vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Forumhome Stats Cache Serialize hack v2.2 (https://vborg.vbsupport.ru/showthread.php?t=61420)

gmarik 02-11-2004 06:18 PM

Why this looks nice. Could add latest attachment as an option as well ...

Gio Takahashi 02-11-2004 07:08 PM

Will install! Good job.

Mike Gaidin 02-11-2004 08:19 PM

Nice one Bob. Glad to see you finally released it. :)

[high]* Mike Gaidin clicks install.[/high]

rinkrat 02-11-2004 08:57 PM

Can it say Top Reputation?

Boofo 02-12-2004 12:10 AM

You can add whatever you want to it. The possibilities are endless. ;)

Boofo 02-12-2004 07:41 PM

Ok, all you query junkies! ;) New version uploaded to first post. One more query deleted from this hack. Now uses serialize to store the data. ;)

Mike Gaidin 02-12-2004 08:50 PM

Upgraded. Good job Bob. :)

Boofo 02-12-2004 09:15 PM

Thanks, Mike! ;)

Alien 02-13-2004 03:05 AM

Quote:

Originally Posted by Boofo
You can add whatever you want to it. The possibilities are endless. ;)

Awesome work. How do the queries work overall? I understand it just grabs data at intervals or whatever, but after it does and someone loads the forumhome how many queries max extra are they running at that particular moment? :) Just curious!

[high]* Alien clicks install.[/high]

Boofo 02-13-2004 03:20 AM

This hack will add 1 query to what you already have (for the new threads and new posts since you last logged on). This can't be cached because it is per user. If you have 10 you will now have 11 when reading from the cache. Since the cache is serialized, there is no query there. So the update to the hack dropped one query. When it updates the cache, it will add 9 queries for all of the stats being updated. So you would then have 20 queries. But the 20 queries only runs at whatever interval you have set (default is 10 minutes). Once the cache is updated, you are back down to 11 queries until the next update. This way you can have numerous stats on your forumhome and not have to worry about a lot of server load at all times. With the serialzation, you can use these same stats on other ares of the board by just including the statscache in the special templates section of the file you want to use them in and you won't have you worry about any queries there (if I understand serialization, right, anyway). ;)

Does that help to understand this a little better. ;)


All times are GMT. The time now is 10:40 AM.

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.01352 seconds
  • Memory Usage 1,729KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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