From 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Sat, 4 Feb 2017 16:05:45 +0100 Subject: Original UTStats beta 4.2.8 --- html/pages/players_search.php | 83 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 83 insertions(+) create mode 100755 html/pages/players_search.php (limited to 'html/pages/players_search.php') diff --git a/html/pages/players_search.php b/html/pages/players_search.php new file mode 100755 index 0000000..1791393 --- /dev/null +++ b/html/pages/players_search.php @@ -0,0 +1,83 @@ +'); +} + +// Get filter and set sorting +$playername = my_stripslashes($_REQUEST[name]); +$playersearch = my_addslashes($_REQUEST[name]); +$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($sort) or ($sort != 'ASC' and $sort != 'DESC')) $sort = ($filter == "name") ? "ASC" : "DESC"; + +echo' +
+
* Click headings to change Sorting *
+ + + + + + + + + + + + + + + + + + + + '; + +$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.name LIKE '%".$playersearch."%' AND pi.banned <> 'Y' GROUP BY name ORDER BY $filter $sort"; + +$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]); + + echo' + + + + + + + + + + + + + '; +} +echo' +
Player Search 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).'
'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_plist[name]).''.$r_plist[games].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$eff.''.$acc.''.$ttl.''.$gametime.'
'; +?> \ No newline at end of file -- cgit