Live Forum Statistics on All Pages in Header

Plugin Keywords: Forum, Stats, Statistics, Members, New Members, Forum, Statistics, Member Info

Please Don't Forget to Click -->

Requested by :
Myself :devious:

Context :
Searched through vb.org but could not find a similar plugin/hack for vB3.5/vB3.0.x. I wanted to show all vital forum stats like total posts, total threads, total members and newest member on each page of my forum as well as vBa CMPS, in header template and this plugin performs exactly the same function.

What this plugin does ?
This plugin uses the 'global_start' hook and stores the desired information from your forum database into php variables and when called in 'header 'template, produces the desired results.

Utility :
Imagine... an unregistered/guest visits your website for the first time via a search engine link (95% of times its not the homepage that is found via a search engines link) and the first thing s/he notices is the forum header information and says wow!! this forum has got xxxx members, xxxxx threads, xxxxxx posts, why not get registered with this community and see what this forum has got in store for me. LOL!! quite true actually.

Demo : http://www.sikhism.us

Any Screenshots : Demo is self-explanatory.

Warning : This plugin executes 5 queries per page.

Installation Instructions : (Also attached alongwith the plugin.)

 
Step by Step Instructions: 
1. Ofcourse, download the Plugin.
2. Go to 'Plugin System' module in vb admin panel and click 'Download/Upload Plugins'.
3. Towards the botton of next screen, you will see a box table - 'Import Plugin Definitions XML File'. Click the 'Browse' button and select the Plugin Definitions XML File downloaded and saved somewhere on your computer. Click the 'Import' button and well... you are not quite yet done. LOL!!
4. Ok, Now go to Styles & Tempalte --> 'Styles Manager' and select the 'Common Templates' option from drop down menu and click the 'Go' button.
5. In the header template:
 
Find: (ususally at the end of the template file)
<!-- content table -->
$spacer_open
 
$_phpinclude_output
 
 
 
Add Above:
<!-- Forum Stats in Header Template -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td>
     <div align="left"><span class="smallfont">| <b>Discussions:</b> $totalthreads | <b>Messages:</b> $totalposts | <b>Members: </b>$numbermembers | <b>Online: </b>$totalonline </b> | <b>Newest :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (Welcome!)
</span></div>
     </td>
</tr>
</table>
<!-- Forum Stats in Header Template -->
 
Ofcourse you can customise this code to suit your website setup. ;)
 
9. And, now finally you are done! :)

Enjoy!!

Please Don't Forget to Click --> INSTALLED

[Neutral Singh]

Hey, sorry for a very very very late response. I have updated the xml plugin file now. Please let me know if it works fine now. That was due to missing TABLE_PREFIXes.

[Mr Chad]

Thank you that fixed my errors for total online, Your the best!

[Neutral Singh]

I am so glad that it worked for you.

[Dark Riku]

Just installed it, and im having issues

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT userid, username FROM vbuser WHERE vbuserid=881;

MySQL Error  : Unknown column 'vbuserid' in 'where clause'
Error Number : 1054
Date         : Sunday, November 20th 2005 @ 02:29:31 PM
Script       : http://www.123abc.com
Referrer     : 
IP Address   : XxX.XxX.XxX.XxX
Username     : name123
Classname    : vb_database

[SirJonathan]

Know of any way to get these stats to appear on a non-VB page? A way to include them in a standard PHP page? - This looks like a great hack and I'd love to use it on my forum's homepage outside of my vB install!

-Jonathan

[Dark Riku]

I Really, dont know whats wrong, i installed it and follow the instructions, yet its not working ahh!!

[Neutral Singh]

Strange its working for 31 others including for me!! Are you using any table prefixes?

Invalid SQL:
SELECT userid, username FROM vbuser WHERE vbuserid=881;

[Dark Riku]

Originally Posted by Neutral Singh

Strange its working for 31 others including for me!! Are you using any table prefixes?

I honestly i dont know lol, all i did was install vb and try this o.O


['tableprefix'] = 'vb';

(Was in the config file, so yea i guess so)

[Dark Riku]

Im going to Bump this and see what happeneds

[Neutral Singh]

I honestly i dont know lol, all i did was install vb and try this o.O


['tableprefix'] = 'vb';

(Was in the config file, so yea i guess so)

Ok just try this xml file. Hopefully, it should work for you.