PageRenderTime 93ms CodeModel.GetById 1ms RepoModel.GetById 0ms app.codeStats 0ms

/html/pages/admin/plm.php

https://github.com/graywh/utstats
PHP | 329 lines | 264 code | 41 blank | 24 comment | 48 complexity | db058437d5846159c2851e34b2a50446 MD5 | raw file
    

  1. <?php 

    2. 

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

    3. 

  3. 

    4. 

  4. $debug = 0; // This enables debug messages

    5. 

  5. 

    6. 

  6. /*

    7. 

  7. ** This function merges two playerss

    8. 

  8. ** @var $mplayer1 : The player to merge to

    9. 

  9. ** @var $mplayer2 : The player who gets merged into mplayer 1

    10. 

  10. ** @return null

    11. 

  11. */

    12. 

  12. function merge_players($mplayer1, $mplayer2) {

    13. 

  13.     $mp1name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer1");

    14. 

  14.     $mp2name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer2");

    15. 

  15.     

    16. 

  16.     mysql_query("DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysql_error());

    17. 

  17.     mysql_query("UPDATE uts_player SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());

    18. 

  18.     mysql_query("UPDATE uts_weaponstats SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());

    19. 

  19.     mysql_query("DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysql_error());

    20. 

  20.     mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysql_error());

    21. 

  21.     

    22. 

  22.     $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());

    23. 

  23.     while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) {

    24. 

  24.         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());

    25. 

  25.     }

    26. 

  26.     mysql_query("UPDATE uts_match SET firstblood = $mplayer1  WHERE firstblood = $mplayer2") or die(mysql_error());

    27. 

  27.     mysql_query("UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysql_error());

    28. 

  28.     $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";

    29. 

  29.     $q_nrank = mysql_query($sql_nrank) or die(mysql_error());

    30. 

  30.     while ($r_nrank = mysql_fetch_array($q_nrank)) {

    31. 

  31.     

    32. 

  32.         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());

    33. 

  33.     }

    34. 

  34.     mysql_query("DELETE FROM uts_rank WHERE pid = $mplayer2") or die(mysql_error());

    35. 

  35. }

    36. 

  36. 

    37. 

  37. // If debugmode is on, get start time

    38. 

  38. if($debug) {

    39. 

  39. 	$time = microtime();

    40. 

  40. 	$time = explode(' ', $time);

    41. 

  41. 	$time = $time[1] + $time[0];

    42. 

  42. 	$begintime = $time;

    43. 

  43. }

    44. 

  44. 

    45. 

  45. // Print header & links

    46. 

  46. echo '<P><B>Player merging tool</B></P>';

    47. 

  47. echo "<P><A href=admin.php?key=".$adminkey."&action=plm>Merge ip's</A> - <A href=admin.php?key=".$adminkey."&action=plm&onlyrange=true>Merge ip's, limited on range</A> - <A href=admin.php?key=".$adminkey."&action=plm&manignore=true>Manage ignored ip's</A> - <A href=admin.php?key=".$adminkey."&action=plm&manignore=true&onlyrange=true>Manage ignored ip's - only range</A><BR><BR></P>";

    48. 

  48. 

    49. 

  49. // CASE: MANAGE IGNORED IPS

    50. 

  50. if($_GET['manignore'] == "true") {

    51. 

  51. 	if($_POST['submit'] == "Remove from ignored list") {

    52. 

  52.     	echo "<P><B>Stopped ignore ip's</B></P>";

    53. 

  53.         foreach($_POST as $key=>$value) {

    54. 

  54.             if($key !='submit') {

    55. 

  55.                 $key = mysql_real_escape_string(str_replace("_",".",$key));

    56. 

  56.                 $query = "DELETE FROM uts_ignoreips WHERE ip = (INET_ATON('".$key."'))";

    57. 

  57.                 mysql_query($query) or die(mysql_error());

    58. 

  58.                 echo "<br>$key";

    59. 

  59.             }

    60. 

  60.         }

    61. 

  61. 	} else if($_GET['onlyrange'] == "true") {

    62. 

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

    63. 

  63. 			echo '<P><B>Ignored ip\'s in range '.htmlentities($_POST['from']).' to '.htmlentities($_POST['to']).'</B><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>';

    64. 

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

    65. 

  65. 			

    66. 

  66. 			$from = mysql_real_escape_string($_POST['from']);

    67. 

  67.     		$to = mysql_real_escape_string($_POST['to']);

    68. 

  68.     		

    69. 

  69.     	    $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to') ORDER BY ip ASC");

    70. 

  70. 	

    71. 

  71. 	        if(mysql_num_rows($ignore_ips) > 0) {

    72. 

  72. 		        while ($r_pipcheck = mysql_fetch_array($ignore_ips)) {

    73. 

  73. 		            

    74. 

  74. 		            $playerip = $r_pipcheck[ip];

    75. 

  75. 		            $trueplayerip = long2ip($playerip);

    76. 

  76. 		            $pidcount = $r_pipcheck[pidcount];

    77. 

  77. 		            

    78. 

  78. 		                echo "<br><input type=checkbox name=$trueplayerip> <b>$trueplayerip</b>";

    79. 

  79. 		                

    80. 

  80. 		                // Query for player names and ids associated to that ip during the cycle

    81. 

  81. 		                $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";

    82. 

  82. 		                $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    83. 

  83. 		                while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    84. 

  84. 		                    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> ';

    85. 

  85. 		                }

    86. 

  86. 		                echo '<br />';

    87. 

  87. 		        }

    88. 

  88. 		        echo '<BR><INPUT TYPE="SUBMIT" VALUE="Remove from ignored list" NAME="submit"></FORM>';

    89. 

  89. 		    } else {

    90. 

  90. 		    	echo "<BR><P>No ignored ip's found</P>";

    91. 

  91. 		    }

    92. 

  92.     	} else {

    93. 

  93.     		echo "<P><B>Ignored ip's in range: Enter range to filter on</B></P>";

    94. 

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

    95. 

  95.         	echo '<BR>Ranging from <INPUT TYPE="TEXT" NAME="from" SIZE="20" VALUE="0.0.0.0"> to <INPUT TYPE="TEXT" NAME="to" SIZE="20" VALUE="255.255.255.255">';

    96. 

  96.     		echo '<BR><BR><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Confirm"></FORM>';

    97. 

  97.     	}		

    98. 

  98. 	} else {

    99. 

  99. 		echo '<P><B>Ignored ip\'s</B><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>';

    100. 

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

    101. 

  101. 		

    102. 

  102.         $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips ORDER BY ip ASC");

    103. 

  103.         if(mysql_num_rows($ignore_ips) > 0) {

    104. 

  104. 	        while ($r_pipcheck = mysql_fetch_array($ignore_ips)) {

    105. 

  105. 	            

    106. 

  106. 	            $playerip = $r_pipcheck[ip];

    107. 

  107. 	            $trueplayerip = long2ip($playerip);

    108. 

  108. 	            $pidcount = $r_pipcheck[pidcount];

    109. 

  109. 	            

    110. 

  110. 	                echo "<br><input type=checkbox name=$trueplayerip> <b>$trueplayerip</b>";

    111. 

  111. 	                

    112. 

  112. 	                // Query for player names and ids associated to that ip during the cycle

    113. 

  113. 	                $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";

    114. 

  114. 	                $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    115. 

  115. 	                while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    116. 

  116. 	                    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> ';

    117. 

  117. 	                }

    118. 

  118. 	                echo '<br />';

    119. 

  119. 	        }

    120. 

  120. 	        echo '<BR><INPUT TYPE="SUBMIT" VALUE="Remove from ignored list" NAME="submit"></FORM>';

    121. 

  121. 	    } else {

    122. 

  122. 	    	echo "<BR><P>No ignored ip's found</P>";

    123. 

  123. 	    }

    124. 

  124.     }

    125. 

  125.     

    126. 

  126. // CASE: IGNORE SUBMITTED IP'S

    127. 

  127. } else if($_POST['submit'] == "ignore") {

    128. 

  128. 	echo "<P><B>Ignored ips</B></P>";

    129. 

  129.     foreach($_POST as $key=>$value) {

    130. 

  130.         if($key !='submit') {

    131. 

  131.             $key = mysql_real_escape_string(str_replace("_",".",$key));

    132. 

  132.             $query = "INSERT INTO uts_ignoreips (ip) VALUES (INET_ATON('".$key."'))";

    133. 

  133.             mysql_query($query) or die(mysql_error());

    134. 

  134.             echo "<br>$key";

    135. 

  135.         }

    136. 

  136.     }

    137. 

  137.     echo "<br>";

    138. 

  138.     

    139. 

  139. // CASE: SHOW NICKS WITH GIVEN SHARED IP   

    140. 

  140. } else if(substr($_POST['submit'],0,8) == "merge - ") {

    141. 

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

    142. 

  142. 	

    143. 

  143.     $ip = mysql_real_escape_string(str_replace("_",".",substr($_POST['submit'],8)));

    144. 

  144.     $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player WHERE ip = INET_ATON('$ip') GROUP BY ip ORDER BY ip ASC";

    145. 

  145.     $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error());

    146. 

  146.     while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) {

    147. 

  147.         

    148. 

  148.         $playerip = $r_pipcheck[ip];

    149. 

  149.         $trueplayerip = long2ip($playerip);

    150. 

  150.         $pidcount = $r_pipcheck[pidcount];

    151. 

  151.         

    152. 

  152.         // If there is more than one pid associated to an IP ...

    153. 

  153.         IF ($pidcount > 1 ) {

    154. 

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

    155. 

  155.             echo "<br><b>$trueplayerip</b>";

    156. 

  156.             

    157. 

  157.             // Query for player names and ids associated to that ip during the cycle

    158. 

  158.             $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";

    159. 

  159.             

    160. 

  160.             $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    161. 

  161.             while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    162. 

  162.                 echo '<br><a class="darkhuman" href="./?p=pinfo&amp;pid='.$r_pcheck[pid].'">'.FormatPlayerName($r_pcheck[country], $r_pcheck['pid'], $r_pcheck['name']).'</a> ';

    163. 

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

    164. 

  164.             }

    165. 

  165.             echo '<br><br>Merge to: <SELECT NAME="merge_to">'.$options.'</SELECT>';

    166. 

  166.             echo "<br><INPUT TYPE=\"hidden\" NAME=\"ip\" VALUE=\"$ip\"><INPUT TYPE=\"SUBMIT\" VALUE=\"Player merge\" NAME=\"submit\"></FORM>";

    167. 

  167.             echo '<br />';

    168. 

  168.         }

    169. 

  169.     }

    170. 

  170.         

    171. 

  171. // CASE: MERGE NICKS WITH SHARED IP              

    172. 

  172. } else if($_POST['submit'] == "Player merge") {

    173. 

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

    174. 

  174. 	

    175. 

  175.     $ip = mysql_real_escape_string(str_replace("_",".",$_POST['ip']));

    176. 

  176.     $merge_to_pid = mysql_real_escape_string($_POST['merge_to']);

    177. 

  177.     $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player WHERE ip = INET_ATON('$ip') GROUP BY ip ORDER BY ip ASC";

    178. 

  178.     $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error());

    179. 

  179.     while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) {

    180. 

  180.         

    181. 

  181.         $playerip = $r_pipcheck[ip];

    182. 

  182.         $trueplayerip = long2ip($playerip);

    183. 

  183.         $pidcount = $r_pipcheck[pidcount];

    184. 

  184.         

    185. 

  185.         // If there is more than one pid associated to an IP ...

    186. 

  186.         IF ($pidcount > 1 ) {

    187. 

  187.             echo "<b>$trueplayerip</b><br><br>merge:<br>";

    188. 

  188.             

    189. 

  189.             // Query for player names and ids associated to that ip during the cycle

    190. 

  190.             $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";

    191. 

  191.             

    192. 

  192.             $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    193. 

  193.             $i=0;

    194. 

  194.             while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    195. 

  195.                 if($r_pcheck['pid'] != $merge_to_pid) {

    196. 

  196.                     $pid_from[$i] = $r_pcheck['pid'];

    197. 

  197.                     echo $pid_from[$i].'<br>';

    198. 

  198.                     $i++;

    199. 

  199.                 }

    200. 

  200.             }

    201. 

  201.             echo '<br />merge to: '.$merge_to_pid;

    202. 

  202.         }

    203. 

  203.     }

    204. 

  204.     if($debug) echo "<br> -- started merging";

    205. 

  205.     for($j=0;$j<count($pid_from);$j++) {

    206. 

  206.         merge_players($merge_to_pid, $pid_from[$j]);

    207. 

  207.     }

    208. 

  208.     if($debug) echo "<br> -- merging ended";

    209. 

  209.     

    210. 

  210. // CASE: SHOW ALL IP'S LINKED TO MORE THAN ONE NICK - ONLY RANGE    

    211. 

  211. } else if($_GET['onlyrange'] == "true") {

    212. 

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

    213. 

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

    214. 

  214. 		$from = mysql_real_escape_string($_POST['from']);

    215. 

  215. 		$to = mysql_real_escape_string($_POST['to']);

    216. 

  216. 		

    217. 

  217. 	    $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to')");

    218. 

  218. 	    $extended_query = "WHERE ip >= INET_ATON('$from') AND ip <= INET_ATON('$to')";

    219. 

  219. 	    $i=0;

    220. 

  220. 	    while($ignore_ips_array = mysql_fetch_array($ignore_ips)) {

    221. 

  221. 	        $ip = $ignore_ips_array[0];

    222. 

  222. 	        $extended_query .= " AND ";

    223. 

  223. 	        $extended_query .= "ip <> '".$ip."'";

    224. 

  224. 	        $i++;

    225. 

  225. 	    }

    226. 

  226. 	    

    227. 

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

    228. 

  228. 	    

    229. 

  229. 	                

    230. 

  230. 	    // Query for list of unique ips and player ids

    231. 

  231. 	    $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player ".$extended_query." GROUP BY ip ORDER BY ip ASC";

    232. 

  232. 	    $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error());

    233. 

  233. 	    if(mysql_num_rows($q_pipcheck) > 0) {

    234. 

  234. 		    while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) {

    235. 

  235. 		        

    236. 

  236. 		        $playerip = $r_pipcheck[ip];

    237. 

  237. 		        $trueplayerip = long2ip($playerip);

    238. 

  238. 		        $pidcount = $r_pipcheck[pidcount];

    239. 

  239. 		        

    240. 

  240. 		        // If there is more than one pid associated to an IP ...

    241. 

  241. 		        IF ($pidcount > 1 ) {

    242. 

  242. 		            

    243. 

  243. 		            echo "<br><input type=checkbox name=$trueplayerip> <b>$trueplayerip</b>";

    244. 

  244. 		            

    245. 

  245. 		            // Query for player names and ids associated to that ip during the cycle

    246. 

  246. 		            $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";

    247. 

  247. 		            $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    248. 

  248. 		            while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    249. 

  249. 		                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> ';

    250. 

  250. 		            }	

    251. 

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

    252. 

  252. 		            echo '<br />';

    253. 

  253. 		        }

    254. 

  254. 		    }

    255. 

  255. 		    

    256. 

  256. 		    

    257. 

  257. 		    echo '<BR><INPUT TYPE="SUBMIT" VALUE="ignore" NAME="submit"></FORM>';	

    258. 

  258. 	    } else {

    259. 

  259. 			echo "<P><BR>No ip's found with more than one nick linked to it and which are not ignored and are in this range</P>";	

    260. 

  260. 		}

    261. 

  261. 	    	

    262. 

  262. 	} else {

    263. 

  263. 		echo "<P><B>Showing all ip's in range - Enter range to filter on</B></P>";

    264. 

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

    265. 

  265.     	echo '<BR>Ranging from <INPUT TYPE="TEXT" NAME="from" SIZE="20" VALUE="0.0.0.0"> to <INPUT TYPE="TEXT" NAME="to" SIZE="20" VALUE="255.255.255.255">';

    266. 

  266. 		echo '<BR><BR><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Confirm"></FORM>';

    267. 

  267. 	}	

    268. 

  268. 

    269. 

  269. // CASE: SHOW ALL IP'S LINKED TO MORE THAN ONE NICK

    270. 

  270. } else {

    271. 

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

    272. 

  272. 	

    273. 

  273.     $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips");

    274. 

  274.     $extended_query = "";

    275. 

  275.     $i=0;

    276. 

  276.     while($ignore_ips_array = mysql_fetch_array($ignore_ips)) {

    277. 

  277.         $ip = $ignore_ips_array[0];

    278. 

  278.         if($i==0)

    279. 

  279.             $extended_query = " WHERE ";

    280. 

  280.         else

    281. 

  281.             $extended_query .= " AND ";

    282. 

  282.         $extended_query .= "ip <> '".$ip."'";

    283. 

  283.         $i++;

    284. 

  284.     }

    285. 

  285.     

    286. 

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

    287. 

  287.     

    288. 

  288.                 

    289. 

  289.     // Query for list of unique ips and player ids

    290. 

  290.     $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player ".$extended_query." GROUP BY ip ORDER BY ip ASC";

    291. 

  291.     $q_pipcheck = mysql_query($sql_pipcheck) or die(mysql_error());

    292. 

  292.     if(mysql_num_rows($q_pipcheck) > 0) {

    293. 

  293. 	    while ($r_pipcheck = mysql_fetch_array($q_pipcheck)) {

    294. 

  294. 	        

    295. 

  295. 	        $playerip = $r_pipcheck[ip];

    296. 

  296. 	        $trueplayerip = long2ip($playerip);

    297. 

  297. 	        $pidcount = $r_pipcheck[pidcount];

    298. 

  298. 	        

    299. 

  299. 	        // If there is more than one pid associated to an IP ...

    300. 

  300. 	        IF ($pidcount > 1 ) {

    301. 

  301. 	            

    302. 

  302. 	            echo "<br><input type=checkbox name=$trueplayerip> <b>$trueplayerip</b>";

    303. 

  303. 	            

    304. 

  304. 	            // Query for player names and ids associated to that ip during the cycle

    305. 

  305. 	            $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";

    306. 

  306. 	            $q_pcheck = mysql_query($sql_pcheck) or die(mysql_error());

    307. 

  307. 	            while ($r_pcheck = mysql_fetch_array($q_pcheck)) {

    308. 

  308. 	                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> ';

    309. 

  309. 	            }	

    310. 

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

    311. 

  311. 	            echo '<br />';

    312. 

  312. 	        }

    313. 

  313. 	    }

    314. 

  314.     	echo '<BR><INPUT TYPE="SUBMIT" VALUE="ignore" NAME="submit"></FORM>';

    315. 

  315.     } else {

    316. 

  316.     	echo "<P><BR>No ip's found with more than one nick linked to it and which are not ignored</P>";	

    317. 

  317.     }

    318. 

  318. }

    319. 

  319. 

    320. 

  320. // If debugmode is on, determine end time & output execution time

    321. 

  321. if($debug) {

    322. 

  322. 	$time = microtime();

    323. 

  323. 	$time = explode(" ", $time);

    324. 

  324. 	$time = $time[1] + $time[0];

    325. 

  325. 	$endtime = $time;

    326. 

  326. 	$totaltime = ($endtime - $begintime);

    327. 

  327. 	echo "<br>execution time: $totaltime";

    328. 

  328. }

    329. 

  329. ?>
    330.