function meta_stats_day_comprime($tablename) { $q = new mysql_meta(); $sql = "SELECT DATE_FORMAT(zDate,'%Y-%m-%d %H:00:00') as zDate,DATE_FORMAT(zDate,'%Y%m%d') as suffix,\n\tCOUNT(zmd5) as hits,SUM(size) as size,uuid \n\tFROM `{$tablename}` GROUP BY `uuid`,DATE_FORMAT(zDate,'%Y-%m-%d %H:00:00'),DATE_FORMAT(zDate,'%Y%m%d')"; $results = $q->QUERY_SQL($sql); if (!$q->ok) { return false; } while ($ligne = mysql_fetch_assoc($results)) { $zmd5 = md5(serialize($ligne)); $table = "metastats_sized_" . $ligne["suffix"]; $f[$table][] = "('{$zmd5}','{$ligne["zDate"]}','{$ligne["uuid"]}','{$ligne["hits"]}','{$ligne["size"]}')"; } while (list($tablename, $rows) = each($f)) { if (count($rows) == 0) { if ($GLOBALS["VERBOSE"]) { echo "{$tablename} 0 rows\n"; } continue; } if ($GLOBALS["VERBOSE"]) { echo "{$tablename} " . count($rows) . "\n"; } if (!$q->create_table_meta_stats_size_day($tablename)) { return; } $sql = "INSERT IGNORE INTO `{$tablename}` (`zmd5`,`zDate`,`uuid`,`hits`,`size`) VALUES " . @implode(",", $rows); $q->QUERY_SQL($sql); if (!$q->ok) { meta_events($q->mysql_error); return false; } } return true; }