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

'; $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

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.'

'; ?>