Ay, Ragezone
Today i will be Re-Releasing The PHPRetro Stats Page. The reason why the first one released from Davidaap to GrandCoder had an Little Error So me and Grand sat down and fixed it up and put the boxes diffrently (Makes it nicer) So Here you go
PHP Code:
<?php
/*#######################################################
#+#Copyright RZ coders 2010 by GrandCoder , StronGFaith and PixLite#+#
#+#Copyright BC&D Best Coders and Designers 2010 by StroNGFaith
, amber and GrandCoder#+#
#######################################################*/
$page['allow_guests'] = true; require_once('./includes/core.php'); require_once('./includes/session.php'); $data = new community_sql; $lang->addLocale("community.community"); $page['id'] = "Stats"; $page['name'] = "Stats"; $page['bodyid'] = "Stats"; $page['cat'] = "community"; require_once('./templates/community_header.php'); ?>
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
<div class="habblet-container " id="">
<div class="cbb clearfix pixellightblue ">
<h2 class="title">Click Stats
</h2>
<div id="not-found-looking-for" class="clearfix">
<center><b>Statistics Hotel</b><br>
Users online: <?php echo GetOnlineCount(); ?> <br>
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 users_badges") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalbadges'];
?>
<br />Favorite rooms:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalfavouritekamers FROM users_favourites") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalfavouritekamers'];
?>
<br />furniture:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM furniture") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalmeubels'];
?>
<br />furniture in the catalog:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM catalogue_items") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalmeubels'];
?>
<br /><br>
<b>Statistics Website</b><br>
forum topics:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalforumtopics FROM cms_forum_threads") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalforumtopics'];
?>
<br />==forum posts:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalforumreacties FROM cms_forum_posts") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalforumreacties'];
?>
<br />questboek messages:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantalgastenboekberichten FROM cms_guestbook") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantalgastenboekberichten'];
?>
<br />tags:
<?php
$query = mysql_query("SELECT COUNT(*) AS aantaltags FROM cms_tags") or die(mysql_error());
$data = mysql_fetch_assoc($query);
echo $data['aantaltags'];
?>
<br />
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix pixellightblue ">
<h2 class="title">Account Information
</h2>
<div class="box-content">
<b>About <?php echo $user->user("name"); ?></b><br>
Motto: <?php echo $user->user("mission"); ?><br />Credits: <?php echo $user->user("credits"); ?>
<br />
IPAdress: <?php echo $_SERVER["REMOTE_ADDR"]; ?><br /><br>
Style: <img alt="<?php echo $user->user("name"); ?>" src="<?php echo $user->avatarURL("self","b,3,3,sml,1,0"); ?>" width="64" height="110" />
small style: <img alt="<?php echo $user->user("name"); ?>" src="<?php echo $user->avatarURL("self","s,3,3,sml,1,0"); ?>" width="33" height="56" />
</div>
</a>
<p class="clear last">
</p>
</center>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> </div> </div> <?php require_once('./templates/community_footer.php'); ?>
Hope u enjoy
Credits:
Davidaap - 95% For The Base
GrandCoder And Pix- 5% for fixing a little Error and changing minor things. (colors, Arrangements,etc...)
PHPRetro Stats Page
Originally Posted by Shacobesaurus
