$$loop row as totaltype index as totaltypeindex select * from %%table%%$$
$$openfile %%table%%_%%totaltype.id%%.html$$
$$messagecentrekey="Top%%table%%%%totaltype.id%%"$$
$$include menu.html$$
<table align=center border=1 class=custom4>
<tr><th>$$title$$:$$totaltype.realname$$</th></tr>
$$if (totaltype.image !EQUALS "")$$<tr><td align=center><img src="$$totaltype.image$$"></td></tr>$$endif$$
</table>
<br>
<table border=0 cellspacing=1 class=custom4 align=center>
<tr>
<th width=25px>#</th>
<th width=160px>Name</th>
<th width=50px>Kills</th>
<th width=50px>Deaths</th>
<th width=50px>Suicides</th>
<th width=50px>Team Kills</th>
<th width=50px>Kill %</th>
</tr>
$$totalkills=0$$
$$loop row as playertotal index as playertotalindex select sum(kills) as totalkills from view_killtotal%%suffix%% where itemindex='%%totaltype.idx%%'$$
$$totalkills=playertotal.totalkills$$
$$endloop$$
$$firstrow="Y"$$$$loop row as playertotal index as playertotalindex select *,coalesce((cast((kills * 100.0 ) as float)/%%totalkills%%.0),0.0) as percentage from view_killtotal%%suffix%% where itemindex='%%totaltype.idx%%' order by kills desc limit %%MAXTOTALLISTPLAYERS%%$$
<tr onMouseover="changeto(event, '494848')" onMouseout="changeback(event, '2f2f2f')" align=center>
$$if (firstrow EQUALS "Y")$$
	$$firstrow="N"$$
	$$MessageCentre(messagecentrekey,playertotal.name,playertotal.kills)$$
$$endif$$
<td>$$playertotalindex$$</td>$$tablename="playerdataavatars"$$$$playerdataplayerindex=playertotal.playerindex$$$$include playerprofilecomponent.html$$
<td align=left id="ignore"><a href="player_$$hash(playertotal.name)$$.html">$$colouredtext2html(playertotal.name)$$$$if (playerdataavatars !EQUALS "")$$<br><img src="$$playerdataavatars$$" width=150>$$endif$$</a></td>
<td>$$playertotal.kills$$</td>
<td>$$playertotal.deaths$$</td>
<td>$$playertotal.suicides$$</td>
<td>$$playertotal.teamkills$$</td>
<td>$$formatfloat("%.2f",playertotal.percentage)$$%</td>
</tr>
$$endloop playertotal$$
</table>
$$closefile$$
$$endloop totaltype$$