function updateRoom() { require_once PATH_CORE . '/utilities/twitter.php'; $tObj = new Twitter(TWITTER_USER, TWITTER_PWD, $this->db); $resp = $tObj->getRateLimitStatus(); if (isset($resp['error'])) { return false; } /* if ($this->db->queryC("SELECT * FROM MicroAccounts;")===false) { // no accounts yet - so remove all followers $this->resetFriends(true); return; } */ $resp = $tObj->getFriendsTimeline(); $mt = new microPostsTable($this->db); $mp = $mt->getRowObject(); $maTable = new microAccountsTable($this->db); $ma = $maTable->getRowObject(); foreach ($resp as $item) { $mp->statusid = $item['id']; $mp->msg = $item['text']; $mp->sid = $item['user']['id']; $mp->dt = date('Y-m-d H:i:s', $item['created_at']); if ($mt->isDup($mp->statusid) === false) { $mp->insert(); } else { } // update microaccount row for user if (!$ma->isDup($item['user']['id'])) { // to do // in facebook app, these should always exist } else { // get latest image $ma->loadWhere("sid=" . $item['user']['id']); $ma->profile_image_url = $item['user']['profile_image_url']; $ma->update(); } } }