Implement design for pages and update includes

1 files changed, 274 insertions, 291 deletions

diff --git a/html/pages/totals.php b/html/pages/totals.php
index e5b5126..0e81f82 100755
--- a/html/pages/totals.php
+++ b/html/pages/totals.php
@@ -1,31 +1,25 @@
-<?php

-echo'

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

-  <tbody><tr>

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

-  </tr>

-</tbody></table>

-<br>

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

+

+<table class="zebra box" border="0" cellpadding="0" cellspacing="0" width=700>

   <tbody><tr>

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

+    <th class="heading" colspan="10" align="center">Summary</th>

   </tr>

   <tr>

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

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

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

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

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

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

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

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

-  </tr>';

+    <th class="smheading" align="center" width="150">Game Type</th>

+    <th class="smheading" align="center" width="45">Score</th>

+    <th class="smheading" align="center" width="35">Frags</th>

+    <th class="smheading" align="center" width="35">Kills</th>

+    <th class="smheading" align="center" width="35">Suicides</th>

+    <th class="smheading" align="center" width="35">Team Kills</th>

+    <th class="smheading" align="center" width="50">Matches</th>

+    <th class="smheading" align="center" width="45">Hours</th>

+  </tr>

 

+<?php

 $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

-FROM uts_player AS p, uts_games AS g

-WHERE p.gid = g.id

-GROUP BY g.name

-ORDER BY gamename ASC";

+  FROM uts_player AS p, uts_games AS g

+  WHERE p.gid = g.id

+  GROUP BY g.name

+  ORDER BY gamename ASC";

 

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

 

@@ -33,55 +27,55 @@ while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) {
 	$gametime = sec2hour($r_totsumm[sumgametime]);

 

 	echo'

-	  <tr>

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

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

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

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

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

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

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

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

-	  </tr>';

+  <tr>

+    <td align="center">'.$r_totsumm[gamename].'</td>

+    <td align="center">'.$r_totsumm[gamescore].'</td>

+    <td align="center">'.$r_totsumm[frags].'</td>

+    <td align="center">'.$r_totsumm[kills].'</td>

+    <td align="center">'.$r_totsumm[suicides].'</td>

+    <td align="center">'.$r_totsumm[teamkills].'</td>

+    <td align="center">'.$r_totsumm[matchcount].'</td>

+    <td align="center">'.$gametime.'</td>

+  </tr>';

 }

 

 $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

-FROM uts_player"));

+  FROM uts_player"));

 

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

 

 echo'

     <tr>

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

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

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

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

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

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

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

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

+    <td align="center">Totals</td>

+	    <td align="center">'.$sql_summtot[gamescore].'</td>

+	    <td align="center">'.$sql_summtot[frags].'</td>

+	    <td align="center">'.$sql_summtot[kills].'</td>

+	    <td align="center">'.$sql_summtot[suicides].'</td>

+	    <td align="center">'.$sql_summtot[teamkills].'</td>

+	    <td align="center">'.$sql_summtot[matchcount].'</td>

+	    <td align="center">'.$gametime2.'</td>

   </tr>

 </tbody></table>

 <br>

-<table class = "box" border="0" cellpadding="1" cellspacing="2" width="600">

+<table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">

   <tbody><tr>

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

+    <th class="heading" colspan="11" align="center">Assault, Domination and CTF Events Summary</th>

   </tr>

   <tr>

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

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

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

+    <th align="center" rowspan="2">Assault Objectives</th>

+    <th align="center" rowspan="2">Control Point Captures</th>

+    <th align="center" colspan="9">Capture The Flag</th>

   </tr>

   <tr>

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

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

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

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

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

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

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

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

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

+    <th align="center">Flag Takes</th>

+    <th align="center">Flag Pickups</th>

+    <th align="center">Flag Drops</th>

+    <th align="center">Flag Assists</th>

+    <th align="center">Flag Covers</th>

+    <th align="center">Flag Seals</th>

+    <th align="center">Flag Captures</th>

+    <th align="center">Flag Kills</th>

+    <th align="center">Flag Returns</th>

   </tr>';

 

  $q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error());

@@ -98,23 +92,23 @@ echo'
 

   echo'

   <tr>

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

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

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

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

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

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

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

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

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

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

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

+    <td align="center">'.$sql_cdatot[ass_obj].'</td>

+    <td align="center">'.$sql_cdatot[dom_cp].'</td>

+    <td align="center">'.$sql_cdatot[flag_taken].'</td>

+    <td align="center">'.$sql_cdatot[flag_pickedup].'</td>

+    <td align="center">'.$sql_cdatot[flag_dropped].'</td>

+    <td align="center">'.$sql_cdatot[flag_assist].'</td>

+    <td align="center">'.$sql_cdatot[flag_cover].'</td>

+    <td align="center">'.$sql_cdatot[flag_seal].'</td>

+    <td align="center">'.$sql_cdatot[flag_capture].'</td>

+    <td align="center">'.$sql_cdatot[flag_kill].'</td>

+    <td align="center">'.$sql_cdatot[flag_return].'</td>

   </tr>

 </tbody></table>

 <br>

-<table class = "box" border="0" cellpadding="1" cellspacing="2" width="500">

+<table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">

   <tbody><tr>

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

+    <th class="heading" colspan="4" align="center">Special Events</th>

   </tr>';

 

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

@@ -123,38 +117,38 @@ $sql_sprees = zero_out(small_query("SELECT SUM(spree_kill) AS spree_kill, SUM(sp
 

   echo'

   <tr>

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

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

+    <th class="smheading" align="center" colspan="2" width="250">Special/Multis</th>

+    <th class="smheading" align="center" colspan="2" width="250">Sprees</th>

   </tr>

   <tr>

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

-    <td class="grey" align="center" width="100">'.$sql_firstblood.'</td>

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

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

+    <th align="center" width="150">First Blood</th>

+    <td align="center" width="100">'.$sql_firstblood.'</td>

+    <th align="center" width="150">Killing Spree</th>

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

   </tr>

   <tr>

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

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

-    <td class="dark" align="center">Rampage</td>

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

+    <th align="center">Double Kills</th>

+    <td align="center">'.$sql_multis[spree_double].'</td>

+    <th align="center">Rampage</th>

+    <td align="center">'.$sql_sprees[spree_rampage].'</td>

   </tr>

   <tr>

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

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

-    <td class="dark" align="center">Dominating</td>

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

+    <th align="center">Multi Kills</th>

+    <td align="center">'.$sql_multis[spree_multi].'</td>

+    <th align="center">Dominating</th>

+    <td align="center">'.$sql_sprees[spree_dom].'</td>

   </tr>

   <tr>

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

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

-    <td class="dark" align="center">Unstoppable</td>

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

+    <th align="center">Ultra Kills</th>

+    <td align="center">'.$sql_multis[spree_ultra].'</td>

+    <th align="center">Unstoppable</th>

+    <td align="center">'.$sql_sprees[spree_uns].'</td>

   </tr>

   <tr>

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

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

-    <td class="dark" align="center">Godlike</td>

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

+    <th align="center">Monster Kills</th>

+    <td align="center">'.$sql_multis[spree_monster].'</td>

+    <th align="center">Godlike</th>

+    <td align="center">'.$sql_sprees[spree_god].'</td>

   </tr>

 </tbody></table>

 <br>';

@@ -163,9 +157,9 @@ include('includes/weaponstats.php');
 weaponstats(0, 0);

 

 echo'<br>

-<table class = "box" border="0" cellpadding="1" cellspacing="2" width="710">

+<table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">

   <tbody><tr>

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

+    <th class="heading" align="center">Totals for Players</th>

   </tr>

 </tbody></table>';

 

@@ -181,8 +175,8 @@ $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, AVG(ttl) AS ttl ,
 $sql_chighflag_capture = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , 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, p.country HAVING sumgametime > 1800 ORDER BY flag_capture DESC LIMIT 0,1");

 $sql_chighflag_kill = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , 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, p.country HAVING sumgametime > 1800 ORDER BY flag_kill DESC LIMIT 0,1");

 $sql_chighdom_cp = small_query("SELECT p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , 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, p.country HAVING sumgametime > 1800 ORDER BY dom_cp DESC LIMIT 0,1");

-

 $ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error());

+

 if ($ass_obj_check[idcount] > 0 ) {

 	$sql_chighass_obj = small_query("SELECT p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , 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 ass_obj DESC LIMIT 0,1");

 } else {

@@ -193,168 +187,167 @@ $sql_chighspree_monster = small_query("SELECT p.pid, pi.name, p.country, SUM(spr
 $sql_chighspree_god = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , 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, p.country HAVING sumgametime > 1800 ORDER BY spree_god DESC LIMIT 0,1");

 $sql_chighrank = small_query("SELECT p.pid, pi.name, p.country, SUM(rank) AS rank , 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, p.country HAVING sumgametime > 1800 ORDER BY rank DESC LIMIT 0,1");

 

-echo'<br>

-<table class = "box" border="0" cellpadding="1" cellspacing="2" width="550">

+echo '<br>

+<table class="zebra box" border="0" cellpadding="0" cellspacing="0" width="700">

   <tbody>

   <tr>

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

+    <th class="smheading" colspan="5" align="center">Career Highs</th>

   </tr>

   <tr>

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

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

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

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

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

+    <th class="smheading" align="center" width="200">Category</th>

+    <th class="smheading" align="center" width="200">Player</th>

+    <th class="smheading" align="center" width="50">Amount</th>

+    <th class="smheading" align="center" width="50">Hours</th>

+    <th class="smheading" align="center" width="50">Matches</th>

   </tr>';

-

 if ($sql_chighfrags and $sql_chighfrags[frags]) {

   echo '

   <tr>

-    <td class="dark" align="center">Frags</td>

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

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

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

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

+    <td align="center">Frags</td>

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

+    <td align="center">'.$sql_chighfrags[frags].'</td>

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

+    <td align="center">'.$sql_chighfrags[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Deaths</td>

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

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

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

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

+    <td align="center">Deaths</td>

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

+    <td align="center">'.$sql_chighdeaths[deaths].'</td>

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

+    <td align="center">'.$sql_chighdeaths[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Kills</td>

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

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

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

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

+    <td align="center">Kills</td>

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

+    <td align="center">'.$sql_chighkills[kills].'</td>

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

+    <td align="center">'.$sql_chighkills[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Suicides</td>

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

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

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

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

+    <td align="center">Suicides</td>

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

+    <td align="center">'.$sql_chighsuicides[suicides].'</td>

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

+    <td align="center">'.$sql_chighsuicides[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Team Kills</td>

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

+    <td align="center">'.$sql_chighteamkills[teamkills].'</td>

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

+    <td align="center">'.$sql_chighteamkills[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Efficiency</td>

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

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

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

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

+    <td align="center">Efficiency</td>

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

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

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

+    <td align="center">'.$sql_chigheff[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Accuracy</td>

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

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

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

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

+    <td align="center">Accuracy</td>

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

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

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

+    <td align="center">'.$sql_chighaccuracy[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">TTL</td>

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

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

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

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

+    <td align="center">TTL</td>

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

+    <td align="center">'.get_dp($sql_chighttl[ttl]).'</td>

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

+    <td align="center">'.$sql_chighttl[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Flag Caps</td>

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

+    <td align="center">'.$sql_chighflag_capture[flag_capture].'</td>

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

+    <td align="center">'.$sql_chighflag_capture[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Flag Kills</td>

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

+    <td align="center">'.$sql_chighflag_kill[flag_kill].'</td>

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

+    <td align="center">'.$sql_chighflag_kill[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Domination Control Points</td>

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

+    <td align="center">'.$sql_chighdom_cp[dom_cp].'</td>

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

+    <td align="center">'.$sql_chighdom_cp[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Assault Objectives</td>

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

+    <td align="center">'.$sql_chighass_obj[ass_obj].'</td>

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

+    <td align="center">'.$sql_chighass_obj[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Monster Kills</td>

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

+    <td align="center">'.$sql_chighspree_monster[spree_monster].'</td>

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

+    <td align="center">'.$sql_chighspree_monster[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

-    <td class="dark" align="center">Godlikes</td>

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

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

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

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

+    <td align="center">Godlikes</td>

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

+    <td align="center">'.$sql_chighspree_god[spree_god].'</td>

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

+    <td align="center">'.$sql_chighspree_god[mcount].'</td>

   </tr>';

 }

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

   echo '

   <tr>

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

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

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

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

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

+    <td align="center">Rank Points</td>

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

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

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

+    <td align="center">'.$sql_chighrank[mcount].'</td>

   </tr>';

 }

 echo '

@@ -362,7 +355,6 @@ echo '
 <br>';

 

 // NGStats Style Total Highs (Single Match)

-

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

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

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

@@ -386,193 +378,184 @@ $sql_mhighspree_monster = small_query("SELECT p.matchid, p.pid, pi.name, p.count
 $sql_mhighspree_god = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_god > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY spree_god DESC LIMIT 0,1");

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

 

-echo'<table class = "box" border="0" cellpadding="1" cellspacing="2" width="480">

+echo'<table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">

   <tbody>

   <tr>

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

+    <th class="smheading" colspan="4" align="center">Match Highs</th>

   </tr>

   <tr>

-    <td class="smheading" align="center" width="175">Category</td>

-    <td class="smheading" align="center" width="175">Player</td>

-    <td class="smheading" align="center" width="65">Amount</td>

-    <td class="smheading" align="center" width="65">Match</td>

+    <th class="smheading" align="center" width="175">Category</th>

+    <th class="smheading" align="center" width="175">Player</th>

+    <th class="smheading" align="center" width="65">Amount</th>

+    <th class="smheading" align="center" width="65">Match</th>

   </tr>';

 

 if ($sql_mhighfrags) {

   echo '

   <tr>

-    <td class="dark" align="center">Frags</td>

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

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

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

+    <td align="center">Frags</td>

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

+    <td align="center">'.$sql_mhighfrags[frags].'</td>

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

   </tr>';

 }

 if ($sql_mhighdeaths) {

   echo '

   <tr>

-    <td class="dark" align="center">Deaths</td>

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

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

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

+    <td align="center">Deaths</td>

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

+    <td align="center">'.$sql_mhighdeaths[deaths].'</td>

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

   </tr>';

 }

 if ($sql_mhighkills) {

   echo '

   <tr>

-    <td class="dark" align="center">Kills</td>

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

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

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

+    <td align="center">Kills</td>

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

+    <td align="center">'.$sql_mhighkills[kills].'</td>

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

   </tr>';

 }

 if ($sql_mhighsuicides) {

   echo '

   <tr>

-    <td class="dark" align="center">Suicides</td>

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

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

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

+    <td align="center">Suicides</td>

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

+    <td align="center">'.$sql_mhighsuicides[suicides].'</td>

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

   </tr>';

 }

 if ($sql_mhighteamkills) {

   echo '

   <tr>

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

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

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

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

+    <td align="center">Team Kills</td>

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

+    <td align="center">'.$sql_mhighteamkills[teamkills].'</td>

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

   </tr>';

 }

 if ($sql_mhigheff) {

   echo '

   <tr>

-    <td class="dark" align="center">Efficiency</td>

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

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

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

+    <td align="center">Efficiency</td>

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

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

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

   </tr>';

 }

 if ($sql_mhighaccuracy) {

   echo '

   <tr>