'); } // Get filter and set sorting $filter = my_addslashes($_GET[filter]); $sort = my_addslashes($_GET[sort]); $q = my_addslashes($_GET[q]); $gid = preg_replace('/\D/', '', $_GET[gid]); IF (empty($filter) or (!in_array(strtolower($filter), array("mapfile", "matchcount", "frags", "matchscore", "gametime")))) { $filter = "mapfile"; } if (empty($sort) or ($sort != 'ASC' and $sort != 'DESC')) $sort = ($filter == "mapfile") ? "ASC" : "DESC"; if (isset($gid)) { if ($gid != 0) { $url_condition .= "&gid=".urlencode($gid); $sql_condition = " WHERE gid = $gid"; } } else { $gid = 0; } if (isset($q)) { if ($gid != 0) { $sql_condition .= ' AND mapfile LIKE "%' . $q . '%" '; } else { $sql_condition .= ' WHERE mapfile LIKE "%' . $q . '%" '; } $url_condition .= "&q=".urlencode($q); } // Firstly we need to work out First Last Next Prev pages $mcount = small_count("SELECT mapfile FROM uts_match" . $sql_condition . " GROUP BY mapfile"); $ecount = $mcount/25; $ecount2 = number_format($ecount, 0, '.', ''); IF($ecount > $ecount2) { $ecount2 = $ecount2+1; } $fpage = 0; IF($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } $cpage = preg_replace('/\D/', '', $_GET["page"]); IF ($cpage == "") { $cpage = "0"; } $qpage = $cpage*25; $tfpage = $cpage+1; $tlpage = $lpage+1; $ppage = $cpage-1; $ppageurl = "[Previous]"; IF ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; IF ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; IF ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } echo'

Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; $sql_maps = "SELECT IF(RIGHT(mapfile,4) LIKE '.unr', mapfile, CONCAT(mapfile, '.unr')) as mapfile, COUNT(id) AS matchcount, AVG(frags) AS frags, AVG(t0score+t1score+t2score+t3score) AS matchscore, SUM(gametime) AS gametime FROM uts_match" . $sql_condition . " GROUP BY mapfile ORDER BY $filter $sort LIMIT $qpage,25"; $q_maps = mysql_query($sql_maps) or die(mysql_error()); while ($r_maps = mysql_fetch_array($q_maps)) { $r_mapfile = un_ut($r_maps[mapfile]); $myurl = urlencode($r_mapfile); $r_gametime = GetMinutes($r_maps[gametime]); echo' '; } echo'

Unreal Tournament Maps List
Filter: '; echo ''; echo '*'; $sql_game = "SELECT DISTINCT(p.gid), g.name FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id ORDER BY g.name ASC"; $q_game = mysql_query($sql_game) or die(mysql_error()); while ($r_game = mysql_fetch_array($q_game)) { $selected = ($r_game['gid'] == $gid) ? 'selected' : ''; echo ''. $r_game['name'] .''; } echo ' '; echo ' Search: '; echo ' '; echo '
Map Name'.SortPic('mapfile', $filter, $sort).'	Matches'.SortPic('matchcount', $filter, $sort).'	Avg. Frags'.SortPic('frags', $filter, $sort).'	Avg. Score'.SortPic('matchscore', $filter, $sort).'	Time'.SortPic('gametime', $filter, $sort).'
'.$r_mapfile.'	'.$r_maps[matchcount].'	'.get_dp($r_maps[frags]).'	'.get_dp($r_maps[matchscore]).'	'.$r_gametime.'

Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; ?>