function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $mintime = strtotime("2008-01-01 00:00:00");
    $params["TO"] = intval($params["TO"]);
    $params["FROM"] = abs(intval($params["FROM"]));
    if ($params["FROM"] < $mintime) {
        $params["FROM"] = strtotime(date("Y-m-d 00:00:00"));
    }
    $params["TO"] = intval($params["TO"]);
    if ($params["TO"] < $mintime) {
        $params["TO"] = time();
    }
    $influx = new influx();
    $to = InfluxQueryFromUTC($params["TO"]);
    $from = InfluxQueryFromUTC($params["FROM"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
        return false;
    }
    $q = new postgres_sql();
    $q->QUERY_SQL("COPY (SELECT * from \"{$md5}report\") To '/tmp/{$md5}report.csv' with CSV HEADER;");
    $values_size = @filesize("/tmp/{$md5}report.csv");
    $values = mysql_escape_string2(@file_get_contents("/tmp/{$md5}report.csv"));
    echo "MD5:{$GLOBALS["zMD5"]} {$values_size}Bytes " . FormatBytes($values_size / 1024) . "\n";
    $q = new mysql_squid_builder();
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$values}',`values_size`='{$values_size}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("PostGreSQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $from = InfluxQueryFromUTC($params["FROM"]);
    $to = InfluxQueryFromUTC($params["TO"]);
    $interval = $params["INTERVAL"];
    $md5_table = $md5;
    $searchsites_sql = null;
    $USER_FIELD = $params["USER"];
    $SEARCH = $params["SEARCH"];
    if ($SEARCH != null) {
        $searchuser_sql = str_replace("*", "%", $SEARCH);
        if (strpos(" {$SEARCH}", "%") > 0) {
            $searchuser_sql = " HAVING {$USER_FIELD} LIKE '{$SEARCH}'";
        } else {
            $searchuser_sql = " HAVING `{$USER_FIELD}`='{$SEARCH}'";
        }
    }
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
        return;
    }
    $q = new mysql_squid_builder();
    //zDate,familysite,user,size,hits
    $sql = "SELECT SUM(SIZE) as SIZE, SUM(RQS) as RQS,{$USER_FIELD},`ZDATE` FROM `tmp_{$md5}user` \n\tGROUP BY {$USER_FIELD},`ZDATE` {$searchuser_sql} ORDER BY `ZDATE`";
    echo "********** SQL **********\n";
    echo $sql . "\n";
    echo "********** SQL **********\n";
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo "{$sql}\n{$q->mysql_error}\n";
        build_progress("MySQL error [" . __LINE__ . "]", 110);
        return;
    }
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $time = $ligne["ZDATE"];
        $c++;
        if (intval($ligne["SIZE"]) == 0) {
            continue;
        }
        $size = $ligne["SIZE"] / 1024;
        $size = round($size / 1024, 2);
        $xdata[] = $ligne["ZDATE"];
        $ydata[] = $size;
    }
    echo "Building chronology\n";
    $sql = "SELECT SUM(SIZE) as SIZE, SUM(RQS) as RQS,`ZDATE`,FAMILYSITE,{$USER_FIELD}\n\tFROM `tmp_{$md5}user` GROUP BY FAMILYSITE,{$USER_FIELD},ZDATE {$searchuser_sql} ORDER BY ZDATE";
    echo "********** SQL **********\n";
    echo $sql . "\n";
    echo "********** SQL **********\n";
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo "{$sql}\n{$q->mysql_error}\n";
        build_progress("MySQL error [" . __LINE__ . "]", 110);
        return;
    }
    $c = 0;
    $MAIN["CSV"][] = array("time", "bytes", "site", "hits");
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $c++;
        $time = $ligne["ZDATE"];
        if ($GLOBALS["VERBOSE"]) {
            echo "CHRONOS: {$ligne["FAMILYSITE"]} {$time}'\n";
        }
        $MAIN["CRONOS"][] = array("TIME" => $time, "BYTES" => $ligne["SIZE"], "SITE" => $ligne["FAMILYSITE"], "RQS" => $ligne["RQS"]);
        $MAIN["CSV"][] = array("{$time}", "{$ligne["SIZE"]}", "{$ligne["FAMILYSITE"]}", "{$ligne["RQS"]}");
    }
    $MAIN["GRAPH1"]["xdata"] = $xdata;
    $MAIN["GRAPH1"]["ydata"] = $ydata;
    if ($c == 0) {
        build_progress("{chronology}: {failed} C == 0", 110);
        return;
    }
    //----------------------------------------------------------------------------------------------------------
    $results = $q->QUERY_SQL("SELECT USERID as uid,IPADDR as ipaddr,MAC as mac FROM `tmp_{$md5}user` GROUP BY uid,ipaddr,mac");
    build_progress("{parsing_data} (2)", 25);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $IDENT[] = array("IPADDR" => $ligne["ipaddr"], "USERID" => $ligne["uid"], "MAC" => $ligne["mac"]);
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(SIZE) as SIZE,FAMILYSITE,{$USER_FIELD} FROM `tmp_{$md5}user` \n\tGROUP BY FAMILYSITE,{$USER_FIELD} {$searchuser_sql} ORDER BY SIZE DESC";
    echo "********** SQL **********\n";
    echo $sql . "\n";
    echo "********** SQL **********\n";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 30);
    if (!$q->ok) {
        echo "{$sql}\n{$q->mysql_error}\n";
        build_progress("MySQL error [" . __LINE__ . "]", 110);
        return;
    }
    $tt = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["SIZE"];
        $FAMILYSITE = $ligne["FAMILYSITE"];
        $size = $size / 1024;
        $PieData2[$FAMILYSITE] = $size;
        if ($GLOBALS["VERBOSE"]) {
            echo "PIE DATA: {$FAMILYSITE}' -> {$size}\n";
        }
        if ($tt < 11) {
            $MAIN["GRAPH2"]["PIEDATA"][$FAMILYSITE] = $size;
            $MAIN["GRAPH2"]["TABLE"][$FAMILYSITE] = $size;
        }
        $tt++;
        $MAIN["FAMS"][$FAMILYSITE] = $ligne["SIZE"];
    }
    //----------------------------------------------------------------------------------------------------------
    echo "MD5:{$GLOBALS["zMD5"]}\n";
    REMOVE_TABLES($GLOBALS["zMD5"]);
    $encoded_data = base64_encode(serialize($MAIN));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $to = InfluxQueryFromUTC($params["TO"]);
    $from = InfluxQueryFromUTC($params["FROM"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
    }
    $q = new mysql_squid_builder();
    $per["10m"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1h"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1d"] = "DATE_FORMAT(zDate,'%m-%d') as tdate";
    $per["1w"] = "DATE_FORMAT(zDate,'%U') as tdate";
    $per["30d"] = "DATE_FORMAT(zDate,'%m') as tdate";
    $datformat = $per[$interval];
    $results = $q->QUERY_SQL("SELECT user,size FROM `{$md5}user` ORDER BY size DESC");
    build_progress("{parsing_data} (2)", 25);
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $USER = $ligne["user"];
        $SIZE = $ligne["size"];
        $BIGDATA[$USER] = $SIZE;
        $c++;
    }
    build_progress("{$c} {rows}", 8);
    echo "{$c} rows....\n";
    REMOVE_TABLES($md5);
    $encoded_data = base64_encode(serialize($BIGDATA));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function xsFLOW($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $from = InfluxQueryFromUTC($params["FROM"]);
    $to = InfluxQueryFromUTC($params["TO"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
    }
    $q = new mysql_squid_builder();
    $per["10m"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1h"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1d"] = "DATE_FORMAT(zDate,'%m-%d') as tdate";
    $per["1w"] = "DATE_FORMAT(zDate,'%U') as tdate";
    $per["30d"] = "DATE_FORMAT(zDate,'%m') as tdate";
    $datformat = $per[$interval];
    $sql = "SELECT SUM(size) as size,{$datformat} FROM `{$md5}sites` GROUP BY tdate ORDER BY tdate";
    echo "{$sql}\n";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 25);
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["size"] / 1024;
        $size = round($size / 1024);
        if ($GLOBALS["VERBOSE"]) {
            echo "{$ligne["tdate"]} = {$size}MB\n";
        }
        if ($size == 0) {
            continue;
        }
        $c++;
        $xdata[] = $ligne["tdate"];
        $ydata[] = $size;
    }
    build_progress("{$c} {rows}", 8);
    echo "{$c} rows....\n";
    if (count($xdata) < 2) {
        $q->QUERY_SQL("DROP TABLE `{$md5}sites`");
        build_progress("{$c} {rows} ({only})", 110);
        REMOVE_TABLES($md5);
        return;
    }
    $time = time();
    $MAIN["GRAPH1"]["xdata"] = $xdata;
    $MAIN["GRAPH1"]["ydata"] = $ydata;
    $xdata = array();
    $ydata = array();
    $sql = "SELECT SUM(size) as size,familysite FROM `{$md5}sites` GROUP BY familysite ORDER BY size DESC LIMIT 0,10";
    echo "{$sql}\n";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 30);
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["size"];
        $FAMILYSITE = $ligne["familysite"];
        $PieData2[$FAMILYSITE] = $size;
        $size = $size / 1024;
        $size = round($size / 1024, 2);
        $PieData[$FAMILYSITE] = $size;
        $c++;
    }
    $MAIN["GRAPH2"]["PIEDATA"] = $PieData;
    $MAIN["GRAPH2"]["TABLE"] = $PieData2;
    build_progress("{saving}", 50);
    if ($GLOBALS["zMD5"] == null) {
        build_progress("MD5 - > NULL {failed}", 110);
        return;
    }
    build_progress("{$c} {rows}", 60);
    build_progress("{building_query} {$user} (3)", 70);
    $results = $q->QUERY_SQL("SELECT user,size FROM `{$md5}users` ORDER BY size DESC LIMIT 0,20");
    build_progress("{parsing_data} {$user} (3)", 90);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["size"];
        $FAMILYSITE = $ligne["user"];
        $PieData4[$FAMILYSITE] = $size;
        $size = $size / 1024;
        $size = round($size / 1024, 2);
        $PieData3[$FAMILYSITE] = $size;
    }
    $MAIN["GRAPH3"]["PIEDATA"] = $PieData3;
    $MAIN["GRAPH3"]["TABLE"] = $PieData4;
    $MAIN["GRAPH3"]["TYPE"] = $user;
    $MAIN["CSV1"] = $GLOBALS["CSV1"];
    $MAIN["CSV2"] = $GLOBALS["CSV2"];
    echo "MD5:{$GLOBALS["zMD5"]}\n";
    REMOVE_TABLES($md5);
    $encoded_data = base64_encode(serialize($MAIN));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $from = InfluxQueryFromUTC($params["FROM"]);
    $to = InfluxQueryFromUTC($params["TO"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
        return;
    }
    $q = new mysql_squid_builder();
    $per["10m"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1h"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1d"] = "DATE_FORMAT(zDate,'%m-%d') as tdate";
    $per["1w"] = "DATE_FORMAT(zDate,'%U') as tdate";
    $per["30d"] = "DATE_FORMAT(zDate,'%m') as tdate";
    $datformat = $per[$interval];
    //----------------------------------------------------------------------------------------------------------
    $results = $q->QUERY_SQL("SELECT SUM(size) as size,familysite FROM `{$md5}user` GROUP BY familysite ORDER BY size DESC LIMIT 0,10");
    build_progress("{parsing_data} (2)", 25);
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["size"];
        $size = round($size / 1024);
        $c++;
        $FAMILYSITE = $ligne["familysite"];
        $TOP_WEBSITES_SIZE[$FAMILYSITE] = $size;
    }
    build_progress("{$c} {rows}", 30);
    //----------------------------------------------------------------------------------------------------------
    $results = $q->QUERY_SQL("SELECT SUM(hits) as hits,familysite FROM `{$md5}user` GROUP BY familysite ORDER BY hits DESC LIMIT 0,10");
    build_progress("{parsing_data} (2)", 25);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $hits = $ligne["hits"];
        $FAMILYSITE = $ligne["familysite"];
        $TOP_WEBSITES_HITS[$FAMILYSITE] = $hits;
    }
    //----------------------------------------------------------------------------------------------------------
    $results = $q->QUERY_SQL("SELECT SUM(size) as size,{$user} FROM `{$md5}user` GROUP BY {$user} ORDER BY size DESC LIMIT 0,10");
    build_progress("{parsing_data} (2)", 25);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $size = $ligne["size"];
        $size = round($size / 1024);
        $USER = $ligne[$user];
        echo "USER: {$USER} (" . FormatBytes($size) . ")\n";
        $TOP_WEBSITES_MEMBERS[$USER] = $size;
    }
    //----------------------------------------------------------------------------------------------------------
    $MAIN["CSV"] = $GLOBALS["CSV1"];
    $MAIN["TOP_WEBSITES_SIZE"] = $TOP_WEBSITES_SIZE;
    $MAIN["TOP_WEBSITES_MEMBERS"] = $TOP_WEBSITES_MEMBERS;
    $MAIN["TOP_WEBSITES_HITS"] = $TOP_WEBSITES_HITS;
    echo "MD5:{$GLOBALS["zMD5"]}\n";
    REMOVE_TABLES($GLOBALS["zMD5"]);
    $encoded_data = base64_encode(serialize($MAIN));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $from = InfluxQueryFromUTC($params["FROM"]);
    $to = InfluxQueryFromUTC($params["TO"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
        return;
    }
    $q = new mysql_squid_builder();
    $per["10m"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1h"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1d"] = "DATE_FORMAT(zDate,'%m-%d') as tdate";
    $per["1w"] = "DATE_FORMAT(zDate,'%U') as tdate";
    $per["30d"] = "DATE_FORMAT(zDate,'%m') as tdate";
    $datformat = $per[$interval];
    $md5_table = "`{$md5}user`";
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(hits) as hits,UID,CLIENT FROM {$md5_table} GROUP BY UID,CLIENT ORDER by hits DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 15);
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $c++;
        $MAIN["GRAPH1"][$ligne["UID"] . "/" . $ligne["CLIENT"]] = $ligne["hits"];
    }
    build_progress("{$c} {rows}", 30);
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(hits) as hits,CATEGORY FROM {$md5_table} GROUP BY CATEGORY ORDER by hits DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 15);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $MAIN["GRAPH2"][$ligne["CATEGORY"]] = $ligne["hits"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(hits) as hits,RULENAME FROM {$md5_table} GROUP BY RULENAME ORDER by hits DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 15);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $MAIN["GRAPH3"][$ligne["RULENAME"]] = $ligne["hits"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(hits) as hits,WEBSITE FROM {$md5_table} GROUP BY WEBSITE ORDER by hits DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data} (2)", 15);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $MAIN["GRAPH4"][$ligne["WEBSITE"]] = $ligne["hits"];
    }
    //----------------------------------------------------------------------------------------------------------
    $MAIN["csv"] = $GLOBALS["CSV1"];
    echo "MD5:{$GLOBALS["zMD5"]}\n";
    REMOVE_TABLES($GLOBALS["zMD5"]);
    $encoded_data = base64_encode(serialize($MAIN));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}
function BUILD_REPORT($md5)
{
    build_progress("{building_query}", 5);
    $unix = new unix();
    $q = new mysql_squid_builder();
    $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reports_cache WHERE `zmd5`='{$md5}'"));
    $params = unserialize($ligne["params"]);
    $influx = new influx();
    $from = InfluxQueryFromUTC($params["FROM"]);
    $to = InfluxQueryFromUTC($params["TO"]);
    $interval = $params["INTERVAL"];
    $user = $params["USER"];
    $md5_table = $md5;
    if (!GRAB_DATAS($ligne, $md5)) {
        build_progress("{unable_to_query_to_bigdata}", 110);
        return;
    }
    $q = new mysql_squid_builder();
    $per["10m"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1h"] = "DATE_FORMAT(zDate,'%m-%d %Hh') as tdate";
    $per["1d"] = "DATE_FORMAT(zDate,'%m-%d') as tdate";
    $per["1w"] = "DATE_FORMAT(zDate,'%U') as tdate";
    $per["30d"] = "DATE_FORMAT(zDate,'%m') as tdate";
    $datformat = $per[$interval];
    $md5_table = "`{$md5}user`";
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT {$datformat},SUM(size) as size FROM {$md5_table} GROUP BY tdate ORDER by tdate";
    build_progress("{parsing_data} (1)", 7);
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("{parsing_data} (1) {failed}", 110);
        REMOVE_TABLES($md5);
        die;
    }
    $c = 0;
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $ligne["size"] = round($ligne["size"] / 1024);
        $MAIN["GRAPH0"]["ydata"][] = $ligne["size"];
        $MAIN["GRAPH0"]["xdata"][] = $ligne["tdate"];
        $c++;
    }
    build_progress("{$c} {rows}", 30);
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT {$datformat},SUM(hits) as hits FROM {$md5_table} GROUP BY zdate ORDER by tdate";
    build_progress("{parsing_data}", 35);
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("{parsing_data} {failed}", 110);
        REMOVE_TABLES($md5);
        die;
    }
    if (mysql_num_rows($results) == 0) {
        build_progress("{parsing_data} {no_data}", 7);
        echo $sql . "\n";
        sleep(10);
        REMOVE_TABLES($md5);
        build_progress("{parsing_data} {failed}", 110);
    }
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $MAIN["GRAPH1"]["ydata"][] = $ligne["hits"];
        $MAIN["GRAPH1"]["xdata"][] = $ligne["tdate"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(size) as size,familysite FROM {$md5_table} GROUP BY familysite ORDER by size DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("{parsing_data} {failed}", 110);
        REMOVE_TABLES($md5);
        die;
    }
    if (mysql_num_rows($results) == 0) {
        build_progress("{parsing_data} {no_data}", 7);
        echo $sql . "\n";
        sleep(10);
        REMOVE_TABLES($md5);
        build_progress("{parsing_data} {failed}", 110);
    }
    build_progress("{parsing_data}", 40);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $ligne["size"] = round($ligne["size"] / 1024);
        $MAIN["GRAPH2"][$ligne["familysite"]] = $ligne["size"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(size) as size,{$user} FROM {$md5_table} GROUP BY {$user} ORDER by size DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("{parsing_data} {failed}", 110);
        REMOVE_TABLES($md5);
        die;
    }
    if (mysql_num_rows($results) == 0) {
        build_progress("{parsing_data} {no_data}", 7);
        echo $sql . "\n";
        sleep(10);
        REMOVE_TABLES($md5);
        build_progress("{parsing_data} {failed}", 110);
    }
    build_progress("{parsing_data}", 45);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $ligne["size"] = round($ligne["size"] / 1024);
        $MAIN["GRAPH3"][$ligne[$user]] = $ligne["size"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(hits) as hits,category FROM {$md5_table} GROUP BY category ORDER by hits DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data}", 50);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $category = $ligne["category"];
        if ($category == null) {
            $category = "unknown";
        }
        $MAIN["GRAPH4"][$category] = $ligne["hits"];
    }
    //----------------------------------------------------------------------------------------------------------
    $sql = "SELECT SUM(size) as size,category FROM {$md5_table} GROUP BY category ORDER by size DESC LIMIT 0,15";
    $results = $q->QUERY_SQL($sql);
    build_progress("{parsing_data}", 55);
    while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
        $category = $ligne["category"];
        $ligne["size"] = $ligne["size"] / 1024;
        if ($category == null) {
            $category = "unknown";
        }
        $MAIN["GRAPH5"][$category] = $ligne["size"];
    }
    //----------------------------------------------------------------------------------------------------------
    $MAIN["csv"] = $GLOBALS["CSV1"];
    echo "MD5:{$GLOBALS["zMD5"]}\n";
    REMOVE_TABLES($GLOBALS["zMD5"]);
    $encoded_data = base64_encode(serialize($MAIN));
    $datasize = strlen($encoded_data);
    echo "Saving " . strlen($encoded_data) . " bytes...\n";
    $q->QUERY_SQL("UPDATE reports_cache SET `builded`=1,`values`='{$encoded_data}',`values_size`='{$datasize}' WHERE `zmd5`='{$GLOBALS["zMD5"]}'");
    if (!$q->ok) {
        echo $q->mysql_error . "\n";
        build_progress("MySQL {failed}", 110);
        return;
    }
    build_progress("{success}", 100);
}