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
106
|
<?php
global $s_lastvisit;
echo'
<table class = "box" border="0" cellpadding="1" cellspacing="2" width="720">
<tbody><tr>
<td class="heading" align="center">Your Watchlist</td>
</tr>
</tbody></table>';
echo '<br><br><br>';
$watchlist = GetCurrentWatchlist();
if (count($watchlist) > 25) $watchlist = array_slice($watchlist, 0, 25);
if (count($watchlist) == 0) {
echo "<p class='pages'>Your watchlist is empty!<br><br>You can add players to your watchlist by clicking the appropriate icon on the header of their career summary page.</p>";
return;
}
echo '
<table class="box" border="0" cellpadding="1" cellspacing="1" width="625">
<tbody>
<tr>
<td class="smheading" align="center" width="150">Player Name</td>
<td class="smheading" align="center">Last Match</td>
<td class="smheading" align="center">Matches</td>
<td class="smheading" align="center">Score</td>
<td class="smheading" align="center">Frags</td>
<td class="smheading" align="center">Kills</td>
<td class="smheading" align="center">Deaths</td>
<td class="smheading" align="center">Suicides</td>
<td class="smheading" align="center">Eff</td>
<td class="smheading" align="center">Acc</td>
<td class="smheading" align="center">TTL</td>
<td class="smheading" align="center">Hours</td>
</tr>';
$i = 0;
foreach($watchlist as $pid) {
$sql_players = "SELECT pi.id AS pid,
pi.name,
pi.country,
m.time,
m.id AS mid
FROM uts_pinfo pi,
uts_match m,
uts_player p
WHERE pi.id = '$pid'
AND p.matchid = m.id
AND p.pid = pi.id
ORDER BY m.time DESC
LIMIT 0,1
";
$sql_pinfo = " SELECT COUNT(*) AS games,
SUM(p.gamescore) as gamescore,
SUM(p.frags) AS frags,
SUM(p.kills) AS kills,
SUM(p.deaths) AS deaths,
SUM(p.suicides) as suicides,
AVG(p.eff) AS eff,
AVG(p.accuracy) AS accuracy,
AVG(p.ttl) AS ttl,
SUM(gametime) as gametime
FROM uts_player AS p
WHERE p.pid = '$pid'
GROUP BY p.pid";
$r_pinfo = small_query($sql_pinfo);
$q_players = mysql_query($sql_players) or die(mysql_error());
while ($r_players = mysql_fetch_array($q_players)) {
$i++;
$new = (mtimestamp($r_players['time']) > $s_lastvisit) ? true : false;
$class = ($i % 2) ? 'grey' : 'grey2';
echo '<tr>';
echo '<td class="dark"><a class="darkhuman" href="?p=pinfo&pid='. $r_players['pid'] .'">';
echo FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name']);
echo '</a></td>';
echo '<td class="'.$class.'" align="center"><a class="'.$class.'" href="?p=match&mid='. $r_players['mid'] .'">';;
if ($new) echo "<strong>";
echo date("Y-m-d H:i", mtimestamp($r_players['time']));
if ($new) echo "</strong>";
echo '</a></td>';
echo '
<td class="'.$class.'" align="center">'.$r_pinfo['games'].'</td>
<td class="'.$class.'" align="center">'.$r_pinfo['gamescore'].'</td>
<td class="'.$class.'" align="center">'.$r_pinfo['frags'].'</td>
<td class="'.$class.'" align="center">'.$r_pinfo['kills'].'</td>
<td class="'.$class.'" align="center">'.$r_pinfo['deaths'].'</td>
<td class="'.$class.'" align="center">'.$r_pinfo['suicides'].'</td>
<td class="'.$class.'" align="center">'.get_dp($r_pinfo['eff']).'</td>
<td class="'.$class.'" align="center">'.get_dp($r_pinfo['accuracy']).'</td>
<td class="'.$class.'" align="center">'.GetMinutes($r_pinfo['ttl']).'</td>
<td class="'.$class.'" align="center">'.sec2hour($r_pinfo['gametime']).'</td>';
echo '</tr>';
}
}
echo '</tbody></table>';
?>
|
