Simple Forum Usage Statistics

This modification is no longer available or supported.

This is a little custom hack originally written for Jilly.

This adds an option to the forum tools dropdown menu to display three counts for the forum (and sub forums if you click on the link) - Number of New Posts, Number of New Threads and Number of Unique Posters - all for a preset time limit (in days). The days and usergroups allowed to use it this function are defined in the ACP.

Unzip the xml file and import it into vbulletin via the product manager, then set the options (in the vb options > forum display options). 7 Days and usergroups 5,6 & 7 are the defaults.


History:

v1.01 : First Private Release.
v1.02 : Minor changes, no update necessary.
v1.03 : Permissions added.
v1.04 : Forum Tools Link Automated.
v1.05 : First Public Release.
v1.06 : Fixed missing table prefixes on joins.
v1.07 : Fixed more table prefix errors.

[Paul M]

Originally Posted by Boofo

Nice idea.

Are you planning on adding any other statistics to this?

What it has now is what was required by the original requestor, so I haven't really thought about it. What other stats were you thinking of ?

[Paul M]

Originally Posted by ZIKI-SET

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Saturday, April 22nd 2006 @ 03:23:51 PM
Script : http://www.xxxxxxxxxx.com/forums/mis...forumstats&f=2
Referrer : http://www.xxxxxxx.com/forums/forumdisplay.php?f=2
IP Address : XXXXXXX
Username : ZIKI-SET
Classname : vb_database

Aaaarrrggg, bloody table prefixes should be banned. :cross-eyed:

Fixed.

[tei727]

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

[Paul M]

Originally Posted by tei727

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

Posting only a small part of the error message is not much use to me, but I think that's fixed by 1.07 anyway - I can't see any stupid prefix changes I've missed now.

Note to self: I really must set-up a test forum using prefixes.

[Boofo]

Originally Posted by Paul M

What it has now is what was required by the original requestor, so I haven't really thought about it. What other stats were you thinking of ?

Last Poster, Link to last post, stuff like that. I might add some things to it that I use for my forumstatistics Cache hack. Using the datastore would be better if you have a lot of staff using it all the time. But they really shouldn't be, I would think. Scratch the datstore idea.

[Ziki]

Now I get

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM forumziki_post AS post
LEFT JOIN forumziki_thread on post.threadid = thread.threadid
WHERE post.dateline > 1145131653 AND thread.forumid IN (2);

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Date : Saturday, April 22nd 2006 @ 04:07:33 PM
Script : http://www.xxxxxxxxx.com/forums/misc...forumstats&f=2
Referrer : http://www.xxxxxxxx.com/forums/forumdisplay.php?f=2
IP Address : XXXXXXX
Username : ZIKI-SET
Classname : vb_database

[tei727]

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM nukepost AS post
LEFT JOIN nukethread on post.threadid = thread.threadid
WHERE post.dateline > 1145132315 AND thread.forumid IN (21);

MySQL Error : Unknown table 'thread' in where clause
Error Number : 1109
Date : Saturday, April 22nd 2006 @ 03:18:35 PM
Script : http://xxxxxxxxmisc.php?do=forumstats&f=21
Referrer : http://xxxxxxxxxxxxxxx/forumdisplay.php?f=21
IP Address : 69.251.126.92
Username : xxxxxxxx
Classname : vb_database

[Paul M]

Ziki, that isn't v1.07, make sure you re-downloaded it, extracted it etc.

This is the SQL in 1.07, you have the bold bit missing (as in v1.06).

SELECT COUNT(post.dateline) AS postcount
FROM ".TABLE_PREFIX."post AS post
LEFT JOIN ".TABLE_PREFIX."thread AS thread ON post.threadid = thread.threadid

Same applies to you tei727 - that sql is not from the current version.

[Floris]

Originally Posted by Paul M

What it has now is what was required by the original requestor, so I haven't really thought about it. What other stats were you thinking of ?

Total times the forum has been viewed by members (and guests): 5 (12)

[hotwheels]

very nice paul m.............