| | |
| | | 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; |
| | | } |
| | | |
| | |
| | | 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; |