function daily_to_monthly($uuid) { $unix = new unix(); $filetime = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".{$uuid}.time"; if (!$GLOBALS["FORCE"]) { if ($unix->file_time_min($filetime) < 240) { return; } } @unlink($filetime); @file_put_contents($filetime, time()); $q = new mysql_uuid_meta($uuid); $LIST_TABLES_SQUID_DAILY = $q->LIST_TABLES_SQUID_DAILY(); meta_events(count($LIST_TABLES_SQUID_DAILY) . " Daily tables..."); $CurrentTable = "squid_daily_" . date("Ymd"); if ($GLOBALS["VERBOSE"]) { echo "CURRENT TABLE = {$CurrentTable}\n"; } while (list($tablename, $rows) = each($LIST_TABLES_SQUID_DAILY)) { if ($GLOBALS["VERBOSE"]) { echo "CURRENT TABLE = {$CurrentTable} <> {$tablename}\n"; } if ($tablename == $CurrentTable) { continue; } if (!_daily_to_monthly($tablename, $uuid)) { continue; } $q->QUERY_SQL("DROP TABLE `{$tablename}`"); } }