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.


All times are GMT. The time now is 02:30 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.01302 seconds
  • Memory Usage 1,736KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete