function add_address($email) { global $dbh; $addr_id = 0; $priority = get_email_address_priority($email); $sth = $dbh->prepare("INSERT INTO mailaddr (priority, email) VALUES (?, ?)"); $sth->execute(array($priority, $email)); if (PEAR::isError($sth)) { die($sth->getMessage()); } $sth->free(); $sth = $dbh->prepare("SELECT id FROM mailaddr WHERE email = ?"); $res = $sth->execute(array($email)); if (PEAR::isError($sth)) { die($sth->getMessage()); } if ($row = $res->fetchRow()) { $addr_id = $row["id"]; } $sth->free(); return $addr_id; }
function add_address_to_user($policy_id, $address, $uid, $domain_id) { global $dbh; $priority = get_email_address_priority($address); $sth = $dbh->prepare("INSERT INTO users (policy_id, email, priority, maia_user_id, maia_domain_id) VALUES (?,?,?,?,?)"); $sth->execute(array($policy_id, $address, $priority, $uid, $domain_id)); if (PEAR::isError($sth)) { die($sth->getMessage()); } $sth->free(); $sth = $dbh->prepare("SELECT id FROM users WHERE email = ?"); $res = $sth->execute(array($address)); if (PEAR::isError($sth)) { die($sth->getMessage()); } if ($row = $res->fetchrow()) { $email_id = $row["id"]; } else { $email_id = 0; } $sth->free(); return $email_id; }
function add_address($email) { global $dbh; $addr_id = 0; $priority = get_email_address_priority($email); $insert = "INSERT INTO mailaddr (priority, email) VALUES (?, ?)"; $dbh->query($insert, array($priority, $email)); $select = "SELECT id FROM mailaddr WHERE email = ?"; $sth = $dbh->query($select, array($email)); if ($row = $sth->fetchRow()) { $addr_id = $row["id"]; } $sth->free(); return $addr_id; }
function add_address_to_user($policy_id, $address, $uid, $domain_id) { global $dbh; $priority = get_email_address_priority($address); $insert = "INSERT INTO users (policy_id, email, priority, maia_user_id, maia_domain_id) VALUES (?,?,?,?,?)"; $dbh->query($insert, array($policy_id, $address, $priority, $uid, $domain_id)); $select = "SELECT id FROM users WHERE email = ?"; $sth = $dbh->query($select, array($address)); if ($row = $sth->fetchrow()) { $email_id = $row["id"]; } else { $email_id = 0; } $sth->free(); return $email_id; }