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