function cyrus_imap_conx($service, $hostname, $ip, $user) { $time = time(); events("{$service}-connection: {$hostname} - > {$ip}"); $fam = new familysite(); if ($hostname == null) { $hostname = $fam->GetComputerName($ip); } $curdate = date("YmdH"); $tablename = "{$curdate}_hcnx"; $zDate = date("Y-m-d H:i:s"); $GLOBALS["CLASS_POSTFIX_SQL"]->postfix_buildhour_connections(); $domain = $fam->GetFamilySites($hostname); $zmd5 = md5("{$time}{$hostname}{$ip}"); $tablename = "{$curdate}_hmbx"; $sql = "INSERT IGNORE INTO `{$tablename}` (`zmd5`,`zDate`,`mbx_service`,`hostname`,`ipaddr`,`uid`,`imap_server`,`domain`)\n\tVALUES('{$zmd5}','{$zDate}','{$service}','{$hostname}','{$ip}','{$user}','{$GLOBALS["MYHOSTNAME"]}','{$domain}')"; $GLOBALS["CLASS_POSTFIX_SQL"]->QUERY_SQL($sql); }
function Postfix_Addconnection($hostname = null, $ip = null) { $time = time(); events("Addconnection: {$hostname} - > {$ip}"); $fam = new familysite(); if ($hostname == null) { $hostname = $fam->GetComputerName($ip); } $curdate = date("YmdH"); $tablename = "{$curdate}_hcnx"; $zDate = date("Y-m-d H:i:s"); $GLOBALS["CLASS_POSTFIX_SQL"]->postfix_buildhour_connections(); $domain = $fam->GetFamilySites($hostname); $zmd5 = md5("{$time}{$hostname}{$ip}"); $sql = "INSERT IGNORE INTO {$tablename} (`zmd5`,`zDate`,`hostname`,`domain`,`ipaddr`) VALUES ('{$zmd5}','{$zDate}','{$hostname}','{$domain}','{$ip}')"; events("Addconnection: QUERY_SQL"); $GLOBALS["CLASS_POSTFIX_SQL"]->QUERY_SQL($sql); }
function STATS_CNX_ACCEPT_parse($path) { if ($GLOBALS["VERBOSE"]) { echo "Parsing {$path}\n"; } $db_con = dba_open($path, "r", "db4"); if (!$db_con) { echo "DB open {$path} failed\n"; return false; } $fam = new familysite(); $SQL1 = array(); $mainkey = dba_firstkey($db_con); while ($mainkey != false) { $data = dba_fetch($mainkey, $db_con); $ARRAY = unserialize($data); if ($ARRAY["IPADDR"] == "127.0.0.1") { $mainkey = dba_nextkey($db_con); continue; } $zmd5 = md5($data); if ($ARRAY["HOSTNAME"] == null) { $ARRAY["HOSTNAME"] = $fam->GetComputerName($ARRAY["IPADDR"]); } $familysite = $fam->GetFamilySites($ARRAY["HOSTNAME"]); $SQL1[date("YmdH", $ARRAY["TIME"])][] = "('{$zmd5}','{$ARRAY["DATE"]}','{$ARRAY["HOSTNAME"]}','{$familysite}','{$ARRAY["IPADDR"]}')"; if ($GLOBALS["VERBOSE"]) { echo "('{$zmd5}','{$ARRAY["DATE"]}','{$ARRAY["HOSTNAME"]}','{$familysite}','{$ARRAY["IPADDR"]}')\n"; } $mainkey = dba_nextkey($db_con); } dba_close($db_con); if (count($SQL1) > 0) { $q = new mysql_postfix_builder(); while (list($TIMESTAMP, $rows) = each($SQL1)) { $q->postfix_buildhour_connections($TIMESTAMP); $sql = "INSERT IGNORE INTO {$TIMESTAMP}_hcnx (`zmd5`,`zDate`,`hostname`,`domain`,`ipaddr`) VALUES " . @implode(",", $rows); $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return false; } } } if ($GLOBALS["VERBOSE"]) { echo "Parsing {$path} END\n"; } return true; }