$$openfile awardlist.html$$
$$include menu.html$$
<table border=1 cellspacing=1 class=custom3 width=100% valign=top>
<tr><th colspan=3 align=center>Awards</th></tr>
$$awardprint=""$$
$$loop row as awarddef index as awarddefindex select * from awarddefinition$$
	$$pointsrecorded="0"$$
	$$loop row as awardpoints index as awardpointsindex select count(*) from view_awardpoints where awardindex='%%awarddef.awardindex%%'$$
		$$pointsrecorded=awardpoints.0$$
	$$endloop awardpoints$$
	$$if (pointsrecorded !EQUALS "0")$$
		$$if (awardprint EQUALS "")$$<tr valign=top align=left>$$endif$$
		$$if (awardprint EQUALS "XX")$$</tr>$$awardprint=""$$$$endif$$
		$$awardprint="%%awardprint%%X"$$
		<th valign=top align=left>
			<table border=1 cellspacing=1 class=custom4 width=100%>
			<tr><th colspan=2 align=center><font face=verdana, arial size=+1>$$awarddef.name$$</font></th></tr>
			<tr valign=top>
				<td align=center>$$if (awarddef.image !EQUALS "")$$<img src="$$awarddef.image$$">$$endif$$</td>
				<td>
					<table border=1 cellspacing=2 class=custom4 width=100%>
					<tr>
						<th>#</th>
						<th>Player</th>
						<th>Score</th>
					</tr>
						$$loop row as awardpoints index as awardpointsindex select sum(score) as awardscore,playername,playerindex from view_awardpoints where awardindex='%%awarddef.awardindex%%' group by playerindex order by awardscore desc limit %%MAXAWARDPLAYERS%%$$
						$$if (awardpointsindex EQUALS "1")$$
						$$MessageCentre("AWARD%%awarddef.name%%",awardpoints.playername,awardpoints.awardscore)$$
						$$endif$$
						<tr>$$tablename="playerdataavatars"$$$$playerdataplayerindex=awardpoints.playerindex$$$$include playerprofilecomponent.html$$
							<td align=center height=27px width=15px>$$awardpointsindex$$</td>
							<td width=180px><a href="player_$$hash(awardpoints.playername)$$.html"><font face=arial size=-1>$$colouredtext2html(awardpoints.playername)$$</font>$$if (playerdataavatars !EQUALS "")$$<br><img src="$$playerdataavatars$$" width=150>$$endif$$</a></td>
							<td align=center width=50px>$$awardpoints.awardscore$$</td>
						</tr>
						$$endloop awardpoints$$
					</table>
				</td>
			</tr>
			</table>
		</th>
	$$endif$$
$$endloop awarddef$$
$$if (awardprint !EQUALS "")$$</tr>$$awardprint=""$$$$endif$$
</table>

$$closefile$$