Esempio n. 1
0
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;
}
Esempio n. 2
0
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;
}
Esempio n. 3
0
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;
}