<table border='0' width='100%' cellspacing='0' cellpadding='0'><tr>
<?php
//(c)SanneA
     $chars = mssql_query("SELECT TOP 5 Name,cLevel,Reset,Class,AccountID FROM Character WHERE ctlcode !='32' AND ctlcode !='8' ORDER BY reset desc, clevel desc");
  echo "<td width='14'><b>#</b></td>
        <td><b>".mmw_lang_character."</b></td>
        <td align='right' width='10'><b>".mmw_lang_level."</b></td></td>";

  for($i=0; $i<5; ++$i) {
     $rank = $i + 1;
     $char = mssql_fetch_row($chars);
     $status = mssql_fetch_row(mssql_query("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id='$char[4]'"));
  if($status[0] == 1) {$status[0] ='<fon color="green">'.mmw_lang_online.'</font>';}
   else {$status[0] ='<fon color="red">'.mmw_lang_offline.'</font>';}
     $guild = mssql_fetch_row(mssql_query("Select G_Name from GuildMember where Name='$char[0]'"));
  if ($guild[0] == "" || $guild[0] == " ") {$guild[0] = "-";}
     $title = "<center>".mmw_lang_reset.": ".$char[2]."<br>
                       ".mmw_lang_level.": ".$char[1]."<br>
                       ".mmw_lang_class.": ".char_class($char[3],full)."<br>
                       ".mmw_lang_guild.": ".$guild[0]."<br>
                       ".mmw_lang_status.": ".$status[0]."<br></center>";
  echo "<tr>
         <td>$rank.</td>
         <td><a title='".$title."' href=?op=character&character=$char[0]>$char[0]</a></td>
         <td align='center'>$char[1]</td>
        </tr>";
  }
?>
</tr></table>