The Arcive of 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, 01: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, 01:23 PM

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

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

Just replace vb3_ with

Code:

" . TABLE_PREFIX . "

and it should work fine.

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

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

tamarian · #6 10-25-2005, 03: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, 03: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, 03: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, 04:32 PM

This took two seconds to add, excellent hack!

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

*clicks installed*