function ParseDB_FILE($path, $uuid = null, $asmeta = false)
{
$unix = new unix();
if (!is_file($path)) {
return;
}
echo "Open {$path}\n";
$db_con = dba_open($path, "r", "db4");
if (!$db_con) {
if ($asmeta) {
meta_admin_mysql(1, "DB open failed {$path}", null, __FILE__, __LINE__);
}
echo "DB open failed\n";
die;
}
$mainkey = dba_firstkey($db_con);
while ($mainkey != false) {
$val = 0;
$data = unserialize(dba_fetch($mainkey, $db_con));
$mainkey = dba_nextkey($db_con);
if (!is_array($data)) {
continue;
}
$q = new mysql_squid_builder();
$qCommon = new mysql_squid_builder();
if ($uuid != null) {
$q = new mysql_stats($uuid);
}
if ($asmeta) {
$q = new mysql_meta();
}
if (!isset($data["HOURLY"])) {
continue;
}
if (!isset($data["WWW"])) {
continue;
}
$category = null;
$ipaddr = mysql_escape_string2($data["IPADDR"]);
if (isset($data["MAC"])) {
$mac = mysql_escape_string2($data["MAC"]);
}
$uid = mysql_escape_string2($data["UID"]);
$familysite = mysql_escape_string2($data["WWW"]);
if (isset($data["category"])) {
$category = mysql_escape_string2($data["category"]);
}
if ($uid == null) {
$uid = $qCommon->UID_FROM_MAC($data["MAC"]);
}
if ($uid == null) {
$uid = $qCommon->UID_FROM_IP($data["IPADDR"]);
}
$uid = mysql_escape_string2($uid);
$length = strlen($ipaddr) + strlen($mac) + strlen($uid) + strlen($familysite);
if ($length == 0) {
continue;
}
while (list($day, $array) = each($data["HOURLY"])) {
while (list($hour, $size) = each($array)) {
$md5 = md5("'{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}'");
$wwwUH[] = "('{$md5}','{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}')";
if ($GLOBALS["VERBOSE"]) {
echo "('{$md5}','{$ipaddr}','{$mac}','{$uid}','{$familysite}','{$day}','{$hour}','{$size}','{$category}')\n";
}
}
}
}
dba_close($db_con);
$TABLE_WEEK_RTTH = "WEEK_RTTH";
$ENGINE = "MEMORY";
if ($asmeta) {
$TABLE_WEEK_RTTH = "{$uuid}_WEEK_RTTH";
$ENGINE = "MYISAM";
}
if ($asmeta) {
xmeta_events("DROP TABLE `{$TABLE_WEEK_RTTH}`", __FUNCTION__, __FILE__, __LINE__);
}
$q->QUERY_SQL("DROP TABLE `{$TABLE_WEEK_RTTH}`");
if ($asmeta) {
xmeta_events("CREATE TABLE `{$TABLE_WEEK_RTTH}`", __FUNCTION__, __FILE__, __LINE__);
}
$q->QUERY_SQL("CREATE TABLE IF NOT EXISTS `{$TABLE_WEEK_RTTH}` (\n\t\t\t`zmd5` varchar(90) NOT NULL,\n\t\t\t`familysite` varchar(128) NOT NULL,\n\t\t\t`ipaddr` varchar(50) NOT NULL DEFAULT '',\n\t\t\t`day` smallint(2) NOT NULL,\n\t\t\t`hour` smallint(2) NOT NULL,\n\t\t\t`uid` varchar(128) NOT NULL,\n\t\t\t`MAC` varchar(20) NOT NULL,\n\t\t\t`size` BIGINT UNSIGNED NOT NULL,\n\t\t\t`category` varchar(90) NOT NULL,\n\t\t\tPRIMARY KEY `zmd5` (`zmd5`),\n\t\t\tKEY `familysite` (`familysite`),\n\t\t\tKEY `ipaddr` (`ipaddr`),\n\t\t\tKEY `uid` (`uid`),\n\t\t\tKEY `category` (`category`),\n\t\t\tKEY `hour` (`hour`),\n\t\t\tKEY `day` (`day`),\n\t\t\tKEY `MAC` (`MAC`)\n\t) ENGINE={$ENGINE};");
if (!$q->ok) {
if ($asmeta) {
meta_admin_mysql(1, "MySQL error", $q->mysql_error, __FILE__, __LINE__);
}
echo $q->mysql_error;
return;
}
$q->QUERY_SQL("INSERT IGNORE INTO `{$TABLE_WEEK_RTTH}` ( `zmd5`,`ipaddr`,`MAC`,`uid`,familysite,`day`,`hour`,`size`,`category`) VALUES " . @implode(",", $wwwUH));
if (!$q->ok) {
if ($asmeta) {
meta_admin_mysql(1, "MySQL error", $q->mysql_error, __FILE__, __LINE__);
}
echo $q->mysql_error;
return;
}
if ($asmeta) {
xmeta_events("Success parsing {$path} adding " . count($wwwUH) . " elements", __FUNCTION__, __FILE__, __LINE__);
return;
}
$sock = new sockets();
$EnableArticaMetaClient = intval($sock->GET_INFO("EnableArticaMetaClient"));
$EnableSquidRemoteMySQL = intval($sock->GET_INFO("EnableSquidRemoteMySQL"));
if ($EnableSquidRemoteMySQL == 1) {
return;
}
if ($EnableArticaMetaClient == 0) {
return;
}
$DIR_TEMP = $unix->TEMP_DIR();
if (!$unix->compress($path, "{$DIR_TEMP}/SQUID_QUOTASIZE.gz")) {
meta_admin_mysql(1, "Unable to compress {$path}", null, __FILE__, __LINE__);
@unlink("{$DIR_TEMP}/SQUID_QUOTASIZE.gz");
return;
}
$artica_meta = new artica_meta();
if (!$artica_meta->SendFile("{$DIR_TEMP}/SQUID_QUOTASIZE.gz", "SQUID_QUOTASIZE")) {
meta_admin_mysql(1, "Unable to updload {$DIR_TEMP}/SQUID_QUOTASIZE.gz", null, __FILE__, __LINE__);
}
@unlink("{$DIR_TEMP}/SQUID_QUOTASIZE.gz");
}
function parse_meta($path, $uuid)
{
$md_path = md5($path);
$TimeFile = "/etc/artica-postfix/pids/exec.squid.interface-size.php.{$uuid}.{$md_path}.time";
$pidfile = "/etc/artica-postfix/pids/exec.squid.interface-size.php.{$uuid}.{$md_path}.pid";
$unix = new unix();
$pid = @file_get_contents($pidfile);
if ($pid < 100) {
$pid = null;
}
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 < 10) {
xmeta_events("{$pid} already executed since {$timepid}Mn", __FUNCTION__, __FILE__, __LINE__);
return;
}
$kill = $unix->find_program("kill");
unix_system_kill_force($pid);
}
@file_put_contents($pidfile, getmypid());
$time = $unix->file_time_min($TimeFile);
if (!$GLOBALS["VERBOSE"]) {
if ($time < 10) {
xmeta_events("{$time}Mn require at least {$time}", __FUNCTION__, __FILE__, __LINE__);
@unlink($path);
return;
}
}
@unlink($TimeFile);
@file_put_contents($TimeFile, time());
if ($GLOBALS["VERBOSE"]) {
echo "ParseDB_FILE({$path},{$uuid},true)\n";
}
xmeta_events("Parsing {$path}", __FUNCTION__, __FILE__, __LINE__);
ParseDB_FILE($path, $uuid, true);
if ($GLOBALS["VERBOSE"]) {
echo "Remove {$path}\n";
}
@unlink($path);
}
