<body id="home" class=" ">
<div id="overlay"></div>
<div id="content-container">
<div id="container">
<div id="content">
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix ">
<div id="notfound-looking-for" class="box-content">
<b>About %habboName%</b><br>
Gender: <?php echo $users->GetUserVar(USER_ID, 'gender'); ?><br />
Motto: <?php echo $users->GetUserVar(USER_ID, 'motto'); ?><br />Credits: <?php echo $users->GetUserVar(USER_ID, 'credits'); ?><br />
Pixels: <?php echo $users->GetUserVar(USER_ID, 'activity_points'); ?> <br />
Last Online: <?php echo $users->GetUserVar(USER_ID, 'last_online'); ?><br />
Registered Date: <?php echo $users->GetUserVar(USER_ID, 'account_created'); ?>
<br />
IP address: <?php echo $_SERVER["REMOTE_ADDR"]; ?><br /><br>
Style: <img alt="%habboName%" src="http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $users->GetUserVar(USER_ID, 'look'); ?>&direction=2&head_direction=3" width="64" height="110" class="welcome-habbo" />
small style: <img alt="%habboName%" src="http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $users->GetUserVar(USER_ID, 'look'); ?>&direction=2&head_direction=3" width="33" height="56" />
</div>
</div></div></div></div>
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix ">
<div id="notfound-looking-for" class="box-content">
<b>Statistics Hotel</b><br>
Users online: <?php $sql = "SELECT COUNT(*) FROM users WHERE online = '1'";
$query = mysql_query($sql) or die(mysql_error());
$hoeveel = mysql_result($query,0,0);
echo $hoeveel; ?> <br>
Registered Members:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalleden FROM users") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalleden'];
?>
<br />Rooms:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalkamers'];
?>
<br />Badges:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM user_badges") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalbadges'];
?>
<br />Favourite rooms:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalfavouritekamers FROM user_favorites") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalfavouritekamers'];
?>
<br />Total pieces of furniture:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM furniture") or die(mysql_error());
$data = mysql_fetch_assoc($query); echo $data['aantalmeubels'];
?>
<br />Total pieces of furniture in the catalog:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM catalog_items") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalmeubels'];
?>
<br /><br>
<b>Statistics Website</b><br>
Number Of tags:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantaltags FROM user_tags") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantaltags'];
?>
<br>
<br>
</div>
</div>
</div></div>