LAM - Lifetime Statistics

[mawby]

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

Download the required attached .zip file
product-LAM_LifetimeStatistics.zip or product-LAM_LifetimeStatistics (vBadvanced).zip
Upload the files
Copy the contents of the upload folder onto your web server
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;

https://vborg.vbsupport.ru/attachment.php?attachmentid=122894&stc=1&d=1287571620

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

https://vborg.vbsupport.ru/attachment.php?attachmentid=122895&stc=1&d=1287571156


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;

https://vborg.vbsupport.ru/attachment.php?attachmentid=122771&stc=1&d=1286976085

And this is afterwards;

https://vborg.vbsupport.ru/attachment.php?attachmentid=122772&stc=1&d=1286976085

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

https://vborg.vbsupport.ru/attachment.php?attachmentid=122906&stc=1&d=1287654781



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]

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 (http://www.vbulletin.com/docs/html/datastore) 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. :confused:

[Boofo]

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

[mawby]

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.

[Boofo]

It would benefit all forums actually. If you have 100 users on, it would be 300 added queries on the forumhome. They can add up fast.

[Alecsmith]

Excellent mod installed and nominated for MOTM.

Thanks :)

[Alecsmith]

@ mawby - This add on didn't work with vbadvance its shows different Figures can you fix it you will find forum links in my siggy. :)

[mawby]

@ mawby - This add on didn't work with vbadvance its shows different Figures can you fix it you will find forum links in my siggy. :)I'll need to install vbadvance on my test system to fix that. Leave it with me and I'll see what I can do.

[mawby]

Updated to include a "Reduced Query" mode which uses the datastore as suggested by Boofo. :)

[ProFifaLeagues]

Nice one much better way of having it running too!But when ive upgraded the mod its totally gone from the forum home now?????
Any ideas

[mawby]

Do you mean the statistics are all zero? If so, that will be true until the cron task has run for the first time. If not, can you give me more details of what you mean by gone please.

[ProFifaLeagues]

Ok sorry fake alert there i did a hard refresh and all is well
Thanks top mod

[pedroenf]

Is it possible to make this work in CMPS (VBA)?

[Alecsmith]

updated with latest version hoping get solution for VBCMPS :D

[HUSSEINDAWOOD]

Installed On test web-site and it works very good
THX

[mawby]

@ mawby - This add on didn't work with vbadvance its shows different Figures can you fix it you will find forum links in my siggy. :)

Is it possible to make this work in CMPS (VBA)?

I've updated the product to support vBadvanced. Please download the vBadvanced version if you want your vBadvanced stats module to display the same values as FORUMHOME does.

[pedroenf]

I've updated the product to support vBadvanced. Please download the vBadvanced version if you want your vBadvanced stats module to display the same values as FORUMHOME does.

Thank you very much :)

[mawby]

I've re-uploaded the files to correct a spelling mistake in the cron task description. As it's only a description typo I've not increased the version number this time.

[Alecsmith]

I've updated the product to support vBadvanced. Please download the vBadvanced version if you want your vBadvanced stats module to display the same values as FORUMHOME does.

Thank you very much :D

[Peejay]

Nice one Mawby, thanks very much fella. Installed and in use :)

Cheers
PJ

[Scyther]

does this work well with vb 4.1.9?

[mawby]

does this work well with vb 4.1.9?It should work with all versions of vB since 4.0.6.