From e6c4c7796f5bfb215e4fe36dfebc65f9a40e3408 Mon Sep 17 00:00:00 2001 From: ftimme <ft@falkotimme.com> Date: Wed, 14 Nov 2012 07:00:12 -0500 Subject: [PATCH] - Removed billing module cron jobs from cron_daily.sh and added billing module container cron job script cron_daily_billing.sh which contains all billing module related daily cron jobs. --- interface/web/sites/ajax_get_json.php | 37 +++++++++++++++++++++++++++++++++---- 1 files changed, 33 insertions(+), 4 deletions(-) diff --git a/interface/web/sites/ajax_get_json.php b/interface/web/sites/ajax_get_json.php index 14eb440..1194596 100644 --- a/interface/web/sites/ajax_get_json.php +++ b/interface/web/sites/ajax_get_json.php @@ -36,8 +36,8 @@ $app->uses('getconf'); -$server_id = intval($_GET["server_id"]); -$web_id = intval($_GET["web_id"]); +$server_id = $app->functions->intval($_GET["server_id"]); +$web_id = $app->functions->intval($_GET["web_id"]); $php_type = $_GET["php_type"]; $type = $_GET["type"]; @@ -100,11 +100,20 @@ $json .= '"}'; } + if($type == 'getredirecttype'){ + $json = '{"redirecttype":"'; + $sql = "SELECT redirect_type FROM web_domain WHERE domain_id = $web_id"; + $redirect = $app->db->queryOneRecord($sql); + $json .= $redirect['redirect_type']; + unset($redirect); + $json .= '"}'; + } + if($type == 'get_ipv4'){ $result = array(); // ipv4 - //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv4' AND (client_id = 0 OR client_id=".intval($_SESSION['s']['user']['client_id']).")"); + //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv4' AND (client_id = 0 OR client_id=".$app->functions->intval($_SESSION['s']['user']['client_id']).")"); $result[] = $app->functions->suggest_ips('IPv4'); $json = $app->functions->json_encode($result); @@ -114,11 +123,31 @@ $result = array(); // ipv6 - //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv6' AND (client_id = 0 OR client_id=".intval($_SESSION['s']['user']['client_id']).")"); + //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv6' AND (client_id = 0 OR client_id=".$app->functions->intval($_SESSION['s']['user']['client_id']).")"); $result[] = $app->functions->suggest_ips('IPv6'); $json = $app->functions->json_encode($result); } + + if($type == 'getdatabaseusers') { + $json = '{'; + + $sql = "SELECT sys_groupid FROM web_domain WHERE domain_id = $web_id"; + $group = $app->db->queryOneRecord($sql); + if($group) { + $sql = "SELECT database_user_id, database_user FROM web_database_user WHERE sys_groupid = '" . $group['sys_groupid'] . "'"; + $records = $app->db->queryAllRecords($sql); + + foreach($records as $record) { + $json .= '"'.$record['database_user_id'].'": "'.$record['database_user'].'",'; + } + unset($records); + unset($group); + } + + if(substr($json,-1) == ',') $json = substr($json,0,-1); + $json .= '}'; + } //} -- Gitblit v1.9.1