From 3a58cb2802c8be14f78015105afe759b1c7ce692 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Tue, 9 Jan 2018 00:43:43 +0100 Subject: Implement design for pages and update includes --- html/assets/main.js | 5 + html/includes/clanbase.php | 0 html/includes/config.php | 6 +- html/includes/config_pic.php | 0 html/includes/countries.php | 0 html/includes/ftp.php | 2 +- html/includes/ftp_class.php | 0 html/includes/ftp_class_native.php | 0 html/includes/ftp_class_pure.php | 0 html/includes/ftp_class_sockets.php | 0 html/includes/geoip.inc | 0 html/includes/hints.php | 6 +- html/includes/teamstats.php | 338 ++++++++-------- html/includes/weaponstats.php | 48 +-- html/pages/admin/acelog.php | 4 +- html/pages/admin/aclog.php | 228 ++++++----- html/pages/admin/dmatch.php | 4 +- html/pages/admin/dplayer.php | 2 +- html/pages/admin/dpmatch.php | 2 +- html/pages/admin/editgames.php | 2 +- html/pages/admin/editgamestype.php | 6 +- html/pages/admin/editweapons.php | 2 +- html/pages/admin/ipsearch.php | 2 +- html/pages/admin/main.php | 51 ++- html/pages/admin/mplayers.php | 2 +- html/pages/admin/mservers.php | 2 +- html/pages/admin/pban.php | 4 +- html/pages/admin/pinfo.php | 4 +- html/pages/admin/plm.php | 34 +- html/pages/admin/recalcflags.php | 2 +- html/pages/admin/recalcranking.php | 2 +- html/pages/admin/utdclog.php | 4 +- html/pages/admin/utdcshot.php | 0 html/pages/credits.php | 661 ++++++++++++++++--------------- html/pages/dpmatch.php | 2 +- html/pages/graph_mbreakdown.php | 247 ++++++------ html/pages/graph_pbreakdown.php | 2 +- html/pages/help.php | 477 +++++++++++++--------- html/pages/home.php | 266 ++++++++++--- html/pages/maps.php | 42 +- html/pages/maps_info.php | 507 ++++++++++++------------ html/pages/match_info.php | 115 +++--- html/pages/match_info_ass.php | 8 +- html/pages/match_info_bt.php | 2 +- html/pages/match_info_ctf.php | 634 +++++++++++++++--------------- html/pages/match_info_killsmatrix.php | 58 +-- html/pages/match_info_lms.php | 27 +- html/pages/match_info_other.php | 206 +++++----- html/pages/match_info_other2.php | 40 +- html/pages/match_player.php | 165 ++++---- html/pages/match_report.php | 9 +- html/pages/players_explain_ranking.php | 66 ++-- html/pages/players_info.php | 694 ++++++++++++++++++--------------- html/pages/players_search.php | 46 ++- html/pages/rank_extended.php | 26 +- html/pages/report.php | 0 html/pages/report/bbcode.php | 0 html/pages/report/clanbase.php | 0 html/pages/report/index.htm | 0 html/pages/report_cb.php | 6 +- html/pages/servers.php | 18 +- html/pages/servers_info.php | 208 +++++----- html/pages/servers_query.php | 6 +- html/pages/totals.php | 565 +++++++++++++-------------- 64 files changed, 3118 insertions(+), 2747 deletions(-) mode change 100755 => 100644 html/includes/clanbase.php mode change 100755 => 100644 html/includes/config_pic.php mode change 100755 => 100644 html/includes/countries.php mode change 100755 => 100644 html/includes/ftp.php mode change 100755 => 100644 html/includes/ftp_class.php mode change 100755 => 100644 html/includes/ftp_class_native.php mode change 100755 => 100644 html/includes/ftp_class_pure.php mode change 100755 => 100644 html/includes/ftp_class_sockets.php mode change 100755 => 100644 html/includes/geoip.inc mode change 100755 => 100644 html/includes/hints.php mode change 100755 => 100644 html/includes/weaponstats.php mode change 100755 => 100644 html/pages/admin/acelog.php mode change 100755 => 100644 html/pages/admin/aclog.php mode change 100755 => 100644 html/pages/admin/dmatch.php mode change 100755 => 100644 html/pages/admin/dplayer.php mode change 100755 => 100644 html/pages/admin/dpmatch.php mode change 100755 => 100644 html/pages/admin/editgames.php mode change 100755 => 100644 html/pages/admin/editgamestype.php mode change 100755 => 100644 html/pages/admin/editweapons.php mode change 100755 => 100644 html/pages/admin/ipsearch.php mode change 100755 => 100644 html/pages/admin/main.php mode change 100755 => 100644 html/pages/admin/mplayers.php mode change 100755 => 100644 html/pages/admin/mservers.php mode change 100755 => 100644 html/pages/admin/pban.php mode change 100755 => 100644 html/pages/admin/pinfo.php mode change 100755 => 100644 html/pages/admin/plm.php mode change 100755 => 100644 html/pages/admin/recalcflags.php mode change 100755 => 100644 html/pages/admin/recalcranking.php mode change 100755 => 100644 html/pages/admin/utdclog.php mode change 100755 => 100644 html/pages/admin/utdcshot.php mode change 100755 => 100644 html/pages/dpmatch.php mode change 100755 => 100644 html/pages/graph_pbreakdown.php mode change 100755 => 100644 html/pages/maps.php mode change 100755 => 100644 html/pages/maps_info.php mode change 100755 => 100644 html/pages/match_info_ass.php mode change 100755 => 100644 html/pages/match_info_bt.php mode change 100755 => 100644 html/pages/match_info_ctf.php mode change 100755 => 100644 html/pages/match_info_killsmatrix.php mode change 100755 => 100644 html/pages/match_info_lms.php mode change 100755 => 100644 html/pages/match_info_other2.php mode change 100755 => 100644 html/pages/match_report.php mode change 100755 => 100644 html/pages/players_explain_ranking.php mode change 100755 => 100644 html/pages/players_search.php mode change 100755 => 100644 html/pages/rank_extended.php mode change 100755 => 100644 html/pages/report.php mode change 100755 => 100644 html/pages/report/bbcode.php mode change 100755 => 100644 html/pages/report/clanbase.php mode change 100755 => 100644 html/pages/report/index.htm mode change 100755 => 100644 html/pages/report_cb.php mode change 100755 => 100644 html/pages/servers.php mode change 100755 => 100644 html/pages/servers_info.php mode change 100755 => 100644 html/pages/servers_query.php diff --git a/html/assets/main.js b/html/assets/main.js index b1e9b9e..5863530 100644 --- a/html/assets/main.js +++ b/html/assets/main.js @@ -8,4 +8,9 @@ $(document).ready(function() { window.document.location = $(this).attr("href"); } }); + + // Credits changelog toggle + $(".changeLog").click(function() { + $("#contentChangeLog").slideToggle(300); + }); }); diff --git a/html/includes/clanbase.php b/html/includes/clanbase.php old mode 100755 new mode 100644 diff --git a/html/includes/config.php b/html/includes/config.php index 55b9ffe..77d42fa 100755 --- a/html/includes/config.php +++ b/html/includes/config.php @@ -1,9 +1,9 @@ '; + if ($html) echo' - - - '; - - $sql_players = "SELECT pi.name, pi.banned, p.pid, p.team, p.country, p.gametime, p.gamescore, p.frags, p.deaths, p.suicides, p.teamkills, p.eff, p.accuracy, p.ttl, p.rank".(($extra) ? ', p.'.$extra.' AS '.$extra : '')." - FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid - ORDER BY".(($teams) ? ' team ASC,' : '')." $order"; - $q_players = mysql_query($sql_players) or die(mysql_error()); - $header = true; - teamstats_init_totals($totals, $num); - - while ($r_players = zero_out(mysql_fetch_array($q_players))) { - $r_players['dom_cp'] = $r_players['gamescore'] - $r_players['frags']; - $r_players['team'] = intval($r_players['team']); - - if ($teams and $oldteam != $r_players['team']) { - if ($r_players['team'] != 0) teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]); - $oldteam = $r_players['team']; - teamstats_init_totals($totals, $num, $extra); - - switch(intval($r_players['team'])) { - case 0: $teamname = 'Red'; break; - case 1: $teamname = 'Blue'; break; - case 2: $teamname = 'Green'; break; - case 3: $teamname = 'Gold'; break; - } - - echo''; - $header = true; - } - - if ($header) { - $header = false; - echo ' - - - - '; - if ($extra) echo ''; - echo' - - - - '; - if ($teams) echo ''; - echo ' - - - - '; - } - - $eff = get_dp($r_players['eff']); - $acc = get_dp($r_players['accuracy']); - $ttl = GetMinutes($r_players['ttl']); - $kills = $r_players['frags'] + $r_players['suicides']; - $pname = $r_players['name']; - - $totals['gamescore'] += $r_players['gamescore']; - if ($extra) $totals[$extra] += $r_players[$extra]; - $totals['frags'] += $r_players['frags']; - $totals['kills'] += $kills; - $totals['deaths'] += $r_players['deaths']; - $totals['suicides'] += $r_players['suicides']; - $totals['teamkills'] += $r_players['teamkills']; - $totals['eff'] += $r_players['eff']; - $totals['acc'] += $r_players['accuracy']; - $totals['ttl'] += $r_players['ttl']; - $num++; - - if ($r_players['banned'] == 'Y') { - $eff = '-'; - $acc = '-'; - $ttl = '-'; - $kills = '-'; - $r_players['gamescore'] = '-'; - $r_players[$extra] = '-'; - $r_players['frags'] = '-'; - $r_players['deaths'] = '-'; - $r_players['suicides'] = '-'; - $r_players['teamkills'] = '-'; - } - - $class = ($num % 2) ? 'grey' : 'grey2'; - echo ''; - - if ($r_players['banned'] != 'Y') { - echo ''; - } else { - echo ''; - } - - echo ''; - echo ''; - - if ($extra) echo ''; - - echo ''; - echo ''; - echo ''; - echo ''; - - if ($teams) echo ''; - - echo ''; - echo ''; - echo ''; - echo ''; - } - - teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]); - - echo '
'; echo "FTP Transferring Log Files...\n"; diff --git a/html/includes/ftp_class.php b/html/includes/ftp_class.php old mode 100755 new mode 100644 diff --git a/html/includes/ftp_class_native.php b/html/includes/ftp_class_native.php old mode 100755 new mode 100644 diff --git a/html/includes/ftp_class_pure.php b/html/includes/ftp_class_pure.php old mode 100755 new mode 100644 diff --git a/html/includes/ftp_class_sockets.php b/html/includes/ftp_class_sockets.php old mode 100755 new mode 100644 diff --git a/html/includes/geoip.inc b/html/includes/geoip.inc old mode 100755 new mode 100644 diff --git a/html/includes/hints.php b/html/includes/hints.php old mode 100755 new mode 100644 index b8da8de..7ba11a3 --- a/html/includes/hints.php +++ b/html/includes/hints.php @@ -24,10 +24,8 @@ $hint['Multis'] = "text" => "Special event: If you manage to kill more 2 than people within a short space of time you get a Double Kill, 3 is a Multi Kill etc" ); -$hint['Sprees'] = - array ( "caption" => "Killing Sprees", - "text" => "Special event: If you manage to kill 5 or more opponents without dying yourself, you will be on a killing spree. If you kill more than 10 opponents, you are on a rampage, etc." - ); +$hint['Sprees'] = "Special event: If you manage to kill 5 or more opponents without dying yourself, you will be on a killing spree. If you kill more than 10 opponents, you are on a rampage, etc." + ; $hint['EFF'] = array ( "caption" => "Efficiency", "text" => "A ratio that denotes the player's kill skill by comparing it with his overall performance. A perfect efficiency is equal to 1 (100%), anything less than 0.5 (50%) is below average.
Formula: Kills / (Kills + Deaths + Suicides [+Team Kills])" diff --git a/html/includes/teamstats.php b/html/includes/teamstats.php index b2116b9..d0b1b58 100755 --- a/html/includes/teamstats.php +++ b/html/includes/teamstats.php @@ -1,182 +1,176 @@ -
'.htmlentities($title).'
Team: '.$teamname.'
PlayerTimeScore'.htmlentities($extratitle).'FKDSTKEff.Acc.Avg TTL
'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).''.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).''.GetMinutes($r_players['gametime'] / TIMERATIO).''.$r_players['gamescore'].''.$r_players[$extra].''.$r_players['frags'].''.$kills.''.$r_players['deaths'].''.$r_players['suicides'].''.$r_players['teamkills'].''.$eff.''.$acc.''.$ttl.'

'; + global $gamename, $gid; + $r_info = small_query("SELECT teamgame, t0score, t1score, t2score, t3score FROM uts_match WHERE id = '$mid'"); + if (!$r_info) die("Match not found"); + + $teams = ($r_info['teamgame'] == 'True') ? true : false; + $teamscore[-1] = 0; + $teamscore[0] = $r_info['t0score']; + $teamscore[1] = $r_info['t1score']; + $teamscore[2] = $r_info['t2score']; + $teamscore[3] = $r_info['t3score']; + + $cols = 10; + if ($teams) $cols++; + if ($extra) $cols++; + + $oldteam = -1; + + echo' + + + + '; + + $sql_players = "SELECT pi.name, pi.banned, p.pid, p.team, p.country, p.gametime, p.gamescore, p.frags, p.deaths, p.suicides, p.teamkills, p.eff, p.accuracy, p.ttl, p.rank".(($extra) ? ', p.'.$extra.' AS '.$extra : '')." + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid + ORDER BY".(($teams) ? ' team ASC,' : '')." $order"; + $q_players = mysql_query($sql_players) or die(mysql_error()); + $header = true; + teamstats_init_totals($totals, $num); + + while ($r_players = zero_out(mysql_fetch_array($q_players))) { + $r_players['dom_cp'] = $r_players['gamescore'] - $r_players['frags']; + $r_players['team'] = intval($r_players['team']); + + if ($teams and $oldteam != $r_players['team']) { + if ($r_players['team'] != 0) teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]); + $oldteam = $r_players['team']; + teamstats_init_totals($totals, $num, $extra); + + switch(intval($r_players['team'])) { + case 0: $teamname = 'Red'; break; + case 1: $teamname = 'Blue'; break; + case 2: $teamname = 'Green'; break; + case 3: $teamname = 'Gold'; break; + } + + echo''; + $header = true; + } + if ($header) { + $header = false; + echo ' + + + + '; + if ($extra) echo ''; + echo ' + + + + '; + if ($teams) echo ''; + echo ' + + + + '; + } + + $eff = get_dp($r_players['eff']); + $acc = get_dp($r_players['accuracy']); + $ttl = GetMinutes($r_players['ttl']); + $kills = $r_players['frags'] + $r_players['suicides']; + $pname = $r_players['name']; + + $totals['gamescore'] += $r_players['gamescore']; + if ($extra) $totals[$extra] += $r_players[$extra]; + $totals['frags'] += $r_players['frags']; + $totals['kills'] += $kills; + $totals['deaths'] += $r_players['deaths']; + $totals['suicides'] += $r_players['suicides']; + $totals['teamkills'] += $r_players['teamkills']; + $totals['eff'] += $r_players['eff']; + $totals['acc'] += $r_players['accuracy']; + $totals['ttl'] += $r_players['ttl']; + $num++; + + if ($r_players['banned'] == 'Y') { + $eff = '-'; + $acc = '-'; + $ttl = '-'; + $kills = '-'; + $r_players['gamescore'] = '-'; + $r_players[$extra] = '-'; + $r_players['frags'] = '-'; + $r_players['deaths'] = '-'; + $r_players['suicides'] = '-'; + $r_players['teamkills'] = '-'; + } + + $class = ($num % 2) ? 'grey' : 'grey2'; + echo ''; + if ($r_players['banned'] != 'Y') { + echo ''; + } else { + echo ''; + } + echo ''; + echo ''; + + if ($extra) echo ''; + + echo ''; + echo ''; + echo ''; + echo ''; + + if ($teams) echo ''; + + echo ''; + echo ''; + echo ''; + echo ''; + } + + teamstats_team_totals($totals, $num, $teams, $extra, $teamscore[$oldteam]); + echo '
'.htmlentities($title).'
Team: '.$teamname.'
PlayerTimeScore'.htmlentities($extratitle).'FKDSTKEff.Acc.Avg TTL
'.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).''.FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name'], $gid, $gamename, true, $r_players['rank']).''.GetMinutes($r_players['gametime'] / TIMERATIO).''.$r_players['gamescore'].''.$r_players[$extra].''.$r_players['frags'].''.$kills.''.$r_players['deaths'].''.$r_players['suicides'].''.$r_players['teamkills'].''.$eff.''.$acc.''.$ttl.'

'; } function teamstats_init_totals(&$totals, &$num, $extra = null) { - $totals['gamescore'] = 0; - if ($extra) $totals[$extra] = 0; - $totals['frags'] = 0; - $totals['kills'] = 0; - $totals['deaths'] = 0; - $totals['suicides'] = 0; - $totals['teamkills'] = 0; - $totals['eff'] = 0; - $totals['acc'] = 0; - $totals['ttl'] = 0; - $num = 0; + $totals['gamescore'] = 0; + if ($extra) $totals[$extra] = 0; + $totals['frags'] = 0; + $totals['kills'] = 0; + $totals['deaths'] = 0; + $totals['suicides'] = 0; + $totals['teamkills'] = 0; + $totals['eff'] = 0; + $totals['acc'] = 0; + $totals['ttl'] = 0; + $num = 0; } function teamstats_team_totals(&$totals, $num, $teams, $extra, $teamscore) { - if ($num == 0) $num = 1; - $eff = get_dp($totals['eff'] / $num); - $acc = get_dp($totals['acc'] / $num); - $ttl = GetMinutes($totals['ttl'] / $num); - - echo ''; - echo 'Totals'; - echo ''; - - if ($teams) { - echo ''.$teamscore.' ('.$totals[gamescore].')'; - } else { - echo ''.$totals[gamescore].''; - } - if ($extra) echo ''.$totals[$extra].''; - - echo ''.$totals[frags].''; - echo ''.$totals[kills].''; - echo ''.$totals[deaths].''; - echo ''.$totals[suicides].''; - - if ($teams) echo ''.$totals[teamkills].''; - - echo ''.$eff.''; - echo ''.$acc.''; - echo ''.$ttl.''; - echo ''; + if ($num == 0) $num = 1; + $eff = get_dp($totals['eff'] / $num); + $acc = get_dp($totals['acc'] / $num); + $ttl = GetMinutes($totals['ttl'] / $num); + + echo ''; + echo 'Totals'; + echo ''; + if ($teams) { + echo ''.$teamscore.' ('.$totals[gamescore].')'; + } else { + echo ''.$totals[gamescore].''; + } + if ($extra) echo ''.$totals[$extra].''; + + echo ''.$totals[frags].''; + echo ''.$totals[kills].''; + echo ''.$totals[deaths].''; + echo ''.$totals[suicides].''; + + if ($teams) echo ''.$totals[teamkills].''; + + echo ''.$eff.''; + echo ''.$acc.''; + echo ''.$ttl.''; + echo ''; } - ?> diff --git a/html/includes/weaponstats.php b/html/includes/weaponstats.php old mode 100755 new mode 100644 index 872fa5a..bccdd6d --- a/html/includes/weaponstats.php +++ b/html/includes/weaponstats.php @@ -26,7 +26,6 @@ function weaponstats($_mid, $_pid, $title = 'Weapons Summary') { AND (wn.id = w.weapon) AND wn.hide <> 'Y'"; - if ($_pid == 0 and $_mid != 0) { $sql_weapons = "SELECT w.matchid, w.pid AS playerid, @@ -99,15 +98,15 @@ uts_weaponstats AS w } echo' - - - - - '; - +
'.htmlentities($title).'
+ + + + '; if ($one) { ws_header($wsort, $weapons, $colspan, $one, $playercol); + echo ''; foreach($wsort as $wid => $bar) { for ($i = 1; $i <= $colspan; $i++) { @@ -119,8 +118,7 @@ uts_weaponstats AS w case 5: $extra = 'Dmg'; break; } $extra = ''. $extra .''; - echo ' - '; + echo ''; } } echo ''; @@ -128,10 +126,10 @@ uts_weaponstats AS w $i = 0; foreach($psort as $pid => $foo) { $i++; - echo ''; + echo ''; if ($playercol) { echo ' - '; + '; } foreach($wsort as $wid => $bar) { ws_cell($wd, $pid, $wid, 'kills', $i); @@ -146,23 +144,22 @@ uts_weaponstats AS w if (!$one) { ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Kills', 'kills'); - ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Shots', 'shots'); - ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Hits', 'hits'); + //ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Shots', 'shots'); + //ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Hits', 'hits'); ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Damage', 'damage'); ws_block($wd, $weapons, $wsort, $psort, $colspan, $playercol, $one, $_mid, $gamename, 'Accuracy', 'acc'); } - echo '
'.htmlentities($title).'
'.$extra.''.$extra.'
'.FormatPlayerName($wd[$pid]['country'], $pid, $wd[$pid]['playername'], $gid, $gamename).''.FormatPlayerName($wd[$pid]['country'], $pid, $wd[$pid]['playername'], $gid, $gamename).'
'; } function ws_header(&$wsort, &$weapons, $colspan, $one, $playercol) { echo ''; - if ($playercol and $playercol != -1) echo 'Player'; - if ($playercol == -1) echo ' '; + if ($playercol and $playercol != -1) echo ''; + if ($playercol == -1) echo ' '; foreach($wsort as $wid => $bar) { if (!empty($weapons[$wid]['image'])) { - $content = ''.$weapons[$wid]['name'].''; + $content = ''.$weapons[$wid]['name'].''; } else { $content = ''.$weapons[$wid]['name'].''; } @@ -172,27 +169,23 @@ function ws_header(&$wsort, &$weapons, $colspan, $one, $playercol) { echo ''; } - function ws_cell(&$wd, $pid, $wid, $field, $i) { $content = ''; if (isset($wd[$pid][$wid][$field])) $content = $wd[$pid][$wid][$field]; $class = ($i % 2) ? 'grey' : 'grey2'; echo ' - '.$content.''; + '.$content.''; } - - - function ws_block(&$wd, &$weapons, &$wsort, &$psort, &$colspan, $playercol, $one,$_mid, $gamename, $caption, $field) { global $gamename, $gid; if (count($psort) != 1) { echo ' - + - '.$caption.' + '.$caption.' '; ws_header($wsort, $weapons, $colspan, $one, $playercol); } @@ -204,8 +197,8 @@ function ws_block(&$wd, &$weapons, &$wsort, &$psort, &$colspan, $playercol, $one $i = 0; foreach($psort as $pid => $foo) { $i++; - echo ''; - if ($playercol and $playercol != -1) echo ''.FormatPlayerName($wd[$pid]['country'], $pid, $wd[$pid]['playername'], $gid, $gamename).''; + echo ''; + if ($playercol and $playercol != -1) echo ''.FormatPlayerName($wd[$pid]['country'], $pid, $wd[$pid]['playername'], $gid, $gamename).''; if ($playercol == -1) echo ''.$caption.''; foreach($wsort as $wid => $bar) { ws_cell($wd, $pid, $wid, $field, $i); @@ -213,4 +206,5 @@ function ws_block(&$wd, &$weapons, &$wsort, &$psort, &$colspan, $playercol, $one echo ''; } } -?> \ No newline at end of file + +?> diff --git a/html/pages/admin/acelog.php b/html/pages/admin/acelog.php old mode 100755 new mode 100644 index 365174a..a9c80c0 --- a/html/pages/admin/acelog.php +++ b/html/pages/admin/acelog.php @@ -90,7 +90,7 @@ if (empty($filename)) { }
- +
@@ -252,7 +252,7 @@ if (empty($filename)) { if (!empty($filename)) { if (!file_exists('logs/ace/'. $filename) or !is_file('logs/ace/'. $filename)) die('File not found (2)'); - echo'
Available ACE Logs:
+ echo'
- - - - - - - - - - - '; -// Show some gametype specific stuff -if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { - // Bunny Track - $record = small_query("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 0,1"); - if (!empty($record['time'])) { + // Map pic code + $mappic = getMapImageName($map); + + echo' +
'.$filename.' '; diff --git a/html/pages/admin/aclog.php b/html/pages/admin/aclog.php old mode 100755 new mode 100644 index ada35c8..2d78b77 --- a/html/pages/admin/aclog.php +++ b/html/pages/admin/aclog.php @@ -1,108 +1,120 @@ - - - - '; - $logdir = opendir('logs/ac'); - $logs = array(); - $sort = array(); - $i = 0; - while (false !== ($filename = readdir($logdir))) { - if (!is_file('logs/ac/'. $filename)) continue; - if ($filename == '.htaccess' or $filename == 'index.htm') continue; - $i++; - $logs[$i] = $filename; - $extra = 0; - if (substr($filename, -4) == '.bz2') $extra = 4; - if (substr($filename, -3) == '.gz') $extra = 3; - - $sort[$i] = substr($filename, strlen($filename) - (23 + $extra), 19); - } - closedir($logdir); - if (count($logs) == 0) { - echo ''; - } else { - arsort($sort); - $i = 0; - foreach($sort as $id => $date) { - $log = $logs[$id]; - $extra = 0; - if (substr($log, -4) == '.bz2') $extra = 4; - if (substr($log, -3) == '.gz') $extra = 3; - - $i++; - $class = ($i%2) ? 'grey' : 'grey2'; - echo ''; - } - } -} - - -if (!empty($filename)) { - if (!file_exists('logs/ac/'. $filename) or !is_file('logs/ac/'. $filename)) die('bla'); - echo'
Available AnthChecker Logs:
No logs available!
'; - $tmp = substr($log, strlen($log) - (23 + $extra), 19); - $tmp = str_replace('.', '', $tmp); - $ts = mtimestamp($tmp); - echo ' '.date('Y-m-d H:i', $ts).''; - echo ''; - echo ''.substr($log, 6, strlen($log) - 30 - $extra).''; - echo ''; - $d_size = file_size_info(filesize('logs/ac/'. $log)); - echo $d_size['size'] .' '. $d_size['type']; - echo ''; - echo 'Delete'; - echo '
- - - - '; - - $fp = my_fopen('logs/ac/'.$filename, 'rb', $compression = NULL); - if (!$fp) die("Error opening file"); - - $i = 0; - echo ''; - */ - echo wordwrap(htmlentities($line), 80, '
', 1) ."
"; - } - echo ''; - my_fclose($fp, $compression); -} - -echo ''; -if (!empty($filename)) echo''; -echo''; -echo '
'.$filename.''; - echo 'Delete'; - echo '
'; - - while (($line = my_fgets($fp, 5000, $compression)) !== FALSE) { - /* - $i++; - $class = ($i%2) ? 'grey' : 'grey2'; - echo '
'; - echo ''; - echo htmlentities($line); - echo ''; - echo '
Go Back To Logfile Overview
Go Back To Admin Page
'; - -?> + + + + '; + + $logdir = opendir('logs/ac'); + $logs = array(); + $sort = array(); + $i = 0; + + while (false !== ($filename = readdir($logdir))) { + if (!is_file('logs/ac/'. $filename)) continue; + if ($filename == '.htaccess' or $filename == 'index.htm') continue; + + $i++; + $logs[$i] = $filename; + $extra = 0; + + if (substr($filename, -4) == '.bz2') $extra = 4; + if (substr($filename, -3) == '.gz') $extra = 3; + + $sort[$i] = substr($filename, strlen($filename) - (23 + $extra), 19); + } + + closedir($logdir); + + if (count($logs) == 0) { + echo ''; + } else { + arsort($sort); + $i = 0; + + foreach($sort as $id => $date) { + $log = $logs[$id]; + $extra = 0; + + if (substr($log, -4) == '.bz2') $extra = 4; + if (substr($log, -3) == '.gz') $extra = 3; + + $i++; + $class = ($i%2) ? 'grey' : 'grey2'; + echo ''; + } + } +} + +if (!empty($filename)) { + if (!file_exists('logs/ac/'. $filename) or !is_file('logs/ac/'. $filename)) die('bla'); + + echo'
Available AnthChecker Logs:
No logs available!
'; + $tmp = substr($log, strlen($log) - (23 + $extra), 19); + $tmp = str_replace('.', '', $tmp); + $ts = mtimestamp($tmp); + + echo ''.date('Y-m-d H:i', $ts).''; + echo ''; + echo ''.substr($log, 6, strlen($log) - 30 - $extra).''; + echo ''; + + $d_size = file_size_info(filesize('logs/ac/'. $log)); + + echo $d_size['size'] .' '. $d_size['type']; + echo ''; + echo 'Delete'; + echo '
+ + + + '; + + $fp = my_fopen('logs/ac/'.$filename, 'rb', $compression = NULL); + if (!$fp) die("Error opening file"); + $i = 0; + echo ''; + */ + + echo wordwrap(htmlentities($line), 80, '
', 1) ."
"; + } + + echo ''; + my_fclose($fp, $compression); +} + +echo ''; + +if (!empty($filename)) echo''; + +echo''; +echo '
'.$filename.''; + echo 'Delete'; + echo '
'; + + while (($line = my_fgets($fp, 5000, $compression)) !== FALSE) { + /* + $i++; + $class = ($i%2) ? 'grey' : 'grey2'; + echo '
'; + echo ''; + echo htmlentities($line); + echo ''; + echo '
Go Back To Logfile Overview
Go Back To Admin Page
'; + +?> diff --git a/html/pages/admin/dmatch.php b/html/pages/admin/dmatch.php old mode 100755 new mode 100644 index 9fed97d..3c7ebc5 --- a/html/pages/admin/dmatch.php +++ b/html/pages/admin/dmatch.php @@ -20,7 +20,7 @@ $results = adminselect($options); $matchid = $results['mid']; -echo'
+echo'
@@ -47,7 +47,7 @@ while ($r_radjust = mysql_fetch_array($q_radjust)) { mysql_query("UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysql_error()); mysql_query("DELETE FROM uts_rank WHERE matches = 0") or die(mysql_error()); } - echo' + echo''; diff --git a/html/pages/admin/dplayer.php b/html/pages/admin/dplayer.php old mode 100755 new mode 100644 index 0239e5d..ca3e747 --- a/html/pages/admin/dplayer.php +++ b/html/pages/admin/dplayer.php @@ -15,7 +15,7 @@ $results = adminselect($options); $pid = $results['pid']; $playerid = $pid; -echo'
Deleting Match ID '.$matchid.'
DoneDone
Removing Match Record:
+echo'
diff --git a/html/pages/admin/dpmatch.php b/html/pages/admin/dpmatch.php old mode 100755 new mode 100644 index b021054..ff4258e --- a/html/pages/admin/dpmatch.php +++ b/html/pages/admin/dpmatch.php @@ -21,7 +21,7 @@ $results = adminselect($options); $matchid = $results['mid']; $pid = $results['pid']; -echo'
Deleting Player
+echo'
'; diff --git a/html/pages/admin/editgames.php b/html/pages/admin/editgames.php old mode 100755 new mode 100644 index 3f7a542..d2981b8 --- a/html/pages/admin/editgames.php +++ b/html/pages/admin/editgames.php @@ -16,7 +16,7 @@ if (isset($_REQUEST['submit'])) { } } -echo'
Delete Player From Match ID '.$matchid.'
+echo'
diff --git a/html/pages/admin/editgamestype.php b/html/pages/admin/editgamestype.php old mode 100755 new mode 100644 index d9e4ff1..26bff62 --- a/html/pages/admin/editgamestype.php +++ b/html/pages/admin/editgamestype.php @@ -29,7 +29,7 @@ if (isset($_REQUEST['submit'])) { ") or die(mysql_error()); if (isset($_REQUEST['update'])) { - echo'
Edit games
+ echo'
@@ -102,7 +102,7 @@ if (isset($_REQUEST['del'])) { -echo'
Updating...
+echo'
@@ -153,7 +153,7 @@ echo '
Current Mappings
'; -echo'
+echo'
diff --git a/html/pages/admin/editweapons.php b/html/pages/admin/editweapons.php old mode 100755 new mode 100644 index 2baeab9..dec6b64 --- a/html/pages/admin/editweapons.php +++ b/html/pages/admin/editweapons.php @@ -11,7 +11,7 @@ if (isset($_REQUEST['submit'])) { } } -echo'
Add new gamestype
+echo'
diff --git a/html/pages/admin/ipsearch.php b/html/pages/admin/ipsearch.php old mode 100755 new mode 100644 index 4ac9731..fcfe17f --- a/html/pages/admin/ipsearch.php +++ b/html/pages/admin/ipsearch.php @@ -22,7 +22,7 @@ $results = adminselect($options); $ip_from = $results['ip_from']; $ip_to = $results['ip_to']; -echo'
Edit weapons
+echo'
'; diff --git a/html/pages/admin/main.php b/html/pages/admin/main.php old mode 100755 new mode 100644 index 4d60302..e2c191e --- a/html/pages/admin/main.php +++ b/html/pages/admin/main.php @@ -17,7 +17,7 @@ function nf($number) { } -echo'
Players using IPs '.$ip_from.' - '.$ip_to.' and their last 5 matches using these IPs
+echo'
'; @@ -71,47 +71,46 @@ echo'
Database Statistics

'; -echo' -
'; +echo' + +
'; -echo ' - '; -echo'
'; +echo'
'; ?> diff --git a/html/pages/admin/mplayers.php b/html/pages/admin/mplayers.php old mode 100755 new mode 100644 index 3754d99..c9b58a3 --- a/html/pages/admin/mplayers.php +++ b/html/pages/admin/mplayers.php @@ -26,7 +26,7 @@ $mplayer2 = $results['mplayer2']; $mp1name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer1"); $mp2name = small_query("SELECT name FROM uts_pinfo WHERE id = $mplayer2"); -echo'
+echo'
diff --git a/html/pages/admin/mservers.php b/html/pages/admin/mservers.php old mode 100755 new mode 100644 index b52a9d1..9e0bf6a --- a/html/pages/admin/mservers.php +++ b/html/pages/admin/mservers.php @@ -24,7 +24,7 @@ $mserver2 = $results[mserver2]; $q_myserver1 = small_query("SELECT servername, serverip FROM uts_match WHERE id = $mserver1"); $q_myserver2 = small_query("SELECT servername, serverip FROM uts_match WHERE id = $mserver2"); -echo'
Merging '.$mp2name[name].' Into '.$mp1name[name].'
+echo'
diff --git a/html/pages/admin/pban.php b/html/pages/admin/pban.php old mode 100755 new mode 100644 index f421ef5..88aa6a4 --- a/html/pages/admin/pban.php +++ b/html/pages/admin/pban.php @@ -26,7 +26,7 @@ $results = adminselect($options); $pid = $results['pid']; if ($ban) { - echo'
Merging '.$q_myserver2[servername].' ('.$q_myserver2[serverip].')
Into '.$q_myserver1[servername].' ('.$q_myserver1[serverip].')
+ echo'
@@ -45,7 +45,7 @@ if ($ban) {
Banning Player
Player Banned - Go Back To Admin Page
'; } else { - echo' + echo'
diff --git a/html/pages/admin/pinfo.php b/html/pages/admin/pinfo.php old mode 100755 new mode 100644 index 7be13ae..3ae57f7 --- a/html/pages/admin/pinfo.php +++ b/html/pages/admin/pinfo.php @@ -25,7 +25,7 @@ echo '
'; $sql_ips = "SELECT INET_NTOA(p.ip) AS ip, COUNT(p.id) AS matches, MIN(m.time) AS first, MAX(m.time) AS last FROM uts_player AS p, uts_match AS m WHERE p.pid = ".$pid." AND m.id = p.matchid GROUP BY ip ORDER BY ip"; $q_ips = mysql_query($sql_ips) or die("Can't get ip's: " . mysql_error()); echo ' -
Unbanning Player
+
@@ -60,7 +60,7 @@ mysql_free_result($q_ips); $sql_fakes = "SELECT INET_NTOA(p1.ip) AS ip, pi.name FROM uts_player AS p1, uts_player AS p2, uts_pinfo AS pi WHERE p1.pid = ".$pid." AND p1.ip = p2.ip AND p1.pid <> p2.pid AND pi.id = p2.pid GROUP BY pi.name"; $q_fakes = mysql_query($sql_fakes) or die("Can't retrieve fake nicks: " . mysql_error()); echo ' -
IP\'s used
+
diff --git a/html/pages/admin/plm.php b/html/pages/admin/plm.php old mode 100755 new mode 100644 index 68992e2..1ea9f52 --- a/html/pages/admin/plm.php +++ b/html/pages/admin/plm.php @@ -43,13 +43,13 @@ if($debug) { } // Print header & links -echo '

Player merging tool

'; +echo '

Player merging tool

'; echo "

Merge ip's - Merge ip's, limited on range - Manage ignored ip's - Manage ignored ip's - only range

"; // CASE: MANAGE IGNORED IPS if($_GET['manignore'] == "true") { if($_POST['submit'] == "Remove from ignored list") { - echo "

Stopped ignore ip's

"; + echo "

Stopped ignore ip's

"; foreach($_POST as $key=>$value) { if($key !='submit') { $key = mysql_real_escape_string(str_replace("_",".",$key)); @@ -60,7 +60,7 @@ if($_GET['manignore'] == "true") { } } else if($_GET['onlyrange'] == "true") { if($_POST['submit'] == "Confirm") { - echo '

Ignored ip\'s in range '.htmlentities($_POST['from']).' to '.htmlentities($_POST['to']).'
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; + echo '

Ignored ip\'s in range '.htmlentities($_POST['from']).' to '.htmlentities($_POST['to']).'
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; echo ''; $from = mysql_real_escape_string($_POST['from']); @@ -75,7 +75,7 @@ if($_GET['manignore'] == "true") { $trueplayerip = long2ip($playerip); $pidcount = $r_pipcheck[pidcount]; - echo "
$trueplayerip"; + echo "
$trueplayerip"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; @@ -90,13 +90,13 @@ if($_GET['manignore'] == "true") { echo "

No ignored ip's found

"; } } else { - echo "

Ignored ip's in range: Enter range to filter on

"; + echo "

Ignored ip's in range: Enter range to filter on

"; echo ''; echo '
Ranging from to '; echo '

'; } } else { - echo '

Ignored ip\'s
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; + echo '

Ignored ip\'s
If you want to stop ignoring some ip\'s, because for example you accidently ignored these, check these and press the button at the lower end to confirm this

'; echo ''; $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips ORDER BY ip ASC"); @@ -107,7 +107,7 @@ if($_GET['manignore'] == "true") { $trueplayerip = long2ip($playerip); $pidcount = $r_pipcheck[pidcount]; - echo "
$trueplayerip"; + echo "
$trueplayerip"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; @@ -125,7 +125,7 @@ if($_GET['manignore'] == "true") { // CASE: IGNORE SUBMITTED IP'S } else if($_POST['submit'] == "ignore") { - echo "

Ignored ips

"; + echo "

Ignored ips

"; foreach($_POST as $key=>$value) { if($key !='submit') { $key = mysql_real_escape_string(str_replace("_",".",$key)); @@ -138,7 +138,7 @@ if($_GET['manignore'] == "true") { // CASE: SHOW NICKS WITH GIVEN SHARED IP } else if(substr($_POST['submit'],0,8) == "merge - ") { - echo "

Merge nicks with shared ip

"; + echo "

Merge nicks with shared ip

"; $ip = mysql_real_escape_string(str_replace("_",".",substr($_POST['submit'],8))); $sql_pipcheck = "SELECT ip, COUNT(DISTINCT pid) AS pidcount FROM uts_player WHERE ip = INET_ATON('$ip') GROUP BY ip ORDER BY ip ASC"; @@ -152,7 +152,7 @@ if($_GET['manignore'] == "true") { // If there is more than one pid associated to an IP ... IF ($pidcount > 1 ) { echo ''; - echo "
$trueplayerip"; + echo "
$trueplayerip"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; @@ -170,7 +170,7 @@ if($_GET['manignore'] == "true") { // CASE: MERGE NICKS WITH SHARED IP } else if($_POST['submit'] == "Player merge") { - echo "

Merging nicks with shared ip

"; + echo "

Merging nicks with shared ip

"; $ip = mysql_real_escape_string(str_replace("_",".",$_POST['ip'])); $merge_to_pid = mysql_real_escape_string($_POST['merge_to']); @@ -184,7 +184,7 @@ if($_GET['manignore'] == "true") { // If there is more than one pid associated to an IP ... IF ($pidcount > 1 ) { - echo "$trueplayerip

merge:
"; + echo "$trueplayerip

merge:
"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT p.pid FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; @@ -210,7 +210,7 @@ if($_GET['manignore'] == "true") { // CASE: SHOW ALL IP'S LINKED TO MORE THAN ONE NICK - ONLY RANGE } else if($_GET['onlyrange'] == "true") { if($_POST['submit'] == "Confirm") { - echo "

Showing all ip's in range ".htmlentities($_POST['from'])." to ".htmlentities($_POST['to'])."
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; + echo "

Showing all ip's in range ".htmlentities($_POST['from'])." to ".htmlentities($_POST['to'])."
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; $from = mysql_real_escape_string($_POST['from']); $to = mysql_real_escape_string($_POST['to']); @@ -240,7 +240,7 @@ if($_GET['manignore'] == "true") { // If there is more than one pid associated to an IP ... IF ($pidcount > 1 ) { - echo "
$trueplayerip"; + echo "
$trueplayerip"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; @@ -260,7 +260,7 @@ if($_GET['manignore'] == "true") { } } else { - echo "

Showing all ip's in range - Enter range to filter on

"; + echo "

Showing all ip's in range - Enter range to filter on

"; echo ''; echo '
Ranging from to '; echo '

'; @@ -268,7 +268,7 @@ if($_GET['manignore'] == "true") { // CASE: SHOW ALL IP'S LINKED TO MORE THAN ONE NICK } else { - echo "

IP's linked with more than one nick
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; + echo "

IP's linked with more than one nick
If you want to ignore some ip's, because for example different but unrelated nicks are associated with it, check these and press the button at the lower end to confirm this

"; $ignore_ips = mysql_query("SELECT ip FROM uts_ignoreips"); $extended_query = ""; @@ -299,7 +299,7 @@ if($_GET['manignore'] == "true") { // If there is more than one pid associated to an IP ... IF ($pidcount > 1 ) { - echo "
$trueplayerip"; + echo "
$trueplayerip"; // Query for player names and ids associated to that ip during the cycle $sql_pcheck = "SELECT pi.id, pi.name, pi.country, p.pid, p.ip FROM uts_pinfo AS pi, uts_player AS p WHERE pi.id = p.pid AND p.ip = $playerip GROUP BY pi.id, pi.name, p.pid, p.ip, pi.country"; diff --git a/html/pages/admin/recalcflags.php b/html/pages/admin/recalcflags.php old mode 100755 new mode 100644 index 073e648..2c88610 --- a/html/pages/admin/recalcflags.php +++ b/html/pages/admin/recalcflags.php @@ -27,7 +27,7 @@ include("includes/geoip.inc"); $gi = geoip_open("GeoIP.dat",GEOIP_STANDARD); -echo'
Possible aliasses
+echo'
'; diff --git a/html/pages/admin/recalcranking.php b/html/pages/admin/recalcranking.php old mode 100755 new mode 100644 index 1cbc865..0065439 --- a/html/pages/admin/recalcranking.php +++ b/html/pages/admin/recalcranking.php @@ -22,7 +22,7 @@ if ($results['start'] != 'Yes') { @set_time_limit(0); -echo'
Recalculating Countryflags
+echo'
'; diff --git a/html/pages/admin/utdclog.php b/html/pages/admin/utdclog.php old mode 100755 new mode 100644 index b22bfd7..b81f8d4 --- a/html/pages/admin/utdclog.php +++ b/html/pages/admin/utdclog.php @@ -17,7 +17,7 @@ if (!empty($filename)) { if (empty($filename)) { - echo'
Recalculating Rankings
+ echo'
'; @@ -70,7 +70,7 @@ if (empty($filename)) { if (!empty($filename)) { if (!file_exists('logs/utdc/'. $filename) or !is_file('logs/utdc/'. $filename)) die('bla'); - echo'
Available UTDC Logs:
+ echo'
+ + + + + + + + + +
'.$filename.' '; diff --git a/html/pages/admin/utdcshot.php b/html/pages/admin/utdcshot.php old mode 100755 new mode 100644 diff --git a/html/pages/credits.php b/html/pages/credits.php index 4f8f4c2..4848d6e 100755 --- a/html/pages/credits.php +++ b/html/pages/credits.php @@ -1,312 +1,349 @@ -
-

Credits

- -
    -
  1. Developers
    2. -
  2. Change Log
    3. -
  3. To Do List
    4. -
  4. Thanks
    5. -
  5. Copyright Notices
    6. -
- -

Developers

-

UTStats was developed by azazel, )°DoE°(-AnthraX, PJMODOS and toa.
-All original pages are W3C HTML 4.01 and -CSS compliant

- -
- -

Change Log

-

-

-
4.3.0 (4/1/2018 by killerEye, imported by Monk)
-
Added:
- Graphs of specific stats for CTF, DOM and DM game types.

- -
beta 4.2.8 (23/7/2011 by Rork)
-
Bug Fixes:
- Fixed explain rankings (reported by Letylove49)
- Fixed delete player (reported by The Cowboy)
- Fixed delete player from match
- Fixed support for LMS++

- -
beta 4.2.7 (24/4/2011 by Rork)
-
Added:
- IP Information in extended player info
- Possible fake nicks in extended player info
- Added support for LMS+

- -
Bug Fixes:
- Fixed player deletion
- Fixed DOM import with bots
- Fixed player info BT records
- Fixed order players in playersearch
- Fixed player time on server longer then gametime
- Fixed lms player sorting
- Fixed lms ttl
- Fixed SQL table creation (reported by PopCorn)

- -
beta 4.2.6 (04/12/2010 by Rork)
-
Bug Fixes:
- Fixed serveral vulnerabilities
- Fixed DOM specific map page not showing
- Fix Assault Match looks
- Add support for new BT times
- Fixed CTF Match Reports

- -
beta 4.2.5 (23/10/2010 by Rork)
-
Added:
- Game time in match stats
- Added applicable totals per gametype on the mappage
- Bunny Track stats, BT++ support only
- Server configuration checker/database setup
- UTDC Screenshots viewer
- ACE Logviewer
- Added out time in LMS
- Added number of players to recent matches
- Hide not applicable statistics from player pages
- Various lay-out improvements
- Filters in maplist
- Show Score under Match Totals for teamgames
- Added debug messages

- -
Bug Fixes:
- Fixed delete player from match
- Fixed bug where players are spec after merging or teamchange
- Fixed effective rank after merging players
- Dirty fix for divide by zero bug on logimport (was line 47) (gametime = 0)
- Fixed dodgy import log recognition
- Fixed playerlink in explain ranking
- Two bug fixes by Enakin reported in the 4.2.3 release thread
- Fixed LMS ttl by using the time until the player is out.
- Sorted LMS players by ttl, the winner on top
- Fixed php shorttag in import_playerstuff.php
- Prevent removing files from ftp after error
- Prevent importing empty log after ftp error
- Made the main pages W3C HTML 4.01 Compliant
- Fixed some vulnerabilities

- -
beta 4.2.4 (10/04/2010 by Loki)
-
Added:
- Breakdown of server occupation per weekday (By Loki)
- Breakdown of country of origin (By Loki)
- Included IpToCountry patch into the release, added GeoIP.dat from March 2010 (By Loki)

-
Bug Fixes:
- Fixed PHP opening tags (By Loki)

- -
beta 4.2.3 (18/01/09 by 2399Skillz)
-
Bug Fixes:
- Lots of bug fixes/database corrections (By Enakin)

- -
beta 4.2.2 (30/12/08 by 2399Skillz)
-
Added:
- Option to import AnthChecker logs (admin viewable only) (Added by Skillz)
- New player merger page for admins(Added by killereye)

-
Bug Fixes:
- UT Stats DOM fix (Edited by killereye)

- -
beta 4.2 (20/10/2005 by Azazel)
-
Added:
- Ranking re-calculation option added to admin section
- Import and display player pings
- Explain Ranking page
- Added an option to the admin page to delete temporary tables (if any)

- -
Bug Fixes:
- Import fix for MySQL v3.x
- Partial Import delete fix
- bbcode and Clanbase Report Fix - not showing high score win reports.
- Ranking fix (was more than 300 mins to get full ranking points)
- Spectator fix (was logging players as spectators)
- Efficiency on Players Total worked out as SUM rather than AVG
- Clanbase report fixed
- Totals on Totals Page fixed
- Events on Totals Page only show if they really happened
- Number of matches on Totals Page fixed
- Fixed a crash when trying to import logs that didnt contain IP records
- Maps sometimes appeared twice on the maps list / incorrect map statistics
- First/Prev/Next/Last links on map stas page were not working correctly
- Improved server actor version uploaded (old one may have caused some server lag at times)
- Updated import.php for new server actor
- Few actor fixes
- Weapon stats for second attacking team in assault games were not correct (reported by wgray8231)
- Delete player from match didn't correctly remove the player from the match (reported by wgray8231)

- -
beta 4.0
-
Added:
- Many pages overhauled
- Database overhauled
- Option to import bots or not (off by default)
- Command Line Interface now outputs to text not html
- Ranking stuff on match and player pages include gold/silver/bronze cups for each gametype
- Rankings tweaked so new players get even less points
- Maps page now sortable
- Flag Assists now show, get the new Smart CTF
- Report generator outputting to Clanbase and bbcode format
- Support added for custom weapons and gametypes
- Admin page including server/player merging, deletion of players/matches, renaming of "game types" etc
- Option to compress logs when backing them up (requires bzip/gzip support in php)
- More debugging stuff added
- Accuracy package optimised and recoded for better performance (it will not lag the server in anyway now)
- More detailed weapon statistics added
- Totals page expanded with information like on the old NGStats
- JailBreak should now display its statistics properly
- Purge logs option added
- Graphs now display better regardless of data used
- CTF4 Compatibility
- Date and Game Type filtering on Recent Matches page
- Ability to Ban players
- Ability to ignore matches < X minues in length
- IP Search within Administration
- Ability to ignore matches less than X minutes in length
- Option to import UTDC logs (admin viewable only)

- -
Bug Fixes:
- Ranking overhauled to better reflect average game play of players
- Cleaned up the importer
- Teamscores now shown correctly regardless of player switching activity
- Kills matrix is now created on combined player records
- Kills against bots no longer counted if bots are not imported
- Domination logs only log when players are in
- Teamkills identified as kills in non-team games (gg Epic :/)
- Eff etc fixed because of above Teamkills bug
- Last line not logging of buffer fixed

- -
beta 3.2
-
Added:
- Debugging Option
- Better FTP Capabilities
- Filters carried over on next last etc on player page

- -
Bug Fixes:
- Imports failing on some versions of php 4.3.x
- Totals page fixed
- Totals info at the top of match pages fixed

- -
beta 3.1
-
Added:
- Kills Matchup Matrix - Country Flags for Players
- Hover Hints over key parts of the page (eg. K F D S)
- Some Graphs

- -
Bug Fixes:
- Importer can now import unlimited logs
- Kills on match pages not listed
- Games where nothing happens no longer imported
- Players who have 0 kills & 0 deaths no longer get imported
- FTP script re-written
- Pickups removed from insta pages
- Translocator entries removed from logs (throws not kills)
- Multis & Sprees report correct player now
- Kills correctly worked out on non-Team Games
- - Frags correctly worked out on all games

- -
beta 3.0
-
Added:
- SmartCTF events
- UTGL Compatibility

- Updated:
- UTStats actor re-written from scratch, it now uses NGLog files
- Database re-written from scratch
- PHP code re-written from scratch

- -
Bug Fixes:
- Too many to think about

- -
beta 2.0
-
Code rewritten from ground up then lost :(

- - -
beta 1.2
-
Added:
- Accuracy Code (best in insta but works on all weapons)
- UT2004 spree scheme
- Who killed the Flag Carrier
-
- Updated:
- Complete overhaul of pages/theme to mimic closley UT2004 Stats by Epic
- Cap times added to Clanbase Report
- Stats database, now at least 10-20x smaller
-
- Bug Fixes:
- TeamKills no longer appear in DM
- TeamKills no longer mess up overall stats
- Bot kills etc no longer included in overall stats
- Sprees are unique

- -
beta 1.1
-
Added:
- Clanbse Reports for CTF Match's
- 30 Recent Match's to Player View

- -
beta 1
-
Stats output for:
- Player Joins/Leaves
- Match Start/End
- Frags and Item Pickups
- Sprees (Doubles/Multis and Domination/Monster etc)
- Events
- -
- -

To Do List

-
- "Requests"
- Centralise stats
- Web based installer
- Other Anticheat log parser. (UTPure, EUT, etc..)
- Multi language support
- Add sftp support
- Add siege support
- Wins/Losses to the Career summary
- Killgraph as in utstatsdb
-
-
- -

Thanks

-
-
-
Epic for making a game that we still play
- kostaki for the database pointers, scoring system and the inzane public servers :)
- Limited for the late night sesions, the linux script and the original zero_out function
- L0cky and Flash for the original FTP Script
- Loph for the 6 different reports o/
- Rush for the improved linux script, testing, suggestions and bug finding
- TNSe for being TNSe
- Truff for testing, suggestions and constant bug finding
- Truff Community for testing, suggestions and input
- UnrealAdmin.org testers and suggesters
- -

Copyright Notices

-
-
UTStats
- Copyright (C) 2004/2005 UTStats
-
- This program is free software; you can redistribute and/or modify
- it under the terms of the Open Unreal Mod License.
-
- If you do make any changes, fixes or updates posting them on the
- forum would be appreciated.
-
- UT Query PHP script v1.01 by Almar Joling, 2003
- www.persistentrealities.com
-
- pemftp Class by Alexey Dotsenko <alex at paneuromedia dot com>
- http://www.phpclasses.org/browse/package/1743.html
-
- GeoLite data created by MaxMind
- Available from http://www.maxmind.com/app/geolitecountry
-
- overLIB by Erik Bosrup
- http://www.bosrup.com/web/overlib/ -
-
- - - - - -
Back to Top 
-
+ + + + + + + + + +
Credits
+ +
    +
  1. Developers
    2. +
  2. Change Log
    3. +
  3. To Do List
    4. +
  4. Thanks
    5. +
  5. Copyright Notices
    6. +
+ +

Developers

+ +
+

+ UTStats was developed by azazel, )°DoE°(-AnthraX, PJMODOS, toa and sn3p.
+ The source code is available from GitHub.
+ All original pages are W3C HTML 4.01 and + CSS compliant +

+
+ +

+ Change Log (click to show/hide) +

+ + + +

To Do List

+ +
+ "Requests"
+ Centralise stats
+ Web based installer
+ Other Anticheat log parser. (UTPure, EUT, etc..)
+ Multi language support
+ Add sftp support
+ Add siege support
+ Wins/Losses to the Career summary
+ Killgraph as in utstatsdb
+
+
+ +

Thanks

+ +
+
+
Epic for making a game that we still play
+ kostaki for the database pointers, scoring system and the inzane public servers :)
+ Limited for the late night sesions, the linux script and the original zero_out function
+ L0cky and Flash for the original FTP Script
+ Loph for the 6 different reports o/
+ Rush for the improved linux script, testing, suggestions and bug finding
+ TNSe for being TNSe
+ Truff for testing, suggestions and constant bug finding
+ Truff Community for testing, suggestions and input
+ UnrealAdmin.org testers and suggesters
+ PassionateGaming and OwnedWell for all the pugs and cups!
+
+ +

Copyright Notices

+ +
+
UTStats
+ Copyright (C) 2004/2005 UTStats
+
+ This program is free software; you can redistribute and/or modify
+ it under the terms of the Open Unreal Mod License.
+
+ If you do make any changes, fixes or updates posting them on the
+ forum would be appreciated.
+
+ UT Query PHP script v1.01 by Almar Joling, 2003
+ www.persistentrealities.com
+
+ pemftp Class by Alexey Dotsenko <alex at paneuromedia dot com>
+ http://www.phpclasses.org/browse/package/1743.html
+
+ GeoLite data created by MaxMind
+ Available from http://www.maxmind.com/app/geolitecountry
+
+ overLIB by Erik Bosrup
+ http://www.bosrup.com/web/overlib/
+
+ High Charts - the graphs that made it possible to visualise the data for DOM, DM, CTF.
+ Tooltipster - the tooltips used everywhere except the graphs.
+ Yummygum Iconsweets - a few icons came from this awesome set that is free.
+ Weapon Icons - the weapons icons used are a combination of both DarkAp89 & piemo's designs.
+ +
+
+ +
diff --git a/html/pages/dpmatch.php b/html/pages/dpmatch.php old mode 100755 new mode 100644 index b563fa0..2605249 --- a/html/pages/dpmatch.php +++ b/html/pages/dpmatch.php @@ -21,7 +21,7 @@ $results = adminselect($options); $matchid = $results['mid']; $pid = $results['pid']; -echo'
+echo'
'; diff --git a/html/pages/graph_mbreakdown.php b/html/pages/graph_mbreakdown.php index 1f386fe..172b419 100755 --- a/html/pages/graph_mbreakdown.php +++ b/html/pages/graph_mbreakdown.php @@ -1,19 +1,22 @@ $hour_max) $hour_max = $r_ghours['res_count']; - $hour_sum += $r_ghours['res_count']; + $gb_hour[$r_ghours['res_hour']] = $r_ghours['res_count']; + if ($r_ghours['res_count'] > $hour_max) $hour_max = $r_ghours['res_count']; + $hour_sum += $r_ghours['res_count']; } + if ($hour_max == 0) return; // Daily Breakdown @@ -22,67 +25,72 @@ $sql_gdays = "SELECT WEEKDAY(time) AS res_day, COUNT(*) AS res_count FROM uts_match WHERE $bgwhere GROUP by res_day"; + $q_gdays = mysql_query($sql_gdays) or die(mysql_error()); $day_max = 0; $day_sum = 0; + while ($r_gdays = mysql_fetch_array($q_gdays)) { - $gb_day[$r_gdays['res_day']] = $r_gdays['res_count']; - if ($r_gdays['res_count'] > $day_max) $day_max = $r_gdays['res_count']; - $day_sum += $r_gdays['res_count']; + $gb_day[$r_gdays['res_day']] = $r_gdays['res_count']; + if ($r_gdays['res_count'] > $day_max) $day_max = $r_gdays['res_count']; + $day_sum += $r_gdays['res_count']; } // Monthly Breakdown $sql_gmonths = "SELECT MONTH(time) AS res_month, COUNT(*) AS res_count -FROM uts_match WHERE $bgwhere GROUP by res_month"; + FROM uts_match + WHERE $bgwhere + GROUP by res_month"; + $q_gmonths = mysql_query($sql_gmonths) or die(mysql_error()); $month_max = 0; $month_sum = 0; + while ($r_gmonths = mysql_fetch_array($q_gmonths)) { - $gb_month[$r_gmonths['res_month']] = $r_gmonths['res_count']; - if ($r_gmonths['res_count'] > $month_max) $month_max = $r_gmonths['res_count']; - $month_sum += $r_gmonths['res_count']; + $gb_month[$r_gmonths['res_month']] = $r_gmonths['res_count']; + if ($r_gmonths['res_count'] > $month_max) $month_max = $r_gmonths['res_count']; + $month_sum += $r_gmonths['res_count']; } // very dirty hack, to deal with the $bgwhere containing an OR // if it contains an OR, all literals should be prefixed with "m." if (substr_count($bgwhere, ' or ') == 0){ - $bgwhere = 'm.' . $bgwhere; + $bgwhere = 'm.' . $bgwhere; } else { - $bgwhere = substr($bgwhere, 1, -1); - $part = explode(' or ', $bgwhere); - $bgwhere = ''; - foreach($part as $i){ - $bgwhere .= 'm.' . $i . ' OR '; - } - $bgwhere = '(' . substr($bgwhere, 0, -4) . ')'; + $bgwhere = substr($bgwhere, 1, -1); + $part = explode(' or ', $bgwhere); + $bgwhere = ''; + foreach($part as $i){ + $bgwhere .= 'm.' . $i . ' OR '; + } + $bgwhere = '(' . substr($bgwhere, 0, -4) . ')'; } // Country Breakdown $sql_gcountries = "SELECT country AS res_country, COUNT(*) AS res_count -FROM (SELECT p.country AS country - FROM uts_player AS p, uts_match AS m - WHERE m.id = p.matchid AND $bgwhere - GROUP BY p.pid, p.country) AS res_table -GROUP BY res_country -ORDER BY res_count DESC"; + FROM (SELECT p.country AS country FROM uts_player AS p, uts_match AS m + WHERE m.id = p.matchid AND $bgwhere + GROUP BY p.pid) AS res_table + GROUP BY res_country ORDER BY res_count DESC"; $q_gcountries = mysql_query($sql_gcountries) or die(mysql_error()); $country_max = 0; $country_sum = 0; $i = 0; + while ($r_gcountries = mysql_fetch_array($q_gcountries)) { - $gb_country[$i] = $r_gcountries['res_country'] . ";" . $r_gcountries['res_count']; - if ($r_gcountries['res_count'] > $country_max) $country_max = $r_gcountries['res_count']; - $country_sum += $r_gcountries['res_count']; - $i++; + $gb_country[$i] = $r_gcountries['res_country'] . ";" . $r_gcountries['res_count']; + if ($r_gcountries['res_count'] > $country_max) $country_max = $r_gcountries['res_count']; + $country_sum += $r_gcountries['res_count']; + $i++; } -echo' -
Delete Player From Match ID '.$matchid.'
+echo ' +
@@ -178,17 +187,17 @@ $no_countries = 20; // Check if there are more countries then $no_countries; if so, we can have a "others" column if ( count($gb_country) < $no_countries ){ - $max_cntry = count($gb_country); - $collspan = $max_cntry + 2; - $others = false; + $max_cntry = count($gb_country); + $collspan = $max_cntry + 2; + $others = false; } else { - $max_cntry = $no_countries; - $collspan = $max_cntry + 3; - $others = true; + $max_cntry = $no_countries; + $collspan = $max_cntry + 3; + $others = true; } echo' -
- + @@ -90,81 +98,82 @@ echo' - '; + '; // Hourly for ($i = 0; $i <= 23; $i++) { - if (!isset($gb_hour[$i])) $gb_hour[$i] = 0; - $title = $gb_hour[$i] .' ('. get_dp($gb_hour[$i] / $hour_sum * 100) .' %)'; - echo ''; + if (!isset($gb_hour[$i])) $gb_hour[$i] = 0; + $title = $gb_hour[$i] .' ('. get_dp($gb_hour[$i] / $hour_sum * 100) .' %)'; + echo ''; } echo ''; // Daily for ($i = 0; $i <= 6; $i++) { - if (!isset($gb_day[$i])) $gb_day[$i] = 0; - $title = $gb_day[$i] .' ('. get_dp($gb_day[$i] / $day_sum * 100) .' %)'; - echo ''; + if (!isset($gb_day[$i])) $gb_day[$i] = 0; + $title = $gb_day[$i] .' ('. get_dp($gb_day[$i] / $day_sum * 100) .' %)'; + echo ''; } echo ''; // Monthly for ($i = 1; $i <= 12; $i++) { - if (!isset($gb_month[$i])) $gb_month[$i] = 0; - $title = $gb_month[$i] .' ('. get_dp($gb_month[$i] / $month_sum * 100) .' %)'; - echo ''; + if (!isset($gb_month[$i])) $gb_month[$i] = 0; + $title = $gb_month[$i] .' ('. get_dp($gb_month[$i] / $month_sum * 100) .' %)'; + echo ''; } + echo ''; echo' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Hourly, Daily and Monthly Activity '.$gtitle.'
'. $title .''. $title .''. $title .''. $title .''. $title .''. $title .'
01234567891011121314151617181920212223MTWTFSSJFMAMJJASOND01234567891011121314151617181920212223MTWTFSSJFMAMJJASOND
+
@@ -199,39 +208,45 @@ echo' - '; + '; // Countries $x = 0; for ($i = 0; $i < $max_cntry; $i++) { - if (!isset($gb_hour[$i])) $gb_hour[$i] = 0; - $country = explode(";",$gb_country[$i]); - $title = $a_countries[$country[0]] .': ' . $country[1] . ' ('. get_dp($country[1] / $country_sum * 100) .' %)'; - echo ''; - $x += $country[1]; + if (!isset($gb_hour[$i])) $gb_hour[$i] = 0; + $country = explode(";",$gb_country[$i]); + $title = $a_countries[$country[0]] .': ' . $country[1] . ' ('. get_dp($country[1] / $country_sum * 100) .' %)'; + echo ''; + $x += $country[1]; } + if($others){ - $countries_left = $country_sum - $x; - $title = 'Other Countries: ' . $countries_left . ' ('. get_dp($countries_left / $country_sum * 100) .' %)'; - echo ''; + $countries_left = $country_sum - $x; + $title = 'Other Countries: ' . $countries_left . ' ('. get_dp($countries_left / $country_sum * 100) .' %)'; + echo ''; }; echo ''; -echo' - '; - for ($i = 0; $i < $max_cntry; $i++) { - $country = explode(";",$gb_country[$i]); - $country = strtoupper($country[0]); - echo ''; +echo' + + '; + + for ($i = 0; $i < $max_cntry; $i++) { + $country = explode(";",$gb_country[$i]); + $country = strtoupper($country[0]); + echo ''; + } + + if($others){ + echo ''; } -if($others){ - echo ''; -} -echo' + + echo '
'. $title .''. $title .''. $title .''. $title .'
' . $country . '
' . $country . '----

'; + ?> diff --git a/html/pages/graph_pbreakdown.php b/html/pages/graph_pbreakdown.php old mode 100755 new mode 100644 index 808c7cb..8395b30 --- a/html/pages/graph_pbreakdown.php +++ b/html/pages/graph_pbreakdown.php @@ -41,7 +41,7 @@ while ($r_gmonths = mysql_fetch_array($q_gmonths)) { echo' - +
- + +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']; +$lastMapFile = $qlastMaps['mapfile']; +$lastMapFileName = rtrim($lastMapFile, ".unr"); + +$lastMapTime = $qlastMaps['time']; +$lastMapScore0 = $qlastMaps['t0score']; +$lastMapScore1 = $qlastMaps['t1score']; +$lastMapScore2 = $qlastMaps['t2score']; +$lastMapScore3 = $qlastMaps['t3score']; +$moreThan2Teams = ($lastMapScore2!=0); + +$mappic = getMapImageName($lastMapFileName); + +// quick hack to show empty one at front page if no map +if (!file_exists($mappic) || $mappic == "images/maps/blank_large.jpg") { + $mappic = "images/maps/emptyfront.jpg"; +} + +echo ' +
+
diff --git a/html/pages/help.php b/html/pages/help.php index 2e595aa..c156eae 100755 --- a/html/pages/help.php +++ b/html/pages/help.php @@ -1,189 +1,296 @@ -
-

Help

-

- For help and documentation please visit - https://github.com/sn3p/utstats.
- Please report issues and feature requests in the - issue tracker. -

-
- -

Frequently Asked Questions

- -
    -
  1. Stat Tracking Servers
    2. -
  2. Enabling your personal stats tracking
    3. -
  3. Information about how the stats work
    4. -
  4. What are the 'official' Unreal Tournament gametypes?
    5. -
  5. How does ranking work?
    6. -
  6. Scoring - Individual player points awarded?
    7. -
  7. Team Scores?
    8. -
  8. Glossary - Terms and abbreviations.
    9. -
  9. Enabling Stats on a Server
    10. -
- -

Stat Tracking Servers

-

UTStats only does stats tracking for servers that have UTStats - installed.
- To download and get the latest information, please click the forum link to - the left.

- -

Enabling your personal stats tracking

-

Currently this is not possible, for now you need to use the same - nick for this group of servers.
- If the server runs UTGL your stats nick always will be the one you registered - with so there are no stats tracking issues on UTGL servers.

- -

Information about how the stats work

-

A server with stat tracking enabled will send information to the -stats server about the game - each frag, score, etc. Once the game is -completed the match is processed and posted on the stats pages. The best -way to look up a recent match you played is either by your stats ID or the -server ID. You can search for your user ID or the server ID by name. -The user names used on the stats pages are based on the last player name you -used in a match - your stats user name you entered in the networking settings is -not displayed.

-

Bots are not logged, nor are any kills against them.

-
- -

What are the 'official' Unreal Tournament gametypes?

-

Out of the box Unreal Tournament features the gametypes -Deathmatch, Team Deathmatch, Capture the Flag, Assault and Domination.
-There are separate rankings for each of the official game types.

- -

How does ranking work?

-

Ranking points are based on what you do in a game.
-Points are awarded for fragging and events (eg. flag captures).
-Points are deducted for deaths, suicides and teamkills

-Player ranking points are reduced until they have completed 300 minutes of games.

- -

Scoring - Individual player points award:

-

These depend on the game type you are playing. There are -individual player scores awarded for special achievements, such as captures, -assists, etc.
-See the Score tables on the Players or Matches subpages to find -out how many points are actually awarded for each score type.

- -

Team Scores?

-

Aside from the individual player scoring in team based gametypes -(CTF, AS, DOM), there are also Team Scores, that are awarded to -your team as a whole, for fulfilling a gametype specific objective:
-

    -
  • Capture the Flag - capturing, covering, killing and returning the flag.
    • -
  • Assault - achieving an objective.
    • -
  • Domination - 'holding' domination points.
    • -
-Note: A team based game is won by the Team Score; the individual player score -sums do not matter!

- -


Glossary

-
- -

Abbreviations

-

Common abbreviations in UTStats.
-- K = Kills, S = Suicides, F = Frags, D = Deaths
-- E = Events, TK = Team Kills, TD = Team Deaths
-- DM = Deathmatch, TDM = Team Deathmatch, CTF = Capture the Flag,
-- AS = Assault, DOM = Domination
-- FPH = Frags per Hour, SPH = Score per Hour
-- [d] = Time in days, [h] = Time in hours,
-- [m],[min] = Time in minutes, [s],[sec] = Time in seconds

- -

Deaths

-

Number of times a player gets killed by another player.
-- This does not include environment induced deaths, like trap doors. These and -self kills are counted separately, as suicides.
-- Team based deaths are counted as team deaths.
-- In tables with weapon specific information, deaths are the number of times a -player died holding that weapon.

- -

Dodging

-

Special move in Unreal Tournament, that can be activated by -tapping any movement key twice. Used by many good players to improve their -maneuverability.

- -

Efficiency

-

A ratio that denotes the player's kill skill by comparing it with -his overall performance. A perfect efficiency is equal to 1 (100%), -anything less than 0.5 (50%) is below average.
-Formula: Kills / (Kills + Deaths + Suicides [+Team Kills])

+
+ + + + + + + +
Help
+
+

+ For help and documentation please visit + https://github.com/sn3p/utstats. +
+ Please report issues and feature requests in the + issue tracker. +

+
+
-

Events

-

Anything not related to frags, deaths, suicides or kills is -hereby defined as an event. Typical events would be a flag capture (score -related) or a flag drop (not score related). Events are mostly used to track all -the other things going on in a game, that are not frag-related.

- -

First Blood

-

Special event awarded to the player who gets the first kill in a -newly started match.

- -

Frags

-

A player's frag count is equal to their kills minus -suicides. In team games team kills (not team suicides) are also subtracted -from the player's kills.

- -

Frags Per Hour

-

A ratio between the number of frags a player scores per one -hour. 30 frags in 5 minutes will give you 360 FPH.
-Formula: Frags / (Time played in hours)

- -

Kills

-

Number of times a player kills another player.
-Note: UTStats only tracks human vs. human kills. Bot kills and other bot -related events are tracked at the admins discretion.

- -

Multi Kills

-

Special event awarded to the player for killing other players in -a certain time frame. Every time a player scores a kill he has up to 3 -seconds to make another kill. So 2 kills in 3 seconds gets you a Double -Kill, 3 kills within 3 seconds apart from another a Multi Kill and so on:
-- Double Kill = 2 kills
-- Multi Kill = 3 kills
-- Ultra Kill = 5 kills
-- Monster Kill = 6 kills

- -

Ping

-

Measure of your connection quality. Ping is the round trip -delay in milliseconds that your computer has to the game server. Low -values are not important for a fun game, but it sure helps.

- -

Killing Sprees

-

Special event: If you manage to kill 5 or more opponents without -dying yourself, you will be on a killing spree. If you kill more than 10 -opponents, you are on a rampage, etc.:
-- Killing Spree! 5 kills
-- Rampage! 10 kills
-- Dominating! 15 kills
-- Unstoppable! 20 kills
-- God Like! 25 kills

- -

Suicides

-

Number of times a player dies due to action of their own cause. -Suicides can be environment induced (drowning, getting crushed, falling) or -weapon related (fatal splash damage from their own weapon).

- -

Team Deaths

-

Number of times a player in a team based game is killed by -someone on their own team.

- -

Team Kills

-

Number of times a player in a team based game kills someone on -their own team.
-Note: Team kills subtract from a player's personal frags and thus the team frags -as a whole.

- -

TTL

-

TTL is Time to Live.
-Its the length of time you are in a game in seconds divided by how many times you die, -thus giving an average time of how long you will live.

- - +
-

Enabling Stats on a Server

-

Download and get the latest information on UTStats by clicking - the forum link to the left.

+ + + + + + + + +
Frequently Asked Questions
+
+

1. + Stat Tracking Servers +
2. + Enabling your personal stats tracking +
3. + Information about how the stats work +
4. + What are the \'official\' Unreal Tournament gametypes? +
5. + How does ranking work? +
6. + Scoring - Individual player points awarded? +
7. + Team Scores? +
8. + Glossary - Terms and abbreviations. +
9. + Enabling Stats on a Server +

+
+

+

+ Stat Tracking Servers +

+
+

UTStats only does stats tracking for servers that have UTStats installed. +
To download and get the latest information, please click the forum link to the left.

+
+

+ + Enabling your personal stats tracking +

+
+

Currently this is not possible, for now you need to use the same nick for this group of servers. +
If the server runs UTGL your stats nick always will be the one you registered with so there are no stats + tracking issues on UTGL servers.

+
+

+

+ Information about how the stats work +

+
+

A server with stat tracking enabled will send information to the stats server about the game - each frag, score, + etc. Once the game is completed the match is processed and posted on the stats pages. The best way to look up a + recent match you played is either by your stats ID or the server ID. You can search for your user ID or the server ID + by name. The user names used on the stats pages are based on the last player name you used in a match - your stats + user name you entered in the networking settings is not displayed.

+

Bots are not logged, nor are any kills against them.

+
+

+

+ What are the 'official' Unreal Tournament gametypes? +

+
+

Out of the box Unreal Tournament features the gametypes Deathmatch, Team Deathmatch, Capture the Flag, Assault and + Domination. +
There are separate rankings for each of the official game types.

+
+

+

+ How does ranking work? +

+
+

Ranking points are based on what you do in a game. +
Points are awarded for fragging and events (eg. flag captures). +
Points are deducted for deaths, suicides and teamkills +
+
Player ranking points are reduced until they have completed 300 minutes of games.

+
+

+

+ Scoring - Individual player points award: +

+
+

These depend on the game type you are playing. There are individual player scores awarded for special + achievements, such as captures, assists, etc. +
See the Score tables on the Players or Matches subpages to find out how many points are actually awarded for + each score type.

+
+

+ + Team Scores? +

+
+

Aside from the individual player scoring in team based gametypes (CTF, AS, DOM), there are also Team Scores, that + are awarded to your team as a whole, for fulfilling a gametype specific objective: +

+

Capture the Flag - capturing, covering, killing and returning the flag. +
Assault - achieving an objective. +
Domination - 'holding' domination points. +
+
Note: A team based game is won by the Team Score; the individual player score sums do not matter!

+
+

+

+ Enabling Stats on a Server +

+
+

Download and get the latest information on UTStats by clicking the forum link to the left.

+
+

-Back to Top - + + + + + + + + + +
Glossary
+

+

+ Abbreviations +

+
+

Common abbreviations in UTStats. +
- K = Kills, S = Suicides, F = Frags, D = Deaths +
- E = Events, TK = Team Kills, TD = Team Deaths +
- DM = Deathmatch, TDM = Team Deathmatch, CTF = Capture the Flag, +
- AS = Assault, DOM = Domination +
- FPH = Frags per Hour, SPH = Score per Hour +
- [d] = Time in days, [h] = Time in hours, +
- [m],[min] = Time in minutes, [s],[sec] = Time in seconds

+
+

+ + Deaths +

+
+

Number of times a player gets killed by another player. +
- This does not include environment induced deaths, like trap doors. These and self kills are counted + separately, as suicides. +
- Team based deaths are counted as team deaths. +
- In tables with weapon specific information, deaths are the number of times a player died holding that + weapon.

+
+

+

+ Dodging +

+
+

Special move in Unreal Tournament, that can be activated by tapping any movement key twice. Used by many good + players to improve their maneuverability.

+
+

+

+ Efficiency +

+
+

A ratio that denotes the player\'s kill skill by comparing it with his overall performance. A perfect + efficiency is equal to 1 (100%), anything less than 0.5 (50%) is below average. +
Formula: Kills / (Kills + Deaths + Suicides [+Team Kills])

+
+

+

+ Events +

+
+

Anything not related to frags, deaths, suicides or kills is hereby defined as an event. Typical events would be a + flag capture (score related) or a flag drop (not score related). Events are mostly used to track all the other things + going on in a game, that are not frag-related.

+
+

+

+ First Blood +

+
+

Special event awarded to the player who gets the first kill in a newly started match.

+
+

+

+ Frags +

+
+

A player\'s frag count is equal to their kills minus suicides. In team games team kills (not team suicides) + are also subtracted from the player\'s kills.

+
+

+

+ Frags Per Hour +

+
+

A ratio between the number of frags a player scores per one hour. 30 frags in 5 minutes will give you 360 FPH. +
Formula: Frags / (Time played in hours)

+
+

+

+ Kills +

+
+

Number of times a player kills another player. +
Note: UTStats only tracks human vs. human kills. Bot kills and other bot related events are tracked at the + admins discretion.

+
+

+

+ Multi Kills +

+
+

Special event awarded to the player for killing other players in a certain time frame. Every time a player scores + a kill he has up to 3 seconds to make another kill. So 2 kills in 3 seconds gets you a Double Kill, 3 kills within 3 + seconds apart from another a Multi Kill and so on: +
- Double Kill = 2 kills +
- Multi Kill = 3 kills +
- Ultra Kill = 5 kills +
- Monster Kill = 6 kills

+
+

+

+ Ping +

+
+

Measure of your connection quality. Ping is the round trip delay in milliseconds that your computer has to the + game server. Low values are not important for a fun game, but it sure helps.

+
+

+

+ Killing Sprees +

+
+

Special event: If you manage to kill 5 or more opponents without dying yourself, you will be on a killing spree. + If you kill more than 10 opponents, you are on a rampage, etc.: +
- Killing Spree! 5 kills +
- Rampage! 10 kills +
- Dominating! 15 kills +
- Unstoppable! 20 kills +
- God Like! 25 kills

+
+

+

+ Suicides +

+
+

Number of times a player dies due to action of their own cause. Suicides can be environment induced (drowning, + getting crushed, falling) or weapon related (fatal splash damage from their own weapon).

+
+

+ + Team Deaths +

+
+

Number of times a player in a team based game is killed by someone on their own team.

+
+

+

+ Team Kills +

+
+

Number of times a player in a team based game kills someone on their own team. +
Note: Team kills subtract from a player's personal frags and thus the team frags as a whole.

+
+

+

+ TTL +

+
+

TTL is Time to Live. +
Its the length of time you are in a game in seconds divided by how many times you die, thus giving an average + time of how long you will live.

+
+
diff --git a/html/pages/home.php b/html/pages/home.php index be75b66..535c15b 100755 --- a/html/pages/home.php +++ b/html/pages/home.php @@ -1,17 +1,154 @@ -
UTStats Summary
Last Map Updated
+ +
+
+ + + + + + + + + + '; + + if ($moreThan2Teams) { + echo ' + + + + '; + } + + echo '

'.$lastMapFileName.'

'.$lastMapScore0.''.mdate($lastMapTime).' '.$lastMapScore1.'
'.$lastMapScore2.''.$lastMapScore3.'
+

+
View stats
+
+
+
+ + + + + - - - - - + + + + + '; +$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 10"; +$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]); + $winner = max($r_recent[t0score], $r_recent[t1score], $r_recent[t2score], $r_recent[t3score]); + + 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 ' + + + + + +
Last 10 Matches
PlayersServersMapsMatches LoggedPlayer HoursIDDate/TimeMatch TypeMapScores
'.$r_recent[id].''.$r_time.''.$r_recent[gamename].''.$r_mapfile.' + '.$r_recent[t0score].''.$r_recent[t1score].''; + + if ($moreThan2Teams) { + echo ''.$r_recent[t2score].' '.$r_recent[t3score].''; + } + + echo '
+ Show all games +
+
'; + +echo' + + + + + + + + + + + + + '; + // Get Summary Info $r_playercount = small_query("SELECT COUNT(*) AS result FROM uts_pinfo"); $playercount = $r_playercount['result']; @@ -20,47 +157,42 @@ $mapcount = small_count("SELECT COUNT(mapfile) AS result FROM uts_match GROUP BY $r_matchcount = small_query("SELECT COUNT(*) AS result FROM uts_match"); $matchcount= $r_matchcount['result']; $hourscount = small_query("SELECT SUM(gametime) AS result FROM uts_player"); - $gametime = sec2hour($hourscount[result]); -echo' +echo ' - - - - - + + + + + -
UTStats Summary
PlayersServersMapsMatches LoggedPlayer Hours
'.$playercount.''.$servercount.''.$mapcount.''.$matchcount.''.$gametime.''.$playercount.''.$servercount.''.$mapcount.''.$matchcount.''.$gametime.'
- - - -
-
-

Welcome to UTStats.
- Here you can look up information on UT matches and players.
- Select a category from the column on the left.

-
- - - - - - - - - - - - - - '; + +
Game Summary
Match TypeFragsKillsSuicidesTeam KillsMatchesGame Hours
+
+ + + + + + + + + + + + + + + + +'; $sql_gamesummary = "SELECT g.id AS gid, g.name AS gamename, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, COUNT(DISTINCT p.matchid) AS matchcount -FROM uts_player AS p, uts_games AS g -WHERE p.gid = g.id -GROUP BY gamename, gid -ORDER BY gamename ASC"; + FROM uts_player AS p, uts_games AS g + WHERE p.gid = g.id + GROUP BY gamename, gid + ORDER BY gamename ASC"; $q_gamesummary = mysql_query($sql_gamesummary) or die(mysql_error()); @@ -70,36 +202,42 @@ while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match WHERE gid = '$gid'"); $gametime = sec2hour($q_gametime[gametime]); - echo' - - - - - - '; + echo ' + + + + + + + + + '; } $totalsummary = small_query("SELECT SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, COUNT(DISTINCT p.matchid) AS matchcount, SUM(p.gametime) AS gametime -FROM uts_player AS p, uts_games AS g -WHERE p.gid = g.id"); + FROM uts_player AS p, uts_games AS g + WHERE p.gid = g.id"); $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match"); $gametime = sec2hour($q_gametime[gametime]); -echo' - - - - - - - - -
Game Summary
Match TypeFragsKillsSuicidesTeam KillsMatchesGame Hours
'.$r_gamesummary[gamename].''.$r_gamesummary[frags].''.$r_gamesummary[kills].''.$r_gamesummary[suicides].''.$r_gamesummary[teamkills].''.$r_gamesummary[matchcount].''.$gametime.'
'.$r_gamesummary[gamename].''.$r_gamesummary[frags].''.$r_gamesummary[kills].''.$r_gamesummary[suicides].''.$r_gamesummary[teamkills].''.$r_gamesummary[matchcount].''.$gametime.'
Totals for All Players'.$totalsummary[frags].''.$totalsummary[kills].''.$totalsummary[suicides].''.$totalsummary[teamkills].''.$totalsummary[matchcount].''.$gametime.'
-

'; +echo ' +
Totals for All Players'.$totalsummary[frags].''.$totalsummary[kills].''.$totalsummary[suicides].''.$totalsummary[teamkills].''.$totalsummary[matchcount].''.$gametime.'
+
'; // Do graph stuff $gtitle = "Across All Servers"; $bgwhere = "id >= 0"; include("pages/graph_mbreakdown.php"); + ?> diff --git a/html/pages/maps.php b/html/pages/maps.php old mode 100755 new mode 100644 index 409398c..9d30179 --- a/html/pages/maps.php +++ b/html/pages/maps.php @@ -9,7 +9,7 @@ function SortPic($curr_field, $filter, $sort) { if ($curr_field != $filter) return; $fname = 'images/s_'. strtolower($sort) .'.png'; if (!file_exists($fname)) return; - return(' '); + return(' '); } @@ -84,13 +84,13 @@ IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } echo'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- +
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 @@ -127,17 +129,17 @@ while ($r_maps = mysql_fetch_array($q_maps)) { $r_gametime = GetMinutes($r_maps[gametime]); echo' - - - - - - + + + + + + '; } echo'
Unreal Tournament Maps ListUnreal Tournament Maps List
+ @@ -104,17 +104,19 @@ while ($r_game = mysql_fetch_array($q_game)) { echo ''; } echo ' '; -echo ' Search: '; -echo ' '; + +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).'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.'
'.$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.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> \ No newline at end of file diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php old mode 100755 new mode 100644 index 329fcce..a7c355e --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -1,6 +1,6 @@ -
Statistics for '.htmlentities($map).'
Matches'.$map_matches[matchcount].''.htmlentities($map).'
Total Time'.$map_tottime.' minutes
+ + + + + + + + + + + + '; + // Show some gametype specific stuff + if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { + // Bunny Track + $record = small_query("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 0,1"); + if (!empty($record['time'])) { + echo ' + + + + '; + } + else { + echo ' + + + + '; + } echo ' - - - - '; + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 4)) == "ctf-") { + // Capture the Flag + $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 ' + + + + + + + + + + + + + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 3)) == "as-") { + // Assault + $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 ' + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 3)) == "jb-") { + // Assault + $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 ' + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 4)) == "dom-") { + // Assault + $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 ' + + + + + + + + + + + + '; } else { echo ' - - - - '; + + + + + + + + + + + + + + + + '; } echo ' - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 4)) == "ctf-") { - // Capture the Flag - $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 ' - - - - - - - - - - - - - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 3)) == "as-") { - // Assault - $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 ' - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 3)) == "jb-") { - // Assault - $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 ' - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 4)) == "dom-") { - // Assault - $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 ' - - - - - - - - - - - - '; -} -else { - echo ' - - - - - - - - - - - - - - - - '; -} -echo ' - - - - -
Statistics for '.htmlentities($map).'
'.$mapname.'
Matches'.$map_matches[matchcount].'
Total Time'.$map_tottime.' minutes
Fastest Capture'.FormatPlayerName($record['country'], $record['id'], $record['name']).'
' . btcaptime($record['time']) . ' minutes
'.gmdate('d-m-Y h:i a', $record['date']).'
Fastest CaptureNo record set!
Fastest Capture'.FormatPlayerName($record['country'], $record['id'], $record['name']).'
' . btcaptime($record['time']) . ' minutes
'.gmdate('d-m-Y h:i a', $record['date']).'
Total Flags Captured'.$map_matches[gamescore].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Flags Taken'.$totals['flag_taken'].'
Total Covers'.$totals['flag_cover'].'
Total Flags Returned'.$totals['flag_return'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Objectives Achieved'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Team Releases'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Control Points Captured'.$totals['dom_cp'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Fastest CaptureNo record set!
Total Score'.$map_matches[gamescore].'
Total Kills'.$map_matches[kills].'
Total Teamkills'.$map_matches[teamkills].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Flags Taken'.$totals['flag_taken'].'
Total Covers'.$totals['flag_cover'].'
Total Flags Returned'.$totals['flag_return'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Objectives Achieved'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Team Releases'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Control Points Captured'.$totals['dom_cp'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Score'.$map_matches[gamescore].'
Total Kills'.$map_matches[kills].'
Total Teamkills'.$map_matches[teamkills].'
Total Suicides'.$map_matches[suicides].'
Last Match'.$map_lastmatch.'
-
'; - -// Do graph stuff -$bgwhere = "(mapfile = '$realmap' or mapfile = '$bugmap')"; -include("pages/graph_mbreakdown.php"); - -// Show a list of BT records -if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { - $mcount = small_count("SELECT pi.id 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') GROUP BY pi.id"); + + Last Match + '.$map_lastmatch.' + + +
'; + + + // 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, '.', ''); @@ -186,7 +183,7 @@ if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, IF($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } - $cpage = preg_replace('/\D/', '', $_GET["rpage"]); + $cpage = preg_replace('/\D/', '', $_GET["page"]); $qpage = $cpage*25; IF ($cpage == "") { $cpage = "0"; } @@ -195,127 +192,133 @@ if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, $tlpage = $lpage+1; $ppage = $cpage-1; - $ppageurl = "[Previous]"; + $ppageurl = "[Previous]"; IF ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; - $npageurl = "[Next]"; + $npageurl = "[Next]"; IF ($npage >= "$ecount") { $npageurl = "[Next]"; } - $fpageurl = "[First]"; + $fpageurl = "[First]"; IF ($cpage == "0") { $fpageurl = "[First]"; } - $lpageurl = "[Last]"; + $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"; - $q_btrecords = mysql_query($sql_btrecords) or die (mysql_error()); - if (mysql_num_rows($q_btrecords) > 0) { - echo ' -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - - - - - - - - - '; - $i = $qpage; - $lasttime = -1; - while ($r_btrecords = mysql_fetch_array($q_btrecords)) { - $i++; - $class = ($i%2) ? 'grey' : 'grey2'; - echo ' - - - - '; - $lasttime = $r_btrecords['time']; - } - echo ' - -
Fastest captures
N°NameTimeDate
'.($lasttime == $r_btrecords['time'] ? '' : $i).' ', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; - } -} + // list recent matches + echo' +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+ + + + + + + + + + '; + $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"; + $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]); -// Show a list of recent matches -$mcount = small_count("SELECT id FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap' GROUP BY id"); + $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); -$ecount = $mcount/25; -$ecount2 = number_format($ecount, 0, '.', ''); + echo' + + + + + + '; + } -IF($ecount > $ecount2) { - $ecount2 = $ecount2+1; -} + echo' +
Recent Matches
DateMatch TypePlayer CountTime
'.$r_matchtime.''.$r_maps[gamename].''.$map_pcount.''.$r_gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; + + // Do graph stuff + $bgwhere = "(mapfile = '$realmap' or mapfile = '$bugmap')"; + include("pages/graph_mbreakdown.php"); -$fpage = 0; -IF($ecount < 1) { $lpage = 0; } -else { $lpage = $ecount2-1; } + // Show a list of BT records + if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { + $mcount = small_count("SELECT pi.id 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') GROUP BY pi.id"); -$cpage = preg_replace('/\D/', '', $_GET["page"]); -$qpage = $cpage*25; + $ecount = $mcount/25; + $ecount2 = number_format($ecount, 0, '.', ''); -IF ($cpage == "") { $cpage = "0"; } + IF($ecount > $ecount2) { + $ecount2 = $ecount2+1; + } -$tfpage = $cpage+1; -$tlpage = $lpage+1; + $fpage = 0; + IF($ecount < 1) { $lpage = 0; } + else { $lpage = $ecount2-1; } -$ppage = $cpage-1; -$ppageurl = "[Previous]"; -IF ($ppage < "0") { $ppageurl = "[Previous]"; } + $cpage = preg_replace('/\D/', '', $_GET["rpage"]); + $qpage = $cpage*25; -$npage = $cpage+1; -$npageurl = "[Next]"; -IF ($npage >= "$ecount") { $npageurl = "[Next]"; } + IF ($cpage == "") { $cpage = "0"; } -$fpageurl = "[First]"; -IF ($cpage == "0") { $fpageurl = "[First]"; } + $tfpage = $cpage+1; + $tlpage = $lpage+1; -$lpageurl = "[Last]"; -IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } + $ppage = $cpage-1; + $ppageurl = "[Previous]"; + IF ($ppage < "0") { $ppageurl = "[Previous]"; } -// list recent matches -echo' -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - - - - - - - - '; + $npage = $cpage+1; + $npageurl = "[Next]"; + IF ($npage >= "$ecount") { $npageurl = "[Next]"; } -$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"; -$q_maps = mysql_query($sql_maps) or die(mysql_error()); -while ($r_maps = mysql_fetch_array($q_maps)) { + $fpageurl = "[First]"; + IF ($cpage == "0") { $fpageurl = "[First]"; } - $r_mapfile = un_ut($r_maps[mapfile]); - $r_matchtime = mdate($r_maps[time]); - $r_gametime = GetMinutes($r_maps[gametime]); + $lpageurl = "[Last]"; + IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } - $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); + $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 ' +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+
Recent Matches
DateMatch TypePlayer CountTime
+ + + + + + + + + + '; + $i = $qpage; + $lasttime = -1; + while ($r_btrecords = mysql_fetch_array($q_btrecords)) { + $i++; + $class = ($i%2) ? 'grey' : 'grey2'; + echo ' + + + + '; + $lasttime = $r_btrecords['time']; + } + echo ' + +
Fastest captures
N°NameTimeDate
'.($lasttime == $r_btrecords['time'] ? '' : $i).' ', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; + } + } - echo' - - '.$r_matchtime.' - '.$r_maps[gamename].' - '.$map_pcount.' - '.$r_gametime.' - '; } -echo' - -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> diff --git a/html/pages/match_info.php b/html/pages/match_info.php index 8d77186..aea8bc2 100755 --- a/html/pages/match_info.php +++ b/html/pages/match_info.php @@ -12,79 +12,78 @@ $_GLOBALS['gamename'] = $gamename; include("includes/teamstats.php"); include("pages/match_info_charts.php"); -echo "

WOOOt

"; switch($real_gamename) { - case "Assault": - case "Assault (insta)": - include("pages/match_info_ass.php"); - break; + case "Assault": + case "Assault (insta)": + include("pages/match_info_ass.php"); + break; - case "Capture the Flag": - case "Capture the Flag (insta)": - case "5v5 iCTF": - case "1v1 iCTF": - case "2v2 iCTF": - case "3v3 iCTF": - case "5v5 teleCTF": - case "5v5 saCTF": - case "5v5 nwCTF": - case "3v3 nwCTF": - include("pages/match_info_ctf.php"); - teamstats($mid, 'Match Summary'); - break; + case "Capture the Flag": + case "Capture the Flag (insta)": + case "5v5 iCTF": + case "1v1 iCTF": + case "2v2 iCTF": + case "3v3 iCTF": + case "5v5 teleCTF": + case "5v5 saCTF": + case "5v5 nwCTF": + case "3v3 nwCTF": + include("pages/match_info_ctf.php"); + teamstats($mid, 'Match Summary'); + break; - case "Domination": - case "Domination (insta)": - case "4v4 iDOM": - case "4v4 sDOM": - case "4v4 nwDOM": - teamstats($mid, 'Match Summary', 'dom_cp', 'Dom Pts'); - break; + case "Domination": + case "Domination (insta)": + case "4v4 iDOM": + case "4v4 sDOM": + case "4v4 nwDOM": + teamstats($mid, 'Match Summary', 'dom_cp', 'Dom Pts'); + break; - case "JailBreak": - case "JailBreak (insta)": - teamstats($mid, 'Match Summary', 'ass_obj', 'Team Releases'); - break; + case "JailBreak": + case "JailBreak (insta)": + teamstats($mid, 'Match Summary', 'ass_obj', 'Team Releases'); + break; - case "Bunny Track": - include("pages/match_info_bt.php"); - break; + case "Bunny Track": + include("pages/match_info_bt.php"); + break; - case "Tournament DeathMatch": - case "Tournament Team Game": - case "Tournament DeathMatch (insta)": - case "Tournament Team Game (insta)": - case "FFA iDM": - case "2v2v2v2 iTDM": - teamstats($mid, 'Match Summary'); - break; + case "Tournament DeathMatch": + case "Tournament Team Game": + case "Tournament DeathMatch (insta)": + case "Tournament Team Game (insta)": + case "FFA iDM": + case "2v2v2v2 iTDM": + teamstats($mid, 'Match Summary'); + break; - case "Extended Last Man Standing": - case "Extended Last Man Standing (insta)": - case "Last Man Standing": - case "Last Man Standing (insta)": - case "Last Man Standing +": - case "Last Man Standing + (insta)": - case "Last Man Standing++": - case "Last Man Standing++ (insta)": - include("pages/match_info_lms.php"); - break; + case "Extended Last Man Standing": + case "Extended Last Man Standing (insta)": + case "Last Man Standing": + case "Last Man Standing (insta)": + case "Last Man Standing +": + case "Last Man Standing + (insta)": + case "Last Man Standing++": + case "Last Man Standing++ (insta)": + include("pages/match_info_lms.php"); + break; - default: - if ($teamgame) { - teamstats($mid, 'Match Summary'); - } else { - teamstats($mid, 'Player Summary'); - } + default: + if ($teamgame) { + teamstats($mid, 'Match Summary'); + } else { + teamstats($mid, 'Player Summary'); + } } if ($real_gamename == "Assault" or $real_gamename == "Assault (insta)") { - include("pages/match_info_other2.php"); + include("pages/match_info_other2.php"); } else if ($real_gamename != "Bunny Track") { - include("pages/match_info_other.php"); + include("pages/match_info_other.php"); } if ($real_gamename == "Capture the Flag" or $real_gamename == "Capture the Flag (insta)") { diff --git a/html/pages/match_info_ass.php b/html/pages/match_info_ass.php old mode 100755 new mode 100644 index df968ec..b5ecbb9 --- a/html/pages/match_info_ass.php +++ b/html/pages/match_info_ass.php @@ -41,9 +41,9 @@ $gametime2 = sec2min($gametime2); teamstats($mid, 'Match Summary - '.$ass_att.' Team Attacking', 'ass_obj', 'Ass Obj'); echo' - +
- +
'.$asswin.''.$asswin.'

'; @@ -54,9 +54,9 @@ IF($mid2 != NULL) { teamstats($mid2, 'Match Summary - '.$ass_att2.' Team Attacking', 'ass_obj', 'Ass Obj'); echo' - +
- +
'.$asswin2.''.$asswin2.'

'; diff --git a/html/pages/match_info_bt.php b/html/pages/match_info_bt.php old mode 100755 new mode 100644 index ed14e3d..16bee03 --- a/html/pages/match_info_bt.php +++ b/html/pages/match_info_bt.php @@ -8,7 +8,7 @@ while ($r_caprecords = mysql_fetch_array($q_caprecords)) { } */ echo' - +
diff --git a/html/pages/match_info_ctf.php b/html/pages/match_info_ctf.php old mode 100755 new mode 100644 index 7426a4e..378b831 --- a/html/pages/match_info_ctf.php +++ b/html/pages/match_info_ctf.php @@ -1,362 +1,362 @@ +
Game Summary
- + - + - - - - - - - - - - - + + + + + + + + + - - + + '; $sql_msred = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank -FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 0 ORDER BY gamescore DESC"; + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 0 ORDER BY gamescore DESC"; + $q_msred = mysql_query($sql_msred) or die(mysql_error()); $i = 0; + while ($r_msred = zero_out(mysql_fetch_array($q_msred))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - - $redpname = $r_msred[name]; - $myurl = urlencode($r_msred[name]); - - - - echo''; - if ($r_msred['banned'] != 'Y') { - echo ''; - } else { - $r_msred ['gamescore'] = '-'; - $r_msred ['flag_taken'] = '-'; - $r_msred ['flag_pickedup'] = '-'; - $r_msred ['flag_dropped'] = '-'; - $r_msred ['flag_assist'] = '-'; - $r_msred ['flag_cover'] = '-'; - $r_msred ['flag_seal'] = '-'; - $r_msred ['flag_capture'] = '-'; - $r_msred ['flag_kill'] = '-'; - $r_msred ['flag_return'] = '-'; - echo ''; - } - - echo ' - - - - - - - - - - - - '; + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $redpname = $r_msred[name]; + $myurl = urlencode($r_msred[name]); + + echo''; + + if ($r_msred['banned'] != 'Y') { + echo ''; + } else { + $r_msred ['gamescore'] = '-'; + $r_msred ['flag_taken'] = '-'; + $r_msred ['flag_pickedup'] = '-'; + $r_msred ['flag_dropped'] = '-'; + $r_msred ['flag_assist'] = '-'; + $r_msred ['flag_cover'] = '-'; + $r_msred ['flag_seal'] = '-'; + $r_msred ['flag_capture'] = '-'; + $r_msred ['flag_kill'] = '-'; + $r_msred ['flag_return'] = '-'; + echo ''; + } + + echo ' + + + + + + + + + + + + '; } $teamscore = small_query("SELECT t0score AS teamscore FROM uts_match WHERE id = $mid"); $msredtot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return -FROM uts_player WHERE matchid = $mid AND team = 0 ORDER BY gamescore DESC"); - + FROM uts_player WHERE matchid = $mid AND team = 0 ORDER BY gamescore DESC"); echo' + + + + + + + + + + + + + + + + + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - '; + + + + + + + + + + + + + + + +'; $sql_msblue = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank -FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 1 ORDER BY gamescore DESC"; + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 1 ORDER BY gamescore DESC"; + $q_msblue = mysql_query($sql_msblue) or die(mysql_error()); $i = 0; + while ($r_msblue = zero_out(mysql_fetch_array($q_msblue))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - - $bluepname = $r_msblue[name]; - $myurl = urlencode($r_msblue[name]); - - echo''; - if ($r_msblue['banned'] != 'Y') { - echo ''; - } else { - $r_msblue ['gamescore'] = '-'; - $r_msblue ['flag_taken'] = '-'; - $r_msblue ['flag_pickedup'] = '-'; - $r_msblue ['flag_dropped'] = '-'; - $r_msblue ['flag_assist'] = '-'; - $r_msblue ['flag_cover'] = '-'; - $r_msblue ['flag_seal'] = '-'; - $r_msblue ['flag_capture'] = '-'; - $r_msblue ['flag_kill'] = '-'; - $r_msblue ['flag_return'] = '-'; - echo ''; - } - - echo ' - - - - - - - - - - - - '; + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $bluepname = $r_msblue[name]; + $myurl = urlencode($r_msblue[name]); + + echo''; + if ($r_msblue['banned'] != 'Y') { + echo ''; + } else { + $r_msblue ['gamescore'] = '-'; + $r_msblue ['flag_taken'] = '-'; + $r_msblue ['flag_pickedup'] = '-'; + $r_msblue ['flag_dropped'] = '-'; + $r_msblue ['flag_assist'] = '-'; + $r_msblue ['flag_cover'] = '-'; + $r_msblue ['flag_seal'] = '-'; + $r_msblue ['flag_capture'] = '-'; + $r_msblue ['flag_kill'] = '-'; + $r_msblue ['flag_return'] = '-'; + echo ''; + } + + echo ' + + + + + + + + + + + + '; } $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); $msbluetot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return -FROM uts_player WHERE matchid = $mid AND team = 1 ORDER BY gamescore DESC"); + FROM uts_player WHERE matchid = $mid AND team = 1 ORDER BY gamescore DESC"); echo' - - - - - - - - - - - - - - '; + + + + + + + + + + + + + +'; // Check If Green Team Were Used (CTF4 Compatibility) - $greencheck = small_count("SELECT * FROM uts_player WHERE matchid = $mid AND team = 2"); -IF ($greencheck > 0) { - - echo' - - - - - - - - - - - - - - - - - - - '; - - $sql_msgreen = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank - FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 2 ORDER BY gamescore DESC"; - $q_msgreen = mysql_query($sql_msgreen) or die(mysql_error()); - $i = 0; - while ($r_msgreen = zero_out(mysql_fetch_array($q_msgreen))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - - $greenpname = $r_msgreen[name]; - $myurl = urlencode($r_msgreen[name]); - - echo''; - if ($r_msgreen['banned'] != 'Y') { - echo ''; - } else { - $r_msgreen ['gamescore'] = '-'; - $r_msgreen ['flag_taken'] = '-'; - $r_msgreen ['flag_pickedup'] = '-'; - $r_msgreen ['flag_dropped'] = '-'; - $r_msgreen ['flag_assist'] = '-'; - $r_msgreen ['flag_cover'] = '-'; - $r_msgreen ['flag_seal'] = '-'; - $r_msgreen ['flag_capture'] = '-'; - $r_msgreen ['flag_kill'] = '-'; - $r_msgreen ['flag_return'] = '-'; - echo ''; - } - - echo ' - - - - - - - - - - - - '; - } - - $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); - $msgreentot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return - FROM uts_player WHERE matchid = $mid AND team = 2 ORDER BY gamescore DESC"); - - echo' - - - - - - - - - - - - - - '; +if ($greencheck > 0) { + echo' + + + + + + + + + + + + + + + + + + + '; + + $sql_msgreen = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 2 ORDER BY gamescore DESC"; + + $q_msgreen = mysql_query($sql_msgreen) or die(mysql_error()); + $i = 0; + + while ($r_msgreen = zero_out(mysql_fetch_array($q_msgreen))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $greenpname = $r_msgreen[name]; + $myurl = urlencode($r_msgreen[name]); + + echo''; + if ($r_msgreen['banned'] != 'Y') { + echo ''; + } else { + $r_msgreen ['gamescore'] = '-'; + $r_msgreen ['flag_taken'] = '-'; + $r_msgreen ['flag_pickedup'] = '-'; + $r_msgreen ['flag_dropped'] = '-'; + $r_msgreen ['flag_assist'] = '-'; + $r_msgreen ['flag_cover'] = '-'; + $r_msgreen ['flag_seal'] = '-'; + $r_msgreen ['flag_capture'] = '-'; + $r_msgreen ['flag_kill'] = '-'; + $r_msgreen ['flag_return'] = '-'; + echo ''; + } + + echo ' + + + + + + + + + + + + '; + } + + $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); + $msgreentot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return + FROM uts_player WHERE matchid = $mid AND team = 2 ORDER BY gamescore DESC"); + + echo ' + + + + + + + + + + + + + + '; } // Check If Gold Team Were Used (CTF4 Compatibility) - $goldcheck = small_count("SELECT * FROM uts_player WHERE matchid = $mid AND team = 3"); -IF ($goldcheck > 0) { - - echo' - - - - - - - - - - - - - - - - - - - '; - - $sql_msgold = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank - FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 3 ORDER BY gamescore DESC"; - $q_msgold = mysql_query($sql_msgold) or die(mysql_error()); - $i = 0; - while ($r_msgold = zero_out(mysql_fetch_array($q_msgold))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - - $goldpname = $r_msgold[name]; - $myurl = urlencode($r_msgold[name]); - - echo''; - if ($r_msgold['banned'] != 'Y') { - echo ''; - } else { - $r_msgold ['gamescore'] = '-'; - $r_msgold ['flag_taken'] = '-'; - $r_msgold ['flag_pickedup'] = '-'; - $r_msgold ['flag_dropped'] = '-'; - $r_msgold ['flag_assist'] = '-'; - $r_msgold ['flag_cover'] = '-'; - $r_msgold ['flag_seal'] = '-'; - $r_msgold ['flag_capture'] = '-'; - $r_msgold ['flag_kill'] = '-'; - $r_msgold ['flag_return'] = '-'; - echo ''; - } - - echo ' - - - - - - - - - - - - '; - } - - $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); - $msgoldtot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return - FROM uts_player WHERE matchid = $mid AND team = 3 ORDER BY gamescore DESC"); - - echo' - - - - - - - - - - - - - - '; +if ($goldcheck > 0) { + echo ' + + + + + + + + + + + + + + + + + + + + '; + + $sql_msgold = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 3 ORDER BY gamescore DESC"; + $q_msgold = mysql_query($sql_msgold) or die(mysql_error()); + $i = 0; + + while ($r_msgold = zero_out(mysql_fetch_array($q_msgold))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $goldpname = $r_msgold[name]; + $myurl = urlencode($r_msgold[name]); + + echo''; + if ($r_msgold['banned'] != 'Y') { + echo ''; + } else { + $r_msgold ['gamescore'] = '-'; + $r_msgold ['flag_taken'] = '-'; + $r_msgold ['flag_pickedup'] = '-'; + $r_msgold ['flag_dropped'] = '-'; + $r_msgold ['flag_assist'] = '-'; + $r_msgold ['flag_cover'] = '-'; + $r_msgold ['flag_seal'] = '-'; + $r_msgold ['flag_capture'] = '-'; + $r_msgold ['flag_kill'] = '-'; + $r_msgold ['flag_return'] = '-'; + echo ''; + } + + echo ' + + + + + + + + + + + + '; + } + + $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); + $msgoldtot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return + FROM uts_player WHERE matchid = $mid AND team = 3 ORDER BY gamescore DESC"); + + echo ' + + + + + + + + + + + + + + '; } -echo'
Flag Event SummaryFlag Event Summary
Team: RedTeam: Red
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag ReturnPlayer + ScoreFlag TakenFlag PickupFlag DropFlag Assist + Flag CoverFlag SealFlag CapsFlag KillFlag Return
TeamPlayerTeamPlayer
'.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''.$r_msred[gamescore].''.$r_msred[flag_taken].''.$r_msred[flag_pickedup].''.$r_msred[flag_dropped].''.$r_msred[flag_assist].''.$r_msred[flag_cover].''.$r_msred[flag_seal].''.$r_msred[flag_capture].''.$r_msred[flag_kill].''.$r_msred[flag_return].'
'.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''.$r_msred[gamescore].''.$r_msred[flag_taken].''.$r_msred[flag_pickedup].''.$r_msred[flag_dropped].''.$r_msred[flag_assist].''.$r_msred[flag_cover].''.$r_msred[flag_seal].''.$r_msred[flag_capture].''.$r_msred[flag_kill].''.$r_msred[flag_return].'
Totals'.$teamscore[teamscore].''.$msredtot[gamescore].''.$msredtot[flag_taken].''.$msredtot[flag_pickedup].''.$msredtot[flag_dropped].''.$msredtot[flag_assist].''.$msredtot[flag_cover].''.$msredtot[flag_seal].''.$msredtot[flag_capture].''.$msredtot[flag_kill].''.$msredtot[flag_return].'
Team: Blue
Totals'.$teamscore[teamscore].''.$msredtot[gamescore].''.$msredtot[flag_taken].''.$msredtot[flag_pickedup].''.$msredtot[flag_dropped].''.$msredtot[flag_assist].''.$msredtot[flag_cover].''.$msredtot[flag_seal].''.$msredtot[flag_capture].''.$msredtot[flag_kill].''.$msredtot[flag_return].'
Team: Blue
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag Return
TeamPlayer
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CapsFlag KillFlag Return
TeamPlayer
'.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''.$r_msblue[gamescore].''.$r_msblue[flag_taken].''.$r_msblue[flag_pickedup].''.$r_msblue[flag_dropped].''.$r_msblue[flag_assist].''.$r_msblue[flag_cover].''.$r_msblue[flag_seal].''.$r_msblue[flag_capture].''.$r_msblue[flag_kill].''.$r_msblue[flag_return].'
'.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''.$r_msblue[gamescore].''.$r_msblue[flag_taken].''.$r_msblue[flag_pickedup].''.$r_msblue[flag_dropped].''.$r_msblue[flag_assist].''.$r_msblue[flag_cover].''.$r_msblue[flag_seal].''.$r_msblue[flag_capture].''.$r_msblue[flag_kill].''.$r_msblue[flag_return].'
Totals'.$teamscore[teamscore].''.$msbluetot[gamescore].''.$msbluetot[flag_taken].''.$msbluetot[flag_pickedup].''.$msbluetot[flag_dropped].''.$msbluetot[flag_assist].''.$msbluetot[flag_cover].''.$msbluetot[flag_seal].''.$msbluetot[flag_capture].''.$msbluetot[flag_kill].''.$msbluetot[flag_return].'
Totals'.$teamscore[teamscore].''.$msbluetot[gamescore].''.$msbluetot[flag_taken].''.$msbluetot[flag_pickedup].''.$msbluetot[flag_dropped].''.$msbluetot[flag_assist].''.$msbluetot[flag_cover].''.$msbluetot[flag_seal].''.$msbluetot[flag_capture].''.$msbluetot[flag_kill].''.$msbluetot[flag_return].'
Team: Green
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag Return
TeamPlayer
'.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''.$r_msgreen[gamescore].''.$r_msgreen[flag_taken].''.$r_msgreen[flag_pickedup].''.$r_msgreen[flag_dropped].''.$r_msgreen[flag_assist].''.$r_msgreen[flag_cover].''.$r_msgreen[flag_seal].''.$r_msgreen[flag_capture].''.$r_msgreen[flag_kill].''.$r_msgreen[flag_return].'
Totals'.$teamscore[teamscore].''.$msgreentot[gamescore].''.$msgreentot[flag_taken].''.$msgreentot[flag_pickedup].''.$msgreentot[flag_dropped].''.$msgreentot[flag_assist].''.$msgreentot[flag_cover].''.$msgreentot[flag_seal].''.$msgreentot[flag_capture].''.$msgreentot[flag_kill].''.$msgreentot[flag_return].'
Team: Green
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag Return
TeamPlayer
'.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''.$r_msgreen[gamescore].''.$r_msgreen[flag_taken].''.$r_msgreen[flag_pickedup].''.$r_msgreen[flag_dropped].''.$r_msgreen[flag_assist].''.$r_msgreen[flag_cover].''.$r_msgreen[flag_seal].''.$r_msgreen[flag_capture].''.$r_msgreen[flag_kill].''.$r_msgreen[flag_return].'
Totals'.$teamscore[teamscore].''.$msgreentot[gamescore].''.$msgreentot[flag_taken].''.$msgreentot[flag_pickedup].''.$msgreentot[flag_dropped].''.$msgreentot[flag_assist].''.$msgreentot[flag_cover].''.$msgreentot[flag_seal].''.$msgreentot[flag_capture].''.$msgreentot[flag_kill].''.$msgreentot[flag_return].'
Team: Gold
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag Return
TeamPlayer
'.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''.$r_msgold[gamescore].''.$r_msgold[flag_taken].''.$r_msgold[flag_pickedup].''.$r_msgold[flag_dropped].''.$r_msgold[flag_assist].''.$r_msgold[flag_cover].''.$r_msgold[flag_seal].''.$r_msgold[flag_capture].''.$r_msgold[flag_kill].''.$r_msgold[flag_return].'
Totals'.$teamscore[teamscore].''.$msgoldtot[gamescore].''.$msgoldtot[flag_taken].''.$msgoldtot[flag_pickedup].''.$msgoldtot[flag_dropped].''.$msgoldtot[flag_assist].''.$msgoldtot[flag_cover].''.$msgoldtot[flag_seal].''.$msgoldtot[flag_capture].''.$msgoldtot[flag_kill].''.$msgoldtot[flag_return].'
Team: Gold
PlayerScoreFlag TakenFlag PickupFlag DropFlag AssistFlag CoverFlag SealFlag CaptureFlag KillFlag Return
TeamPlayer
'.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''.$r_msgold[gamescore].''.$r_msgold[flag_taken].''.$r_msgold[flag_pickedup].''.$r_msgold[flag_dropped].''.$r_msgold[flag_assist].''.$r_msgold[flag_cover].''.$r_msgold[flag_seal].''.$r_msgold[flag_capture].''.$r_msgold[flag_kill].''.$r_msgold[flag_return].'
Totals'.$teamscore[teamscore].''.$msgoldtot[gamescore].''.$msgoldtot[flag_taken].''.$msgoldtot[flag_pickedup].''.$msgoldtot[flag_dropped].''.$msgoldtot[flag_assist].''.$msgoldtot[flag_cover].''.$msgoldtot[flag_seal].''.$msgoldtot[flag_capture].''.$msgoldtot[flag_kill].''.$msgoldtot[flag_return].'
+echo '
'; ?> diff --git a/html/pages/match_info_killsmatrix.php b/html/pages/match_info_killsmatrix.php old mode 100755 new mode 100644 index be16905..3b425e5 --- a/html/pages/match_info_killsmatrix.php +++ b/html/pages/match_info_killsmatrix.php @@ -55,13 +55,15 @@ while ($r_players = mysql_fetch_array($q_players)) { // Table header $extra = $teamgame ? 3 : 2; -echo ' +echo ' + +
+ - + - - + '; @@ -69,11 +71,15 @@ echo '
Kills Match UpKills Match Up
 Victim
foreach($players as $player) { - echo ''; + + echo ''; } echo ''; @@ -81,13 +87,13 @@ echo ''; if ($teamgame) { foreach($players as $player) { switch($player['team']) { - case 0: $teamcolor = 'redteam'; break; - case 1: $teamcolor = 'blueteam'; break; - case 2: $teamcolor = 'greenteam'; break; - case 3: $teamcolor = 'goldteam'; break; + case 0: $teamcolor = 'redteamb'; break; + case 1: $teamcolor = 'blueteamb'; break; + case 2: $teamcolor = 'greenteamb'; break; + case 3: $teamcolor = 'goldteamb'; break; } - echo ''; + echo ''; } echo ''; } @@ -98,24 +104,24 @@ $i = 0; foreach($players as $kid => $killer) { if ($killer['banned'] == 'Y') continue; $i++; - echo ''; - if ($first) echo''; - echo ''; + if ($first) echo''; + echo ''; if ($teamgame) { switch($killer['team']) { - case 0: $teamcolor = 'redteam'; break; - case 1: $teamcolor = 'blueteam'; break; - case 2: $teamcolor = 'greenteam'; break; - case 3: $teamcolor = 'goldteam'; break; + case 0: $teamcolor = 'redteamb'; break; + case 1: $teamcolor = 'blueteamb'; break; + case 2: $teamcolor = 'greenteamb'; break; + case 3: $teamcolor = 'goldteamb'; break; } - echo ''; + echo ''; } foreach($players as $vid => $victim) { - $class = ($kid == $vid) ? 'darkgrey' : 'grey'; + $class = ($kid == $vid) ? 'suicide' : 'killCell'; //if ($i % 2) $class .= '2'; - echo ' + + +
- '. - PrintVertical($player['name']) . - ' +
'; + if (strlen($player['name']) > 10) { +echo substr($player['name'],0,10); +} else { +echo $player['name'] ; +}; +'
-   +
K
i
l
l
e
r		'; - echo ''. + echo '
'; + echo ''. FormatPlayerName($killer['country'], $killer['pid'], $killer['name'], $gid, $gamename) .'  '; + echo ''; if ($kid == $vid) { $val = ($killer['suicides'] != 0) ? $killer['suicides'] : ' '; } else { diff --git a/html/pages/match_info_lms.php b/html/pages/match_info_lms.php old mode 100755 new mode 100644 index 1c6aa05..3caffaa --- a/html/pages/match_info_lms.php +++ b/html/pages/match_info_lms.php @@ -16,7 +16,7 @@ echo' - +
'; @@ -50,19 +50,20 @@ $header = false; echo ' - - - - - - - - '; - if ($teams) echo ''; + + + '; + if ($extra) echo' '; + echo' + + + + '; + if ($teams) echo ''; echo ' - - - + + + '; } diff --git a/html/pages/match_info_other.php b/html/pages/match_info_other.php index 21dfca4..7f9cf18 100755 --- a/html/pages/match_info_other.php +++ b/html/pages/match_info_other.php @@ -1,124 +1,138 @@ -
Player Summary
PlayerTimeScoreOutFKDSTKPlayerTimeScore'.htmlentities($extratitle).'FKDSTKEff.Acc.Avg TTLEff.Acc.Avg TTL
- - - +echo '
+
Special Events
+ - - - - + + + + + + + - - - - - - - - - + + + + + + + + + '; $sql_firstblood = small_query("SELECT firstblood FROM uts_match WHERE id = $mid"); $sql_multis = "SELECT p.pid, pi.name, p.country, SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, -SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, -SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, -SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god -FROM uts_player as p, uts_pinfo AS pi -WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid -GROUP BY pid, p.country -ORDER BY name ASC"; + SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, + SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, + SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god + FROM uts_player as p, uts_pinfo AS pi + WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid + GROUP BY pid, p.country + ORDER BY name ASC"; $q_multis = mysql_query($sql_multis) or die(mysql_error()); $i = 0; + while ($r_multis = zero_out(mysql_fetch_array($q_multis))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - $r_pname = $r_multis[name]; - $myurl = urlencode($r_pname); + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + $r_pname = $r_multis[name]; + $myurl = urlencode($r_pname); echo' - - - - - - - - - - - - + + + + + + + + + + + + '; } // No items in insta matches or lms -if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Standing") === false)) { - echo'
PlayerFirst BloodMultisSpreesSpecial Events
First BloodMultisSprees
DblMultiUltraMonsKillRamDomUnsGodDblMultiUltraMonsKillRamDomUnsGod
'.FormatPlayerName($r_multis[country], $r_multis[pid], $r_pname, $gid, $gamename).'', ($sql_firstblood['firstblood'] == $r_multis['pid'] ? "Yes": ""), ''.$r_multis[spree_double].''.$r_multis[spree_multi].''.$r_multis[spree_ultra].''.$r_multis[spree_monster].''.$r_multis[spree_kill].''.$r_multis[spree_rampage].''.$r_multis[spree_dom].''.$r_multis[spree_uns].''.$r_multis[spree_god].'
'.FormatPlayerName($r_multis[country], $r_multis[pid], $r_pname, $gid, $gamename).'', ($sql_firstblood['firstblood'] == $r_multis['pid'] ? "Yes": ""), ''.$r_multis[spree_double].''.$r_multis[spree_multi].''.$r_multis[spree_ultra].''.$r_multis[spree_monster].''.$r_multis[spree_kill].''.$r_multis[spree_rampage].''.$r_multis[spree_dom].''.$r_multis[spree_uns].''.$r_multis[spree_god].'

- - - - - - - - - - - - - '; - - $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, - SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp - FROM uts_player as p, uts_pinfo AS pi - WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid - GROUP BY pid, p.country - ORDER BY name ASC"; +if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Standing") === false) && (strpos($gamename, "iCTF") === false) && (strpos($gamename, "iTDM") === false) && (strpos($gamename, "iDM") === false) && (strpos($gamename, "iDOM") === false)) { + + $anyPickups = false; + $contentTable = ""; + + $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, + SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp, SUM(p.pu_boots) AS pu_boots + FROM uts_player as p, uts_pinfo AS pi + WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid + GROUP BY pid, p.country + ORDER BY name ASC"; + + $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); + $i = 0; - $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); - $i = 0; - while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { - $i++; - $class = ($i % 2) ? 'grey' : 'grey2'; - $r_pname = $r_pickups[name]; - $myurl = urlencode($r_pname); - - echo' - - - - - - - - - '; - } + while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + $r_pname = $r_pickups[name]; + $myurl = urlencode($r_pname); + + if(!$anyPickups && ($r_pickups[pu_pads] > 0 || $r_pickups[pu_armour] > 0 || $r_pickups[pu_keg] > 0 || $r_pickups[pu_invis] > 0 || $r_pickups[pu_belt] > 0 || $r_pickups[pu_amp] > 0 || $r_pickups[pu_boots] > 0)) + $anyPickups = true; + + $contentTable .= ' + + + + + + + + + + '; + } + + if ($anyPickups) { + echo '
Pickups Summary
PlayerPadsArmourKegInvisibilityShield
Belt		Damage Amp
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).''.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].'
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).''.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].''.$r_pickups[pu_boots].'

+ + + + + + + + + + + + + + '; + + echo $contentTable; + } } + echo'
Pickups Summary
PadsArmourKegInvisibilityShield
Belt		Damage AmpAntigrav Boots
'; -/* $sql_firstblood = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid"); -if (!$sql_firstblood) $sql_firstblood = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL); +/* +// To add when forum widget is available + +echo ' +
+ +
'; +*/ -echo' -
- - - - - - - - -
First Blood
'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'
'; */ ?> diff --git a/html/pages/match_info_other2.php b/html/pages/match_info_other2.php old mode 100755 new mode 100644 index 1f72fdd..e25d426 --- a/html/pages/match_info_other2.php +++ b/html/pages/match_info_other2.php @@ -11,7 +11,7 @@ IF($mid2 != NULL) { echo'
- +
@@ -53,7 +53,7 @@ IF($mid2 == NULL) { } else { echo'
Pickups Summary - '.$ass_att.' Attacking

- +
@@ -81,7 +81,7 @@ IF($mid2 == NULL) { echo' - + @@ -104,32 +104,32 @@ $sql_multis2 = small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_ } echo'
Pickups Summary - '.$ass_att2.' Attacking
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).''.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).' '.$r_pickups[pu_pads].' '.$r_pickups[pu_armour].' '.$r_pickups[pu_keg].'

- +
- - + + - - - - + + + + - - - - + + - - - - + + + + - - + + diff --git a/html/pages/match_player.php b/html/pages/match_player.php index 63a3787..55c1892 100755 --- a/html/pages/match_player.php +++ b/html/pages/match_player.php @@ -4,9 +4,7 @@ $pid = preg_replace('/\D/', '', $_GET[pid]); $r_infos = small_query("SELECT p.playerid, p.country, pi.name, pi.banned, p.gid, g.name AS gamename FROM uts_player p, uts_pinfo pi, uts_games g - WHERE p.gid = g.id AND p.pid = pi.id AND p.pid = '$pid' - AND matchid = '$mid' - LIMIT 0,1;"); + WHERE p.gid = g.id AND p.pid = pi.id AND p.pid = '$pid' AND matchid = '$mid' LIMIT 0,1;"); if (!$r_infos) { echo "Unable to retrieve data!"; @@ -30,76 +28,90 @@ $country = $r_infos['country']; $gamename = $r_infos['gamename']; $gid = $r_infos['gid']; -echo' -
Special Events - '.$ass_att.' AttackingSpecial Events - '.$ass_att2.' AttackingSpecial Events - '.$ass_att.' AttackingSpecial Events - '.$ass_att2.' Attacking
First Blood'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'First Blood'.FormatPlayerName($sql_firstblood2[country], $sql_firstblood[firstblood], $sql_firstblood2[name], $gid, $gamename).'First Blood'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'First Blood'.FormatPlayerName($sql_firstblood2[country], $sql_firstblood[firstblood], $sql_firstblood2[name], $gid, $gamename).'
Double Kills'.$sql_multis[spree_double].'Double Kills'.$sql_multis2[spree_double].'Double Kills'.$sql_multis[spree_double].' + Double Kills + '.$sql_multis2[spree_double].'
Multi Kills'.$sql_multis[spree_multi].'Multi Kills'.$sql_multis2[spree_multi].'Multi Kills'.$sql_multis[spree_multi].'Multi Kills'.$sql_multis2[spree_multi].'
Ultra Kills'.$sql_multis[spree_ultra].'Ultra Kills'.$sql_multis[spree_ultra].' Ultra Kills '.$sql_multis2[spree_ultra].'
- - +echo ' +
Individual Match Stats for - '.FlagImage($country) .' '. htmlentities($playername) .' - '. RankImageOrText($pid, $playername, NULL, $gid, $gamename, true, '(%IT% in %GN% with %RP% ranking points)') .' -
+ + + -
Individual Match Stats for
-
'; +
'.FlagImage($country) .' '. htmlentities($playername) .' + '. RankImageOrText($pid, $playername, NULL, $gid, $gamename, true, '(%IT% in %GN% with %RP% ranking points)') .' +
+ Player page + '; + + if (PlayerOnWatchlist($pid)) { + echo 'Remove from Watchlist'; + } else { + echo 'Add to Watchlist'; + }; + +echo ' +

'; // Get Summary Info include("pages/match_info_server.php"); echo '
- - - +
Game Summary
+ + + - - - - - - - - + + + + + + + + '; -$r_gsumm = zero_out(small_query("SELECT gamescore, frags, SUM(frags+suicides) AS kills, deaths, suicides, teamkills, eff, accuracy, ttl, gametime, spree_kill, spree_rampage, spree_dom, spree_uns, spree_god - FROM uts_player - WHERE matchid = $mid AND pid = '$pid' - GROUP BY pid, gamescore, frags, deaths, suicides, teamkills, eff, accuracy, ttl, gametime, spree_kill, spree_rampage, spree_dom, spree_uns, spree_god")); + $r_gsumm = zero_out(small_query("SELECT gamescore, frags, SUM(frags+suicides) AS kills, deaths, suicides, teamkills, eff, accuracy, ttl, gametime, spree_kill, spree_rampage, spree_dom, spree_uns, spree_god + FROM uts_player + WHERE matchid = $mid AND pid = '$pid' + GROUP BY pid, gamescore, frags, deaths, suicides, teamkills, eff, accuracy, ttl, gametime, spree_kill, spree_rampage, spree_dom, spree_uns, spree_god")); - echo' +echo ' - - - - - - - - - '; - -echo' -
Game Summary
FragsKillsDeathsSuicidesEfficiencyAccuracyAvg TTLTimeFragsKillsDeathsSuicidesEfficiencyAccuracyAvg TTLTime
'.$r_gsumm[frags].''.$r_gsumm[kills].''.$r_gsumm[deaths].''.$r_gsumm[suicides].''.$r_gsumm[eff].''.$r_gsumm[accuracy].''.$r_gsumm[ttl].''.GetMinutes($r_gsumm[gametime]).'
+ '.$r_gsumm[frags].' + '.$r_gsumm[kills].' + '.$r_gsumm[deaths].' + '.$r_gsumm[suicides].' + '.$r_gsumm[eff].' + '.$r_gsumm[accuracy].' + '.$r_gsumm[ttl].' + '.GetMinutes($r_gsumm[gametime]).' + + +
- - - +
Special Events
+ + + - - - + + + - - - - - - - - - + + + + + + + + + '; $r_gsumm = zero_out(small_query("SELECT spree_double, spree_multi, spree_ultra, spree_monster, spree_kill, spree_rampage, spree_dom, spree_uns, spree_god @@ -117,40 +129,41 @@ if ($sql_firstblood[firstblood] == $pid) { echo' - - - - - - - - - - + + + + + + + + + + -
Special Events
First BloodMultisSpreesFirst BloodMultisSprees
DblMultiUltraMonsKillRamDomUnsGodDblMultiUltraMonsKillRamDomUnsGod
'.$firstblood.''.$r_gsumm[spree_double].''.$r_gsumm[spree_multi].''.$r_gsumm[spree_ultra].''.$r_gsumm[spree_monster].''.$r_gsumm[spree_kill].''.$r_gsumm[spree_rampage].''.$r_gsumm[spree_dom].''.$r_gsumm[spree_uns].''.$r_gsumm[spree_god].''.$firstblood.''.$r_gsumm[spree_double].''.$r_gsumm[spree_multi].''.$r_gsumm[spree_ultra].''.$r_gsumm[spree_monster].''.$r_gsumm[spree_kill].''.$r_gsumm[spree_rampage].''.$r_gsumm[spree_dom].''.$r_gsumm[spree_uns].''.$r_gsumm[spree_god].'
+ +
'; include('includes/weaponstats.php'); weaponstats($mid, $pid); $r_pings = small_query("SELECT lowping, avgping, highping FROM uts_player WHERE pid = $pid and matchid = $mid and lowping > 0"); + if ($r_pings and $r_pings['lowping']) { - echo ' -
- + echo '
+
- + - - - + + + - - - + + +
PingsPings
MinAvgMaxMinAvgMax
'.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).''.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).'
'; } diff --git a/html/pages/match_report.php b/html/pages/match_report.php old mode 100755 new mode 100644 index 0f452ba..05fd413 --- a/html/pages/match_report.php +++ b/html/pages/match_report.php @@ -1,16 +1,13 @@ +echo'
- + - - - - +
Match ReportsMatch Report
Clanbase Cup Format
Forum BBCode FormatForum BBCode Format
'; diff --git a/html/pages/players_explain_ranking.php b/html/pages/players_explain_ranking.php old mode 100755 new mode 100644 index 5930cfb..4648c3c --- a/html/pages/players_explain_ranking.php +++ b/html/pages/players_explain_ranking.php @@ -14,10 +14,10 @@ function row($name = NULL, $amount = 0, $multiplier = 0, $extra_multiplier = tru $d_points = get_dp($points); if ($points % 1 == 0) $d_points = ceil($points); echo ''; - echo ''. htmlentities($name) .''; - echo ''. $amount .''; - echo ''. $multiplier .''; - echo ''. $d_points .''; + echo ''. htmlentities($name) .''; + echo ''. $amount .''; + echo ''. $multiplier .''; + echo ''. $d_points .''; echo ''; return($points); } @@ -69,22 +69,16 @@ $r_cnt = small_query("SELECT -echo' - - - - -
'.FlagImage($r_info['country'], false).' '.htmlentities($playername).'\'s '. htmlentities($r_game['name']) .' ranking explained
'; -echo '

'; - - - echo ' - +
+ + + + @@ -111,7 +105,7 @@ else { $t_points += row('Deaths', $r_cnt['deaths'], -0.25); $t_points += row('Suicides', $r_cnt['suicides'], -0.25 ); $t_points += row('Teamkills', $r_cnt['teamkills'], -2); - row(); +echo ''; $t_points += row('Flag Takes', $r_cnt['flag_taken'], 1); $t_points += row('Flag Pickups', $r_cnt['flag_pickedup'], 1); $t_points += row('Flag Returns', $r_cnt['flag_return'], 1); @@ -120,7 +114,7 @@ else { $t_points += row('Flag Seals', $r_cnt['flag_seal'], 2); $t_points += row('Flag Assists', $r_cnt['flag_assist'], 5); $t_points += row('Flag Kills', $r_cnt['flag_kill'], 2); - row(); +echo ''; $t_points += row('Controlpoint Captures', $r_cnt['dom_cp'], 10); if (strpos($real_gamename, 'Assault') !== false) { $t_points += row('Assault Objectives', $r_cnt['ass_obj'], 10); @@ -132,33 +126,33 @@ else { } else { $t_points += row('Team Releases', 0, 1.5); } - row(); +echo ''; $t_points += row('Double Kills', $r_cnt['spree_double'], 1); $t_points += row('Multi Kills', $r_cnt['spree_multi'], 1); $t_points += row('Ultra Kills', $r_cnt['spree_ultra'], 1); $t_points += row('Monster Kills', $r_cnt['spree_monster'], 2); - row(); +echo ''; $t_points += row('Killing Sprees', $r_cnt['spree_kill'], 1); $t_points += row('Rampages', $r_cnt['spree_rampage'], 1); $t_points += row('Dominatings', $r_cnt['spree_dom'], 1.5); $t_points += row('Unstoppables', $r_cnt['spree_uns'], 2); $t_points += row('Godlikes', $r_cnt['spree_god'], 3); -} - -row(); -row(); -echo ' - - - +}; + +echo ''; + +echo ' + + + '; $gametime = ceil($r_cnt['gametime'] / 60); $t_points = $t_points / $gametime; -echo ' - - - +echo ' + + + '; IF ($gametime < 10) { @@ -180,11 +174,11 @@ IF ($gametime >= 100 && $gametime < 200) { IF ($gametime >= 200 && $gametime < 300) { $t_points += row('Penalty for playing < 300 minutes', get_dp($t_points), -0.15, false); } -row(); -echo ' - - - +echo ''; +echo ' + + + '; echo '
'.FlagImage($r_info['country'], false).' '.htmlentities($playername).'\'s '. htmlentities($r_game['name']) .' ranking explained
Amount Multiplier
Total'. ceil($t_points) .'
Total'. ceil($t_points) .'
Divided by game minutes'.$gametime.''. get_dp($t_points) .'
Divided by game minutes'.$gametime.''. get_dp($t_points) .'
Total'. get_dp($t_points) .'
Ranking points'. get_dp($t_points) .'
'; ?> diff --git a/html/pages/players_info.php b/html/pages/players_info.php index f4d131c..e0e4546 100755 --- a/html/pages/players_info.php +++ b/html/pages/players_info.php @@ -1,293 +1,302 @@ "; - } else { - echo "Sorry, this player has been banned!"; - include("includes/footer.php"); - exit; - } + if (isset($is_admin) and $is_admin) { + echo "Warning: Banned player - Admin override
"; + } else { + echo "Sorry, this player has been banned!"; + include("includes/footer.php"); + exit; + } } $playername = $r_info['name']; if (isset($_GET['togglewatch'])) { - $status = ToggleWatchStatus($pid); - include('includes/header.php'); - if ($status == 1) { - echo htmlentities($playername) ." has been added to your watchlist"; - } else { - echo htmlentities($playername) ." has been removed from your watchlist"; - } - echo "
"; - $target = $PHP_SELF .'?p=pinfo&pid='. $pid; - echo 'You will be taken back to the '. htmlentities($playername) .'\'s page in a moment.'; - echo ''; - return; + $status = ToggleWatchStatus($pid); + include('includes/header.php'); + + if ($status == 1) { + echo "

Added!

" .htmlentities($playername)." has been added to your watchlist"; + } else { + echo "

Removed!

" .htmlentities($playername) ." has been removed from your watchlist"; + } + + echo "
"; + $target = $PHP_SELF .'?p=pinfo&pid='. $pid; + echo 'Do you want to go to '. htmlentities($playername) .'\'s page or go to your Watchlist?.
Player page Watchlist'; + echo '
Or search another player:
+
'; + return; } - if (isset($_GET['pics'])) { - $gid = $_GET['gid']; - $gid = preg_replace("/\D/", "", $gid); - if (!$pic_enable) { - echo "Sorry, pictures are disabled by the administrator"; - return; - } - $oururl = $_SERVER["HTTP_HOST"].$_SERVER["PHP_SELF"]; - $oururl = str_replace("index.php", "", $oururl); - - echo '
'; - require('includes/config_pic.php'); - $disp = false; - foreach($pic as $num => $options) { - if (!$options['enabled']) continue; - if ($options['gidrequired'] and empty($gid)) continue; - $disp = true; - $pinfourl = "http://${oururl}?p=pinfo&pid=$pid"; - $lgid = ($options['gidrequired']) ? $gid : 0; - $imgurl = "http://${oururl}pic.php/$num/$pid/$lgid/.".$options['output']['type']; - echo ''; - echo ''; - echo ''; - echo ''; - echo ''; - echo ''; - echo '
BB Code:
HTML Code:


'; + $gid = $_GET['gid']; + $gid = preg_replace("/\D/", "", $gid); + + if (!$pic_enable) { + echo "Sorry, pictures are disabled by the administrator"; + return; + } + + $oururl = $_SERVER["HTTP_HOST"].$_SERVER["PHP_SELF"]; + $oururl = str_replace("index.php", "", $oururl); + + echo '
'; + require('includes/config_pic.php'); + $disp = false; + + foreach($pic as $num => $options) { + if (!$options['enabled']) continue; + if ($options['gidrequired'] and empty($gid)) continue; + $disp = true; + $pinfourl = "http://${oururl}?p=pinfo&pid=$pid"; + $lgid = ($options['gidrequired']) ? $gid : 0; + $imgurl = "http://${oururl}pic.php/$num/$pid/$lgid/.".$options['output']['type']; + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + echo '
BB Code:
HTML Code:


'; + } + if (!$disp) { + echo "Sorry, no pictures in this category"; } - if (!$disp) echo "Sorry, no pictures in this category"; - echo '
'; - return; + echo '
'; + return; } - - - - -echo' - - - '; -} +$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' -
Career Summary for '.FlagImage($r_info['country'], false).' '.htmlentities($playername).' '; +echo ' + + + + - - - - - - - - - - - - - - '; +echo ' + + + + + + + + + + + + + + +'; $sql_plist = "SELECT g.name AS gamename, SUM(p.gamescore) AS gamescore, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.deaths) AS deaths, -SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, -COUNT(p.id) AS games, SUM(p.gametime) as gametime -FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id AND p.pid = '$pid' GROUP BY p.gid"; + SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, + COUNT(p.id) AS games, SUM(p.gametime) as gametime + FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id AND p.pid = '$pid' GROUP BY p.gid"; $q_plist = mysql_query($sql_plist) or die(mysql_error()); + while ($r_plist = mysql_fetch_array($q_plist)) { + $gametime = sec2hour($r_plist[gametime]); + $eff = get_dp($r_plist[kills]/$r_plist[sumeff]*100); + $acc = get_dp($r_plist[accuracy]); + $ttl = GetMinutes($r_plist[ttl]); - $gametime = sec2hour($r_plist[gametime]); - $eff = get_dp($r_plist[kills]/$r_plist[sumeff]*100); - $acc = get_dp($r_plist[accuracy]); - $ttl = GetMinutes($r_plist[ttl]); - - echo' - - - - - - - - - - - - - '; + echo' + + + + + + + + + + + + + + '; } $r_sumplist = small_query("SELECT SUM(gamescore) AS gamescore, SUM(frags) AS frags, SUM(kills) AS kills, SUM(deaths) AS deaths, -SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, -AVG(accuracy) AS accuracy, AVG(ttl) AS ttl, COUNT(id) AS games, SUM(gametime) as gametime -FROM uts_player WHERE pid = '$pid'"); + SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, + AVG(accuracy) AS accuracy, AVG(ttl) AS ttl, COUNT(id) AS games, SUM(gametime) as gametime + FROM uts_player WHERE pid = '$pid'"); $gametime = sec2hour($r_sumplist[gametime]); $eff = get_dp($r_sumplist[kills]/$r_sumplist[sumeff]*100); $acc = get_dp($r_sumplist[accuracy]); $ttl = GetMinutes($r_sumplist[ttl]); - echo' - - - - - - - - - - - - - - +echo' + + + + + + + + + + + + + +
Career Summary for '.htmlentities($playername).' '; if (PlayerOnWatchlist($pid)) { - echo ''; + echo ''; } else { - echo ''; + echo ''; } -echo ' - -
Match TypeScoreFKDSTKEff.Acc.Avg TTLMatchesHours
Match TypeScoreFKDSTKEff.Acc.Avg TTLMatchesHours
'.$r_plist[gamename].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$r_plist[teamkills].''.$eff.''.$acc.''.$ttl.''.$r_plist[games].''.$gametime.'
'.$r_plist[gamename].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$r_plist[teamkills].''.$eff.''.$acc.''.$ttl.''.$r_plist[games].''.$gametime.'
Totals'.$r_sumplist[gamescore].''.$r_sumplist[frags].''.$r_sumplist[kills].''.$r_sumplist[deaths].''.$r_sumplist[suicides].''.$r_sumplist[teamkills].''.$eff.''.$acc.''.$ttl.''.$r_sumplist[games].''.$gametime.'
Totals'.$r_sumplist[gamescore].''.$r_sumplist[frags].''.$r_sumplist[kills].''.$r_sumplist[deaths].''.$r_sumplist[suicides].''.$r_sumplist[teamkills].''.$eff.''.$acc.''.$ttl.''.$r_sumplist[games].''.$gametime.'

'; $q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); $assgids = array(); + while ($r_assgids = mysql_fetch_array($q_assgids)) { - $assgids[] = $r_assgids['id']; + $assgids[] = $r_assgids['id']; } + $assquery = (count($assgids) > 0) ? 'SUM(IF (gid IN ('. implode(',', $assgids) .'), ass_obj, 0)) AS ass_obj' : '0 AS ass_obj'; - $sql_cdatot = zero_out(small_query("SELECT SUM(dom_cp) AS dom_cp, $assquery, SUM(flag_taken) AS flag_taken, -SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, -SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, -SUM(flag_return) AS flag_return FROM uts_player WHERE pid = '$pid'")); +$sql_cdatot = zero_out(small_query("SELECT SUM(dom_cp) AS dom_cp, $assquery, SUM(flag_taken) AS flag_taken, + SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, + SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, + SUM(flag_return) AS flag_return FROM uts_player WHERE pid = '$pid'")); if ($sql_cdatot[ass_obj] || $sql_cdatot[dom_cp] || $sql_cdatot[flag_taken] || $sql_cdatot[flag_pickedup] || $sql_cdatot[flag_dropped] || $sql_cdatot[flag_assist] || $sql_cdatot[flag_cover] || $sql_cdatot[flag_seal] || $sql_cdatot[flag_capture] || $sql_cdatot[flag_kill] || $sql_cdatot[flag_return]) { - echo ' - - - - - - - - - - - - - - - - - - - - '; - - echo' - - - - - - - - - - - - - -
Assault, Domination and CTF Events Summary
Assault ObjectivesControl Point CapturesCapture The Flag
Flag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag Returns
'.$sql_cdatot[ass_obj].''.$sql_cdatot[dom_cp].''.$sql_cdatot[flag_taken].''.$sql_cdatot[flag_pickedup].''.$sql_cdatot[flag_dropped].''.$sql_cdatot[flag_assist].''.$sql_cdatot[flag_cover].''.$sql_cdatot[flag_seal].''.$sql_cdatot[flag_capture].''.$sql_cdatot[flag_kill].''.$sql_cdatot[flag_return].'
-
'; + echo ' + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Assault, Domination and CTF Events Summary
Assault ObjectivesControl Point CapturesCapture The Flag
Flag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag Returns
'.$sql_cdatot[ass_obj].''.$sql_cdatot[dom_cp].''.$sql_cdatot[flag_taken].''.$sql_cdatot[flag_pickedup].''.$sql_cdatot[flag_dropped].''.$sql_cdatot[flag_assist].''.$sql_cdatot[flag_cover].''.$sql_cdatot[flag_seal].''.$sql_cdatot[flag_capture].''.$sql_cdatot[flag_kill].''.$sql_cdatot[flag_return].'
+
'; } $sql_firstblood = zero_out(small_query("SELECT COUNT(id) AS fbcount FROM uts_match WHERE firstblood = '$pid'")); $sql_multis = zero_out(small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, -SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, -SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, -SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god -FROM uts_player WHERE pid = '$pid'")); + SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, + SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, + SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god + FROM uts_player WHERE pid = '$pid'")); if ($sql_firstblood[fbcount] || $sql_multis[spree_double] || $sql_multis[spree_multi] || $sql_multis[spree_ultra] || $sql_multis[spree_monster] || $sql_multis[spree_kill] || $sql_multis[spree_rampage] || $sql_multis[spree_dom] || $sql_multis[spree_uns] || $sql_multis[spree_god] ) { - echo ' - - - - - - - - - - - - - - - - - - - - '; - - echo' - - - - - - - - - - - - -
Special Events
First BloodMultisSprees
DblMultiUltraMonsKillRamDomUnsGod
'.$sql_firstblood[fbcount].''.$sql_multis[spree_double].''.$sql_multis[spree_multi].''.$sql_multis[spree_ultra].''.$sql_multis[spree_monster].''.$sql_multis[spree_kill].''.$sql_multis[spree_rampage].''.$sql_multis[spree_dom].''.$sql_multis[spree_uns].''.$sql_multis[spree_god].'
-
'; + echo ' + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Special Events
First BloodMultisSprees
DblMultiUltraMonsKillRamDomUnsGod
'.$sql_firstblood[fbcount].''.$sql_multis[spree_double].''.$sql_multis[spree_multi].''.$sql_multis[spree_ultra].''.$sql_multis[spree_monster].''.$sql_multis[spree_kill].''.$sql_multis[spree_rampage].''.$sql_multis[spree_dom].''.$sql_multis[spree_uns].''.$sql_multis[spree_god].'
+
'; } $r_pickups = zero_out(small_query("SELECT SUM(pu_pads) AS pu_pads, SUM(pu_armour) AS pu_armour, SUM(pu_keg) AS pu_keg, -SUM(pu_invis) AS pu_invis, SUM(pu_belt) AS pu_belt, SUM(pu_amp) AS pu_amp -FROM uts_player WHERE pid = '$pid'")); + SUM(pu_invis) AS pu_invis, SUM(pu_belt) AS pu_belt, SUM(pu_amp) AS pu_amp, SUM(pu_boots) AS pu_boots + FROM uts_player WHERE pid = '$pid'")); if ($r_pickups[pu_pads] || $r_pickups[pu_armour] || $r_pickups[pu_keg] || $r_pickups[pu_invis] || $r_pickups[pu_belt] || $r_pickups[pu_amp] ) { - echo ' - - - - - - - - - - - - - - - - - - - - -
Pickups Summary
PadsArmourKegInvisibilityShield BeltDamage Amp
'.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].'
-
'; + echo ' + + + + + + + + + + + + + + + + + + + + + + + +
Pickups Summary
PadsArmourKegInvisibilityShield BeltDamage AmpAntigrav Boots
'.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].''.$r_pickups[pu_boots].'
+
'; } include('includes/weaponstats.php'); @@ -318,125 +327,168 @@ ORDER BY 0 + e.col3 ASC"; $q_btrecords = mysql_query($sql_btrecords) or die (mysql_error()); + if (mysql_num_rows($q_btrecords) > 0) { - echo ' - - - - - - - - - - '; - while ($r_btrecords = mysql_fetch_array($q_btrecords)) { - $map = un_ut($r_btrecords['map']); - $myurl = urlencode($map); - $maprank = 1 + small_count("SELECT DISTINCT p.pid AS rank FROM uts_player as p, uts_events AS e, uts_match as m WHERE (m.mapfile = '" . addslashes($map) . "' OR m.mapfile = '" . addslashes($map) . ".unr') AND m.id = e.matchid AND e.matchid = p.matchid AND e.playerid = p.playerid AND e.col3 < ".$r_btrecords['time'] . " AND e.col1 = 'btcap'"); - echo ' - - - - '; - } - echo ' -
Bunny Track Personal Records
MapN°TimeDate
 '.htmlentities($map).'', $maprank, '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
-
'; + echo ' + + + + + + + + + + + '; + + while ($r_btrecords = mysql_fetch_array($q_btrecords)) { + $map = un_ut($r_btrecords['map']); + $myurl = urlencode($map); + $maprank = 1 + small_count("SELECT DISTINCT p.pid AS rank FROM uts_player as p, uts_events AS e, uts_match as m WHERE (m.mapfile = '" . addslashes($map) . "' OR m.mapfile = '" . addslashes($map) . ".unr') AND m.id = e.matchid AND e.matchid = p.matchid AND e.playerid = p.playerid AND e.col3 < ".$r_btrecords['time'] . " AND e.col1 = 'btcap'"); + + echo ' + + + + + '; + } + echo '
Bunny Track Personal Records
MapN°TimeDate
 '.htmlentities($map).'', $maprank, '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
+
'; } // Do graph stuff $bgwhere = "pid = '$pid'"; -include("pages/graph_pbreakdown.php"); - +//include("pages/graph_pbreakdown.php"); // Player's ranks -echo' - - - - - - - - - '; - if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') echo ''; +echo '
Ranking
N°Match TypeRankMatchesExplainPics
+ + + + + + + + +'; + +if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') { + echo ''; +} echo ''; $sql_rank = "SELECT g.name AS gamename, r.rank, r.prevrank, r.matches, r.gid, r.pid FROM uts_rank AS r, uts_games AS g WHERE r.gid = g.id AND r.pid = '$pid';"; $q_rank = mysql_query($sql_rank) or die(mysql_error()); + while ($r_rank = mysql_fetch_array($q_rank)) { - $r_no = small_query("SELECT (COUNT(*) + 1) AS no FROM uts_rank WHERE gid= '${r_rank['gid']}' and rank > ". get_dp($r_rank['rank']) ."9"); - echo' - - - - '; - echo ''; - if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') echo ''; - echo ''; + $r_no = small_query("SELECT (COUNT(*) + 1) AS no FROM uts_rank WHERE gid= '${r_rank['gid']}' and rank > ". get_dp($r_rank['rank']) ."9"); + + echo' + + + + '; + + echo ''; + if ($pic_enable and basename($_SERVER['PATH_TRANSLATED']) != 'admin.php') { + echo ''; + } + echo ''; } - echo '
Ranking
N°Match TypeRankMatchesExplainPics
'.RankImageOrText($r_rank['pid'], $name, $r_no['no'], $r_rank['gid'], $r_rank['gamename'], false, '%IT%').''.$r_rank['gamename'].''.get_dp($r_rank['rank']) .' '. RankMovement($r_rank['rank'] - $r_rank['prevrank']) . ''.$r_rank['matches'].'(Click)(Click)
'.RankImageOrText($r_rank['pid'], $name, $r_no['no'], $r_rank['gid'], $r_rank['gamename'], false, '%IT%').''.$r_rank['gamename'].''.get_dp($r_rank['rank']) .' '. RankMovement($r_rank['rank'] - $r_rank['prevrank']) . ''.$r_rank['matches'].'(Click)(Click)
'; - $r_pings = small_query("SELECT MIN(lowping * 1) AS lowping, AVG(avgping * 1) AS avgping, MAX(highping * 1) AS highping FROM uts_player WHERE pid = $pid and lowping > 0"); + if ($r_pings and $r_pings['lowping']) { -echo ' -
- - - - - - - - - - - - - - -
Pings
MinAvgMax
'.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).'
'; + echo ' +
+ + + + + + + + + + + + + + + +
Pings
MinAvgMax
'.ceil($r_pings['lowping']).''.ceil($r_pings['avgping']).''.ceil($r_pings['highping']).'
'; } +$mcount = $r_sumplist[games]; +$ecount = $mcount/50; +$ecount2 = number_format($ecount, 0, '.', ''); +if ($ecount > $ecount2) { + $ecount2 = $ecount2+1; +} - -echo'
- - - - - - - - '; - if (isset($is_admin) and $is_admin) echo ''; - echo''; +$fpage = 0; +if ($ecount < 1) { $lpage = 0; } +else { $lpage = $ecount2-1; } + +$cpage = mysql_real_escape_string(preg_replace('/\D/', '', $_REQUEST["page"])); +if ($cpage == "") { $cpage = "0"; } + +$qpage = $cpage*50; +$tfpage = $cpage+1; +$tlpage = $lpage+1; +$ppage = $cpage-1; + +echo '
+
Last 50 Games
Match IDDate/TimeMatch TypeMapIP Used
+ + + + + + + + '; +if (isset($is_admin) and $is_admin) echo ''; +echo''; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, INET_NTOA(p.ip) AS ip FROM uts_match m, uts_player p, uts_games g -WHERE p.pid = '$pid' AND m.id = p.matchid AND m.gid = g.id ORDER BY time DESC LIMIT 0,50"; + WHERE p.pid = '$pid' AND m.id = p.matchid AND m.gid = g.id ORDER BY time DESC LIMIT $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_time = mdate($r_recent[time]); - $r_mapfile = un_ut($r_recent[mapfile]); + echo' + + + + + '; + if (isset($is_admin) and $is_admin) echo ''; + + echo ''; +} - echo' - - - - - '; - if (isset($is_admin) and $is_admin) echo ''; +echo'
Matches played
IDDate/TimeMatch TypeMapIP Used
'.$r_recent[id].''.$r_time.''.$r_recent[gamename].''.$r_mapfile.''. $r_recent[ip].'
'.$r_recent[id].''.$r_time.''.$r_recent[gamename].''.$r_mapfile.''. $r_recent[ip].'
'; - echo '
-'; ?> diff --git a/html/pages/players_search.php b/html/pages/players_search.php old mode 100755 new mode 100644 index 1791393..39ab53f --- a/html/pages/players_search.php +++ b/html/pages/players_search.php @@ -10,7 +10,7 @@ function SortPic($curr_field, $filter, $sort) { if ($curr_field != $filter) return; $fname = 'images/s_'. strtolower($sort) .'.png'; if (!file_exists($fname)) return; - return(' '); + return(' '); } // Get filter and set sorting @@ -26,16 +26,22 @@ IF (empty($filter) or (!in_array(strtolower($filter), array("name", "games", "ga if (empty($sort) or ($sort != 'ASC' and $sort != 'DESC')) $sort = ($filter == "name") ? "ASC" : "DESC"; echo' + + + +
-
* Click headings to change Sorting *
- + +
- - + - + + @@ -64,18 +70,18 @@ while ($r_plist = mysql_fetch_array($q_plist)) { $ttl = GetMinutes($r_plist[ttl]); echo' - - - - - - - - - - - - + + + + + + + + + + + + '; } echo' diff --git a/html/pages/rank_extended.php b/html/pages/rank_extended.php old mode 100755 new mode 100644 index b41baf2..bd9c60e --- a/html/pages/rank_extended.php +++ b/html/pages/rank_extended.php @@ -40,17 +40,17 @@ $lpageurl = "Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.' -
Player Search List
Player Search List +
Name Search: - - +
+
+
Player Name'.SortPic('name', $filter, $sort).'
'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_plist[name]).''.$r_plist[games].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$eff.''.$acc.''.$ttl.''.$gametime.'
'.FormatPlayerName($r_plist[country], $r_plist['pid'], $r_plist[name]).''.$r_plist[games].''.$r_plist[gamescore].''.$r_plist[frags].''.$r_plist[kills].''.$r_plist[deaths].''.$r_plist[suicides].''.$eff.''.$acc.''.$ttl.''.$gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+
- + - - - - + + + + '; $ranking = $qpage; @@ -61,15 +61,15 @@ echo' $ranking++; echo' - - - - - + + + + + '; } echo'
'.$gamename.' Ranking Players'.$gamename.' Ranking Players
N°Player NameRankMatchesN°Player NameRankMatches
'.$ranking.''.FlagImage($r_rplayer[country]).' '.htmlspecialchars($r_rplayer[name]) .' '. RankMovement($r_rplayer['rank'] - $r_rplayer['prevrank']) .''.get_dp($r_rplayer[rank]).''.$r_rplayer[matches].'
'.$ranking.''.FlagImage($r_rplayer[country]).' '.htmlspecialchars($r_rplayer[name]) .' '. RankMovement($r_rplayer['rank'] - $r_rplayer['prevrank']) .''.get_dp($r_rplayer[rank]).''.$r_rplayer[matches].'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> \ No newline at end of file diff --git a/html/pages/report.php b/html/pages/report.php old mode 100755 new mode 100644 diff --git a/html/pages/report/bbcode.php b/html/pages/report/bbcode.php old mode 100755 new mode 100644 diff --git a/html/pages/report/clanbase.php b/html/pages/report/clanbase.php old mode 100755 new mode 100644 diff --git a/html/pages/report/index.htm b/html/pages/report/index.htm old mode 100755 new mode 100644 diff --git a/html/pages/report_cb.php b/html/pages/report_cb.php old mode 100755 new mode 100644 index ebde5a6..50eb5d4 --- a/html/pages/report_cb.php +++ b/html/pages/report_cb.php @@ -19,7 +19,7 @@ echo' echo' + Team BreakDown of Match @@ -64,7 +64,7 @@ IF ($stage == "1") { + Who Played As Red Team?
- Team BreakDown of Match
Red Team
- Who Played As Red Team?
@@ -108,7 +108,7 @@ IF ($stage == "2") { + Clan and Player Info for Clanbase War ID '.$wid.'
- Clan and Player Info for Clanbase War ID '.$wid.'
diff --git a/html/pages/servers.php b/html/pages/servers.php old mode 100755 new mode 100644 index 63d3721..8b27fab --- a/html/pages/servers.php +++ b/html/pages/servers.php @@ -36,8 +36,8 @@ $lpageurl = "[Last] IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } echo' -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+
@@ -59,16 +59,16 @@ while ($r_servers = mysql_fetch_array($q_servers)) { echo' - - - - - - + + + + + + '; } echo'
Unreal Tournament Server List
'.$r_servers[servername].'Server Status'.$r_servers[matchcount].''.$r_servers[frags].''.$r_servers[matchscore].''.$r_gametime.''.$r_servers[servername].'Server Status'.$r_servers[matchcount].''.$r_servers[frags].''.$r_servers[matchscore].''.$r_gametime.'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> \ No newline at end of file diff --git a/html/pages/servers_info.php b/html/pages/servers_info.php old mode 100755 new mode 100644 index 2548197..81f7772 --- a/html/pages/servers_info.php +++ b/html/pages/servers_info.php @@ -1,104 +1,106 @@ - $ecount2) { - $ecount2 = $ecount2+1; -} - -$fpage = 0; -IF($ecount < 1) { $lpage = 0; } -else { $lpage = $ecount2-1; } - -$cpage = $_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]"; } - - -// Get the last match entry for this server - -$serverinfo = small_query("SELECT time, servername, serverinfo, gameinfo, mutators FROM uts_match WHERE serverip = '$serverip' ORDER BY time DESC LIMIT 0,1"); -$matchdate = mdate($serverinfo[time]); - -echo' - - - - - - - - - - - - - - - - - - -
'.$serverinfo[servername].'
Last Match'.$matchdate.'Game Info
Server Info'.$serverinfo[serverinfo].''.$serverinfo[gameinfo].'
Mutators'.$serverinfo[mutators].'
-
'; - -// Do graph stuff -$bgwhere = "serverip = '$serverip'"; -include("pages/graph_mbreakdown.php"); - -echo'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - - - - - - - - '; - -$sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid AND m.serverip = '$serverip' 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 = sec2min($r_recent[gametime]); - $myurl = urlencode($r_mapfile); - - echo' - - - - - - '; -} - -echo' -
Unreal Tournament Match List
Date/TimeMatch TypeMapTime
'.$r_time.''.$r_recent[gamename].''.$r_mapfile.''.$r_gametime.'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; + $ecount2) { + $ecount2 = $ecount2+1; +} + +$fpage = 0; +IF($ecount < 1) { $lpage = 0; } +else { $lpage = $ecount2-1; } + +$cpage = mysql_real_escape_string($_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]"; } + + +// Get the last match entry for this server + +$serverinfo = small_query("SELECT time, servername, serverinfo, gameinfo, mutators FROM uts_match WHERE serverip = '$serverip' ORDER BY time DESC LIMIT 0,1"); +$matchdate = mdate($serverinfo[time]); + +echo' + + + + + + + + + + + + + + + + + +
'.$serverinfo[servername].'
Last Match'.$matchdate.'
Server Info'.$serverinfo[serverinfo].'
Mutators + '.$serverinfo[mutators].' +
Game Info + '.$serverinfo[gameinfo].'
+
'; + +// Do graph stuff +$bgwhere = "serverip = '$serverip'"; +include("pages/graph_mbreakdown.php"); + +echo'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+ + + + + + + + + '; + +$sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid AND m.serverip = '$serverip' 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 = sec2min($r_recent[gametime]); + $myurl = urlencode($r_mapfile); + + echo' + + + + + + '; +} + +echo' +
Unreal Tournament Match List
Date/TimeMatch TypeMap + Time
'.$r_time.''.$r_recent[gamename].''.$r_mapfile.''.$r_gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> \ No newline at end of file diff --git a/html/pages/servers_query.php b/html/pages/servers_query.php old mode 100755 new mode 100644 index 95265c6..c44a718 --- a/html/pages/servers_query.php +++ b/html/pages/servers_query.php @@ -98,14 +98,14 @@ $r_friendlyfire = getiteminfo("friendlyfire",$chunks); $r_gamestyle = getiteminfo("gamestyle",$chunks); echo' - +
- + @@ -139,7 +139,7 @@ echo'
Server Status for '.$r_hostname.'
Server IP '.$serverip.':'.$serverport.''.$mapname.''.$mapname.'
Map Name

- +
diff --git a/html/pages/totals.php b/html/pages/totals.php index e5b5126..0e81f82 100755 --- a/html/pages/totals.php +++ b/html/pages/totals.php @@ -1,31 +1,25 @@ - - - - -
Player Information
Totals Summary
-
- + +
- + - - - - - - - - - '; + + + + + + + + + + - - - - - - - - - '; + + + + + + + + + + '; } $sql_summtot = zero_out(small_query("SELECT SUM(gamescore) AS gamescore, SUM(frags) AS frags, SUM(kills) AS kills, SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, COUNT(DISTINCT matchid) AS matchcount, SUM(gametime) AS sumgametime -FROM uts_player")); + FROM uts_player")); $gametime2 = sec2hour($sql_summtot[sumgametime]); echo' - - - - - - - - + + + + + + + +
SummarySummary
Game TypeScoreFragsKillsSuicidesTeam KillsMatchesHours
Game TypeScoreFragsKillsSuicidesTeam KillsMatchesHours
'.$r_totsumm[gamename].''.$r_totsumm[gamescore].''.$r_totsumm[frags].''.$r_totsumm[kills].''.$r_totsumm[suicides].''.$r_totsumm[teamkills].''.$r_totsumm[matchcount].''.$gametime.'
'.$r_totsumm[gamename].''.$r_totsumm[gamescore].''.$r_totsumm[frags].''.$r_totsumm[kills].''.$r_totsumm[suicides].''.$r_totsumm[teamkills].''.$r_totsumm[matchcount].''.$gametime.'
Totals'.$sql_summtot[gamescore].''.$sql_summtot[frags].''.$sql_summtot[kills].''.$sql_summtot[suicides].''.$sql_summtot[teamkills].''.$sql_summtot[matchcount].''.$gametime2.'Totals'.$sql_summtot[gamescore].''.$sql_summtot[frags].''.$sql_summtot[kills].''.$sql_summtot[suicides].''.$sql_summtot[teamkills].''.$sql_summtot[matchcount].''.$gametime2.'

- +
- + - - - + + + - - - - - - - - - + + + + + + + + + '; $q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); @@ -98,23 +92,23 @@ echo' echo' - - - - - - - - - - - + + + + + + + + + + +
Assault, Domination and CTF Events SummaryAssault, Domination and CTF Events Summary
Assault ObjectivesControl Point CapturesCapture The FlagAssault ObjectivesControl Point CapturesCapture The Flag
Flag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag ReturnsFlag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag Returns
'.$sql_cdatot[ass_obj].''.$sql_cdatot[dom_cp].''.$sql_cdatot[flag_taken].''.$sql_cdatot[flag_pickedup].''.$sql_cdatot[flag_dropped].''.$sql_cdatot[flag_assist].''.$sql_cdatot[flag_cover].''.$sql_cdatot[flag_seal].''.$sql_cdatot[flag_capture].''.$sql_cdatot[flag_kill].''.$sql_cdatot[flag_return].''.$sql_cdatot[ass_obj].''.$sql_cdatot[dom_cp].''.$sql_cdatot[flag_taken].''.$sql_cdatot[flag_pickedup].''.$sql_cdatot[flag_dropped].''.$sql_cdatot[flag_assist].''.$sql_cdatot[flag_cover].''.$sql_cdatot[flag_seal].''.$sql_cdatot[flag_capture].''.$sql_cdatot[flag_kill].''.$sql_cdatot[flag_return].'

- +
- + '; $sql_firstblood = zero_out(small_count("SELECT firstblood FROM uts_match WHERE firstblood != ''")); @@ -123,38 +117,38 @@ $sql_sprees = zero_out(small_query("SELECT SUM(spree_kill) AS spree_kill, SUM(sp echo' - - + + - - - - + + + + - - - - + + + + - - - - + + + + - - - - + + + + - - - - + + + +
Special EventsSpecial Events
Special/MultisSpreesSpecial/MultisSprees
First Blood'.$sql_firstblood.'Killing Spree'.$sql_sprees[spree_kill].'First Blood'.$sql_firstblood.'Killing Spree'.$sql_sprees[spree_kill].'
Double Kills'.$sql_multis[spree_double].'Rampage'.$sql_sprees[spree_rampage].'Double Kills'.$sql_multis[spree_double].'Rampage'.$sql_sprees[spree_rampage].'
Multi Kills'.$sql_multis[spree_multi].'Dominating'.$sql_sprees[spree_dom].'Multi Kills'.$sql_multis[spree_multi].'Dominating'.$sql_sprees[spree_dom].'
Ultra Kills'.$sql_multis[spree_ultra].'Unstoppable'.$sql_sprees[spree_uns].'Ultra Kills'.$sql_multis[spree_ultra].'Unstoppable'.$sql_sprees[spree_uns].'
Monster Kills'.$sql_multis[spree_monster].'Godlike'.$sql_sprees[spree_god].'Monster Kills'.$sql_multis[spree_monster].'Godlike'.$sql_sprees[spree_god].'

'; @@ -163,9 +157,9 @@ include('includes/weaponstats.php'); weaponstats(0, 0); echo'
- +
- +
Totals for PlayersTotals for Players
'; @@ -181,8 +175,8 @@ $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, AVG(ttl) AS ttl , $sql_chighflag_capture = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY flag_capture DESC LIMIT 0,1"); $sql_chighflag_kill = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY flag_kill DESC LIMIT 0,1"); $sql_chighdom_cp = small_query("SELECT p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY dom_cp DESC LIMIT 0,1"); - $ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); + if ($ass_obj_check[idcount] > 0 ) { $sql_chighass_obj = small_query("SELECT p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ass_obj DESC LIMIT 0,1"); } else { @@ -193,168 +187,167 @@ $sql_chighspree_monster = small_query("SELECT p.pid, pi.name, p.country, SUM(spr $sql_chighspree_god = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY spree_god DESC LIMIT 0,1"); $sql_chighrank = small_query("SELECT p.pid, pi.name, p.country, SUM(rank) AS rank , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid, p.country HAVING sumgametime > 1800 ORDER BY rank DESC LIMIT 0,1"); -echo'
- +echo '
+
- + - - - - - + + + + + '; - if ($sql_chighfrags and $sql_chighfrags[frags]) { echo ' - - - - - + + + + + '; } if ($sql_chighdeaths and $sql_chighdeaths[deaths]) { echo ' - - - - - + + + + + '; } if ($sql_chighkills and $sql_chighkills[kills]) { echo ' - - - - - + + + + + '; } if ($sql_chighsuicides and $sql_chighsuicides[suicides]) { echo ' - - - - - + + + + + '; } if ($sql_chighteamkills and $sql_chighteamkills[teamkills]) { echo ' - - - - - + + + + + '; } if ($sql_chigheff and $sql_chigheff[eff]) { echo ' - - - - - + + + + + '; } if ($sql_chighaccuracy and $sql_chighaccuracy[accuracy]) { echo ' - - - - - + + + + + '; } if ($sql_chighttl and $sql_chighttl[ttl]) { echo ' - - - - - + + + + + '; } if ($sql_chighflag_capture and $sql_chighflag_capture[flag_capture]) { echo ' - - - - - + + + + + '; } if ($sql_chighflag_kill and $sql_chighflag_kill[flag_kill]) { echo ' - - - - - + + + + + '; } if ($sql_chighdom_cp and $sql_chighdom_cp[dom_cp]) { echo ' - - - - - + + + + + '; } if ($sql_chighass_obj and $sql_chighass_obj[ass_obj]) { echo ' - - - - - + + + + + '; } if ($sql_chighspree_monster and $sql_chighspree_monster[spree_monster]) { echo ' - - - - - + + + + + '; } if ($sql_chighspree_god and $sql_chighspree_god[spree_god]) { echo ' - - - - - + + + + + '; } if ($sql_chighrank and $sql_chighrank[rank]) { echo ' - - - - - + + + + + '; } echo ' @@ -362,7 +355,6 @@ echo '
'; // NGStats Style Total Highs (Single Match) - $sql_mhighfrags = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(frags) AS frags , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND frags > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY frags DESC LIMIT 0,1"); $sql_mhighdeaths = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(deaths) AS deaths , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND deaths > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY deaths DESC LIMIT 0,1"); $sql_mhighkills = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(kills) AS kills , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND kills > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY kills DESC LIMIT 0,1"); @@ -386,193 +378,184 @@ $sql_mhighspree_monster = small_query("SELECT p.matchid, p.pid, pi.name, p.count $sql_mhighspree_god = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_god > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY spree_god DESC LIMIT 0,1"); $sql_mhighrank = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(rank) AS rank , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND rank > 0 GROUP BY matchid, pid, country HAVING sumgametime > 600 ORDER BY rank DESC LIMIT 0,1"); -echo'
Career HighsCareer Highs
CategoryPlayerAmountHoursMatchesCategoryPlayerAmountHoursMatches
Frags'.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags[name].''.$sql_chighfrags[frags].''.sec2hour($sql_chighfrags[sumgametime]).''.$sql_chighfrags[mcount].'Frags'.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags[name].''.$sql_chighfrags[frags].''.sec2hour($sql_chighfrags[sumgametime]).''.$sql_chighfrags[mcount].'
Deaths'.FlagImage($sql_chighdeaths['country'], false).' '.$sql_chighdeaths[name].''.$sql_chighdeaths[deaths].''.sec2hour($sql_chighdeaths[sumgametime]).''.$sql_chighdeaths[mcount].'Deaths'.FlagImage($sql_chighdeaths['country'], false).' '.$sql_chighdeaths[name].''.$sql_chighdeaths[deaths].''.sec2hour($sql_chighdeaths[sumgametime]).''.$sql_chighdeaths[mcount].'
Kills'.FlagImage($sql_chighkills['country'], false).' '.$sql_chighkills[name].''.$sql_chighkills[kills].''.sec2hour($sql_chighkills[sumgametime]).''.$sql_chighkills[mcount].'Kills'.FlagImage($sql_chighkills['country'], false).' '.$sql_chighkills[name].''.$sql_chighkills[kills].''.sec2hour($sql_chighkills[sumgametime]).''.$sql_chighkills[mcount].'
Suicides'.FlagImage($sql_chighsuicides['country'], false).' '.$sql_chighsuicides[name].''.$sql_chighsuicides[suicides].''.sec2hour($sql_chighsuicides[sumgametime]).''.$sql_chighsuicides[mcount].'Suicides'.FlagImage($sql_chighsuicides['country'], false).' '.$sql_chighsuicides[name].''.$sql_chighsuicides[suicides].''.sec2hour($sql_chighsuicides[sumgametime]).''.$sql_chighsuicides[mcount].'
Team Kills'.FlagImage($sql_chighteamkills['country'], false).' '.$sql_chighteamkills[name].''.$sql_chighteamkills[teamkills].''.sec2hour($sql_chighteamkills[sumgametime]).''.$sql_chighteamkills[mcount].'Team Kills'.FlagImage($sql_chighteamkills['country'], false).' '.$sql_chighteamkills[name].''.$sql_chighteamkills[teamkills].''.sec2hour($sql_chighteamkills[sumgametime]).''.$sql_chighteamkills[mcount].'
Efficiency'.FlagImage($sql_chigheff['country'], false).' '.$sql_chigheff[name].''.get_dp($sql_chigheff[eff]).''.sec2hour($sql_chigheff[sumgametime]).''.$sql_chigheff[mcount].'Efficiency'.FlagImage($sql_chigheff['country'], false).' '.$sql_chigheff[name].''.get_dp($sql_chigheff[eff]).''.sec2hour($sql_chigheff[sumgametime]).''.$sql_chigheff[mcount].'
Accuracy'.FlagImage($sql_chighaccuracy['country'], false).' '.$sql_chighaccuracy[name].''.get_dp($sql_chighaccuracy[accuracy]).''.sec2hour($sql_chighaccuracy[sumgametime]).''.$sql_chighaccuracy[mcount].'Accuracy'.FlagImage($sql_chighaccuracy['country'], false).' '.$sql_chighaccuracy[name].''.get_dp($sql_chighaccuracy[accuracy]).''.sec2hour($sql_chighaccuracy[sumgametime]).''.$sql_chighaccuracy[mcount].'
TTL'.FlagImage($sql_chighttl['country'], false).' '.$sql_chighttl[name].''.get_dp($sql_chighttl[ttl]).''.sec2hour($sql_chighttl[sumgametime]).''.$sql_chighttl[mcount].'TTL'.FlagImage($sql_chighttl['country'], false).' '.$sql_chighttl[name].''.get_dp($sql_chighttl[ttl]).''.sec2hour($sql_chighttl[sumgametime]).''.$sql_chighttl[mcount].'
Flag Caps'.FlagImage($sql_chighflag_capture['country'], false).' '.$sql_chighflag_capture[name].''.$sql_chighflag_capture[flag_capture].''.sec2hour($sql_chighflag_capture[sumgametime]).''.$sql_chighflag_capture[mcount].'Flag Caps'.FlagImage($sql_chighflag_capture['country'], false).' '.$sql_chighflag_capture[name].''.$sql_chighflag_capture[flag_capture].''.sec2hour($sql_chighflag_capture[sumgametime]).''.$sql_chighflag_capture[mcount].'
Flag Kills'.FlagImage($sql_chighflag_kill['country'], false).' '.$sql_chighflag_kill[name].''.$sql_chighflag_kill[flag_kill].''.sec2hour($sql_chighflag_kill[sumgametime]).''.$sql_chighflag_kill[mcount].'Flag Kills'.FlagImage($sql_chighflag_kill['country'], false).' '.$sql_chighflag_kill[name].''.$sql_chighflag_kill[flag_kill].''.sec2hour($sql_chighflag_kill[sumgametime]).''.$sql_chighflag_kill[mcount].'
Domination Control Points'.FlagImage($sql_chighdom_cp['country'], false).' '.$sql_chighdom_cp[name].''.$sql_chighdom_cp[dom_cp].''.sec2hour($sql_chighdom_cp[sumgametime]).''.$sql_chighdom_cp[mcount].'Domination Control Points'.FlagImage($sql_chighdom_cp['country'], false).' '.$sql_chighdom_cp[name].''.$sql_chighdom_cp[dom_cp].''.sec2hour($sql_chighdom_cp[sumgametime]).''.$sql_chighdom_cp[mcount].'
Assault Objectives'.FlagImage($sql_chighass_obj['country'], false).' '.$sql_chighass_obj[name].''.$sql_chighass_obj[ass_obj].''.sec2hour($sql_chighass_obj[sumgametime]).''.$sql_chighass_obj[mcount].'Assault Objectives'.FlagImage($sql_chighass_obj['country'], false).' '.$sql_chighass_obj[name].''.$sql_chighass_obj[ass_obj].''.sec2hour($sql_chighass_obj[sumgametime]).''.$sql_chighass_obj[mcount].'
Monster Kills'.FlagImage($sql_chighspree_monster['country'], false).' '.$sql_chighspree_monster[name].''.$sql_chighspree_monster[spree_monster].''.sec2hour($sql_chighspree_monster[sumgametime]).''.$sql_chighspree_monster[mcount].'Monster Kills'.FlagImage($sql_chighspree_monster['country'], false).' '.$sql_chighspree_monster[name].''.$sql_chighspree_monster[spree_monster].''.sec2hour($sql_chighspree_monster[sumgametime]).''.$sql_chighspree_monster[mcount].'
Godlikes'.FlagImage($sql_chighspree_god['country'], false).' '.$sql_chighspree_god[name].''.$sql_chighspree_god[spree_god].''.sec2hour($sql_chighspree_god[sumgametime]).''.$sql_chighspree_god[mcount].'Godlikes'.FlagImage($sql_chighspree_god['country'], false).' '.$sql_chighspree_god[name].''.$sql_chighspree_god[spree_god].''.sec2hour($sql_chighspree_god[sumgametime]).''.$sql_chighspree_god[mcount].'
Rank Points'.FlagImage($sql_chighrank['country'], false).' '.$sql_chighrank[name].''.get_dp($sql_chighrank[rank]).''.sec2hour($sql_chighrank[sumgametime]).''.$sql_chighrank[mcount].'Rank Points'.FlagImage($sql_chighrank['country'], false).' '.$sql_chighrank[name].''.get_dp($sql_chighrank[rank]).''.sec2hour($sql_chighrank[sumgametime]).''.$sql_chighrank[mcount].'
+echo'
- + - - - - + + + + '; if ($sql_mhighfrags) { echo ' - - - - + + + + '; } if ($sql_mhighdeaths) { echo ' - - - - + + + + '; } if ($sql_mhighkills) { echo ' - - - - + + + + '; } if ($sql_mhighsuicides) { echo ' - - - - + + + + '; } if ($sql_mhighteamkills) { echo ' - - - - + + + + '; } if ($sql_mhigheff) { echo ' - - - - + + + + '; } if ($sql_mhighaccuracy) { echo ' - - - - + + + + '; } if ($sql_mhighttl) { echo ' - - - - + + + + '; } if ($sql_mhighflag_capture) { echo ' - - - - + + + + '; } if ($sql_mhighflag_kill) { echo ' - - - - + + + + '; } if ($sql_mhighdom_cp) { echo ' - - - - + + + + '; } if ($sql_mhighass_obj) { echo ' - - - - + + + + '; } if ($sql_mhighspree_monster) { echo ' - - - - + + + + '; } if ($sql_mhighspree_god) { echo ' - - - - + + + + '; } if ($sql_mhighrank) { - echo ' + echo ' - - - - + + + + '; } - echo '
Match HighsMatch Highs
CategoryPlayerAmountMatchCategoryPlayerAmountMatch
Frags'.FlagImage($sql_mhighfrags['country'], false).' '.$sql_mhighfrags[name].''.$sql_mhighfrags[frags].'(click)Frags'.FlagImage($sql_mhighfrags['country'], false).' '.$sql_mhighfrags[name].''.$sql_mhighfrags[frags].'(click)
Deaths'.FlagImage($sql_mhighdeaths['country'], false).' '.$sql_mhighdeaths[name].''.$sql_mhighdeaths[deaths].'(click)Deaths'.FlagImage($sql_mhighdeaths['country'], false).' '.$sql_mhighdeaths[name].''.$sql_mhighdeaths[deaths].'(click)
Kills'.FlagImage($sql_mhighkills['country'], false).' '.$sql_mhighkills[name].''.$sql_mhighkills[kills].'(click)Kills'.FlagImage($sql_mhighkills['country'], false).' '.$sql_mhighkills[name].''.$sql_mhighkills[kills].'(click)
Suicides'.FlagImage($sql_mhighsuicides['country'], false).' '.$sql_mhighsuicides[name].''.$sql_mhighsuicides[suicides].'(click)Suicides'.FlagImage($sql_mhighsuicides['country'], false).' '.$sql_mhighsuicides[name].''.$sql_mhighsuicides[suicides].'(click)
Team Kills'.FlagImage($sql_mhighteamkills['country'], false).' '.$sql_mhighteamkills[name].''.$sql_mhighteamkills[teamkills].'(click)Team Kills'.FlagImage($sql_mhighteamkills['country'], false).' '.$sql_mhighteamkills[name].''.$sql_mhighteamkills[teamkills].'(click)
Efficiency'.FlagImage($sql_mhigheff['country'], false).' '.$sql_mhigheff[name].''.get_dp($sql_mhigheff[eff]).'(click)Efficiency'.FlagImage($sql_mhigheff['country'], false).' '.$sql_mhigheff[name].''.get_dp($sql_mhigheff[eff]).'(click)
Accuracy'.FlagImage($sql_mhighaccuracy['country'], false).' '.$sql_mhighaccuracy[name].''.get_dp($sql_mhighaccuracy[accuracy]).'(click)Accuracy'.FlagImage($sql_mhighaccuracy['country'], false).' '.$sql_mhighaccuracy[name].''.get_dp($sql_mhighaccuracy[accuracy]).'(click)
TTL'.FlagImage($sql_mhighttl['country'], false).' '.$sql_mhighttl[name].''.get_dp($sql_mhighttl[ttl]).'(click)TTL'.FlagImage($sql_mhighttl['country'], false).' '.$sql_mhighttl[name].''.get_dp($sql_mhighttl[ttl]).'(click)
Flag Caps'.FlagImage($sql_mhighflag_capture['country'], false).' '.$sql_mhighflag_capture[name].''.$sql_mhighflag_capture[flag_capture].'(click)Flag Caps'.FlagImage($sql_mhighflag_capture['country'], false).' '.$sql_mhighflag_capture[name].''.$sql_mhighflag_capture[flag_capture].'(click)
Flag Kills'.FlagImage($sql_mhighflag_kill['country'], false).' '.$sql_mhighflag_kill[name].''.$sql_mhighflag_kill[flag_kill].'(click)Flag Kills'.FlagImage($sql_mhighflag_kill['country'], false).' '.$sql_mhighflag_kill[name].''.$sql_mhighflag_kill[flag_kill].'(click)
Domination Control Points'.FlagImage($sql_mhighdom_cp['country'], false).' '.$sql_mhighdom_cp[name].''.$sql_mhighdom_cp[dom_cp].'(click)Domination Control Points'.FlagImage($sql_mhighdom_cp['country'], false).' '.$sql_mhighdom_cp[name].''.$sql_mhighdom_cp[dom_cp].'(click)
Assault Objectives'.FlagImage($sql_mhighass_obj['country'], false).' '.$sql_mhighass_obj[name].''.$sql_mhighass_obj[ass_obj].'(click)Assault Objectives'.FlagImage($sql_mhighass_obj['country'], false).' '.$sql_mhighass_obj[name].''.$sql_mhighass_obj[ass_obj].'(click)
Monster Kills'.FlagImage($sql_mhighspree_monster['country'], false).' '.$sql_mhighspree_monster[name].''.$sql_mhighspree_monster[spree_monster].'(click)Monster Kills'.FlagImage($sql_mhighspree_monster['country'], false).' '.$sql_mhighspree_monster[name].''.$sql_mhighspree_monster[spree_monster].'(click)
Godlikes'.FlagImage($sql_mhighspree_god['country'], false).' '.$sql_mhighspree_god[name].''.$sql_mhighspree_god[spree_god].'(click)Godlikes'.FlagImage($sql_mhighspree_god['country'], false).' '.$sql_mhighspree_god[name].''.$sql_mhighspree_god[spree_god].'(click)
Rank Points'.FlagImage($sql_mhighrank['country'], false).' '.$sql_mhighrank[name].''.get_dp($sql_mhighrank[rank]).'(click)Rank Points'.FlagImage($sql_mhighrank['country'], false).' '.$sql_mhighrank[name].''.get_dp($sql_mhighrank[rank]).'(click)

- +
- - - - - - - + -'; - + + + + + + '; $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC"; $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error()); - while ($r_mweapons = mysql_fetch_array($q_mweapons)) { - $wid = $r_mweapons[id]; - - $sql_mweaponsl = "SELECT w.pid AS playerid, pi.name AS name, pi.country AS country, SUM(w.kills) as kills, COUNT(DISTINCT w.matchid) AS mcount - FROM uts_weaponstats AS w - LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id - WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid <> 0 AND pi.banned <> 'Y' - GROUP BY w.pid - ORDER BY kills DESC LIMIT 0,1"; + $wid = $r_mweapons[id]; + $sql_mweaponsl = "SELECT w.pid AS playerid, pi.name AS name, pi.country AS country, SUM(w.kills) as kills, COUNT(DISTINCT w.matchid) AS mcount FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid <> 0 AND pi.banned <> 'Y' GROUP BY w.pid ORDER BY kills DESC LIMIT 0,1"; $q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error()); - while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { - echo ' - - - - - '; + + echo ' + + + + + '; + } } @@ -581,37 +564,37 @@ echo '
Weapon Career Highs
CategoryPlayerKillsMatchesWeapon Career Highs
CategoryPlayerKillsMatches
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].''.$r_mweaponsl[mcount].'
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].''.$r_mweaponsl[mcount].'
// NGStats Style Weapon Highs (All Time) -echo ' - - - +echo '
Weapon Match Highs
+ + + - - - - - '; + + + + + +'; $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC"; $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error()); - while ($r_mweapons = mysql_fetch_array($q_mweapons)) { + $wid = $r_mweapons[id]; $sql_mweaponsl = "SELECT w.matchid, w.pid AS playerid, pi.name AS name, pi.country AS country, w.kills FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid > 0 AND pi.banned <> 'Y' ORDER BY w.kills DESC LIMIT 0,1"; $q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error()); - while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { - echo ' - - - - - '; + + echo ' + + + + + '; } } // NGStats Style Weapon Highs (Single Match) echo'
Weapon Match Highs
CategoryPlayerKillsMatch
CategoryPlayerKillsMatch
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].'(click)
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].'(click)
'; - ?> -- cgit