Live Forum Statistics on All Pages in Header

[Neutral Singh]

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

Please Don't Forget to Click --> https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=95493)

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 (http://www.sikhism.us) 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 (http://www.sikhphilosophy.net/)

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/member.php?u=$newuserid"><b>$newusername</b></a> (Welcome!)
</span></div>
</td>
</tr>
</table>
<!-- Forum Stats in Header Template -->

[B]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 --> INSTALLEDhttps://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=95493)

[ThePimp]

Doesn't support table prefixes ie.. vb3_

[Neutral Singh]

Doesn't support table prefixes ie.. vb3_

Now it does!! XML updated. Thanks for the Pointer. ;)

[turksengel]

any screen ?

[Neutral Singh]

Visit the Demo Link --> http://www.sikhphilosophy.net

[thetoolman]

does it work in footer as well?

[Boofo]

You might want to let people know that this will run 5 queries on every page. Why not use the datastore? ;)

[thetoolman]

yes it works in footer too :)

[Neutral Singh]

You might want to let people know that this will run 5 queries on every page. Why not use the datastore? ;)

How can we use datastore? Thanks. :)

[Brandon Sheley]

i'd like this, i'll wait untill the queries are cut down :)

[hyproVision]

Wow your site looks very much like www.webhostingtalk.com !

[Blindchild02]

Wow your site looks very much like www.webhostingtalk.com !

i was just about to say that
http://www.webhostingtalk.com/

[hyproVision]

This comes up when i install it:

There seems to have been a problem with the Test Forums database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM testboardsession WHERE session.userid>0 AND session.lastactivity>1127143369;

MySQL Error : Unknown table 'session' in where clause
Error Number : 1109

[HaYLaZ]

ı made some code modifications about this and ı change the table:D
ı think it was very beatiful and changable all colours
replace the codes below wiht your old codes and ı put this codes to myforumhome template under $navbar code.You can see the example in attachment

<!-- Forum Stats in Header Template -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table align="center" border="1">
<tr>
<td bordercolor="red"><div class="smallfont">
<span style="color: red;"><b>Discussions:</b> $totalthreads </span></div>

<td bordercolor="blue"><div class="smallfont">
<span style="color: blue;"><b>Messages:</b> $totalposts </span></div>

<td bordercolor="black"><div class="smallfont">
<span style="color: black;"><b>Members: </b>$numbermembers </span></div>

<td bordercolor="green"><div class="smallfont">
<span style="color: green;"><b>Online: </b>$totalonline </b> </span></div>

<td bordercolor="purple"><div class="smallfont">
<span style="color: purple;"><b>Newmember :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (welcome!)</span></div>

</tr>
</table>
<!-- Forum Stats in Header Template -->


you can change colours yourself

[Neutral Singh]

ı made some code modifications about this and ı change the table:D
ı think it was very beatiful and changable all colours
replace the codes below wiht your old codes and ı put this codes to myforumhome template under $navbar code.You can see the example in attachment

<!-- Forum Stats in Header Template -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table align="center" border="1">
<tr>
<td bordercolor="red"><div class="smallfont">
<span style="color: red;"><b>Discussions:</b> $totalthreads </span></div>

<td bordercolor="blue"><div class="smallfont">
<span style="color: blue;"><b>Messages:</b> $totalposts </span></div>

<td bordercolor="black"><div class="smallfont">
<span style="color: black;"><b>Members: </b>$numbermembers </span></div>

<td bordercolor="green"><div class="smallfont">
<span style="color: green;"><b>Online: </b>$totalonline </b> </span></div>

<td bordercolor="purple"><div class="smallfont">
<span style="color: purple;"><b>Newmember :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (welcome!)</span></div>

</tr>
</table>
<!-- Forum Stats in Header Template -->


you can change colours yourself

Yeah, hee hee, its duly called WHT Remix Style. ;)

Nice work HaYLaZ !! :)

[Mr Chad]

Yeah, hee hee, its duly called WHT Remix Style. ;)

Nice work HaYLaZ !! :)

didnt work w/ gold.

[Mr Chad]

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM x_session WHERE session.userid>0 AND session.lastactivity>11288029;

MySQL Error : Unknown table 'session' in where clause
Error Number : 1109
Date : Sunday, October 9th 2005 @ 04:17:09 AM
Script : http://www.thesite.com/
Referrer :
IP Address : x.x.x.x
Username : Chad
Classname : vb_database

[Mr Chad]

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM x_session WHERE session.userid>0 AND session.lastactivity>11288029;

MySQL Error : Unknown table 'session' in where clause
Error Number : 1109
Date : Sunday, October 9th 2005 @ 04:17:09 AM
Script : http://www.thesite.com/
Referrer :
IP Address : x.x.x.x
Username : name
Classname : vb_database

why cant i get it to show how many users are online?

[Mr Chad]

? anyone

[Mr Chad]

? anyone

how come you got it to work for online members...

[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? :D - 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]

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. :)

[Dark Riku]

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

Thanks so much :) Works like a charm

[Neutral Singh]

Thats gr8!! :)

[proxyMX]

Thats gr8!! :)

does this work for 3.5.2?

[Lowfyr]

does this work for 3.5.2?

yes, works fine for me - installed.

[blueuniverse]

Is it possible to show full details about those who are online with the plugin? By that I mean, exactly as it is on the forumhome with all online members listed.

[blueuniverse]

Any update on that?

[The Chief]

installed and works great ;)

* The Chief clicks install

[bashy]

Hi peeps

Thanks for this, considered it installed and used your 1 HaYLaZ :)

Bashy

ı made some code modifications about this and ı change the table:D
ı think it was very beatiful and changable all colours
replace the codes below wiht your old codes and ı put this codes to myforumhome template under $navbar code.You can see the example in attachment

<!-- Forum Stats in Header Template -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table align="center" border="1">
<tr>
<td bordercolor="red"><div class="smallfont">
<span style="color: red;"><b>Discussions:</b> $totalthreads </span></div>

<td bordercolor="blue"><div class="smallfont">
<span style="color: blue;"><b>Messages:</b> $totalposts </span></div>

<td bordercolor="black"><div class="smallfont">
<span style="color: black;"><b>Members: </b>$numbermembers </span></div>

<td bordercolor="green"><div class="smallfont">
<span style="color: green;"><b>Online: </b>$totalonline </b> </span></div>

<td bordercolor="purple"><div class="smallfont">
<span style="color: purple;"><b>Newmember :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (welcome!)</span></div>

</tr>
</table>
<!-- Forum Stats in Header Template -->


you can change colours yourself

[The Chief]

Does anybody know how this could work with vB Drupal??

How we could get these functions to work with the vB Drupal header..??

[version2]

Does anybody know how this could work with vB Drupal??

How we could get these functions to work with the vB Drupal header..??

Any word on cutting down the queries?

[Sean James]

Installed and working great ;)

Only problem i have is that it messes my gallery table on the forumhome template.

http://www.bluepearl-design.com/forums/

Anyway i can fix this?

[Neutral Singh]

Any word on cutting down the queries?

Its possible, if we store the information in a database and then retrieve it after fixed intervals using cron tabs but then the informaiton will not be "LIVE". However, if somebody can make this possible then i will gladly add that to the first post with full credits. :devious:


Hi Griffin,

I think you finally figured it out. :) Nice site btw. Great Styles!!

[Sean James]

thx man, yeah i got it sorted after i posted for help lol always the way

[Bubble #5]

Do NOT use this with 3.5.3! Unless you want your database to go bye-bye :ermm:

[Sean James]

Do NOT use this with 3.5.3! Unless you want your database to go bye-bye :ermm:

been using this on my forum running 3.5.3 for about 3 weeks or more, and havent had any problems yet

[prettyboi]

I don't know what had happen but after installing the product. My site had caused a major serious error and then I couldn't even find the product to removed it.

[kildjean]

I just upgraded to 3.5.4. I installed this because Im using the styles from vbskinworks.com and they recommended this plug-in.

This is the error I am getting:

Database error in vBulletin 3.5.4:

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

MySQL Error : Unknown column 'vbuserid' in 'where clause'
Error Number : 1054
Date : Tuesday, February 21st 2006 @ 10:26:49 PM
Script : http://www.zonaxbox360.com/
Referrer :
IP Address : 70.45.48.203
Username : Lord Badr
Classname : vb_database

My table prefix is 'vb'

Please help.

[Bubble #5]

I just upgraded to 3.5.4. I installed this because Im using the styles from vbskinworks.com and they recommended this plug-in.
Well John must have 'recommended' it a long time ago, because this plugin hasn't worked with their skins since 3.5.2 :nervous:

[Impreza04]

Im using this plugin for the blackteal skin and its working perfectly on 3.5.3 and 3.5.4..

[Bubble #5]

It's not a matter of 'if' :rolleyes: The plugin is rated to work up to V. 3.5.2 and has already been documented to cause server problems. If you want to use it then that's your business, but a false sense of security is often worse than no security at all :ermm: If one day your entire board 'suddenly' goes down, then you might want to start diagnostics testing with this plugin. Enjoy.

[kildjean]

Dude chill your attitude... jeez.. just trying to find some info.

John's Post:

[ January '06 ]
There are a few styles we offer pre-coded to have the ability to display live forum statistics in the header. We have simply coded the skin but there is a plugin we provide a link to that actually make this happen.

This plugin was released for free from vbulletin.org and as such is not warrantied nor supported by vBSkinworks.

As with any add-on or hack, it is highly recommended that you backup your database prior to installing and further, we recommend you familiarize yourself with how this plugin works and any issues you may encounter.

The plugin may be found and researched at: https://vborg.vbsupport.ru/showthread.php?t=95493

Thank You, The vBSkinworks Team

[smacklan]

I am running this plugin on vBSkinworks with no issues (version 3.5.4), however, the plugin does add 5 sql queries so that is something to keep in mind when deciding whether to use it. My experience has been when the database errors occur, it's related to table prefixes of your vb database. The author has addressed this earlier in this thread with an altered version of the plugin and that is the one I use.

[ShadowOne]

works great for me with the blackteal skin on 3.5.4

[mcyates]

How come the total posts on my header says 280,848 but the total posts in the Forum Statistics at the bottom of the forumhome template says 280,022?

Do they take the information from different sources?

[Neutral Singh]

This hacks counts all the posts in your database whether they are under usergroup restrictions or not which i think is the true count of posts in your forums. :)

[mcyates]

This hacks counts all the posts in your database whether they are under usergroup restrictions or not which i think is the true count of posts in your forums. :)


Well how can i get them to be the same, can i change the at the bottom of the site to show the same number of posts as the one at the top?

[offsidex]

is there a way to uninstall this thing ? It has messed up my whole website!

[trickedoutpc]

where can I d/l the newest version in zip format or do I just d/l the XML file next to the instructions. I tryed that but get errors. anyone have a link to a good d/l thanks again.

[smacklan]

where can I d/l the newest version in zip format or do I just d/l the XML file next to the instructions. I tryed that but get errors. anyone have a link to a good d/l thanks again.
Hey, PM me on my site and I'll send you the one you need that will work for you ;)

[mano1.com]

Installed!

[kurtbarker]

This hacks counts all the posts in your database whether they are under usergroup restrictions or not which i think is the true count of posts in your forums. :)

hey mate, was going to install, but what is stated above is a bit of a worry for me... I have admin/mod/official sections which only those usergroups have access to, I don't want to display more posts than what my members can actually see, and if it shows a different count from the stats down the bottom, then it could be seen as a 'bug' by my members

[Neutral Singh]

Is there any need to show both the stats at all... just remove the stats down the bottom !! ;)

[Svenna]

sorry, don?t work.

https://vborg.vbsupport.ru/showthread.php?t=116361


I have tried all sorts of things but it simply does not work.

[MrOnline]

i've had to use impex on my old vb sqldb and move to a new, but on the new one after running all kinda "maintance" i still cant get the this plugin to show anything at the header...
the default stats update like no problem, but nothing comes up on top...

[Neutral Singh]

i think you would have to install the plugin again.

[napy8gen]

me too having the same problem to 2 of our client skin;

Invalid SQL:
SELECT userid, username FROM vb_user WHERE vb_userid=9041;

MySQL Error : Unknown column 'vb_userid' in 'where clause'
Error Number : 1054

the plugin was installed and the code is put in header template properly.Any clue Mr Singh?

[TitanJeff]

I am having a custom skin designed for 3.5.1 and installed this just a few minutes ago. It worked like a charm but it messed with my photo thumbnail table below the masthead by scrunching (technical term) the thumbnails to the left. Not only that, it did the same thing to my current skin which isn't even using the plugin.

Any ideas or suggestions as to a fix? I turned off this plugin and all returned to normal. I can post an image if it may help.

Thanks!

[TitanJeff]

I am having a custom skin designed for 3.5.1 and installed this just a few minutes ago. It worked like a charm but it messed with my photo thumbnail table below the masthead by scrunching (technical term) the thumbnails to the left. Not only that, it did the same thing to my current skin which isn't even using the plugin.

Any ideas or suggestions as to a fix? I turned off this plugin and all returned to normal. I can post an image if it may help.

Thanks!

Just to follow up, here are screen shots which show the problem better.

[Neutral Singh]

Hi Jeff, sorry for a late reply... see you dont have to put the same html formatting i used for an example....

So, even the following code should work for you!!


<b>Discussions:</b> $totalthreads </br>
<b>Messages:</b> $totalposts </br>
<b>Members: </b>$numbermembers </br>
<b>Online: </b>$totalonline </b> </br>
<b>Newest :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (Welcome!) </br>

[TitanJeff]

Hi Jeff, sorry for a late reply... see you dont have to put the same html formatting i used for an example....

So, even the following code should work for you!!


<b>Discussions:</b> $totalthreads </br>
<b>Messages:</b> $totalposts </br>
<b>Members: </b>$numbermembers </br>
<b>Online: </b>$totalonline </b> </br>
<b>Newest :</b> <a href="$vboptions[bburl]/member.php?u=$newuserid"><b>$newusername</b></a> (Welcome!) </br>

I am still getting the same error with the thumbnails shifting. Here is the code:

<td style="background-image:url($stylevar[imgdir_misc]/header_mid_bg.gif); background-position:top;">
<p class="headlink2">
<span class="headlink2">
<strong>Members:</strong> $numbermembers<br />
<strong>Threads:</strong> $totalthreads<br />
<strong>Posts:</strong> $totalposts<br />

<br />
<strong>Newest Member:</strong> <a href="$vboptions[bburl]/member.php?u=$newuserid">$newusername</a></span></p>
</td>

I assume this has to be in the plug-in code itself as my current template, that doesn't even use this plugin, has a shift of the photo gallery thumbnails when the plugin is activated.

[TitanJeff]

Installed and working great ;)

Only problem i have is that it messes my gallery table on the forumhome template.

http://www.bluepearl-design.com/forums/

Anyway i can fix this?
It looks my problem is a repeat of a previous one. Anyone know the solution? Thanks.

[007]

Hi,

Does this hack also allow the "Most users ever online" record to be updated from any page as well? By default, this record seems to only updated when somebody views the index.php file and the current number of active users is higher than the current record. Does your hack update this from any page? Thanks!

~007

[MrOnline]

i'm using deliosso, and it says i "must" have this plugin, i've tried both versions of the xml but can't seem to get it to work, any tip's on what it might be ??

It's just not showing ANYTHING :-)
This is on a vbulletin v3.5.4 where all users are imported via impex :-D

[Polo]

I only used this hack for the "total users online" in the top header... and removed the extra queries :) for the other stats

thanks so much ;) working great and as desired.

[Renmiri]

Sweet!

Installed :laugh:

[powerbook]

The first xml messed up the board and the db didn't work but I deleted that one and installed the second xml and now it's a treat... Thanks...

[aveon]

hey man can we make it work for the left column i tried but it didnt show the numbers???

[Firestar.chkn]

Hi,

Thanks for a great hack! Is there some way of getting some (or all the information to update themselves via AJAX? I am especially interested in updating the number of users online every x amount of minutes/hours.

If possible, could you do this in the next version (perhaps make it an option)?

[Allan]

Great hack, thank you :)

[Allan]

i'm a little problem :p

The hack statistics are differents from that of vBulletin. (screen)

[Neutral Singh]

Yeah!! Thats because my plugin does not take into consideration all the hidden threads. ;)

[gullystation]

any chance of changing the colour of the text of the statistics in the header to white?

[Neutral Singh]

any chance of changing the colour of the text of the statistics in the header to white?

Why not. The following code should work for you just fine. :)


<!-- Forum Stats in Header Template -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="left"><span style="color:white;" 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 -->

[masterme]

Just installed it (already had a statscolumn so without that part..)
Works perfect!

[GruntHalo]

Thanks for this I'll be using it on www.h2grunt.com :D on my forums page.

[McDot]

Hi,

I'm having a little of a fight with this plugin.:(

Running on www.trendstuff.com

No error messages but no display as it should.:confused:
Where can I look?

[McDot]

OK, my mistake!!!

Works fine!!!

[da_judge]

Dont work with 3.7.... damm... i will try fix.. unless anyone else has the fix

Cheers da_judge

[TTG]

Dont work with 3.7.... damm... i will try fix.. unless anyone else has the fix

Cheers da_judge

Working fine on my 3.7.0 beta 5 :up:

[Toranto]

Thanks. Works fine with vBulletin 3.7.0 Gold. :)