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/players.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'html/pages/players.php') diff --git a/html/pages/players.php b/html/pages/players.php index b038405..323eb4f 100755 --- a/html/pages/players.php +++ b/html/pages/players.php @@ -100,9 +100,9 @@ echo' $sql_plist = "SELECT pi.name AS name, pi.country AS country, p.pid, COUNT(p.id) AS games, SUM(p.gamescore) as gamescore, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.deaths) AS deaths, SUM(p.suicides) as suicides, AVG(p.eff) AS eff, AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, SUM(gametime) as gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY p.pid ORDER BY $filter $sort LIMIT $qpage,50"; -$q_plist = mysql_query($sql_plist) or die(mysql_error()); +$q_plist = mysqli_query($GLOBALS["___mysqli_link"], $sql_plist) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_plist = mysql_fetch_array($q_plist)) { +while ($r_plist = mysqli_fetch_array($q_plist)) { $gametime = sec2hour($r_plist[gametime]); $eff = get_dp($r_plist[eff]); $acc = get_dp($r_plist[accuracy]); -- cgit