Calculate Member Average Age?

[rex_b]

I think this would be a fun hack for a simple stat.

Anybody know how?

[AN-net]

well first you would have to query the database for all users with a birthday. then convert the xx/xx/xxxx to a unix timestamp then divide that by the number of seconds in a year and then add the year to variable. once all the ages are added to a variable then divide the variable by the number of users found having a birthday;)

[rex_b]

Oh geeeese. How about someone just convert this hack:
https://vborg.vbsupport.ru/showthread.php?t=33610&page=1&pp=15&highlight=User+Ages

It's only 1 file :)

[Andreas]

SELECT AVG( YEAR( CURDATE( ) ) - YEAR( birthday_search ) ) - ( RIGHT( CURDATE( ) , 5 ) < RIGHT( birthday_search, 5 ) ) AS avgage
FROM user WHERE birthday_search NOT LIKE '0000-%'

[TCattitude]

Oh geeeese. How about someone just convert this hack:
https://vborg.vbsupport.ru/showthread.php?t=33610&page=1&pp=15&highlight=User+Ages

It's only 1 file :)
WOW
That would be great!

Can anyone do it? :S

[Marco van Herwaarden]

WOW
That would be great!

Can anyone do it? :S
Lol,

Read Kirby's post above yours, he already did it more then 10 days ago!

[sabret00the]

w00t mines 22 lol

[tpearl5]

ah cool... 25 for me.

[agiacosa]

I don't think Andreas converted the mod. He just gave the query to get the average age. Anyone willing to convert the mod?

[IvyKeepMommy]

Mine's 32.0978 :)

[Boofo]

Mine is 35. something.

[benstillman]

35.7600