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