public static function getLatestTitle($board)
{
if (!array_key_exists($board, self::$_latest_cache)) {
self::$_latest_cache[$board] = TitleHistory::search(array('board' => $board))->max('time');
}
return self::$_latest_cache[$board];
}
}
$month_start = mktime(0, 0, 0, date('m', $min_time), 1, date('Y', $min_time));
$month_end = strtotime('+1 month', $month_start);
$filename = 'ptthot-' . date('Ym', $month_start) . '.csv.gz';
$temp = tmpfile();
$meta_data = stream_get_meta_data($temp);
$tmp_filename = $meta_data['uri'];
$stream = gzopen($tmp_filename, 'w');
fwrite($stream, "#board,timestamp,count\n");
foreach (RankData::search("`time` >= {$month_start} AND `time` < {$month_end}")->order(array('board', 'time'))->volumemode(10000) as $rankdata) {
$last_time = max($last_time, $rankdata->time);
fwrite($stream, "{$rankdata->board},{$rankdata->time},{$rankdata->count}\n");
}
fclose($stream);
DropboxLib::putFile($tmp_filename, $filename);
fclose($temp);
KeyValue::set('snapshot_at', $last_time);
}
//dump titlehistory
$filename = 'ptthot-title.csv.gz';
$temp = tmpfile();
$meta_data = stream_get_meta_data($temp);
$tmp_filename = $meta_data['uri'];
$stream = gzopen($tmp_filename, 'w');
fwrite($stream, "#board,timestamp,title\n");
foreach (TitleHistory::search(1)->order(array("board", "title"))->volumemode(10000) as $titlehistory) {
fputcsv($stream, array($titlehistory->board, $titlehistory->time, $titlehistory->title));
}
fclose($stream);
DropboxLib::putFile($tmp_filename, $filename);
fclose($temp);