Trato de hacer un sistema de ranking en mi web, pero no me lo hace bien.
Este es mi codigo:
Código PHP:
<?php
if(!isset($_SESSION['usuario'])){
ir("index.php?id=login&next=".nextUrl());
exit;
}
$user=$_SESSION['usuario'];
$data=usuario($user);
$datTg=empty($_GET['dat'])?'level':$_GET['dat'];
$arrayRank=array('level','oro','ataque','defensa','vida');
echo '<div class="info-title">Ranking | <a href="index.php?id=rank&dat=level">Nivel</a> | <a href="index.php?id=rank&dat=oro">Oro</a> | <a href="index.php?id=rank&dat=ataque">Ataque</a> | <a href="index.php?id=rank&dat=defensa">Defensa</a> | <a href="index.php?id=rank&dat=vida">Vida</a></div>';
if(in_array($datTg,$arrayRank)){
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%" bgcolor="#000000">#</td>
<td width="17%" bgcolor="#000000">Usuario</td>
<td width="14%" bgcolor="'.($datTg=='level'?'#171717':'#000000').'">Nivel</td>
<td width="17%" bgcolor="'.($datTg=='ataque'?'#171717':'#000000').'">Ataque</td>
<td width="23%" bgcolor="'.($datTg=='defensa'?'#171717':'#000000').'">Defensa</td>
<td width="12%" bgcolor="'.($datTg=='vida'?'#171717':'#000000').'">Vida</td>
<td width="13%" bgcolor="'.($datTg=='oro'?'#171717':'#000000').'">Oro</td> </tr>';
$rank=1;
$sql='SELECT * FROM user ORDER BY '.$datTg.' DESC LIMIT 0,20';
$Sqll = mysql_query($sql) or die(mysql_error());
while($dat= mysql_fetch_array($Sqll)){
echo '<tr>
<td width="4%">'.$rank.'</td>
<td width="17%">'.$dat['usuario'].'</td>
<td width="18%"'.($datTg=='level'?' bgcolor="#171717 "':'').'>'.$dat['level'].'</td>
<td width="17%"'.($datTg=='ataque'?' bgcolor="#171717 "':'').'>'.$dat['ataque'].'</td>
<td width="23%"'.($datTg=='defensa'?' bgcolor="#171717 "':'').'>'.$dat['defensa'].'</td>
<td width="12%"'.($datTg=='vida'?' bgcolor="#171717 "':'').'>'.$dat['vida'].'</td>
<td width="13%"'.($datTg=='oro'?' bgcolor="#171717 "':'').'>'.$dat['oro'].'</td>
</tr>';
$rank++;
}
echo '</table>'.$sql;
}else{
echo "<div class=\"error\">ERROR!</div>";
}
?> Gracias
Salu2
