'); } // 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.'

'; ?>