Statistics Modifications - LAM - Lifetime Statistics

This product will change the FORUMHOME threads, posts and members statistics to include deleted data. This means your forums statistics will only go up with each new posts/threads and will not be affected by forum deletions or thread/post pruning.

Since version 4.0.6.1 it is now possible to run this product in two modes. The default mode is to always query the database (with 3 separate queries) for the latest statistics whenever the FORUMHOME template is displayed. Alternatively, you can run this product in "Reduced Query" mode which utilises a cron task to put the statistics into the datastore every 15 minutes. This will prevent the additional queries normally done when FORUMHOME is displayed but it will mean the statistics shown can be up to 15 minutes out of date.

Since version 4.0.8 there are now two products available to download, one with support for changing the vBadvanced "Stats" module values, and one without. (Note: As I do not run vBadvanced on my site support for it may be removed from this product at any time)

Installation

1. Download the required attached .zip file
   product-LAM_LifetimeStatistics.zip or product-LAM_LifetimeStatistics (vBadvanced).zip
2. Upload the files
   Copy the contents of the upload folder onto your web server
3. Install the product
   AdminCP -> Plugins & Products -> Add/Import Product -> Import Product

Configuration

You can change this product to run in "Reduced Query" mode by modifying the following setting;



If running in "Reduced Query" mode, you can also change the frequency the statistics are updated by modifying the Schedule Task settings;




Example

Not much to show really. The screen shots below show the difference it makes to my site which is approaching 10 years old and has therefore had a fair amount of pruning done over the years.

This is before the product was installed on my site;



And this is afterwards;



This is the vBadvanced module which also gets updated if you install the vBadvanced version of this product.





Version History

4.0.8.0 - Support for vBadvanced stats module (2010/10/21)
4.0.6.1 - Added the "Reduced Query" mode (2010/10/20)
4.0.6 - Initial release (2010/10/13)


Suggestions

• Support changing the statistics on vBAdvance

[ProFifaLeagues]

Worked perfect thank you!
Rated and Installed

[COL NIL SATIS]

AWESOME !!!!!!!Thanks

[Boofo]

Nice idea.

It might be better to use the datastore for the info, though. This will add 3 queries to the forumhome as it is right now.

[BoostinEuros]

Awesome, worked perfectly!

[synseal]

Great mod.......... thankyou.

[Dr.osamA]

installed + 5 stars

thanxxx

[mawby]

Originally Posted by Boofo

It might be better to use the datastore for the info, though.

I'll admit to not being au fait with the datastore, so I looked in the manual which states...

To improve performance, vBulletin caches certain information which isn't updated often in the datastore, so that it doesn't have to be rebuilt every time it's needed.

This doesn't sound like what I need given how frequently the data is changing.

[Boofo]

You could run an hourly cron job for the queries to pull the info for the datastore.

[mawby]

Originally Posted by Boofo

You could run an hourly cron job for the queries to pull the info for the datastore.

OK I'll add it to a suggestions list as I can see why this would benefit really large forums.