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.

[Mr Chad]

Looks pretty good, Installin.

[klaush]

Mhhhh:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount
FROM vb3_post AS post
LEFT JOIN thread on post.threadid = thread.threadid
WHERE post.dateline > 1145122278 AND thread.forumid IN (32);

MySQL-Fehler : Table 'usr_web2_3.thread' doesn't exist

---

Thanks!:-)

[XanTrax]

Need to include table prefix in the code.

[Paul M]

Oops, a table prefix missing on the joins - 1.06 uploaded to fix it.

[topsoftware]

where is the link

[Paul M]

As it says ;

This adds an option to the forum tools dropdown menu

[Boofo]

Nice idea.

Are you planning on adding any other statistics to this?

[Atakan KOC]

Nice. Thanks

[Ziki]

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 > 1145129031 AND thread.forumid IN (2);

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