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/maps.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'html/pages/maps.php') diff --git a/html/pages/maps.php b/html/pages/maps.php index bd1106e..4baa5f7 100644 --- a/html/pages/maps.php +++ b/html/pages/maps.php @@ -95,8 +95,8 @@ echo' '; $sql_game = "SELECT DISTINCT(p.gid), g.name FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id ORDER BY g.name ASC"; - $q_game = mysql_query($sql_game) or die(mysql_error()); - while ($r_game = mysql_fetch_array($q_game)) { + $q_game = mysqli_query($GLOBALS["___mysqli_link"], $sql_game) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_game = mysqli_fetch_array($q_game)) { $selected = ($r_game['gid'] == $gid) ? 'selected' : ''; echo ''; } @@ -120,9 +120,9 @@ echo ' $sql_maps = "SELECT IF(RIGHT(mapfile,4) LIKE '.unr', mapfile, CONCAT(mapfile, '.unr')) as mapfile, COUNT(id) AS matchcount, AVG(frags) AS frags, AVG(t0score+t1score+t2score+t3score) AS matchscore, SUM(gametime) AS gametime FROM uts_match" . $sql_condition . " GROUP BY mapfile ORDER BY $filter $sort LIMIT $qpage,25"; -$q_maps = mysql_query($sql_maps) or die(mysql_error()); +$q_maps = mysqli_query($GLOBALS["___mysqli_link"], $sql_maps) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_maps = mysql_fetch_array($q_maps)) { +while ($r_maps = mysqli_fetch_array($q_maps)) { $r_mapfile = un_ut($r_maps[mapfile]); $myurl = urlencode($r_mapfile); $r_gametime = GetMinutes($r_maps[gametime]); -- cgit