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/report_cb.php | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'html/pages/report_cb.php') diff --git a/html/pages/report_cb.php b/html/pages/report_cb.php index 50eb5d4..97493eb 100644 --- a/html/pages/report_cb.php +++ b/html/pages/report_cb.php @@ -28,16 +28,16 @@ echo'
'; $sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC"; -$q_rteam = mysql_query($sql_rteam); -while ($r_rteam = mysql_fetch_array($q_rteam)) { +$q_rteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_rteam); +while ($r_rteam = mysqli_fetch_array($q_rteam)) { echo''.$r_rteam[name].'
'; } echo'
'; $sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC"; -$q_bteam = mysql_query($sql_bteam); -while ($r_bteam = mysql_fetch_array($q_bteam)) { +$q_bteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_bteam); +while ($r_bteam = mysqli_fetch_array($q_bteam)) { echo''.$r_bteam[name].'
'; } echo'

'; @@ -120,8 +120,8 @@ IF ($stage == "2") { $sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC"; - $q_rteam = mysql_query($sql_rteam); - while($r_rteam = mysql_fetch_array($q_rteam)) { + $q_rteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_rteam); + while($r_rteam = mysqli_fetch_array($q_rteam)) { echo' '.$r_rteam[name].' @@ -142,8 +142,8 @@ IF ($stage == "2") { $sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC"; - $q_bteam = mysql_query($sql_bteam); - while($r_bteam = mysql_fetch_array($q_bteam)) { + $q_bteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_bteam); + while($r_bteam = mysqli_fetch_array($q_bteam)) { echo' '.$r_bteam[name].' -- cgit