The Arcive of Official vBulletin Modifications Site.

Average age in forumhome · **Released**: 10-24-2005

This is a modification I really wanted for my forum and I am posting it cause I thought that others may find it useful as well. However, I only had the idea as Xenon helped my really much with the query (My SQL knowledge is very basic and this is why this hack isn't supported, I wish I could support it but I don't have the knowledge to do so).
Thanks also to tamarian for fixing the issue with the table prefix.

Instructions

1. Import the attached XML file. It's a plugin, not a product

2. Edit template FORUMHOME:
Find:

HTML Code:

<span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
                </if>

Add below:

HTML Code:

Average Age: $avg_age

You're done!

If you liked this and you are using it, don't forget to click INSTALL!

If you want less or more than 2 decimals at the average then:

In the plugin manager click Avg Age in order to edit the plugin code.
Find DAYOFYEAR(NOW())) / 365), 2) and change the 2 in green to the number of decimals you like.

Andreas · #2 10-25-2005, 02:16 PM

If you make the plugin use TABLE_PREFIX it will work on every installation, without needing to edit the Plugin

Lea Verou · #3 10-25-2005, 02:23 PM

I know but for some reason that gives a database error!

Andreas · #4 10-25-2005, 02:33 PM

Just replace vb3_ with

Code:

" . TABLE_PREFIX . "

and it should work fine.

Lea Verou · #5 10-25-2005, 02:37 PM

That's EXACTLY what I did. It doesn't. Really strange...

tamarian · #6 10-25-2005, 04:42 PM

Quote:

Originally Posted by Loukrhtia

That's EXACTLY what I did. It doesn't. Really strange...

Make sure when you add TABLE_PREFIX that you remove vb3_

Lea Verou · #7 10-25-2005, 04:48 PM

I did! I'll test the attached plugin and if it causes no db errors in my test forum I'll update the attachment

Thanks

edit: Yep, no database errors. I still can't figure out what I was doing wrong, lol.

Thanks a lot tamarian!

Boots · #8 10-25-2005, 04:57 PM

I'd change the query to something like

Code:

SELECT ROUND(AVG(YEAR(NOW()) - YEAR(birthday_search) - (DAYOFYEAR(birthday_search) - DAYOFYEAR(NOW())) / 365), 2) AS avgage WHERE YEAR(birthday_search) > 1950

replace 1950 with any cutoff date... on my forum where I was an old phpbb forum I have some birthdays in there of 1900 for some reason so that addition makes the query more accurate.

Extreme John · #9 10-25-2005, 05:32 PM

This took two seconds to add, excellent hack!

Moncal · #10 10-25-2005, 05:59 PM

*clicks installed*

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10981 seconds Memory Usage 2,295KB Queries Executed 24 (?)
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 (2)bbcode_code (2)bbcode_html (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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!