<div class="titulo_g"><span>HEROIS</span><em><a href="?pagina=heros">Herois</a> &nbsp;/&nbsp; <a href="?pagina=oly">Olimpidas</a></em></div>
<table class="table_r" cellpadding="0" cellspacing="2">
<tr class="tb_r_t">
<td class="centro">Posi&ccedil;&atilde;o</td>
<td>Nome do char</td>
<td class="centro">Level</td>
<td>Classe</td>
<td>Clan</td>
<td class="centro">Vezes</td>
</tr>
<?php
include('configs/config_info.php');
$sql = mysql_query("SELECT * FROM heroes ORDER BY count") or die(mysql_error());
$a = 1;
while($c = mysql_fetch_array($sql)) {
$h = mysql_query("SELECT * FROM characters WHERE ".$charId." = '".$c[$charId]."'") or die(mysql_error());
$n = mysql_fetch_array($h);
$l = mysql_query("SELECT * FROM class_list WHERE id = '".$n['base_class']."'") or die(mysql_error());
$g = mysql_fetch_array($l);
$i = mysql_query("SELECT * FROM clan_data WHERE clan_id = '".$n['clanid']."'") or die(mysql_error());
$j = mysql_fetch_array($i);
//$g['class_name'] = explode("_", $g['class_name']);
$j['clan_name'] = empty($n['clanid']) ? 'Sem Clan.' : $j['clan_name'];

if($a == 1) {
$img = '<img src="imagens/icones/corona05.gif" alt="1&ordm; Lugar" />';
}
elseif($a == 2 || $a == 3) {
$img = '<img src="imagens/icones/corona03.gif" alt="2&ordm; Lugar" />';
}
elseif($a >= 4 && $a <= 10){
$img = '<img src="imagens/icones/corona01.gif" alt="3&ordm; Lugar" />';
}else{
$img = $a."&ordm;";
}

$bclasse = $g['class_name'];
if( stristr($bclasse, 'k_') ){
$arrayr = array('Female', 'Male');
$rcls = str_replace($arrayr, '', $bclasse);
$classe = str_replace('K', 'Kamael', str_replace('_', ' ', $rcls));
}else{
$texto_corrido = substr(strstr($bclasse, '_'), 1);
$txt = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'X', 'W', 'Y', 'Z');
$rep = array(' A', ' B', ' C', ' D', ' E', ' F', ' G', ' H', ' I', ' J', ' K', ' L', ' M', ' N', ' O', ' P', ' Q', ' R', ' S', ' T', ' U', ' V', ' X', ' W', ' Y', ' Z');
$texto_separado = str_replace($txt, $rep, $texto_corrido);
$classe = substr($texto_separado,1);
}

?>
<tr>
<td class="centro"><?php echo $img; ?></td>
<td><strong><a href="#"><?php echo $n['char_name']; ?></a></strong></td>
<td class="centro"><?php echo $n['level']; ?></td>
<td><?php echo $classe; ?></td>
<td><?php echo $j['clan_name']; ?></td>
<td class="centro"><?php echo $c['count']; ?></td>
</tr>
<?php $a++; } ?>
</table>