Reply to thread

Message

<blockquote data-quote="RJackHabbo" data-source="post: 338931" data-attributes="member: 59872">Hello, &nbsp; DevBestThis is my first post so hopefully you like also this has most likely been released so if it has please include Link in the Description for their Credits. Step 1;Run this on your database:[CODE]ALTER TABLE `users` ADD `age` VARCHAR(10) NOT NULL default 'Unknown';ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL default 'Hotel User';ALTER TABLE `users` ADD `country` VARCHAR(55) NOT NULL default 'Unknown';[/CODE]This is for the Staff Page it Will Show The Age so Edit Unknown with there Age this will be on the Users Page obviously also You need to Edit the Hotel User to What there position is so like 'Founder' and then the last one i will show you nowStep 2;Now add this into your SWF Folder which is usually called 'r63'Download <a href="https://goo.gl/A8OiO1" target="_blank">HERE</a>This is to show what country they are From it shows as a ImageIn the Folder;Various Country's<img src="http://i.imgur.com/7KbsJcB.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> Okay now for the staff page;Usually on the Staff Page the MySQL Code is(Had to use Pastebin because of characters)<a href="http://pastebin.com/Aw0sEr6Z" target="_blank">http://pastebin.com/Aw0sEr6Z</a>So you want to Remove this and add this[PHP]&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;content&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;?phperror_reporting(0);$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id =12 ORDER BY id DESC&quot;);$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `username` = '&quot; . $Users['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);echo $BanCount;while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix red &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Founder&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $member['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Last online: &lt;i&gt;' . date('d M, Y', $member['last_online']) . '&lt;/i&gt;&lt;br&gt;Motto: &quot;&lt;i&gt;' . $member['motto'] . '&lt;/i&gt;&quot;&lt;br&gt;' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/font&gt;&lt;/font&gt;&lt;/strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; position: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&lt;?phperror_reporting(0);$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id =11 ORDER BY id DESC&quot;);$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `username` = '&quot; . $Users['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);echo $BanCount;while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix red &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Technician&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $member['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Last online: &lt;i&gt;' . date('d M, Y', $member['last_online']) . '&lt;/i&gt;&lt;br&gt;Motto: &quot;&lt;i&gt;' . $member['motto'] . '&lt;/i&gt;&quot;&lt;br&gt;' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/font&gt;&lt;/font&gt;&lt;/strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Role: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;?php$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id = 10 ORDER BY id DESC&quot;);while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix settings &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Manager&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; $Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $member['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Last online: &lt;i&gt;' . date('d M, Y', $member['last_online']) . '&lt;/i&gt;&lt;br&gt;Motto: &quot;&lt;i&gt;' . $member['motto'] . '&lt;/i&gt;&quot;&lt;br&gt;' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/font&gt;&lt;/font&gt;&lt;/strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Role: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo '&lt;br&gt;&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;?php$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id = 9 ORDER BY id DESC&quot;);while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix green &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Administrator&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; $Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $member['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Motto: ' . $member['motto'] . '' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: -8px;&quot;&gt;&lt;img src=&quot;http://URL/r63/c_images/album1584/ADM.gif&quot;&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Role: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;?php$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id = 7 ORDER BY id DESC&quot;);while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Moderators&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Last online: &lt;i&gt;' . date('d M, Y', $member['last_online']) . '&lt;/i&gt;&lt;br&gt;Motto: &quot;&lt;i&gt;' . $member['motto'] . '&lt;/i&gt;&quot;&lt;br&gt;' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/font&gt;&lt;/font&gt;&lt;/strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Role: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;content&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;?phperror_reporting(0);$getRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id = 4 ORDER BY id DESC&quot;);$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `username` = '&quot; . $Users['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);echo $BanCount;while ($Ranks = mysql_fetch_assoc($getRanks)){&nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix red &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Trial Moderator&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;&lt;/span&gt;&lt;/h2&gt;';&nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT id,username,motto,look,account_created,online,last_online,position,age,country FROM users WHERE rank = '&quot; . $Ranks['id'] . &quot;'&quot;);&nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }$Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $member['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; height=&quot;50px&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&amp;size=m&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/br&gt;&lt;p style=&quot;margin-top: -10px;&quot; style=&quot;font-size: 100%;&quot;&gt;&lt;strong&gt;&lt;a&gt;&lt;u&gt;' .$member['username'] . '&lt;/a&gt;&lt;/u&gt;&lt;/strong&gt;&lt;br&gt;Last online: &lt;i&gt;' . date('d M, Y', $member['last_online']) . '&lt;/i&gt;&lt;br&gt;Motto: &quot;&lt;i&gt;' . $member['motto'] . '&lt;/i&gt;&quot;&lt;br&gt;' . (($member['online'] == &quot;1&quot;) ? '&lt;font color=&quot;darkgreen&quot;&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;&lt;strong&gt;Online&lt;/stromg&gt;': '&lt;font color=&quot;darkred&quot;&gt;&lt;strong&gt;&lt;p style=&quot;margin-left: 165px; margin-top: -37px;&quot;&gt;Offline&lt;/stromg&gt;') . '&lt;/p&gt;&lt;/font&gt;&lt;/font&gt;&lt;/strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Role: &lt;b&gt;' . $member['position'] . '&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Age: ' . $member['age'] . '&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Registered on: &lt;b&gt;' . date('d M, Y', $member['account_created']) . '&lt;/b&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bans: &lt;b&gt;'; echo $BanCount;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;img src=&quot;http://URL/r63/Flags/' .$member['country'] . '.png&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;No information available.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}?&gt;&nbsp; [/PHP]Hopefully you understand this if not please Message in The Comments Below!Also replace&nbsp; URL with your url <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" />I would share Screenies but i dont have a Retro&nbsp;</blockquote>

[QUOTE="RJackHabbo, post: 338931, member: 59872"] Hello, DevBest This is my first post so hopefully you like also this has most likely been released so if it has please include Link in the Description for their Credits. Step 1; Run this on your database: [CODE]ALTER TABLE `users` ADD `age` VARCHAR(10) NOT NULL default 'Unknown'; ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL default 'Hotel User'; ALTER TABLE `users` ADD `country` VARCHAR(55) NOT NULL default 'Unknown';[/CODE] This is for the Staff Page it Will Show The Age so Edit Unknown with there Age this will be on the Users Page obviously also You need to Edit the Hotel User to What there position is so like 'Founder' and then the last one i will show you now Step 2; Now add this into your SWF Folder which is usually called 'r63' Download [B][U][URL='https://goo.gl/A8OiO1']HERE[/URL][/U][/B] This is to show what country they are From it shows as a Image In the Folder; Various Country's [IMG]http://i.imgur.com/7KbsJcB.png[/IMG] Okay now for the staff page; [SIZE=14px]Usually on the Staff Page the MySQL Code is (Had to use Pastebin because of characters) [URL]http://pastebin.com/Aw0sEr6Z[/URL][/SIZE] So you want to Remove this and add this [PHP] <div id="container"> <div id="content"> <div id="column2" class="column"> <?php error_reporting(0); $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id =12 ORDER BY id DESC"); $Bans = mysql_query("SELECT * FROM `bans` WHERE `username` = '" . $Users['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo $BanCount; while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">Founder </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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; } $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo '<table width="107%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Last online: ' . date('d M, Y', $member['last_online']) . ' Motto: "' . $member['motto'] . '" ' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . ' <hr> position: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo ' <img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> <?php error_reporting(0); $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id =11 ORDER BY id DESC"); $Bans = mysql_query("SELECT * FROM `bans` WHERE `username` = '" . $Users['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo $BanCount; while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">Technician </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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; } $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo '<table width="107%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Last online: ' . date('d M, Y', $member['last_online']) . ' Motto: "' . $member['motto'] . '" ' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . ' <hr> Role: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo ' <img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> </div> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> <div id="column2" class="column"><div class="habblet-container "> <?php $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 10 ORDER BY id DESC"); while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix settings "> <h2 class="title">Manager </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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; } $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo '<table width="107%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Last online: ' . date('d M, Y', $member['last_online']) . ' Motto: "' . $member['motto'] . '" ' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . ' <hr> Role: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo ' <img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> <div id="column2" class="column"><div class="habblet-container "> <?php $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 9 ORDER BY id DESC"); while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix green "> <h2 class="title">Administrator </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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; } $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo '<table width="107%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Motto: ' . $member['motto'] . '' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . '<img src="http://URL/r63/c_images/album1584/ADM.gif"> <hr> Role: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo ' <img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> </div></div></div></div> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> <div id="column2" class="column"><div class="habblet-container "> <?php $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 7 ORDER BY id DESC"); while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Moderators </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Last online: ' . date('d M, Y', $member['last_online']) . ' Motto: "' . $member['motto'] . '" ' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . ' <hr> Role: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo ' <img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> <div id="container"> <div id="content"> <div id="column2" class="column"> <?php error_reporting(0); $getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 4 ORDER BY id DESC"); $Bans = mysql_query("SELECT * FROM `bans` WHERE `username` = '" . $Users['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo $BanCount; while ($Ranks = mysql_fetch_assoc($getRanks)) { echo '<div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">Trial Moderator </h2>'; $getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,position,age,country 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; } $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'"); $BanCount = mysql_num_rows($Bans); echo '<table width="107%" height="50px" 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://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml"> </td> <td valign="top"> <a>' .$member['username'] . '</a> Last online: ' . date('d M, Y', $member['last_online']) . ' Motto: "' . $member['motto'] . '" ' . (($member['online'] == "1") ? 'Online</stromg>': 'Offline</stromg>') . ' <hr> Role: ' . $member['position'] . ' Age: ' . $member['age'] . ' Registered on: ' . date('d M, Y', $member['account_created']) . ' Bans: '; echo $BanCount; echo '<img src="http://URL/r63/Flags/' .$member['country'] . '.png"> </td> </td> </tr> </tbody> </table>'; } } else { echo 'No information available.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?> [/PHP] Hopefully you understand this if not please Message in The Comments Below! Also replace URL with your url :) I would share Screenies but i dont have a Retro [SIZE=14px] [/SIZE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members