Reply to thread

Message

<blockquote data-quote="Wickd" data-source="post: 335447" data-attributes="member: 26932">[CODE]&lt;div id=&quot;column1&quot; class=&quot;column&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix red &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Hotel Statistics&lt;/span&gt;&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;padding:5px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalbadges FROM users&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalbadges'];?&gt;&lt;/strong&gt; Registered Members on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php $query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` &gt;= '2'&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Silver VIP Members on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalmeubels FROM cms_news&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalmeubels'];?&gt;&lt;/strong&gt; Furniture items on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php $query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` &gt;= '7'&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Staff Members on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM cms_news&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; News Articles on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM bans&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Banned Users on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM user_wardrobe&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; saved outfits on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM rooms&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Rooms on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;352&lt;/strong&gt; Filtered words in rooms on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM user_pets&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Pets on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM bots&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Bots on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; There are &lt;strong&gt;&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM groups&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;/strong&gt; Groups on {hotelname}.&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix red &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Staff Statistics&lt;/span&gt;&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;padding:5px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php //* Wickd MAYN/devbest.com$getStats = mysql_query(&quot;SELECT * FROM users WHERE `rank` &gt;= '7' ORDER BY `respect` DESC LIMIT 45&quot;);while($staffStats = mysql_fetch_array($getStats)) {&nbsp; &nbsp; &nbsp; $Bans = mysql_query(&quot;SELECT * FROM `bans` WHERE `added_by` = '&quot; . $staffStats['username'] . &quot;'&quot;);$BanCount = mysql_num_rows($Bans);$Tickets = mysql_query(&quot;SELECT * FROM `moderation_tickets` WHERE `moderator_id` = '&quot; . $staffStats['id'] . &quot;'&quot;);$TicketCount = mysql_num_rows($Tickets);echo '&nbsp; &lt;strong&gt;&lt;a href=&quot;/home/'.$staffStats['username'].'&quot;&gt;'.$staffStats['username'].'&lt;/a&gt;&lt;/strong&gt; has banned &lt;strong&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '.$BanCount.'&lt;/strong&gt; users and handled&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;'.$TicketCount.'&lt;/strong&gt; call for help tickets.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;hr&gt;';}?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;{hotelname}'s Newest User&lt;/span&gt;&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;padding: 5px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;staffBox&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-bottom: 4px; margin-left: 4px; float:left;&quot; src=&quot;https://game.boon.pw/habbo-imaging/head.php?figure=hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-&amp;size=m&amp;direction=2&amp;head_direction=2&amp;gesture=sml&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span style=&quot;float: right; margin-right: 4px; margin-top: 12px;&quot;&gt;&lt;img src=&quot;https://images.boon.pw/offline-xmas14.png&quot; /&gt;&lt;/span&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;margin-left: 35px; padding-top: 6px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr style=&quot;padding: 0;&quot;&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;&lt;a href=&quot;https://boon.pw/home/poopin&quot;&gt;poopin&lt;/a&gt;&lt;/strong&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I am new to {hotelname}!&lt;br /&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;Random {hotelname} Staff Member&lt;/span&gt;&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;padding: 5px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;staffBox&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-bottom: 4px; margin-left: 4px; float:left;&quot; src=&quot;https://game.boon.pw/habbo-imaging/head.php?figure=lg-280-63.ch-255-73.hr-828-45.he-1609-73.hd-205-3.fa-1209-73.ca-1813-62.sh-295-73&amp;size=m&amp;direction=2&amp;head_direction=2&amp;gesture=sml&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span style=&quot;float: right; margin-right: 4px; margin-top: 12px;&quot;&gt;&lt;img src=&quot;https://images.boon.pw/offline-xmas14.png&quot; /&gt;&lt;/span&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;margin-left: 35px; padding-top: 6px;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr style=&quot;padding: 0;&quot;&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;&lt;a href=&quot;https://boon.pw/home/MOD-Adrian&quot;&gt;BlackJesus&lt;/a&gt;&lt;/strong&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Wicked RULES&lt;br /&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; document.observe(&quot;dom:loaded&quot;, function() { PromoSlideShow.init(); });&nbsp; &nbsp; &nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HabboView.run();&nbsp; &nbsp; &nbsp; &nbsp; &lt;/script&gt;[/CODE]</blockquote>

[QUOTE="Wickd, post: 335447, member: 26932"] [CODE]<div id="column1" class="column"> <div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">Hotel Statistics</h2> <div style="padding:5px;"> There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM users") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalbadges']; ?> Registered Members on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '2'") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Silver VIP Members on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM cms_news") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalmeubels']; ?> Furniture items on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '7'") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Staff Members on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM cms_news") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> News Articles on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bans") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Banned Users on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_wardrobe") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> saved outfits on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Rooms on {hotelname}. There are 352 Filtered words in rooms on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_pets") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Pets on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bots") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Bots on {hotelname}. There are <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM groups") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Groups on {hotelname}. </div> </div> </div> <div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">Staff Statistics</h2> <div style="padding:5px;"> <?php //* Wickd MAYN/devbest.com $getStats = mysql_query("SELECT * FROM users WHERE `rank` >= '7' ORDER BY `respect` DESC LIMIT 45"); while($staffStats = mysql_fetch_array($getStats)) { $Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $staffStats['username'] . "'"); $BanCount = mysql_num_rows($Bans); $Tickets = mysql_query("SELECT * FROM `moderation_tickets` WHERE `moderator_id` = '" . $staffStats['id'] . "'"); $TicketCount = mysql_num_rows($Tickets); echo ' <a href="/home/'.$staffStats['username'].'">'.$staffStats['username'].'</a> has banned '.$BanCount.' users and handled '.$TicketCount.' call for help tickets. <hr> '; } ?> </div> </div> </div> </div> <div id="column2" class="column"> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">{hotelname}'s Newest User</h2> <div style="padding: 5px;"> <div class="staffBox"> <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-&size=m&direction=2&head_direction=2&gesture=sml" /> <img src="https://images.boon.pw/offline-xmas14.png" /> <table style="margin-left: 35px; padding-top: 6px;"> <tr style="padding: 0;"> <td> <a href="https://boon.pw/home/poopin">poopin</a> I am new to {hotelname}! </td> </tr> </table> </div> </div> </div> </div> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Random {hotelname} Staff Member</h2> <div style="padding: 5px;"> <div class="staffBox"> <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=lg-280-63.ch-255-73.hr-828-45.he-1609-73.hd-205-3.fa-1209-73.ca-1813-62.sh-295-73&size=m&direction=2&head_direction=2&gesture=sml" /> <img src="https://images.boon.pw/offline-xmas14.png" /> <table style="margin-left: 35px; padding-top: 6px;"> <tr style="padding: 0;"> <td> <a href="https://boon.pw/home/MOD-Adrian">BlackJesus</a> Wicked RULES </td> </tr> </table> </div> </div> </div> </div> </div> <script type="text/javascript"> document.observe("dom:loaded", function() { PromoSlideShow.init(); }); </script> <script type="text/javascript"> HabboView.run(); </script>[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members