<?PHP
// PHP Script By Vaflan
// For MyMuWeb
// Ver. 1.7

$top_rank = clean_var(stripslashes($_POST['top_rank']));
$race = clean_var(stripslashes($_POST['sort']));

if(empty($_POST['top_rank'])) {$top_rank = '100';}
if(empty($_POST['sort'])) {$race = 'all';}

$query_race['all'] = "class>='0'";
$query_race['dw'] = "class>='0' and class<='15'";
$query_race['dk'] = "class>='16' and class<='31'";
$query_race['elf'] = "class>='32' and class<='47'";
$query_race['mg'] = "class>='48' and class<='63'";
$query_race['dl'] = "class>='64' and class<='79'";
$query_race['sum'] = "class>='80' and class<='95'";
$query_race['rf'] = "class>='96' and class<='112'";

if($mmw['gm']=='no') {$no_gm_in_top = "and ctlcode!='32' and ctlcode!='8'";}
$result = @mssql_query("SELECT TOP $top_rank Name,Class,cLevel,AccountID,strength,dexterity,vitality,energy,leadership FROM Character WHERE ".$query_race[$race]." $no_gm_in_top ORDER BY reset DESC, clevel DESC");
$row_num = @mssql_num_rows($result);

echo "<br>".mmw_lang_top." $top_rank ".mmw_lang_characters."<br> </br>
           <table class='sort-table' border='0' cellpadding='0' cellspacing='0'>                 
           <thead><tr>
           <td>#</td>
           <td>".mmw_lang_character."</td>
           <td>".mmw_lang_level."</td>
           <td>".mmw_lang_class."</td>
           <td>".mmw_lang_guild."</td>
           </tr></thead>";

if($row_num==0) {
  echo '<tr><td colspan="6">'.mmw_lang_no_characters.'</td></tr>';
}

for($i=0; $i<$row_num; ++$i) {
  $rank = $i+1;
  $row = mssql_fetch_row($result);
  $status_reults = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='$row[4]'");
  $status = mssql_fetch_row($status_reults);
  $statusdc_reults = mssql_query("Select GameIDC from AccountCharacter where Id='$row[4]'");
  $statusdc = mssql_fetch_row($statusdc_reults);
  if(empty($_SESSION['guild_'.$row[0]])) {
   $guild_reults = mssql_query("Select G_Name from GuildMember where Name='$row[0]'");
   $_SESSION['guild_'.$row[0]] = mssql_fetch_row($guild_reults);
  }
  $guild = $_SESSION['guild_'.$row[0]];

  if($status[0] == 1 && $statusdc[0] == $row[0]) {$status[0] ='<img src='.default_img('online.gif').' width=6 height=6>';}
  else {$status[0] ='<img src='.default_img('offline.gif').' width=6 height=6>';}
?>
  <tbody>
   <tr>
    <td><?php echo $rank;?></td>
    <td><?php echo $status[0];?> <a href="?op=character&character=<?php echo $row[0];?>" title="<center><img src=<?php echo default_img(char_class($row[1],img));?>><br>Str: <?php echo $row[5];?><br>Agi: <?php echo $row[6];?><br>Vit: <?php echo $row[7];?><br>Ene: <?php echo $row[8];?><?php if($row[9]>0) {echo '<br>Com: '.$row[9];}?></center>"><?php echo $row[0];?></a></td>
    <td><?php echo $row[2];?></td>
    <td><?php echo char_class($row[1],off);?></td>
    <td><a href="?op=guild&guild=<?php echo $guild[0];?>"><?php echo $guild[0];?></a></td>
   </tr>
  </tbody>
<?php }?>
</table>