Average age in forumhome
 

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:
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. :)

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

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

Just replace vb3_ with and it should work fine.

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

Make sure when you add TABLE_PREFIX that you remove vb3_ :)

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. :p :) Thanks a lot tamarian! :D

I'd change the query to something like

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.

This took two seconds to add, excellent hack!

*clicks installed*