PageRenderTime 62ms CodeModel.GetById 14ms RepoModel.GetById 1ms app.codeStats 0ms

/html/pages/match_info_other2.php

https://github.com/graywh/utstats
PHP | 152 lines | 139 code | 12 blank | 1 comment | 9 complexity | 83f33de1ce8e6bafcd2a655eb93c3754 MD5 | raw file
    

  1. <?php

    2. 

  2. //include('pages/match_info_killsmatrix.php');

    3. 

  3. 

    4. 

  4. include('includes/weaponstats.php');

    5. 

  5. weaponstats($mid, 0, 'Weapons Summary - '.$ass_att.' Attacking');

    6. 

  6. 

    7. 

  7. IF($mid2 != NULL) {

    8. 

  8. 	weaponstats($mid2, 0, 'Weapons Summary - '.$ass_att2.' Attacking');

    9. 

  9. }

    10. 

  10. 

    11. 

  11. echo'

    12. 

  12. <br>

    13. 

  13. <table border="0" cellpadding="0" cellspacing="2" width="720">

    14. 

  14.   <tbody><tr>

    15. 

  15.     <td class="heading" colspan="8" align="center">Pickups Summary - '.$ass_att.' Attacking</td>

    16. 

  16.   </tr>

    17. 

  17.   <tr>

    18. 

  18.     <td class="smheading" align="center">Player</td>

    19. 

  19.     <td class="smheading" align="center" width="80">Pads</td>

    20. 

  20.     <td class="smheading" align="center" width="80">Armour</td>

    21. 

  21.     <td class="smheading" align="center" width="80">Keg</td>

    22. 

  22.     <td class="smheading" align="center" width="80">Invisibility</td>

    23. 

  23.     <td class="smheading" align="center" width="80">Shield Belt</td>

    24. 

  24.     <td class="smheading" align="center" width="80">Damage Amp</td>

    25. 

  25. 	<td class="smheading" align="center" width="80">AntiGrav Boots</td>

    26. 

  26.   </tr>';

    27. 

  27. 

    28. 

  28. $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg,

    29. 

  29. SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp, SUM(p.pu_boots) AS pu_boots

    30. 

  30. FROM uts_player as p, uts_pinfo AS pi  WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC";

    31. 

  31. $q_pickups = mysql_query($sql_pickups) or die(mysql_error());

    32. 

  32. $i = 0;

    33. 

  33. while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) {

    34. 

  34.      $i++;

    35. 

  35.      $class = ($i % 2) ? 'grey' : 'grey2';

    36. 

  36. 

    37. 

  37. 	  $r_pname = $r_pickups[name];

    38. 

  38. 	  $myurl = urlencode($r_pname);

    39. 

  39. 

    40. 

  40. 	  echo'

    41. 

  41. 	  <tr>

    42. 

  42. 		<td nowrap class="darkhuman" align="left"><a class="darkhuman" href="./?p=matchp&amp;mid='.$mid.'&amp;pid='.$r_pickups[pid].'">'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).'</a></td>

    43. 

  43. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_pads].'</td>

    44. 

  44. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_armour].'</td>

    45. 

  45. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_keg].'</td>

    46. 

  46. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_invis].'</td>

    47. 

  47. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_belt].'</td>

    48. 

  48. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_amp].'</td>

    49. 

  49. 		<td class="'.$class.'" align="center">'.$r_pickups[pu_boots].'</td>

    50. 

  50. 	  </tr>';

    51. 

  51. }

    52. 

  52. 

    53. 

  53. IF($mid2 == NULL) {

    54. 

  54. } else {

    55. 

  55. 	echo'</tbody></table>

    56. 

  56. 	<br>

    57. 

  57. 	<table border="0" cellpadding="0" cellspacing="2" width="720">

    58. 

  58. 	  <tbody><tr>

    59. 

  59. 		<td class="heading" colspan="8" align="center">Pickups Summary - '.$ass_att2.' Attacking</td>

    60. 

  60. 	  </tr>

    61. 

  61. 	  <tr>

    62. 

  62. 		<td class="smheading" align="center">Player</td>

    63. 

  63. 		<td class="smheading" align="center" width="80">Pads</td>

    64. 

  64. 		<td class="smheading" align="center" width="80">Armour</td>

    65. 

  65. 		<td class="smheading" align="center" width="80">Keg</td>

    66. 

  66. 		<td class="smheading" align="center" width="80">Invisibility</td>

    67. 

  67. 		<td class="smheading" align="center" width="80">Shield Belt</td>

    68. 

  68. 		<td class="smheading" align="center" width="80">Damage Amp</td>

    69. 

  69. 		<td class="smheading" align="center" width="80">AntiGrav Boots</td>

    70. 

  70. 	  </tr>';

    71. 

  71. 

    72. 

  72. 	$sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg,

    73. 

  73. 	SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp, SUM(p.pu_boots) AS pu_boots

    74. 

  74. 	FROM uts_player as p, uts_pinfo AS pi  WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid2 GROUP BY pid ORDER BY name ASC";

    75. 

  75. 	$q_pickups = mysql_query($sql_pickups) or die(mysql_error());

    76. 

  76. 	$i = 0;

    77. 

  77. 	while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) {

    78. 

  78.      $i++;

    79. 

  79.      $class = ($i % 2) ? 'grey' : 'grey2';

    80. 

  80. 

    81. 

  81. 	  $r_pname = $r_pickups[name];

    82. 

  82. 	  $myurl = urlencode($r_pname);

    83. 

  83. 

    84. 

  84. 		  echo'

    85. 

  85. 		  <tr>

    86. 

  86. 			<td nowrap class="darkhuman" align="left"><a class="darkhuman" href="./?p=matchp&amp;mid='.$mid.'&amp;pid='.$r_pickups[pid].'">'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).'</a></td>

    87. 

  87. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_pads].'</td>

    88. 

  88. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_armour].'</td>

    89. 

  89. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_keg].'</td>

    90. 

  90. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_invis].'</td>

    91. 

  91. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_belt].'</td>

    92. 

  92. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_amp].'</td>

    93. 

  93. 			<td class="'.$class.'" align="center">'.$r_pickups[pu_boots].'</td>

    94. 

  94. 		  </tr>';

    95. 

  95. 	}

    96. 

  96. }

    97. 

  97. 

    98. 

  98. $sql_firstblood = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid");

    99. 

  99. if (!$sql_firstblood) $sql_firstblood = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL);

    100. 

  100. $sql_multis = small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, SUM(headshots) AS headshots FROM uts_player WHERE matchid = $mid");

    101. 

  101. 

    102. 

  102. IF($mid2 == NULL) {

    103. 

  103. } else {

    104. 

  104. $sql_firstblood2 = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid2");

    105. 

  105. if (!$sql_firstblood2) $sql_firstblood2 = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL);

    106. 

  106. $sql_multis2 = small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, SUM(headshots) AS headshots FROM uts_player WHERE matchid = $mid2");

    107. 

  107. }

    108. 

  108. echo'</tbody></table>

    109. 

  109. <br>

    110. 

  110. <table border="0" cellpadding="1" cellspacing="2" width="720">

    111. 

  111.   <tbody><tr>

    112. 

  112.     <td class="heading" colspan="2" align="center">Special Events - '.$ass_att.' Attacking</td>

    113. 

  113.     <td class="heading" colspan="2" align="center">Special Events - '.$ass_att2.' Attacking</td>

    114. 

  114.   </tr>

    115. 

  115.   <tr>

    116. 

  116.     <td class="dark" align="center" width="150">First Blood</td>

    117. 

  117.     <td class="grey" align="center" width="150">'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'</td>

    118. 

  118.     <td class="dark" align="center" width="150">First Blood</td>

    119. 

  119.     <td class="grey" align="center" width="150">'.FormatPlayerName($sql_firstblood2[country], $sql_firstblood2[firstblood], $sql_firstblood2[name], $gid, $gamename).'</td>

    120. 

  120.   </tr>

    121. 

  121.   <tr>

    122. 

  122.     <td class="dark" align="center">Head Shots</td>

    123. 

  123.     <td class="grey2" align="center">'.$sql_multis[headshots].'</td>

    124. 

  124.     <td class="dark" align="center">Head Shots</td>

    125. 

  125.     <td class="grey2" align="center">'.$sql_multis2[headshots].'</td>

    126. 

  126.   </tr>

    127. 

  127.   <tr>

    128. 

  128.     <td class="dark" align="center">Double Kills</td>

    129. 

  129.     <td class="grey2" align="center">'.$sql_multis[spree_double].'</td>

    130. 

  130.     <td class="dark" align="center">Double Kills</td>

    131. 

  131.     <td class="grey2" align="center">'.$sql_multis2[spree_double].'</td>

    132. 

  132.   </tr>

    133. 

  133.   <tr>

    134. 

  134.     <td class="dark" align="center">Multi Kills</td>

    135. 

  135.     <td class="grey" align="center">'.$sql_multis[spree_multi].'</td>

    136. 

  136.     <td class="dark" align="center">Multi Kills</td>

    137. 

  137.     <td class="grey" align="center">'.$sql_multis2[spree_multi].'</td>

    138. 

  138.   </tr>

    139. 

  139.   <tr>

    140. 

  140.     <td class="dark" align="center">Ultra Kills</td>

    141. 

  141.     <td class="grey2" align="center">'.$sql_multis[spree_ultra].'</td>

    142. 

  142.     <td class="dark" align="center">Ultra Kills</td>

    143. 

  143.     <td class="grey2" align="center">'.$sql_multis2[spree_ultra].'</td>

    144. 

  144.   </tr>

    145. 

  145.   <tr>

    146. 

  146.     <td class="dark" align="center">Monster Kills</td>

    147. 

  147.     <td class="grey" align="center">'.$sql_multis[spree_monster].'</td>

    148. 

  148.     <td class="dark" align="center">Monster Kills</td>

    149. 

  149.     <td class="grey" align="center">'.$sql_multis2[spree_monster].'</td>

    150. 

  150.   </tr>

    151. 

  151. </tbody></table>';

    152. 

  152. ?>

    153. 

  153.