$$openfile info.html$$
$$include menu.include$$
<title>CoD2 Stats Info</title>

<br>
<br>

<table border=0 class=nameplate align=center>
	<tr><td width=298 height=50 background="general/nameplate.jpg"><div align="center"><b>Stats Information</b></div></td></tr>
</table>

<br>

<table border=0 cellspacing=0 align=center class=style2>
<tr align=center>
<th id=index height=27px colspan=2>SKILL CALCULATION</th>
</tr>
<br>




<tr align=center>
<td>

<table align=center cellspacing=0 border=0 class=style5  width=250px>
<tr align=center>	
</tr>
<tr valign=middle>	
<td><img name=picture src="locations/player.jpg"></td>
</tr>
</table>
</td>

<td valign=top>
<table align=center class=style2 border=0 cellspacing=1 width=250px>
<tr align=center>
	<th height=27px>Location</th>
	<th>Value</th>
</tr>
$$loop row as weight index as weightindex select * from SkillWeights where key like 'location_%' order by key desc$$
<tr>
	<td height=27px align=center>
		$$if (weight.image !EQUALS "")$$<onmouseover = "doButtons('locations/$$weight.image$$')" onmouseout = "doButtons('locations/player.jpg', 'locations/player.jpg')">$$endif$$$$weight.realname$$</td>
	<td width=50px align=center>$$weight.weight$$</td>
</tr>
$$endloop$$
</table>
</td>
</table>

<br><br>

<table border=0 cellspacing=0 align=center class=style2>
<tr align=center>
<th id=index height=27px colspan=2>SCORE CALCULATION</th>
</tr>
<tr width=100%>
	<td>
		<table align=center border=0 cellspacing=1 class=style2 width=520px>
			<tr>
				<th align=center height=27px>Type</th>
				<th align=center>Value</th>
			</tr>
			<tr>
				<td colspan=2 align=center height=6px>&nbsp;</td>
			</tr>
$$loop row as weight index as weightindex select * from ScoreWeights order by key asc$$
			<tr height=27px align=left>
				<td>$$weight.realname$$</td>
				<td width=50px align=center>$$weight.weight$$</td>
			</tr>
$$endloop$$
		</table>
		</table>	
	</td>
</tr>

<br><br>

<table border=0 cellspacing=0 align=center class=style2>
<tr align=center>
<th id=index height=27px colspan=2>SCORE CALCULATION</th>
</tr>
<tr width=100%>
	<td>
		<table align=center border=0 cellspacing=0 class=style2 width=520px>							
			<tr>	
				<th align=center height=27px>GameType</th>
				<th align=center>Value</th>
			</tr>
			<tr>
				<td colspan=2 align=center height=6px>&nbsp;</td>
			</tr>
$$loop row as weight index as weightindex select * from SkillWeights where key like 'gametype_%' order by realname asc$$
			<tr>
				<td align=center>$$if (weight.image !EQUALS "")$$<img src="gametypes/$$weight.image$$" width=200 height=151><br>$$else$$<img src="default/defaultgametype.jpg" width=200 height=151><br>$$endif$$$$weight.realname$$</td>
				<td width=50px align=center>$$weight.weight$$</td>
			</tr>
$$endloop$$
		</table>
		</table>	
		<br><br>
	</td>
</tr>

<table border=0 cellspacing=0 align=center class=style2>
<tr align=center>
<th id=index height=27px colspan=2>SKILL CALCULATION</th>
</tr>

<tr width=100%>
	<td>
		<table align=center border=0 cellspacing=1 class=style2 width=520px>							
			<tr>	
				<th align=center height=27px>Weapon</th>
				<th align=center>Value</th>
			</tr>
			<tr>
				<td colspan=2 align=center height=6px>&nbsp;</td>
			</tr>
$$loop row as weight index as weightindex select * from SkillWeights where key like 'weapon_%' order by realname asc$$
			<tr>
				<td align=center>$$if (weight.image !EQUALS "")$$<img src="weapons/$$weight.image$$" width=256 height=113><br>$$else$$<img src="default/defaultweapon.jpg" width=256 height=113><br>$$endif$$$$weight.realname$$</td>
				<td width=50px align=center>$$weight.weight$$</td>
			</tr>
$$endloop$$
		</table>
		</table>	
		
	</td>
</tr>
<br>
<br>
<tr width=100%>
	<td>
		<table align=center border=0 cellspacing=0 class=style2 width=1024px>	
			<tr>
				<th id=index align=center height=27px>AWARD</th>
				<th id=index align=center>Factors</th>
			</tr>
			<tr>
				<td colspan=2 align=center height=6px>&nbsp;</td>
			</tr>
			$$loop row as awarddef index as awarddefindex select * from awarddefinition$$
			$$pointsrecorded="0"$$
			$$loop row as awardpoints index as awardpointsindex select count(*) from awardpoints where awardindex='%%awarddef.awardindex%%'$$
				$$pointsrecorded=awardpoints.0$$
			$$endloop awardpoints$$
			$$if (pointsrecorded !EQUALS "0")$$
			<tr>
				<td valign=top align=center height=425px width=168px>$$if (awarddef.image !EQUALS "")$$<img src="awards/$$awarddef.image$$"><br><br>$$else$$<img src="default/default.jpg"><br><br>$$endif$$$$awarddef.name$$$$if (awarddef.weighted EQUALS "Y")$$<br>(weighted)$$endif$$</td>
				$$positivelocationkills=""$$
				$$positivelocationdeaths=""$$
				$$positivelocationtks=""$$
				$$positiveweaponkills=""$$
				$$positiveweapondeaths=""$$
				$$positiveweapontks=""$$
				$$positiveactions=""$$
				$$positivemisc=""$$
				$$positivexp=""$$
				$$negativelocationkills=""$$
				$$negativelocationdeaths=""$$
				$$negativelocationtks=""$$
				$$negativeweaponkills=""$$
				$$negativeweapondeaths=""$$
				$$negativeweapontks=""$$
				$$negativeactions=""$$
				$$negativemisc=""$$
				$$negativexp=""$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionaction where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positiveactions="%%positiveactions%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativeactions="%%negativeactions%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionmisc where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positivemisc="%%positivemisc%%- %%awardcomponent.id%%<br>$$
					$$else$$
						$$negativemisc="%%negativemisc%%- %%awardcomponent.id%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionxp where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positivexp="%%positivexp%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativexp="%%negativexp%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionlocationtk where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positivelocationtks="%%positivelocationtks%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativelocationtks="%%negativelocationtks%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionlocationkill where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positivelocationkills="%%positivelocationkills%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativelocationkills="%%negativelocationkills%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionlocationdeath where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positivelocationdeaths="%%positivelocationdeaths%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativelocationdeaths="%%negativelocationdeaths%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionweapontk where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positiveweapontks="%%positiveweapontks%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativeweapontks="%%negativeweapontks%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionweaponkill where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positiveweaponkills="%%positiveweaponkills%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativeweaponkills="%%negativeweaponkills%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				$$loop row as awardcomponent index as awardcomponentindex select * from awarddefinitionweapondeath where awardindex='%%awarddef.awardindex%%'$$
					$$if (awardcomponent.posneg EQUALS "+")$$
						$$positiveweapondeaths="%%positiveweapondeaths%%- %%awardcomponent.name%%<br>$$
					$$else$$
						$$negativeweapondeaths="%%negativeweapondeaths%%- %%awardcomponent.name%%<br>$$
					$$endif$$
				$$endloop$$
				<td align=left valign=top>
					<table border=0 cellspacing=1 class=style1 width=100%>	
					<tr><th id=index colspan=4>POSITIVE EFFECT</th></tr>
					<tr><th width=25%>Weapons</th><th width=25%>Locations</th><th width=25%>Objectives</th><th width=25%>Other</th></tr>
					<tr>
						<td>
							$$if (positiveweaponkills !EQUALS "")$$<u><b>Kills:</b></u><br>$$positiveweaponkills$$<br>$$endif$$
							$$if (positiveweapondeaths !EQUALS "")$$<u><b>Deaths:</b></u><br>$$positiveweapondeaths$$<br>$$endif$$
							$$if ("%%positiveweaponkills%%%%positiveweapondeaths%%" EQUALS "")$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (positivelocationkills !EQUALS "")$$<u><b>Kills:</b></u><br>$$positivelocationkills$$<br>$$endif$$
							$$if (positivelocationdeaths !EQUALS "")$$<u><b>Deaths:</b></u><br>$$positivelocationdeaths$$<br>$$endif$$
							$$if ("%%positivelocationkills%%%%positivelocationdeaths%%" EQUALS "")$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (positiveactions !EQUALS "")$$$$positiveactions$$$$else$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (positivemisc !EQUALS "")$$$$positivemisc$$$$else$$&nbsp;$$endif$$
						</td>
					</tr>
					<tr><th id=index colspan=4>NEGATIVE EFFECT</th></tr>
					<tr><th width=25%>Weapons</th><th width=25%>Locations</th><th width=25%>Objectives</th><th width=25%>Other</th></tr>
					<tr>
						<td>
							$$if (negativeweaponkills !EQUALS "")$$<u><b>Kills:</b></u><br>$$negativeweaponkills$$<br>$$endif$$
							$$if (negativeweapondeaths !EQUALS "")$$<u><b>Deaths:</b></u><br>$$negativeweapondeaths$$<br>$$endif$$
							$$if ("%%negativeweaponkills%%%%negativeweapondeaths%%" EQUALS "")$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (negativelocationkills !EQUALS "")$$<u><b>Kills:</b></u><br>$$negativelocationkills$$<br>$$endif$$
							$$if (negativelocationdeaths !EQUALS "")$$<u><b>Deaths:</b></u><br>$$negativelocationdeaths$$<br>$$endif$$
							$$if ("%%negativelocationkills%%%%negativelocationdeaths%%" EQUALS "")$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (negativeactions !EQUALS "")$$$$negativeactions$$$$else$$&nbsp;$$endif$$
						</td>
						<td>
							$$if (negativemisc !EQUALS "")$$$$negativemisc$$$$else$$&nbsp;$$endif$$
						</td>
					</tr>
					</table>
				</td>
			</tr>
			$$endif$$
			$$endloop$$
		</table>
	</td>
</tr>
</table>
$$closefile$$
