root/buddyloo/files/lib/system/cronjob/BuddylooSocialCleanupCronjob.class.php @ 1285

<?php
require_once(WCF_DIR.'lib/data/cronjobs/Cronjob.class.php');

/**
 * cleans up empty social pages
 * 
 * @author      Torben Brodt
 * @package     de.easy-coding.wcf.buddyloo
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class BuddylooSocialCleanupCronjob implements Cronjob {
        
        /**
         * @see Cronjob::execute()
         */
        public function execute($data) {
                // (1)
                $sql = "DELETE FROM a USING wcf1_buddyloo_social a LEFT JOIN wcf1_buddyloo_gadget_to_social b USING(socialID) WHERE ISNULL(b.socialID);";
                WCF::getDB()->sendQuery($sql);

                // (2)
                $sql = "DELETE FROM a USING wcf1_buddyloo_user_to_social a LEFT JOIN wcf1_buddyloo_social b USING(socialID) WHERE ISNULL(b.socialID);";
                WCF::getDB()->sendQuery($sql);

                // (3)
                $sql = "UPDATE wcf1_user a, (
                                SELECT a.userid FROM wcf1_user a LEFT JOIN wcf1_buddyloo_social b USING(socialID) WHERE a.socialID > 0 AND ISNULL(b.socialID)
                        ) b
                        SET socialID = 0
                        WHERE a.userID = b.userID;";
                WCF::getDB()->sendQuery($sql);
        }
}
?>