function localAliasExists($name, $destination) { $sql = 'SELECT' . ' alias_id' . ' FROM local_aliases' . ' WHERE name=?' . ' AND destination=?'; $conditions = array($name, $destination); $result = db_getval($sql, $conditions); if ($result) { return TRUE; } return FALSE; }
function isDomainAdmin($userId = FALSE) { if (!$userId) { $userId = $_SESSION['user']['user_id']; } if (!userIsActive($userId)) { return FALSE; } if (isSiteAdmin($userId)) { return TRUE; } $sql = 'SELECT count(*)' . ' FROM domain_administrators' . ' WHERE user_id = ?'; $numDomains = db_getval($sql, array($userId)); if ($numDomains > 0) { return TRUE; } return FALSE; }
function getDomainId($domain) { if (!$domain) { return FALSE; } $sql = 'SELECT domain_id FROM virtual_domains WHERE domain = ?'; return db_getval($sql, array($domain)); }
function forwardExistsByIdEmail($aliasId, $email) { $sql = 'SELECT' . ' COUNT(*)' . ' FROM virtual_aliases' . ' JOIN virtual_domains USING(domain_id)' . ' WHERE alias_id = ?' . ' AND (username || \'@\' || domain) = ?'; $val = db_getval($sql, array($aliasId, $email)); if ($val > 0) { return TRUE; } else { return FALSE; } }
function getNumVirtualForwards($name) { $sql = 'SELECT' . ' COUNT(alias_id)' . ' FROM virtual_aliases' . ' WHERE destination = ?'; return db_getval($sql, array($name)); }
function getRoleId($role) { $sql = 'SELECT role_id FROM roles WHERE role = ?'; return db_getval($sql, array($role)); }
function aliasExistsById($aliasId) { if (!$aliasId) { return FALSE; } $sql = 'SELECT' . ' COUNT(alias_id)' . ' FROM virtual_aliases' . ' WHERE alias_id = ?'; $val = db_getval($sql, array($aliasId)); if ($val > 0) { return TRUE; } return FALSE; }
$params[] = $to; $row = db_getrow($sql, $params); $userId = $row['user_id']; $message = $row['message']; if ($message) { $sql = "SELECT timestamp"; $sql .= " FROM autoreply_log"; $sql .= " JOIN autoreply USING(user_id)"; $sql .= " WHERE active = 't'"; $sql .= " AND begins <= timestamp"; $sql .= " AND user_id = ?"; $sql .= " AND from_email = ?"; $params = array(); $params[] = $userId; $params[] = $from; $time = db_getval($sql, $params); if ($time) { exit(0); } $params = array(); $params['user_id'] = $userId; $params['from_email'] = $from; $time = db_insert('autoreply_log', $params, 'timestamp'); if (!$time) { printErr("could not insert into autoreply_log"); exit(1); } $subject = "Re: " . getOrigSubject(); sendEmail($from, $to, $subject, $message); } exit(0);