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/rank.php | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'html/pages/rank.php')

diff --git a/html/pages/rank.php b/html/pages/rank.php
index 4be751e..10d1409 100755
--- a/html/pages/rank.php
+++ b/html/pages/rank.php
@@ -1,8 +1,8 @@
 <?php
 $sql_rgame = "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_rgame = mysql_query($sql_rgame) or die(mysql_error());
+$q_rgame = mysqli_query($GLOBALS["___mysqli_link"], $sql_rgame) or die(mysqli_error($GLOBALS["___mysqli_link"]));
 
-while ($r_rgame = mysql_fetch_array($q_rgame)) {
+while ($r_rgame = mysqli_fetch_array($q_rgame)) {
 
     echo'
     <table class="box zebra" border="0" cellpadding="0" cellspacing="0" width="700">
@@ -21,9 +21,9 @@ while ($r_rgame = mysql_fetch_array($q_rgame)) {
   $ranking = 0;
 
   $sql_rplayer = "SELECT pi.id AS pid, pi.name, pi.country, r.rank, r.prevrank, r.matches FROM uts_rank AS r, uts_pinfo AS pi WHERE r.pid = pi.id AND r.gid =  '$r_rgame[gid]' AND pi.banned <> 'Y' ORDER BY r.rank DESC LIMIT 0,10";
-  $q_rplayer = mysql_query($sql_rplayer) or die(mysql_error());
+  $q_rplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_rplayer) or die(mysqli_error($GLOBALS["___mysqli_link"]));
 
-  if (mysql_num_rows($q_rplayer) == 0) {
+  if (mysqli_num_rows($q_rplayer) == 0) {
     echo '
     <tr>
 	    <th align="center" colspan = "4">No players entered the rankings yet.</th>
@@ -35,7 +35,7 @@ while ($r_rgame = mysql_fetch_array($q_rgame)) {
 		<br>';
   }
   else {
-    while ($r_rplayer = mysql_fetch_array($q_rplayer)) {
+    while ($r_rplayer = mysqli_fetch_array($q_rplayer)) {
 
       $ranking++;
       $myurl = urlencode($r_rplayer[name]);
-- 
cgit