blob: 6eacca0e29391ba41a301388f783f4c524f9f9cf (
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
|
<?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" border="0" cellpadding="1" cellspacing="1">
<tbody>
<tr>
<td class="heading" colspan="4" align="center">Top 10 '.$r_rgame['name'].' Players</td>
</tr>
<tr>
<td class="smheading" align="center" width="75">N°</td>
<td class="smheading" align="center" width="150">Player Name</td>
<td class="smheading" align="center" width="75">Rank</td>
<td class="smheadingx" align="center" width="75">Matches</td>
</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>
<td class="grey" align="center" colspan = "4">No players entered the rankings yet.</td>
</tr>
<tr>
<td class="smheading" align="center" colspan="4"> </td>
</tr>
</tbody></table><br>';
}
else {
while ($r_rplayer = mysql_fetch_array($q_rplayer)) {
$ranking++;
$myurl = urlencode($r_rplayer[name]);
echo'
<tr>
<td class="grey" align="center">'.$ranking.'</td>
<td nowrap class="dark" align="left"><a class="darkhuman" 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 class="dark" align="center">'.get_dp($r_rplayer[rank]).'</td>
<td class="grey" align="center">'.$r_rplayer[matches].'</td>
</tr>';
}
echo'
<tr>
<td class="smheading" 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>';
}
}
?>
|
