Update to mysqli

17 files changed, 211 insertions, 224 deletions

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 '
-	<table class="box" border="0" cellpadding="1" cellspacing="2">
+<table class="box" border="0" cellpadding="1" cellspacing="2">
 	<tr>
 		<td class="smheading" align="center" height="25" width="550" colspan="2">Checking access rights</td>
 	</tr>';
 
 // 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 '
 	<tr>
 		<td class="smheading" align="left" width="350">', $dir, '</td>';
 	if (!file_exists($dir)) {
 		if (mkdir($dir, 0777)) {
-		      echo '
-			    <td class="warn" align="left" width="200">Created</td></tr>';
+      echo '<td class="warn" align="left" width="200">Created</td></tr>';
 		}
 		else {
-		      echo '
-			    <td class="warn" align="left" width="200">Not found!</td></tr>';
+      echo '<td class="warn" align="left" width="200">Not found!</td></tr>';
 		}
 	}
 	else if (!is_dir($dir)) {
-		echo '
-		      <td class="warn" align="left" width="200">Not a directory!</td></tr>';
+		echo '<td class="warn" align="left" width="200">Not a directory!</td></tr>';
 	}
 	else if (!is_writable($dir)) {
 		if (@chmod($dir, 0777)) {
-			echo '
-			      <td class="grey" align="left" width="200">SET</td></tr>';
+			echo '<td class="grey" align="left" width="200">SET</td></tr>';
 		}
 		else {
-			echo '
-			      <td class="warn" align="left" width="200">Incorrect access rights: ' , substr(sprintf('%o', fileperms($dir)), -4) , '</td></tr>';
+			echo '<td class="warn" align="left" width="200">Incorrect access rights: ' , substr(sprintf('%o', fileperms($dir)), -4) , '</td></tr>';
 		}
 	}
 	else {
-		echo '
-		      <td class="grey" align="left" width="200">OK</td></tr>';
+		echo '<td class="grey" align="left" width="200">OK</td></tr>';
 	}
 }
 
@@ -58,39 +51,33 @@ foreach (array("includes/ftptimestamp.php") as $file)
 	<tr>
 		<td class="smheading" align="left" width="350">', $file, '</td>';
 	if (!file_exists($file)) {
-		echo '
-		      <td class="warn" align="left" width="200">Not found!</td></tr>';
+		echo '<td class="warn" align="left" width="200">Not found!</td></tr>';
 	}
 	else if (!is_file($file)) {
-		echo '
-		      <td class="warn" align="left" width="200">Not a file!</td></tr>';
+		echo '<td class="warn" align="left" width="200">Not a file!</td></tr>';
 	}
 	else if (!is_writable($file)) {
 		if (@chmod($file, 0777)) {
-			echo '
-			      <td class="grey" align="left" width="200">SET</td></tr>';
+			echo '<td class="grey" align="left" width="200">SET</td></tr>';
 		}
 		else {
-			echo '
-			      <td class="warn" align="left" width="200">Incorrect access rights: ' , substr(sprintf('%o', fileperms($file)), -4) , '</td></tr>';
+			echo '<td class="warn" align="left" width="200">Incorrect access rights: ' , substr(sprintf('%o', fileperms($file)), -4) , '</td></tr>';
 		}
 	}
 	else {
-		echo '
-		      <td class="grey" align="left" width="200">OK</td></tr>';
+		echo '<td class="grey" align="left" width="200">OK</td></tr>';
 	}
 }
 
-echo '
-	</tbody></table>
+echo '</tbody></table>
 <div class="opnote">* Might not work correctly on Windows systems *</div><br>';
 
 
 // connect to the database and check structure
 echo '
-	<table class="box" border="0" cellpadding="1" cellspacing="2">
+<table class="box" border="0" cellpadding="1" cellspacing="2">
 	<tr>
-		<td class="smheading" align="center" height="25" width="550" colspan="2">Checking mysql tables</td>
+		<td class="smheading" align="center" height="25" width="550" colspan="2">Checking MySQL tables</td>
 	</tr>';
 
 // database creation array
@@ -337,7 +324,7 @@ foreach ($create_table as $table => $query) {
 		      <td class="grey" align="left" width="200">OK</td></tr>';
 	}
 	else {
-		if (mysql_query($query)) {
+		if (mysqli_query($GLOBALS["___mysqli_link"], $query)) {
 			echo '
 		      <td class="grey" align="left" width="200">Created</td></tr>';
 		}
@@ -349,7 +336,7 @@ foreach ($create_table as $table => $query) {
 }
 echo '
 	</tbody></table><br>';
-	
+
 // 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 {
 			      <td class="grey" align="left" width="200">OK</td></tr>';
 		}
 		else {
-			if (mysql_query($query)) {
+			if (mysqli_query($GLOBALS["___mysqli_link"], $query)) {
 				echo '
 			      <td class="grey" align="left" width="200">Added</td></tr>';
 			}
@@ -442,7 +429,7 @@ else {
 			      <td class="grey" align="left" width="200">OK</td></tr>';
 		}
 		else {
-			if (mysql_query($query)) {
+			if (mysqli_query($GLOBALS["___mysqli_link"], $query)) {
 				echo '
 			      <td class="grey" align="left" width="200">Added</td></tr>';
 			}
@@ -466,8 +453,8 @@ echo '
 	<tr>
 		<td class="smheading" align="left" width="350">Fix BT cap times</td>';
 
-	$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 '<tr><td class="smheading" align="center" colspan="4"><a class="grey" href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td></tr>';
 echo '</tbody></table>';
 
-?>
\ 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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 <tr>

 	<td class="smheading" align="left" width="200">Adjusting Rankings</td>';

 $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'<td class="grey" align="left" width="700">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Match Record:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Player Records:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Kill Matrix Entries:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Weapon Stats:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Player Weapon Stats:</td>';

 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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Global Weapon Stats:</td>';

-	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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing events:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

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'<table border="0" cellpadding="0" cellspacing="0" width="600">
 </tr>

 <tr>

 	<td class="smheading" align="left">Removing Kill Matrix Entries:</td>';

-	$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'<td class="grey" align="left">Done</td>

 </tr>

@@ -32,7 +32,7 @@ echo'<table border="0" cellpadding="0" cellspacing="0" width="600">
 	<td class="smheading" align="left" width="300">Removing Player Info:</td>';

 $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'<td class="grey" align="left" width="300">Done</td>';

 } else {

 	echo'<td class="grey" align="left" width="300">No (player banned)</td>';

@@ -41,31 +41,31 @@ echo '
 </tr>

 <tr>

 	<td class="smheading" align="left">Removing Player Match Events:</td>';

-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'<td class="grey" align="left">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left">Removing Player Match Records:</td>';

-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'<td class="grey" align="left">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left">Removing Player Rank:</td>';

-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'<td class="grey" align="left">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left">Removing Player Weapon Stats:</td>';

-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'<td class="grey" align="left">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Global Weapon Stats:</td>';

-	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'<td class="grey" align="left" width="400">Done</td>

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'<td class="grey" align="left" width="400">Done</td>';

 }

 echo'</tr>

 <tr>

 	<td class="smheading" align="left">Removing Kill Matrix Entries:</td>';

-	$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'<td class="grey" align="left">Done</td>

 </tr>

@@ -65,36 +65,36 @@ echo'</tr>
 

 <tr>

 	<td class="smheading" align="left" width="200">Removing Player Weapon Stats:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Player Events:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Player From Match:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Player Weapon Stats:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Global Weapon Stats:</td>';

-	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'<td class="grey" align="left" width="400">Done</td>

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 

 

 $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 '<tr>';

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">

@@ -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'<td class="grey" align="left" width="400">Done (updated '.mysql_affected_rows().' records)</td>

+		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'<td class="grey" align="left" width="400">Done (updated '.mysqli_affected_rows($GLOBALS["___mysqli_link"]).' records)</td>

 				</tr>

 

 

@@ -59,8 +59,8 @@ if (isset($_REQUEST['submit'])) {
 

 				<tr>

 					<td class="smheading" align="left" width="200">Updating Matches</td>';

-		mysql_query("UPDATE uts_match m SET m.gid = '". my_addslashes($_REQUEST['gid']) ."' $where;") or die(mysql_error());

-		echo'<td class="grey" align="left" width="400">Done (updated '.mysql_affected_rows().' matches)</td>

+		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'<td class="grey" align="left" width="400">Done (updated '.mysqli_affected_rows($GLOBALS["___mysqli_link"]).' matches)</td>

 				</tr>

 

 

@@ -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'<td class="grey" align="left" width="400">Done (recalculated '.$num_ranks.' rankings)</td>

@@ -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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 

 

 $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 '<tr>';

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 

 

 $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 '<tr>';

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

     </td>';

 

-    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 '<td class="grey" align="left" width="300">Done</td>

   </tr>

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 

 

 $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 '<tr>';

 	echo '<td class="dark" align="center" valign="top" width="150">';

 	echo '<a class="darkhuman" href="admin.php?action=pinfo&amp;pid='.$r_players['pid'].'">'.$r_players['name'].'</a></td>';

 	$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 '<td class="grey">';

 	echo '<table width="100%" border="0" cellspacing="0" cellpadding="2">';

-	$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 '<tr><td class="'.$class.'" align="center" width="60%">';

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'<table class = "box" border="0" cellpadding="0" cellspacing="0" width="600"
 	<td class="smheading" align="center" height="25" colspan="4">Database Statistics</td>

 </tr>';

 

-$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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Info Records</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Updating Player Records</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Updating Weapon Records</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Amending Player Weapon Stats:</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Updating First Blood Records</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Temporary Rank</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Creating New Rank</td>';

 

 $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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Removing Old Rank</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 </tr>

 <tr>

 	<td class="smheading" align="left" width="200">Merging Records</td>';

-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'<td class="grey" align="left" width="400">Done</td>

 </tr>

 <tr>

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) {
 	</tr>

 	<tr>

 		<td class="smheading" align="left">Removing Player Rank:</td>';

-	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'<td class="grey" align="left">Done</td>

 	</tr>

 	<tr>

 		<td class="smheading" align="left">Updating Player Record:</td>';

-	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'<td class="grey" align="left">Done</td>

 	</tr>

 	

@@ -51,17 +51,17 @@ if ($ban) {
 	</tr>

 	<tr>

 		<td class="smheading" align="left">Updating Player Record:</td>';

-	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'<td class="grey" align="left">Done</td>

 	</tr>

 	<tr>

 		<td class="smheading" align="left" width="200">Restoring Rankings</td>';

 	

 	$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'<td class="grey" align="left" width="400">Done</td>

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 @@
 <?php

 if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');

-	

+

 $options['title'] = 'Extended Player Info';

 $options['requireconfirmation'] = false;

 $i = 0;

@@ -23,7 +23,7 @@ include('pages/players_info.php');
 echo '<br>';

 

 $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 '

 <table class = "box" border="0" cellpadding="0" cellspacing="0" width="720">

   <tbody>

@@ -32,14 +32,14 @@ echo '
   </tr>

   <tr>

     <td class="smheading" width="80" align = "center">IP</td>

-    <td class="smheading" width="180" align = "left">Hostname</td>  

+    <td class="smheading" width="180" align = "left">Hostname</td>

     <td class="smheading" width="60" align = "center">Matches</td>

     <td class="smheading" width="200" align = "left">First</td>

     <td class="smheading" width="200" align = "left">Last</td>

   </tr>';

 

-while ($r_ips = mysql_fetch_assoc($q_ips)) {

-      echo '

+while ($r_ips = mysqli_fetch_assoc($q_ips)) {

+  echo '

   <tr>

     <td class="grey" align = "center">'.$r_ips['ip'].'</td>

     <td class="grey" align = "left">'.gethostbyaddr($r_ips['ip']).'</td>

@@ -55,10 +55,10 @@ echo '
 <div class="opnote">* Hostnames are real time and might have been different at the time of playing. *</div>

 <br>';

 

-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 '

 <table class = "box" border="0" cellpadding="0" cellspacing="0" width="480">

   <tbody>

@@ -70,14 +70,14 @@ echo '
     <td class="smheading" width="360" align = "center">IP</td>

   </tr>';

 

-if (mysql_num_rows($q_fakes) == 0) {

+if (mysqli_num_rows($q_fakes) == 0) {

 	      echo '

 	  <tr>

 	    <td class="grey" align = "center" colspan="2">No other names found</td>

 	  </tr>';

 }

 else {

-	while($r_fakes = mysql_fetch_assoc($q_fakes)) {

+	while($r_fakes = mysqli_fetch_assoc($q_fakes)) {

 	      echo '

 	  <tr>

 	    <td class="grey" align = "center">'.$r_fakes[ip].'</td>

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 "<P>Stopped ignore ip's</P>";

         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 "<br>$key";

             }

         }

@@ -63,13 +63,13 @@ if($_GET['manignore'] == "true") {
 			echo '<P>Ignored ip\'s in range '.htmlentities($_POST['from']).' to '.htmlentities($_POST['to']).'<br><I>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</I></P>';

 			echo '<FORM METHOD="POST" ACTION="admin.php?key='.$adminkey.'&action=plm&manignore=true" target="_blank">';    		

 			

-			$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 '<br><a class="darkhuman" href="admin.php?key='.$adminkey.'&amp;action=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

 		                }

 		                echo '<br />';

@@ -99,9 +99,9 @@ if($_GET['manignore'] == "true") {
 		echo '<P>Ignored ip\'s<br><I>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</I></P>';

 		echo '<FORM METHOD="POST" ACTION="admin.php?key='.$adminkey.'&action=plm&manignore=true" target="_blank">';

 		

-        $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 '<br><a class="darkhuman" href="admin.php?key='.$adminkey.'&amp;action=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

 	                }

 	                echo '<br />';

@@ -128,9 +128,9 @@ if($_GET['manignore'] == "true") {
 	echo "<P>Ignored ips</P>";

     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 "<br>$key";

         }

     }

@@ -140,10 +140,10 @@ if($_GET['manignore'] == "true") {
 } else if(substr($_POST['submit'],0,8) == "merge - ") {

 	echo "<P>Merge nicks with shared ip</P>";

 	

-    $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 '<br><a class="darkhuman" href="./?p=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

                 $options .= '<OPTION value="'.$r_pcheck[pid].'">'.$r_pcheck['name'].'</OPTION>';

             }

@@ -172,11 +172,11 @@ if($_GET['manignore'] == "true") {
 } else if($_POST['submit'] == "Player merge") {

 	echo "<P>Merging nicks with shared ip</P>";

 	

-    $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].'<br>';

@@ -211,13 +211,13 @@ if($_GET['manignore'] == "true") {
 } else if($_GET['onlyrange'] == "true") {

 	if($_POST['submit'] == "Confirm") {

 		echo "<P>Showing all ip's in range ".htmlentities($_POST['from'])." to ".htmlentities($_POST['to'])."<br><I>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</I></P>";

-		$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 '<br><a class="darkhuman" href="admin.php?key='.$adminkey.'&amp;action=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

 		            }	

 		            echo "<br><INPUT TYPE=\"SUBMIT\" VALUE=\"merge - $trueplayerip\" NAME=\"submit\">";

@@ -270,10 +270,10 @@ if($_GET['manignore'] == "true") {
 } else {

 	echo "<P>IP's linked with more than one nick<br><I>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</I></P>";

 	

-    $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 '<br><a class="darkhuman" href="admin.php?key='.$adminkey.'&amp;action=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

 	            }	

 	            echo "<br><INPUT TYPE=\"SUBMIT\" VALUE=\"merge - $trueplayerip\" NAME=\"submit\">";

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'</tr>
 

 	echo'Recalculating pinfo table...<br>';

 	/* 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...<br>';

 	/* 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</td>

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'<br><table border="0" cellpadding="0" cellspacing="0" width="600">
 echo'<tr>

 	<td class="smheading" align="left" width="200">Deleting rankings</td>';

 

-	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'<td class="grey" align="left" width="400">Done</td>';

 

@@ -39,7 +39,7 @@ echo'</tr>
 	<td class="smheading" align="left">Recalculating Rankings:</td>';

 	echo'<td class="grey" align="left">';

 	$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'</tr>
 									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 '. ';