[Pytanie] Ranking edytowanie how?

[derezem147]

Witam, edytował by mi ktoś ten ranking tak aby pokazywał lvl od największego do najmniejszego oraz żeby nie było tam gm? z gory dzięki

<div id="content">
	<div class="con_ui con_title"><h2>Lista Rankingowa</h2></div>
    	<div class="con_ui con_cont">
        <div class="con_middle">
        <style type="text/css">
		.tr {
			background:url(style/images/th.png);
			width:485px;
			height:30px;
		}
		</style>
<?php
echo "<center>";

        mysql_select_db('player'); 

    $test = "SELECT * from player";
        $testquery = mysql_query($test);
            $num2 = mysql_num_rows($testquery);

        if($_GET['max']) {
            $get = $_GET['max'];
        } else {
        $get = '0';


    $max = $get + 20;
    $max2 = $get - 20;

if($get > $num2) {
}
elseif($get >= 20 && $get < $num2) {  }
elseif ($num2 <= 20) { echo ""; }
else {  }
echo "</center><br>";
?>

<center><div class="tr"><table border="0">
    <tr>
        <th width="50">LP</th>
        <th width="270">Nick</th>
        <th width="155">Poziom</th>
        <th width="200">Exp</th>
        <th width="70">Krolestwo</th>
    </tr>
</table></div></center>
<?php

        mysql_select_db('player');


    $rank = "SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' and name NOT LIKE '[SA]%' and name NOT LIKE '[SGM]%'";
        $query = mysql_query($rank);
    echo "<center><table border=\"0\" width=\"458\">";
    $i = 0;

            while($array = mysql_fetch_array($query)) {
                $i = $i + 1;


                echo "
                <tr>
                <th width=\"10\">".$i."</th>
                <th width=\"270\">".$array["name"]."</th>
                <th width=\"155\">".$array["level"]."</th>
                <th width=\"200\">".$array["exp"]."</th>";



                $reich = "SELECT empire from player_index where id = " . $array[account_id] . "";
                    $query2 = mysql_query($reich);
                    $array2 = mysql_fetch_array($query2);


                if($array2["empire"] == 1) {
                echo "<th width=\"100\"><img src=\"style/images/1.jpg\"></th></tr>";
                } elseif($array2["empire"] == 2) {
                echo "<th width=\"100\"><img src=\"style/images/2.jpg\"></th></tr>";
                } else {
                echo "<th width=\"100\"><img src=\"style/images/3.jpg\"></th></tr>";
                }
                }
    echo "</table></center><br>"; // close table


}
?>
        </div>
        <div id="clear"></div>
        </div>
	<div class="con_ui con_bt"></div>
</div>

 

 

[derezem147]

ref

[Fakel]

SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' and name NOT LIKE '[SA]%' and name NOT LIKE '[SGM]%'

 

jeśli masz postac np [GM]Nick to go nie wyświetli w rankingu .

 

a tu masz żeby było od największego lvl .

 

 

SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' and name NOT LIKE '[SA]%' and name NOT LIKE '[SGM]%' ORDER BY level desc, exp