diff options
Diffstat (limited to 'html/includes/teamstats.php')
-rwxr-xr-x | html/includes/teamstats.php | 101 |
1 files changed, 53 insertions, 48 deletions
diff --git a/html/includes/teamstats.php b/html/includes/teamstats.php index fd06ead..b2116b9 100755 --- a/html/includes/teamstats.php +++ b/html/includes/teamstats.php @@ -1,8 +1,10 @@ <?php
function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'gamescore DESC') {
global $gamename, $gid;
+
$r_info = small_query("SELECT teamgame, t0score, t1score, t2score, t3score FROM uts_match WHERE id = '$mid'");
if (!$r_info) die("Match not found");
+
$teams = ($r_info['teamgame'] == 'True') ? true : false;
$teamscore[-1] = 0;
$teamscore[0] = $r_info['t0score'];
@@ -10,31 +12,29 @@ function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'ga $teamscore[2] = $r_info['t2score'];
$teamscore[3] = $r_info['t3score'];
-
$cols = 10;
if ($teams) $cols++;
if ($extra) $cols++;
-
$oldteam = -1;
-
echo'
- <table class = "box" border="0" cellpadding="0" cellspacing="2" width="600">
- <tbody><tr>
- <td class="heading" colspan="'.$cols.'" align="center">'.htmlentities($title).'</td>
- </tr>';
-
+ <table class="box zebra" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody>
+ <tr>
+ <th class="heading" colspan="'.$cols.'" align="center">'.htmlentities($title).'</th>
+ </tr>';
$sql_players = "SELECT pi.name, pi.banned, p.pid, p.team, p.country, p.gametime, p.gamescore, p.frags, p.deaths, p.suicides, p.teamkills, p.eff, p.accuracy, p.ttl, p.rank".(($extra) ? ', p.'.$extra.' AS '.$extra : '')."
- FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid
- ORDER BY".(($teams) ? ' team ASC,' : '')." $order";
+ FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid
+ ORDER BY".(($teams) ? ' team ASC,' : '')." $order";
$q_players = mysql_query($sql_players) or die(mysql_error());
$header = true;
teamstats_init_totals($totals, $num);
+
while ($r_players = zero_out(mysql_fetch_array($q_players))) {
$r_players['dom_cp'] = $r_players['gamescore'] - $r_players['frags'];
-
$r_players['team'] = intval($r_players['team']);
+
if ($teams and $oldteam != $r_players['team']) {
if ($r_players['team'] != 0) teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]);
$oldteam = $r_players['team'];
@@ -46,27 +46,29 @@ function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'ga case 2: $teamname = 'Green'; break;
case 3: $teamname = 'Gold'; break;
}
- echo'<tr><td class="hlheading" colspan="'.$cols.'" align="center">Team: '.$teamname.'</td></tr>';
+
+ echo'<tr><td class="'.$teamname.'" colspan="'.$cols.'" align="center">Team: '.$teamname.'</td></tr>';
$header = true;
}
+
if ($header) {
$header = false;
echo '
<tr>
- <td class="smheading" align="center">Player</td>
- <td class="smheading" align="center" width="50">Time</td>
- <td class="smheading" align="center" width="50">Score</td>';
- if ($extra) echo' <td class="smheading" align="center" width="50">'.htmlentities($extratitle).'</td>';
+ <th class="smheading" align="center">Player</th>
+ <th class="smheading" align="center" width="50">Time</th>
+ <th class="smheading" align="center" width="50">Score</th>';
+ if ($extra) echo '<th class="smheading" align="center" width="50">'.htmlentities($extratitle).'</th>';
echo'
- <td class="smheading" align="center" width="40" '.OverlibPrintHint('F').'>F</td>
- <td class="smheading" align="center" width="40" '.OverlibPrintHint('K').'>K</td>
- <td class="smheading" align="center" width="40" '.OverlibPrintHint('D').'>D</td>
- <td class="smheading" align="center" width="40" '.OverlibPrintHint('S').'>S</td>';
- if ($teams) echo '<td class="smheading" align="center" width="40" '.OverlibPrintHint('TK').'>TK</td>';
+ <th class="smheading tooltip" align="center" width="40" title="Frags: A player\'s frag count is equal to their kills minus suicides. In team games team kills (not team suicides) are also subtracted from the player\'s kills.">F</th>
+ <th class="smheading tooltip" align="center" width="40" title="Kills: Number of times a player kills another player.">K</th>
+ <th class="smheading tooltip" align="center" width="40" title="Deaths: Number of times a player gets killed by another player.">D</th>
+ <th class="smheading tooltip" align="center" width="40" title="Suicides: Number of times a player dies due to action of their own cause. Suicides can be environment induced (drowning, getting crushed, falling) or weapon related (fatal splash damage from their own weapon).">S</th>';
+ if ($teams) echo '<th class="smheading tooltip" align="center" width="40" title="Team Kills: Number of times a player in a team based game kills someone on their own team.">TK</th>';
echo '
- <td class="smheading" align="center" width="55" '.OverlibPrintHint('EFF').'>Eff.</td>
- <td class="smheading" align="center" width="55" '.OverlibPrintHint('ACC').'>Acc.</td>
- <td class="smheading" align="center" width="50" '.OverlibPrintHint('TTL').'>Avg TTL</td>
+ <th class="smheading tooltip" align="center" width="55" title="Efficiency: A ratio that denotes the player\'s kill skill by comparing it with his overall performance. A perfect efficiency is equal to 1 (100%), anything less than 0.5 (50%) is below average. Formula: Kills / (Kills + Deaths + Suicides [+Team Kills])">Eff.</th>
+ <th class="smheading tooltip" align="center" width="55" title="Accuracy: Overall accuracy when using all weapons. Most accurate in insta but also very accurate in normal weapons.">Acc.</th>
+ <th class="smheading tooltip" align="center" width="50" title="Average Time to Live: The length of time a player is in a game in seconds divided by how many times he/she dies, thus giving an average time of how long he/she will live.">Avg TTL</th>
</tr>';
}
@@ -87,7 +89,7 @@ function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'ga $totals['acc'] += $r_players['accuracy'];
$totals['ttl'] += $r_players['ttl'];
$num++;
-
+
if ($r_players['banned'] == 'Y') {
$eff = '-';
$acc = '-';
@@ -101,15 +103,16 @@ function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'ga $r_players['teamkills'] = '-';
}
-
$class = ($num % 2) ? 'grey' : 'grey2';
- echo '<tr>';
+ echo '<tr class="clickableRow" href="./?p=matchp&mid='.$mid.'&pid='.$r_players['pid'].'">';
+
if ($r_players['banned'] != 'Y') {
- echo '<td nowrap class="darkhuman" align="left"><a class="darkhuman" href="./?p=matchp&mid='.$mid.'&pid='.$r_players['pid'].'">'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).'</a></td>';
+ echo '<td nowrap align="left"><a href="./?p=matchp&mid='.$mid.'&pid='.$r_players['pid'].'">'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).'</a></td>';
} else {
- echo '<td nowrap class="darkhuman" align="left"><span style="text-decoration: line-through;">'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).'</span></td>';
+ echo '<td nowrap align="left"><span style="text-decoration: line-through;">'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).'</span></td>';
}
- echo '<td class="'.$class.'" align="center">'.GetMinutes($r_players['gametime']/TIMERATIO).'</td>';
+
+ echo '<td class="'.$class.'" align="center">'.GetMinutes($r_players['gametime'] / TIMERATIO).'</td>';
echo '<td class="'.$class.'" align="center">'.$r_players['gamescore'].'</td>';
if ($extra) echo '<td class="'.$class.'" align="center">'.$r_players[$extra].'</td>';
@@ -121,14 +124,15 @@ function teamstats($mid, $title, $extra = NULL, $extratitle = NULL, $order = 'ga if ($teams) echo '<td class="'.$class.'" align="center">'.$r_players['teamkills'].'</td>';
- echo '<td class="'.$class.'" align="center">'.$eff.'</td>';
- echo '<td class="'.$class.'" align="center">'.$acc.'</td>';
- echo '<td class="'.$class.'" align="center">'.$ttl.'</td>';
+ echo '<td align="center">'.$eff.'</td>';
+ echo '<td align="center">'.$acc.'</td>';
+ echo '<td align="center">'.$ttl.'</td>';
echo '</tr>';
}
+
teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]);
- echo '</tbody></table><br>';
+ echo '</tbody></table><br>';
}
function teamstats_init_totals(&$totals, &$num, $extra = null) {
@@ -151,27 +155,28 @@ function teamstats_team_totals(&$totals, $num, $teams, $extra, $teamscore) { $acc = get_dp($totals['acc'] / $num);
$ttl = GetMinutes($totals['ttl'] / $num);
-
echo '<tr>';
- echo '<td nowrap class="dark" align="center">Totals</td>';
- echo '<td class="darkgrey" align="center"></td>';
+ echo '<td nowrap class="totals" align="center">Totals</td>';
+ echo '<td class="totals" align="center"></td>';
+
if ($teams) {
- echo '<td class="darkgrey" align="center"><strong>'.$teamscore.'</strong> ('.$totals[gamescore].')</td>';
+ echo '<td class="totals" align="center"><strong>'.$teamscore.'</strong> ('.$totals[gamescore].')</td>';
} else {
- echo '<td class="darkgrey" align="center">'.$totals[gamescore].'</td>';
+ echo '<td class="totals" align="center">'.$totals[gamescore].'</td>';
}
- if ($extra) echo '<td class="darkgrey" align="center">'.$totals[$extra].'</td>';
+ if ($extra) echo '<td class="totals" align="center">'.$totals[$extra].'</td>';
- echo '<td class="darkgrey" align="center">'.$totals[frags].'</td>';
- echo '<td class="darkgrey" align="center">'.$totals[kills].'</td>';
- echo '<td class="darkgrey" align="center">'.$totals[deaths].'</td>';
- echo '<td class="darkgrey" align="center">'.$totals[suicides].'</td>';
+ echo '<td class="totals" align="center">'.$totals[frags].'</td>';
+ echo '<td class="totals" align="center">'.$totals[kills].'</td>';
+ echo '<td class="totals" align="center">'.$totals[deaths].'</td>';
+ echo '<td class="totals" align="center">'.$totals[suicides].'</td>';
- if ($teams) echo '<td class="darkgrey" align="center">'.$totals[teamkills].'</td>';
+ if ($teams) echo '<td class="totals" align="center">'.$totals[teamkills].'</td>';
- echo '<td class="darkgrey" align="center">'.$eff.'</td>';
- echo '<td class="darkgrey" align="center">'.$acc.'</td>';
- echo '<td class="darkgrey" align="center">'.$ttl.'</td>';
+ echo '<td class="totals" align="center">'.$eff.'</td>';
+ echo '<td class="totals" align="center">'.$acc.'</td>';
+ echo '<td class="totals" align="center">'.$ttl.'</td>';
echo '</tr>';
}
+
?>
|