if (!$fileName) {
if ($alternateFileName) {
$fileName = $alternateFileName;
} else {
echo "Could not find file name for '{$item->title}'.\nSkipping.\n";
usleep(M2VRU_THROTTLE_USLEEP);
continue;
}
} else {
echo "Found {$fileName} for '{$item->title}', updating PreDB table.\n";
}
$item->title = $db->escapeString($item->title);
$item->category = $db->escapeString($item->category);
$item->pubDate = strtotime($item->pubDate);
$fileName = $db->escapeString(preg_replace('#\\..{0,5}$#', '', $fileName));
$db->queryInsert(sprintf("INSERT INTO predb (title, category, predate, filename, source)\n\t\t\t\tVALUES (%s, %s, FROM_UNIXTIME(%d), %s, 'm2v.ru')\n\t\t\t\tON DUPLICATE KEY\n\t\t\t\tUPDATE title = %s, category = %s, predate = FROM_UNIXTIME(%d), filename = %s, source = 'm2v.ru', id = LAST_INSERT_ID(id)", $item->title, $item->category, $item->pubDate, $fileName, $item->title, $item->category, $item->pubDate, $fileName));
$items++;
echo "Sleeping " . M2VRU_THROTTLE_USLEEP . " microseconds to be kind on m2v.ru\n";
usleep(M2VRU_THROTTLE_USLEEP);
}
echo "Updated {$items} rows in PreDB\n";
sleep_printout(M2V_SLEEP_TIME);
}
function sleep_printout($time)
{
$time--;
if (!$time) {
echo "\n";
return;
}
echo "Sleeping {$time} seconds.\r";
