[Help] Rank

**omar2009** · 29-01-09

hey guys, sorry that i always ask >_>, i am pretty noob for post a helpful thread here
I want my rank page not show up the gm, only the normal players, i already have a rank page, but what do i need to write for showing only the normal players not with gms.
Thanks in advance !

**MentaL**

**caja** · 29-01-09

change the lvl of character of the ranking page
for no gm < 100

Here is my raknig page

rank.php

PHP Code:


<?php

require_once('inc/config2.inc.php');

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <head>
        <link href="style.css" rel="stylesheet" type="text/css"/>  
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    </head>
    <body>';

    
    $ref_sql = mysql_query("SELECT c.rebirths, c.level, c.charname, c.class, a.logged_in FROM characters AS C 
                                                    LEFT JOIN accounts AS a ON a.username = c.accountname
                                                    WHERE a.accesslevel = 100");

    while ( $ref = mysql_fetch_row($ref_sql) ) {
        if ($ref[3] >= '0' && $ref[3] <= '13') {
            $master = '0';
        }
        elseif ($ref[3] >= '16' && $ref[3] <= '23') {
            $master = '1';
        }
        elseif ($ref[3] >= '24' && $ref[3] <= '31') {
            $master = '2';
        }
        switch ($ref[3]) {
            case 0: $classnr = '0'; break;
            case 1: $classnr = '1'; break;
            case 2: $classnr = '2'; break;
            case 3: $classnr = '3'; break;
            case 4: $classnr = '4'; break;
            case 6: $classnr = '6'; break;
            case 7: $classnr = '7'; break;
            case 8: $classnr = '8'; break;
            case 9: $classnr = '9'; break;
            case 10: $classnr = '10'; break;
            case 11: $classnr = '11'; break;
            case 12: $classnr = '12'; break;
            case 13: $classnr = '13'; break;
            case 16: $classnr = '6'; break;
            case 17: $classnr = '7'; break;
            case 18: $classnr = '8'; break;
            case 19: $classnr = '9'; break;
            case 20: $classnr = '10'; break;
            case 21: $classnr = '11'; break;
            case 22: $classnr = '12'; break;
            case 23: $classnr = '13'; break;
            case 24: $classnr = '6'; break;
            case 25: $classnr = '7'; break;
            case 26: $classnr = '8'; break;
            case 27: $classnr = '9'; break;
            case 28: $classnr = '10'; break;
            case 29: $classnr = '11'; break;
            case 30: $classnr = '12'; break;
            case 31: $classnr = '13'; break;
        }
        $add = mysql_query("INSERT INTO `references` ( `rebirths`, `level`, `charname`, `class`, `logged_in`, `master` )
                                                                                    VALUES ( '".$ref[0]."', '".$ref[1]."', '".$ref[2]."', '".$classnr."', '".$ref[4]."', 
                                                                                                    '".$master."' ) ");
    }

    $row_sql = mysql_query("SELECT rebirths, level, charname, class, logged_in, master FROM `references` 
                                                    ORDER BY rebirths DESC, master DESC, level DESC, charname ASC");

    echo '<table style="border: 1px solid orange; font-size: 12px;" cellpadding="0" cellspacing="0" width="100%">
                    <tr STYLE="font-style: bold;">
                        <td width="10%"><b>Rank</b></td>
                        <td width="15%"><b>Rebirths</b></td>
                        <td width="10%"><b>Level</b></td>
                        <td width="15%"><b>State</b></td>
                        <td width="15%"><b>Name</b></td>
                        <td width="10%"><b>Class</b></td>
                        <td width="20%"><b>Status</b></td>
                    </tr>
                    <tr>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                    </tr>';

    $i = '0';
    while( $row = mysql_fetch_row($row_sql) ) {
    $i++;
    if ($row[4] == '0') {
        $status = '<img src="files/offline.gif">';
    } else {
        $status = '<img src="files/online.gif">';
    }

    if ($row[5] == '0') {
        $img = '';
    }
    elseif ($row[5] == '1') {
        if ($row[1] >= '60' && $row[1] <= '69') {
            $img = '<img src="img/m1.png">';
        }
        elseif ($row[1] >= '70' && $row[1] <= '79') {
            $img = '<img src="img/m2.png">';
        }
        elseif ($row[1] >= '80' && $row[1] <= '89') {
            $img = '<img src="img/m3.png">';
        }
        elseif ($row[1] >= '90' && $row[1] <= '99') {
            $img = '<img src="img/m4.png">';
        }
        elseif ($row[1] >= '100' && $row[1] <= '109') {
            $img = '<img src="img/m5.png">';
        }
        elseif ($row[1] >= '110' && $row[1] <= '150') {
            $img = '<img src="img/m6.png">';
        }
    }
    elseif ($row[5] == '2') {
        $img = '<img src="img/h.png">';
    }

    if ($row[0] == $row_before) {
        $color = $color;
    } else {
        if ($color == '#EEEEEE') {
            $color = '#FFFFFF';
        } else {
            $color = '#EEEEEE';
        }
    }
    $row_before = $row[0];

    echo '<tr bgcolor='.$color.'>
                    <td>'.$i.'</td>                    
                    <td>'.$row[0].'</td>
                    <td>'.$row[1].'</td>
                    <td>'.$img.'</td>
                    <td>'.$row[2].'</td>  
                    <td><img src="img/'.$row[3].'.png"></td>
                    <td>'.$status.'</td>
                </tr>';
        if ($i > '99') {
            break;
        }
    }

    echo '</table>';

    $clear = mysql_query("DROP TABLE `references`");

    echo '</table>';

    echo '</body>
                </html>';

?>

ranking.php

PHP Code:


<?php
require('./config.php');
?>
<link rel="Shortcut Icon" href="./files/Untitled-1(1).png">
<title> Flyff Vicio Ranking </title>
<script type="text/javascript" src="files/e107.htm"></script>
<script type="text/javascript" src="files/sleight_js.htm"></script>
<link rel="stylesheet" href="files/style.css" type="text/css" media="all">
<link rel="stylesheet" href="files/e107.css" type="text/css">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta http-equiv="content-style-type" content="text/css">
<meta http-equiv="content-language" content="en">

<link rel="StyleSheet" href="files/topbar.css" type="text/css"media="screen">


</div>
</div>

<div class="wrapper"><div class="innerwrapper"><div class="header"></div>
<div class="wrapper"><div class="innerwrapper"><div class="header"></div>
<div class="nav"><ul id="topmenu"><font color="white"><li><a class="offpage" title="Home" href="./index.php" accesskey="4">Home</a></li><li><a class="offpage" title="Character CP" href="change/changejob.php" accesskey="4">Character CP</a></li><li><a class="offpage" title="Forum" href="Not done yet" accesskey="0">Forum</a></li><li><a class="offpage" title="Register" href="./reg.php" accesskey="1">Register</a></li><li><a class="offpage" title="Top 100" href="./ranking.php" accesskey="3">Top 100</a></li><li><a class="offpage" title="Downloads" href="./downloads.php" accesskey="4">Downloads</a></li><li><a class="offpage" title="Players Online" href="./playonline.php" accesskey="4">Players Online</a></li> <li><a class="offpage" title="Shop" href="shop" accesskey="4">Web Shop</a></li><li><a class="offpage" title="Ban List" href="./banlist.php" accesskey="4">Ban List</a></li></font></ul>
</div><div class="clear"></div><div class="main"><div class="leftmenu"><h3><font color="white">Server Status</font></h3>
<div class="bodytable">



        <?php
include('./_stats.php');
?>


</font>
</tr></tbody></table></font>


</tbody></table>

</table>
<br>

</center></td>
</tr></tbody></table></div>

<h3><font color="white">Server info:</font></h3>
<div class="bodytable"><b>
<br>
<b>- Special Features -<br><br></b>
</div></div><div class="central">
<div class="bodytable">
<?php
include('./rank.php');
?>
</div>

</div><div class="rightmenu">

<h2><font color="white">Players Online</font></h2>
<div class="bodytable"><table id="table1" width="90%" border="0" cellpadding="0" cellspacing="0"> 
<tbody><tr>  
<div class="centered"><table><b>
&nbsp;- Total Accounts:
            <?php
            
            $tcount = mysql_query("SELECT * FROM accounts");
            echo mysql_num_rows($tcount);
            ?>
            <br />
            - Total Chars:  
            <?php
            $tchar = mysql_query("SELECT * FROM characters");
            echo mysql_num_rows($tchar);
            ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <br />
            - Players Online:   
          <?php        
            $tonl = mysql_query("SELECT * FROM accounts WHERE logged_in = '1'");
            echo mysql_num_rows($tonl);        
            ?><br/>

          </div></td>

</tbody></table> 
</div>

<h3><font color="white">Vote for us.</font></h3>
<div class="bodytable">
<?php
include('./vote.php');
?>
</div>

<h3><font color="white">Donate for a better server</font></h3>
<div class="bodytable">
<br>
<center><b>Top 3 Donations:</b></center><br>
<li>1. nickname</li>
<li>2. nickname</li>
<li>3. nickname</li><br>

<br>
<b>Total Donors: XX</b><br><br>
How does it Work?<br>
After you donate contact lol32 In-Game or Live Chat for your reward :)<br>
<br>
</div>
</body></html>

[Help] Rank

Thread Tools

Search Thread

[Help] Rank

Re: Rank help

Advertisement