Show user ages in CP

SHOW AGE HACK 1.0

This small addon for your CP shows a statistic of your users age.
You're also able to download a CSV version of the statistic.

Install instruction are in the ZIP file. Thanks to Streicher for testing.

Update: Small AddOn for user output here

[MarkB]

Nice

[the_sisko]

Originally posted by Bedhead
Very useful and informative hack.

Is there any way to modify this so that everyone can see the average ages such as this?

I created a user output of the hack as well
Here is the Add On, which can be installed as a stand alone hack, only for user output.

[the_sisko]

And as well a screenshot for it

[Lesane]

Cool Thanks Again

[Bedhead]

Thanks buddy!

[the_sisko]

Originally posted by XiXora
whats csv neway?

CommaSeperatedVersion (Version not sure )

You get a file like:

15,45
16,4
21,117

And can open this file e.g. with MS Excel and work with the data. Very nice for persentation or statistics

[Freddie Bingham]

Values.

[djr]

I wrote a small 'more information' add-on for 'User ages in CP' and posting it here with approval of the_sisko.

The idea is:
Registered member information
There are 382 members with complete birthday information, out of 2,664 registered members. 2,282 members have decided to not provide their birthday details.

before

PHP Code:

// ###################### get birthdays ####################### 


add this:

PHP Code:

// ###################### get total registered members #######################
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbersmembers=$numbersmembers['users']; 


then before:

PHP Code:

// start output on site || edit this text in echo ""; if you like to 


add this:

PHP Code:

// calculate $nobirthday
$nobirthday = $numbersmembers - $usercount;
$nobirthday = number_format($nobirthday);
$numbersmembers = number_format($numbersmembers); 


then after:

PHP Code:

doformheader("showage","show"); 


add this:

PHP Code:

maketableheader("Registered member information","",0,3);
echo "<tr class='".getrowbg()."' valign='top'><td>There are $usercount members with complete birthday information, out of $numbersmembers registered members. $nobirthday members have decided to not provide their birthday details</td>\n</tr>\n";
restarttable(); 


then change:

PHP Code:

maketableheader("How old are your users ($usercount with complete birthday)","",0,3); 


in:

PHP Code:

maketableheader("How old are your users","",0,3); 


todo:
in the user version of 'user ages' put the same information, and provide users with no birthday information set with a link to their profile to do so.

Have fun and a big thank you goes out to the_sisko for making this wonderfull hack!

- djr

[Action-N]

Hi the_sisko,

Great hack went in with very little effort (once I realized the showage.php went in admin directory). But I do have a negative comment to report, the darn thing said I was 30! Now I accept that I am getting older, but I'm not that old yet, not until this November. Apparently you are only using the year to do your calculations and should definitely figure in the months at least.

[the_sisko]

@Action-N: You are right I forgot to check the month. I'll will take a look at it in the next days. Got some truble with my database at the moment so don't have much time, but after it, I'll take a look at it.