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();
}
}
}
