[Rel] Holo Emu/CMS Stats

Users are always asking me how many peices of furniture ect that there is so i decided to make a page that displays it plus other specs/stats.

Here is the code just make a new file called stats.php and add it into your community header or somewhere else. There is proberly a better way to code it but i couldn't care less. It's really simple.

For people who cba to test it you can see it at hotel-bobba.net/stats.php

It counts the following:

Code:

---

Furniture count:
User count:
Stickie count:
Group count:
Total Discussion Board Posts:
Total Discussion Board Threads:
Room count:
Room bans:
News Item Count:
Room Votes Count:
Room Rights Count:
Stickers in use:
Total guestbook posts:
Unopened Present Count:
Total Moodlights:
Total Group Members:
Total Friends:
Total Trax Songs Made:
Lines of chatlogs recorded:
Staff log count:
Users banned:
HC Members:

---

PHP Code:

---

<?php

include('core.php');

include("locale/".$language."/login.php");
include("locale/".$language."/policies.php");

include('templates/login/subheader.php');
include('templates/login/header.php');
?>

<div id="process-content">
                <div id="terms" class="box-content">
<div class="tos-header"><b><?php echo "$shortname Hotel Stats"; ?></b></div>
<br />
<?php
    echo "Here are some interesting hotel stats. If you have any suggestions on what stats to add then please let me know. I will organize them soon.";
?>
<br />
<br />
<?php
echo "<b>Furniture count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM furniture");
?>
<br />
<br />
<?php
echo "<b>User count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM users");
?>
<br />
<br />
<?php
echo "<b>Stickie count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM furniture_stickies");
?>
<br />
<br>
<?php

echo "<b>Group count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM groups_details");
?>
<br />
<br />
<?php
echo "<b>Total Discussion Board Posts:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM cms_forum_posts");
?>
<br />
<br />
<?php
echo "<b>Total Discussion Board Threads:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM cms_forum_threads");
?>
<br />
<br />
<?php
echo "<b>Room count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM rooms");
?>
<br />
<br />
<?php
echo "<b>Room bans:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM room_bans");
?>
<br />
<br />
<?php
echo "<b>News Item Count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM cms_news");
?>
<br />
<br />
<?php
echo "<b>Room Votes Count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM room_votes");
?>
<br />
<br />
<?php
echo "<b>Room Rights Count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM room_rights");
?>
<br />
<br />
<?php
echo "<b>Stickers in use:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM cms_homes_stickers");
?>
<br />
<br />
<?php
echo "<b>Total guestbook posts:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM cms_guestbook");
?>
<br />
<br />
<?php
echo "<b>Unopened Present Count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM furniture_presents");
?>
<br />
<br />
<?php
echo "<b>Total Moodlights:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM furniture_moodlight");
?>
<br />
<br />
<?php
echo "<b>Total Group Members:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM groups_memberships");
?>
<br />
<br />
<?php
echo "<b>Total Friends:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM messenger_friendships");
?>
<br />
<br />
<?php
echo "<b>Total Trax Songs Made:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM soundmachine_songs");
?>
<br />
<br />
<?php
echo "<b>Lines of chatlogs recorded:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM system_chatlog");
?>
<br />
<br />
<?php
echo "<b>Staff log count:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM system_stafflog");
?>
<br />
<br />
<?php
echo "<b>Users banned:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM users_bans");
?>
<br />
<br />
<?php
echo "<b>HC Members:</b>";
?>
<br />
<?php
echo mysql_evaluate("SELECT COUNT(*) FROM users_club");
?>
<br />
<br />
<?php

include('templates/login/footer.php');

?>

---

pretty sweet.
any screenies???
I like it

Quote:

---

Originally Posted by rickymenier

pretty sweet.
any screenies???
I like it

---

Theres a link right there for a preview. No need to login/signup or anything.

Quote:

---

Originally Posted by Jakeyy

Theres a link right there for a preview. No need to login/signup or anything.

---

oh.
didn't see it.
make it a direct link
like

Preview: http://www.hotel-bobba.net/stats.php

Useful for people who dont know how to look at those :p How long did it take you?

Quote:

---

Originally Posted by -Twilight

Useful for people who dont know :p How long did it take you?

---

2 minuites. Only because i had to type in the stat name. Just a simple count rows inside a table.

very nice, thanks! :D:

Pages like these are the ones that are relatively useless in my opinion, all they really do is add extra load to your MySQL db

Quote:

---

Originally Posted by Moogly

Pages like these are the ones that are relatively useless in my opinion, all they really do is add extra load to your MySQL db

---

You wouldn't even notice it unless you had 1000s online.

I guess, but I'm a memory freak lately considering how much memory windows wastes when its idle doing useless things it shouldn't be doing as opposed to Linux...

Quote:

---

Originally Posted by Moogly

I guess, but I'm a memory freak lately considering how much memory windows wastes when its idle doing useless things it shouldn't be doing as opposed to Linux...

---

Yeh i'm the same. And trust me if i had a lot online using it i would remove ;d. I'm always ending process's LOL its the first thing i do when i log into my computer.

I don't need to end them, well sometimes my wireless thing wastes resources, but the problem is the new Windows MSN it is a fucking Memory wasting WHORE....

Quote:

---

Originally Posted by Moogly

I don't need to end them, well sometimes my wireless thing wastes resources, but the problem is the new Windows MSN it is a fucking Memory wasting WHORE....

---

A whore in her period to be exactly (or is it exact, it comes after a verb).
Microsoft should only do their Visual Studio, leave the OS's to Linux and other programmes to one three three seven guis.

Woot nice dude seriously I made one but I didnt put like the HC count and The furni count didnt work well I guess im gonna take yours instead ::P

Quote:

---

Originally Posted by !Kevin!

Woot nice dude seriously I made one but I didnt put like the HC count and The furni count didnt work well I guess im gonna take yours instead ::P

---

Thanks :) I'm going to make a housekeeping add-on or maybe a public page where you type in the furni id and it counts how many of that furnis there are. I'm not going to do that until i find a better way to do it without performance issues. I'm also going to make mass furni and mass presents for housekeeping.