PHP familysite::GetComputerName Examples

Example #1

File: exec.maillog.php Project: articatech/artica

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

Example #2

File: exec.maillog.php Project: brucewu16899/1.6.x

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

Example #3

File: exec.postfix-stats.php Project: BillTheBest/1.6.x

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;
}