diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
|---|---|---|
| committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
| commit | 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 (patch) | |
| tree | 6ac6279ac26749ffe7ca0ae9603fbcae2e757e6e /html/pages/rank.php | |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/pages/rank.php')
| -rwxr-xr-x | html/pages/rank.php | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/html/pages/rank.php b/html/pages/rank.php new file mode 100755 index 0000000..6eacca0 --- /dev/null +++ b/html/pages/rank.php @@ -0,0 +1,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>';
+ }
+}
+?>
\ No newline at end of file |