Show user ages in CP

[the_sisko]

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 (https://vborg.vbsupport.ru/showthread.php?postid=209952#post209952)

[the_sisko]

Screenshot:

[Streicher]

Very nice hack. I don't need the help of excel anymore. Thanks, you saved me a lot of time. :up:

[DelusionalMind]

nice :)

good job man :p

[Twig Deez]

simple but useful.

thanks!

[djr]

Just what I was looking for! Very nicely done, cool output and .csv output as the cream on top!

Thanks!

[Lesane]

Great hack, i luv it ;). Thanks

[Psychdrone]

yes two thumbs up!

[Bedhead]

Very useful and informative hack.

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

[XiXora]

whats csv neway?

[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 :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

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


add this:

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


then before:

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


add this:

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


then after:

doformheader("showage","show");


add this:

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:

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


in:

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.

[djr]

This is the attachment with all the neccesary modifications as posted above. I also fixed the year calculation to include checking for current month and day. So I'm now 30 again instead of 31 as what was originally calculated :D (man, I get old :eek: )

the_sisko: hope the database trouble is minor, take care fiddling with it!

- djr

[GrphicImprssion]

can anyone modify this to draw its imformation from a "custom field"? I made an additional field on my bb for "date of birth (admin)" that is a required field and is hidden from the public profile. The users are asked to input the information in a 10 character field in this format "mm-dd-yyyy" The "-" is not automatic, they must input it as well ( i could not find how to modify a custom fields input variables). So it would be really great to have this hack pull its info from that field!!! any ideas?

[GrphicImprssion]

no ideas? :(

[Lucky]

Originally posted by djr
This is the attachment with all the neccesary modifications as posted above. I also fixed the year calculation to include checking for current month and day. So I'm now 30 again instead of 31 as what was originally calculated :D (man, I get old :eek: )

the_sisko: hope the database trouble is minor, take care fiddling with it!

- djr

Thanks for that.


Just wondering now that you have changed the showage.php for the admin side of things if you would be able to post the showuserage.php for the user side of things.

TIA:)

[Lucky]

Anybody?

[Lucky]

UP

[djr]

Today I fixed and finished the user side of 'Show user age' and also added a (hopefully) nice bonus.
You have to install one extra template though!


Install Useroutput AddOn Version 1.1:
"Will work without the hack for the CP"

original version by - the sisko -
with modifications by djr
--------------------------------------------------------------

[modified by djr]
* fixed age calculation
* extra template: userage_nobirthday
* extra twist: if a user has not provided a birthday, he/she is
taken to the different userage_nobirthday template with a
request to update his/her profile.
--------------------------------------------------------------


screenshots in next posts.

[djr]

screenshot 1: user has set his/her birthday

[djr]

screenshot 2: user has NOT set his/her birthday

[Lucky]

I am still a year older than what I really am in the user age area.

More problems though...
I have the user age area in the memberlist section.
Where it says there are (555) members with complete birthdays, out of (missing) registed members.
(missing) members have decided not to give their birthday information.
What is up with the variables as those numbers are not popping up and are (missing)?

[djr]

Lucky,

Entirerly my fault :cry: I zipped the old version of showuserage.php instead of the fixed one. Please download the attachment again and upload the (newer) showuserage.php.

My sincere apologies! Hope you like the fixes and improvements!

- djr

[Lucky]

NP Buddy,

Right on, this works awesome.

Keep up the great work! :)

[Heineken77]

Hi :)

I installed the showage hack, however don't understand what exactly the user output addon does.

Also, seeing as I installed the showage hack, do I have to change anything or reupload the showage.php file, or just add the extra 2 templates?

Finally, where do I place the following:

Place a link to:

showuserage.php?action=show&s=$session[sessionhash]

to link to the site.

Thanks!
Heineken :)

[Boofo]

I think I might have found a small bug here. If the user only puts in the birth month and day (sans the year), it doesn't show the right template to update their profile. :)

[Boofo]

Is this hack still being supported? :)

[Ordovicium]

Thanks for this nice Hack :D

[mini2]

Thanks, quick easy and painless hack, perfect.

:)

[agiacosa]

Can anyone convert this to 3.5? PLEASE!