[Pytanie]Jak zrobic zeby nie było zbanowanych w top

[xXxQGxXx]

jak dodac do tego

 

 

<h4>Ranking Graczy</h4>

</div>

<div class="sbui sbcontent">

<div id="rankslider">

<ul>

<li>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

 

<tr class="head">

<td>#  </td>

<td>Nazwa</td>

<td>Level</td>

</tr>

<?php

require_once("config.php");

$database = mysql_select_db("player");

$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 10");

$i = 1;

 

while($player = mysql_fetch_array($query))

 

if($player["name"] != GM) {

 

echo "<tr><td class='sbrc1'>".$i."</td><td class='sbrc2'><font color='#008B8B'>".$player["name"]."</font></td><td class='sbrc3'>".$player["level"]."</td></tr>";

 

$i++;

}

?>

[lopescio]

Podaj nazwę kolumny w player, albo account, gdzie pisze OK albo BLOCK, bo nie mam aktualnie żadnej bazy pod ręką

[xXxQGxXx]

w account "status"

[xXxQGxXx]

i jak

[Pkmn]

W query dodaj

AND status != 'BLOCK'

[eMaxx]

W query dodaj

AND status != 'BLOCK'

 

No chyba nie, bo pole block nie jest w player, tylko w account.

 

<h4>Ranking Graczy</h4>
</div>
<div class="sbui sbcontent">
<div id="rankslider">
<ul>
<li>
<table width="100%" border="0"  cellspacing="0" cellpadding="0">

 <tr class="head">
<td>#  </td>
<td>Nazwa</td>
<td>Level</td>
 </tr>
<?php
require_once("config.php");
$query = mysql_query("SELECT * FROM player.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 10");
$i = 1;

while($player = mysql_fetch_array($query)){

$status = mysql_fetch_array(mysql_query("SELECT `status` FROM account.account WHERE `id`='".$player['account_id']."' LIMIT 1"));

   if($status['status'] == 'OK'){
       echo "<tr><td class='sbrc1'>".$i."</td><td class='sbrc2'><font color='#008B8B'>".$player["name"]."</font></td><td class='sbrc3'>".$player["level"]."</td></tr>";
       $i++;
   }
}
?>

[xXxQGxXx]

thx dział