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 From 861e3230f0154e6a5942698adedf18d5eb0e0b8a Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Wed, 10 Jan 2018 20:08:33 +0100 Subject: Move imaegs to assets folder --- html/pages/players.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'html/pages/players.php') diff --git a/html/pages/players.php b/html/pages/players.php index d888855..b038405 100755 --- a/html/pages/players.php +++ b/html/pages/players.php @@ -7,7 +7,7 @@ function InvertSort($curr_field, $filter, $sort) { function SortPic($curr_field, $filter, $sort) { if ($curr_field != $filter) return; - $fname = 'images/s_'. strtolower($sort) .'.png'; + $fname = 'assets/images/s_'. strtolower($sort) .'.png'; if (!file_exists($fname)) return; return(' '); } -- cgit