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>
