$ecount2) { $ecount2 = $ecount2+1; } $fpage = 0; IF($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } $cpage = preg_replace('/\D/', '', $_REQUEST["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.'

'; echo ' '; echo ' '; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, (SELECT count(p.id) FROM uts_player AS p WHERE m.id = p.matchid) as players FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid $where ORDER BY m.time DESC LIMIT $qpage,25"; $q_recent = mysql_query($sql_recent) or die(mysql_error()); while ($r_recent = mysql_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); $r_gametime = GetMinutes($r_recent[gametime]); echo' '; } echo '

Unreal Tournament Match List
'; echo ''; echo ''; echo ''; //echo ''; echo ''; echo ''; echo ''; echo ''; echo ' Filter: Date: '; echo '*'; for($i = date('Y');$i >= date("Y") - 5; $i--) { $selected = ($year == $i) ? 'selected' : ''; echo ''.$i.''; } echo ''; echo ' '; echo ''; echo '*'; $monthname = array('', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); for($i = 1;$i <= 12; $i++) { $selected = ($month == $i) ? 'selected' : ''; echo ''.$monthname[$i].''; } echo ''; echo ' '; echo ''; echo '*'; for($i = 1;$i <= 31; $i++) { $selected = ($day == $i) ? 'selected' : ''; echo ''.$i.''; } echo ' Gametype: '; 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 '
Match ID	Date/Time	Match Type	Map	Time	Players
'.$r_recent[id].'	'.$r_time.'	'.$r_recent[gamename].'	'.$r_mapfile.'	'.$r_gametime.'	'.$r_recent[players].'

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

'; ?>