PageRenderTime 50ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 0ms

/html/pages/totals.php

https://github.com/graywh/utstats
PHP | 808 lines | 337 code | 33 blank | 438 comment | 19 complexity | 634b024c709c8e59486c06cb580e04b1 MD5 | raw file
    

  1. <?php

    2. 

  2. echo'

    3. 

  3. <table border="0" cellpadding="1" cellspacing="2" width="710">

    4. 

  4.   <tbody><tr>

    5. 

  5.     <td class="heading" align="center">Totals Summary</td>

    6. 

  6.   </tr>

    7. 

  7. </tbody></table>

    8. 

  8. <br>

    9. 

  9. <table class="box" border="0" cellpadding="1" cellspacing="2">

    10. 

  10.   <tbody><tr>

    11. 

  11.     <td class="medheading" colspan="10" align="center">Summary</td>

    12. 

  12.   </tr>

    13. 

  13.   <tr>

    14. 

  14.     <td class="smheading" align="center" width="150">Game Type</td>

    15. 

  15.     <td class="smheading" align="center" width="45">Score</td>

    16. 

  16.     <td class="smheading" align="center" width="35">Frags</td>

    17. 

  17.     <td class="smheading" align="center" width="35">Kills</td>

    18. 

  18.     <td class="smheading" align="center" width="35">Suicides</td>

    19. 

  19.     <td class="smheading" align="center" width="35">Team Kills</td>

    20. 

  20.     <td class="smheading" align="center" width="50">Matches</td>

    21. 

  21.     <td class="smheading" align="center" width="45">Hours</td>

    22. 

  22.   </tr>';

    23. 

  23. 

    24. 

  24. $sql_totsumm = "SELECT g.name AS gamename, SUM(p.gamescore) AS gamescore, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, COUNT(DISTINCT p.matchid) AS matchcount, SUM(p.gametime) AS sumgametime

    25. 

  25. FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id GROUP BY gamename ORDER BY gamename ASC";

    26. 

  26. $q_totsumm = mysql_query($sql_totsumm) or die(mysql_error());

    27. 

  27. while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) {

    28. 

  28. 

    29. 

  29. 	$gametime = sec2hour($r_totsumm[sumgametime]);

    30. 

  30. 

    31. 

  31. 	echo'

    32. 

  32. 	  <tr>

    33. 

  33. 	    <td class="dark" align="center">'.$r_totsumm['gamename'].'</td>

    34. 

  34. 	    <td class="grey" align="center">'.$r_totsumm['gamescore'].'</td>

    35. 

  35. 	    <td class="grey" align="center">'.$r_totsumm['frags'].'</td>

    36. 

  36. 	    <td class="grey" align="center">'.$r_totsumm['kills'].'</td>

    37. 

  37. 	    <td class="grey" align="center">'.$r_totsumm['suicides'].'</td>

    38. 

  38. 	    <td class="grey" align="center">'.$r_totsumm['teamkills'].'</td>

    39. 

  39. 	    <td class="grey" align="center">'.$r_totsumm['matchcount'].'</td>

    40. 

  40. 	    <td class="grey" align="center">'.$gametime.'</td>

    41. 

  41. 	  </tr>';

    42. 

  42. }

    43. 

  43. 

    44. 

  44. $sql_summtot = zero_out(small_query("SELECT SUM(gamescore) AS gamescore, SUM(frags) AS frags, SUM(kills) AS kills, SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, COUNT(DISTINCT matchid) AS matchcount, SUM(gametime) AS sumgametime

    45. 

  45. FROM uts_player"));

    46. 

  46. 

    47. 

  47. $gametime2 = sec2hour($sql_summtot[sumgametime]);

    48. 

  48. 

    49. 

  49. echo'

    50. 

  50.     <tr>

    51. 

  51.     <td class="dark" align="center"><b>Totals</b></td>

    52. 

  52. 	    <td class="grey" align="center">'.$sql_summtot['gamescore'].'</td>

    53. 

  53. 	    <td class="grey" align="center">'.$sql_summtot['frags'].'</td>

    54. 

  54. 	    <td class="grey" align="center">'.$sql_summtot['kills'].'</td>

    55. 

  55. 	    <td class="grey" align="center">'.$sql_summtot['suicides'].'</td>

    56. 

  56. 	    <td class="grey" align="center">'.$sql_summtot['teamkills'].'</td>

    57. 

  57. 	    <td class="grey" align="center">'.$sql_summtot['matchcount'].'</td>

    58. 

  58. 	    <td class="grey" align="center">'.$gametime2.'</td>

    59. 

  59.   </tr>

    60. 

  60. </tbody></table>

    61. 

  61. <br>

    62. 

  62. <table border="0" cellpadding="1" cellspacing="2" width="600">

    63. 

  63.   <tbody><tr>

    64. 

  64.     <td class="medheading" colspan="11" align="center">Assault, Domination and CTF Events Summary</td>

    65. 

  65.   </tr>

    66. 

  66.   <tr>

    67. 

  67.     <td class="dark" align="center" rowspan="2">Assault Objectives</td>

    68. 

  68.     <td class="dark" align="center" rowspan="2">Control Point Captures</td>

    69. 

  69.     <td class="dark" align="center" colspan="9">Capture The Flag</td>

    70. 

  70.   </tr>

    71. 

  71.   <tr>

    72. 

  72.     <td class="dark" align="center">Flag Takes</td>

    73. 

  73.     <td class="dark" align="center">Flag Pickups</td>

    74. 

  74.     <td class="dark" align="center">Flag Drops</td>

    75. 

  75.     <td class="dark" align="center">Flag Assists</td>

    76. 

  76.     <td class="dark" align="center">Flag Covers</td>

    77. 

  77.     <td class="dark" align="center">Flag Seals</td>

    78. 

  78.     <td class="dark" align="center">Flag Captures</td>

    79. 

  79.     <td class="dark" align="center">Flag Kills</td>

    80. 

  80.     <td class="dark" align="center">Flag Returns</td>

    81. 

  81.   </tr>';

    82. 

  82. 

    83. 

  83.  $sql_cdatot = zero_out(small_query("SELECT SUM(dom_cp) AS dom_cp, SUM(ass_obj) AS ass_obj, SUM(flag_taken) AS flag_taken,

    84. 

  84.  SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover,

    85. 

  85.  SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill,

    86. 

  86.  SUM(flag_return) AS flag_return FROM uts_player"));

    87. 

  87. 

    88. 

  88.   echo'

    89. 

  89.   <tr>

    90. 

  90.     <td class="grey" align="center">'.$sql_cdatot['ass_obj'].'</td>

    91. 

  91.     <td class="grey" align="center">'.$sql_cdatot['dom_cp'].'</td>

    92. 

  92.     <td class="grey" align="center">'.$sql_cdatot['flag_taken'].'</td>

    93. 

  93.     <td class="grey" align="center">'.$sql_cdatot['flag_pickedup'].'</td>

    94. 

  94.     <td class="grey" align="center">'.$sql_cdatot['flag_dropped'].'</td>

    95. 

  95.     <td class="grey" align="center">'.$sql_cdatot['flag_assist'].'</td>

    96. 

  96.     <td class="grey" align="center">'.$sql_cdatot['flag_cover'].'</td>

    97. 

  97.     <td class="grey" align="center">'.$sql_cdatot['flag_seal'].'</td>

    98. 

  98.     <td class="grey" align="center">'.$sql_cdatot['flag_capture'].'</td>

    99. 

  99.     <td class="grey" align="center">'.$sql_cdatot['flag_kill'].'</td>

    100. 

  100.     <td class="grey" align="center">'.$sql_cdatot['flag_return'].'</td>

    101. 

  101.   </tr>

    102. 

  102. </tbody></table>

    103. 

  103. <br>

    104. 

  104. <table border="0" cellpadding="1" cellspacing="2" width="500">

    105. 

  105.   <tbody><tr>

    106. 

  106.     <td class="medheading" colspan="4" align="center">Special Events</td>

    107. 

  107.   </tr>';

    108. 

  108. 

    109. 

  109. //$sql_firstblood = zero_out(small_count("SELECT firstblood FROM uts_match WHERE firstblood != ''"));

    110. 

  110. $sql_headshots = zero_out(small_query("SELECT SUM(headshots) AS headshots FROM uts_player"));

    111. 

  111. $sql_multis = zero_out(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 FROM uts_player"));

    112. 

  112. $sql_sprees = zero_out(small_query("SELECT SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god FROM uts_player"));

    113. 

  113. 

    114. 

  114.   echo'

    115. 

  115.   <tr>

    116. 

  116.     <td class="smheading" align="center" colspan="2" width="250">Special/Multis</td>

    117. 

  117.     <td class="smheading" align="center" colspan="2" width="250">Sprees</td>

    118. 

  118.   </tr>

    119. 

  119.   <tr>

    120. 

  120.     <td class="dark" align="center" width="150">Head Shots</td>

    121. 

  121.     <td class="grey" align="center" width="100">'.$sql_headshots['headshots'].'</td>

    122. 

  122.     <td class="dark" align="center" width="150">Killing Spree</td>

    123. 

  123.     <td class="grey" align="center" width="100">'.$sql_sprees['spree_kill'].'</td>

    124. 

  124.   </tr>

    125. 

  125.   <tr>

    126. 

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

    127. 

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

    128. 

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

    129. 

  129.     <td class="grey" align="center">'.$sql_sprees['spree_rampage'].'</td>

    130. 

  130.   </tr>

    131. 

  131.   <tr>

    132. 

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

    133. 

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

    134. 

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

    135. 

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

    136. 

  136.   </tr>

    137. 

  137.   <tr>

    138. 

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

    139. 

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

    140. 

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

    141. 

  141.     <td class="grey" align="center">'.$sql_sprees['spree_uns'].'</td>

    142. 

  142.   </tr>

    143. 

  143.   <tr>

    144. 

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

    145. 

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

    146. 

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

    147. 

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

    148. 

  148.   </tr>

    149. 

  149. </tbody></table>

    150. 

  150. <br>';

    151. 

  151. 

    152. 

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

    153. 

  153. weaponstats(0, 0);

    154. 

  154. 

    155. 

  155. echo'<br>

    156. 

  156. <table border="0" cellpadding="1" cellspacing="2" width="710">

    157. 

  157.   <tbody><tr>

    158. 

  158.     <td class="heading" align="center">Totals for Players</td>

    159. 

  159.   </tr>

    160. 

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

    161. 

  161. 

    162. 

  162. // NGStats Style Total Highs (All Time)

    163. 

  163. 

    164. 

  164. // Generalized Career High Stats - Title => Forumula

    165. 

  165. $careerstatlist = array(

    166. 

  166. 						'Frags' => 'SUM(p.frags)',

    167. 

  167. 						'Deaths' => 'SUM(p.deaths)',

    168. 

  168. 						'Kills' => 'SUM(p.kills)',

    169. 

  169. 						'Suicides' => 'SUM(p.suicides)',

    170. 

  170. 						'Team Kills' => 'SUM(p.teamkills)',

    171. 

  171. 						'Head Shots' => 'SUM(p.headshots)',

    172. 

  172. 						'Efficiency' => '(100*SUM(p.frags)/(SUM(p.kills)+SUM(p.deaths)+SUM(p.teamkills)+SUM(p.suicides)))',

    173. 

  173. 						'Accuracy' => 'ws.acc',

    174. 

  174. 						'TTL' => '(SUM(p.gametime)/(SUM(p.deaths)+SUM(p.suicides)+COUNT(p.id)))',

    175. 

  175. 						'Flag Caps' => 'SUM(p.flag_capture)',

    176. 

  176. 						'Flag Assists' => 'SUM(p.flag_assist)',

    177. 

  177. 						'Flag Kills' => 'SUM(p.flag_kill)',

    178. 

  178. 						'Domination Control Points' => 'SUM(p.dom_cp)',

    179. 

  179. 						'Assault Objectives' => 'SUM(p.ass_obj)',

    180. 

  180. 						'Monster Kills' => 'SUM(p.spree_monster)',

    181. 

  181. 						'Godlikes' => 'SUM(p.spree_god)',

    182. 

  182. 						'Rank Points' => 'SUM(rank)'

    183. 

  183. 					);

    184. 

  184. 

    185. 

  185. // Generalized Match High Stats - Title => Formula

    186. 

  186. $matchstatlist = array(

    187. 

  187. 					'Frags' => 'p.frags',

    188. 

  188. 					'Deaths' => 'p.deaths',

    189. 

  189. 					'Kills' => 'p.kills',

    190. 

  190. 					'Suicides' => 'p.suicides',

    191. 

  191. 					'Team Kills' => 'p.teamkills',

    192. 

  192. 					'Head Shots' => 'p.headshots',

    193. 

  193. 					'Efficiency' => 'p.eff',

    194. 

  194. 					'Accuracy' => 'ws.acc',

    195. 

  195. 					'TTL' => '(p.gametime/(p.deaths+p.suicides+1))',

    196. 

  196. 					'Flag Caps' => 'p.flag_capture',

    197. 

  197. 					'Flag Assists' => 'p.flag_assist',

    198. 

  198. 					'Flag Kills' => 'p.flag_kill',

    199. 

  199. 					'Domination Control Points' => 'p.dom_cp',

    200. 

  200. 					'Assault Objectives' => 'p.ass_obj',

    201. 

  201. 					'Monster Kills' => 'p.spree_monster',

    202. 

  202. 					'Godlikes' => 'p.spree_god',

    203. 

  203. 					'Rank Points' => 'rank'

    204. 

  204. 				);

    205. 

  205. 

    206. 

  206. // Title => Format

    207. 

  207. $formatstatlist = array(

    208. 

  208. 						'Efficiency' => 'decimal',

    209. 

  209. 						'Accuracy' => 'decimal',

    210. 

  210. 						'TTL' => 'minutes',

    211. 

  211. 						'Rank Points' => 'decimal',

    212. 

  212. 					);

    213. 

  213. //*/

    214. 

  214. echo'<br>

    215. 

  215. <table border="0" cellpadding="1" cellspacing="2" width="550">

    216. 

  216.   <tbody>

    217. 

  217.   <tr>

    218. 

  218.     <td class="medheading" colspan="5" align="center">Career Highs</td>

    219. 

  219.   </tr>

    220. 

  220.   <tr>

    221. 

  221.     <td class="smheading" align="center" width="200">Category</td>

    222. 

  222.     <td class="smheading" align="center" width="50">Amount</td>

    223. 

  223.     <td class="smheading" align="center" width="200">Player</td>

    224. 

  224.     <td class="smheading" align="center" width="50">Hours</td>

    225. 

  225.     <td class="smheading" align="center" width="50">Matches</td>

    226. 

  226.   </tr>';

    227. 

  227. 

    228. 

  228. foreach ($careerstatlist as $s_title => $s_formula)

    229. 

  229. {

    230. 

  230.     $stat_high = small_query("SELECT @max := $s_formula AS x, SUM(p.gametime) AS sumgametime FROM uts_player AS p ,uts_weaponstats AS ws WHERE ws.pid = p.pid AND ws.matchid = 0 AND ws.weapon = 0 GROUP BY p.pid HAVING sumgametime > 1800 ORDER BY x DESC LIMIT 1");

    231. 

  231. 	$q_cstat = mysql_query("SELECT p.pid, pi.name, p.country, $s_formula AS stat, SUM(p.gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi, uts_weaponstats AS ws WHERE ws.pid = pi.id AND p.pid = pi.id AND ws.matchid = 0 AND ws.weapon = 0 AND pi.banned <> 'Y' GROUP BY ws.pid HAVING sumgametime > 1800 AND stat > 0 AND stat = @max ORDER BY pi.name ASC");

    232. 

  232. 

    233. 

  233.     $nrows = mysql_num_rows($q_cstat);

    234. 

  234. 	if ($nrows > 0)

    235. 

  235. 	{

    236. 

  236. 		echo '  

    237. 

  237. 		<tr>

    238. 

  238. 			<td class="dark" align="center" rowspan="'.$nrows.'">'.$s_title.'</td>

    239. 

  239. 			<td class="grey" align="center" rowspan="'.$nrows.'">';

    240. 

  240. 		if ($formatstatlist[$s_title] == 'decimal')

    241. 

  241. 			echo get_dp($stat_high['x']);

    242. 

  242. 		else if ($formatstatlist[$s_title] == 'minutes')

    243. 

  243. 			echo GetMinutes($stat_high['x']);

    244. 

  244. 		else

    245. 

  245. 			echo $stat_high['x'];

    246. 

  246. 		echo '</td>';

    247. 

  247.         while ($sql_cstat = mysql_fetch_array($q_cstat))

    248. 

  248.         {

    249. 

  249.             echo '

    250. 

  250. 			<td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_cstat['pid'].'">'.FlagImage($sql_cstat['country'], false).' '.$sql_cstat['name'].'</a></td>

    251. 

  251. 			<td class="grey" align="center">'.sec2hour($sql_cstat['sumgametime']).'</td>

    252. 

  252. 			<td class="grey" align="center">'.$sql_cstat['mcount'].'</td>

    253. 

  253. 		</tr>';

    254. 

  254.         }

    255. 

  255. 	}

    256. 

  256. }

    257. 

  257. 

    258. 

  258. /*/

    259. 

  259. $sql_chighfrags = small_query("SELECT p.pid, pi.name, p.country, SUM(frags) AS frags , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY frags DESC LIMIT 0,1");

    260. 

  260. 

    261. 

  261. $sql_chighdeaths = small_query("SELECT p.pid, pi.name, p.country, SUM(deaths) AS deaths , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY deaths DESC LIMIT 0,1");

    262. 

  262. 

    263. 

  263. $sql_chighkills = small_query("SELECT p.pid, pi.name, p.country, SUM(kills) AS kills , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY kills DESC LIMIT 0,1");

    264. 

  264. 

    265. 

  265. $sql_chighsuicides = small_query("SELECT p.pid, pi.name, p.country, SUM(suicides) AS suicides , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY suicides DESC LIMIT 0,1");

    266. 

  266. 

    267. 

  267. $sql_chighteamkills = small_query("SELECT p.pid, pi.name, p.country, SUM(teamkills) AS teamkills , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY teamkills DESC LIMIT 0,1");

    268. 

  268. 

    269. 

  269. $sql_chighheadshots = small_query("SELECT p.pid, pi.name, p.country, SUM(headshots) AS headshots , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY headshots DESC LIMIT 0,1");

    270. 

  270. 

    271. 

  271. $sql_chigheff = small_query("SELECT p.pid, pi.name, p.country, (100 * SUM(kills) / (SUM(kills) + SUM(deaths) + SUM(suicides) + SUM(teamkills))) AS eff , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY eff DESC LIMIT 0,1");

    272. 

  272. 

    273. 

  273. $sql_chighaccuracy = small_query("SELECT p.pid, pi.name, p.country, (100 * SUM(ws.hits) / SUM(ws.shots)) AS accuracy, SUM(p.gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi, uts_weaponstats AS ws WHERE ws.pid = pi.id AND p.pid = ws.pid AND p.pid = pi.id AND ws.matchid = 0 AND ws.weapon = 0 AND pi.banned <> 'Y' GROUP BY ws.pid HAVING sumgametime > 1800 ORDER BY accuracy DESC LIMIT 0,1");

    274. 

  274. 

    275. 

  275. $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, (SUM(gametime)/(SUM(deaths) + SUM(suicides) + COUNT(matchid))) AS ttl , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ttl DESC LIMIT 0,1");

    276. 

  276. 

    277. 

  277. $sql_chighflag_capture = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY flag_capture DESC LIMIT 0,1");

    278. 

  278. 

    279. 

  279. $sql_chighflag_assist = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_assist) AS flag_assist, SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY flag_assist DESC LIMIT 0,1");

    280. 

  280. 

    281. 

  281. $sql_chighflag_kill = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY flag_kill DESC LIMIT 0,1");

    282. 

  282. 

    283. 

  283. $sql_chighdom_cp = small_query("SELECT p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY dom_cp DESC LIMIT 0,1");

    284. 

  284. 

    285. 

  285. $sql_chighass_obj = small_query("SELECT p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ass_obj DESC LIMIT 0,1");

    286. 

  286. 

    287. 

  287. $sql_chighspree_monster = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_monster) AS spree_monster , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY spree_monster DESC LIMIT 0,1");

    288. 

  288. 

    289. 

  289. $sql_chighspree_god = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY spree_god DESC LIMIT 0,1");

    290. 

  290. 

    291. 

  291. $sql_chighrank = small_query("SELECT p.pid, pi.name, p.country, SUM(rank) AS rank , SUM(gametime) AS sumgametime, COUNT(p.matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY rank DESC LIMIT 0,1");

    292. 

  292. 

    293. 

  293. if ($sql_chighfrags and $sql_chighfrags['frags']) {

    294. 

  294.    echo '  

    295. 

  295.   <tr>

    296. 

  296.     <td class="dark" align="center">Frags</td>

    297. 

  297.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighfrags['pid'].'">'.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags['name'].'</a></td>

    298. 

  298.     <td class="grey" align="center">'.$sql_chighfrags['frags'].'</td>

    299. 

  299.     <td class="grey" align="center">'.sec2hour($sql_chighfrags['sumgametime']).'</td>

    300. 

  300.     <td class="grey" align="center">'.$sql_chighfrags['mcount'].'</td>

    301. 

  301.   </tr>';

    302. 

  302. }

    303. 

  303. if ($sql_chighdeaths and $sql_chighdeaths[deaths]) {

    304. 

  304.    echo '  

    305. 

  305.   <tr>

    306. 

  306.     <td class="dark" align="center">Deaths</td>

    307. 

  307.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighdeaths[pid].'">'.FlagImage($sql_chighdeaths[country], false).' '.$sql_chighdeaths[name].'</a></td>

    308. 

  308.     <td class="grey" align="center">'.$sql_chighdeaths[deaths].'</td>

    309. 

  309.     <td class="grey" align="center">'.sec2hour($sql_chighdeaths[sumgametime]).'</td>

    310. 

  310.     <td class="grey" align="center">'.$sql_chighdeaths[mcount].'</td>

    311. 

  311.   </tr>';

    312. 

  312. }

    313. 

  313. if ($sql_chighkills and $sql_chighkills[kills]) {

    314. 

  314.    echo '  

    315. 

  315.   <tr>

    316. 

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

    317. 

  317.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighkills[pid].'">'.FlagImage($sql_chighkills[country], false).' '.$sql_chighkills[name].'</a></td>

    318. 

  318.     <td class="grey" align="center">'.$sql_chighkills[kills].'</td>

    319. 

  319.     <td class="grey" align="center">'.sec2hour($sql_chighkills[sumgametime]).'</td>

    320. 

  320.     <td class="grey" align="center">'.$sql_chighkills[mcount].'</td>

    321. 

  321.   </tr>';

    322. 

  322. }

    323. 

  323. if ($sql_chighsuicides and $sql_chighsuicides[suicides]) {

    324. 

  324.    echo '  

    325. 

  325.   <tr>

    326. 

  326.     <td class="dark" align="center">Suicides</td>

    327. 

  327.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighsuicides[pid].'">'.FlagImage($sql_chighsuicides[country], false).' '.$sql_chighsuicides[name].'</a></td>

    328. 

  328.     <td class="grey" align="center">'.$sql_chighsuicides[suicides].'</td>

    329. 

  329.     <td class="grey" align="center">'.sec2hour($sql_chighsuicides[sumgametime]).'</td>

    330. 

  330.     <td class="grey" align="center">'.$sql_chighsuicides[mcount].'</td>

    331. 

  331.   </tr>';

    332. 

  332. }

    333. 

  333. if ($sql_chighteamkills and $sql_chighteamkills[teamkills]) {

    334. 

  334.    echo '  

    335. 

  335.   <tr>

    336. 

  336.     <td class="dark" align="center">Team Kills</td>

    337. 

  337.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighteamkills[pid].'">'.FlagImage($sql_chighteamkills[country], false).' '.$sql_chighteamkills[name].'</a></td>

    338. 

  338.     <td class="grey" align="center">'.$sql_chighteamkills[teamkills].'</td>

    339. 

  339.     <td class="grey" align="center">'.sec2hour($sql_chighteamkills[sumgametime]).'</td>

    340. 

  340.     <td class="grey" align="center">'.$sql_chighteamkills[mcount].'</td>

    341. 

  341.   </tr>';

    342. 

  342. }

    343. 

  343. if ($sql_chigheff and $sql_chigheff[eff]) {

    344. 

  344.    echo '  

    345. 

  345.   <tr>

    346. 

  346.     <td class="dark" align="center">Efficiency</td>

    347. 

  347.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chigheff[pid].'">'.FlagImage($sql_chigheff[country], false).' '.$sql_chigheff[name].'</a></td>

    348. 

  348.     <td class="grey" align="center">'.get_dp($sql_chigheff[eff]).'</td>

    349. 

  349.     <td class="grey" align="center">'.sec2hour($sql_chigheff[sumgametime]).'</td>

    350. 

  350.     <td class="grey" align="center">'.$sql_chigheff[mcount].'</td>

    351. 

  351.   </tr>';

    352. 

  352. }

    353. 

  353. if ($sql_chighaccuracy and $sql_chighaccuracy[accuracy]) {

    354. 

  354.    echo '  

    355. 

  355.   <tr>

    356. 

  356.     <td class="dark" align="center">Accuracy</td>

    357. 

  357.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighaccuracy[pid].'">'.FlagImage($sql_chighaccuracy[country], false).' '.$sql_chighaccuracy[name].'</a></td>

    358. 

  358.     <td class="grey" align="center">'.get_dp($sql_chighaccuracy[accuracy]).'</td>

    359. 

  359.     <td class="grey" align="center">'.sec2hour($sql_chighaccuracy[sumgametime]).'</td>

    360. 

  360.     <td class="grey" align="center">'.$sql_chighaccuracy[mcount].'</td>

    361. 

  361.   </tr>';

    362. 

  362. }

    363. 

  363. if ($sql_chighttl and $sql_chighttl[ttl]) {

    364. 

  364.    echo '  

    365. 

  365.   <tr>

    366. 

  366.     <td class="dark" align="center">TTL</td>

    367. 

  367.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighttl[pid].'">'.FlagImage($sql_chighttl[country], false).' '.$sql_chighttl[name].'</a></td>

    368. 

  368.     <td class="grey" align="center">'.GetMinutes($sql_chighttl[ttl]).'</td>

    369. 

  369.     <td class="grey" align="center">'.sec2hour($sql_chighttl[sumgametime]).'</td>

    370. 

  370.     <td class="grey" align="center">'.$sql_chighttl[mcount].'</td>

    371. 

  371.   </tr>';

    372. 

  372. }

    373. 

  373. if ($sql_chighheadshots and $sql_chighheadshots[headshots]) {

    374. 

  374.    echo '  

    375. 

  375.   <tr>

    376. 

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

    377. 

  377.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighheadshots[pid].'">'.FlagImage($sql_chighheadshots[country], false).' '.$sql_chighheadshots[name].'</a></td>

    378. 

  378.     <td class="grey" align="center">'.$sql_chighheadshots[headshots].'</td>

    379. 

  379.     <td class="grey" align="center">'.sec2hour($sql_chighheadshots[sumgametime]).'</td>

    380. 

  380.     <td class="grey" align="center">'.$sql_chighheadshots[mcount].'</td>

    381. 

  381.   </tr>';

    382. 

  382. }

    383. 

  383. if ($sql_chighflag_capture and $sql_chighflag_capture[flag_capture]) {

    384. 

  384.    echo '  

    385. 

  385.   <tr>

    386. 

  386.     <td class="dark" align="center">Flag Caps</td>

    387. 

  387.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighflag_capture[pid].'">'.FlagImage($sql_chighflag_capture[country], false).' '.$sql_chighflag_capture[name].'</a></td>

    388. 

  388.     <td class="grey" align="center">'.$sql_chighflag_capture[flag_capture].'</td>

    389. 

  389.     <td class="grey" align="center">'.sec2hour($sql_chighflag_capture[sumgametime]).'</td>

    390. 

  390.     <td class="grey" align="center">'.$sql_chighflag_capture[mcount].'</td>

    391. 

  391.   </tr>';

    392. 

  392. }

    393. 

  393. if ($sql_chighflag_assist and $sql_chighflag_assist[flag_assist]) {

    394. 

  394. 	echo'

    395. 

  395. 	<tr>

    396. 

  396. 		<td class="dark" align="center">Flag Assists</td>

    397. 

  397.     	<td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighflag_assist[pid].'">'.FlagImage($sql_chighflag_assist[country], false).' '.$sql_chighflag_assist[name].'</a></td>

    398. 

  398.     	<td class="grey" align="center">'.$sql_chighflag_assist[flag_assist].'</td>

    399. 

  399.     	<td class="grey" align="center">'.sec2hour($sql_chighflag_assist[sumgametime]).'</td>

    400. 

  400.     	<td class="grey" align="center">'.$sql_chighflag_assist[mcount].'</td>

    401. 

  401. 	</tr>';

    402. 

  402. }

    403. 

  403. if ($sql_chighflag_kill and $sql_chighflag_kill[flag_kill]) {

    404. 

  404.    echo '  

    405. 

  405.   <tr>

    406. 

  406.     <td class="dark" align="center">Flag Kills</td>

    407. 

  407.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighflag_kill[pid].'">'.FlagImage($sql_chighflag_kill[country], false).' '.$sql_chighflag_kill[name].'</a></td>

    408. 

  408.     <td class="grey" align="center">'.$sql_chighflag_kill[flag_kill].'</td>

    409. 

  409.     <td class="grey" align="center">'.sec2hour($sql_chighflag_kill[sumgametime]).'</td>

    410. 

  410.     <td class="grey" align="center">'.$sql_chighflag_kill[mcount].'</td>

    411. 

  411.   </tr>';

    412. 

  412. }

    413. 

  413. if ($sql_chighdom_cp and $sql_chighdom_cp[dom_cp]) {

    414. 

  414.    echo '  

    415. 

  415.   <tr>

    416. 

  416.     <td class="dark" align="center">Domination Control Points</td>

    417. 

  417.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighdom_cp[pid].'">'.FlagImage($sql_chighdom_cp[country], false).' '.$sql_chighdom_cp[name].'</a></td>

    418. 

  418.     <td class="grey" align="center">'.$sql_chighdom_cp[dom_cp].'</td>

    419. 

  419.     <td class="grey" align="center">'.sec2hour($sql_chighdom_cp[sumgametime]).'</td>

    420. 

  420.     <td class="grey" align="center">'.$sql_chighdom_cp[mcount].'</td>

    421. 

  421.   </tr>';

    422. 

  422. }

    423. 

  423. if ($sql_chighass_obj and $sql_chighass_obj[ass_obj]) {

    424. 

  424.    echo '  

    425. 

  425.   <tr>

    426. 

  426.     <td class="dark" align="center">Assault Objectives</td>

    427. 

  427.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighass_obj[pid].'">'.FlagImage($sql_chighass_obj[country], false).' '.$sql_chighass_obj[name].'</a></td>

    428. 

  428.     <td class="grey" align="center">'.$sql_chighass_obj[ass_obj].'</td>

    429. 

  429.     <td class="grey" align="center">'.sec2hour($sql_chighass_obj[sumgametime]).'</td>

    430. 

  430.     <td class="grey" align="center">'.$sql_chighass_obj[mcount].'</td>

    431. 

  431.   </tr>';

    432. 

  432. }

    433. 

  433. if ($sql_chighspree_monster and $sql_chighspree_monster[spree_monster]) {

    434. 

  434.    echo '  

    435. 

  435.   <tr>

    436. 

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

    437. 

  437.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighspree_monster[pid].'">'.FlagImage($sql_chighspree_monster[country], false).' '.$sql_chighspree_monster[name].'</a></td>

    438. 

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

    439. 

  439.     <td class="grey" align="center">'.sec2hour($sql_chighspree_monster[sumgametime]).'</td>

    440. 

  440.     <td class="grey" align="center">'.$sql_chighspree_monster[mcount].'</td>

    441. 

  441.   </tr>';

    442. 

  442. }

    443. 

  443. if ($sql_chighspree_god and $sql_chighspree_god[spree_god]) {

    444. 

  444.    echo '  

    445. 

  445.   <tr>

    446. 

  446.     <td class="dark" align="center">Godlikes</td>

    447. 

  447.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighspree_god[pid].'">'.FlagImage($sql_chighspree_god[country], false).' '.$sql_chighspree_god[name].'</a></td>

    448. 

  448.     <td class="grey" align="center">'.$sql_chighspree_god[spree_god].'</td>

    449. 

  449.     <td class="grey" align="center">'.sec2hour($sql_chighspree_god[sumgametime]).'</td>

    450. 

  450.     <td class="grey" align="center">'.$sql_chighspree_god[mcount].'</td>

    451. 

  451.   </tr>';

    452. 

  452. }

    453. 

  453. if ($sql_chighrank and $sql_chighrank[rank]) {

    454. 

  454.    echo '  

    455. 

  455.   <tr>

    456. 

  456.     <td class="dark" align="center">Rank Points</td>

    457. 

  457.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_chighrank[pid].'">'.FlagImage($sql_chighrank[country], false).' '.$sql_chighrank[name].'</a></td>

    458. 

  458.     <td class="grey" align="center">'.get_dp($sql_chighrank[rank]).'</td>

    459. 

  459.     <td class="grey" align="center">'.sec2hour($sql_chighrank[sumgametime]).'</td>

    460. 

  460.     <td class="grey" align="center">'.$sql_chighrank[mcount].'</td>

    461. 

  461.   </tr>';

    462. 

  462. }

    463. 

  463. //*/

    464. 

  464. echo '

    465. 

  465. </tbody></table>

    466. 

  466. <br>';

    467. 

  467. 

    468. 

  468. // NGStats Style Total Highs (Single Match)

    469. 

  469. 

    470. 

  470. echo'<table border="0" cellpadding="1" cellspacing="2" width="500">

    471. 

  471.   <tbody>

    472. 

  472.   <tr>

    473. 

  473.     <td class="medheading" colspan="4" align="center">Match Highs</td>

    474. 

  474.   </tr>

    475. 

  475.   <tr>

    476. 

  476.     <td class="smheading" align="center" width="200">Category</td>

    477. 

  477.     <td class="smheading" align="center" width="50">Amount</td>

    478. 

  478.     <td class="smheading" align="center" width="200">Player</td>

    479. 

  479.     <td class="smheading" align="center" width="50">Matches</td>

    480. 

  480.   </tr>';

    481. 

  481. 

    482. 

  482. 

    483. 

  483. foreach ($matchstatlist as $s_title => $s_formula)

    484. 

  484. {

    485. 

  485.     $stat_high = small_query("SELECT @max := max($s_formula) AS x FROM uts_player as p LEFT JOIN uts_weaponstats AS ws ON (ws.pid = p.pid AND ws.matchid = p.matchid AND ws.weapon = 0)");

    486. 

  486. 	$q_cstat = mysql_query("SELECT COUNT(p.matchid) as times, p.pid, pi.name, p.country, MAX($s_formula) AS stat FROM uts_player AS p, uts_pinfo AS pi, uts_weaponstats AS ws WHERE ws.pid = pi.id AND p.pid = pi.id AND ws.matchid = p.matchid AND ws.weapon = 0 AND pi.banned <> 'Y' AND p.gametime > 60 AND $s_formula > 0 AND $s_formula = @max GROUP BY p.pid ORDER BY times DESC, pi.name ASC");

    487. 

  487. 

    488. 

  488.     $nrows = mysql_num_rows($q_cstat);

    489. 

  489. 	if ($nrows > 0)

    490. 

  490. 	{

    491. 

  491. 		echo '  

    492. 

  492. 		<tr>

    493. 

  493. 			<td class="dark" align="center" rowspan="'.$nrows.'">'.$s_title.'</td>

    494. 

  494.             <td class="grey" align="center" rowspan="'.$nrows.'">';

    495. 

  495.         if ($formatstatlist[$s_title] == 'decimal')

    496. 

  496.             echo get_dp($stat_high['x']);

    497. 

  497.         else if ($formatstatlist[$s_title] == 'minutes')

    498. 

  498.             echo GetMinutes($stat_high['x']);

    499. 

  499.         else

    500. 

  500.             echo $stat_high['x'];

    501. 

  501.         echo '</td>';

    502. 

  502.         while ($sql_cstat = mysql_fetch_array($q_cstat))

    503. 

  503.         {

    504. 

  504.             echo '

    505. 

  505.            <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_cstat['pid'].'">'.FlagImage($sql_cstat['country'], false).' '.$sql_cstat['name'].'</a></td>

    506. 

  506.             <td class="grey" align="center">'.$sql_cstat['times'].'</td>

    507. 

  507.         </tr>';

    508. 

  508.         }

    509. 

  509. 	}

    510. 

  510. }

    511. 

  511. /*/

    512. 

  512. //$sql_mhighfrags = small_query("SELECT p.matchid, p.pid, pi.name, p.country, frags , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND frags > 0 AND gametime > 60 ORDER BY frags DESC LIMIT 0,1");

    513. 

  513. 

    514. 

  514. run_query("SELECT @frags := MAX(frags) from uts_player");

    515. 

  515. $q_mhighfrags = run_query("SELECT p.matchid, p.pid, pi.name, p.country, frags , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND frags > 0 AND gametime > 60 AND frags = @frags");

    516. 

  516. //if ($sql_mhighfrags) {

    517. 

  517. while ($sql_mhighfrags = mysql_fetch_array($q_mhighfrags)) {

    518. 

  518.    echo '  

    519. 

  519.   <tr>

    520. 

  520.     <td class="dark" align="center">Frags</td>

    521. 

  521.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighfrags[pid].'">'.FlagImage($sql_mhighfrags[country], false).' '.$sql_mhighfrags[name].'</a></td>

    522. 

  522.     <td class="grey" align="center">'.$sql_mhighfrags[frags].'</td>

    523. 

  523.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighfrags[matchid].'">(click)</a></td>

    524. 

  524.   </tr>';

    525. 

  525. }

    526. 

  526. 

    527. 

  527. $sql_mhighdeaths = small_query("SELECT p.matchid, p.pid, pi.name, p.country, deaths , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND deaths > 0 AND gametime > 60 ORDER BY deaths DESC LIMIT 0,1");

    528. 

  528. 

    529. 

  529. if ($sql_mhighdeaths) {

    530. 

  530.    echo '  

    531. 

  531.   <tr>

    532. 

  532.     <td class="dark" align="center">Deaths</td>

    533. 

  533.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighdeaths[pid].'">'.FlagImage($sql_mhighdeaths[country], false).' '.$sql_mhighdeaths[name].'</a></td>

    534. 

  534.     <td class="grey" align="center">'.$sql_mhighdeaths[deaths].'</td>

    535. 

  535.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighdeaths[matchid].'">(click)</a></td>

    536. 

  536.   </tr>';

    537. 

  537. }

    538. 

  538. 

    539. 

  539. $sql_mhighkills = small_query("SELECT p.matchid, p.pid, pi.name, p.country, kills , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND kills > 0 AND gametime > 60 ORDER BY kills DESC LIMIT 0,1");

    540. 

  540. 

    541. 

  541. if ($sql_mhighkills) {

    542. 

  542.    echo '  

    543. 

  543.   <tr>

    544. 

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

    545. 

  545.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighkills[pid].'">'.FlagImage($sql_mhighkills[country], false).' '.$sql_mhighkills[name].'</a></td>

    546. 

  546.     <td class="grey" align="center">'.$sql_mhighkills[kills].'</td>

    547. 

  547.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighkills[matchid].'">(click)</a></td>

    548. 

  548.   </tr>';

    549. 

  549. }

    550. 

  550. 

    551. 

  551. $sql_mhighsuicides = small_query("SELECT p.matchid, p.pid, pi.name, p.country, suicides , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND suicides > 0 AND gametime > 60 ORDER BY suicides DESC LIMIT 0,1");

    552. 

  552. 

    553. 

  553. if ($sql_mhighsuicides) {

    554. 

  554.    echo '  

    555. 

  555.   <tr>

    556. 

  556.     <td class="dark" align="center">Suicides</td>

    557. 

  557.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighsuicides[pid].'">'.FlagImage($sql_mhighsuicides[country], false).' '.$sql_mhighsuicides[name].'</a></td>

    558. 

  558.     <td class="grey" align="center">'.$sql_mhighsuicides[suicides].'</td>

    559. 

  559.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighsuicides[matchid].'">(click)</a></td>

    560. 

  560.   </tr>';

    561. 

  561. }

    562. 

  562. 

    563. 

  563. $sql_mhighteamkills = small_query("SELECT p.matchid, p.pid, pi.name, p.country, teamkills , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND teamkills > 0 AND gametime > 60 ORDER BY teamkills DESC LIMIT 0,1");

    564. 

  564. 

    565. 

  565. if ($sql_mhighteamkills) {

    566. 

  566.    echo '  

    567. 

  567.   <tr>

    568. 

  568.     <td class="dark" align="center">Team Kills</td>

    569. 

  569.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighteamkills[pid].'">'.FlagImage($sql_mhighteamkills[country], false).' '.$sql_mhighteamkills[name].'</a></td>

    570. 

  570.     <td class="grey" align="center">'.$sql_mhighteamkills[teamkills].'</td>

    571. 

  571.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighteamkills[matchid].'">(click)</a></td>

    572. 

  572.   </tr>';

    573. 

  573. }

    574. 

  574. 

    575. 

  575. $sql_mhigheff = small_query("SELECT p.matchid, p.pid, pi.name, p.country, eff , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND eff > 0 AND gametime > 600 ORDER BY eff DESC LIMIT 0,1");

    576. 

  576. 

    577. 

  577. if ($sql_mhigheff) {

    578. 

  578.    echo '  

    579. 

  579.   <tr>

    580. 

  580.     <td class="dark" align="center">Efficiency</td>

    581. 

  581.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhigheff[pid].'">'.FlagImage($sql_mhigheff[country], false).' '.$sql_mhigheff[name].'</a></td>

    582. 

  582.     <td class="grey" align="center">'.get_dp($sql_mhigheff[eff]).'</td>

    583. 

  583.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhigheff[matchid].'">(click)</a></td>

    584. 

  584.   </tr>';

    585. 

  585. }

    586. 

  586. 

    587. 

  587. $sql_mhighaccuracy = small_query("SELECT p.matchid, p.pid, pi.name, p.country, ws.acc as accuracy, gametime FROM uts_player AS p, uts_pinfo AS pi, uts_weaponstats as ws WHERE ws.pid = p.pid AND p.pid = pi.id AND p.matchid = ws.matchid AND pi.banned <> 'Y' AND accuracy > 0 AND gametime > 60 AND ws.weapon = 0 AND ws.matchid > 0 ORDER BY accuracy DESC LIMIT 0,1");

    588. 

  588. 

    589. 

  589. if ($sql_mhighaccuracy) {

    590. 

  590.    echo '  

    591. 

  591.   <tr>

    592. 

  592.     <td class="dark" align="center">Accuracy</td>

    593. 

  593.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighaccuracy[pid].'">'.FlagImage($sql_mhighaccuracy[country], false).' '.$sql_mhighaccuracy[name].'</a></td>

    594. 

  594.     <td class="grey" align="center">'.get_dp($sql_mhighaccuracy[accuracy]).'</td>

    595. 

  595.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighaccuracy[matchid].'">(click)</a></td>

    596. 

  596.   </tr>';

    597. 

  597. }

    598. 

  598. 

    599. 

  599. $sql_mhighttl = small_query("SELECT p.matchid, p.pid, pi.name, p.country, (gametime/(deaths + suicides + 1)) AS ttl , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND ttl > 0 AND gametime > 60 ORDER BY ttl DESC LIMIT 0,1");

    600. 

  600. 

    601. 

  601. if ($sql_mhighttl) {

    602. 

  602.    echo '  

    603. 

  603.   <tr>

    604. 

  604.     <td class="dark" align="center">TTL</td>

    605. 

  605.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighttl[pid].'">'.FlagImage($sql_mhighttl[country], false).' '.$sql_mhighttl[name].'</a></td>

    606. 

  606.     <td class="grey" align="center">'.GetMinutes($sql_mhighttl[ttl]).'</td>

    607. 

  607.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighttl[matchid].'">(click)</a></td>

    608. 

  608.   </tr>';

    609. 

  609. }

    610. 

  610. 

    611. 

  611. $sql_mhighheadshots = small_query("SELECT p.matchid, p.pid, pi.name, p.country, headshots , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND headshots > 0 AND gametime > 60 ORDER BY headshots DESC LIMIT 0,1");

    612. 

  612. 

    613. 

  613. if ($sql_mhighheadshots) {

    614. 

  614.    echo '  

    615. 

  615.   <tr>

    616. 

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

    617. 

  617.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighheadshots[pid].'">'.FlagImage($sql_mhighheadshots[country], false).' '.$sql_mhighheadshots[name].'</a></td>

    618. 

  618.     <td class="grey" align="center">'.$sql_mhighheadshots[headshots].'</td>

    619. 

  619.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighheadshots[matchid].'">(click)</a></td>

    620. 

  620.   </tr>';

    621. 

  621. }

    622. 

  622. 

    623. 

  623. //$sql_mhighflag_capture = small_query("SELECT p.matchid, p.pid, pi.name, p.country, flag_capture , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_capture > 0 AND gametime > 60 ORDER BY flag_capture DESC LIMIT 0,1");

    624. 

  624. 

    625. 

  625. run_query("SELECT @caps := MAX(flag_capture) from uts_player");

    626. 

  626. $q_mhighflag_capture = run_query("SELECT p.matchid, p.pid, pi.name, p.country, flag_capture , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_capture > 0 AND gametime > 60 AND flag_capture = @caps");

    627. 

  627. 

    628. 

  628. $sql_mhighflag_capture = mysql_fetch_array($q_mhighflag_capture);

    629. 

  629. if ($sql_mhighflag_capture)

    630. 

  630. {

    631. 

  631.   echo '

    632. 

  632.   <tr>

    633. 

  633.     <td class="dark" align="center" rowspan='.mysql_num_rows($q_mhighflag_capture).'>Flag Caps</td>

    634. 

  634.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighflag_capture[pid].'">'.FlagImage($sql_mhighflag_capture[country], false).' '.$sql_mhighflag_capture[name].'</a></td>

    635. 

  635.     <td class="grey" align="center" rowspan='.mysql_num_rows($q_mhighflag_capture).'>'.$sql_mhighflag_capture[flag_capture].'</td>

    636. 

  636.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighflag_capture[matchid].'">(click)</a></td>

    637. 

  637.   </tr>';

    638. 

  638.   

    639. 

  639.   while ($sql_mhighflag_capture = mysql_fetch_array($q_mhighflag_capture))

    640. 

  640.   {

    641. 

  641.     echo '  

    642. 

  642.   <tr>

    643. 

  643.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighflag_capture[pid].'">'.FlagImage($sql_mhighflag_capture[country], false).' '.$sql_mhighflag_capture[name].'</a></td>

    644. 

  644.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighflag_capture[matchid].'">(click)</a></td>

    645. 

  645.   </tr>';

    646. 

  646.   }

    647. 

  647. }

    648. 

  648. 

    649. 

  649. $sql_mhighflag_assist = small_query("SELECT p.matchid, p.pid, pi.name, p.country, flag_assist , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_capture > 0 AND gametime > 60 ORDER BY flag_assist DESC LIMIT 0,1");

    650. 

  650. 

    651. 

  651. if ($sql_mhighflag_assist) {

    652. 

  652.    echo '  

    653. 

  653.   <tr>

    654. 

  654.     <td class="dark" align="center">Flag Assists</td>

    655. 

  655.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighflag_assist[pid].'">'.FlagImage($sql_mhighflag_assist[country], false).' '.$sql_mhighflag_assist[name].'</a></td>

    656. 

  656.     <td class="grey" align="center">'.$sql_mhighflag_assist[flag_assist].'</td>

    657. 

  657.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighflag_assist[matchid].'">(click)</a></td>

    658. 

  658.   </tr>';

    659. 

  659. }

    660. 

  660. 

    661. 

  661. $sql_mhighflag_kill = small_query("SELECT p.matchid, p.pid, pi.name, p.country, flag_kill , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_kill > 0 AND gametime > 60 ORDER BY flag_kill DESC LIMIT 0,1");

    662. 

  662. 

    663. 

  663. if ($sql_mhighflag_kill) {

    664. 

  664.    echo '  

    665. 

  665.   <tr>

    666. 

  666.     <td class="dark" align="center">Flag Kills</td>

    667. 

  667.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighflag_kill[pid].'">'.FlagImage($sql_mhighflag_kill[country], false).' '.$sql_mhighflag_kill[name].'</a></td>

    668. 

  668.     <td class="grey" align="center">'.$sql_mhighflag_kill[flag_kill].'</td>

    669. 

  669.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighflag_kill[matchid].'">(click)</a></td>

    670. 

  670.   </tr>';

    671. 

  671. }

    672. 

  672. 

    673. 

  673. $sql_mhighdom_cp = small_query("SELECT p.matchid, p.pid, pi.name, p.country, dom_cp , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND dom_cp > 0 AND gametime > 60 ORDER BY dom_cp DESC LIMIT 0,1");

    674. 

  674. 

    675. 

  675. if ($sql_mhighdom_cp) {

    676. 

  676.    echo '  

    677. 

  677.   <tr>

    678. 

  678.     <td class="dark" align="center">Domination Control Points</td>

    679. 

  679.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighdom_cp[pid].'">'.FlagImage($sql_mhighdom_cp[country], false).' '.$sql_mhighdom_cp[name].'</a></td>

    680. 

  680.     <td class="grey" align="center">'.$sql_mhighdom_cp[dom_cp].'</td>

    681. 

  681.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighdom_cp[matchid].'">(click)</a></td>

    682. 

  682.   </tr>';

    683. 

  683. }

    684. 

  684. 

    685. 

  685. $sql_mhighass_obj = small_query("SELECT p.matchid, p.pid, pi.name, p.country, ass_obj , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND ass_obj > 0 AND gametime > 60 ORDER BY ass_obj DESC LIMIT 0,1");

    686. 

  686. 

    687. 

  687. if ($sql_mhighass_obj) {

    688. 

  688.    echo '  

    689. 

  689.   <tr>

    690. 

  690.     <td class="dark" align="center">Assault Objectives</td>

    691. 

  691.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighass_obj[pid].'">'.FlagImage($sql_mhighass_obj[country], false).' '.$sql_mhighass_obj[name].'</a></td>

    692. 

  692.     <td class="grey" align="center">'.$sql_mhighass_obj[ass_obj].'</td>

    693. 

  693.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighass_obj[matchid].'">(click)</a></td>

    694. 

  694.   </tr>';

    695. 

  695. }

    696. 

  696. 

    697. 

  697. $sql_mhighspree_monster = small_query("SELECT p.matchid, p.pid, pi.name, p.country, spree_monster , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_monster > 0 AND gametime > 60 ORDER BY spree_monster DESC LIMIT 0,1");

    698. 

  698. 

    699. 

  699. if ($sql_mhighspree_monster) {

    700. 

  700.    echo '  

    701. 

  701.   <tr>

    702. 

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

    703. 

  703.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighspree_monster[pid].'">'.FlagImage($sql_mhighspree_monster[country], false).' '.$sql_mhighspree_monster[name].'</a></td>

    704. 

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

    705. 

  705.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighspree_monster[matchid].'">(click)</a></td>

    706. 

  706.   </tr>';

    707. 

  707. }

    708. 

  708. 

    709. 

  709. $sql_mhighspree_god = small_query("SELECT p.matchid, p.pid, pi.name, p.country, spree_god , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_god > 0 AND gametime > 60 ORDER BY spree_god DESC LIMIT 0,1");

    710. 

  710. 

    711. 

  711. if ($sql_mhighspree_god) {

    712. 

  712.    echo '  

    713. 

  713.   <tr>

    714. 

  714.     <td class="dark" align="center">Godlikes</td>

    715. 

  715.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighspree_god[pid].'">'.FlagImage($sql_mhighspree_god[country], false).' '.$sql_mhighspree_god[name].'</a></td>

    716. 

  716.     <td class="grey" align="center">'.$sql_mhighspree_god[spree_god].'</td>

    717. 

  717.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighspree_god[matchid].'">(click)</a></td>

    718. 

  718.   </tr>';

    719. 

  719. }

    720. 

  720. 

    721. 

  721. $sql_mhighrank = small_query("SELECT p.matchid, p.pid, pi.name, p.country, rank , gametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND rank > 0 AND gametime > 60 ORDER BY rank DESC LIMIT 0,1");

    722. 

  722. 

    723. 

  723. if ($sql_mhighrank) {

    724. 

  724.    echo '  

    725. 

  725.   <tr>

    726. 

  726.     <td class="dark" align="center">Rank Points</td>

    727. 

  727.     <td nowrap class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$sql_mhighrank[pid].'">'.FlagImage($sql_mhighrank[country], false).' '.$sql_mhighrank[name].'</a></td>

    728. 

  728.     <td class="grey" align="center">'.get_dp($sql_mhighrank[rank]).'</td>

    729. 

  729.     <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$sql_mhighrank[matchid].'">(click)</a></td>

    730. 

  730.   </tr>';

    731. 

  731. }

    732. 

  732. //*/

    733. 

  733. 

    734. 

  734. // NGStats Style Weapon Highs (All Time)

    735. 

  735. 

    736. 

  736. echo '

    737. 

  737. </tbody></table>

    738. 

  738. <br>

    739. 

  739. <table border="0" cellpadding="1" cellspacing="2" width="500">

    740. 

  740.   <tbody>

    741. 

  741. <tr>

    742. 

  742.     <td class="medheading" colspan="4" align="center">Weapon Career Highs</td>

    743. 

  743.   </tr>

    744. 

  744.   <tr>

    745. 

  745.     <td class="smheading" align="center" width="200">Category</td>

    746. 

  746.     <td class="smheading" align="center" width="50">Kills</td>

    747. 

  747.     <td class="smheading" align="center" width="200">Player</td>

    748. 

  748.     <td class="smheading" align="center" width="50">Matches</td>

    749. 

  749.   </tr>

    750. 

  750. ';

    751. 

  751. 

    752. 

  752. $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC";

    753. 

  753. $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error());

    754. 

  754. while ($r_mweapons = mysql_fetch_array($q_mweapons))

    755. 

  755. {

    756. 

  756. 	$wid =  $r_mweapons['id'];

    757. 

  757. 	$sql_mweaponsl = "SELECT w.pid AS playerid, pi.name AS name, pi.country AS country, SUM(w.kills) as kills, COUNT(DISTINCT w.matchid) AS mcount FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid <> 0 AND pi.banned <> 'Y' GROUP BY w.pid ORDER BY kills DESC LIMIT 0,1";

    758. 

  758. 	$q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error());

    759. 

  759. 	while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl))

    760. 

  760. 	{

    761. 

  761. 	      echo '<tr>

    762. 

  762. 		    <td class="dark" align="center">'.$r_mweapons['name'].'</td>

    763. 

  763. 		    <td class="grey" align="center">'.$r_mweaponsl['kills'].'</td>

    764. 

  764. 		    <td class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$r_mweaponsl['playerid'].'">'.FlagImage($r_mweaponsl['country'], false).' '.$r_mweaponsl['name'].'</a></td>

    765. 

  765. 		    <td class="grey" align="center">'.$r_mweaponsl['mcount'].'</td>

    766. 

  766.  		    </tr>';

    767. 

  767. 

    768. 

  768. 	}

    769. 

  769. }

    770. 

  770. 

    771. 

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

    772. 

  772. <br>';

    773. 

  773. 

    774. 

  774. // NGStats Style Weapon Highs (Single Match)

    775. 

  775. 

    776. 

  776. echo '<table border="0" cellpadding="1" cellspacing="2" width="450">

    777. 

  777.   <tbody>

    778. 

  778. <tr>

    779. 

  779.     <td class="medheading" colspan="4" align="center">Weapon Match Highs</td>

    780. 

  780.   </tr>

    781. 

  781.   <tr>

    782. 

  782.     <td class="smheading" align="center" width="200">Category</td>

    783. 

  783.     <td class="smheading" align="center" width="50">Kills</td>

    784. 

  784.     <td class="smheading" align="center" width="200">Player</td>

    785. 

  785.     <td class="smheading" align="center" width="50">Match</td>

    786. 

  786.   </tr>

    787. 

  787. ';

    788. 

  788. 

    789. 

  789. //$sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC";

    790. 

  790. $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error());

    791. 

  791. while ($r_mweapons = mysql_fetch_array($q_mweapons))

    792. 

  792. {

    793. 

  793. 	$wid =  $r_mweapons['id'];

    794. 

  794. 	$sql_mweaponsl = "SELECT w.matchid, w.pid AS playerid, pi.name AS name, pi.country AS country, w.kills FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid > 0 AND pi.banned <> 'Y' ORDER BY w.kills DESC LIMIT 0,1";

    795. 

  795. 	$q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error());

    796. 

  796. 	while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl))

    797. 

  797. 	{

    798. 

  798. 	      echo '<tr>

    799. 

  799. 		    <td class="dark" align="center">'.$r_mweapons['name'].'</td>

    800. 

  800. 		    <td class="grey" align="center">'.$r_mweaponsl['kills'].'</td>

    801. 

  801. 		    <td class="greyhuman" align="center"><a class="greyhuman" href="./?p=pinfo&amp;pid='.$r_mweaponsl['playerid'].'">'.FlagImage($r_mweaponsl['country'], false).' '.$r_mweaponsl['name'].'</a></td>

    802. 

  802. 		    <td class="grey" align="center"><a class="greyhuman" href="./?p=match&amp;mid='.$r_mweaponsl['matchid'].'">(click)</a></td>

    803. 

  803.  		    </tr>';

    804. 

  804. 	}

    805. 

  805. }

    806. 

  806. 

    807. 

  807. echo'</tbody></table>';

    808. 

  808. ?>

    809. 

  809.