From cc7a82756b4f4d7ab18e928527c37489adbaf564 Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Tue, 07 Apr 2015 14:10:50 -0400
Subject: [PATCH] - rewrite of sql queries to new form

---
 interface/web/sites/ajax_get_ip.php |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/interface/web/sites/ajax_get_ip.php b/interface/web/sites/ajax_get_ip.php
index 4101a80..c50c1ba 100644
--- a/interface/web/sites/ajax_get_ip.php
+++ b/interface/web/sites/ajax_get_ip.php
@@ -44,8 +44,8 @@
 	//* Get global web config
 	$web_config = $app->getconf->get_server_config($server_id, 'web');
 
-	$sql = "SELECT ip_address FROM server_ip WHERE ip_type = '$ip_type' AND server_id = $server_id";
-	$ips = $app->db->queryAllRecords($sql);
+	$sql = "SELECT ip_address FROM server_ip WHERE ip_type = ? AND server_id = ?";
+	$ips = $app->db->queryAllRecords($sql, $ip_type, $server_id);
 	// $ip_select = "<option value=''></option>";
 	if($ip_type == 'IPv4'){
 		$ip_select = ($web_config['enable_ip_wildcard'] == 'y')?"*#":"";

--
Gitblit v1.9.1