Staff page wont work

[Thatboysab]

Hey ragezone,

So I added my cms that I used from my r63 to my r63b now. But I'm having trouble with the staff page. It wont show anyone on there even though I am the rank it is supposed to show. I do use Azure emu, and I would have posted it on the azure emu help thread, but I dont think azure emu is the problem to this.


Staff code:

            <div id="container">                <div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
                                        <?php
 
function GetDescr($level)
{
        switch ($level)
        {
                case 12:
                        return ' Lead Developers';
                case 11:
               
                        return ' Head Administrative';
                       
                case 10:
               
                        return ' Hotel Administration';
                       
                case 9:
               
                        return ' Head of Moderators';
                       
                case 8:
               
                        return ' Hotel Moderators';
						
				case 7:
               
                        return ' Trial Moderators';
                       
       
                default:
               
                        return '';
        }
}
 
$getRanks = mysql_query("SELECT *  FROM `ranks`  WHERE ((`ranks`.`id` = 7) OR (`ranks`.`id` = 8) OR (`ranks`.`id` = 9) OR (`ranks`.`id` = 10) OR (`ranks`.`id` = 11) OR (`ranks`.`id` = 12)) ORDER BY id DESC");
 
while ($Ranks = mysql_fetch_assoc($getRanks))
{      
        echo '<div class="habblet-container ">         
<div class="cbb clearfix green ">
<h2 class="title"><span style="float: left;">' . $Ranks['name'] . '</span> <span style="float: right; font-weight: normal; font-size: 75%;">' . GetDescr($Ranks['id']) . '</span></h2>';
       
        $getMembers = mysql_query("SELECT id,username,motto,look,online,last_online FROM users WHERE rank = '" . $Ranks['id'] . "'");
       
        echo '<div class="box-content">';
       
        if (mysql_num_rows($getMembers) > 0)
        {
                $oe = 1;
               
                while ($member = mysql_fetch_assoc($getMembers))
                {
                        if ($oe == 2)
                        {
                                $oe = 1;
                        }
                        else
                        {
                                $oe = 2;
                        }
       
                        echo '<table width="107%" style="padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';">
						
                        <tbody>
                                <tr>
                                        <td valign="middle" width="25">
                                                <img style="margin-top: -10px;" src="http://habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m">
                                        </td>
                                        <td valign="top">
                                                Username: <strong><span style="font-family:Arial,Helvetica,sans-serif; color: #2d0747;text-shadow: 0px 0px 3px #7700ff;background:url(/app/tpl/skins/Custom-Habbo/images/glitter.gif);">' .$member['username'] . '</strong></span><br>Motto: ' . $member['motto'] . '<br><br><i>Last Online: '. date("D, d F Y H:i (P)", $member['last_online']) .'</i></p>
                                                <br />';
                                               
                                        $getBadges = mysql_query("SELECT * FROM user_badges WHERE user_id = '" . $member['id'] . "' AND badge_slot >= 1 ORDER BY badge_slot DESC LIMIT 5");
                                       
                                        while ($b = mysql_fetch_assoc($getBadges))
                                        {
                                                echo '<img src="/r63/c_images/album1584/' . $b['badge_id'] . '.gif" style="float: left;">&nbsp;&nbsp;&nbsp;';
                                        }
                                               
                                        echo '</td>
                                        <td valign="top" style="float: right;">
                                                ' . (($member['online'] == "1") ? '<img src="{url}/app/tpl/skins/Custom-Habbo/images/online.gif"/>': '<img src="{url}/app/tpl/skins/Custom-Habbo/images/offline.gif"/>') . '
												
                                        </td>
                                </tr>
                        </tbody>
                        </table>';
                }
        }
        else
        {
                echo '<i>Fill out an application for your chance to be in this spot!</i>';
        }
       
        echo '</div>
        </div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> ';
}
 
?>


 <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    </div>

[MentaL]

[KyleeIsProzZ]

Use this:
<div id="container"> <div id="content" style="position: relative" class="clearf - Pastebin.com

And execute this query:
-- ---------------------------- -- Table structure for ranks -- -------------- - Pastebin.com

[Thatboysab]

Use this:
<div id="container"> <div id="content" style="position: relative" class="clearf - Pastebin.com

And execute this query:
-- ---------------------------- -- Table structure for ranks -- -------------- - Pastebin.com

Works like a charm! +1

Also, how came I make it with columns, how fresh has it? Like going down in small column? You know what I mean?

one more thing, How do I make less ranks? Where are the permissions so I can make less ranks in azure db?

[KyleeIsProzZ]

Works like a charm! +1

Also, how came I make it with columns, how fresh has it? Like going down in small column? You know what I mean?

one more thing, How do I make less ranks? Where are the permissions so I can make less ranks in azure db?

You can change the min_rank of a permission in the source code, HabboHotel > Commands. Each command has it's own code in each of the .cs files.

[Thatboysab]

You can change the min_rank of a permission in the source code, HabboHotel > Commands. Each command has it's own code in each of the .cs files.

Why are some -3? lol Thats what threw me off.

[KyleeIsProzZ]

-3 is VIP

[Thatboysab]

-3 is VIP

So why is it 2 in the ranks table in db?

[KyleeIsProzZ]

So why is it 2 in the ranks table in db?

Put it to -3 then :)

[Thatboysab]

Put it to -3 then :)

Would you know how to make the staff page with three columns that are side by side like fresh?