diff options
Diffstat (limited to 'html/pages')
| -rwxr-xr-x | html/pages/help.php | 14 | ||||
| -rwxr-xr-x | html/pages/home.php | 2 | ||||
| -rw-r--r-- | html/pages/maps.php | 2 | ||||
| -rw-r--r-- | html/pages/maps_info.php | 220 | ||||
| -rw-r--r-- | html/pages/match_info_killsmatrix.php | 169 | ||||
| -rwxr-xr-x | html/pages/match_info_other.php | 11 | ||||
| -rw-r--r-- | html/pages/servers.php | 2 | ||||
| -rw-r--r-- | html/pages/servers_query.php | 4 |
8 files changed, 211 insertions, 213 deletions
diff --git a/html/pages/help.php b/html/pages/help.php index c156eae..51186c6 100755 --- a/html/pages/help.php +++ b/html/pages/help.php @@ -7,11 +7,17 @@ <td class="credits" align="left">
<blockquote>
<p>
- For help and documentation please visit
+ For installation instrcutions and documentation please visit
<a href="https://github.com/sn3p/utstats" target="_blank">https://github.com/sn3p/utstats</a>.
- <br>
- Please report issues and feature requests in the
- <a href="https://github.com/sn3p/utstats/issues" target="_blank">issue tracker</a>.
+ </p>
+ <p>
+ Still havind problems? Check out the
+ <a href="https://github.com/sn3p/utstats/wiki/Troubleshooting" target="_blank">Troubleshooting</a>
+ page.
+ </p>
+ <p>
+ UTStats is getting pretty old so errors or warnings you'll encounter are most likely caused by deprecated or functions that are not supported any more.
+ Please report issues and feature requests in the <a href="https://github.com/sn3p/utstats/issues" target="_blank">issue tracker</a>.
</p>
</blockquote>
</td>
diff --git a/html/pages/home.php b/html/pages/home.php index d2d90cf..a61d7f9 100755 --- a/html/pages/home.php +++ b/html/pages/home.php @@ -1,7 +1,5 @@ <?php
-include_once("analytics.php");
-
// Get last map, time, scores
$qlastMaps = small_query("SELECT id, mapfile, time, t0score, t1score, t2score, t3score FROM uts_match WHERE time = (SELECT MAX(time) FROM uts_match)");
$lastMapId = $qlastMaps['id'];
diff --git a/html/pages/maps.php b/html/pages/maps.php index 69c8785..1959085 100644 --- a/html/pages/maps.php +++ b/html/pages/maps.php @@ -83,7 +83,7 @@ echo' <div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
<table class="zebra box" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
- <th class="heading" colspan="5" align="center">Maps List</th>
+ <th class="heading" colspan="5" align="center">Unreal Tournament Maps List</th>
</tr>
<tr>
<th class="smheading" align="center" width="100%" colspan="5">
diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php index a7c355e..fc0a9e3 100644 --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -19,19 +19,24 @@ if($map_matches[gametime]<= 0) { // Map pic code
$mappic = getMapImageName($map);
- echo'
- <table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
- <tbody><tr>
- <th class="heading" align="center" colspan="4">Statistics for '.htmlentities($map).'</th>
- </tr><tr>
- <th colspan="4" class="mapheader"><img border="0" alt="'.$mapname.'" class="tooltip" title="'.$mapname.'" src="'.$mappic.'" width=698></th></tr>
+ echo '
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody>
+ <tr>
+ <th class="heading" align="center" colspan="4">Statistics for '.htmlentities($map).'</th>
+ </tr>
+ <tr>
+ <th colspan="4" class="mapheader">
+ <img border="0" alt="'.$map.'" src="'.$mappic.'" width=698>
+ </th>
+ </tr>
<tr>
- <th align="center">Matches</th>
- <td align="center">'.$map_matches[matchcount].'</td>
+ <th align="center">Matches</th>
+ <td align="center">'.$map_matches[matchcount].'</td>
</tr>
<tr>
- <th align="center">Total Time</th>
- <td align="center">'.$map_tottime.' minutes</td>
+ <th align="center">Total Time</th>
+ <td align="center">'.$map_tottime.' minutes</td>
</tr>';
// Show some gametype specific stuff
if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) {
@@ -40,25 +45,25 @@ if($map_matches[gametime]<= 0) { if (!empty($record['time'])) {
echo '
<tr>
- <th align="center">Fastest Capture</th>
- <td align="center"><a href="?p=pinfo&pid='.$record[id].'">'.FormatPlayerName($record['country'], $record['id'], $record['name']).'</a><br>' . btcaptime($record['time']) . ' minutes<BR>'.gmdate('d-m-Y h:i a', $record['date']).'</td>
+ <th align="center">Fastest Capture</th>
+ <td align="center"><a href="?p=pinfo&pid='.$record[id].'">'.FormatPlayerName($record['country'], $record['id'], $record['name']).'</a><br>' . btcaptime($record['time']) . ' minutes<BR>'.gmdate('d-m-Y h:i a', $record['date']).'</td>
</tr>';
}
else {
echo '
<tr>
- <th align="center">Fastest Capture</th>
- <td align="center">No record set!</td>
+ <th align="center">Fastest Capture</th>
+ <td align="center">No record set!</td>
</tr>';
}
echo '
<tr>
- <th align="center">Total Flags Captured</th>
- <td align="center">'.$map_matches[gamescore].'</td>
+ <th align="center">Total Flags Captured</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
else if (strtolower(substr($map, 0, 4)) == "ctf-") {
@@ -66,28 +71,28 @@ if($map_matches[gametime]<= 0) { $totals = small_query("SELECT SUM(p.flag_taken) as flag_taken, SUM(p.flag_return) AS flag_return, SUM(p.flag_cover) AS flag_cover FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')");
echo '
<tr>
- <th align="center">Total Flags Captured</th>
- <td align="center">'.$map_matches[gamescore].'</td>
+ <th align="center">Total Flags Captured</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
</tr>
<tr>
- <th align="center">Total Flags Taken</th>
- <td align="center">'.$totals['flag_taken'].'</td>
+ <th align="center">Total Flags Taken</th>
+ <td align="center">'.$totals['flag_taken'].'</td>
</tr>
<tr>
- <th align="center">Total Covers</th>
- <td align="center">'.$totals['flag_cover'].'</td>
+ <th align="center">Total Covers</th>
+ <td align="center">'.$totals['flag_cover'].'</td>
</tr>
<tr>
- <th align="center">Total Flags Returned</th>
- <td align="center">'.$totals['flag_return'].'</td>
+ <th align="center">Total Flags Returned</th>
+ <td align="center">'.$totals['flag_return'].'</td>
</tr>
<tr>
- <th align="center">Total Kills</th>
- <td align="center">'.$map_matches[kills].'</td>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
else if (strtolower(substr($map, 0, 3)) == "as-") {
@@ -95,16 +100,16 @@ if($map_matches[gametime]<= 0) { $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')");
echo '
<tr>
- <th align="center">Total Objectives Achieved</th>
- <td align="center">'.$totals[ass_obj].'</td>
+ <th align="center">Total Objectives Achieved</th>
+ <td align="center">'.$totals[ass_obj].'</td>
</tr>
<tr>
- <th align="center">Total Kills</th>
- <td align="center">'.$map_matches[kills].'</td>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
else if (strtolower(substr($map, 0, 3)) == "jb-") {
@@ -112,16 +117,16 @@ if($map_matches[gametime]<= 0) { $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')");
echo '
<tr>
- <th align="center">Team Releases</th>
- <td align="center">'.$totals[ass_obj].'</td>
+ <th align="center">Team Releases</th>
+ <td align="center">'.$totals[ass_obj].'</td>
</tr>
<tr>
- <th align="center">Total Kills</th>
- <td align="center">'.$map_matches[kills].'</td>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
else if (strtolower(substr($map, 0, 4)) == "dom-") {
@@ -129,118 +134,119 @@ if($map_matches[gametime]<= 0) { $totals = small_query("SELECT SUM(p.dom_cp) as dom_cp FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')");
echo '
<tr>
- <th align="center">Total Control Points Captured</th>
- <td align="center">'.$totals['dom_cp'].'</td>
+ <th align="center">Total Control Points Captured</th>
+ <td align="center">'.$totals['dom_cp'].'</td>
</tr>
<tr>
- <th align="center">Total Kills</th>
- <td align="center">'.$map_matches[kills].'</td>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
else {
echo '
<tr>
- <th align="center">Total Score</th>
- <td align="center">'.$map_matches[gamescore].'</td>
+ <th align="center">Total Score</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
</tr>
<tr>
- <th align="center">Total Kills</th>
- <td align="center">'.$map_matches[kills].'</td>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
</tr>
<tr>
- <th align="center">Total Teamkills</th>
- <td align="center">'.$map_matches[teamkills].'</td>
+ <th align="center">Total Teamkills</th>
+ <td align="center">'.$map_matches[teamkills].'</td>
</tr>
<tr>
- <th align="center">Total Suicides</th>
- <td align="center">'.$map_matches[suicides].'</td>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
</tr>';
}
echo '
<tr>
- <th align="center">Last Match</th>
- <td align="center">'.$map_lastmatch.'</td>
+ <th align="center">Last Match</th>
+ <td align="center">'.$map_lastmatch.'</td>
</tr>
</tbody></table>
<br>';
-
// Show a list of recent matches
$mcount = small_count("SELECT id FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap' GROUP BY id");
$ecount = $mcount/25;
$ecount2 = number_format($ecount, 0, '.', '');
- IF($ecount > $ecount2) {
+ 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/', '', $_GET["page"]);
$qpage = $cpage*25;
- IF ($cpage == "") { $cpage = "0"; }
+ if ($cpage == "") { $cpage = "0"; }
$tfpage = $cpage+1;
$tlpage = $lpage+1;
$ppage = $cpage-1;
$ppageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$ppage\">[Previous]</a>";
- IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+ if ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$npage\">[Next]</a>";
- IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+ if ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$fpage\">[First]</a>";
- IF ($cpage == "0") { $fpageurl = "[First]"; }
+ if ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$lpage\">[Last]</a>";
- IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+ if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
// list recent matches
- echo'
+ echo '
<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
<table class="zebra box" border="0" cellpadding="0" cellspacing="0" width=700>
- <tbody><tr>
- <th class="heading" colspan="5" align="center">Recent Matches</th>
+ <tbody>
+ <tr>
+ <th class="heading" colspan="5" align="center">Recent Matches</th>
</tr>
<tr>
- <th class="smheading" align="center" width="250">Date</th>
- <th class="smheading" align="center" width="100">Match Type</th>
- <th class="smheading" align="center">Player Count</th>
- <th class="smheading" align="center" width="100">Time</th>
+ <th class="smheading" align="center" width="250">Date</th>
+ <th class="smheading" align="center" width="100">Match Type</th>
+ <th class="smheading" align="center">Player Count</th>
+ <th class="smheading" align="center" width="100">Time</th>
</tr>';
$sql_maps = "SELECT m.id, m.time, g.name AS gamename, m.gametime
- FROM uts_match AS m, uts_games AS g WHERE (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND m.gid = g.id ORDER BY time DESC LIMIT $qpage,25";
+ FROM uts_match AS m, uts_games AS g WHERE (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND m.gid = g.id ORDER BY time DESC 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]);
- $r_matchtime = mdate($r_maps[time]);
- $r_gametime = GetMinutes($r_maps[gametime]);
+ while ($r_maps = mysql_fetch_array($q_maps)) {
+ $r_mapfile = un_ut($r_maps[mapfile]);
+ $r_matchtime = mdate($r_maps[time]);
+ $r_gametime = GetMinutes($r_maps[gametime]);
- $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]");
+ $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]");
- echo'
- <tr class="clickableRow" href="./?p=match&mid='.$r_maps[id].'">
+ echo '
+ <tr class="clickableRow" href="./?p=match&mid='.$r_maps[id].'">
<td align="center"><a href="./?p=match&mid='.$r_maps[id].'">'.$r_matchtime.'</a></td>
<td align="center">'.$r_maps[gamename].'</td>
<td align="center">'.$map_pcount.'</td>
<td align="center">'.$r_gametime.'</td>
- </tr>';
+ </tr>';
}
- echo'
- </tbody></table>
+ echo '
+ </tbody>
+ </table>
<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>';
// Do graph stuff
@@ -254,71 +260,73 @@ if($map_matches[gametime]<= 0) { $ecount = $mcount/25;
$ecount2 = number_format($ecount, 0, '.', '');
- IF($ecount > $ecount2) {
+ 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/', '', $_GET["rpage"]);
$qpage = $cpage*25;
- IF ($cpage == "") { $cpage = "0"; }
+ if ($cpage == "") { $cpage = "0"; }
$tfpage = $cpage+1;
$tlpage = $lpage+1;
$ppage = $cpage-1;
$ppageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$ppage\">[Previous]</a>";
- IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+ if ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$npage\">[Next]</a>";
- IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+ if ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$fpage\">[First]</a>";
- IF ($cpage == "0") { $fpageurl = "[First]"; }
+ if ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$lpage\">[Last]</a>";
- IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+ if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
- $sql_btrecords = "SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT $qpage,25";
+ $sql_btrecords = "SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT $qpage,25";
$q_btrecords = mysql_query($sql_btrecords) or die (mysql_error());
+
if (mysql_num_rows($q_btrecords) > 0) {
echo '
<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
- <table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
- <tbody>
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody>
<tr>
- <th class="heading" colspan="4" align="center">Fastest captures</th>
+ <th class="heading" colspan="4" align="center">Fastest captures</th>
</tr>
<tr>
- <th class="smheading" align="center" width="40">N°</th>
- <th class="smheading" align="center" width="200">Name</th>
- <th class="smheading" align="center" width="60">Time</th>
- <th class="smheading" align="center" width="180">Date</th>
- </tr>';
+ <th class="smheading" align="center" width="40">N°</th>
+ <th class="smheading" align="center" width="200">Name</th>
+ <th class="smheading" align="center" width="60">Time</th>
+ <th class="smheading" align="center" width="180">Date</th>
+ </tr>';
+
$i = $qpage;
$lasttime = -1;
+
while ($r_btrecords = mysql_fetch_array($q_btrecords)) {
$i++;
$class = ($i%2) ? 'grey' : 'grey2';
echo '
<tr><td class = "'.$class.'" align = "right">'.($lasttime == $r_btrecords['time'] ? '' : $i).' </td>
- <td class = "'.$class.'" align = "center"><a href="?p=pinfo&pid='.$r_btrecords[id].'">', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '</a></td>
- <td class = "'.$class.'" align = "center">', btcaptime($r_btrecords['time']), '</td>
- <td class = "'.$class.'" align = "center">', gmdate('d-m-Y h:i a', $r_btrecords['date']), '</td></tr>';
+ <td class="'.$class.'" align="center"><a href="?p=pinfo&pid='.$r_btrecords[id].'">', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '</a></td>
+ <td class="'.$class.'" align="center">', btcaptime($r_btrecords['time']), '</td>
+ <td class="'.$class.'" align="center">', gmdate('d-m-Y h:i a', $r_btrecords['date']), '</td></tr>';
$lasttime = $r_btrecords['time'];
}
- echo '
- </tbody>
+
+ echo '</tbody>
</table>
<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div><br>';
}
}
-
}
?>
diff --git a/html/pages/match_info_killsmatrix.php b/html/pages/match_info_killsmatrix.php index 3b425e5..0ace5ac 100644 --- a/html/pages/match_info_killsmatrix.php +++ b/html/pages/match_info_killsmatrix.php @@ -1,23 +1,23 @@ <?php
function PrintVertical($text) {
- $len = strlen($text);
- $ret = '';
- for ($i = 0; $i < $len; $i++) {
- $ret .= substr($text, $i, 1) .'<br>';
- }
- return($ret);
+ $len = strlen($text);
+ $ret = '';
+ for ($i = 0; $i < $len; $i++) {
+ $ret .= substr($text, $i, 1) .'<br>';
+ }
+ return($ret);
}
// Retrieve the killmatrix
-$sql_km = " SELECT killer,
- victim,
- kills
- FROM uts_killsmatrix
- WHERE matchid = $mid;";
-
+$sql_km = " SELECT killer,
+ victim,
+ kills
+ FROM uts_killsmatrix
+ WHERE matchid = $mid;";
+
$q_km = mysql_query($sql_km) or die(mysql_error());
while ($r_km = mysql_fetch_array($q_km)) {
- $km[intval($r_km['killer'])][intval($r_km['victim'])] = $r_km['kills'];
+ $km[intval($r_km['killer'])][intval($r_km['victim'])] = $r_km['kills'];
}
// No matrix: bye
@@ -29,27 +29,27 @@ $teamgame = $qm_teamgame['teamgame']; $teamgame = ($teamgame == 'False') ? false : true;
// Get the players of this match
-$sql_players = " SELECT p.pid,
- p.playerid,
- pi.name,
- pi.country,
- pi.banned,
- p.team,
- p.suicides
- FROM uts_player p,
- uts_pinfo pi
- WHERE (p.pid = pi.id)
- AND matchid = '$mid'
- ORDER BY team ASC,
- gamescore DESC;";
+$sql_players = " SELECT p.pid,
+ p.playerid,
+ pi.name,
+ pi.country,
+ pi.banned,
+ p.team,
+ p.suicides
+ FROM uts_player p,
+ uts_pinfo pi
+ WHERE (p.pid = pi.id)
+ AND matchid = '$mid'
+ ORDER BY team ASC,
+ gamescore DESC;";
$q_players = mysql_query($sql_players) or die(mysql_error());
while ($r_players = mysql_fetch_array($q_players)) {
- $players[intval($r_players['playerid'])] = array( 'pid' => $r_players['pid'],
- 'name' => $r_players['name'],
- 'country' => $r_players['country'],
- 'banned' => $r_players['banned'],
- 'suicides' => intval($r_players['suicides']),
- 'team' => intval($r_players['team']));
+ $players[intval($r_players['playerid'])] = array( 'pid' => $r_players['pid'],
+ 'name' => $r_players['name'],
+ 'country' => $r_players['country'],
+ 'banned' => $r_players['banned'],
+ 'suicides' => intval($r_players['suicides']),
+ 'team' => intval($r_players['team']));
}
@@ -58,7 +58,7 @@ $extra = $teamgame ? 3 : 2; echo '
<table class="zebra" border="0" cellpadding="0" cellspacing="0" width="700">
-
+
<tbody><tr>
<th class="heading" colspan="'. (count($players) + $extra) .'" align="center">Kills Match Up</th>
</tr>
@@ -69,69 +69,66 @@ echo ' // Victims
foreach($players as $player) {
-
-
-
- echo '<th align="center" class="tooltip" title="'.($player['name']).'" href="?p=matchp&mid='. $mid .'&pid='. urlencode($player['pid']). '">
- <div class="vertical">';
- if (strlen($player['name']) > 10) {
-echo substr($player['name'],0,10);
-} else {
-echo $player['name'] ;
-};
-'</div></th>';
-}
+ echo '<th align="center" class="tooltip" title="'.($player['name']).'" href="?p=matchp&mid='. $mid .'&pid='. urlencode($player['pid']). '">
+ <div class="vertical">';
+ if (strlen($player['name']) > 10) {
+ echo substr($player['name'],0,10);
+ } else {
+ echo $player['name'] ;
+ };
+ '</div></th>';
+}
echo '</tr><tr>';
// Team colors victims
if ($teamgame) {
- foreach($players as $player) {
- switch($player['team']) {
- case 0: $teamcolor = 'redteamb'; break;
- case 1: $teamcolor = 'blueteamb'; break;
- case 2: $teamcolor = 'greenteamb'; break;
- case 3: $teamcolor = 'goldteamb'; break;
- }
- echo '<td class="'. $teamcolor .'" align="center" width="25" height="25">
- <img src="images/victim.png" height="15"></td>';
- }
- echo '</tr>';
+ foreach($players as $player) {
+ switch($player['team']) {
+ case 0: $teamcolor = 'redteamb'; break;
+ case 1: $teamcolor = 'blueteamb'; break;
+ case 2: $teamcolor = 'greenteamb'; break;
+ case 3: $teamcolor = 'goldteamb'; break;
+ }
+ echo '<td class="'. $teamcolor .'" align="center" width="25" height="25">
+ <img src="images/victim.png" height="15"></td>';
+ }
+ echo '</tr>';
}
// Killer rows
$first = true;
$i = 0;
foreach($players as $kid => $killer) {
- if ($killer['banned'] == 'Y') continue;
- $i++;
- echo '<tr class="clickableRow" href="?p=matchp&mid='. $mid .'&pid='. urlencode($killer['pid']). '">';
- if ($first) echo'<td class="smheading" rowspan="'. count($players) .'" align="center" width="20"> <img src="images/xhair.png"> </td>';
- echo '<td nowrap align="left" style="width: 220px;">';
- echo '<a href="?p=matchp&mid='. $mid .'&pid='. urlencode($killer['pid']). '">'.
- FormatPlayerName($killer['country'], $killer['pid'], $killer['name'], $gid, $gamename) .' </a></td>';
- if ($teamgame) {
- switch($killer['team']) {
- case 0: $teamcolor = 'redteamb'; break;
- case 1: $teamcolor = 'blueteamb'; break;
- case 2: $teamcolor = 'greenteamb'; break;
- case 3: $teamcolor = 'goldteamb'; break;
- }
- echo '<td class="'. $teamcolor .'" align="center" width="30" height="25"><img src="images/xhair.png" height="15"></td>';
- }
- foreach($players as $vid => $victim) {
- $class = ($kid == $vid) ? 'suicide' : 'killCell';
- //if ($i % 2) $class .= '2';
- echo '<td class="'.$class.' tooltip" title="'.($victim['name']).'" href="?p=matchp&mid='. $mid .'&pid='. urlencode($player['pid']). '" align="center" width="20">';
- if ($kid == $vid) {
- $val = ($killer['suicides'] != 0) ? $killer['suicides'] : ' ';
- } else {
- $val = (isset($km[$kid][$vid])) ? $km[$kid][$vid] : ' ';
- }
- echo $val .'</td>';
- }
+ if ($killer['banned'] == 'Y') continue;
+ $i++;
+ echo '<tr class="clickableRow" href="?p=matchp&mid='. $mid .'&pid='. urlencode($killer['pid']). '">';
+ if ($first) echo'<td class="smheading" rowspan="'. count($players) .'" align="center" width="20"> <img src="images/xhair.png"> </td>';
+ echo '<td nowrap align="left" style="width: 220px;">';
+ echo '<a href="?p=matchp&mid='. $mid .'&pid='. urlencode($killer['pid']). '">'.
+ FormatPlayerName($killer['country'], $killer['pid'], $killer['name'], $gid, $gamename) .' </a></td>';
+ if ($teamgame) {
+ switch($killer['team']) {
+ case 0: $teamcolor = 'redteamb'; break;
+ case 1: $teamcolor = 'blueteamb'; break;
+ case 2: $teamcolor = 'greenteamb'; break;
+ case 3: $teamcolor = 'goldteamb'; break;
+ }
+ echo '<td class="'. $teamcolor .'" align="center" width="30" height="25"><img src="images/xhair.png" height="15"></td>';
+ }
+ foreach($players as $vid => $victim) {
+ $class = ($kid == $vid) ? 'suicide' : 'killCell';
+ //if ($i % 2) $class .= '2';
+ echo '<td class="'.$class.' tooltip" title="'.($victim['name']).'" href="?p=matchp&mid='. $mid .'&pid='. urlencode($player['pid']). '" align="center" width="20">';
+ if ($kid == $vid) {
+ $val = ($killer['suicides'] != 0) ? $killer['suicides'] : ' ';
+ } else {
+ $val = (isset($km[$kid][$vid])) ? $km[$kid][$vid] : ' ';
+ }
+ echo $val .'</td>';
+ }
- $first = false;
-}
+ $first = false;
+}
echo '</tbody></table><br>';
-?>
\ No newline at end of file +?>
diff --git a/html/pages/match_info_other.php b/html/pages/match_info_other.php index b92ae74..6547637 100755 --- a/html/pages/match_info_other.php +++ b/html/pages/match_info_other.php @@ -123,15 +123,4 @@ if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Sta echo '</tbody></table>';
-/*
-// To add when forum widget is available
-
-echo '
-<br><table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
- <tbody><tr>
- <td class="share" colspan="4"><center>Share this match:<br> <div class="darksearch">
- <span><input type="text" class="owshare square" value="[stats]'.$mid.'[/stats]" name="name" value="'.htmlentities($playername).'"></span></div>
-</td></tr></tbody></table>';
-*/
-
?>
diff --git a/html/pages/servers.php b/html/pages/servers.php index 770796b..bb54d75 100644 --- a/html/pages/servers.php +++ b/html/pages/servers.php @@ -39,7 +39,7 @@ echo ' <table class="zebra box" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
- <th class="heading" colspan="6" align="center">Server List</th>
+ <th class="heading" colspan="6" align="center">Unreal Tournament Server List</th>
</tr>
<tr>
<td class="smheading" align="center" width="250">Server Name</td>
diff --git a/html/pages/servers_query.php b/html/pages/servers_query.php index c44a718..d6228a6 100644 --- a/html/pages/servers_query.php +++ b/html/pages/servers_query.php @@ -70,7 +70,7 @@ if (file_exists($mappic)) { $mapname = getiteminfo("mapname",$chunks);
$mappic = strtolower("images/maps/".$mapname.".jpg");
-IF (file_exists($mappic)) {
+if (file_exists($mappic)) {
} else {
$mappic = "images/maps/blank.jpg";
}
@@ -173,4 +173,4 @@ for ($i = 0; $i < $r_numplayers; $i++) { }
echo'</tbody></table>';
-?>
\ No newline at end of file +?>
|