function hourly_to_daily($uuid) { $unix = new unix(); $filetime = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".{$uuid}.time"; if ($unix->file_time_min($filetime) < 60) { return; } @unlink($filetime); @file_put_contents($filetime, time()); $q = new mysql_uuid_meta($uuid); $LIST_TABLES_SQUID_HOURLY = $q->LIST_TABLES_SQUID_HOURLY(); $CurrentTable = "squid_hourly_" . date("YmdH"); if ($GLOBALS["VERBOSE"]) { echo "CURRENT TABLE = {$CurrentTable}\n"; } while (list($tablename, $rows) = each($LIST_TABLES_SQUID_HOURLY)) { if ($GLOBALS["VERBOSE"]) { echo "CURRENT TABLE = {$CurrentTable} <> {$tablename}\n"; } if ($tablename == $CurrentTable) { continue; } if (!_hourly_to_daily($tablename, $uuid)) { continue; } $q->QUERY_SQL("DROP TABLE `{$tablename}`"); } }