este es el codigo una ayuda pls
Código
<div id="content"> <div class="postui2 text-title"> <h2> Ranking </h2> </div> <div class="postui2 text-con"> <div class="con-wrap"> <center> <?PHP $CPSeite = 50; $markierteZeile=0; if(!checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite = 1; else $aSeite = $_GET['p']; } else { $aSeite = 1; } $sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang FROM ( SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang FROM ( SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0 FROM player.player LEFT JOIN player.player_index ON player_index.id = player.account_id LEFT JOIN player.guild_member ON guild_member.pid = player.id LEFT JOIN player.guild ON guild.id = guild_member.guild_id INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' ORDER BY player.level DESC , player.exp DESC ) AS t1 ) AS t2 $markierteZeile = $getRang->rang; } } } $sqlCmd = "SELECT COUNT(*) AS summeChars FROM player.player LEFT JOIN player.player_index ON player_index.id=player.account_id LEFT JOIN player.guild_member ON guild_member.pid=player.id LEFT JOIN player.guild ON guild.id=guild_member.guild_id INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' ORDER BY player.level DESC, player.exp DESC"; $cSeite = calcPages($getSum->summeChars,$aSeite,$CPSeite); ?> <form action="index.php?git=rankings" method="POST"> <table> <tr> <th class="topLine">Charaktersuche:</th> <td class="thell" style="text-align:center;"><input type="text" name="charakter" maxlength="20" size="20"/></td> <td class="tdunkel" style="text-align:center;"><input type="submit" name="suche" value="suchen" maxlength="20" size="20"/></td> </tr> </table> </form> <?PHP $maxRange = 5; $maxStep = 15; if(($aSeite-$maxRange)>0) $sStart = $aSeite-$maxRange; else $sStart = 1; if(($aSeite+$maxRange)<=$cSeite[0]) $sEnde = $aSeite+$maxRange; else $sEnde = $cSeite[0]; echo '<table> <tr> <td class="tdunkel">'; if(($aSeite-$maxStep)>0) echo '<a href="index.php?git=rankings&p='.($aSeite-$maxStep).'">'.($aSeite-$maxStep).'</a> «'; else echo '<a href="index.php?git=rankings&p=1">1</a> «'; echo'</td>'; for($i=$sStart;$i<=$sEnde;$i++) { $sKlasse = ($i==$aSeite) ? "topLine" : "thell"; echo'<td class="'.$sKlasse.'" style="text-align:center;">'; echo'<a href="index.php?git=rankings&p='.$i.'">'.$i.'</a>'; echo'</td>'; } echo'<td class="tdunkel" style="text-align:right;">'; if(($aSeite+$maxStep)<=$cSeite[0]) echo '» <a href="index.php?git=rankings&p='.($aSeite+$maxStep).'">'.($aSeite+$maxStep).'</a>'; else echo '» <a href="index.php?git=rankings&p='.$cSeite[0].'">'.$cSeite[0].'</a>'; echo'</td>'; echo'</table>'; ?> <table width="408"> <tr> <th class="topLine">Platz</th> <th class="topLine">Charakter</th> <th class="topLine">Level</th> <th class="topLine">EXP</th> <th class="topLine">Gilde</th> <th class="topLine">Reich</th> </tr> <?PHP $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name FROM player.player LEFT JOIN player.player_index ON player_index.id=player.account_id LEFT JOIN player.guild_member ON guild_member.pid=player.id LEFT JOIN player.guild ON guild.id=guild_member.guild_id INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' ORDER BY player.level DESC, player.exp DESC LIMIT ".$cSeite[1].",".$CPSeite; //echo $sqlCmd; $x=$cSeite[1]+1; $zF = ($x%2==0) ? "thell" : "tdunkel"; if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; } echo "<tr>"; echo "<td class=\"$zF\">".$x."</td>"; echo "<td class=\"$zF\">".$getPlayers->name."</td>"; echo "<td class=\"$zF\">".$getPlayers->level."</td>"; echo "<td class=\"$zF\">".$getPlayers->exp."</td>"; echo "<td class=\"$zF\">".$getPlayers->guild_name."</td>"; echo "<td class=\"$zF\">"; echo '<img src="img/reiche/'.$getPlayers->empire.'_kl.jpg" title="Reich" alt="Reich"/>'; } echo "</td>"; echo "</tr>"; $x++; } ?> </table></center> </div> </div> <div class="postui2 text-end"> </div></div>
MOD: UTILIZAR ETIQUETA GESHI PARA CÓDIGOS ([code][/code]) LEER REGLAS -> Normas de subforo de Desarrollo Web & Normas del subforo de PHP!