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