$sql = sprintf("SELECT a.email FROM users AS a LEFT JOIN autoresponder AS b ON b.email = a.id WHERE a.domainid='%d' AND b.active = 'y'", $db->escapeSimple($row['id']));
$res_vacation = $db->query($sql);
$vaction_infos = "";
if ($res_vacation->numRows() > 0) {
$vaction = 1;
while ($row_vac = $res_vacation->fetchrow(DB_FETCHMODE_ASSOC)) {
$vaction_infos .= $row_vac['email'] . "<br/>";
}
} else {
$vaction = 0;
}
//display size of all mailboxes
$sql = sprintf("SELECT SUM( mb_size ) AS sum FROM users WHERE domainid = %d", $db->escapeSimple($row['id']));
$res_mb_size =& $db->query($sql);
$mb_size = $res_mb_size->fetchrow(DB_FETCHMODE_ASSOC);
$mb_size = mailbox_size_human($mb_size['sum']);
if (empty($data_mb_size['sum'])) {
$data_mb_size['sum'] = 0;
}
array_push($table_data, array('dnsname' => $row['dnsname'], 'access' => $row['access'], 'count_forward' => get_forem_domain($row['id'], 'forwardings', $db), 'count_email' => get_forem_domain($row['id'], 'users', $db), 'id' => $row['id'], 'access' => $row['access'], 'dnote' => $row['dnote'], 'vacation' => $vaction, 'vacation_infos' => $vaction_infos, 'mb_size' => $mb_size));
//$i++;
}
}
//email user part:
if ($_SESSION['superadmin'] == 0 && $_SESSION['admin'] == '0' | $_SESSION['ad_user'] == 'y' && $_SESSION['manager'] == '0') {
$folders = list_imap_folders($config['imap_server'], $_SESSION['email'], decrypt_passwd($_SESSION['cpasswd']), 1);
if ($folders == false) {
$smarty->assign('imap_folder_exits', 0);
} else {
$smarty->assign('imap_folder_exits', 1);
$smarty->assign('available_folders', $folders);
$smarty->assign('table_domain_points', $table_domain_points);
} else {
$smarty->assign('domains_points_to_me', 0);
}
//FIXME: deleted email addresses!!!
$sql = sprintf("SELECT email,id,access,mb_size FROM users WHERE domainid='%s' AND enew!='0' ORDER BY email", $db->escapeSimple($_GET['did']));
$result =& $db->query($sql);
$table_email = array();
while ($data = $result->fetchrow(DB_FETCHMODE_ASSOC)) {
$autoresponder = 0;
$sql = sprintf("SELECT id FROM autoresponder WHERE email='%d' AND active='y'", $db->escapeSimple($data['id']));
$res =& $db->query($sql);
if ($res->numRows() == 1) {
$autoresponder = 1;
}
array_push($table_email, array('id' => $data['id'], 'did' => $_GET['did'], 'email' => $data['email'], 'access' => $data['access'], 'mb_size' => mailbox_size_human($data['mb_size']), 'autoresponder' => $autoresponder));
}
//ENDE WHILE eMails
$sql = sprintf("SELECT * FROM forwardings WHERE domainid='%s' ORDER BY efrom", $db->escapeSimple($_GET['did']));
$result =& $db->query($sql);
echo mysql_error();
$table_forward = array();
while ($data = $result->fetchrow(DB_FETCHMODE_ASSOC)) {
if (!ereg('^@', $data['efrom'])) {
array_push($table_forward, array('id' => $data['id'], 'did' => $_GET['did'], 'from' => $data['efrom'], 'to' => get_first_forward($data['eto']), 'if_multif' => check_multi_forward($data['eto']), 'access' => $data['access']));
}
}
//ENDE WHILE forward
if ($config['mailinglists'] == '1') {
//Run ML-Code only ==1
$sql = sprintf("SELECT id,COUNT(*) as num FROM list_recp GROUP BY id", $db->escapeSimple($_GET['did']));
