From 790d93b495ecc375ea0518a5f43f2944daa9720b Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Mon, 8 Jan 2018 01:16:20 +0100 Subject: Main pages markup --- html/pages/players.php | 145 ++++++++++++++++++++++++++----------------------- 1 file changed, 78 insertions(+), 67 deletions(-) (limited to 'html/pages/players.php') diff --git a/html/pages/players.php b/html/pages/players.php index 1d9788a..d888855 100755 --- a/html/pages/players.php +++ b/html/pages/players.php @@ -1,29 +1,27 @@ '); + if ($curr_field != $filter) return; + $fname = 'images/s_'. strtolower($sort) .'.png'; + if (!file_exists($fname)) return; + return(' '); } - // 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 = "[Previous]"; -IF ($ppage < "0") { $ppageurl = "[Previous]"; } + +if ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; -IF ($npage >= "$ecount") { $npageurl = "[Next]"; } +if ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; -IF ($cpage == "0") { $fpageurl = "[First]"; } +if ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; -IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } +if ($cpage == "$lpage") { $lpageurl = "[Last]"; } // Show information echo' -
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
-
* Click headings to change Sorting *
- - - - - - - - - - - - - - - - - - - - '; + +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+ +
Unreal Tournament Player List
Name Search: - -
Player Name'.SortPic('name', $filter, $sort).'Matches'.SortPic('games', $filter, $sort).'Score'.SortPic('gamescore', $filter, $sort).'Frags'.SortPic('frags', $filter, $sort).'Kills'.SortPic('kills', $filter, $sort).'Deaths'.SortPic('deaths', $filter, $sort).'Suicides'.SortPic('suicides', $filter, $sort).'Eff.'.SortPic('eff', $filter, $sort).'Acc.'.SortPic('accuracy', $filter, $sort).'TTL'.SortPic('ttl', $filter, $sort).'Hours'.SortPic('gametime', $filter, $sort).'
+ + + + + + + + + + + + + + + + + + + + + + + '; $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' - - - - - - - - - - - - - '; +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' + + + + + + + + + + + + + '; } + echo'
Unreal Tournament Player List
+
+ + + + +
+
Player Name'.SortPic('name', $filter, $sort).'Matches'.SortPic('games', $filter, $sort).'Score'.SortPic('gamescore', $filter, $sort).'Frags'.SortPic('frags', $filter, $sort).'Kills'.SortPic('kills', $filter, $sort).'Deaths'.SortPic('deaths', $filter, $sort).'Suicides'.SortPic('suicides', $filter, $sort).'Eff.'.SortPic('eff', $filter, $sort).'Acc.'.SortPic('accuracy', $filter, $sort).'TTL'.SortPic('ttl', $filter, $sort).'Hours'.SortPic('gametime', $filter, $sort).'
'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_pname).''.$r_plist[games].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$eff.''.$acc.''.$ttl.''.$gametime.'
+ '.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_pname).' + '.$r_plist[games].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$eff.''.$acc.''.$ttl.''.$gametime.'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> -- cgit