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/admin/check.php | 59 +++++------- html/pages/admin/dmatch.php | 34 +++---- html/pages/admin/dplayer.php | 24 ++--- html/pages/admin/dpmatch.php | 32 +++---- html/pages/admin/editgames.php | 12 +-- html/pages/admin/editgamestype.php | 36 ++++---- html/pages/admin/editweapons.php | 8 +- html/pages/admin/emptydb.php | 24 ++--- html/pages/admin/ipsearch.php | 8 +- html/pages/admin/main.php | 6 +- html/pages/admin/mplayers.php | 28 +++--- html/pages/admin/mservers.php | 2 +- html/pages/admin/pban.php | 12 +-- html/pages/admin/pinfo.php | 18 ++-- html/pages/admin/plm.php | 114 +++++++++++------------ html/pages/admin/recalcflags.php | 12 +-- html/pages/admin/recalcranking.php | 6 +- html/pages/credits.php | 2 +- html/pages/dpmatch.php | 30 +++--- html/pages/graph_mbreakdown.php | 16 ++-- html/pages/graph_pbreakdown.php | 12 +-- html/pages/home.php | 8 +- html/pages/maps.php | 8 +- html/pages/maps_info.php | 14 +-- html/pages/match_info_bt.php | 8 +- html/pages/match_info_charts.php | 10 +- html/pages/match_info_ctf.php | 16 ++-- html/pages/match_info_killsmatrix.php | 8 +- html/pages/match_info_lms.php | 4 +- html/pages/match_info_other.php | 8 +- html/pages/match_info_other2.php | 8 +- html/pages/players.php | 4 +- html/pages/players_explain_ranking.php | 4 +- html/pages/players_info.php | 163 +++++++++++++++++---------------- html/pages/players_search.php | 4 +- html/pages/rank.php | 10 +- html/pages/rank_extended.php | 4 +- html/pages/recent.php | 12 +-- html/pages/report/bbcode.php | 8 +- html/pages/report/clanbase.php | 8 +- html/pages/report_cb.php | 16 ++-- html/pages/servers.php | 4 +- html/pages/servers_info.php | 8 +- html/pages/totals.php | 28 +++--- html/pages/watchlist.php | 4 +- 45 files changed, 428 insertions(+), 436 deletions(-) (limited to 'html/pages') diff --git a/html/pages/admin/check.php b/html/pages/admin/check.php index 125a282..80dee0e 100755 --- a/html/pages/admin/check.php +++ b/html/pages/admin/check.php @@ -10,44 +10,37 @@ echo ' // Check access rights echo ' - +
'; // directories -foreach (array("logs", "logs/ac", "logs/backup", "logs/utdc", "logs/ace") as $dir) -{ +foreach (array("logs", "logs/ac", "logs/backup", "logs/utdc", "logs/ace") as $dir) { echo ' '; if (!file_exists($dir)) { if (mkdir($dir, 0777)) { - echo ' - '; + echo ''; } else { - echo ' - '; + echo ''; } } else if (!is_dir($dir)) { - echo ' - '; + echo ''; } else if (!is_writable($dir)) { if (@chmod($dir, 0777)) { - echo ' - '; + echo ''; } else { - echo ' - '; + echo ''; } } else { - echo ' - '; + echo ''; } } @@ -58,39 +51,33 @@ foreach (array("includes/ftptimestamp.php") as $file) '; if (!file_exists($file)) { - echo ' - '; + echo ''; } else if (!is_file($file)) { - echo ' - '; + echo ''; } else if (!is_writable($file)) { if (@chmod($file, 0777)) { - echo ' - '; + echo ''; } else { - echo ' - '; + echo ''; } } else { - echo ' - '; + echo ''; } } -echo ' -
Checking access rights
', $dir, 'Created
Created
Not found!
Not found!
Not a directory!
Not a directory!
SET
SET
Incorrect access rights: ' , substr(sprintf('%o', fileperms($dir)), -4) , '
Incorrect access rights: ' , substr(sprintf('%o', fileperms($dir)), -4) , '
OK
OK
', $file, 'Not found!
Not found!
Not a file!
Not a file!
SET
SET
Incorrect access rights: ' , substr(sprintf('%o', fileperms($file)), -4) , '
Incorrect access rights: ' , substr(sprintf('%o', fileperms($file)), -4) , '
OK
OK
+echo '
* Might not work correctly on Windows systems *

'; // connect to the database and check structure echo ' - +
- + '; // database creation array @@ -337,7 +324,7 @@ foreach ($create_table as $table => $query) { '; } else { - if (mysql_query($query)) { + if (mysqli_query($GLOBALS["___mysqli_link"], $query)) { echo ' '; } @@ -349,7 +336,7 @@ foreach ($create_table as $table => $query) { } echo '
Checking mysql tablesChecking MySQL tables
OK
Created

'; - + // check graph types - have to use id since no other unique key except composite ones. $create_charttype['90'] = "INSERT INTO `uts_charttypes` VALUES (90, 'Frags Team', 'teamScore', 'team', 'title: {\ntext: ''Battle for #1''\n},\ncredits: {\nenabled: false\n}, \nlegend: {\nenabled: false\n}, \nxAxis: {\ntitle: '''',\nmin: 0\n}, \nyAxis: {\ntitle: '''',\nmin: 0\n},\nplotOptions : {\n line : {\n stickyTracking : false\n }\n}', 'line', 1);"; $create_charttype['20'] = "INSERT INTO `uts_charttypes` VALUES (20, 'Domination', 'teamScore', 'team', 'title: {\ntext: ''Score''\n},\ncredits: {\nenabled: false\n}, \nlegend: {\nenabled: false\n}, \nxAxis: {\ntitle: '''',\nmin: 0\n}, \nyAxis: {\ntitle: '''',\nmin: 0\n},\nplotOptions : {\n line : {\n stickyTracking : false\n }\n}', 'line', 1);"; @@ -389,7 +376,7 @@ else { OK'; } else { - if (mysql_query($query)) { + if (mysqli_query($GLOBALS["___mysqli_link"], $query)) { echo ' Added'; } @@ -442,7 +429,7 @@ else { OK'; } else { - if (mysql_query($query)) { + if (mysqli_query($GLOBALS["___mysqli_link"], $query)) { echo ' Added'; } @@ -466,8 +453,8 @@ echo ' Fix BT cap times'; - $q = mysql_query("UPDATE uts_events SET col3 = ROUND(CEILING((col3-1)*100/1.1) / 100, 2), col1 = 'btcap' WHERE col1 = 'cap'"); - $affected = mysql_affected_rows(); + $q = mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_events SET col3 = ROUND(CEILING((col3-1)*100/1.1) / 100, 2), col1 = 'btcap' WHERE col1 = 'cap'"); + $affected = mysqli_affected_rows($GLOBALS["___mysqli_link"]); if ($affected == -1) { echo ' @@ -486,4 +473,4 @@ echo ' echo 'Go Back To Admin Page'; echo ''; -?> \ No newline at end of file +?> diff --git a/html/pages/admin/dmatch.php b/html/pages/admin/dmatch.php index 3c7ebc5..4ad3bc1 100644 --- a/html/pages/admin/dmatch.php +++ b/html/pages/admin/dmatch.php @@ -27,9 +27,9 @@ echo'
'; $sql_radjust = "SELECT pid, gid, rank FROM uts_player WHERE matchid = $matchid"; -$q_radjust = mysql_query($sql_radjust) or die(mysql_error()); +$q_radjust = mysqli_query($GLOBALS["___mysqli_link"], $sql_radjust) or die(mysqli_error($GLOBALS["___mysqli_link"])); $pids = array(); -while ($r_radjust = mysql_fetch_array($q_radjust)) { +while ($r_radjust = mysqli_fetch_array($q_radjust)) { $pid = $r_radjust[pid]; $pids[] = $pid; @@ -44,57 +44,57 @@ while ($r_radjust = mysql_fetch_array($q_radjust)) { $oldrank = $sql_crank[rank]; $matchcount = $sql_crank[matches]-1; - mysql_query("UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysql_error()); - mysql_query("DELETE FROM uts_rank WHERE matches = 0") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE matches = 0") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; -mysql_query("DELETE FROM uts_match WHERE id = $matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_match WHERE id = $matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_player WHERE matchid = $matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_player WHERE matchid = $matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_killsmatrix WHERE matchid = $matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_killsmatrix WHERE matchid = $matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid = $matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid = $matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; foreach($pids as $pid) { - mysql_query("DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } echo''; - mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; -mysql_query("DELETE FROM uts_events WHERE matchid = $matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_events WHERE matchid = $matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo' diff --git a/html/pages/admin/dplayer.php b/html/pages/admin/dplayer.php index ca3e747..c641480 100644 --- a/html/pages/admin/dplayer.php +++ b/html/pages/admin/dplayer.php @@ -21,9 +21,9 @@ echo'
Adjusting RankingsDone
Removing Match Record:Done
Removing Player Records:Done
Removing Kill Matrix Entries:Done
Removing Weapon Stats:Done
Amending Player Weapon Stats:Done
Amending Global Weapon Stats:Done
Removing events:Done
'; - $q_match = mysql_query("SELECT matchid, playerid FROM uts_player WHERE pid = '$pid'") or die(mysql_error()); - while ($r_match = mysql_fetch_array($q_match)) { - mysql_query("DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysql_error()); + $q_match = mysqli_query($GLOBALS["___mysqli_link"], "SELECT matchid, playerid FROM uts_player WHERE pid = '$pid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_match = mysqli_fetch_array($q_match)) { + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' @@ -32,7 +32,7 @@ echo'
Removing Kill Matrix Entries:Done
'; $r_pinfo = small_query("SELECT banned FROM uts_pinfo WHERE id = $playerid"); if ($r_pinfo['banned'] != 'Y') { - mysql_query("DELETE FROM uts_pinfo WHERE id = $playerid") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_pinfo WHERE id = $playerid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; } else { echo''; @@ -41,31 +41,31 @@ echo ' '; -mysql_query("DELETE e.* FROM uts_player as p, uts_events as e WHERE p.pid = $playerid AND p.playerid = e.playerid AND p.matchid = e.matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE e.* FROM uts_player as p, uts_events as e WHERE p.pid = $playerid AND p.playerid = e.playerid AND p.matchid = e.matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_player WHERE pid = $playerid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_player WHERE pid = $playerid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_rank WHERE pid = $playerid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE pid = $playerid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE pid = $playerid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE pid = $playerid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; - mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' diff --git a/html/pages/admin/dpmatch.php b/html/pages/admin/dpmatch.php index ff4258e..35e8a7e 100644 --- a/html/pages/admin/dpmatch.php +++ b/html/pages/admin/dpmatch.php @@ -47,17 +47,17 @@ if (!$sql_crank) { $oldrank = $sql_crank[rank]; $matchcount = $sql_crank[matches]-1; - mysql_query("UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysql_error()); - mysql_query("DELETE FROM uts_rank WHERE matches = 0") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE matches = 0") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; } echo''; - $q_match = mysql_query("SELECT matchid, playerid FROM uts_player WHERE pid = '$pid' and matchid = '$matchid'") or die(mysql_error()); - while ($r_match = mysql_fetch_array($q_match)) { - mysql_query("DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysql_error()); + $q_match = mysqli_query($GLOBALS["___mysqli_link"], "SELECT matchid, playerid FROM uts_player WHERE pid = '$pid' and matchid = '$matchid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_match = mysqli_fetch_array($q_match)) { + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' @@ -65,36 +65,36 @@ echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid = $matchid AND pid = $pid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid = $matchid AND pid = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE e.* FROM uts_events as e, uts_player as p WHERE p.pid = '$pid' AND e.matchid = $matchid AND p.playerid = e.playerid AND p.matchid = e.matchid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE e.* FROM uts_events as e, uts_player as p WHERE p.pid = '$pid' AND e.matchid = $matchid AND p.playerid = e.playerid AND p.matchid = e.matchid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_player WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_player WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); -$q_weaponstats = mysql_query("SELECT SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysql_error()); -while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); +$q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; - mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' diff --git a/html/pages/admin/editgames.php b/html/pages/admin/editgames.php index d2981b8..36f19e3 100644 --- a/html/pages/admin/editgames.php +++ b/html/pages/admin/editgames.php @@ -5,13 +5,13 @@ if (isset($_REQUEST['submit'])) { foreach($_REQUEST['name'] as $id => $bla) { if ($id == 0) { if (empty($_REQUEST['name'][$id])) continue; - mysql_query(" INSERT INTO uts_games + mysqli_query($GLOBALS["___mysqli_link"], " INSERT INTO uts_games SET name = '". my_addslashes($_REQUEST['name'][$id]) ."', - gamename = '(user defined)';") or die(mysql_error()); + gamename = '(user defined)';") or die(mysqli_error($GLOBALS["___mysqli_link"])); } else { - mysql_query(" UPDATE uts_games + mysqli_query($GLOBALS["___mysqli_link"], " UPDATE uts_games SET name = '". my_addslashes($_REQUEST['name'][$id]) ."' - WHERE id = '$id';") or die(mysql_error()); + WHERE id = '$id';") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } } @@ -31,9 +31,9 @@ echo'
Removing Player Info:DoneNo (player banned)
Removing Player Match Events:Done
Removing Player Match Records:Done
Removing Player Rank:Done
Removing Player Weapon Stats:Done
Amending Global Weapon Stats:DoneDone
Removing Kill Matrix Entries:Done
Removing Player Weapon Stats:Done
Removing Player Events:Done
Removing Player From Match:Done
Amending Player Weapon Stats:Done
Amending Global Weapon Stats:Done
$sql_games = "SELECT id, gamename, name FROM uts_games ORDER BY gamename ASC;"; -$q_games = mysql_query($sql_games) or die(mysql_error()); +$q_games = mysqli_query($GLOBALS["___mysqli_link"], $sql_games) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_games = mysql_fetch_array($q_games)) { +while ($r_games = mysqli_fetch_array($q_games)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ''; diff --git a/html/pages/admin/editgamestype.php b/html/pages/admin/editgamestype.php index 0b8ac30..2f7a238 100644 --- a/html/pages/admin/editgamestype.php +++ b/html/pages/admin/editgamestype.php @@ -2,31 +2,31 @@ if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla'); $sql_server = "SELECT id, servername, serverip FROM uts_match GROUP BY servername, serverip ORDER BY servername ASC"; -$q_server = mysql_query($sql_server) or die(mysql_error()); +$q_server = mysqli_query($GLOBALS["___mysqli_link"], $sql_server) or die(mysqli_error($GLOBALS["___mysqli_link"])); $servernames = array('0' => ''); $serverips = array('0' => '*'); -while ($r_server = mysql_fetch_array($q_server)) { +while ($r_server = mysqli_fetch_array($q_server)) { $servernames[$r_server['id']] = $r_server['servername']; $serverips[$r_server['id']] = $r_server['serverip']; } $sql_games = "SELECT id, gamename, name FROM uts_games ORDER BY gamename ASC"; -$q_games = mysql_query($sql_games) or die(mysql_error()); +$q_games = mysqli_query($GLOBALS["___mysqli_link"], $sql_games) or die(mysqli_error($GLOBALS["___mysqli_link"])); $gamedisplaynames = array('0' => ''); $gamenames = array('0' => '*'); -while ($r_games = mysql_fetch_array($q_games)) { +while ($r_games = mysqli_fetch_array($q_games)) { $gamenames[$r_games['id']] = $r_games['gamename']; $gamedisplaynames[$r_games['id']] = $r_games['name']; } if (isset($_REQUEST['submit'])) { - mysql_query(" INSERT INTO uts_gamestype + mysqli_query($GLOBALS["___mysqli_link"], " INSERT INTO uts_gamestype SET serverip = '". my_addslashes($_REQUEST['serverip']) ."', gamename = '". my_addslashes($_REQUEST['gamename']) ."', mutator = '". my_addslashes($_REQUEST['mutator']) ."', gid = '". my_addslashes($_REQUEST['gid']) ."' - ") or die(mysql_error()); + ") or die(mysqli_error($GLOBALS["___mysqli_link"])); if (isset($_REQUEST['update'])) { echo'
@@ -50,8 +50,8 @@ if (isset($_REQUEST['submit'])) { $where .= " AND m.mutators LIKE '%".my_addslashes($_REQUEST['mutator'])."%'"; } - mysql_query("UPDATE uts_player p, uts_match m SET p.gid = '". my_addslashes($_REQUEST['gid']) ."' $where AND m.id = p.matchid;") or die(mysql_error()); - echo' + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player p, uts_match m SET p.gid = '". my_addslashes($_REQUEST['gid']) ."' $where AND m.id = p.matchid;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + echo' @@ -59,8 +59,8 @@ if (isset($_REQUEST['submit'])) { '; - mysql_query("UPDATE uts_match m SET m.gid = '". my_addslashes($_REQUEST['gid']) ."' $where;") or die(mysql_error()); - echo' + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_match m SET m.gid = '". my_addslashes($_REQUEST['gid']) ."' $where;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + echo' @@ -76,13 +76,13 @@ if (isset($_REQUEST['submit'])) { } else { $where = 'WHERE 1'; } - mysql_query("DELETE FROM uts_rank $where;") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank $where;") or die(mysqli_error($GLOBALS["___mysqli_link"])); $sql_nrank = "SELECT SUM(p.gametime) AS time, p.pid, p.gid, SUM(p.rank) AS rank, COUNT(p.matchid) AS matches FROM uts_player p, uts_pinfo pi $where AND pi.id = p.pid AND pi.banned <> 'Y' GROUP BY p.gid, p.pid"; - $q_nrank = mysql_query($sql_nrank) or die(mysql_error()); + $q_nrank = mysqli_query($GLOBALS["___mysqli_link"], $sql_nrank) or die(mysqli_error($GLOBALS["___mysqli_link"])); $num_ranks = 0; - while ($r_nrank = mysql_fetch_array($q_nrank)) { - mysql_query("INSERT INTO uts_rank SET time = '${r_nrank['time']}', pid = ${r_nrank['pid']}, gid = ${r_nrank['gid']}, rank = '${r_nrank['rank']}', prevrank = '${r_nrank['rank']}', matches = ${r_nrank['matches']}") or die(mysql_error()); + while ($r_nrank = mysqli_fetch_array($q_nrank)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_rank SET time = '${r_nrank['time']}', pid = ${r_nrank['pid']}, gid = ${r_nrank['gid']}, rank = '${r_nrank['rank']}', prevrank = '${r_nrank['rank']}', matches = ${r_nrank['matches']}") or die(mysqli_error($GLOBALS["___mysqli_link"])); $num_ranks++; } echo' @@ -95,9 +95,9 @@ if (isset($_REQUEST['submit'])) { } if (isset($_REQUEST['del'])) { - mysql_query(" DELETE FROM uts_gamestype + mysqli_query($GLOBALS["___mysqli_link"], " DELETE FROM uts_gamestype WHERE id = '". my_addslashes($_REQUEST['del']) ."' - ") or die(mysql_error()); + ") or die(mysqli_error($GLOBALS["___mysqli_link"])); } @@ -123,9 +123,9 @@ echo'
Done (updated '.mysql_affected_rows().' records)Done (updated '.mysqli_affected_rows($GLOBALS["___mysqli_link"]).' records)
Updating MatchesDone (updated '.mysql_affected_rows().' matches)Done (updated '.mysqli_affected_rows($GLOBALS["___mysqli_link"]).' matches)
Done (recalculated '.$num_ranks.' rankings)
$sql_gamestype = "SELECT id, serverip, gamename, mutator, gid FROM uts_gamestype ORDER BY id ASC;"; -$q_gamestype = mysql_query($sql_gamestype) or die(mysql_error()); +$q_gamestype = mysqli_query($GLOBALS["___mysqli_link"], $sql_gamestype) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_gamestype = mysql_fetch_array($q_gamestype)) { +while ($r_gamestype = mysqli_fetch_array($q_gamestype)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ''; diff --git a/html/pages/admin/editweapons.php b/html/pages/admin/editweapons.php index e7b3251..0921d95 100644 --- a/html/pages/admin/editweapons.php +++ b/html/pages/admin/editweapons.php @@ -3,11 +3,11 @@ if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_ad if (isset($_REQUEST['submit'])) { foreach($_REQUEST['image'] as $id => $bla) { - mysql_query(" UPDATE uts_weapons + mysqli_query($GLOBALS["___mysqli_link"], " UPDATE uts_weapons SET image = '". my_addslashes($_REQUEST['image'][$id]) ."', sequence = '". my_addslashes($_REQUEST['sequence'][$id]) ."', hide = '". (isset($_REQUEST['hide'][$id]) ? 'Y' : 'N') ."' - WHERE id = '$id';") or die(mysql_error()); + WHERE id = '$id';") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } @@ -28,9 +28,9 @@ echo'
$sql_weapons = "SELECT id, name, image, sequence, hide FROM uts_weapons ORDER BY sequence ASC;"; -$q_weapons = mysql_query($sql_weapons) or die(mysql_error()); +$q_weapons = mysqli_query($GLOBALS["___mysqli_link"], $sql_weapons) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_weapons = mysql_fetch_array($q_weapons)) { +while ($r_weapons = mysqli_fetch_array($q_weapons)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ''; diff --git a/html/pages/admin/emptydb.php b/html/pages/admin/emptydb.php index 63599fc..cecd14b 100755 --- a/html/pages/admin/emptydb.php +++ b/html/pages/admin/emptydb.php @@ -30,18 +30,18 @@ IF ($results['sure'] == "Yes" and $results['really'] == "Yes") { Emptying All Tables except uts_ip2country, uts_weaponstats and uts_charttypes '; - mysql_query("TRUNCATE uts_chartdata;") or die(mysql_error()); - mysql_query("TRUNCATE uts_events;") or die(mysql_error()); - mysql_query("TRUNCATE uts_games;") or die(mysql_error()); - mysql_query("TRUNCATE uts_gamestype;") or die(mysql_error()); - mysql_query("TRUNCATE uts_killsmatrix;") or die(mysql_error()); - mysql_query("TRUNCATE uts_match;") or die(mysql_error()); - mysql_query("TRUNCATE uts_pinfo;") or die(mysql_error()); - mysql_query("TRUNCATE uts_player;") or die(mysql_error()); - mysql_query("TRUNCATE uts_rank;") or die(mysql_error()); - mysql_query("DELETE FROM uts_weapons WHERE id > 19") or die(mysql_error()); - mysql_query("ALTER TABLE uts_weapons AUTO_INCREMENT=20") or die(mysql_error()); - mysql_query("TRUNCATE uts_weaponstats;") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_chartdata;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_events;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_games;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_gamestype;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_killsmatrix;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_match;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_pinfo;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_player;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_rank;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weapons WHERE id > 19") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "ALTER TABLE uts_weapons AUTO_INCREMENT=20") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_weaponstats;") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo ' diff --git a/html/pages/admin/ipsearch.php b/html/pages/admin/ipsearch.php index fcfe17f..6db94dc 100644 --- a/html/pages/admin/ipsearch.php +++ b/html/pages/admin/ipsearch.php @@ -29,17 +29,17 @@ echo'
Done
$sql_players = "SELECT pi.name, pi.id AS pid FROM uts_player p, uts_pinfo pi WHERE p.pid = pi.id AND p.ip BETWEEN INET_ATON('$ip_from') AND INET_ATON('$ip_to') GROUP BY pid"; -$q_players = mysql_query($sql_players) or die(mysql_error()); +$q_players = mysqli_query($GLOBALS["___mysqli_link"], $sql_players) or die(mysqli_error($GLOBALS["___mysqli_link"])); $j = 0; -while ($r_players = mysql_fetch_array($q_players)) { +while ($r_players = mysqli_fetch_array($q_players)) { echo ''; echo ''; $sql_recent = "SELECT m.time AS time, m.id AS mid, INET_NTOA(p.ip) AS ip FROM uts_player p, uts_match m WHERE m.id = p.matchid AND p.pid = '${r_players['pid']}' AND p.ip BETWEEN INET_ATON('$ip_from') AND INET_ATON('$ip_to') ORDER BY m.time DESC LIMIT 0,5"; echo ' @@ -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' diff --git a/html/pages/servers.php b/html/pages/servers.php index 65dd06b..e0b4040 100644 --- a/html/pages/servers.php +++ b/html/pages/servers.php @@ -52,9 +52,9 @@ echo ' $sql_servers = "SELECT servername, serverip, COUNT(*) AS matchcount, SUM(frags) AS frags, SUM(t0score+t1score+t2score+t3score) AS matchscore, SUM(gametime) AS gametime FROM uts_match GROUP BY servername, serverip ORDER BY servername ASC LIMIT $qpage,25"; -$q_servers = mysql_query($sql_servers) or die(mysql_error()); +$q_servers = mysqli_query($GLOBALS["___mysqli_link"], $sql_servers) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_servers = mysql_fetch_array($q_servers)) { +while ($r_servers = mysqli_fetch_array($q_servers)) { $r_gametime = sec2hour($r_servers[gametime]); echo ' diff --git a/html/pages/servers_info.php b/html/pages/servers_info.php index 81f7772..baded2b 100644 --- a/html/pages/servers_info.php +++ b/html/pages/servers_info.php @@ -1,5 +1,5 @@ Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' '; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid AND m.serverip = '$serverip' ORDER BY m.time DESC LIMIT $qpage,25"; -$q_recent = mysql_query($sql_recent) or die(mysql_error()); -while ($r_recent = mysql_fetch_array($q_recent)) { +$q_recent = mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_recent = mysqli_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); diff --git a/html/pages/totals.php b/html/pages/totals.php index 0e81f82..772e0bb 100755 --- a/html/pages/totals.php +++ b/html/pages/totals.php @@ -21,9 +21,9 @@ $sql_totsumm = "SELECT g.name AS gamename, SUM(p.gamescore) AS gamescore, SUM(p. GROUP BY g.name ORDER BY gamename ASC"; -$q_totsumm = mysql_query($sql_totsumm) or die(mysql_error()); +$q_totsumm = mysqli_query($GLOBALS["___mysqli_link"], $sql_totsumm) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) { +while ($r_totsumm = zero_out(mysqli_fetch_array($q_totsumm))) { $gametime = sec2hour($r_totsumm[sumgametime]); echo' @@ -78,9 +78,9 @@ echo' '; - $q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); + $q_assgids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysqli_error($GLOBALS["___mysqli_link"])); $assgids = array(); - while ($r_assgids = mysql_fetch_array($q_assgids)) { + while ($r_assgids = mysqli_fetch_array($q_assgids)) { $assgids[] = $r_assgids['id']; } $assquery = (count($assgids) > 0) ? 'SUM(IF (gid IN ('. implode(',', $assgids) .'), ass_obj, 0)) AS ass_obj' : '0 AS ass_obj'; @@ -175,7 +175,7 @@ $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, AVG(ttl) AS ttl , $sql_chighflag_capture = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY flag_capture DESC LIMIT 0,1"); $sql_chighflag_kill = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY flag_kill DESC LIMIT 0,1"); $sql_chighdom_cp = small_query("SELECT p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY dom_cp DESC LIMIT 0,1"); -$ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); +$ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysqli_error($GLOBALS["___mysqli_link"])); if ($ass_obj_check[idcount] > 0 ) { $sql_chighass_obj = small_query("SELECT p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ass_obj DESC LIMIT 0,1"); @@ -367,7 +367,7 @@ $sql_mhighflag_capture = small_query("SELECT p.matchid, p.pid, pi.name, p.countr $sql_mhighflag_kill = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_kill > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY flag_kill DESC LIMIT 0,1"); $sql_mhighdom_cp = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND dom_cp > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY dom_cp DESC LIMIT 0,1"); -$ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); +$ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysqli_error($GLOBALS["___mysqli_link"])); if ($ass_obj_check[idcount] > 0 ) { $sql_mhighass_obj = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND ass_obj > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY ass_obj DESC LIMIT 0,1"); } else { @@ -541,13 +541,13 @@ echo ' '; $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC"; -$q_mweapons = mysql_query($sql_mweapons) or die(mysql_error()); -while ($r_mweapons = mysql_fetch_array($q_mweapons)) { +$q_mweapons = mysqli_query($GLOBALS["___mysqli_link"], $sql_mweapons) or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_mweapons = mysqli_fetch_array($q_mweapons)) { $wid = $r_mweapons[id]; $sql_mweaponsl = "SELECT w.pid AS playerid, pi.name AS name, pi.country AS country, SUM(w.kills) as kills, COUNT(DISTINCT w.matchid) AS mcount FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid <> 0 AND pi.banned <> 'Y' GROUP BY w.pid ORDER BY kills DESC LIMIT 0,1"; - $q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error()); - while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { + $q_mweaponsl = mysqli_query($GLOBALS["___mysqli_link"], $sql_mweaponsl) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_mweaponsl = mysqli_fetch_array($q_mweaponsl)) { echo ' @@ -578,13 +578,13 @@ echo '
'; echo ''.$r_players['name'].''; echo ''; - $q_recent= mysql_query($sql_recent) or die(mysql_error()); - while ($r_recent = mysql_fetch_array($q_recent)) { + $q_recent= mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_recent = mysqli_fetch_array($q_recent)) { $j++; $class = ($j%2) ? 'grey' : 'grey2'; echo ''; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, INET_NTOA(p.ip) AS ip FROM uts_match m, uts_player p, uts_games g WHERE p.pid = '$pid' AND m.id = p.matchid AND m.gid = g.id ORDER BY time DESC LIMIT $qpage,50"; -$q_recent = mysql_query($sql_recent) or die(mysql_error()); +$q_recent = mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_recent = mysql_fetch_array($q_recent)) { +while ($r_recent = mysqli_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); echo' - - - - '; + + + + '; if (isset($is_admin) and $is_admin) echo ''; echo ''; 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]); 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 @@ @@ -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 ' @@ -35,7 +35,7 @@ while ($r_rgame = mysql_fetch_array($q_rgame)) {
'; } else { - while ($r_rplayer = mysql_fetch_array($q_rplayer)) { + while ($r_rplayer = mysqli_fetch_array($q_rplayer)) { $ranking++; $myurl = urlencode($r_rplayer[name]); diff --git a/html/pages/rank_extended.php b/html/pages/rank_extended.php index bd9c60e..6782469 100644 --- a/html/pages/rank_extended.php +++ b/html/pages/rank_extended.php @@ -56,8 +56,8 @@ echo' $ranking = $qpage; $sql_rplayer = "SELECT pi.name, pi.country, r.rank, r.prevrank, r.matches, r.pid FROM uts_rank AS r, uts_pinfo AS pi WHERE r.pid = pi.id AND r.gid = '$gid' AND pi.banned <> 'Y' ORDER BY rank DESC LIMIT $qpage,25"; - $q_rplayer = mysql_query($sql_rplayer) or die(mysql_error()); - while ($r_rplayer = mysql_fetch_array($q_rplayer)) { + $q_rplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_rplayer) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_rplayer = mysqli_fetch_array($q_rplayer)) { $ranking++; echo' diff --git a/html/pages/recent.php b/html/pages/recent.php index e95b195..29d9297 100755 --- a/html/pages/recent.php +++ b/html/pages/recent.php @@ -25,7 +25,7 @@ $fpage = 0; if ($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } -$cpage = mysql_real_escape_string(preg_replace('/\D/', '', $_REQUEST["page"])); +$cpage = mysqli_real_escape_string($GLOBALS["___mysqli_link"], preg_replace('/\D/', '', $_REQUEST["page"])); if ($cpage == "") { $cpage = "0"; } $qpage = $cpage*25; @@ -95,9 +95,9 @@ echo ''; -$sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, t0score, t1score, t2score, t3score, (SELECT count(p.id) FROM uts_player AS p WHERE m.id = p.matchid) as players FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid $where ORDER BY m.time DESC LIMIT ".mysql_real_escape_string($qpage).",50"; -$q_recent = mysql_query($sql_recent) or die(mysql_error()); +$sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, t0score, t1score, t2score, t3score, (SELECT count(p.id) FROM uts_player AS p WHERE m.id = p.matchid) as players FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid $where ORDER BY m.time DESC LIMIT ".mysqli_real_escape_string($GLOBALS["___mysqli_link"], $qpage).",50"; +$q_recent = mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_recent = mysql_fetch_array($q_recent)) { +while ($r_recent = mysqli_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); $r_gametime = GetMinutes($r_recent[gametime]); diff --git a/html/pages/report/bbcode.php b/html/pages/report/bbcode.php index 09c65a7..b6475ff 100644 --- a/html/pages/report/bbcode.php +++ b/html/pages/report/bbcode.php @@ -220,8 +220,8 @@ echo'[b]'.$teama.' Lineup[/b] '; $sql_rplayer = "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_rplayer = mysql_query($sql_rplayer); -while ($r_rplayer = mysql_fetch_array($q_rplayer)) { +$q_rplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_rplayer); +while ($r_rplayer = mysqli_fetch_array($q_rplayer)) { echo''.$r_rplayer[name].' '; @@ -234,8 +234,8 @@ echo' '; $sql_bplayer = "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_bplayer = mysql_query($sql_bplayer); -while ($r_bplayer = mysql_fetch_array($q_bplayer)) { +$q_bplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_bplayer); +while ($r_bplayer = mysqli_fetch_array($q_bplayer)) { echo''.$r_bplayer[name].' '; diff --git a/html/pages/report/clanbase.php b/html/pages/report/clanbase.php index 2eb8cde..54ba998 100644 --- a/html/pages/report/clanbase.php +++ b/html/pages/report/clanbase.php @@ -261,8 +261,8 @@ echo'_______________________________________________________________________
_____________________________________________________________________ '; $sql_bplayer = "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_bplayer = mysql_query($sql_bplayer); -while ($r_bplayer = mysql_fetch_array($q_bplayer)) { +$q_bplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_bplayer); +while ($r_bplayer = mysqli_fetch_array($q_bplayer)) { echo'[pl]'.$cbid($r_bplayer[id]).','.$cbnick($r_bplayer[name]).'[/pl] '; } 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'
'; diff --git a/html/pages/admin/main.php b/html/pages/admin/main.php index 697909a..569d142 100644 --- a/html/pages/admin/main.php +++ b/html/pages/admin/main.php @@ -3,7 +3,7 @@ if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_ad if (isset($_REQUEST['droptable'])) { $droptable = my_addslashes($_REQUEST['droptable']); if (substr($droptable, 0, 9) == 'uts_temp_' and strlen($droptable) == 17) { - mysql_query("DROP TABLE $droptable;") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DROP TABLE $droptable;") or die(mysqli_error($GLOBALS["___mysqli_link"])); } else { die('NO!'); } @@ -22,11 +22,11 @@ echo'Database Statistics'; -$q_dbsize = mysql_query("SHOW table STATUS") or die(mysql_error()); +$q_dbsize = mysqli_query($GLOBALS["___mysqli_link"], "SHOW table STATUS") or die(mysqli_error($GLOBALS["___mysqli_link"])); $tot_size = 0; $tot_rows = 0; $max_size = 0; -while ($r_dbsize = mysql_fetch_array($q_dbsize)) { +while ($r_dbsize = mysqli_fetch_array($q_dbsize)) { if (substr($r_dbsize['Name'], 0, 4) != 'uts_') continue; $size = $r_dbsize['Data_length'] + $r_dbsize['Index_length']; $rows = $r_dbsize['Rows']; diff --git a/html/pages/admin/mplayers.php b/html/pages/admin/mplayers.php index c9b58a3..efe7658 100644 --- a/html/pages/admin/mplayers.php +++ b/html/pages/admin/mplayers.php @@ -32,55 +32,55 @@ echo'
'; -mysql_query("DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("UPDATE uts_player SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("UPDATE uts_weaponstats SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysql_error()); -mysql_query("DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_weaponstats SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysqli_error($GLOBALS["___mysqli_link"])); -$q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1' GROUP BY weapon") or die(mysql_error()); -while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); +$q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; -mysql_query("UPDATE uts_match SET firstblood = $mplayer1 WHERE firstblood = $mplayer2") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_match SET firstblood = $mplayer1 WHERE firstblood = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; $sql_nrank = "SELECT SUM(time) AS time, pid, gid, AVG(rank) AS rank, AVG(prevrank) AS prevrank, SUM(matches) AS matches FROM uts_rank WHERE pid = $mplayer2 GROUP BY pid, gid"; -$q_nrank = mysql_query($sql_nrank) or die(mysql_error()); -while ($r_nrank = mysql_fetch_array($q_nrank)) { +$q_nrank = mysqli_query($GLOBALS["___mysqli_link"], $sql_nrank) or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_nrank = mysqli_fetch_array($q_nrank)) { - mysql_query("INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $mplayer1, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[prevrank]', matches = $r_nrank[matches]") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $mplayer1, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[prevrank]', matches = $r_nrank[matches]") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; -mysql_query("DELETE FROM uts_rank WHERE pid = $mplayer2") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo' diff --git a/html/pages/admin/mservers.php b/html/pages/admin/mservers.php index 9e0bf6a..f58937f 100644 --- a/html/pages/admin/mservers.php +++ b/html/pages/admin/mservers.php @@ -31,7 +31,7 @@ echo'
Removing Info RecordsDone
Updating Player RecordsDone
Updating Weapon RecordsDone
Amending Player Weapon Stats:Done
Updating First Blood RecordsDone
Temporary RankDone
Creating New RankDone
Removing Old RankDone
'; -mysql_query("UPDATE uts_match SET serverip = '". addslashes($q_myserver1[serverip]) ."', servername = '". addslashes($q_myserver1[servername]) ."' WHERE serverip = '". addslashes($q_myserver2[serverip]) ."' and servername = '". addslashes($q_myserver2[servername]) ."'") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_match SET serverip = '". addslashes($q_myserver1[serverip]) ."', servername = '". addslashes($q_myserver1[servername]) ."' WHERE serverip = '". addslashes($q_myserver2[serverip]) ."' and servername = '". addslashes($q_myserver2[servername]) ."'") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo' diff --git a/html/pages/admin/pban.php b/html/pages/admin/pban.php index 88aa6a4..4d11daa 100644 --- a/html/pages/admin/pban.php +++ b/html/pages/admin/pban.php @@ -32,12 +32,12 @@ if ($ban) { '; - mysql_query("DELETE FROM uts_rank WHERE pid = $pid") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE pid = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; - mysql_query("UPDATE uts_pinfo SET banned = 'Y' WHERE id = $pid") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_pinfo SET banned = 'Y' WHERE id = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo' @@ -51,17 +51,17 @@ if ($ban) { '; - mysql_query("UPDATE uts_pinfo SET banned = 'N' WHERE id = $pid") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_pinfo SET banned = 'N' WHERE id = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; $sql_nrank = "SELECT SUM(gametime) AS time, pid, gid, SUM(rank) AS rank, COUNT(matchid) AS matches FROM uts_player WHERE pid = $pid GROUP BY pid, gid"; - $q_nrank = mysql_query($sql_nrank) or die(mysql_error()); - while ($r_nrank = mysql_fetch_array($q_nrank)) { + $q_nrank = mysqli_query($GLOBALS["___mysqli_link"], $sql_nrank) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_nrank = mysqli_fetch_array($q_nrank)) { - mysql_query("INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $pid, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[rank]', matches = $r_nrank[matches]") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $pid, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[rank]', matches = $r_nrank[matches]") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' diff --git a/html/pages/admin/pinfo.php b/html/pages/admin/pinfo.php index 3ae57f7..cf04b3d 100644 --- a/html/pages/admin/pinfo.php +++ b/html/pages/admin/pinfo.php @@ -1,6 +1,6 @@ '; $sql_ips = "SELECT INET_NTOA(p.ip) AS ip, COUNT(p.id) AS matches, MIN(m.time) AS first, MAX(m.time) AS last FROM uts_player AS p, uts_match AS m WHERE p.pid = ".$pid." AND m.id = p.matchid GROUP BY ip ORDER BY ip"; -$q_ips = mysql_query($sql_ips) or die("Can't get ip's: " . mysql_error()); +$q_ips = mysqli_query($GLOBALS["___mysqli_link"], $sql_ips) or die("Can't get ip's: " . mysqli_error($GLOBALS["___mysqli_link"])); echo '
Merging RecordsDone
Removing Player Rank:Done
Updating Player Record:Done
Updating Player Record:Done
Restoring RankingsDone
@@ -32,14 +32,14 @@ echo ' - + '; -while ($r_ips = mysql_fetch_assoc($q_ips)) { - echo ' +while ($r_ips = mysqli_fetch_assoc($q_ips)) { + echo ' @@ -55,10 +55,10 @@ echo '
* Hostnames are real time and might have been different at the time of playing. *

'; -mysql_free_result($q_ips); +((mysqli_free_result($q_ips) || (is_object($q_ips) && (get_class($q_ips) == "mysqli_result"))) ? true : false); $sql_fakes = "SELECT INET_NTOA(p1.ip) AS ip, pi.name FROM uts_player AS p1, uts_player AS p2, uts_pinfo AS pi WHERE p1.pid = ".$pid." AND p1.ip = p2.ip AND p1.pid <> p2.pid AND pi.id = p2.pid GROUP BY pi.name"; -$q_fakes = mysql_query($sql_fakes) or die("Can't retrieve fake nicks: " . mysql_error()); +$q_fakes = mysqli_query($GLOBALS["___mysqli_link"], $sql_fakes) or die("Can't retrieve fake nicks: " . mysqli_error($GLOBALS["___mysqli_link"])); echo '
IPHostnameHostname Matches First Last
'.$r_ips['ip'].' '.gethostbyaddr($r_ips['ip']).'
@@ -70,14 +70,14 @@ echo ' '; -if (mysql_num_rows($q_fakes) == 0) { +if (mysqli_num_rows($q_fakes) == 0) { echo ' '; } else { - while($r_fakes = mysql_fetch_assoc($q_fakes)) { + while($r_fakes = mysqli_fetch_assoc($q_fakes)) { echo ' diff --git a/html/pages/admin/plm.php b/html/pages/admin/plm.php index 1ea9f52..be26f71 100644 --- a/html/pages/admin/plm.php +++ b/html/pages/admin/plm.php @@ -13,25 +13,25 @@ function merge_players($mplayer1, $mplayer2) { $mp1name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer1"); $mp2name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer2"); - mysql_query("DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysql_error()); - mysql_query("UPDATE uts_player SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysql_error()); - mysql_query("UPDATE uts_weaponstats SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysql_error()); - mysql_query("DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysql_error()); - mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_weaponstats SET pid = $mplayer1 WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } - mysql_query("UPDATE uts_match SET firstblood = $mplayer1 WHERE firstblood = $mplayer2") or die(mysql_error()); - mysql_query("UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_match SET firstblood = $mplayer1 WHERE firstblood = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysqli_error($GLOBALS["___mysqli_link"])); $sql_nrank = "SELECT SUM(time) AS time, pid, gid, AVG(rank) AS rank, AVG(prevrank) AS prevrank, SUM(matches) AS matches FROM uts_rank WHERE pid = $mplayer2 GROUP BY pid, gid"; - $q_nrank = mysql_query($sql_nrank) or die(mysql_error()); - while ($r_nrank = mysql_fetch_array($q_nrank)) { + $q_nrank = mysqli_query($GLOBALS["___mysqli_link"], $sql_nrank) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_nrank = mysqli_fetch_array($q_nrank)) { - mysql_query("INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $mplayer1, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[prevrank]', matches = $r_nrank[matches]") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $mplayer1, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[prevrank]', matches = $r_nrank[matches]") or die(mysqli_error($GLOBALS["___mysqli_link"])); } - mysql_query("DELETE FROM uts_rank WHERE pid = $mplayer2") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE pid = $mplayer2") or die(mysqli_error($GLOBALS["___mysqli_link"])); } // If debugmode is on, get start time @@ -52,9 +52,9 @@ if($_GET['manignore'] == "true") { echo "

Stopped ignore ip's

"; foreach($_POST as $key=>$value) { if($key !='submit') { - $key = mysql_real_escape_string(str_replace("_",".",$key)); + $key = mysqli_real_escape_string($GLOBALS["___mysqli_link"], str_replace("_",".",$key)); $query = "DELETE FROM uts_ignoreips WHERE ip = (INET_ATON('".$key."'))"; - mysql_query($query) or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], $query) or die(mysqli_error($GLOBALS["___mysqli_link"])); echo "
$key"; } } @@ -63,13 +63,13 @@ if($_GET['manignore'] == "true") { echo '

Ignored ip\'s in range '.htmlentities($_POST['from']).' to '.htmlentities($_POST['to']).'
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; echo ''; - $from = mysql_real_escape_string($_POST['from']); - $to = mysql_real_escape_string($_POST['to']); + $from = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $_POST['from']); + $to = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $_POST['to']); - $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to') ORDER BY ip ASC"); + $ignore_ips = mysqli_query($GLOBALS["___mysqli_link"], "SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to') ORDER BY ip ASC"); - if(mysql_num_rows($ignore_ips) > 0) { - while ($r_pipcheck = mysql_fetch_array($ignore_ips)) { + if(mysqli_num_rows($ignore_ips) > 0) { + while ($r_pipcheck = mysqli_fetch_array($ignore_ips)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -79,8 +79,8 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { echo '
'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).' '; } echo '
'; @@ -99,9 +99,9 @@ if($_GET['manignore'] == "true") { echo '

Ignored ip\'s
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; echo ''; - $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips ORDER BY ip ASC"); - if(mysql_num_rows($ignore_ips) > 0) { - while ($r_pipcheck = mysql_fetch_array($ignore_ips)) { + $ignore_ips = mysqli_query($GLOBALS["___mysqli_link"], "SELECT ip FROM uts_ignoreips ORDER BY ip ASC"); + if(mysqli_num_rows($ignore_ips) > 0) { + while ($r_pipcheck = mysqli_fetch_array($ignore_ips)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -111,8 +111,8 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { echo '
'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).' '; } echo '
'; @@ -128,9 +128,9 @@ if($_GET['manignore'] == "true") { echo "

Ignored ips

"; foreach($_POST as $key=>$value) { if($key !='submit') { - $key = mysql_real_escape_string(str_replace("_",".",$key)); + $key = mysqli_real_escape_string($GLOBALS["___mysqli_link"], str_replace("_",".",$key)); $query = "INSERT INTO uts_ignoreips (ip) VALUES (INET_ATON('".$key."'))"; - mysql_query($query) or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], $query) or die(mysqli_error($GLOBALS["___mysqli_link"])); echo "
$key"; } } @@ -140,10 +140,10 @@ if($_GET['manignore'] == "true") { } else if(substr($_POST['submit'],0,8) == "merge - ") { echo "

Merge nicks with shared ip

"; - $ip = mysql_real_escape_string(str_replace("_",".",substr($_POST['submit'],8))); + $ip = mysqli_real_escape_string($GLOBALS["___mysqli_link"], str_replace("_",".",substr($_POST['submit'],8))); $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player WHERE ip = INET_ATON('$ip') GROUP BY ip ORDER BY ip ASC"; - $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error()); - while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) { + $q_pipcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pipcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pipcheck = mysqli_fetch_array($q_pipcheck)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -157,8 +157,8 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { echo '
'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).' '; $options .= ''; } @@ -172,11 +172,11 @@ if($_GET['manignore'] == "true") { } else if($_POST['submit'] == "Player merge") { echo "

Merging nicks with shared ip

"; - $ip = mysql_real_escape_string(str_replace("_",".",$_POST['ip'])); - $merge_to_pid = mysql_real_escape_string($_POST['merge_to']); + $ip = mysqli_real_escape_string($GLOBALS["___mysqli_link"], str_replace("_",".",$_POST['ip'])); + $merge_to_pid = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $_POST['merge_to']); $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player WHERE ip = INET_ATON('$ip') GROUP BY ip ORDER BY ip ASC"; - $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error()); - while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) { + $q_pipcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pipcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pipcheck = mysqli_fetch_array($q_pipcheck)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -189,9 +189,9 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT p.pid FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i=0; - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { if($r_pcheck['pid'] != $merge_to_pid) { $pid_from[$i] = $r_pcheck['pid']; echo $pid_from[$i].'
'; @@ -211,13 +211,13 @@ if($_GET['manignore'] == "true") { } else if($_GET['onlyrange'] == "true") { if($_POST['submit'] == "Confirm") { echo "

Showing all ip's in range ".htmlentities($_POST['from'])." to ".htmlentities($_POST['to'])."
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; - $from = mysql_real_escape_string($_POST['from']); - $to = mysql_real_escape_string($_POST['to']); + $from = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $_POST['from']); + $to = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $_POST['to']); - $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to')"); + $ignore_ips = mysqli_query($GLOBALS["___mysqli_link"], "SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to')"); $extended_query = "WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to')"; $i=0; - while($ignore_ips_array = mysql_fetch_array($ignore_ips)) { + while($ignore_ips_array = mysqli_fetch_array($ignore_ips)) { $ip = $ignore_ips_array[0]; $extended_query .= " AND "; $extended_query .= "ip <> '".$ip."'"; @@ -229,9 +229,9 @@ if($_GET['manignore'] == "true") { // Query for list of unique ips and player ids $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player ".$extended_query." GROUP BY ip ORDER BY ip ASC"; - $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error()); - if(mysql_num_rows($q_pipcheck) > 0) { - while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) { + $q_pipcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pipcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + if(mysqli_num_rows($q_pipcheck) > 0) { + while ($r_pipcheck = mysqli_fetch_array($q_pipcheck)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -244,8 +244,8 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { echo '
'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).' '; } echo "
"; @@ -270,10 +270,10 @@ if($_GET['manignore'] == "true") { } else { echo "

IP's linked with more than one nick
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; - $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips"); + $ignore_ips = mysqli_query($GLOBALS["___mysqli_link"], "SELECT ip FROM uts_ignoreips"); $extended_query = ""; $i=0; - while($ignore_ips_array = mysql_fetch_array($ignore_ips)) { + while($ignore_ips_array = mysqli_fetch_array($ignore_ips)) { $ip = $ignore_ips_array[0]; if($i==0) $extended_query = " WHERE "; @@ -288,9 +288,9 @@ if($_GET['manignore'] == "true") { // Query for list of unique ips and player ids $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player ".$extended_query." GROUP BY ip ORDER BY ip ASC"; - $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error()); - if(mysql_num_rows($q_pipcheck) > 0) { - while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) { + $q_pipcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pipcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + if(mysqli_num_rows($q_pipcheck) > 0) { + while ($r_pipcheck = mysqli_fetch_array($q_pipcheck)) { $playerip = $r_pipcheck[ip]; $trueplayerip = long2ip($playerip); @@ -303,8 +303,8 @@ if($_GET['manignore'] == "true") { // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; - $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error()); - while ($r_pcheck = mysql_fetch_array($q_pcheck)) { + $q_pcheck = mysqli_query($GLOBALS["___mysqli_link"], $sql_pcheck) or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_pcheck = mysqli_fetch_array($q_pcheck)) { echo '
'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).' '; } echo "
"; diff --git a/html/pages/admin/recalcflags.php b/html/pages/admin/recalcflags.php index 2c88610..228247e 100644 --- a/html/pages/admin/recalcflags.php +++ b/html/pages/admin/recalcflags.php @@ -39,27 +39,27 @@ echo' echo'Recalculating pinfo table...
'; /* update pinfo table */ - $sql_pids = mysql_query("SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysql_error()); - while($sql_pid = mysql_fetch_array($sql_pids)) + $sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while($sql_pid = mysqli_fetch_array($sql_pids)) { $playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip']))); if ($playercountry != $sql_pid['country'] ) { - mysql_query("UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } echo'Recalculating player table...
'; /* update player table */ - $sql_pids = mysql_query("SELECT pid, ip, country FROM uts_player"); - while ($sql_pid = mysql_fetch_array($sql_pids)) + $sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT pid, ip, country FROM uts_player"); + while ($sql_pid = mysqli_fetch_array($sql_pids)) { $playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip']))); if ($playercountry != $sql_pid['country']) { - mysql_query("UPDATE uts_player SET country = '$playercountry' WHERE pid = '".$sql_pid['pid']."'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player SET country = '$playercountry' WHERE pid = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } echo 'Done diff --git a/html/pages/admin/recalcranking.php b/html/pages/admin/recalcranking.php index 0065439..236687c 100644 --- a/html/pages/admin/recalcranking.php +++ b/html/pages/admin/recalcranking.php @@ -30,7 +30,7 @@ echo'
IP
No other names found
'.$r_fakes[ip].'
echo''; - mysql_query("TRUNCATE uts_rank") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "TRUNCATE uts_rank") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; @@ -39,7 +39,7 @@ echo''; echo' ORDER BY p.matchid ASC, p.playerid ASC"); $i = 0; - while ($r_pm = mysql_fetch_array($q_pm)) { + while ($r_pm = mysqli_fetch_array($q_pm)) { $i++; if ($i%50 == 0) { echo '. '; diff --git a/html/pages/credits.php b/html/pages/credits.php index 406bbf0..236c38c 100755 --- a/html/pages/credits.php +++ b/html/pages/credits.php @@ -148,7 +148,7 @@ Added an option to the admin page to delete temporary tables (if any)

Bug Fixes:
- Import fix for MySQL v3.x
+ Import fix for MySQL v3.x
Partial Import delete fix
bbcode and Clanbase Report Fix - not showing high score win reports.
Ranking fix (was more than 300 mins to get full ranking points)
diff --git a/html/pages/dpmatch.php b/html/pages/dpmatch.php index 2605249..0bc7043 100644 --- a/html/pages/dpmatch.php +++ b/html/pages/dpmatch.php @@ -47,17 +47,17 @@ if (!$sql_crank) { $oldrank = $sql_crank[rank]; $matchcount = $sql_crank[matches]-1; - mysql_query("UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysql_error()); - mysql_query("DELETE FROM uts_rank WHERE matches = 0") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysqli_error($GLOBALS["___mysqli_link"])); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_rank WHERE matches = 0") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo'
'; } echo''; - $q_match = mysql_query("SELECT matchid, playerid FROM uts_player WHERE pid = '$pid' and matchid = '$matchid'") or die(mysql_error()); - while ($r_match = mysql_fetch_array($q_match)) { - mysql_query("DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysql_error()); + $q_match = mysqli_query($GLOBALS["___mysqli_link"], "SELECT matchid, playerid FROM uts_player WHERE pid = '$pid' and matchid = '$matchid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_match = mysqli_fetch_array($q_match)) { + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_killsmatrix WHERE matchid = '${r_match['matchid']}' AND (killer = '${r_match['playerid']}' OR victim = '${r_match['playerid']}')") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' @@ -65,31 +65,31 @@ echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid = $matchid AND pid = $pid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid = $matchid AND pid = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_player WHERE matchid = $matchid AND pid = $pid") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_player WHERE matchid = $matchid AND pid = $pid") or die(mysqli_error($GLOBALS["___mysqli_link"])); echo''; -mysql_query("DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysql_error()); +mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid IN ('$matchid','0') AND pid = '$pid'") or die(mysqli_error($GLOBALS["___mysqli_link"])); -$q_weaponstats = mysql_query("SELECT SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysql_error()); -while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); +$q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$pid' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='$pid', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo''; - mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysql_error()); + mysqli_query($GLOBALS["___mysqli_link"], "DELETE FROM uts_weaponstats WHERE matchid='0' AND pid='0'") or die(mysqli_error($GLOBALS["___mysqli_link"])); - $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysql_error()); - while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) { - mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error()); + $q_weaponstats = mysqli_query($GLOBALS["___mysqli_link"], "SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE matchid = '0' GROUP BY weapon") or die(mysqli_error($GLOBALS["___mysqli_link"])); + while ($r_weaponstats = mysqli_fetch_array($q_weaponstats)) { + mysqli_query($GLOBALS["___mysqli_link"], "INSERT INTO uts_weaponstats SET matchid='0', pid='0', weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } echo' diff --git a/html/pages/graph_mbreakdown.php b/html/pages/graph_mbreakdown.php index 677e0c1..da9bce1 100755 --- a/html/pages/graph_mbreakdown.php +++ b/html/pages/graph_mbreakdown.php @@ -7,11 +7,11 @@ $sql_ghours = "SELECT HOUR(time) AS res_hour, COUNT(*) AS res_count WHERE $bgwhere GROUP by res_hour"; -$q_ghours = mysql_query($sql_ghours) or die(mysql_error()); +$q_ghours = mysqli_query($GLOBALS["___mysqli_link"], $sql_ghours) or die(mysqli_error($GLOBALS["___mysqli_link"])); $hour_max = 0; $hour_sum = 0; -while ($r_ghours = mysql_fetch_array($q_ghours)) { +while ($r_ghours = mysqli_fetch_array($q_ghours)) { $gb_hour[$r_ghours['res_hour']] = $r_ghours['res_count']; if ($r_ghours['res_count'] > $hour_max) $hour_max = $r_ghours['res_count']; $hour_sum += $r_ghours['res_count']; @@ -26,11 +26,11 @@ $sql_gdays = "SELECT WEEKDAY(time) AS res_day, COUNT(*) AS res_count WHERE $bgwhere GROUP by res_day"; -$q_gdays = mysql_query($sql_gdays) or die(mysql_error()); +$q_gdays = mysqli_query($GLOBALS["___mysqli_link"], $sql_gdays) or die(mysqli_error($GLOBALS["___mysqli_link"])); $day_max = 0; $day_sum = 0; -while ($r_gdays = mysql_fetch_array($q_gdays)) { +while ($r_gdays = mysqli_fetch_array($q_gdays)) { $gb_day[$r_gdays['res_day']] = $r_gdays['res_count']; if ($r_gdays['res_count'] > $day_max) $day_max = $r_gdays['res_count']; $day_sum += $r_gdays['res_count']; @@ -42,11 +42,11 @@ $sql_gmonths = "SELECT MONTH(time) AS res_month, COUNT(*) AS res_count WHERE $bgwhere GROUP by res_month"; -$q_gmonths = mysql_query($sql_gmonths) or die(mysql_error()); +$q_gmonths = mysqli_query($GLOBALS["___mysqli_link"], $sql_gmonths) or die(mysqli_error($GLOBALS["___mysqli_link"])); $month_max = 0; $month_sum = 0; -while ($r_gmonths = mysql_fetch_array($q_gmonths)) { +while ($r_gmonths = mysqli_fetch_array($q_gmonths)) { $gb_month[$r_gmonths['res_month']] = $r_gmonths['res_count']; if ($r_gmonths['res_count'] > $month_max) $month_max = $r_gmonths['res_count']; $month_sum += $r_gmonths['res_count']; @@ -73,12 +73,12 @@ $sql_gcountries = "SELECT country AS res_country, COUNT(*) AS res_count GROUP BY p.pid) AS res_table GROUP BY res_country ORDER BY res_count DESC"; -$q_gcountries = mysql_query($sql_gcountries) or die(mysql_error()); +$q_gcountries = mysqli_query($GLOBALS["___mysqli_link"], $sql_gcountries) or die(mysqli_error($GLOBALS["___mysqli_link"])); $country_max = 0; $country_sum = 0; $i = 0; -while ($r_gcountries = mysql_fetch_array($q_gcountries)) { +while ($r_gcountries = mysqli_fetch_array($q_gcountries)) { $gb_country[$i] = $r_gcountries['res_country'] . ";" . $r_gcountries['res_count']; if ($r_gcountries['res_count'] > $country_max) $country_max = $r_gcountries['res_count']; $country_sum += $r_gcountries['res_count']; diff --git a/html/pages/graph_pbreakdown.php b/html/pages/graph_pbreakdown.php index b287865..9e99226 100644 --- a/html/pages/graph_pbreakdown.php +++ b/html/pages/graph_pbreakdown.php @@ -4,10 +4,10 @@ $max_height = 80; // Hourly Breakdown $sql_ghours = "SELECT HOUR(m.time) AS res_hour, COUNT(p.id) AS res_count FROM uts_match m, uts_player p WHERE $bgwhere AND m.id = p.matchid GROUP by res_hour"; -$q_ghours = mysql_query($sql_ghours) or die(mysql_error()); +$q_ghours = mysqli_query($GLOBALS["___mysqli_link"], $sql_ghours) or die(mysqli_error($GLOBALS["___mysqli_link"])); $hour_max = 0; $hour_sum = 0; -while ($r_ghours = mysql_fetch_array($q_ghours)) { +while ($r_ghours = mysqli_fetch_array($q_ghours)) { $gb_hour[$r_ghours['res_hour']] = $r_ghours['res_count']; if ($r_ghours['res_count'] > $hour_max) $hour_max = $r_ghours['res_count']; $hour_sum += $r_ghours['res_count']; @@ -18,10 +18,10 @@ if ($hour_max == 0) return; // We use WEEKDAY rather then DAYOFWEEK because now the week starts with Monday instead of Sunday $sql_gdays = "SELECT WEEKDAY(time) AS res_day, COUNT(*) AS res_count FROM uts_match m, uts_player p WHERE $bgwhere AND m.id = p.matchid GROUP by res_day"; -$q_gdays = mysql_query($sql_gdays) or die(mysql_error()); +$q_gdays = mysqli_query($GLOBALS["___mysqli_link"], $sql_gdays) or die(mysqli_error($GLOBALS["___mysqli_link"])); $day_max = 0; $day_sum = 0; -while ($r_gdays = mysql_fetch_array($q_gdays)) { +while ($r_gdays = mysqli_fetch_array($q_gdays)) { $gb_day[$r_gdays['res_day']] = $r_gdays['res_count']; if ($r_gdays['res_count'] > $day_max) $day_max = $r_gdays['res_count']; $day_sum += $r_gdays['res_count']; @@ -30,10 +30,10 @@ while ($r_gdays = mysql_fetch_array($q_gdays)) { // Monthly Breakdown $sql_gmonths = "SELECT MONTH(m.time) AS res_month, COUNT(p.id) AS res_count FROM uts_match m, uts_player p WHERE $bgwhere AND m.id = p.matchid GROUP by res_month"; -$q_gmonths = mysql_query($sql_gmonths) or die(mysql_error()); +$q_gmonths = mysqli_query($GLOBALS["___mysqli_link"], $sql_gmonths) or die(mysqli_error($GLOBALS["___mysqli_link"])); $month_max = 0; $month_sum = 0; -while ($r_gmonths = mysql_fetch_array($q_gmonths)) { +while ($r_gmonths = mysqli_fetch_array($q_gmonths)) { $gb_month[$r_gmonths['res_month']] = $r_gmonths['res_count']; if ($r_gmonths['res_count'] > $month_max) $month_max = $r_gmonths['res_count']; $month_sum += $r_gmonths['res_count']; diff --git a/html/pages/home.php b/html/pages/home.php index fc419af..c86ecab 100755 --- a/html/pages/home.php +++ b/html/pages/home.php @@ -79,9 +79,9 @@ echo ' '; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, t0score, t1score, t2score, t3score, (SELECT count(p.id) FROM uts_player AS p WHERE m.id = p.matchid) as players FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid $where ORDER BY m.time DESC LIMIT 10"; -$q_recent = mysql_query($sql_recent) or die(mysql_error()); +$q_recent = mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_recent = mysql_fetch_array($q_recent)) { +while ($r_recent = mysqli_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); $r_gametime = GetMinutes($r_recent[gametime]); @@ -192,9 +192,9 @@ $sql_gamesummary = "SELECT g.id AS gid, g.name AS gamename, SUM(p.frags) AS frag GROUP BY gamename, gid ORDER BY gamename ASC"; -$q_gamesummary = mysql_query($sql_gamesummary) or die(mysql_error()); +$q_gamesummary = mysqli_query($GLOBALS["___mysqli_link"], $sql_gamesummary) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { +while ($r_gamesummary = mysqli_fetch_array($q_gamesummary)) { $gid = $r_gamesummary[gid]; $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match WHERE gid = '$gid'"); 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]); diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php index fc0a9e3..46033c9 100644 --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -1,6 +1,6 @@ 0) { + if (mysqli_num_rows($q_btrecords) > 0) { echo '
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
Deleting rankingsDone
Recalculating Rankings:'; $playerbanned = false; - $q_pm = mysql_query( " SELECT p.id, + $q_pm = mysqli_query($GLOBALS["___mysqli_link"], " SELECT p.id, p.matchid, p.pid, p.gid, @@ -53,7 +53,7 @@ echo'
Done
Removing Kill Matrix Entries:Done
Removing Player Weapon Stats:Done
Removing Player From Match:Done
Amending Player Weapon Stats:Done
Amending Global Weapon Stats:Done
@@ -311,7 +311,7 @@ if($map_matches[gametime]<= 0) { $i = $qpage; $lasttime = -1; - while ($r_btrecords = mysql_fetch_array($q_btrecords)) { + while ($r_btrecords = mysqli_fetch_array($q_btrecords)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ' diff --git a/html/pages/match_info_bt.php b/html/pages/match_info_bt.php index 16bee03..81b11fa 100644 --- a/html/pages/match_info_bt.php +++ b/html/pages/match_info_bt.php @@ -35,9 +35,9 @@ $sql_msred = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamesco WHERE p.pid = pi.id AND p.matchid = $mid AND team = 0 GROUP BY p.playerid ORDER BY e.col1 DESC, (0 + e.col3) ASC, gamescore DESC"; -$q_msred = mysql_query($sql_msred) or die(mysql_error()); +$q_msred = mysqli_query($GLOBALS["___mysqli_link"], $sql_msred) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_msred = zero_out(mysql_fetch_array($q_msred))) { +while ($r_msred = zero_out(mysqli_fetch_array($q_msred))) { if (!$r_msred['playerid']) { $r_msred['playerid'] = 0; } @@ -108,9 +108,9 @@ $sql_msblue = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamesc WHERE p.pid = pi.id AND p.matchid = $mid AND team = 1 GROUP BY p.playerid ORDER BY e.col1 DESC, (0 + e.col3) ASC, gamescore DESC"; -$q_msblue = mysql_query($sql_msblue) or die(mysql_error()); +$q_msblue = mysqli_query($GLOBALS["___mysqli_link"], $sql_msblue) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_msblue = zero_out(mysql_fetch_array($q_msblue))) { +while ($r_msblue = zero_out(mysqli_fetch_array($q_msblue))) { if (!$r_msblue['playerid']) { $r_msblue['playerid'] = 0; } diff --git a/html/pages/match_info_charts.php b/html/pages/match_info_charts.php index ed62fe5..549d00d 100644 --- a/html/pages/match_info_charts.php +++ b/html/pages/match_info_charts.php @@ -5,25 +5,25 @@ include_once 'includes/renderer-general-output.php'; global $renderer_heigth; global $renderer_width; -$mid = mysql_real_escape_string($mid); +$mid = mysqli_real_escape_string($GLOBALS["___mysqli_link"], $mid); $prevCategory = ""; $chartOutput = ""; $prevRenderedChart = ""; // get all charts for this match -$charts = mysql_query("SELECT d.* , t.charttype, t.category, t.type, t.color, t.layout,t.columns +$charts = mysqli_query($GLOBALS["___mysqli_link"], "SELECT d.* , t.charttype, t.category, t.type, t.color, t.layout,t.columns FROM uts_chartdata d JOIN uts_charttypes t ON d.chartid = t.id WHERE d.mid = $mid - ORDER BY d.id ASC") or die(mysql_error()); + ORDER BY d.id ASC") or die(mysqli_error($GLOBALS["___mysqli_link"])); -$chartCount = mysql_num_rows($charts); +$chartCount = mysqli_num_rows($charts); if ($chartCount >0) { $i = 0; // cycle over charts - while ($chart = mysql_fetch_array($charts)) { + while ($chart = mysqli_fetch_array($charts)) { // retrieve both generic as the specific data $category = $chart['category']; diff --git a/html/pages/match_info_ctf.php b/html/pages/match_info_ctf.php index 378b831..c3d2983 100644 --- a/html/pages/match_info_ctf.php +++ b/html/pages/match_info_ctf.php @@ -28,10 +28,10 @@ echo' $sql_msred = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 0 ORDER BY gamescore DESC"; -$q_msred = mysql_query($sql_msred) or die(mysql_error()); +$q_msred = mysqli_query($GLOBALS["___mysqli_link"], $sql_msred) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_msred = zero_out(mysql_fetch_array($q_msred))) { +while ($r_msred = zero_out(mysqli_fetch_array($q_msred))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; @@ -114,10 +114,10 @@ echo' $sql_msblue = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 1 ORDER BY gamescore DESC"; -$q_msblue = mysql_query($sql_msblue) or die(mysql_error()); +$q_msblue = mysqli_query($GLOBALS["___mysqli_link"], $sql_msblue) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_msblue = zero_out(mysql_fetch_array($q_msblue))) { +while ($r_msblue = zero_out(mysqli_fetch_array($q_msblue))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; @@ -203,10 +203,10 @@ if ($greencheck > 0) { $sql_msgreen = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 2 ORDER BY gamescore DESC"; - $q_msgreen = mysql_query($sql_msgreen) or die(mysql_error()); + $q_msgreen = mysqli_query($GLOBALS["___mysqli_link"], $sql_msgreen) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; - while ($r_msgreen = zero_out(mysql_fetch_array($q_msgreen))) { + while ($r_msgreen = zero_out(mysqli_fetch_array($q_msgreen))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; @@ -293,10 +293,10 @@ if ($goldcheck > 0) { $sql_msgold = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 3 ORDER BY gamescore DESC"; - $q_msgold = mysql_query($sql_msgold) or die(mysql_error()); + $q_msgold = mysqli_query($GLOBALS["___mysqli_link"], $sql_msgold) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; - while ($r_msgold = zero_out(mysql_fetch_array($q_msgold))) { + while ($r_msgold = zero_out(mysqli_fetch_array($q_msgold))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; diff --git a/html/pages/match_info_killsmatrix.php b/html/pages/match_info_killsmatrix.php index 3083419..41e6f8a 100644 --- a/html/pages/match_info_killsmatrix.php +++ b/html/pages/match_info_killsmatrix.php @@ -13,8 +13,8 @@ $sql_km = "SELECT killer, victim, kills FROM uts_killsmatrix WHERE matchid = $mid;"; -$q_km = mysql_query($sql_km) or die(mysql_error()); -while ($r_km = mysql_fetch_array($q_km)) { +$q_km = mysqli_query($GLOBALS["___mysqli_link"], $sql_km) or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_km = mysqli_fetch_array($q_km)) { $km[intval($r_km['killer'])][intval($r_km['victim'])] = $r_km['kills']; } @@ -40,8 +40,8 @@ $sql_players = " SELECT p.pid, AND matchid = '$mid' ORDER BY team ASC, gamescore DESC;"; -$q_players = mysql_query($sql_players) or die(mysql_error()); -while ($r_players = mysql_fetch_array($q_players)) { +$q_players = mysqli_query($GLOBALS["___mysqli_link"], $sql_players) or die(mysqli_error($GLOBALS["___mysqli_link"])); +while ($r_players = mysqli_fetch_array($q_players)) { $players[intval($r_players['playerid'])] = array( 'pid' => $r_players['pid'], 'name' => $r_players['name'], 'country' => $r_players['country'], diff --git a/html/pages/match_info_lms.php b/html/pages/match_info_lms.php index 3caffaa..21ba6c4 100644 --- a/html/pages/match_info_lms.php +++ b/html/pages/match_info_lms.php @@ -30,7 +30,7 @@ GROUP BY p.playerid ORDER BY p.gamescore DESC, (0+e.col2) DESC"; - $q_players = mysql_query($sql_players) or die(mysql_error()); + $q_players = mysqli_query($GLOBALS["___mysqli_link"], $sql_players) or die(mysqli_error($GLOBALS["___mysqli_link"])); $header = true; $totals['gamescore'] = 0; @@ -45,7 +45,7 @@ $totals['ttl'] = 0; $num = 0; - while ($r_players = zero_out(mysql_fetch_array($q_players))) { + while ($r_players = zero_out(mysqli_fetch_array($q_players))) { if ($header) { $header = false; echo ' diff --git a/html/pages/match_info_other.php b/html/pages/match_info_other.php index 63e840e..9013468 100755 --- a/html/pages/match_info_other.php +++ b/html/pages/match_info_other.php @@ -38,10 +38,10 @@ $sql_multis = "SELECT p.pid, pi.name, p.country, SUM(spree_double) AS spree_doub GROUP BY pid, p.country ORDER BY name ASC"; -$q_multis = mysql_query($sql_multis) or die(mysql_error()); +$q_multis = mysqli_query($GLOBALS["___mysqli_link"], $sql_multis) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_multis = zero_out(mysql_fetch_array($q_multis))) { +while ($r_multis = zero_out(mysqli_fetch_array($q_multis))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; $r_pname = $r_multis[name]; @@ -76,10 +76,10 @@ if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Sta GROUP BY pid, p.country ORDER BY name ASC"; - $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); + $q_pickups = mysqli_query($GLOBALS["___mysqli_link"], $sql_pickups) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; - while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { + while ($r_pickups = zero_out(mysqli_fetch_array($q_pickups))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; $r_pname = $r_pickups[name]; diff --git a/html/pages/match_info_other2.php b/html/pages/match_info_other2.php index e25d426..6c1594f 100644 --- a/html/pages/match_info_other2.php +++ b/html/pages/match_info_other2.php @@ -28,9 +28,9 @@ echo' $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC"; -$q_pickups = mysql_query($sql_pickups) or die(mysql_error()); +$q_pickups = mysqli_query($GLOBALS["___mysqli_link"], $sql_pickups) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; -while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { +while ($r_pickups = zero_out(mysqli_fetch_array($q_pickups))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; @@ -70,9 +70,9 @@ IF($mid2 == NULL) { $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid2 GROUP BY pid ORDER BY name ASC"; - $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); + $q_pickups = mysqli_query($GLOBALS["___mysqli_link"], $sql_pickups) or die(mysqli_error($GLOBALS["___mysqli_link"])); $i = 0; - while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { + while ($r_pickups = zero_out(mysqli_fetch_array($q_pickups))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; 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]); diff --git a/html/pages/players_explain_ranking.php b/html/pages/players_explain_ranking.php index 4648c3c..705a9a8 100644 --- a/html/pages/players_explain_ranking.php +++ b/html/pages/players_explain_ranking.php @@ -87,9 +87,9 @@ echo ' if ($real_gamename == "Bunny Track") { $sql_btmaprank = "SELECT e.col2 AS no, COUNT(e.col2) AS count FROM uts_events AS e, uts_player AS p WHERE p.pid = $pid AND p.gid = $gid AND p.playerid = e.playerid AND e.matchid = p.matchid AND e.col2 > 0 AND e.col2 <= 5 GROUP BY e.col2"; - $q_btmaprank = mysql_query($sql_btmaprank) or die ("Can't retrieve \$q_btmaprank: ". mysql_error()); + $q_btmaprank = mysqli_query($GLOBALS["___mysqli_link"], $sql_btmaprank) or die ("Can't retrieve \$q_btmaprank: ". mysqli_error($GLOBALS["___mysqli_link"])); $mapranks = array(); - while($r_btmaprank = mysql_fetch_assoc($q_btmaprank)) { + while($r_btmaprank = mysqli_fetch_assoc($q_btmaprank)) { $mapranks[$r_btmaprank[no]] = $r_btmaprank[count]; } diff --git a/html/pages/players_info.php b/html/pages/players_info.php index 746bac1..160cb72 100755 --- a/html/pages/players_info.php +++ b/html/pages/players_info.php @@ -2,7 +2,7 @@ global $pic_enable; $pid = isset($pid) ? $pid : $_GET['pid']; -$pid = mysql_real_escape_string(preg_replace('/\D/', '', $pid)); +$pid = mysqli_real_escape_string($GLOBALS["___mysqli_link"], preg_replace('/\D/', '', $pid)); $r_info = small_query("SELECT name, country, banned FROM uts_pinfo WHERE id = '$pid'"); @@ -74,8 +74,8 @@ if (isset($_GET['pics'])) { echo '


'; } if (!$disp) { - echo "Sorry, no pictures in this category"; - } + echo "Sorry, no pictures in this category"; + } echo ''; return; } @@ -83,7 +83,7 @@ if (isset($_GET['pics'])) { echo ' - + '; -$sql_plist = "SELECT - g.name AS gamename, - SUM(p.gamescore) AS gamescore, - COUNT(p.gamescore) as played, - SUM(p.frags) AS frags, - SUM(p.kills) AS kills, - SUM(p.deaths) AS deaths, - SUM(p.suicides) AS suicides, - SUM(p.teamkills) AS teamkills, - SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, - AVG(p.accuracy) AS accuracy, - AVG(p.ttl) AS ttl, - SUM(IF( - p.team = 0, - IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), - IF( - p.team = 1, - IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), - IF( - p.team = 2, - IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), - IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) - ) +$sql_plist = "SELECT + g.name AS gamename, + SUM(p.gamescore) AS gamescore, + COUNT(p.gamescore) as played, + SUM(p.frags) AS frags, + SUM(p.kills) AS kills, + SUM(p.deaths) AS deaths, + SUM(p.suicides) AS suicides, + SUM(p.teamkills) AS teamkills, + SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, + AVG(p.accuracy) AS accuracy, + AVG(p.ttl) AS ttl, + SUM(IF( + p.team = 0, + IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), + IF( + p.team = 1, + IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), + IF( + p.team = 2, + IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), + IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) + ) ) -)) as wins, - COUNT(p.id) AS games, - SUM(p.gametime) as gametime - FROM - uts_player AS p, - uts_games AS g, - uts_match as m - WHERE - p.gid = g.id AND m.id = p.matchid - AND - p.pid = '$pid' - GROUP BY - p.gid"; - -$q_plist = mysql_query($sql_plist) or die(mysql_error()); - -while ($r_plist = mysql_fetch_array($q_plist)) { + ) + ) as wins, + COUNT(p.id) AS games, + SUM(p.gametime) as gametime + FROM + uts_player AS p, + uts_games AS g, + uts_match as m + WHERE + p.gid = g.id AND m.id = p.matchid + AND + p.pid = '$pid' + GROUP BY + p.gid"; + +$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[kills]/$r_plist[sumeff]*100); $acc = get_dp($r_plist[accuracy]); @@ -170,29 +171,33 @@ while ($r_plist = mysql_fetch_array($q_plist)) { - - - + + + '; } $r_sumplist = small_query("SELECT 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, SUM(p.teamkills) AS teamkills, SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, -AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, COUNT(p.id) AS games, SUM(IF( - p.team = 0, - IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), - IF( - p.team = 1, - IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), - IF( - p.team = 2, - IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), - IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) - ) + SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, + AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, COUNT(p.id) AS games, + SUM(IF( + p.team = 0, + IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), + IF( + p.team = 1, + IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), + IF( + p.team = 2, + IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), + IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) ) -)) as wins, SUM(p.gametime) as gametime -FROM uts_player p, uts_match m WHERE p.matchid = m.id AND pid = '$pid'"); + ) + ) + ) as wins, SUM(p.gametime) as gametime + FROM uts_player p, uts_match m + WHERE p.matchid = m.id + AND pid = '$pid'"); $gametime = sec2hour($r_sumplist[gametime]); $eff = get_dp($r_sumplist[kills]/$r_sumplist[sumeff]*100); @@ -220,10 +225,10 @@ echo'
Career Summary for '.htmlentities($playername).' '; if (PlayerOnWatchlist($pid)) { @@ -111,47 +111,48 @@ echo ' Hours
'.$eff.' '.$acc.' '.$ttl.''.$r_plist[games].''.$r_plist[wins].''.$winpercent.'%'.$r_plist[games].''.$r_plist[wins].''.$winpercent.'% '.$gametime.'

'; -$q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); +$q_assgids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysqli_error($GLOBALS["___mysqli_link"])); $assgids = array(); -while ($r_assgids = mysql_fetch_array($q_assgids)) { +while ($r_assgids = mysqli_fetch_array($q_assgids)) { $assgids[] = $r_assgids['id']; } @@ -377,9 +382,9 @@ ORDER BY m.mapfile, 0 + e.col3 ASC"; -$q_btrecords = mysql_query($sql_btrecords) or die (mysql_error()); +$q_btrecords = mysqli_query($GLOBALS["___mysqli_link"], $sql_btrecords) or die (mysqli_error($GLOBALS["___mysqli_link"])); -if (mysql_num_rows($q_btrecords) > 0) { +if (mysqli_num_rows($q_btrecords) > 0) { echo ' @@ -393,7 +398,7 @@ if (mysql_num_rows($q_btrecords) > 0) { '; - while ($r_btrecords = mysql_fetch_array($q_btrecords)) { + while ($r_btrecords = mysqli_fetch_array($q_btrecords)) { $map = un_ut($r_btrecords['map']); $myurl = urlencode($map); $maprank = 1 + small_count("SELECT DISTINCT p.pid AS rank FROM uts_player as p, uts_events AS e, uts_match as m WHERE (m.mapfile = '" . addslashes($map) . "' OR m.mapfile = '" . addslashes($map) . ".unr') AND m.id = e.matchid AND e.matchid = p.matchid AND e.playerid = p.playerid AND e.col3 < ".$r_btrecords['time'] . " AND e.col1 = 'btcap'"); @@ -423,7 +428,7 @@ echo '
Date
Match Type -'; + '; if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') { echo ''; @@ -431,9 +436,9 @@ if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') { echo ''; $sql_rank = "SELECT g.name AS gamename, r.rank, r.prevrank, r.matches, r.gid, r.pid FROM uts_rank AS r, uts_games AS g WHERE r.gid = g.id AND r.pid = '$pid';"; -$q_rank = mysql_query($sql_rank) or die(mysql_error()); +$q_rank = mysqli_query($GLOBALS["___mysqli_link"], $sql_rank) or die(mysqli_error($GLOBALS["___mysqli_link"])); -while ($r_rank = mysql_fetch_array($q_rank)) { +while ($r_rank = mysqli_fetch_array($q_rank)) { $r_no = small_query("SELECT (COUNT(*) + 1) AS no FROM uts_rank WHERE gid= '${r_rank['gid']}' and rank > ". get_dp($r_rank['rank']) ."9"); echo' @@ -466,9 +471,9 @@ if ($r_pings and $r_pings['lowping']) { - - - + + +
Rank MatchesExplainExplainPics
Max
'.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).''.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).'
'; } @@ -485,7 +490,7 @@ $fpage = 0; if ($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } -$cpage = mysql_real_escape_string(preg_replace('/\D/', '', $_REQUEST["page"])); +$cpage = mysqli_real_escape_string($GLOBALS["___mysqli_link"], preg_replace('/\D/', '', $_REQUEST["page"])); if ($cpage == "") { $cpage = "0"; } $qpage = $cpage*50; @@ -508,18 +513,18 @@ echo'
'.$r_recent[id].''.$r_time.''.$r_recent[gamename].''.$r_mapfile.''.$r_recent[id].''.$r_time.''.$r_recent[gamename].''.$r_mapfile.''. $r_recent[ip].'
No players entered the rankings yet.Scores
'; $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].'
'.$r_bteam[name].'
Flag Returns
'.$r_mweapons[name].'
diff --git a/html/pages/watchlist.php b/html/pages/watchlist.php index 4f4cf1b..0da97eb 100755 --- a/html/pages/watchlist.php +++ b/html/pages/watchlist.php @@ -85,9 +85,9 @@ foreach ($watchlist as $pid) { $r_pinfo = small_query($sql_pinfo); - $q_players = mysql_query($sql_players) or die(mysql_error()); + $q_players = mysqli_query($GLOBALS["___mysqli_link"], $sql_players) or die(mysqli_error($GLOBALS["___mysqli_link"])); - while ($r_players = mysql_fetch_array($q_players)) { + while ($r_players = mysqli_fetch_array($q_players)) { $i++; $new = (mtimestamp($r_players['time']) > $s_lastvisit) ? true : false; $class = ($i % 2) ? 'grey' : 'grey2'; -- cgit
'.$r_mweapons[name].'