From 7e5c50603cbe1307d68a2b5b8ee14409e15a9dcb Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Sun, 14 Jan 2018 20:08:50 +0100 Subject: Update to mysqli --- html/pages/admin/ipsearch.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'html/pages/admin/ipsearch.php') diff --git a/html/pages/admin/ipsearch.php b/html/pages/admin/ipsearch.php index fcfe17f..6db94dc 100644 --- a/html/pages/admin/ipsearch.php +++ b/html/pages/admin/ipsearch.php @@ -29,17 +29,17 @@ echo'
$sql_players = "SELECT pi.name, pi.id AS pid FROM uts_player p, uts_pinfo pi WHERE p.pid = pi.id AND p.ip BETWEEN INET_ATON('$ip_from') AND INET_ATON('$ip_to') GROUP BY pid"; -$q_players = mysql_query($sql_players) or die(mysql_error()); +$q_players = mysqli_query($GLOBALS["___mysqli_link"], $sql_players) or die(mysqli_error($GLOBALS["___mysqli_link"])); $j = 0; -while ($r_players = mysql_fetch_array($q_players)) { +while ($r_players = mysqli_fetch_array($q_players)) { echo ''; echo ''; $sql_recent = "SELECT m.time AS time, m.id AS mid, INET_NTOA(p.ip) AS ip FROM uts_player p, uts_match m WHERE m.id = p.matchid AND p.pid = '${r_players['pid']}' AND p.ip BETWEEN INET_ATON('$ip_from') AND INET_ATON('$ip_to') ORDER BY m.time DESC LIMIT 0,5"; echo '
'; echo ''.$r_players['name'].''; echo ''; - $q_recent= mysql_query($sql_recent) or die(mysql_error()); - while ($r_recent = mysql_fetch_array($q_recent)) { + $q_recent= mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_recent = mysqli_fetch_array($q_recent)) { $j++; $class = ($j%2) ? 'grey' : 'grey2'; echo '
'; -- cgit