<?php
/**
* ispCP П‰ (OMEGA) a Virtual Hosting Control System
*
* @copyright 2001-2006 by moleSoftware GmbH
* @copyright 2006-2008 by ispCP | http://isp-control.net
* @version SVN: $ID$
* @link http://isp-control.net
* @author ispCP Team
*
* @license
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*
* The Original Code is "VHCS - Virtual Hosting Control System".
*
* The Initial Developer of the Original Code is moleSoftware GmbH.
* Portions created by Initial Developer are Copyright (C) 2001-2006
* by moleSoftware GmbH. All Rights Reserved.
* Portions created by the ispCP Team are Copyright (C) 2006-2009 by
* isp Control Panel. All Rights Reserved.
*/
require '../include/ispcp-lib.php';
check_login(__FILE__);
$tpl = new pTemplate();
$tpl->define_dynamic('page', Config::get('ADMIN_TEMPLATE_PATH') . '/domain_details.tpl');
$tpl->define_dynamic('logged_from', 'page');
$tpl->define_dynamic('custom_buttons', 'page');
$theme_color = Config::get('USER_INITIAL_THEME');
$tpl->assign(
array(
'TR_DETAILS_DOMAIN_PAGE_TITLE' => tr('ispCP - Domain/Details'),
'THEME_COLOR_PATH' => "../themes/$theme_color",
'THEME_CHARSET' => tr('encoding'),
'ISP_LOGO' => get_logo($_SESSION['user_id']),
)
);
/*
*
* static page messages.
*
*/
$tpl->assign(
array(
'TR_DOMAIN_DETAILS' => tr('Domain details'),
'TR_DOMAIN_NAME' => tr('Domain name'),
'TR_DOMAIN_IP' => tr('Domain IP'),
'TR_STATUS' => tr('Status'),
'TR_PHP_SUPP' => tr('PHP support'),
'TR_CGI_SUPP' => tr('CGI support'),
'TR_DNS_SUPP' => tr('Manual DNS support (EXPERIMENTAL)'),
'TR_MYSQL_SUPP' => tr('MySQL support'),
'TR_TRAFFIC' => tr('Traffic in MB'),
'TR_DISK' => tr('Disk in MB'),
'TR_FEATURE' => tr('Feature'),
'TR_USED' => tr('Used'),
'TR_LIMIT' => tr('Limit'),
'TR_MAIL_ACCOUNTS' => tr('Mail accounts'),
'TR_FTP_ACCOUNTS' => tr('FTP accounts'),
'TR_SQL_DB_ACCOUNTS' => tr('SQL databases'),
'TR_SQL_USER_ACCOUNTS' => tr('SQL users'),
'TR_SUBDOM_ACCOUNTS' => tr('Subdomains'),
'TR_DOMALIAS_ACCOUNTS' => tr('Domain aliases'),
'TR_UPDATE_DATA' => tr('Submit changes'),
'TR_BACK' => tr('Back'),
'TR_CRON_MANAGER' => tr('Cronjob Manager'),
'TR_MESSAGE_DELETE' => tr('Are you sure you want to delete %s?', true, '%s'),
'TR_CRONJOBS' => tr('Cronjobs'),
'TR_ACTIVE' => tr('Active'),
'TR_ACTION' => tr('Active'),
'TR_EDIT' => tr('Edit'),
'TR_DELETE' => tr('Delete'),
'TR_ADD' => tr('Add Cronjob')
)
);
gen_admin_mainmenu($tpl, Config::get('ADMIN_TEMPLATE_PATH') . '/main_menu_users_manage.tpl');
gen_admin_menu($tpl, Config::get('ADMIN_TEMPLATE_PATH') . '/menu_users_manage.tpl');
gen_page_message($tpl);
// Get user id that comes for manage domain
if (!isset($_GET['domain_id'])) {
user_goto('manage_users.php');
}
$editid = $_GET['domain_id'];
gen_detaildom_page($tpl, $_SESSION['user_id'], $editid);
//Add Cron table
$domain = user_vs_domain($tpl, $sql, $editid);
gen_cron_jobs($tpl, $sql, $domain);
$tpl->parse('PAGE', 'page');
$tpl->prnt();
if (Config::get('DUMP_GUI_DEBUG')) {
dump_gui_debug();
}
unset_messages();
// Begin function block
function gen_detaildom_page(&$tpl, $user_id, $domain_id) {
$sql = Database::getInstance();
// Get domain data
$query = "
SELECT
*,
IFNULL(`domain_disk_usage`, 0) AS domain_disk_usage
FROM
`domain`
WHERE
`domain_id` = ?;
";
$res = exec_query($sql, $query, array($domain_id));
$data = $res->FetchRow();
if ($res->RecordCount() <= 0) {
user_goto('manage_users.php');
}
// Get admin data
$query = "SELECT `admin_name` FROM `admin` WHERE `admin_id` = ?";
$res1 = exec_query($sql, $query, array($data['domain_admin_id']));
$data1 = $res1->FetchRow();
if ($res1->RecordCount() <= 0) {
user_goto('manage_users.php');
}
// Get IP info
$query = "SELECT * FROM `server_ips` WHERE `ip_id` = ?";
$ipres = exec_query($sql, $query, array($data['domain_ip_id']));
$ipdat = $ipres->FetchRow();
// Get status name
$dstatus = $data['domain_status'];
if ($dstatus == Config::get('ITEM_OK_STATUS')
|| $dstatus == Config::get('ITEM_DISABLED_STATUS')
|| $dstatus == Config::get('ITEM_DELETE_STATUS')
|| $dstatus == Config::get('ITEM_ADD_STATUS')
|| $dstatus == Config::get('ITEM_RESTORE_STATUS')
|| $dstatus == Config::get('ITEM_CHANGE_STATUS')
|| $dstatus == Config::get('ITEM_TOENABLE_STATUS')
|| $dstatus == Config::get('ITEM_TODISABLED_STATUS')) {
$dstatus = translate_dmn_status($data['domain_status']);
} else {
$dstatus = "<b><font size=\"3\" color=\"red\">" . $data['domain_status'] . "</font></b>";
}
// Traffic diagram
$fdofmnth = mktime(0, 0, 0, date("m"), 1, date("Y"));
$ldofmnth = mktime(1, 0, 0, date("m") + 1, 0, date("Y"));
$query = "
SELECT
IFNULL(SUM(`dtraff_web`), 0) AS dtraff_web,
IFNULL(SUM(`dtraff_ftp`), 0) AS dtraff_ftp,
IFNULL(SUM(`dtraff_mail`), 0) AS dtraff_mail,
IFNULL(SUM(`dtraff_pop`), 0) AS dtraff_pop
FROM
`domain_traffic`
WHERE
`domain_id` = ?
AND
`dtraff_time` > ?
AND
`dtraff_time` < ?
";
$res7 = exec_query($sql, $query, array($data['domain_id'], $fdofmnth, $ldofmnth));
$dtraff = $res7->FetchRow();
$sumtraff = $dtraff['dtraff_web'] + $dtraff['dtraff_ftp'] + $dtraff['dtraff_mail'] + $dtraff['dtraff_pop'];
$dtraffmb = sprintf("%.1f", ($sumtraff / 1024) / 1024);
$month = date("m");
$year = date("Y");
$query = "SELECT * FROM `server_ips` WHERE `ip_id` = ?";
$res8 = exec_query($sql, $query, array($data['domain_ip_id']));
$ipdat = $res8->FetchRow();
$domain_traffic_limit = $data['domain_traffic_limit'];
$domain_all_traffic = $sumtraff; //$dtraff['traffic'];
$traff = ($domain_all_traffic / 1024) / 1024;
$mtraff = sprintf("%.2f", $traff);
if ($domain_traffic_limit == 0) {
$pr = 0;
} else {
$pr = ($traff / $domain_traffic_limit) * 100;
$pr = sprintf("%.2f", $pr);
}
$indx = (int)$pr;
list($traffic_percent, $indx, $a) = make_usage_vals($domain_all_traffic, $domain_traffic_limit * 1024 * 1024);
// Get disk status
$domdu = $data['domain_disk_usage'];
$domdl = $data['domain_disk_limit'];
$tmp = ($domdu / 1024) / 1024;
if ($domdu == 0) {
$dpr = 0;
} else if ($domdl == 0) {
$dpr = 0;
} else {
$dpr = ($tmp / $domdl) * 100;
$dpr = sprintf("%.2f", $dpr);
}
$dindx = (int) $dpr;
$domduh = sizeit($domdu);
list($disk_percent, $dindx, $b) = make_usage_vals($domdu, $domdl * 1024 * 1024);
// Get current mail count
$query = "SELECT COUNT(`mail_id`) AS mcnt
FROM `mail_users`
WHERE `domain_id` = ?
AND `mail_type` NOT RLIKE '_catchall'";
if (Config::get('COUNT_DEFAULT_EMAIL_ADDRESSES') == 0) {
$query .= " AND `mail_acc` != 'abuse'
AND `mail_acc` != 'postmaster'
AND `mail_acc` != 'webmaster'";
}
$res6 = exec_query($sql, $query, array($data['domain_id']));
$dat3 = $res6->FetchRow();
$mail_limit = translate_limit_value($data['domain_mailacc_limit']);
// FTP stat
$query = "SELECT `gid` FROM `ftp_group` WHERE `groupname` = ?";
$res4 = exec_query($sql, $query, array($data['domain_name']));
$ftp_gnum = $res4->RowCount();
if ($ftp_gnum == 0) {
$used_ftp_acc = 0;
} else {
$dat1 = $res4->FetchRow();
$query = "SELECT COUNT(*) AS ftp_cnt FROM `ftp_users` WHERE `gid` = ?";
$res5 = exec_query($sql, $query, array($dat1['gid']));
$dat2 = $res5->FetchRow();
$used_ftp_acc = $dat2['ftp_cnt'];
}
$ftp_limit = translate_limit_value($data['domain_ftpacc_limit']);
// Get sql database count
$query = "SELECT COUNT(*) AS dnum FROM `sql_database` WHERE `domain_id` = ?";
$res = exec_query($sql, $query, array($data['domain_id']));
$dat5 = $res->FetchRow();
$sql_db = translate_limit_value($data['domain_sqld_limit']);
// Get sql users count
$query = "SELECT COUNT(u.`sqlu_id`) AS ucnt FROM `sql_user` u, `sql_database` d WHERE u.`sqld_id` = d.`sqld_id` AND d.`domain_id` = ?";
$res = exec_query($sql, $query, array($data['domain_id']));
$dat6 = $res->FetchRow();
$sql_users = translate_limit_value($data['domain_sqlu_limit']);
// Get subdomain
$query = "SELECT COUNT(`subdomain_id`) AS sub_num FROM `subdomain` WHERE `domain_id` = ?";
$res1 = exec_query($sql, $query, array($data['domain_id']));
$sub_num_data = $res1->FetchRow();
$query = "SELECT COUNT(`subdomain_alias_id`) AS sub_num FROM `subdomain_alias` WHERE `alias_id` IN (SELECT `alias_id` FROM `domain_aliasses` WHERE `domain_id` = ?)";
$res1 = exec_query($sql, $query, array($domain_id));
$alssub_num_data = $res1->FetchRow();
$sub_dom = translate_limit_value($data['domain_subd_limit']);
// Get domain aliases
$query = "SELECT COUNT(*) AS alias_num FROM `domain_aliasses` WHERE `domain_id` = ?";
$res1 = exec_query($sql, $query, array($data['domain_id']));
$alias_num_data = $res1->FetchRow();
$dom_alias = translate_limit_value($data['domain_alias_limit']);
// Fill in the fields
$tpl->assign(
array(
'DOMAIN_ID' => $data['domain_id'],
'VL_DOMAIN_NAME' => decode_idna($data['domain_name']),
'VL_DOMAIN_IP' => $ipdat['ip_number'] . ' (' . $ipdat['ip_alias'] . ')',
'VL_STATUS' => $dstatus,
'VL_PHP_SUPP' => ($data['domain_php'] == 'yes') ? tr('Enabled') : tr('Disabled'),
'VL_CGI_SUPP' => ($data['domain_cgi'] == 'yes') ? tr('Enabled') : tr('Disabled'),
'VL_DNS_SUPP' => ($data['domain_dns'] == 'yes') ? tr('Enabled') : tr('Disabled'),
'VL_MYSQL_SUPP' => ($data['domain_sqld_limit'] >= 0) ? tr('Enabled') : tr('Disabled'),
'VL_TRAFFIC_PERCENT' => $traffic_percent,
'VL_TRAFFIC_USED' => sizeit($domain_all_traffic),
'VL_TRAFFIC_LIMIT' => sizeit($domain_traffic_limit, 'MB'),
'VL_DISK_PERCENT' => $disk_percent,
'VL_DISK_USED' => $domduh,
'VL_DISK_LIMIT' => sizeit($data['domain_disk_limit'], 'MB'),
'VL_MAIL_ACCOUNTS_USED' => $dat3['mcnt'],
'VL_MAIL_ACCOUNTS_LIIT' => $mail_limit,
'VL_FTP_ACCOUNTS_USED' => $used_ftp_acc,
'VL_FTP_ACCOUNTS_LIIT' => $ftp_limit,
'VL_SQL_DB_ACCOUNTS_USED' => $dat5['dnum'],
'VL_SQL_DB_ACCOUNTS_LIIT' => $sql_db,
'VL_SQL_USER_ACCOUNTS_USED' => $dat6['ucnt'],
'VL_SQL_USER_ACCOUNTS_LIIT' => $sql_users,
'VL_SUBDOM_ACCOUNTS_USED' => $sub_num_data['sub_num'] + $alssub_num_data['sub_num'],
'VL_SUBDOM_ACCOUNTS_LIIT' => $sub_dom,
'VL_DOMALIAS_ACCOUNTS_USED' => $alias_num_data['alias_num'],
'VL_DOMALIAS_ACCOUNTS_LIIT' => $dom_alias
)
);
} // End of load_user_data();
# Get CronJobs
function gen_cron_jobs(&$tpl, &$sql, $user_id) {
$query = <<<SQL_QUERY
SELECT
id, name, lastrun, activ, coment, domain
FROM
hcrondtab
WHERE
domain = $user_id
ORDER BY
id
SQL_QUERY;
$rs = exec_query($sql, $query, array($user_id));
if ($rs->RecordCount() == 0) {
$tpl->assign(
array('NAME' => tr('Jobs list is empty!'),
'DESCRIPTION' => '',
'ACTIVE' => '',
'LASTRUN' => ''
)
);
} else {
$counter = 0;
while (!$rs->EOF) {
if ($counter % 2 == 0) {
$tpl->assign('ITEM_CLASS', 'content');
} else {
$tpl->assign('ITEM_CLASS', 'content2');
}
if ($rs->fields['activ'] == 1) {$activ = 'Yes';}
else {$activ = 'No';};
$lastrun = $rs->fields['lastrun'];
if ($lastrun == 0 ) {$lastrun = '';}
else {$lastrun = date("Y-m-d H:i:s",$lastrun);}
$tpl->assign(
array('NAME' => $rs->fields['name'],
'DESCRIPTION' => $rs->fields['coment'],
'LASTRUN' => $lastrun,
'ACTIVE' => $activ,
'ID' => $rs->fields['id']
)
);
$tpl->parse('CRONJOBS', '.cronjobs');
$rs->MoveNext();
$counter++;
}
}
} // End of gen_cron_job
function user_vs_domain(&$tpl, &$sql, $domain_id) {
$query = <<<SQL_QUERY
SELECT
domain_admin_id
FROM
domain
WHERE
domain_id = $domain_id
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
return $rs->fields['domain_admin_id'];;
} //End user_vs_domain
Search
Member List
Calendar
Help
