Habbo Staff

Status
Not open for further replies.

Queso

echo 'Web Developer';
Nov 29, 2016
232
72
@Lethargic You modify the query that selects the stff members from the database and add a column, to the users table called like hidden, make it an enum, and after your SELECT * from users WHERE rank = ends, after the Ranks['id'], add AND hidden = 0
 

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
Open the design view of the ranks table

Add a new column called hidden, int, 11, 0

Go to your staff.php page and where it says

"SELECT * FROM `ranks`"

Add

Where `hidden` = '0'

And it will hide that rank from the staff page. ZeroHigh's suggestion will put individual users being hidden, but would have to be attached to the query that says where rank = x
 

Logic

Bobby Billionaire
Feb 8, 2012
748
207
Open the design view of the ranks table

Add a new column called hidden, int, 11, 0

Go to your staff.php page and where it says

"SELECT * FROM `ranks`"

Add

Where `hidden` = '0'

And it will hide that rank from the staff page. ZeroHigh's suggestion will put individual users being hidden, but would have to be attached to the query that says where rank = x

This is what I'm using to select ranks from the database:
PHP:
                        <?php
                            $GetRanks = mysql_query("SELECT id,name FROM ranks WHERE id > 1 ORDER BY id DESC");
                            while($Ranks = mysql_fetch_assoc($GetRanks))
                            {
                                echo "<div class=\"habblet-container \"><div class=\"cbb clearfix blue \"><h2 class=\"title\">{$Ranks['name']}s</h2><div style=\"padding:5px\"><p>";
                                $GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']}");
                                while($Users = mysql_fetch_assoc($GetUsers))
                                {
                                    if($Users['online'] == 1){ $OnlineStatus = "<font color=\"darkgreen\"><b>Online</b></font>"; } else { $OnlineStatus = "<font color=\"darkred\"><b>Offline</b></font>"; }
                                    echo "<img style=\"position:absolute;\" src=\"http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&direction=2&head_direction=2&gesture=sml\">"
                                        ."<p style=\"margin-left:80px;margin-top:20px;\">Username: <strong>{$Users['username']}</strong><br>Motto: <strong>{$Users['motto']}</strong><br><small>Last Online: ". date("D, d F Y H:i (P)", $Users['last_online']) ."</small></p>"
                                        ."<p style=\"float:right;margin-top:-30px;margin-right:5px;\">{$OnlineStatus}</p><br><br><br>";
                                }
                                echo "</div></div></div>";
                            }
                        ?>
 
Status
Not open for further replies.

Users who are viewing this thread

Top