$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'])); }