vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Statistics Modifications - LAM - Lifetime Statistics (https://vborg.vbsupport.ru/showthread.php?t=252030)

mawby 10-12-2010 10:00 PM

LAM - Lifetime Statistics
 
1 Attachment(s)
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;

https://vborg.vbsupport.ru/attachmen...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/attachmen...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/attachmen...1&d=1286976085

And this is afterwards;

https://vborg.vbsupport.ru/attachmen...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/attachmen...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 10-13-2010 09:50 AM

Worked perfect thank you!
Rated and Installed

COL NIL SATIS 10-13-2010 01:35 PM

AWESOME !!!!!!!Thanks

Boofo 10-13-2010 02:33 PM

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 10-13-2010 04:24 PM

Awesome, worked perfectly!

synseal 10-13-2010 05:42 PM

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

Dr.osamA 10-14-2010 05:35 AM

installed + 5 stars

thanxxx

mawby 10-15-2010 09:43 AM

Quote:

Originally Posted by Boofo (Post 2109767)
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...

Quote:

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 10-15-2010 11:28 AM

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

mawby 10-15-2010 11:47 AM

Quote:

Originally Posted by Boofo (Post 2110347)
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 10-15-2010 12:17 PM

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 10-16-2010 11:32 AM

Excellent mod installed and nominated for MOTM.

Thanks :)

Alecsmith 10-18-2010 10:36 PM

@ 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 10-20-2010 07:07 AM

Quote:

Originally Posted by Alecsmith (Post 2111486)
@ 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 10-20-2010 09:49 AM

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

ProFifaLeagues 10-20-2010 10:04 AM

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 10-20-2010 10:40 AM

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 10-20-2010 10:56 AM

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

pedroenf 10-20-2010 11:48 AM

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

Alecsmith 10-21-2010 01:35 AM

updated with latest version hoping get solution for VBCMPS :D

HUSSEINDAWOOD 10-21-2010 03:05 AM

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

mawby 10-21-2010 09:01 AM

Quote:

Originally Posted by Alecsmith (Post 2111486)
@ 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. :)

Quote:

Originally Posted by pedroenf (Post 2112013)
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 10-21-2010 01:10 PM

Quote:

Originally Posted by mawby (Post 2112307)
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 10-29-2010 02:43 PM

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 10-29-2010 06:31 PM

Quote:

Originally Posted by mawby (Post 2112307)
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 03-06-2012 11:15 AM

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

Cheers
PJ

Scyther 03-09-2012 04:03 AM

does this work well with vb 4.1.9?

mawby 03-28-2012 06:27 AM

Quote:

Originally Posted by Scyther (Post 2307737)
does this work well with vb 4.1.9?

It should work with all versions of vB since 4.0.6.


All times are GMT. The time now is 06:06 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01310 seconds
  • Memory Usage 1,773KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (28)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete