PageRenderTime 41ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/html/pages/home.php

https://github.com/graywh/utstats
PHP | 100 lines | 87 code | 11 blank | 2 comment | 1 complexity | 0dc346d41c09882861c78ca59975fdef MD5 | raw file
  1. <?php
  2. echo'
  3. <table class="box" border="0" cellpadding="1" cellspacing="1" width="450">
  4. <tbody><tr>
  5. <td class="heading" colspan="5" align="center">UTStats Summary</td>
  6. </tr>
  7. <tr>
  8. <td class="smheading" align="center">Players</td>
  9. <td class="smheading" align="center">Servers</td>
  10. <td class="smheading" align="center">Maps</td>
  11. <td class="smheading" align="center">Matches Logged</td>
  12. <td class="smheading" align="center">Player Hours</td>
  13. </tr>';
  14. // Get Summary Info
  15. $r_playercount = small_query("SELECT COUNT(*) AS result FROM uts_pinfo");
  16. $playercount = $r_playercount['result'];
  17. $servercount = small_count("SELECT DISTINCT servername FROM uts_match");
  18. $mapcount = small_count("SELECT COUNT(mapfile) AS result FROM uts_match GROUP BY mapfile");
  19. $r_matchcount = small_query("SELECT COUNT(*) AS result FROM uts_match");
  20. $matchcount= $r_matchcount['result'];
  21. $hourscount = small_query("SELECT SUM(gametime) AS result FROM uts_player");
  22. $gametime = sec2hour($hourscount[result]);
  23. echo'
  24. <tr>
  25. <td class="lggrey" align="center">'.$playercount.'</td>
  26. <td class="lggrey" align="center">'.$servercount.'</td>
  27. <td class="lggrey" align="center">'.$mapcount.'</td>
  28. <td class="lggrey" align="center">'.$matchcount.'</td>
  29. <td class="lggrey" align="center">'.$gametime.'</td>
  30. </tr>
  31. </tbody></table>
  32. <table border="0" width="600">
  33. <tbody><tr>
  34. <td align="center">
  35. <div class="titlemsg">
  36. <p>Welcome to UTStats.<br>
  37. Here you can look up information on UT matches and players.<br>
  38. Select a category from the column on the left.<br></p>
  39. </div>
  40. <table class="box" border="0" cellpadding="1" cellspacing="2">
  41. <tbody><tr>
  42. <td class="heading" colspan="8" align="center">Game Summary</td>
  43. </tr>
  44. <tr>
  45. <td class="smheading" align="center" width="150">Match Type</td>
  46. <td class="smheading" align="center" width="52">Frags</td>
  47. <td class="smheading" align="center" width="52">Kills</td>
  48. <td class="smheading" align="center" width="52">Suicides</td>
  49. <td class="smheading" align="center" width="40">Team Kills</td>
  50. <td class="smheading" align="center" width="52">Matches</td>
  51. <td class="smheading" align="center" width="52">Game Hours</td>
  52. </tr>';
  53. $sql_gamesummary = "SELECT g.id AS gid, g.name AS gamename, 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
  54. FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id GROUP BY gamename ORDER BY gamename ASC";
  55. $q_gamesummary = mysql_query($sql_gamesummary) or die(mysql_error());
  56. while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) {
  57. $gid = $r_gamesummary[gid];
  58. $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match WHERE gid = '$gid'");
  59. $gametime = sec2hour($q_gametime[gametime]);
  60. echo'<tr><td class="dark" align="center">'.$r_gamesummary[gamename].'</td>
  61. <td class="grey" align="center">'.$r_gamesummary[frags].'</td>
  62. <td class="grey" align="center">'.$r_gamesummary[kills].'</td>
  63. <td class="grey" align="center">'.$r_gamesummary[suicides].'</td>
  64. <td class="grey" align="center">'.$r_gamesummary[teamkills].'</td>
  65. <td class="grey" align="center">'.$r_gamesummary[matchcount].'</td>
  66. <td class="grey" align="center">'.$gametime.'</td>';
  67. }
  68. $totalsummary = small_query("SELECT 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 gametime
  69. FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id");
  70. $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match");
  71. $gametime = sec2hour($q_gametime[gametime]);
  72. echo' <tr>
  73. <td class="dark" align="center"><b>Totals for All Players</b></td>
  74. <td class="darkgrey" align="center">'.$totalsummary[frags].'</td>
  75. <td class="darkgrey" align="center">'.$totalsummary[kills].'</td>
  76. <td class="darkgrey" align="center">'.$totalsummary[suicides].'</td>
  77. <td class="darkgrey" align="center">'.$totalsummary[teamkills].'</td>
  78. <td class="darkgrey" align="center">'.$totalsummary[matchcount].'</td>
  79. <td class="darkgrey" align="center">'.$gametime.'</td>
  80. </tr>
  81. </tbody></table>
  82. </tbody></table><br>';
  83. // Do graph stuff
  84. $gtitle = "Across All Servers";
  85. $bgwhere = "id >= 0";
  86. include("pages/graph_mbreakdown.php");
  87. ?>