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