$ecount2) { $ecount2 = $ecount2+1; } $fpage = 0; if ($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } $cpage = mysqli_real_escape_string($GLOBALS["___mysqli_link"], 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 ' '; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, t0score, t1score, t2score, t3score, (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 ".mysqli_real_escape_string($GLOBALS["___mysqli_link"], $qpage).",50"; $q_recent = mysqli_query($GLOBALS["___mysqli_link"], $sql_recent) or die(mysqli_error($GLOBALS["___mysqli_link"])); while ($r_recent = mysqli_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); $r_gametime = GetMinutes($r_recent[gametime]); $winner = max($r_recent[t0score], $r_recent[t1score], $r_recent[t2score], $r_recent[t3score]); $moreThan2Teams = ($r_recent[t2score]!=0); if ($winner == $r_recent[t0score]) { $winnercolor = "red"; $winmsg = "Red is the winner!"; } elseif ($winner == $r_recent[t1score]) { $winnercolor = "blue"; $winmsg = "Blue is the winner!"; } elseif ($winner == $r_recent[t2score]) { $winnercolor = "green"; $winmsg = "Green is the winner!"; } else { $winnercolor = "gold"; $winmsg = "Gold is the winner!"; }; echo ' '; } echo '

Unreal Tournament Match List

'; echo ''; echo ''; echo ''; //echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Filter:	Date:	'; echo ' '; echo ''; echo ' '; echo '	Gametype:

'; echo '

Date/Time

Match Type

Map

Scores

'.$r_recent[id].'

'.$r_time.'

'.$r_recent[gamename].'

'.$r_mapfile.'

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

'; ?>