diff options
Diffstat (limited to 'html/pages/recent.php')
| -rwxr-xr-x | html/pages/recent.php | 152 |
1 files changed, 90 insertions, 62 deletions
diff --git a/html/pages/recent.php b/html/pages/recent.php index 92fafb7..e95b195 100755 --- a/html/pages/recent.php +++ b/html/pages/recent.php @@ -1,4 +1,5 @@ <?php
+
// Firstly we need to work out First Last Next Prev pages
$where = ' ';
$year = !empty($_REQUEST['year']) ? my_addslashes(sprintf("%04d", $_REQUEST['year'])) : 0;
@@ -16,16 +17,16 @@ $mcount = $r_mcount['result']; $ecount = $mcount/25;
$ecount2 = number_format($ecount, 0, '.', '');
-IF($ecount > $ecount2) {
- $ecount2 = $ecount2+1;
+if ($ecount > $ecount2) {
+ $ecount2 = $ecount2+1;
}
$fpage = 0;
-IF($ecount < 1) { $lpage = 0; }
+if ($ecount < 1) { $lpage = 0; }
else { $lpage = $ecount2-1; }
-$cpage = preg_replace('/\D/', '', $_REQUEST["page"]);
-IF ($cpage == "") { $cpage = "0"; }
+$cpage = mysql_real_escape_string(preg_replace('/\D/', '', $_REQUEST["page"]));
+if ($cpage == "") { $cpage = "0"; }
$qpage = $cpage*25;
$tfpage = $cpage+1;
@@ -33,105 +34,132 @@ $tlpage = $lpage+1; $ppage = $cpage-1;
$ppageurl = "<a class=\"pages\" href=\"./?p=recent&year=$year&month=$month&day=$day&gid=$gid&page=$ppage\">[Previous]</a>";
-IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+if ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "<a class=\"pages\" href=\"./?p=recent&year=$year&month=$month&day=$day&gid=$gid&page=$npage\">[Next]</a>";
-IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+if ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "<a class=\"pages\" href=\"./?p=recent&year=$year&month=$month&day=$day&gid=$gid&page=$fpage\">[First]</a>";
-IF ($cpage == "0") { $fpageurl = "[First]"; }
+if ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "<a class=\"pages\" href=\"./?p=recent&year=$year&month=$month&day=$day&gid=$gid&page=$lpage\">[Last]</a>";
-IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
echo '
<form action="'.$_SERVER['PHP_SELF'].'" method="GET">
-<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
-<table width="720" class="box" border="0" cellpadding="1" cellspacing="1">
- <tbody><tr>
- <td class="heading" colspan="7" align="center">Unreal Tournament Match List</td>
- </tr>';
+<div class="pages spacer">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
-echo '
+<table width="900" class="zebra box" border="0" cellpadding="0" cellspacing="0">
+ <tbody><tr>
+ <th class="heading" colspan="7" align="center">Unreal Tournament Match List</th>
+ </tr>
<tr>
- <td class = "smheading" colspan = "7" align = "center">';
-echo '<input type="hidden" name="p" value="'.$_REQUEST['p'].'">';
-echo '<table width="700" class="searchform" border="0" cellpadding="1" cellspacing="1">';
-echo '<tr><td><strong>Filter:</strong></td>';
+ <th colspan="7" align="center">';
+echo '<input type="hidden" name="p" value="'.htmlentities($_REQUEST['p']).'">';
+echo '<table width="900" class="smheading" border="0" cellpadding="0" cellspacing="0">';
+echo '<tr><th class="noborders">Filter:</th>';
//echo '<td>Date:</td>';
-echo '<td><select class="searchform" name="year">';
+echo '<th class="noborders"><select class="searchform" name="year">';
echo '<option value="0">*</option>';
-for($i = date('Y');$i >= date("Y") - 5; $i--) {
- $selected = ($year == $i) ? 'selected' : '';
- echo '<option '.$selected.' value="'.$i.'">'.$i.'</option>';
+
+for ($i = date('Y');$i >= date("Y") - 5; $i--) {
+ $selected = ($year == $i) ? 'selected' : '';
+ echo '<option '.$selected.' value="'.$i.'">'.$i.'</option>';
}
+
echo '</select>';
echo ' ';
echo '<select class="searchform" name="month">';
echo '<option value="0">*</option>';
+
$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 '<option '.$selected.' value="'.$i.'">'.$monthname[$i].'</option>';
+for ($i = 1;$i <= 12; $i++) {
+ $selected = ($month == $i) ? 'selected' : '';
+ echo '<option '.$selected.' value="'.$i.'">'.$monthname[$i].'</option>';
}
+
echo '</select>';
echo ' ';
echo '<select class="searchform" name="day">';
echo '<option value="0">*</option>';
-for($i = 1;$i <= 31; $i++) {
- $selected = ($day == $i) ? 'selected' : '';
- echo '<option '.$selected.' value="'.$i.'">'.$i.'</option>';
+
+for ($i = 1;$i <= 31; $i++) {
+ $selected = ($day == $i) ? 'selected' : '';
+ echo '<option '.$selected.' value="'.$i.'">'.$i.'</option>';
}
-echo '</select></td>';
-echo '<td>Gametype:</td>';
-echo '<td><select class="searchform" name="gid">';
+echo '</select></th>';
+echo '<th class="noborders">Gametype:</th>';
+echo '<th class="noborders"><select class="searchform" name="gid">';
echo '<option value="0">*</option>';
+
$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 '<option '.$selected.' value="'.$r_game['gid'].'">'. $r_game['name'] .'</option>';
+ $selected = ($r_game['gid'] == $gid) ? 'selected' : '';
+ echo '<option '.$selected.' value="'.$r_game['gid'].'">'. $r_game['name'] .'</option>';
}
-echo '</select></td>';
-echo '<td><input class="searchform" type="Submit" name="filter" value="Apply"></td>';
+
+echo '</select></th>';
+echo '<th class="noborders"><input class="searchform" type="Submit" name="filter" value="Apply"></th>';
echo '</tr></table>';
echo '</td></tr>';
-
echo '
<tr>
- <td class="smheading" align="center" width="80">Match ID</td>
- <td class="smheading" align="center" width="220">Date/Time</td>
- <td class="smheading" align="center" width="140">Match Type</td>
- <td class="smheading" align="center">Map</td>
- <td class="smheading" align="center" width="60">Time</td>
- <td class="smheading" align="center" width="60">Players</td>
+ <th class="smheading" align="center" width="40">ID</th>
+ <th class="smheading" align="center" width="220">Date/Time</th>
+ <th class="smheading" align="center" width="140">Match Type</th>
+ <th class="smheading" align="center">Map</th>
+ <th class="smheading" align="center" width="200">Scores</th>
</tr>';
-$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";
+$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 ".mysql_real_escape_string($qpage).",50";
$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'
- <tr>
- <td class="dark" align="center"><a class="darkid" href="./?p=match&mid='.$r_recent[id].'">'.$r_recent[id].'</a></td>
- <td nowrap class="dark" align="center"><a class="darkhuman" href="./?p=match&mid='.$r_recent[id].'">'.$r_time.'</a></td>
- <td nowrap class="grey" align="center">'.$r_recent[gamename].'</td>
- <td class="grey" align="center">'.$r_mapfile.'</td>
- <td class="grey" align="center">'.$r_gametime.'</td>
- <td class="grey" align="center">'.$r_recent[players].'</td>
- </tr>';
+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]);
+ $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 '
+ <tr class="clickableRow" href="./?p=match&mid='.$r_recent[id].'">
+ <td align="center">'.$r_recent[id].'</td>
+ <td nowrap align="center"><a href="./?p=match&mid='.$r_recent[id].'">'.$r_time.'</a></td>
+ <td nowrap align="center">'.$r_recent[gamename].'</td>
+ <td align="center">'.$r_mapfile.'</td>
+ <td class="tooltip" title="'.$winmsg.'" align="center"><span class="redbox">'.$r_recent[t0score].'</span><span class="bluebox">'.$r_recent[t1score].'</span>';
+
+ if ($moreThan2Teams) {
+ echo '<span class="greenbox">'.$r_recent[t2score].' </span><span class="goldbox"> '.$r_recent[t3score].' </span>';
+ }
+
+ '</td>
+ </tr>';
}
-
-
echo '
</tbody></table>
-<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
+<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
</form>';
-?>
\ No newline at end of file +?>
|