$now = gettimeofday(true);
$yesterday = $now - $one_day;
$two_days_ago = $now - 2 * $one_day;
$user_id = 44;
$z_name = "tweets";
$z_obj = $z_name . ":" . $user_id;
$mysql_archive_table = $z_name . "_archive";
$temp_mysql_table = "user_" . gmdate("M_d_Y", time());
$drop = @$_GET['drop'];
if ($drop) {
$redisql->del($z_obj);
try {
$redisql->dropTable($temp_mysql_table);
} catch (Exception $e) {
}
$redisql->m_query("delete from {$mysql_archive_table};");
}
populate_tweets($redisql, $z_name, $user_id, $yesterday, $two_days_ago, 0);
$zset_cache = new Zset_Cache($redisql);
$zset_cache->archive($z_name, $user_id, $two_days_ago, $yesterday);
$display_archive_query = "select * from {$mysql_archive_table} order by score";
$result = $redisql->m_query($display_archive_query);
echo "<br/>";
echo "MYSQL ARCHIVE TABLE<br/>";
while ($row = $redisql->m_fetch_assoc($result)) {
echo " " . "DATE: <strong>" . $row['score'] . "</strong> " . "TWEET: <strong>" . $row['tweets'] . "</strong><br/>";
}
$redisql->m_free_result($result);
$redisql->zremrangebyscore($z_obj, -1, $yesterday);
echo "<br/>";
echo "REDIS ZSET POST ARCHIVING<br/>";
