PHP db_getval Examples

Example #1

File: localAliases.inc.php Project: rubixconsulting/postfixweb

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

Example #2

File: user.inc.php Project: rubixconsulting/postfixweb

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

Example #3

File: domains.inc.php Project: rubixconsulting/postfixweb

function getDomainId($domain)
{
    if (!$domain) {
        return FALSE;
    }
    $sql = 'SELECT domain_id FROM virtual_domains WHERE domain = ?';
    return db_getval($sql, array($domain));
}

Example #4

File: forwards.inc.php Project: rubixconsulting/postfixweb

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

Example #5

File: localForwards.inc.php Project: rubixconsulting/postfixweb

function getNumVirtualForwards($name)
{
    $sql = 'SELECT' . '  COUNT(alias_id)' . '  FROM virtual_aliases' . '  WHERE destination = ?';
    return db_getval($sql, array($name));
}

Example #6

File: roles.inc.php Project: rubixconsulting/postfixweb

function getRoleId($role)
{
    $sql = 'SELECT role_id FROM roles WHERE role = ?';
    return db_getval($sql, array($role));
}

Example #7

File: aliases.inc.php Project: rubixconsulting/postfixweb

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

Example #8

File: autoreply.php Project: rubixconsulting/postfixweb

$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);