From 7e5c50603cbe1307d68a2b5b8ee14409e15a9dcb Mon Sep 17 00:00:00 2001
From: Matthijs Kuiper <info@matthijskuiper.nl>
Date: Sun, 14 Jan 2018 20:08:50 +0100
Subject: Update to mysqli

---
 html/pages/admin/recalcflags.php | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'html/pages/admin/recalcflags.php')

diff --git a/html/pages/admin/recalcflags.php b/html/pages/admin/recalcflags.php
index 2c88610..228247e 100644
--- a/html/pages/admin/recalcflags.php
+++ b/html/pages/admin/recalcflags.php
@@ -39,27 +39,27 @@ echo'</tr>
 
 	echo'Recalculating pinfo table...<br>';
 	/* update pinfo table */
-	$sql_pids = mysql_query("SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysql_error());
-		while($sql_pid = mysql_fetch_array($sql_pids))
+	$sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysqli_error($GLOBALS["___mysqli_link"]));
+		while($sql_pid = mysqli_fetch_array($sql_pids))
 		{
 			$playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip'])));
 
 			if ($playercountry != $sql_pid['country'] )
 			{
-				mysql_query("UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysql_error());
+				mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"]));
 			}
 		}
 
 	echo'Recalculating player table...<br>';
 	/* update player table */
-	$sql_pids = mysql_query("SELECT pid, ip, country FROM uts_player");
-		while ($sql_pid = mysql_fetch_array($sql_pids))
+	$sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT pid, ip, country FROM uts_player");
+		while ($sql_pid = mysqli_fetch_array($sql_pids))
 		{
 			$playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip'])));
 
 			if ($playercountry != $sql_pid['country'])
 			{
-				mysql_query("UPDATE uts_player SET country = '$playercountry' WHERE pid = '".$sql_pid['pid']."'") or die(mysql_error());
+				mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player SET country = '$playercountry' WHERE pid = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"]));
 			}
 		}
 	echo 'Done</td>
-- 
cgit