blob: b41baf2c16547476a94bf0a002cee7ece6e64b3c (
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
64
65
66
67
68
69
70
71
72
73
74
75
|
<?php
$gid = my_addslashes($_GET['gid']);
$r_gamename = small_query("SELECT name FROM uts_games WHERE id = '$gid'");
$gamename = $r_gamename['name'];
$r_pcount = small_query("SELECT COUNT(*) as pcount FROM uts_rank WHERE gid= '$gid'");
$pcount = $r_pcount['pcount'];
$ecount = $pcount/25;
$ecount2 = number_format($ecount, 0, '.', '');
IF($ecount > $ecount2) {
$ecount2 = $ecount2+1;
}
$fpage = 0;
IF($ecount < 1) { $lpage = 0; }
else { $lpage = $ecount2-1; }
$cpage = $_GET["page"];
IF ($cpage == "") { $cpage = "0"; }
$qpage = $cpage*25;
$tfpage = $cpage+1;
$tlpage = $lpage+1;
$ppage = $cpage-1;
$ppageurl = "<a class=\"pages\" href=\"./?p=ext_rank&gid=$gid&page=$ppage\">[Previous]</a>";
IF ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "<a class=\"pages\" href=\"./?p=ext_rank&gid=$gid&page=$npage\">[Next]</a>";
IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "<a class=\"pages\" href=\"./?p=ext_rank&gid=$gid&page=$fpage\">[First]</a>";
IF ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "<a class=\"pages\" href=\"./?p=ext_rank&gid=$gid&page=$lpage\">[Last]</a>";
IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
echo'
<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
<table class="box" border="0" cellpadding="1" cellspacing="1">
<tbody>
<tr>
<td class="heading" colspan="4" align="center">'.$gamename.' Ranking 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 = $qpage;
$sql_rplayer = "SELECT pi.name, pi.country, r.rank, r.prevrank, r.matches, r.pid FROM uts_rank AS r, uts_pinfo AS pi WHERE r.pid = pi.id AND r.gid = '$gid' AND pi.banned <> 'Y' ORDER BY rank DESC LIMIT $qpage,25";
$q_rplayer = mysql_query($sql_rplayer) or die(mysql_error());
while ($r_rplayer = mysql_fetch_array($q_rplayer)) {
$ranking++;
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]) .' '. 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'
</tbody></table>
<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>';
?>
|
