function youtube_all_from_hourtable($tablename)
{
$q = new mysql_squid_builder();
$sql = "SELECT SUM(hits) as hits,zDate,uid,youtubeid,MAC \n\tFROM `{$tablename}` \n\tGROUP BY zDate,uid,youtubeid,MAC";
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
if ($GLOBALS["VERBOSE"]) {
echo "############# ERROR #########\n{$q->mysql_error}\\Line:" . __LINE__ . "\n#############\n";
}
return;
}
if (mysql_num_rows($results) == 0) {
if ($GLOBALS["VERBOSE"]) {
echo "No results...\n";
}
return true;
}
$prefix = "INSERT IGNORE INTO `youtube_all` (zmd5,hits,zDate,uid,MAC,youtubeid,category) VALUES ";
$youtube = new YoutubeStats();
if ($GLOBALS["VERBOSE"]) {
echo mysql_num_rows($results) . " results...\n";
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$md5 = md5(serialize($ligne));
$ligne["uid"] = mysql_escape_string2($ligne["uid"]);
$category = mysql_escape_string2($youtube->youtube_category($ligne["youtubeid"]));
$f[] = "('{$md5}','{$ligne["hits"]}','{$ligne["zDate"]}','{$ligne["uid"]}','{$ligne["MAC"]}','{$ligne["youtubeid"]}','{$category}')";
if (count($f) > 500) {
$q->QUERY_SQL($prefix . @implode(",", $f));
$f = array();
if (!$q->ok) {
return false;
}
}
}
if (count($f) > 0) {
$q->QUERY_SQL($prefix . @implode(",", $f));
$f = array();
if (!$q->ok) {
return false;
}
}
return true;
}
