| | |
| | | throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.'); |
| | | return false; |
| | | } |
| | | $sql = "SELECT server_id FROM server_ip WHERE ip_address = '$ipaddress' LIMIT 1 "; |
| | | $all = $app->db->queryAllRecords($sql); |
| | | $sql = "SELECT server_id FROM server_ip WHERE ip_address = ? LIMIT 1"; |
| | | $all = $app->db->queryAllRecords($sql, $ipaddress); |
| | | return $all; |
| | | } |
| | | |
| | |
| | | */ |
| | | |
| | | |
| | | public function server_get($session_id, $server_id, $section ='') { |
| | | public function server_get($session_id, $server_id = null, $section ='') { |
| | | global $app; |
| | | if(!$this->checkPerm($session_id, 'server_get')) { |
| | | $this->server->fault('permission_denied', 'You do not have the permissions to access this function.'); |
| | | return false; |
| | | } |
| | | if (!empty($session_id)) { |
| | | $app->uses('remoting_lib , getconf'); |
| | | if(!empty($server_id)) { |
| | | $section_config = $app->getconf->get_server_config($server_id, $section); |
| | | return $section_config; |
| | | } else { |
| | | $servers = array(); |
| | | $sql = "SELECT server_id FROM server WHERE 1"; |
| | | $all = $app->db->queryAllRecords($sql); |
| | | foreach($all as $s) { |
| | | $servers[$s['server_id']] = $app->getconf->get_server_config($s['server_id'], $section); |
| | | } |
| | | unset($all); |
| | | unset($s); |
| | | return $servers; |
| | | } |
| | | } else { |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | /** |
| | | Gets a list of all servers |
| | | @param int session_id |
| | | @param int server_name |
| | | @author Marius Cramer <m.cramer@pixcept.de> 2014 |
| | | */ |
| | | public function server_get_all($session_id) |
| | | { |
| | | global $app; |
| | | if(!$this->checkPerm($session_id, 'server_get')) { |
| | | $this->server->fault('permission_denied', 'You do not have the permissions to access this function.'); |
| | | return false; |
| | | } |
| | | if (!empty($session_id) && !empty($server_id)) { |
| | | $app->uses('remoting_lib , getconf'); |
| | | $section_config = $app->getconf->get_server_config($server_id, $section); |
| | | return $section_config; |
| | | if (!empty($session_id)) { |
| | | $sql = "SELECT server_id, server_name FROM server WHERE 1"; |
| | | $servers = $app->db->queryAllRecords($sql); |
| | | return $servers; |
| | | } else { |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | Gets the server_id by server_name |
| | | @param int session_id |
| | |
| | | return false; |
| | | } |
| | | if (!empty($session_id) && !empty($server_name)) { |
| | | $sql = "SELECT server_id FROM server WHERE server_name = '$server_name' LIMIT 1 "; |
| | | $all = $app->db->queryAllRecords($sql); |
| | | $sql = "SELECT server_id FROM server WHERE server_name = ? LIMIT 1"; |
| | | $all = $app->db->queryAllRecords($sql, $server_name); |
| | | return $all; |
| | | } else { |
| | | return false; |
| | |
| | | return false; |
| | | } |
| | | if (!empty($session_id) && !empty($server_id)) { |
| | | $sql = "SELECT mail_server, web_server, dns_server, file_server, db_server, vserver_server, proxy_server, firewall_server FROM server WHERE server_id = '$server_id' LIMIT 1 "; |
| | | $all = $app->db->queryAllRecords($sql); |
| | | $sql = "SELECT mail_server, web_server, dns_server, file_server, db_server, vserver_server, proxy_server, firewall_server FROM server WHERE server_id = ? LIMIT 1 "; |
| | | $all = $app->db->queryAllRecords($sql, $server_id); |
| | | return $all; |
| | | } else { |
| | | return false; |