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 +- 17 files changed, 211 insertions(+), 224 deletions(-) (limited to 'html/pages/admin') 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 '
'; 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 '
'; 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_pipchec
IP
No other names found
'.$r_fakes[ip].'