<?php include("config.php");?>
<link rel="stylesheet" type="text/css" href="style.css">
<body bgcolor="070707"><div align="center">
<font color="ffffff" size="1" face="arial">
<?php
$query = mssql_query("SELECT TOP 10 * FROM Character order by xP Desc");
?>
<style type="text/css">
<!--
.style28 {font-size: 10px}
.style29 {color: #000000; font-weight: ; font-size: 10px; }
.style1 { font-size: 10px;
font-weight: ;
}
-->
</style>
<table width="250" border="0">
<tr >
<th colspan="0" scope="row"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="3">Player's
Ranking</font></th>
</tr>
<tr>
<th width="24" scope="row"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif"><span class="style28"><strong>#</strong></span></font></th>
<td width="24"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif"><span class="style28"><strong>Name</strong></span></font></td>
<td width="23"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif"><span class="style28"><strong>Level</strong></span></font></td>
</tr>
<?php
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
?>
<tr>
<th scope="row"><span class="style28"><strong><?php echo "$rank";?></strong></span></th>
<td><span class="style28"><strong><?php echo "$row[2]" ;?></strong></span></td>
<td><span class="style28"><strong><?php echo "$row[3]";?></strong></span></td>
</tr>
<?php }?></div>
</table>