Junior Spellweaver
- Joined
- Oct 4, 2009
- Messages
- 113
- Reaction score
- 6
This is the code:
Screenshot:
PHP:
<div class="habblet-container ">
<div class="cbb clearfix red ">
<h2 class="title">Hotel Statistics</h2>
<div class="box-content">
<div style="text-align: left;">
<Center>
There are <strong>
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM users") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalbadges'];
?></strong> Registered Members on Hangout.<br />
There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `vip` >= '1'") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> VIP Members on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM furniture") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalmeubels'];
?></strong> Furniture items on Hangout.<br />
There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '6'") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Staff Members on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM site_news") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> News Articles on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bans") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Banned Users on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_wardrobe") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> saved outfits on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Rooms on Hangout.<br />
There are <strong>352</strong> Filtered words in rooms on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bots_petdata") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Pets on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bots") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Bots on Hangout.<br />
There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM groups") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?></strong> Groups on Hangout.
</div></center>
</div>
</div>
</div>
Screenshot: