NEW RANK WITH RAZE

Humm try with this, it's faster

Exemple :
PHP Code:

			
        <?php

         $NbJoueur="50"; //Number player on a page

         If (!isset($_GET['page'])){

            $Page = "1";

        }Else{

            $Page = $_GET['page'];

        }

        ?><center><?php if ($Page <= 1) { echo "Previous page"; }

              else  { ?> <a href="index.php?page=<?php echo $Page-1; ?>">Previous page</a> <?php } ?> || <a href="index.php?page=<?php echo $Page+1; ?>">Next page</a></center><br> <?php

         echo '<center><table width="800" border="1">';

echo '    <tr>

        <td><center>Posizione</center></td>

        <td><center>Nombre</center></td>

        <td><center>Raza</center></td>

        <td><center>Level</center></td>

        <td><center>Reino</center></td>

        <td><center>Guild</center></td>

        <td><center>Exp</center></td>

        <td><center>Play time</center></td>

            </tr>

        

    <tr>';

                                        @require_once("conn.php");

                    @mysql_select_db("player");

                    $query = @mysql_query("SELECT player.playtime,player.name,player.job,player.exp,player.level,player_index.empire,account.id FROM player,player_index,account.account WHERE player.account_id = player_index.id AND (player.account_id = account.id) AND (account.status='OK') AND ( not (name like '[%' ) ORDER BY level DESC,exp DESC LIMIT ".($Page-"1")*$NbJoueur.",".$NbJoueur."");

                        

while ($row = @mysql_fetch_array($query)){

                        $i++;

                        $PlaceNb = ($Page-1)*$NbJoueur;

                        ?>

                        

                        <td><center><?php echo $PlaceNb+$i; ?></center></td>

                        

                        <td><center><?php echo $row['name']; ?></center></td>

                        

                        <td><center><?php if($row['job']==2 or $row['job']==6) echo '<div align=\'center\'>Sura</div>';

                        if($row['job']==4 or $row['job']==0) echo '<div align=\'center\'>Warrior</div>';

                        if($row['job']==3 or $row['job']==7) echo '<div align=\'center\'>Mage</div>';

                        if($row['job']==1 or $row['job']==5) echo '<div align=\'center\'>Assassin</div>'; ?></center></td>

                        

                        <td><center><?php echo $row['level']; ?></center></td>

                        

                        <td><center><?php if($row['empire']==1) echo '<div align=\'center\'><img src="images/shinsoo.jpg"></div>';

                        if($row['empire']==2) echo '<div align=\'center\'><img src="images/chunjo.jpg"></div>';

                        if($row['empire']==3) echo '<div align=\'center\'><img src="images/jinno.jpg"></div>'; ?></center></td>

                        <td><center><?php $idplayer=mysql_query("select id from player.player where name='".$row['name']."'");

                                          $pouili=mysql_fetch_array($idplayer);

                                          $guild ="select guild_id from player.guild_member where pid='".$pouili[0]."'";

                                          $queryguild=@mysql_query($guild);

                                          $idguild=@mysql_fetch_array($queryguild);

                                          $nomguild="select name from player.guild where id='".$idguild['guild_id']."'";

                                          $querynom=@mysql_query($nomguild);

                                          $nomguildd=@mysql_fetch_array($querynom);

                                          if ($nomguildd[0] == "") echo "No guild"; if ($nomguildd[0] != "") echo $nomguildd[0]; ?></center></td>

                        

                        <td><center><?php echo $row['exp']; ?></center></td>

                        <?php $seconde=$row['playtime']*60; ?>

                        <td><center><?php $total= $seconde;

   

      $jours=floor($total/86400);

   

      $reste=$total%86400;

   

      $heures=floor($reste/3600);

   

      $reste=$reste%3600;

   

      $minutes=floor($reste/60);

  

      $secondes=$reste%60;

      echo $jours;

      echo " Days ";

      echo $heures;

      echo " Hours ";

      echo $minutes;

      echo " minutes";

?></center></td>

                    

</tr>

<?php

}

echo '</table></center>';





?>

<br>

<center><?php if ($Page <= 1) { echo "Previous page"; }

              else  { ?> <a href="index.php?page=<?php echo $Page-1; ?>">Previous page</a> <?php } ?> || <a href="index.php?page=<?php echo $Page+1; ?>">Next page</a></center><br>