public function execute($parameters, $db)
{
$url = "https://twitter.com/eve_kill/status/";
$storageName = "twitterLatestRepliesID";
$latest = $db->queryField("SELECT contents FROM zz_storage WHERE locker = '{$storageName}'", "contents", array(), 0);
if ($latest == null) {
$latest = 0;
}
$maxID = $latest;
$twitter = Twit::getMessages(25);
$messages = array();
foreach ($twitter as $status) {
$text = (array) $status->text;
$createdAt = (array) $status->created_at;
$postedBy = (array) $status->user->name;
$screenName = (array) $status->user->screen_name;
$id = (int) $status->id;
if ($id <= $latest) {
continue;
}
$maxID = max($id, $maxID);
$message = array("message" => $text[0], "postedAt" => $createdAt[0], "postedBy" => $postedBy[0], "screenName" => $screenName[0], "url" => $url . $id[0]);
$url = "https://twitter.com/" . $screenName[0] . "/status/" . $id;
$msg = "|g|@|n|" . $screenName[0] . " (|g|" . $message["postedBy"] . "|n|) |g|/|n| " . date("H:i:s", strtotime($message["postedAt"])) . " |g|/|n| " . Twit::shortenUrl($url) . " |g|/|n| |g|" . $message["message"];
//$msg = "Twitter: ($id) |g|" . $message["postedBy"] . "|n| (|g|@". $screenName[0] ."|n|) / |g|" . date("Y-m-d H:i:s", strtotime($message["postedAt"])) . " Message:|n| " . $message["message"];
$messages[$id] = $msg;
}
ksort($messages);
foreach ($messages as $id => $msg) {
Log::irc($msg, "");
}
if (sizeof($twitter)) {
$db->execute("INSERT INTO zz_storage (contents, locker) VALUES (:contents, :locker) ON DUPLICATE KEY UPDATE contents = :contents", array(":locker" => $storageName, ":contents" => $maxID));
}
}
