blob: 4be751eed66d06534dcd29db6c4d7b343e243573 (
plain)
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
|
<?php
$sql_rgame = "SELECT DISTINCT(p.gid), g.name FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id ORDER BY g.name ASC";
$q_rgame = mysql_query($sql_rgame) or die(mysql_error());
while ($r_rgame = mysql_fetch_array($q_rgame)) {
echo'
<table class="box zebra" border="0" cellpadding="0" cellspacing="0" width="700">
<tbody>
<tr>
<th class="heading" colspan="4" align="center">Top 10 '.$r_rgame['name'].' Players</th>
</tr>
<tr>
<th align="center" width="50">N°</th>
<th align="center" width="150">Player Name</th>
<th align="center" width="75">Rank</th>
<th align="center" width="75">Matches</th>
</tr>
';
$ranking = 0;
$sql_rplayer = "SELECT pi.id AS pid, pi.name, pi.country, r.rank, r.prevrank, r.matches FROM uts_rank AS r, uts_pinfo AS pi WHERE r.pid = pi.id AND r.gid = '$r_rgame[gid]' AND pi.banned <> 'Y' ORDER BY r.rank DESC LIMIT 0,10";
$q_rplayer = mysql_query($sql_rplayer) or die(mysql_error());
if (mysql_num_rows($q_rplayer) == 0) {
echo '
<tr>
<th align="center" colspan = "4">No players entered the rankings yet.</th>
</tr>
<tr>
<th align="center" colspan="4"> </th>
</tr>
</tbody></table>
<br>';
}
else {
while ($r_rplayer = mysql_fetch_array($q_rplayer)) {
$ranking++;
$myurl = urlencode($r_rplayer[name]);
echo'
<tr class="clickableRow" href="./?p=pinfo&pid='.$r_rplayer[pid].'">
<td align="center">'.$ranking.'</td>
<td nowrap align="left">
<a href="./?p=pinfo&pid='.$r_rplayer[pid].'">'.FlagImage($r_rplayer[country]).' '.htmlspecialchars($r_rplayer[name], ENT_QUOTES) .' '. RankMovement($r_rplayer['rank'] - $r_rplayer['prevrank']).'</a>
</td>
<td align="center">'.get_dp($r_rplayer[rank]).'</td>
<td align="center">'.$r_rplayer[matches].'</td>
</tr>';
}
echo'
<tr>
<td class="totals" align="center" colspan="4">
<a href="./?p=ext_rank&gid='.$r_rgame[gid].'">Click here to see all the rankings</a>
</td>
</tr>
</tbody></table>
<br>';
}
}
?>
|
