Miscellaneous Hacks - Forum Stats

Forum Stats

vBulletin 3.5.x and vBulletin 3.6
www.vBHackers.com

What this does
It globals the forum statistics like thread info so you can use it on any page not just the forum home. Feel free to use in your modifications but please add credits!

To do list...

• Time to install: About a minute or two
• New Templates: 0
• Template Edits: Depends what you want to do.
• New Files: 0
• New Phrases: 0
• New Plugins: 1

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Instructions
Import the attached file into the PLUGIN section. You then have serveral variables you can use throughtout your forums:
$numbermembers - The number of members your forum has.
$totalposts - The number of posts in your forum.
$totalthreads - The number of threads in your forum.
$headerguests - The Number of Guests online.
$headerusers - The number of Users online.
$totalonline - The number of guests and users online.
and then an added bonus:
$newusername - Gets the username of the newest user
$newuserid - Gets the userid of the newest user (you could use this in a template as a conditional so when you get to userid 100 then you display a table saying you have got 100 users.)

Hope you like, feedback welcomed.

[Hasann]

thanks for releasing it is very usefully hack

[Nick R]

Done by request... For someone... i think it was.... Kau....

[TheSh@rk]

Great hack.
Thanks for releasing..

[Arnoud]

Good work

When we use this with beta 4 we get database errors. When we disable it we can log in again. It also seems to be messing up the welcome headers hack by TedS :ermm:

[Nick R]

I use it and it's fine. Could you tell me what database error your getting?

EDIT: just checked. Works fine for me all installed and i have checked all the variables..

Look at advertise.php that also uses this mod...

Just letting you know what's happening with it on our forum ;) The error is unknown column 'userid' in 'where clause'.

[Nick R]

Can you please give the FULL error message.

Ok take a look in phpmyadmin look at the table seesion and check if there is a column called userid there. And then check in user. Thats the only two where's used.

edit: just as a though try the attached file. your forum might be fussy :p

MySQL Error : Unknown column 'vb36_userid' in 'where clause'
Error Number : 1054
Date : Sunday, July 9th 2006 @ 01:50:51 PM
Script : http://www.website.com/forum/index.php
Referrer : http://www.website.com/forum/admincp/index.php?do=head

Both the table session and the table user have a column called userid.

What's the difference between the first xml and the one you just posted?