[Pytanie]Kto mi zedytuje ranking graczy

[xXxQGxXx]

Kto mi to zedytuje zeby nie było widac zbanowanych

 

<?php

require_once("config.php");

$database = mysql_select_db("player");

if(isset($_GET['poz']) && $_GET['poz'] != '') {

$poz1 = addslashes($_GET['poz'])-25; $poz = addslashes($_GET['poz']); $poz2 = addslashes($_GET['poz'])+25;

}

else {

$poz1 = '-25'; $poz = '0'; $poz2 = '25';

}

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit $poz,25");

//$query = mysql_query("SELECT * FROM account WHERE status='BLOCK'");

 

echo "<td>#";

echo "<td>Nazwa</td>";

echo "<td>Level</td>";

echo "<td>Czas Gry</td>";

echo "<td>Do?wiadczenie</td>";

echo "<td>Królestwo</td>";

echo "</tr>";

$i = $poz+1;

while($player = mysql_fetch_array($query))

 

if($player["id"] != 273) {

 

 

echo "<tr class='rank_player'>";

echo "<td>".$i."</td>";

echo "<td><a href=profile.php?name=".$player['name']."><font color='#7FFF00'>".$player["name"]."</font></td>";

echo "<td>".$player["level"]."</td>";

echo "<td>".$player["playtime"]." min.</td>";

echo "<td>".$player["exp"]."</td>";

$query2 = mysql_query("SELECT * FROM player_index WHERE id LIKE '$player[account_id]'");

while($player2 = mysql_fetch_array($query2))

if($player2['empire'] == 1) {

echo "<td align='center'><img src='images/krolestwa/Shinsoo.jpg'</td>";

}

elseif($player2['empire'] == 2) {

echo "<td align='center'><img src='images/krolestwa/Chunjo.jpg'</td>";

}

else {

echo "<td align='center'><img src='images/krolestwa/Jinno.jpg'</td>";

}

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player "));

$num=$rs[0];

echo "</tr> </table>";

echo "".($poz1>='0' ? "<a href='?poz=".$poz1."'><span style='font-size:12px;'>[<- Poprzednia strona]</a></span>  " : "").($poz2<$num ? "<a href='?poz=".$poz2."'><span style='font-size:12px;'>[Nastepna strona ->]</a></span>" : "")."";

?>

[.Carni]

Po prostu musisz dopisać kolejne AND name NOT LIKE '.....'

W tym przypadku nie wiem jak nazywają się zbanowane konta..