$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('if_user_index', 'y');
$smarty->assign('full_name', $_SESSION['full_name']);
$smarty->assign('email', $_SESSION['email']);
$smarty->assign('if_webmail', $data['p_webmail']);
$smarty->assign('if_spamassassin', $data['p_spamassassin']);
$domain_id = $_GET['did'];
$max_email = $data['max_email'];
$smarty->assign('domain', $data['dnsname']);
$smarty->assign('dnsname', $data['dnsname']);
$smarty->assign('full_name', false);
$smarty->assign('eMail', false);
if (get_forem_domain($domain_id, 'users', $db) >= $max_email && $max_email != 0) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_error_email_max_reached', 'y');
}
if (isset($_POST['submit'])) {
if (!empty($_POST['emailaddr']) && !empty($_POST['npassword'])) {
$full_email = $_POST['emailaddr'] . "@" . $data['dnsname'];
if (get_forem_domain($domain_id, 'users', $db) >= $max_email && $max_email != 0) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_error_email_max_reached', 'y');
} else {
if (!email_valid($_POST['emailaddr'])) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_email_valid', 'y');
$smarty->assign('if_valid', 'n');
$smarty->assign('eMail', $_POST['emailaddr']);
$smarty->assign('full_name', $_POST['full_name']);
} else {
if (email_exist($full_email, $db, 0, 0)) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_error_email_exits', 'y');
$smarty->assign('full_email', 'y');
$smarty->assign('eMail', $_POST['emailaddr']);
}
} else {
$table_email = false;
}
$smarty->assign('table_email', $table_email);
$smarty->assign('from', false);
if (isset($_POST['submit'])) {
if (!empty($_POST['from']) && !empty($_POST['to'])) {
$full_email = $_POST['from'] . "@" . $dnsname;
if (!email_valid($_POST['from'])) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_email_valid', 'y');
$smarty->assign('from', $_POST['from']);
$smarty->assign('to', $_POST['to']);
} else {
if (get_forem_domain($domain_id, 'forwardings', $db) >= $max_forward && $max_forward != 0) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_error_forwds_max_reached', 'y');
} else {
if (email_exist($full_email, $db, 0, 0)) {
$smarty->assign('error_msg', 'y');
$smarty->assign('if_error_email_exits', 'y');
$smarty->assign('full_email', 'y');
$smarty->assign('from', $_POST['from']);
$smarty->assign('to', $_POST['to']);
} else {
$eto = preg_replace("(\n|\r)", '', $_POST['to']);
$sql = sprintf("INSERT INTO forwardings SET efrom='%s', eto='%s', domainid='%s', access='1'", $db->escapeSimple(strtolower($full_email)), $db->escapeSimple($eto), $db->escapeSimple($_GET['did']));
$result =& $db->query($sql);
$smarty->assign('success_msg', 'y');
$smarty->assign('if_forward_saved', 'y');
} elseif ($_GET['f'] == 'check_grey' && $config['recipient_classes_grey'] == 0) {
} else {
change_domain_feature($_GET['did'], $_GET['f'], $_GET['fstate']);
}
}
}
// Domain feature veraendern ENDE
$sql = sprintf("SELECT * FROM domains WHERE id='%s' LIMIT 1", $db->escapeSimple($_GET['did']));
$result =& $db->query($sql);
$data = $result->fetchrow(DB_FETCHMODE_ASSOC);
$smarty->assign('dnsname', $data['dnsname']);
$smarty->assign('domain', $data);
$smarty->assign('max_emails', $data['max_email']);
$smarty->assign('max_fwd', $data['max_forward']);
$smarty->assign('emails', get_forem_domain($_GET['did'], 'users', $db));
$smarty->assign('forwardings', get_forem_domain($_GET['did'], 'forwardings', $db));
//get forward domain
if (do_fwd_get_fwd_domain($_GET['did']) == false) {
$smarty->assign('domain_fwd', 0);
} else {
$smarty->assign('domain_fwd', do_fwd_get_fwd_domain($_GET['did']));
}
// get points domains
$sql = sprintf("SELECT a.fr_domain,b.dnsname FROM domains_forward AS a LEFT JOIN domains AS b ON b.id=a.fr_domain WHERE a.to_domain='%s' ORDER BY b.dnsname", $db->escapeSimple($_GET['did']));
$result =& $db->query($sql);
if ($result->numRows() > 0) {
$smarty->assign('domains_points_to_me', 1);
$table_domain_points = array();
while ($data = $result->fetchrow(DB_FETCHMODE_ASSOC)) {
array_push($table_domain_points, array('fr_domain' => $data['fr_domain'], 'fr_domain_name' => $data['dnsname']));
}
