PageRenderTime 48ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/html/pages/admin/dplayer.php

https://github.com/graywh/utstats
PHP | 100 lines | 95 code | 5 blank | 0 comment | 5 complexity | 97385d9e12641d62c72b611a0723a31c MD5 | raw file
  1. <?php
  2. if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');
  3. $options['title'] = 'Delete Player';
  4. $i = 0;
  5. $options['vars'][$i]['name'] = 'pid';
  6. $options['vars'][$i]['type'] = 'player';
  7. $options['vars'][$i]['prompt'] = 'Choose the player you want to delete:';
  8. $options['vars'][$i]['caption'] = 'Player to delete:';
  9. $i++;
  10. $results = adminselect($options);
  11. $pid = $results['pid'];
  12. $playerid = $pid;
  13. echo'<table border="0" cellpadding="1" cellspacing="2" width="600">
  14. <tr>
  15. <td class="smheading" align="center" colspan="2">Deleting Player</td>
  16. </tr>
  17. <tr>
  18. <td class="smheading" align="left">Removing Kill Matrix Entries:</td>';
  19. $q_match = mysql_query("SELECT matchid, playerid FROM uts_player WHERE pid = '$pid'") or die(mysql_error());
  20. while ($r_match = mysql_fetch_array($q_match))
  21. {
  22. 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());
  23. }
  24. echo'<td class="grey" align="left">Done</td>
  25. </tr>
  26. <tr>
  27. <td class="smheading" align="left" width="300">Removing Player Info:</td>';
  28. $r_pinfo = small_query("SELECT banned FROM uts_pinfo WHERE id = $playerid");
  29. if ($r_pinfo['banned'] != 'Y')
  30. {
  31. mysql_query("DELETE FROM uts_pinfo WHERE id = $playerid") or die(mysql_error());
  32. echo'<td class="grey" align="left" width="300">Done</td>';
  33. }
  34. else
  35. {
  36. echo'<td class="grey" align="left" width="300">No (player banned)</td>';
  37. }
  38. echo '
  39. </tr>
  40. <tr>
  41. <td class="smheading" align="left">Removing Player Match Records:</td>';
  42. mysql_query("DELETE FROM uts_player WHERE pid = $playerid") or die(mysql_error());
  43. echo'<td class="grey" align="left">Done</td>
  44. </tr>
  45. <tr>
  46. <td class="smheading" align="left">Removing Player Rank:</td>';
  47. mysql_query("DELETE FROM uts_rank WHERE pid = $playerid") or die(mysql_error());
  48. echo'<td class="grey" align="left">Done</td>
  49. </tr>
  50. <tr>
  51. <td class="smheading" align="left">Removing Player Weapon Stats:</td>';
  52. $q_match = mysql_query("SELECT matchid FROM uts_weaponstats WHERE pid = '$playerid' AND weapon = 0;") or die(mysql_error());
  53. mysql_query("DELETE FROM uts_weaponstats WHERE pid = $playerid") or die(mysql_error());
  54. echo'<td class="grey" align="left">Done</td>
  55. </tr>
  56. tr>
  57. <tr>
  58. <td class="smheading" align="left" width="200">Amending Global Weapon Stats:</td>';
  59. mysql_query(" REPLACE uts_weaponstats
  60. SELECT 0 AS matchid,
  61. 0 AS pid,
  62. weapon,
  63. SUM(kills) AS kills,
  64. SUM(shots) AS shots,
  65. SUM(hits) AS hits,
  66. SUM(damage) AS damage,
  67. LEAST(ROUND(10000*SUM(hits)/SUM(shots))/100, 100) AS acc
  68. FROM uts_weaponstats
  69. WHERE matchid > 0
  70. AND pid > 0
  71. AND weapon > 0
  72. GROUP BY weapon;"
  73. ) or die(mysql_error());
  74. mysql_query(" REPLACE uts_weaponstats
  75. SELECT 0 AS matchid,
  76. 0 AS pid,
  77. 0 AS weapon,
  78. SUM(kills) AS kills,
  79. SUM(shots) AS shots,
  80. SUM(hits) AS hits,
  81. SUM(damage) AS damage,
  82. LEAST(ROUND(10000*SUM(hits)/SUM(shots))/100, 100) AS acc
  83. FROM uts_weaponstats
  84. WHERE matchid > 0
  85. AND pid > 0
  86. AND weapon > 0;"
  87. ) or die(mysql_error());
  88. echo'<td class="grey" align="left" width="400">Done</td>
  89. </tr>
  90. <tr>
  91. <td class="smheading" align="center" colspan="2">Player Deleted - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
  92. </tr></table>';
  93. ?>