The Arcive of Official vBulletin Modifications Site.

vbTrends 1.1.2 - An Enhanced Statistics Box on Forum Home · **Released**: 04-18-2006

Keywords: Statistics, New members, joins, trends, Forum Home, threads, posts

Description:
Enhances the "YourBBS" Statistics box on the forum home to show trends of posts, threads and new users vs. the overall history of the board. Also allows you to display more than one "newest member".

Version 1.1.2:

Added admincp menu to reset cached counters.
Fixed a couple of divide by zero errors that occurred when your board had no history (was less than a month old).
Fixed so templates are now cached.

Version 1.1.1:

Fixed calculation of statistics - should definately be correct now

Version 1.1.0:

Fully phrased.
Uses templates now so look and feel can be customized
Fixed bug so output is valid xhtml 1.0.

Version 1.0.0:

Turn on/off in admincp
Offers the option to auto replace in templates, or to manually edit templates.
Allows more than one 'newest user' to be display.
Shows trends for posts, threads and new users - this month vs. the boards average.

Install

Download the vbTrends_1.0.0.zip.
Unzip and follow instructions in install.html.

hambil · #12 04-18-2006, 11:58 PM

Okay, I changed it to support older versions of MySQL now.

hambil · #13 04-18-2006, 11:58 PM

Quote:

Originally Posted by SolidSnake@GTI

its a nice hack

but has a very bad issue
it consmes over 30 query

try to improve this hack by reduce database queries

30 queries? What are you drinking?

DJ XtAzY · #14 04-19-2006, 12:05 AM

im gonna test it out and see if i have the same query results

hambil · #15 04-19-2006, 12:06 AM

Keep in mind it runs a number of querys ONCE a day, the first time someone hits it, and stores the results in the datastore. I really don't think those count

wizardan · #16 04-19-2006, 12:07 AM

Installed flawlessly.
MySQL 4.1.15.

Very cool hack, Hambil.
Thank you.

DJ XtAzY · #17 04-19-2006, 12:16 AM

heres my statistic

if i didnt enable vbtrend, the total amount of queries is 22
if i enabled vbtrend, the total amount of queries is 27
so i guess it boost just 5 queries... but i still love this hack =]

but how to those percentage works?

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?

hambil · #18 04-19-2006, 12:19 AM

Quote:

Originally Posted by XtAzY

heres my statistic

if i didnt enable vbtrend, the total amount of queries is 22
if i enabled vbtrend, the total amount of queries is 27
so i guess it boost just 5 queries... but i still love this hack =]

but how to those percentage works?

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?

Sould be 4 queries, but the implementation of the datastore is flawed, and mostly useless for hooks. I've started a thread on vb.com about it.

hambil · #19 04-19-2006, 12:20 AM

Quote:

Originally Posted by XtAzY

Threads: 9,788, This Month: 699 (175%)
Posts: 216,372, This Month: 14125 (1177%)
Members: 18,914, This Month: 1209 (134%)

arnt those percentage a bit huge?

Maybe, let me check my math.

MThornback · #20 04-19-2006, 12:47 AM

Quote:

Originally Posted by hambil

Okay, I changed it to support older versions of MySQL now.

Your a gentleman and a scholar

thank you from me and my users!

hambil · #21 04-19-2006, 12:49 AM

Okay, I think I got it this time. Changing the queries through me off for a bit, but the numbers look right again. Updated.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05329 seconds Memory Usage 2,303KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!