$result = Database::pexecute_first($result_stmt, $params);
if ($result['domain'] != '') {
$subdomains_stmt = Database::prepare("\n\t\t\t\tSELECT COUNT(`id`) AS count FROM `" . TABLE_PANEL_DOMAINS . "` WHERE\n\t\t\t\t`parentdomainid` = :resultid\n\t\t\t");
$subdomains = Database::pexecute_first($subdomains_stmt, array('resultid' => $result['id']));
$subdomains = $subdomains['count'];
$alias_check_stmt = Database::prepare("\n\t\t\t\tSELECT COUNT(`id`) AS count FROM `" . TABLE_PANEL_DOMAINS . "` WHERE\n\t\t\t\t`aliasdomain` = :resultid\n\t\t\t");
$alias_check = Database::pexecute_first($alias_check_stmt, array('resultid' => $result['id']));
$alias_check = $alias_check['count'];
$domain_emails_result_stmt = Database::prepare("\n\t\t\t\tSELECT `email`, `email_full`, `destination`, `popaccountid` AS `number_email_forwarders`\n\t\t\t\tFROM `" . TABLE_MAIL_VIRTUAL . "` WHERE `customerid` = :customerid AND `domainid` = :id\n\t\t\t");
Database::pexecute($domain_emails_result_stmt, array('customerid' => $result['customerid'], 'id' => $result['id']));
$emails = Database::num_rows();
$email_forwarders = 0;
$email_accounts = 0;
while ($domain_emails_row = $domain_emails_result_stmt->fetch(PDO::FETCH_ASSOC)) {
if ($domain_emails_row['destination'] != '') {
$domain_emails_row['destination'] = explode(' ', makeCorrectDestination($domain_emails_row['destination']));
$email_forwarders += count($domain_emails_row['destination']);
if (in_array($domain_emails_row['email_full'], $domain_emails_row['destination'])) {
$email_forwarders -= 1;
$email_accounts++;
}
}
}
$ipsresult_stmt = Database::prepare("\n\t\t\t\tSELECT `id_ipandports` FROM `" . TABLE_DOMAINTOIP . "` WHERE `id_domain` = :id\n\t\t\t");
Database::pexecute($ipsresult_stmt, array('id' => $result['id']));
$usedips = array();
while ($ipsresultrow = $ipsresult_stmt->fetch(PDO::FETCH_ASSOC)) {
$usedips[] = $ipsresultrow['id_ipandports'];
}
if (isset($_POST['send']) && $_POST['send'] == 'send') {
$customer_stmt = Database::prepare("\n\t\t\t\t\tSELECT * FROM " . TABLE_PANEL_CUSTOMERS . " WHERE `customerid` = :customerid\n\t\t\t\t");
}
} else {
standard_error('allresourcesused');
}
} elseif ($action == 'delete' && $id != 0) {
$result = $db->query_first("SELECT `id`, `email`, `email_full`, `iscatchall`, `destination`, `customerid`, `popaccountid` FROM `" . TABLE_MAIL_VIRTUAL . "` WHERE `customerid`='" . (int) $userinfo['customerid'] . "' AND `id`='" . (int) $id . "'");
if (isset($result['destination']) && $result['destination'] != '') {
if (isset($_POST['forwarderid'])) {
$forwarderid = intval($_POST['forwarderid']);
} elseif (isset($_GET['forwarderid'])) {
$forwarderid = intval($_GET['forwarderid']);
} else {
$forwarderid = 0;
}
$result['destination'] = explode(' ', $result['destination']);
if (isset($result['destination'][$forwarderid]) && $result['email'] != $result['destination'][$forwarderid]) {
$forwarder = $result['destination'][$forwarderid];
if (isset($_POST['send']) && $_POST['send'] == 'send') {
unset($result['destination'][$forwarderid]);
$result['destination'] = implode(' ', $result['destination']);
$db->query("UPDATE `" . TABLE_MAIL_VIRTUAL . "` SET `destination` = '" . $db->escape(makeCorrectDestination($result['destination'])) . "' WHERE `customerid`='" . (int) $userinfo['customerid'] . "' AND `id`='" . (int) $id . "'");
$db->query("UPDATE `" . TABLE_PANEL_CUSTOMERS . "` SET `email_forwarders_used` = `email_forwarders_used` - 1 WHERE `customerid`='" . (int) $userinfo['customerid'] . "'");
$log->logAction(USR_ACTION, LOG_NOTICE, "deleted email forwarder for '" . $result['email_full'] . "'");
redirectTo($filename, array('page' => 'emails', 'action' => 'edit', 'id' => $id, 's' => $s));
} else {
ask_yesno('email_reallydelete_forwarder', $filename, array('id' => $id, 'forwarderid' => $forwarderid, 'page' => $page, 'action' => $action), $idna_convert->decode($result['email_full']) . ' -> ' . $idna_convert->decode($forwarder));
}
}
}
}
}
/**
* Function which updates all counters of used ressources in panel_admins and panel_customers
* @param bool Set to true to get an array with debug information
* @return array Contains debug information if parameter 'returndebuginfo' is set to true
*
* @author Florian Lippert <*****@*****.**> (2003-2009)
* @author Froxlor team <*****@*****.**> (2010-)
*/
function updateCounters($returndebuginfo = false)
{
$returnval = array();
if ($returndebuginfo === true) {
$returnval = array('admins' => array(), 'customers' => array());
}
// Customers
$customers_stmt = Database::prepare('SELECT * FROM `' . TABLE_PANEL_CUSTOMERS . '` ORDER BY `customerid`');
Database::pexecute($customers_stmt);
$admin_resources = array();
while ($customer = $customers_stmt->fetch(PDO::FETCH_ASSOC)) {
$cur_adm = $customer['adminid'];
// initialize admin-resources array for admin $customer['adminid']
if (!isset($admin_resources[$cur_adm])) {
$admin_resources[$cur_adm] = array();
}
_addResourceCountEx($admin_resources[$cur_adm], $customer, 'diskspace_used', 'diskspace');
_addResourceCountEx($admin_resources[$cur_adm], $customer, 'traffic_used', 'traffic_used');
// !!! yes, USED and USED
foreach (array('mysqls', 'ftps', 'emails', 'email_accounts', 'tickets', 'email_forwarders', 'email_quota', 'subdomains') as $field) {
_addResourceCount($admin_resources[$cur_adm], $customer, $field . '_used', $field);
}
$customer_mysqls_stmt = Database::prepare('SELECT COUNT(*) AS `number_mysqls` FROM `' . TABLE_PANEL_DATABASES . '`
WHERE `customerid` = :cid');
$customer_mysqls = Database::pexecute_first($customer_mysqls_stmt, array("cid" => $customer['customerid']));
$customer['mysqls_used_new'] = (int) $customer_mysqls['number_mysqls'];
$customer_emails_stmt = Database::prepare('SELECT COUNT(*) AS `number_emails` FROM `' . TABLE_MAIL_VIRTUAL . '`
WHERE `customerid` = :cid');
$customer_emails = Database::pexecute_first($customer_emails_stmt, array("cid" => $customer['customerid']));
$customer['emails_used_new'] = (int) $customer_emails['number_emails'];
$customer_emails_result_stmt = Database::prepare('SELECT `email`, `email_full`, `destination`, `popaccountid` AS `number_email_forwarders` FROM `' . TABLE_MAIL_VIRTUAL . '`
WHERE `customerid` = :cid');
Database::pexecute($customer_emails_result_stmt, array("cid" => $customer['customerid']));
$customer_email_forwarders = 0;
$customer_email_accounts = 0;
while ($customer_emails_row = $customer_emails_result_stmt->fetch(PDO::FETCH_ASSOC)) {
if ($customer_emails_row['destination'] != '') {
$customer_emails_row['destination'] = explode(' ', makeCorrectDestination($customer_emails_row['destination']));
$customer_email_forwarders += count($customer_emails_row['destination']);
if (in_array($customer_emails_row['email_full'], $customer_emails_row['destination'])) {
$customer_email_forwarders -= 1;
$customer_email_accounts++;
}
}
}
$customer['email_accounts_used_new'] = $customer_email_accounts;
$customer['email_forwarders_used_new'] = $customer_email_forwarders;
$customer_ftps_stmt = Database::prepare('SELECT COUNT(*) AS `number_ftps` FROM `' . TABLE_FTP_USERS . '` WHERE `customerid` = :cid');
$customer_ftps = Database::pexecute_first($customer_ftps_stmt, array("cid" => $customer['customerid']));
$customer['ftps_used_new'] = (int) $customer_ftps['number_ftps'] - 1;
$customer_tickets_stmt = Database::prepare('SELECT COUNT(*) AS `number_tickets` FROM `' . TABLE_PANEL_TICKETS . '` WHERE `answerto` = "0" AND `customerid` = :cid');
$customer_tickets = Database::pexecute_first($customer_tickets_stmt, array("cid" => $customer['customerid']));
$customer['tickets_used_new'] = (int) $customer_tickets['number_tickets'];
$customer_subdomains_stmt = Database::prepare('SELECT COUNT(*) AS `number_subdomains` FROM `' . TABLE_PANEL_DOMAINS . '` WHERE `customerid` = :cid AND `parentdomainid` IS NOT NULL');
$customer_subdomains = Database::pexecute_first($customer_subdomains_stmt, array("cid" => $customer['customerid']));
$customer['subdomains_used_new'] = (int) $customer_subdomains['number_subdomains'];
$customer_email_quota_stmt = Database::prepare('SELECT SUM(`quota`) AS `email_quota` FROM `' . TABLE_MAIL_USERS . '` WHERE `customerid` = :cid');
$customer_email_quota = Database::pexecute_first($customer_email_quota_stmt, array("cid" => $customer['customerid']));
$customer['email_quota_used_new'] = (int) $customer_email_quota['email_quota'];
$stmt = Database::prepare('UPDATE `' . TABLE_PANEL_CUSTOMERS . '`
SET `mysqls_used` = :mysqls_used,
`emails_used` = :emails_used,
`email_accounts_used` = :email_accounts_used,
`email_forwarders_used` = :email_forwarders_used,
`email_quota_used` = :email_quota_used,
`ftps_used` = :ftps_used,
`tickets_used` = :tickets_used,
`subdomains_used` = :subdomains_used
WHERE `customerid` = :cid');
$params = array("mysqls_used" => $customer['mysqls_used_new'], "emails_used" => $customer['emails_used_new'], "email_accounts_used" => $customer['email_accounts_used_new'], "email_forwarders_used" => $customer['email_forwarders_used_new'], "email_quota_used" => $customer['email_quota_used_new'], "ftps_used" => $customer['ftps_used_new'], "tickets_used" => $customer['tickets_used_new'], "subdomains_used" => $customer['subdomains_used_new'], "cid" => $customer['customerid']);
Database::pexecute($stmt, $params);
if ($returndebuginfo === true) {
$returnval['customers'][$customer['customerid']] = $customer;
}
}
// Admins
$admins_stmt = Database::prepare('SELECT * FROM `' . TABLE_PANEL_ADMINS . '` ORDER BY `adminid`');
Database::pexecute($admins_stmt, array());
while ($admin = $admins_stmt->fetch(PDO::FETCH_ASSOC)) {
$admin_customers_stmt = Database::prepare('SELECT COUNT(*) AS `number_customers` FROM `' . TABLE_PANEL_CUSTOMERS . '` WHERE `adminid` = :aid');
$admin_customers = Database::pexecute_first($admin_customers_stmt, array("aid" => $admin['adminid']));
$admin['customers_used_new'] = $admin_customers['number_customers'];
$admin_domains_stmt = Database::prepare('SELECT COUNT(*) AS `number_domains` FROM `' . TABLE_PANEL_DOMAINS . '` WHERE `adminid` = :aid AND `isemaildomain` = "1"');
$admin_domains = Database::pexecute_first($admin_domains_stmt, array("aid" => $admin['adminid']));
$admin['domains_used_new'] = $admin_domains['number_domains'];
$cur_adm = $admin['adminid'];
if (!isset($admin_resources[$cur_adm])) {
$admin_resources[$cur_adm] = array();
}
foreach (array('diskspace_used', 'traffic_used', 'mysqls_used', 'ftps_used', 'emails_used', 'email_accounts_used', 'tickets_used', 'email_forwarders_used', 'email_quota_used', 'subdomains_used') as $field) {
_initArrField($field, $admin_resources[$cur_adm], 0);
$admin[$field . '_new'] = $admin_resources[$cur_adm][$field];
}
$stmt = Database::prepare('UPDATE `' . TABLE_PANEL_ADMINS . '`
SET `customers_used` = :customers_used,
`domains_used` = :domains_used,
`diskspace_used` = :diskspace_used,
`mysqls_used` = :mysqls_used,
`emails_used` = :emails_used,
`email_accounts_used` = :email_accounts_used,
`email_forwarders_used` = :email_forwarders_used,
`email_quota_used` = :email_quota_used,
`ftps_used` = :ftps_used,
`tickets_used` = :tickets_used,
`subdomains_used` = :subdomains_used,
`traffic_used` = :traffic_used
WHERE `adminid` = :aid');
$params = array("customers_used" => $admin['customers_used_new'], "domains_used" => $admin['domains_used_new'], "diskspace_used" => $admin['diskspace_used_new'], "mysqls_used" => $admin['mysqls_used_new'], "emails_used" => $admin['emails_used_new'], "email_accounts_used" => $admin['email_accounts_used_new'], "email_forwarders_used" => $admin['email_forwarders_used_new'], "email_quota_used" => $admin['email_quota_used_new'], "ftps_used" => $admin['ftps_used_new'], "tickets_used" => $admin['tickets_used_new'], "subdomains_used" => $admin['subdomains_used_new'], "traffic_used" => $admin['traffic_used_new'], "aid" => $admin['adminid']);
Database::pexecute($stmt, $params);
if ($returndebuginfo === true) {
$returnval['admins'][$admin['adminid']] = $admin;
}
}
return $returnval;
}
} elseif ($action == 'delete' && $id != 0) {
$stmt = Database::prepare("SELECT `id`, `email`, `email_full`, `iscatchall`, `destination`, `customerid`, `popaccountid` FROM `" . TABLE_MAIL_VIRTUAL . "`\n\t\t\tWHERE `customerid`='" . (int) $userinfo['customerid'] . "'\n\t\t\tAND `id`='" . (int) $id . "'");
$result = Database::pexecute_first($stmt, array("cid" => $userinfo['customerid']));
if (isset($result['destination']) && $result['destination'] != '') {
if (isset($_POST['forwarderid'])) {
$forwarderid = intval($_POST['forwarderid']);
} elseif (isset($_GET['forwarderid'])) {
$forwarderid = intval($_GET['forwarderid']);
} else {
$forwarderid = 0;
}
$result['destination'] = explode(' ', $result['destination']);
if (isset($result['destination'][$forwarderid]) && $result['email'] != $result['destination'][$forwarderid]) {
$forwarder = $result['destination'][$forwarderid];
if (isset($_POST['send']) && $_POST['send'] == 'send') {
unset($result['destination'][$forwarderid]);
$result['destination'] = implode(' ', $result['destination']);
$stmt = Database::prepare("UPDATE `" . TABLE_MAIL_VIRTUAL . "`\n\t\t\t\t\t\tSET `destination` = :dest\n\t\t\t\t\t\tWHERE `customerid`= :cid\n\t\t\t\t\t\tAND `id`= :id");
$params = array("dest" => makeCorrectDestination($result['destination']), "cid" => $userinfo['customerid'], "id" => $id);
Database::pexecute($stmt, $params);
$stmt = Database::prepare("UPDATE `" . TABLE_PANEL_CUSTOMERS . "`\n\t\t\t\t\t\tSET `email_forwarders_used` = `email_forwarders_used` - 1\n\t\t\t\t\t\tWHERE `customerid`= :cid");
Database::pexecute($stmt, array("cid" => $userinfo['customerid']));
$log->logAction(USR_ACTION, LOG_NOTICE, "deleted email forwarder for '" . $result['email_full'] . "'");
redirectTo($filename, array('page' => 'emails', 'action' => 'edit', 'id' => $id, 's' => $s));
} else {
ask_yesno('email_reallydelete_forwarder', $filename, array('id' => $id, 'forwarderid' => $forwarderid, 'page' => $page, 'action' => $action), $idna_convert->decode($result['email_full']) . ' -> ' . $idna_convert->decode($forwarder));
}
}
}
}
}
/**
* Function which updates all counters of used ressources in panel_admins and panel_customers
* @param bool Set to true to get an array with debug information
* @return array Contains debug information if parameter 'returndebuginfo' is set to true
*
* @author Florian Lippert <*****@*****.**> (2003-2009)
* @author Froxlor team <*****@*****.**> (2010-)
*/
function updateCounters($returndebuginfo = false)
{
global $db;
$returnval = array();
if ($returndebuginfo === true) {
$returnval = array('admins' => array(), 'customers' => array());
}
$admin_resources = array();
// Customers
$customers = $db->query('SELECT * FROM `' . TABLE_PANEL_CUSTOMERS . '` ORDER BY `customerid`');
while ($customer = $db->fetch_array($customers)) {
if (!isset($admin_resources[$customer['adminid']])) {
$admin_resources[$customer['adminid']] = array();
}
if (!isset($admin_resources[$customer['adminid']]['diskspace_used'])) {
$admin_resources[$customer['adminid']]['diskspace_used'] = 0;
}
if ($customer['diskspace'] / 1024 != '-1') {
$admin_resources[$customer['adminid']]['diskspace_used'] += intval_ressource($customer['diskspace']);
}
if (!isset($admin_resources[$customer['adminid']]['traffic_used'])) {
$admin_resources[$customer['adminid']]['traffic_used'] = 0;
}
$admin_resources[$customer['adminid']]['traffic_used'] += $customer['traffic_used'];
if (!isset($admin_resources[$customer['adminid']]['mysqls_used'])) {
$admin_resources[$customer['adminid']]['mysqls_used'] = 0;
}
if ($customer['mysqls'] != '-1') {
$admin_resources[$customer['adminid']]['mysqls_used'] += intval_ressource($customer['mysqls']);
}
if (!isset($admin_resources[$customer['adminid']]['ftps_used'])) {
$admin_resources[$customer['adminid']]['ftps_used'] = 0;
}
if ($customer['ftps'] != '-1') {
$admin_resources[$customer['adminid']]['ftps_used'] += intval_ressource($customer['ftps']);
}
if (!isset($admin_resources[$customer['adminid']]['tickets_used'])) {
$admin_resources[$customer['adminid']]['tickets_used'] = 0;
}
if ($customer['tickets'] != '-1') {
$admin_resources[$customer['adminid']]['tickets_used'] += intval_ressource($customer['tickets']);
}
if (!isset($admin_resources[$customer['adminid']]['emails_used'])) {
$admin_resources[$customer['adminid']]['emails_used'] = 0;
}
if ($customer['emails'] != '-1') {
$admin_resources[$customer['adminid']]['emails_used'] += intval_ressource($customer['emails']);
}
if (!isset($admin_resources[$customer['adminid']]['email_accounts_used'])) {
$admin_resources[$customer['adminid']]['email_accounts_used'] = 0;
}
if ($customer['email_accounts'] != '-1') {
$admin_resources[$customer['adminid']]['email_accounts_used'] += intval_ressource($customer['email_accounts']);
}
if (!isset($admin_resources[$customer['adminid']]['email_forwarders_used'])) {
$admin_resources[$customer['adminid']]['email_forwarders_used'] = 0;
}
if ($customer['email_forwarders'] != '-1') {
$admin_resources[$customer['adminid']]['email_forwarders_used'] += intval_ressource($customer['email_forwarders']);
}
if (!isset($admin_resources[$customer['adminid']]['email_quota_used'])) {
$admin_resources[$customer['adminid']]['email_quota_used'] = 0;
}
if ($customer['email_quota'] != '-1') {
$admin_resources[$customer['adminid']]['email_quota_used'] += intval_ressource($customer['email_quota']);
}
if (!isset($admin_resources[$customer['adminid']]['email_autoresponder_used'])) {
$admin_resources[$customer['adminid']]['email_autoresponder_used'] = 0;
}
if ($customer['email_autoresponder'] != '-1') {
$admin_resources[$customer['adminid']]['email_autoresponder_used'] += intval_ressource($customer['email_autoresponder']);
}
if (!isset($admin_resources[$customer['adminid']]['subdomains_used'])) {
$admin_resources[$customer['adminid']]['subdomains_used'] = 0;
}
if ($customer['subdomains'] != '-1') {
$admin_resources[$customer['adminid']]['subdomains_used'] += intval_ressource($customer['subdomains']);
}
if (!isset($admin_resources[$customer['adminid']]['aps_packages_used'])) {
$admin_resources[$customer['adminid']]['aps_packages_used'] = 0;
}
if ($customer['aps_packages'] != '-1') {
$admin_resources[$customer['adminid']]['aps_packages_used'] += intval_ressource($customer['aps_packages']);
}
$customer_mysqls = $db->query_first('SELECT COUNT(*) AS `number_mysqls` FROM `' . TABLE_PANEL_DATABASES . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['mysqls_used_new'] = (int) $customer_mysqls['number_mysqls'];
$customer_emails = $db->query_first('SELECT COUNT(*) AS `number_emails` FROM `' . TABLE_MAIL_VIRTUAL . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['emails_used_new'] = (int) $customer_emails['number_emails'];
$customer_emails_result = $db->query('SELECT `email`, `email_full`, `destination`, `popaccountid` AS `number_email_forwarders` FROM `' . TABLE_MAIL_VIRTUAL . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '" ');
$customer_email_forwarders = 0;
$customer_email_accounts = 0;
while ($customer_emails_row = $db->fetch_array($customer_emails_result)) {
if ($customer_emails_row['destination'] != '') {
$customer_emails_row['destination'] = explode(' ', makeCorrectDestination($customer_emails_row['destination']));
$customer_email_forwarders += count($customer_emails_row['destination']);
if (in_array($customer_emails_row['email_full'], $customer_emails_row['destination'])) {
$customer_email_forwarders -= 1;
$customer_email_accounts++;
}
}
}
$customer['email_accounts_used_new'] = $customer_email_accounts;
$customer['email_forwarders_used_new'] = $customer_email_forwarders;
$customer_ftps = $db->query_first('SELECT COUNT(*) AS `number_ftps` FROM `' . TABLE_FTP_USERS . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['ftps_used_new'] = (int) $customer_ftps['number_ftps'] - 1;
$customer_tickets = $db->query_first('SELECT COUNT(*) AS `number_tickets` FROM `' . TABLE_PANEL_TICKETS . '` WHERE `answerto` = "0" AND `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['tickets_used_new'] = (int) $customer_tickets['number_tickets'];
$customer_subdomains = $db->query_first('SELECT COUNT(*) AS `number_subdomains` FROM `' . TABLE_PANEL_DOMAINS . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '" AND `parentdomainid` <> "0"');
$customer['subdomains_used_new'] = (int) $customer_subdomains['number_subdomains'];
$customer_email_quota = $db->query_first('SELECT SUM(`quota`) AS `email_quota` FROM `' . TABLE_MAIL_USERS . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['email_quota_used_new'] = (int) $customer_email_quota['email_quota'];
$customer_email_autoresponder = $db->query_first('SELECT COUNT(*) AS `number_autoresponder` FROM `' . TABLE_MAIL_AUTORESPONDER . '` WHERE `customerid` = "' . (int) $customer['customerid'] . '"');
$customer['email_autoresponder_used_new'] = (int) $customer_email_autoresponder['number_autoresponder'];
$customer_aps_packages = $db->query_first('SELECT COUNT(*) AS `number_apspackages` FROM `' . TABLE_APS_INSTANCES . '` WHERE `CustomerID` = "' . (int) $customer['customerid'] . '"');
$customer['aps_packages_used_new'] = (int) $customer_aps_packages['number_apspackages'];
$db->query('UPDATE
`' . TABLE_PANEL_CUSTOMERS . '`
SET
`mysqls_used` = "' . (int) $customer['mysqls_used_new'] . '",
`emails_used` = "' . (int) $customer['emails_used_new'] . '",
`email_accounts_used` = "' . (int) $customer['email_accounts_used_new'] . '",
`email_forwarders_used` = "' . (int) $customer['email_forwarders_used_new'] . '",
`email_quota_used` = "' . (int) $customer['email_quota_used_new'] . '",
`email_autoresponder_used` = "' . (int) $customer['email_autoresponder_used_new'] . '",
`ftps_used` = "' . (int) $customer['ftps_used_new'] . '",
`tickets_used` = "' . (int) $customer['tickets_used_new'] . '",
`subdomains_used` = "' . (int) $customer['subdomains_used_new'] . '",
`aps_packages_used` = "' . (int) $customer['aps_packages_used_new'] . '"
WHERE
`customerid` = "' . (int) $customer['customerid'] . '"
');
if ($returndebuginfo === true) {
$returnval['customers'][$customer['customerid']] = $customer;
}
}
// Admins
$admins = $db->query('SELECT * FROM `' . TABLE_PANEL_ADMINS . '` ORDER BY `adminid`');
while ($admin = $db->fetch_array($admins)) {
$admin_customers = $db->query_first('SELECT COUNT(*) AS `number_customers` FROM `' . TABLE_PANEL_CUSTOMERS . '` WHERE `adminid` = "' . (int) $admin['adminid'] . '"');
$admin['customers_used_new'] = $admin_customers['number_customers'];
$admin_domains = $db->query_first('SELECT COUNT(*) AS `number_domains` FROM `' . TABLE_PANEL_DOMAINS . '` WHERE `adminid` = "' . (int) $admin['adminid'] . '" AND `isemaildomain` = "1"');
$admin['domains_used_new'] = $admin_domains['number_domains'];
if (!isset($admin_resources[$admin['adminid']])) {
$admin_resources[$admin['adminid']] = array();
}
if (!isset($admin_resources[$admin['adminid']]['diskspace_used'])) {
$admin_resources[$admin['adminid']]['diskspace_used'] = 0;
}
$admin['diskspace_used_new'] = $admin_resources[$admin['adminid']]['diskspace_used'];
if (!isset($admin_resources[$admin['adminid']]['traffic_used'])) {
$admin_resources[$admin['adminid']]['traffic_used'] = 0;
}
$admin['traffic_used_new'] = $admin_resources[$admin['adminid']]['traffic_used'];
if (!isset($admin_resources[$admin['adminid']]['mysqls_used'])) {
$admin_resources[$admin['adminid']]['mysqls_used'] = 0;
}
$admin['mysqls_used_new'] = $admin_resources[$admin['adminid']]['mysqls_used'];
if (!isset($admin_resources[$admin['adminid']]['ftps_used'])) {
$admin_resources[$admin['adminid']]['ftps_used'] = 0;
}
$admin['ftps_used_new'] = $admin_resources[$admin['adminid']]['ftps_used'];
if (!isset($admin_resources[$admin['adminid']]['emails_used'])) {
$admin_resources[$admin['adminid']]['emails_used'] = 0;
}
$admin['emails_used_new'] = $admin_resources[$admin['adminid']]['emails_used'];
if (!isset($admin_resources[$admin['adminid']]['email_accounts_used'])) {
$admin_resources[$admin['adminid']]['email_accounts_used'] = 0;
}
$admin['email_accounts_used_new'] = $admin_resources[$admin['adminid']]['email_accounts_used'];
if (!isset($admin_resources[$admin['adminid']]['tickets_used'])) {
$admin_resources[$admin['adminid']]['tickets_used'] = 0;
}
$admin['tickets_used_new'] = $admin_resources[$admin['adminid']]['tickets_used'];
if (!isset($admin_resources[$admin['adminid']]['email_forwarders_used'])) {
$admin_resources[$admin['adminid']]['email_forwarders_used'] = 0;
}
$admin['email_forwarders_used_new'] = $admin_resources[$admin['adminid']]['email_forwarders_used'];
if (!isset($admin_resources[$admin['adminid']]['email_quota_used'])) {
$admin_resources[$admin['adminid']]['email_quota_used'] = 0;
}
$admin['email_quota_used_new'] = $admin_resources[$admin['adminid']]['email_quota_used'];
if (!isset($admin_resources[$admin['adminid']]['email_autoresponder_used'])) {
$admin_resources[$admin['adminid']]['email_autoresponder_used'] = 0;
}
if (!isset($admin_resources[$admin['adminid']]['email_autoresponder_used'])) {
$admin_resources[$admin['adminid']]['email_autoresponder_used'] = 0;
}
$admin['email_autoresponder_used_new'] = $admin_resources[$admin['adminid']]['email_autoresponder_used'];
if (!isset($admin_resources[$admin['adminid']]['subdomains_used'])) {
$admin_resources[$admin['adminid']]['subdomains_used'] = 0;
}
if (!isset($admin_resources[$admin['adminid']]['aps_packages_used'])) {
$admin_resources[$admin['adminid']]['aps_packages_used'] = 0;
}
$admin['subdomains_used_new'] = $admin_resources[$admin['adminid']]['subdomains_used'];
if (!isset($admin_resources[$admin['adminid']]['aps_packages_used'])) {
$admin_resources[$admin['adminid']]['aps_packages_used'] = 0;
}
$admin['aps_packages_used_new'] = $admin_resources[$admin['adminid']]['aps_packages_used'];
$db->query('UPDATE
`' . TABLE_PANEL_ADMINS . '`
SET
`customers_used` = "' . (int) $admin['customers_used_new'] . '",
`domains_used` = "' . (int) $admin['domains_used_new'] . '",
`diskspace_used` = "' . (int) $admin['diskspace_used_new'] . '",
`mysqls_used` = "' . (int) $admin['mysqls_used_new'] . '",
`emails_used` = "' . (int) $admin['emails_used_new'] . '",
`email_accounts_used` = "' . (int) $admin['email_accounts_used_new'] . '",
`email_forwarders_used` = "' . (int) $admin['email_forwarders_used_new'] . '",
`email_quota_used` = "' . (int) $admin['email_quota_used_new'] . '",
`email_autoresponder_used` = "' . (int) $admin['email_autoresponder_used_new'] . '",
`ftps_used` = "' . (int) $admin['ftps_used_new'] . '",
`tickets_used` = "' . (int) $admin['tickets_used_new'] . '",
`subdomains_used` = "' . (int) $admin['subdomains_used_new'] . '",
`traffic_used` = "' . (int) $admin['traffic_used_new'] . '",
`aps_packages_used` = "' . (int) $admin['aps_packages_used_new'] . '"
WHERE
`adminid` = "' . (int) $admin['adminid'] . '"
');
if ($returndebuginfo === true) {
$returnval['admins'][$admin['adminid']] = $admin;
}
}
return $returnval;
}
