root/twitter/files/lib/system/cronjob/TwitterUpdateJob.class.php @ 1303

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

/**
 * query twitter retweets
 * 
 * @author      Torben Brodt
 * @package     de.easy-coding.wcf.twitter
 * @license     GNU General Public License <http://opensource.org/licenses/gpl-3.0.html>
 */
class TwitterUpdateJob implements Cronjob {
        
        /**
         * @see Cronjob::execute()
         */
        public function execute($data) {
                $system_user = $this->getSystemUser();

                // no system user yet?
                if(!$system_user) {
                        return;
                }
        
                $twitter = Twitter::getInstance();
                
                /*
                        http://api.twitter.com/version/statuses/user_timeline.format
                         * since_id
                         * count
                         * trim_user

                        http://api.twitter.com/version/statuses/mentions.format
                         * since_id
                         * count
                         * trim_user
                         
                        @return
                         * text
                         * id
                */
        }
        
        protected function getSystemUser() {
                $sql = "SELECT          utt.*
                        FROM            wcf".WCF_N."_twitter_account ta
                        INNER JOIN      wcf".WCF_N."_user_to_twitter utt ON utt.accountID = ta.accountID
                        WHERE           ta.screen_name = '".escapeString(TWITTER_USER)."'";
                return WCF::getDB()->getFirstRow($sql);
        }
}
?>