diff options
author | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-01-14 20:08:50 +0100 |
---|---|---|
committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-09-01 11:48:28 +0200 |
commit | 7e5c50603cbe1307d68a2b5b8ee14409e15a9dcb (patch) | |
tree | 0fff0499b4d94f8ed2e13d72bfd97dec51cd283e /html/pages/players_search.php | |
parent | 4d21dfcac97fd02c186bb3ce4085275b36e3790e (diff) |
Update to mysqli
Diffstat (limited to 'html/pages/players_search.php')
-rw-r--r-- | html/pages/players_search.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/html/pages/players_search.php b/html/pages/players_search.php index 133f46c..f40bfde 100644 --- a/html/pages/players_search.php +++ b/html/pages/players_search.php @@ -61,8 +61,8 @@ $sql_plist = "SELECT pi.name AS name, pi.country AS country, p.pid, COUNT(p.id) 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.name LIKE '%".$playersearch."%' AND pi.banned <> 'Y' GROUP BY name ORDER BY $filter $sort";
-$q_plist = mysql_query($sql_plist) or die(mysql_error());
-while ($r_plist = mysql_fetch_array($q_plist)) {
+$q_plist = mysqli_query($GLOBALS["___mysqli_link"], $sql_plist) or die(mysqli_error($GLOBALS["___mysqli_link"]));
+while ($r_plist = mysqli_fetch_array($q_plist)) {
$gametime = sec2hour($r_plist[gametime]);
$eff = get_dp($r_plist[eff]);
|