Added!

" .htmlentities($playername)." has been added to your watchlist"; } else { echo "'; 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 ''; return; } 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"; $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]); 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'"); $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'

Career Summary for '.htmlentities($playername).' '; if (PlayerOnWatchlist($pid)) { echo ''; } else { echo ''; } echo '
Match Type	Score	F	K	D	S	TK	Eff.	Acc.	Avg TTL	Matches	Hours
'.$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.'

'; $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']; } $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'")); 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 '

Assault, Domination and CTF Events Summary
Assault Objectives	Control Point Captures	Capture The Flag
		Flag Takes	Flag Pickups	Flag Drops	Flag Assists	Flag Covers	Flag Seals	Flag Captures	Flag Kills	Flag 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'")); 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 '

Special Events
First Blood	Multis				Sprees
	Dbl	Multi	Ultra	Mons	Kill	Ram	Dom	Uns	God
'.$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, 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
Pads	Armour	Keg	Invisibility	Shield Belt	Damage Amp	Antigrav 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'); weaponstats(0, $pid); echo '
'; // bt records $sql_btrecords = " SELECT m.mapfile AS map, e.col3 AS time, e.col4 AS date FROM uts_match AS m, uts_events AS e, uts_player AS p WHERE p.pid = $pid AND p.playerid = e.playerid AND e.matchid = p.matchid AND m.id = p.matchid AND e.col1 = 'btcap' GROUP BY m.mapfile, e.col3, e.col4 ORDER BY m.mapfile, 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
Map	N°	Time	Date
'.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"); // Player's ranks echo ''; 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 ''; } echo '

Ranking
N°	Match Type	Rank	Matches	Explain	Pics
'.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
Min	Avg	Max
'.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; } $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 '
'; 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 $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]); echo' '; if (isset($is_admin) and $is_admin) echo ''; echo ''; } echo'

Matches played
ID	Date/Time	Match Type	Map	IP Used
'.$r_recent[id].'	'.$r_time.'	'.$r_recent[gamename].'	'.$r_mapfile.'	'. $r_recent[ip].'

'; $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 ''; ?>