Changeset 1335

Timestamp:

03/20/11 12:02:41 (2 years ago)

Author:

Torben Brodt

Message:

automatically add feeds for twitter system user

Files:

• twitter/files/lib/system/cronjob/TwitterUpdateJob.class.php (modified) (1 diff)

twitter/files/lib/system/cronjob/TwitterUpdateJob.class.php

@@ -22 +22 @@
                         WHERE           ti.failcount < 5";
                 $result = WCF::getDB()->sendQuery($sql);
+                $i = 0;
                 while ($row = WCF::getDB()->fetchArray($result)) {
                         $this->load($row);
+                        $i++;
                 }
+
+                // try to active system user feeds
+                if($i == 0) {
+                        $user = $this->getSystemUser();
+                        if($user) {
+                                $sql = "INSERT INTO
+                                                        wcf".WCF_N."_twitter_feed
+                                                        (accountID, action)
+                                        VALUES          (".intval($user['accountID']).", 'user_timeline'),
+                                                        (".intval($user['accountID']).", 'mentions')
+                                        ON DUPLICATE KEY UPDATE
+                                                        failcount = IF(failcount > 1, failcount - 1, 0)";
+                                $result = WCF::getDB()->sendQuery($sql);
+                        }
+                }
+        }
+
+        protected function getSystemUser() {
+                $sql = "SELECT          *
+                        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);
         }