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 Floris

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

Unless you know something I don't - then I don't think there is any way to extract that data - vB does not keep such records.

[Boofo]

Originally Posted by Paul M

Unless you know something I don't - then I don't think there is any way to extract that data - vB does not keep such records.

This will give you total thread views and replies in a forum:

PHP Code:

 $numcount=$db->query_first("
  SELECT COUNT(threadid) AS threads, SUM(replycount) AS replies, SUM(views) AS views
  FROM " . TABLE_PREFIX . "thread
  WHERE forumid=$forumid
 "); 


This is what I use for my Forumdisplay stats cache hack.

[Paul M]

Originally Posted by Boofo

This will give you total thread views and replies in a forum:

Ah yes, but that count is not over a time period, and cannot be split between members and guests, which is what I meant.

[Boofo]

Originally Posted by Paul M

Ah yes, but that count is not over a time period, and cannot be split between members and guests, which is what I meant.

True, but still nice to have, I guess.

[Invalid ID]

It's not showing any result

[Bounce]

Installed and working well

Thanks Paul

[jilly]

This is a really useful hack for my board - Paul did a fantastic job - I have the mods turn in a weekly report on their forums, and that gets conglomerated into one big report to keep tabs on the site in general - the stats each week are an important part of showing the traffic each forum is getting, how many posters, etc.

One troubleshooting thing - you have to be either a mod attached to that specific board, or supermod or administrator to run the reports.

[vau7]

Is it possible to show / display Links to e.g. the started Threads in the last 30 Days ?

[ubercool]

Originally Posted by Boofo

True, but still nice to have, I guess.

Are you thinking about incorporating this feature? I'm looking for a way to track views for each forum, or do you show this already?

[Paul M]

Originally Posted by ubercool

Are you thinking about incorporating this feature? I'm looking for a way to track views for each forum, or do you show this already?

Nope. No changes will be made to my 3.5 hacks, and I have no plans to release a vb 3.6 specific version.