$$openfile player_%%hash(player.name)%%.html$$
$$include menu.html$$
<table class=nameplate align=center cellspacing=0 border=1>
<tr align=center>
<td width=600 height=99 background="nameplate.jpg"><font face=tahoma size="+1"><div align="center"><b>$$colouredtext2html(player.name)$$</b></div></font></td>
</tr>
</table>

<table width=600px border=0 cellspacing=0 class=custom2 align=center>

<tr align=left>
<th><b>Rounds</b></th><td><b>$$player.rounds$$</b></td>
<th><b>Last Round</b></th><td><b>[<a href="round_$$player.lastactiveround$$.html">$$formatinteger("%05d",player.lastactiveround)$$</a>]</b></td>
<th><b>Play Time</b></th><td><b>$$formatduration("%H:%M:%S",player.duration)$$</b></td>
</tr>

<tr align=left>
<th><b>Score</b></th><td><b>$$formatfloat("%.1f",player.score)$$($$formatfloat("%.2f",player.scoreweighted)$$)</b></td>
<th><b>Skill</b></th><td><b>$$formatfloat("%.1f",player.skill)$$($$formatfloat("%.2f",player.skillweighted)$$)</b></td>
<th><b>Ratio</b></th><td><b>$$formatfloat("%.2f",player.ratio)$$</b></td>
</tr>

<tr align=left>
<th><b>Kills</b></th><td><b>$$player.kills$$</b></td>
<th><b>Deaths</b></th><td><b>$$player.deaths$$</b></td>
<th><b>Suicides</b></th><td><b>$$player.suicides$$</b></td>
</tr>

<tr align=left>
<th><b>Kill Streak</b></th><td><b>$$player.longestkillstreak$$</b></td>
<th><b>Death Streak</b></th><td><b>$$player.longestdeathstreak$$</b></td>
<th><b>Team Kill Streak</b></th><td><b>$$player.longestteamkillstreak$$</b></td>
</tr>

<tr align=left>
<th><b>Team Wins</b></th><td><b>$$player.teamwins$$</b></td>
<th><b>Team Losses</b></th><td><b>$$player.teamlosses$$</b></td>
<th><b>Team Kills</b></th><td><b>$$player.teamkills$$</b></td>
</tr>
<tr><td colspan=7>$$include playerprofile.html$$</td></tr>
<tr><td colspan=7>$$include playerenemies.html$$</td></tr>
<tr><td colspan=7>$$include playerspeech.html$$</td></tr>

</table>
<table align=center border=1 cellspacing=0 class=custom2 width=900px>
<tr><th height=30px colspan=4><font face=arial size=-1>Rounds Played</font></th></tr>
$$loop row as gametypelist index as gametypelistindex select count(*),* from playerinround,view_rounds where playerindex='%%player.playerindex%%' and playerinround.roundindex=view_rounds.roundidx group by gametype$$
$$gametype=gametypelist.gametype$$
$$gametyperealname=gametypelist.gametyperealname$$
$$gametypeimage=gametypelist.gametypeimage$$
<tr width=100%>
<td>
   <table align=center border=1 cellspacing=0 width=900px class=custom2>
   <tr valign=top>
      <td width=655px>
      <table border=1 cellspacing=0 class=custom2 width=245px>
	<th>Gametype</th>
        <tr><td colspan=4 align=center>
		<a href="gametype_$$gametypelist.gametypeid$$.html">$$if (gametypeimage !EQUALS "")$$<img src="$$gametypeimage$$"><br>$$endif$$$$gametyperealname$$</a>
	</td><tr>
        $$bestscore=""$$
        $$worstscore=""$$
        $$bestskill=""$$
        $$worstskill=""$$
        $$bestscoreround=""$$
        $$worstscoreround=""$$
        $$bestskillround=""$$
        $$worstskillround=""$$
        $$loop row as round index as roundindex select * from playerinround where playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by score desc limit 1$$
	$$bestscore=round.score$$
	$$bestscoreround=round.roundindex$$
	$$endloop$$
        $$loop row as round index as roundindex select * from playerinround where playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by score asc limit 1$$
	$$worstscore=round.score$$
	$$worstscoreround=round.roundindex$$
	$$endloop$$
        $$loop row as round index as roundindex select * from playerinround where playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by skill desc limit 1$$
	$$bestskill=round.skill$$
	$$bestskillround=round.roundindex$$
	$$endloop$$
        $$loop row as round index as roundindex select * from playerinround where playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by skill asc limit 1$$
	$$worstskill=round.skill$$
	$$worstskillround=round.roundindex$$
	$$endloop$$

	$$killstreak=""$$
	$$killstreakender=""$$
	$$deathstreak=""$$
	$$deathstreakender=""$$
	$$teamkillstreak=""$$
	$$teamkillstreakender=""$$

    $$loop row as streak index as streakindex select * from streakdata where streaktype='0' and playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by streaksize desc limit 1$$
	$$killstreak=streak.streaksize$$
	$$streakendindex=streak.streakender$$
	$$if (streakendindex !EQUALS "-1")$$
		$$loop row as streakplayer index as streakplayerindex select * from player where playerindex='%%streakendindex%%'$$
			$$killstreakender=streakplayer.name$$
			$$if (streakplayer.dropped EQUALS "Y")$$$$killstreakender=""$$$$endif$$
		$$endloop$$
	$$endif$$
	$$endloop$$

    $$loop row as streak index as streakindex select * from streakdata where streaktype='1' and playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by streaksize desc limit 1$$
	$$deathstreak=streak.streaksize$$
	$$streakendindex=streak.streakender$$
	$$if (streakendindex !EQUALS "-1")$$
		$$loop row as streakplayer index as streakplayerindex select * from player where playerindex='%%streakendindex%%'$$
			$$deathstreakender=streakplayer.name$$
			$$if (streakplayer.dropped EQUALS "Y")$$$$deathstreakender=""$$$$endif$$
		$$endloop$$
	$$endif$$
	$$endloop$$

    $$loop row as streak index as streakindex select * from streakdata where streaktype='2' and playerindex='%%player.playerindex%%' and roundindex in (select roundidx from view_rounds where gametype='%%gametype%%') order by streaksize desc limit 1$$
	$$teamkillstreak=streak.streaksize$$
	$$streakendindex=streak.streakender$$
	$$if (streakendindex !EQUALS "-1")$$
		$$loop row as streakplayer index as streakplayerindex select * from player where playerindex='%%streakendindex%%'$$
			$$teamkillstreakender=streakplayer.name$$
			$$if (streakplayer.dropped EQUALS "Y")$$$$teamkillstreakender=""$$$$endif$$
		$$endloop$$
	$$endif$$
	$$endloop$$
	<tr>
	<table border=1 cellspacing=0 class=custom2 width=100%>
	<tr><th align=left colspan=2 width=50%><b>Best Scoring</b></th><td width=25% align=center><b>$$formatfloat("%.1f",bestscore)$$</b></td><td width=25% align=center>[<a href="round_$$bestscoreround$$.html">$$formatinteger("%05d",bestscoreround)$$</a>]</td></tr>
	<tr><th align=left colspan=2 width=50%><b>Worst Scoring</b></th><td width=25% align=center><b>$$formatfloat("%.1f",worstscore)$$</b></td><td width=25% align=center>[<a href="round_$$worstscoreround$$.html">$$formatinteger("%05d",worstscoreround)$$</a>]</td></tr>
	<tr><th align=left colspan=2 width=50%><b>Most Skillful</b></th><td width=25% align=center><b>$$formatfloat("%.1f",bestskill)$$</b></td><td width=25% align=center>[<a href="round_$$bestskillround$$.html">$$formatinteger("%05d",bestskillround)$$</a>]</td></tr>
	<tr><th align=left colspan=2 width=50%><b>Least Skillful</b></th><td width=25% align=center><b>$$formatfloat("%.1f",worstskill)$$</b></td><td width=25% align=center>[<a href="round_$$worstskillround$$.html">$$formatinteger("%05d",worstskillround)$$</a>]</td></tr>
	<tr><th colspan=4 width=100% align=center><b>Longest Streaks</b></th></tr>
	<tr><th align=left colspan=1 width=25%></th><th width=25%><b>#</b></th><th colspan=2 width=50%><b>Ended By</b></th></tr>
	<tr><th align=left colspan=1 width=25%><b>Kill</b></th><td width=25% align=center><b>$$killstreak$$</b></td><td colspan=2 width=50%><b><font face=tahoma size=-2><a href="player_$$hash(killstreakender)$$.html">$$colouredtext2html(killstreakender)$$</a></font></b></td></tr>
	$$if (deathstreak !EQUALS "")$$
	<tr><th align=left colspan=1 width=25%><b>Death</b></th><td width=25% align=center><b>$$deathstreak$$</b></td><td colspan=2 width=50%><b><font face=tahoma size=-2><a href="player_$$hash(deathstreakender)$$.html">$$colouredtext2html(deathstreakender)$$</a></font></b></td></tr>
	$$endif$$
	$$if (teamkillstreak !EQUALS "")$$
	<tr><th align=left colspan=1 width=25%><b>TK</b></th><td width=25% align=center><b>$$teamkillstreak$$</b></td><td colspan=2 width=50%><b><font face=tahoma size=-2><a href="player_$$hash(teamkillstreakender)$$.html">$$colouredtext2html(teamkillstreakender)$$</a></font></b></td></tr>
	$$endif$$
      </table>
      </td>
      <td width=100% valign=top>
         $$loop row as round index as roundindex select * from view_rounds where view_rounds.gametype='%%gametype%%' and view_rounds.roundidx in (select roundindex from playerinround where playerinround.playerindex='%%player.playerindex%%')$$
         [<a href="round_$$round.roundidx$$.html">$$formatinteger("%05d",round.roundidx)$$</a>] 
         $$endloop round$$
      </td>
   </tr>
   </table>
</td>
</tr>
</table>
<br>
$$endloop gametypelist$$
</table>
$$closefile$$