PHP mysql_postfix_builder::milter_BuildHourTable Beispiele

Beispiel #1

Datei: exec.postfix-logger.php Projekt: brucewu16899/1.6.x

function MiltergreyList_inject($array)
{
    if (count($array) == 0) {
        events("MiltergreyList_inject():: Nothing to do...", __FILE__);
        return;
    }
    $q = new mysql_postfix_builder();
    events("MiltergreyList_inject():: Analyze " . count($array) . " rows", __FILE__);
    while (list($tablename, $sqls) = each($array)) {
        events("MiltergreyList_inject():: build-sql {$tablename} > " . count($array) . " rows", __FILE__);
        $q->milter_BuildHourTable($tablename);
        if (!$q->TABLE_EXISTS($tablename)) {
            events("MiltergreyList_inject():: {$tablename} no such table", __FILE__);
        }
        $prefix = "INSERT IGNORE INTO {$tablename} (`zmd5`,`ztime`,`zhour`,`mailfrom`,`instancename`,`mailto`,`domainfrom`,`domainto`,`senderhost`,`failed`) VALUES ";
        $q->QUERY_SQL($prefix . @implode(",", $sqls));
        if (!$q->ok) {
            events("MiltergreyList_inject():: {$q->mysql_error}", __FILE__);
        }
    }
    events("MiltergreyList_inject():: Finish...", __FILE__);
}