Esempi in PHP per mysql_uuid_meta::LIST_TABLES_SQUID_DAILY

Esempio n. 1

File: exec.artica-meta-squid-parser.php Progetto: BillTheBest/1.6.x

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}`");
    }
}