PHP parse_berekley_dbs::MIME_PARSE_DB Exemples

Exemple #1

Fichier : exec.squid.stats.mime.parser.php Projet : brucewu16899/1.6.x

function parse()
{
    $TimeFile = "/etc/artica-postfix/pids/exec.squid.stats.mime.parser.php.time";
    $pidfile = "/etc/artica-postfix/pids/exec.squid.stats.mime.parser.php.pid";
    $unix = new unix();
    $pid = $unix->get_pid_from_file($pidfile);
    if ($unix->process_exists($pid, basename(__FILE__))) {
        $timepid = $unix->PROCCESS_TIME_MIN($pid);
        if ($GLOBALS["VERBOSE"]) {
            echo "{$pid} already executed since {$timepid}Mn\n";
        }
        if ($timepid < 14) {
            return;
        }
        $kill = $unix->find_program("kill");
        unix_system_kill_force($pid);
    }
    @file_put_contents($pidfile, getmypid());
    $TimeExec = $unix->file_time_min($TimeFile);
    if (!$GLOBALS["FORCE"]) {
        if ($TimeExec < 20) {
            return;
        }
    }
    @unlink($TimeFile);
    @file_put_contents($TimeFile, time());
    $f = $unix->DirFiles("/var/log/squid", "[0-9]+_mime\\.db");
    $export_path = "/home/artica/squid/dbExport";
    @mkdir($export_path, 0755, true);
    $berekley = new parse_berekley_dbs();
    $q = new mysql_squid_builder();
    while (list($filename, $none) = each($f)) {
        preg_match("#([0-9]+)_#", $filename, $re);
        $xdate = $re[1];
        $xtime = $berekley->TIME_FROM_DAY_INT($xdate);
        echo "{$filename} ( {$xdate} )\n";
        if (date("Y-m-d", $xtime) == date("Y-m-d")) {
            if (!$q->QUERY_SQL($berekley->MIME_PARSE_TABLE_STRING("MIME_RTT"))) {
                continue;
            }
            $q->QUERY_SQL("TRUNCATE TABLE MIME_RTT");
            $array = $berekley->MIME_PARSE_DB("/var/log/squid/{$filename}", $xdate);
            $prefix = $berekley->MIME_PARSE_TABLE_PREFIX("MIME_RTT");
            if (!$array) {
                continue;
            }
            $sql = $prefix . " " . @implode(",", $array);
            $q->QUERY_SQL($sql);
            continue;
        }
        $tablename = date("Ym", $xtime) . "_mime";
        if (!$q->QUERY_SQL($berekley->MIME_PARSE_TABLE_STRING($tablename))) {
            continue;
        }
        $array = $berekley->MIME_PARSE_DB("/var/log/squid/{$filename}", $xdate);
        $prefix = $berekley->MIME_PARSE_TABLE_PREFIX($tablename);
        if (!$array) {
            continue;
        }
        $sql = $prefix . " " . @implode(",", $array);
        $q->QUERY_SQL($sql);
        if (!$q->ok) {
            continue;
        }
        if (!@copy("/var/log/squid/{$filename}", "{$export_path}/{$filename}")) {
            continue;
        }
        @unlink("/var/log/squid/{$filename}");
    }
    @unlink("/usr/share/artica-postfix/ressources/logs/web/TOP_MIME.db");
    $sql = "SELECT SUM(size) as size,mime_type FROM MIME_RTT GROUP BY mime_type ORDER BY size DESC LIMIT 0,15;";
    $results = $q->QUERY_SQL($sql);
    $array = array();
    if (mysql_num_rows($results) > 1) {
        while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
            $ligne["size"] = $ligne["size"] / 1024;
            $ligne["size"] = $ligne["size"] / 1024;
            $ligne["size"] = round($ligne["size"], 2);
            if ($GLOBALS["VERBOSE"]) {
                echo "{$ligne["size"]}MB = {$ligne["mime_type"]}\n";
            }
            if (preg_match("#application\\/(.+)#", $ligne["mime_type"], $re)) {
                $ligne["mime_type"] = $re[1];
            }
            $MAIN[$ligne["mime_type"]] = $ligne["size"];
        }
        @mkdir("/usr/share/artica-postfix/ressources/logs/web", 0755, true);
        @file_put_contents("/usr/share/artica-postfix/ressources/logs/web/TOP_MIME.db", serialize($MAIN));
        @chmod("/usr/share/artica-postfix/ressources/logs/web/TOP_MIME.db", 0755);
    }
    gencache_TOPCACHED();
}