diff options
Diffstat (limited to 'html/pages/players.php')
| -rwxr-xr-x | html/pages/players.php | 145 |
1 files changed, 78 insertions, 67 deletions
diff --git a/html/pages/players.php b/html/pages/players.php index 1d9788a..b038405 100755 --- a/html/pages/players.php +++ b/html/pages/players.php @@ -1,29 +1,27 @@ <?php
function InvertSort($curr_field, $filter, $sort) {
- if ($curr_field != $filter) return(($curr_field == "name") ? "ASC" : "DESC");
- if ($sort == 'ASC') return('DESC');
- return('ASC');
+ if ($curr_field != $filter) return(($curr_field == "name") ? "ASC" : "DESC");
+ if ($sort == 'ASC') return('DESC');
+ return('ASC');
}
function SortPic($curr_field, $filter, $sort) {
- if ($curr_field != $filter) return;
- $fname = 'images/s_'. strtolower($sort) .'.png';
- if (!file_exists($fname)) return;
- return(' <img src="'. $fname .'" border="0" width="11" height="9" alt="" title="('.strtolower($sort).'ending)">');
+ if ($curr_field != $filter) return;
+ $fname = 'assets/images/s_'. strtolower($sort) .'.png';
+ if (!file_exists($fname)) return;
+ return(' <img src="'. $fname .'" border="0" width="11" height="9" alt="" class="tooltip" title="('.strtolower($sort).'ending)">');
}
-
// Get filter and set sorting
$filter = my_addslashes($_GET[filter]);
$sort = my_addslashes($_GET[sort]);
-IF (empty($filter) or (!in_array(strtolower($filter), array("name", "games", "gamescore", "frags", "kills", "deaths", "suicides", "eff", "accuracy", "ttl", "gametime")))) {
- $filter = "name";
+if (empty($filter) or (!in_array(strtolower($filter), array("name", "games", "gamescore", "frags", "kills", "deaths", "suicides", "eff", "accuracy", "ttl", "gametime")))) {
+ $filter = "name";
}
if (empty($sort) or ($sort != 'ASC' and $sort != 'DESC')) $sort = ($filter == "name") ? "ASC" : "DESC";
-
// Work out Prev, Next, First, Last Stuff
$r_pcount = small_query("SELECT COUNT(*) AS pcount FROM uts_pinfo");
@@ -32,16 +30,16 @@ $pcount = $r_pcount['pcount']; $ecount = $pcount/50;
$ecount2 = number_format($ecount, 0, '.', '');
-IF($ecount > $ecount2) {
- $ecount2 = $ecount2+1;
+if ($ecount > $ecount2) {
+ $ecount2 = $ecount2+1;
}
$fpage = 0;
-IF($ecount < 1) { $lpage = 0; }
+if ($ecount < 1) { $lpage = 0; }
else { $lpage = $ecount2-1; }
$cpage = preg_replace('/\D/', '', $_GET["page"]);
-IF ($cpage == "") { $cpage = "0"; }
+if ($cpage == "") { $cpage = "0"; }
$qpage = $cpage*50;
$tfpage = $cpage+1;
@@ -49,76 +47,89 @@ $tlpage = $lpage+1; $ppage = $cpage-1;
$ppageurl = "<a class=\"pages\" href=\"./?p=players&filter=$filter&sort=$sort&page=$ppage\">[Previous]</a>";
-IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+
+if ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "<a class=\"pages\" href=\"./?p=players&filter=$filter&sort=$sort&page=$npage\">[Next]</a>";
-IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+if ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "<a class=\"pages\" href=\"./?p=players&filter=$filter&sort=$sort&page=$fpage\">[First]</a>";
-IF ($cpage == "0") { $fpageurl = "[First]"; }
+if ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "<a class=\"pages\" href=\"./?p=players&filter=$filter&sort=$sort&page=$lpage\">[Last]</a>";
-IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
// Show information
echo'
-<form NAME="playersearch" METHOD="post" ACTION="./?p=psearch">
-<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
-<div class="opnote">* Click headings to change Sorting *</div>
-<table class="box" border="0" cellpadding="1" cellspacing="1">
- <tbody><tr>
- <td class="heading" colspan="12" align="center">Unreal Tournament Player List</td>
- </tr>
- <tr>
- <td class = "smheading" colspan = "12" ALIGN="center">Name Search:
- <input TYPE="text" NAME="name" MAXLENGTH="35" SIZE="20" CLASS="searchform">
- <input TYPE="submit" NAME="Default" VALUE="Search" CLASS="searchformb"></td>
- </tr>
- <tr>
- <td class="smheading" align="center" width="150"><a class="smheading" href="./?p=players&filter=name&sort='.InvertSort('name', $filter, $sort).'">Player Name</a>'.SortPic('name', $filter, $sort).'</td>
- <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=games&sort='.InvertSort('games', $filter, $sort).'">Matches</a>'.SortPic('games', $filter, $sort).'</td>
- <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=gamescore&sort='.InvertSort('gamescore', $filter, $sort).'">Score</a>'.SortPic('gamescore', $filter, $sort).'</td>
- <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=frags&sort='.InvertSort('frags', $filter, $sort).'">Frags</a>'.SortPic('frags', $filter, $sort).'</td>
- <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=kills&sort='.InvertSort('kills', $filter, $sort).'">Kills</a>'.SortPic('kills', $filter, $sort).'</td>
- <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=deaths&sort='.InvertSort('deaths', $filter, $sort).'">Deaths</a>'.SortPic('deaths', $filter, $sort).'</td>
- <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=suicides&sort='.InvertSort('suicides', $filter, $sort).'">Suicides</a>'.SortPic('suicides', $filter, $sort).'</td>
- <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=eff&sort='.InvertSort('eff', $filter, $sort).'">Eff.</a>'.SortPic('eff', $filter, $sort).'</td>
- <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=accuracy&sort='.InvertSort('accuracy', $filter, $sort).'">Acc.</a>'.SortPic('accuracy', $filter, $sort).'</td>
- <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=ttl&sort='.InvertSort('ttl', $filter, $sort).'">TTL</a>'.SortPic('ttl', $filter, $sort).'</td>
- <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=gametime&sort='.InvertSort('gametime', $filter, $sort).'">Hours</a>'.SortPic('gametime', $filter, $sort).'</td>
- </tr>';
+<form name="playersearch" method="post" action="./?p=psearch">
+ <div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
+
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0">
+ <thead>
+ <tr>
+ <th class="heading" colspan="12" align="center">Unreal Tournament Player List</th>
+ </tr>
+ <tr>
+ <th class="smheading" colspan="12" align="center">
+ <div class="darksearch">
+ <span>
+ <input type="text" class="search square" placeholder="Search player..." name="name" value="'.htmlentities($playername).'">
+ <input class="searchbutton" type="submit" value="Search">
+ </span>
+ </div>
+ </th>
+ </tr>
+ <tr>
+ <th class="smheading" align="center" width="150"><a class="smheading" href="./?p=players&filter=name&sort='.InvertSort('name', $filter, $sort).'">Player Name</a>'.SortPic('name', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=games&sort='.InvertSort('games', $filter, $sort).'">Matches</a>'.SortPic('games', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=gamescore&sort='.InvertSort('gamescore', $filter, $sort).'">Score</a>'.SortPic('gamescore', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=frags&sort='.InvertSort('frags', $filter, $sort).'">Frags</a>'.SortPic('frags', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=kills&sort='.InvertSort('kills', $filter, $sort).'">Kills</a>'.SortPic('kills', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=deaths&sort='.InvertSort('deaths', $filter, $sort).'">Deaths</a>'.SortPic('deaths', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&filter=suicides&sort='.InvertSort('suicides', $filter, $sort).'">Suicides</a>'.SortPic('suicides', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=eff&sort='.InvertSort('eff', $filter, $sort).'">Eff.</a>'.SortPic('eff', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=accuracy&sort='.InvertSort('accuracy', $filter, $sort).'">Acc.</a>'.SortPic('accuracy', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=ttl&sort='.InvertSort('ttl', $filter, $sort).'">TTL</a>'.SortPic('ttl', $filter, $sort).'</th>
+ <th class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&filter=gametime&sort='.InvertSort('gametime', $filter, $sort).'">Hours</a>'.SortPic('gametime', $filter, $sort).'</th>
+ </tr>
+ </thead>
+ <tbody>
+ ';
$sql_plist = "SELECT pi.name AS name, pi.country AS country, p.pid, COUNT(p.id) 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, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY p.pid ORDER BY $filter $sort LIMIT $qpage,50";
$q_plist = mysql_query($sql_plist) or die(mysql_error());
-while ($r_plist = mysql_fetch_array($q_plist)) {
- $gametime = sec2hour($r_plist[gametime]);
- $eff = get_dp($r_plist[eff]);
- $acc = get_dp($r_plist[accuracy]);
- $ttl = GetMinutes($r_plist[ttl]);
- $r_pname = $r_plist[name];
- $myurl = urlencode($r_pname);
-
- echo'
- <tr>
- <td nowrap class="dark" align="left"><a class="darkhuman" href="./?p=pinfo&pid='.$r_plist['pid'].'">'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_pname).'</a></td>
- <td class="grey" align="center">'.$r_plist[games].'</td>
- <td class="grey" align="center">'.$r_plist[gamescore].'</td>
- <td class="grey" align="center">'.$r_plist[frags].'</td>
- <td class="grey" align="center">'.$r_plist[kills].'</td>
- <td class="grey" align="center">'.$r_plist[deaths].'</td>
- <td class="grey" align="center">'.$r_plist[suicides].'</td>
- <td class="grey" align="center">'.$eff.'</td>
- <td class="grey" align="center">'.$acc.'</td>
- <td class="grey" align="center">'.$ttl.'</td>
- <td class="grey" align="center">'.$gametime.'</td>
- </tr>';
+while ($r_plist = mysql_fetch_array($q_plist)) {
+ $gametime = sec2hour($r_plist[gametime]);
+ $eff = get_dp($r_plist[eff]);
+ $acc = get_dp($r_plist[accuracy]);
+ $ttl = GetMinutes($r_plist[ttl]);
+ $r_pname = $r_plist[name];
+ $myurl = urlencode($r_pname);
+
+ echo'
+ <tr class="zebra clickableRow" href="./?p=pinfo&pid='.$r_plist['pid'].'">
+ <td nowrap align="left">
+ <a href="./?p=pinfo&pid='.$r_plist['pid'].'">'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_pname).'</a>
+ </td>
+ <td align="center">'.$r_plist[games].'</td>
+ <td align="center">'.$r_plist[gamescore].'</td>
+ <td align="center">'.$r_plist[frags].'</td>
+ <td align="center">'.$r_plist[kills].'</td>
+ <td align="center">'.$r_plist[deaths].'</td>
+ <td align="center">'.$r_plist[suicides].'</td>
+ <td align="center">'.$eff.'</td>
+ <td align="center">'.$acc.'</td>
+ <td align="center">'.$ttl.'</td>
+ <td align="center">'.$gametime.'</td>
+ </tr>';
}
+
echo'
</tbody></table>
-<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
+<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
</form>';
?>
|