PHP amavisdb::emailid_from_mailaddr示例

示例#1

文件： miniadm.messaging.amavis.php 项目： brucewu16899/1.6.x

function wbl_save()
{
    $q = new amavisdb();
    $rcpt = $_POST["rcpt"];
    $sender = $_POST["sender"];
    $rcpt_id = $q->emailid_from_email($rcpt);
    $sender_id = $q->emailid_from_mailaddr($sender);
    if (!is_numeric($rcpt_id)) {
        $rcpt_id = 0;
    }
    if ($rcpt_id == 0) {
        $user = new user($_SESSION["uid"]);
        $user->DisplayName = mysql_escape_string2($user->DisplayName);
        $sql = "INSERT IGNORE INTO `users` (policy_id,email,uid,fullname,local) VALUES\n\t\t('','{$rcpt}','{$_SESSION["uid"]}','{$user->DisplayName}',1);";
        $q->QUERY_SQL($sql);
        if (!$q->ok) {
            echo $q->mysql_error;
            return;
        }
        $rcpt_id = $q->last_id;
    }
    if ($sender_id == 0) {
        $sql = "INSERT IGNORE INTO `mailaddr` (email) VALUES ('{$sender}');";
        $q->QUERY_SQL($sql);
        if (!$q->ok) {
            echo $q->mysql_error;
            return;
        }
        $sender_id = $q->last_id;
    }
    $sql = "SELECT wb FROM wblist WHERE sid={$sender_id} AND rid={$rcpt_id}";
    $ligne = mysql_fetch_array($q->QUERY_SQL($sql));
    if ($ligne["wb"] == null) {
        $q->QUERY_SQL("INSERT INTO wblist (sid,rid,wb) VALUES ({$sender_id},{$rcpt_id},'{$_POST["wbl-type"]}')");
        if (!$q->ok) {
            echo $q->mysql_error;
            return;
        }
    }
}