Average age in forumhome

[Lea Verou]

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:
<span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
</if> Add below:
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]

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

[Lea Verou]

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

[Andreas]

Just replace vb3_ with " . TABLE_PREFIX . " and it should work fine.

[Lea Verou]

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

[tamarian]

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

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

[Lea Verou]

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

[Boots]

I'd change the query to something like


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]

This took two seconds to add, excellent hack!

[Moncal]

*clicks installed*

[Snake]

Installed!

[Lea Verou]

Installed!

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

:);)

[weaver]

How would you integrate this with vbadvanced? I found the template to insert it into but it's not showing a value for age.

[Lea Verou]

How would you integrate this with vbadvanced? I found the template to insert it into but it's not showing a value for age.

Woops sorry I took so long to respond, I didn't notice your message!
What do you mean "integrate it with vbadvanced"? You want it to show in the stats block?
Also, the most common reasons for it not showing a value for age:
1. You haven't done the template change correctly
2. The plugin isn't enabled
3. If you have the very first version of the hack, you haven't entered the database perfix correctly (if that's the case you would get a db error as well)

Do you get any errors or the number just doesn't show?

[Julie]

Hm, funny little thing this :D Thanks!

*installs*

[Lea Verou]

Thank you :)
What is funnier is the way I came up with it! :p
Some people (a very annoying competitor as well) that had only seen a little of my forum were saying that it has a very low level of average age which I knew was not true. So I put that in the forumhome and when they saw average age 29 they shut their mouths :D

[Julie]

Thank you :)
What is funnier is the way I came up with it! :p
Some people (a very annoying competitor as well) that had only seen a little of my forum were saying that it has a very low level of average age which I knew was not true. So I put that in the forumhome and when they saw average age 29 they shut their mouths :D

Haha, wicked! Well, great ideas often come from simple things like that!

[El Barto]

This didnt work in my forum.


Edit; it works fine, thanxs! :)

[Lea Verou]

What does it show?

[El Barto]

What does it show?

I`m sorry, but I did something wrong.

[Lea Verou]

did you solve the problem?

[El Barto]

Yes, i did at first place "Average Age: $avg_age" above if.

[alfaowner]

works well, thanks

[yowen]

It's not displaying anything for me...

this is what I see: "Average Age: "

I upgraded from 3.0.0 RC4 and my forumhome template does show up (in admincp home) as one of the templates that has been updated. But I cant find anything in there that would cause this code not to work, I just put it in the code right after the member count

btw. This is on a password protected test forum, not the one listed in my profile.

[PJSkiboy]

Excellent little addition.

I have one forum member (oldest guy on the forums) always saying everyone is so young, yada yada yada....

Now he can eat some humble pie. :D

Thanks a ton.

[Lea Verou]

Is the plugin enabled yowen?

[yowen]

yes it is.

[Pagandream]

Hi,

thx for this hack? But one question, how does it calculate the age? In my forum 50 % doesn't have fill out her age, coz it not necessary for getting registered. Does it only use those with an age in the profile or does it use all member?

For example you have 4 Members, all are 20 years old but only 3 have fill out their age, so will it calculate 60:3 = 20 or 60:4=15

Sorry for my bad english

[Lea Verou]

I calculates from all members that have entered a date :)

[dutchbb]

Hm, funny little thing this :D Thanks!

*installs*
Unfortunatly a funny little thing that adds 1 query, and imho, that's not really worth it.

[Lea Verou]

Unfortunatly a funny little thing that adds 1 query, and imho, that's not really worth it.
Then don't install it.
In what particular way can your comment be considered "constructive"?

[Boofo]

Then don't install it.
In what particular way can your comment be considered "constructive"?

Don't worry, Michelle, I'll install this. If he can come up with another way to get this info without a query, then he'll be doing magic. ;)

[dutchbb]

Then don't install it.
I didn't

In what particular way can your comment be considered "constructive"?
Because people should know this.

I didn't mean to be offensive or anything.

[Protonus]

Wanted to let ya'll know this works in 3.6. However I didn't like where it displayed the age, thought it was kinda of weird, makes it look like it's implying it's the age of the members currently signed in.

Instead, I wanted it next to the member total in the navbar. See here for instructions on how to do this, I think it looks a lot better:
http://www.vbstyles.com/forum/showthread.php?t=3155

[adwade]

See here for instructions...
For the benefit of those who don't have a vbstyles login...

Yes, it in template "navbar".

Please try it like this (works for me):

open template "navbar" and search for:

$vbphrase[active_members]: $activemembers</span></if></div>Modify this line that it looks like:

$vbphrase[active_members]: $activemembers</if>, Average Age: $avg_age</span></div>Daniel

:D Great to know this works with vB3.6 :D and FWIW, Miko (http://www.vbstyles.com) makes GREAT Skins for vB!

[The Coon]

Great ... still works with 3.8.2! THX!

[alfaowner]

Great ... still works with 3.8.2! THX!

Agreed, thanks!

[The Coon]

Unfortunately it don`t works with vBulletin 4.

Could please someone take a look on this cool Plug-in?