function getAliases()
{
    if (!isDomainAdmin()) {
        return FALSE;
    }
    $sql = 'SELECT' . '  alias_id,' . '  (username || \'@\' || domain) AS email,' . '  domain,' . '  destination,' . '  active' . '  FROM virtual_aliases' . '  JOIN virtual_domains USING(domain_id)' . '  WHERE domain IN (' . quotedAdminDomainString() . '  )' . '    AND username != \'\'' . '    AND (username || \'@\' || domain) NOT IN (' . quotedAdminUserString() . '    )' . '    AND destination IN (' . quotedAdminUserString() . '    )' . '  ORDER BY domain, username, destination';
    return db_getrows($sql);
}
示例#2
0
function db_getrow($sql, $params = FALSE)
{
    $rows = db_getrows($sql, $params);
    if (!$rows) {
        return FALSE;
    }
    return $rows[0];
}
function getLocalForwards()
{
    $sql = 'SELECT' . '  alias_id,' . '  (username || \'@\' || domain) AS email,' . '  domain,' . '  destination,' . '  active' . '  FROM virtual_aliases' . '  JOIN virtual_domains USING(domain_id)' . '  WHERE (username || \'@\' || domain) NOT IN (' . quotedAdminUserString() . '  )' . '  ORDER BY domain, username, destination';
    $rows = db_getrows($sql);
    $ret = array();
    foreach ($rows as $row) {
        if (!validEmailAddress($row['destination']) && validUserName($row['destination'])) {
            $row['aliases'] = getNumLocalAliasDestination($row['destination']);
            $ret[] = $row;
        }
    }
    return $ret;
}
function getForwards()
{
    if (!isDomainAdmin()) {
        return FALSE;
    }
    $sql = 'SELECT' . '  alias_id,' . '  (username || \'@\' || domain) AS email,' . '  domain,' . '  destination,' . '  active' . '  FROM virtual_aliases' . '  JOIN virtual_domains USING(domain_id)' . '  WHERE domain IN (' . quotedAdminDomainString() . '  )' . '  AND (username || \'@\' || domain) IN (' . quotedAdminUserString() . '  )' . '  AND (username || \'@\' || domain) != destination' . '  AND (username || \'@\' || domain || \'@autoreply.\' || domain) != destination' . '  ORDER BY domain, username, destination';
    $rows = db_getrows($sql);
    $i = 0;
    foreach ($rows as $row) {
        if ($row['active'] == 't') {
            $rows[$i]['active'] = TRUE;
        } else {
            $rows[$i]['active'] = FALSE;
        }
        $i++;
    }
    return $rows;
}
function getLocalAliases()
{
    if (!isSiteAdmin()) {
        return FALSE;
    }
    $sql = 'SELECT' . '  alias_id,' . '  name,' . '  destination,' . '  active' . '  FROM local_aliases' . '  ORDER BY name';
    $rows = db_getrows($sql);
    $i = 0;
    foreach ($rows as $row) {
        if ($row['active'] == 't') {
            $rows[$i]['active'] = TRUE;
        } else {
            $rows[$i]['active'] = FALSE;
        }
        $rows[$i]['forwards'] = getNumVirtualForwards($row['name']);
        $i++;
    }
    return $rows;
}
示例#6
0
function getSyslog($limit = FALSE, $start = FALSE)
{
    global $priorities;
    $sql = 'SELECT * FROM (' . '  SELECT' . '    id,' . '    DATE_PART(\'epoch\', devicereportedtime) AS time,' . '    priority AS priority_id,' . '    message,' . '    syslogtag AS service' . '    FROM systemevents' . '    WHERE facility = ?';
    $params = array(SYSLOG_MAIL);
    if ($start) {
        $sql .= ' AND id > ?';
        $params[] = $start;
    }
    $sql .= ' ORDER BY id DESC';
    if ($limit) {
        $sql .= ' LIMIT ?';
        $params[] = $limit;
    }
    $sql .= ') AS LOG' . '  ORDER BY id';
    db_set_active('logs');
    $rows = db_getrows($sql, $params);
    db_set_active('default');
    if (!$rows) {
        return FALSE;
    }
    $i = 0;
    foreach ($rows as $row) {
        $pid = null;
        $service = str_replace(':', '', $row['service']);
        if (preg_match('/^(.*)\\[(.*)\\]$/', $service, $matches)) {
            $service = $matches[1];
            $pid = $matches[2];
        }
        $rows[$i]['pid'] = $pid;
        $rows[$i]['service'] = $service;
        $message = htmlspecialchars($row['message']);
        $rows[$i]['message'] = $message;
        $i++;
    }
    return $rows;
}
示例#7
0
function getAdminUsers($like = FALSE, $userId = FALSE)
{
    if (!$userId) {
        $userId = $_SESSION['user']['user_id'];
    }
    if (!isDomainAdmin($userId)) {
        return FALSE;
    }
    $sql = 'SELECT' . '    user_id,' . '    username || \'@\' || domain AS email,' . '    username,' . '    domain,' . '    role_id,' . '    description AS name,' . '    active' . '  FROM virtual_users' . '    JOIN virtual_domains USING(domain_id)' . '  WHERE domain IN (' . quotedAdminDomainString() . '  )';
    if ($like) {
        $sql .= '  AND (username || \'@\' || domain) LIKE ?';
    }
    $sql .= ' ORDER BY domain, username';
    if ($like) {
        $params = array('%' . $like . '%');
    } else {
        $params = array();
    }
    $users = db_getrows($sql, $params);
    if (!$users) {
        return FALSE;
    }
    $i = 0;
    foreach ($users as $tmpUser) {
        $u = $users[$i];
        $u['local'] = userLocal($u['email']);
        $u['active'] = FALSE;
        if ($tmpUser['active'] == 't') {
            $u['active'] = TRUE;
        }
        $users[$i] = $u;
        $i++;
    }
    return $users;
}
function getAllDomains()
{
    $sql = 'SELECT domain_id, domain FROM virtual_domains';
    return db_getrows($sql);
}
示例#9
0
include_once '../lib/session.inc.php';
include_once '../lib/user.inc.php';
include_once '../lib/domains.inc.php';
requireDomainAdmin();
$query = $_POST['query'];
$mode = $_POST['mode'];
if ($query && !$mode && $query != 'all') {
    $sql = 'SELECT' . '  domain_id,' . '  domain' . '  FROM virtual_domains' . '  WHERE domain LIKE ?' . '  AND domain IN (' . quotedAdminDomainString() . '  )' . ' ORDER BY domain';
    $rows = db_getrows($sql, array('%' . strtolower($query) . '%'));
    $domains = array('success' => true, 'domains' => $rows);
    print json_encode($domains);
} else {
    if ($mode == 'load' || $query == 'all') {
        $sql = 'SELECT' . '  domain_id,' . '  domain' . '  FROM virtual_domains' . '  WHERE domain IN (' . quotedAdminDomainString() . '  )' . '  ORDER BY domain';
        $rows = db_getrows($sql);
        $domains = array('success' => true, 'domains' => $rows);
        print json_encode($domains);
    } else {
        if ($mode == 'add') {
            requireSiteAdmin();
            addDomain($_POST['domain']);
        } else {
            if ($mode == 'remove') {
                requireSiteAdmin();
                $remove = $_POST['domains'];
                $domainIds = split(',', $remove);
                foreach ($domainIds as $domainId) {
                    removeDomain($domainId);
                }
                print json_encode(array('success' => TRUE));