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/pages/players_info.php | 694 ++++++++++++++++++++++++-------------------- 1 file changed, 373 insertions(+), 321 deletions(-) (limited to 'html/pages/players_info.php') 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 '
-'; ?> -- cgit