Statistics Modifications - Age And Gender Demographics

This mod will show a break down of age groups of your users based on their birth dates. It will also show genders if you have the profile field for it (multiple radio button field).

Report is shown here:

misc.php?do=demographics_report

You can define what user groups can see the report (default usergroup 6).

This product was developed for Andy R from Social Knowledge and released here for others to enjoy.

Please don't forget to:

Click Install

[Hornstar]

Thats pretty cool ^^ thanks for sharing.

What would an example of the profile filed for gender setting be?

[abrecher]

Very nice, thanks for your contribution!! It would be nice to have a link in stats in Admincp.

[Jafo232]

Originally Posted by hornstar1337

Thats pretty cool ^^ thanks for sharing.

What would an example of the profile filed for gender setting be?

Umm Gender? Male Female Undisclosed..

[PGAmerica]

This is working nicely, thank you.

Question. How do I add a link to "/forums/misc.php?do=demographics_report" to my navbar and only allow usergroups that have access in the ACP to see the link?

[Jafo232]

I think you need to search the is_memberof template function..

[PGAmerica]

I just want to add a link to my navbar and have it appear only to those usergroups that I have selected in the "SK Demographics" settings.

Also, it would be nice if the demographics it reports also have links that allow me to list the users that fall into each demographic.

[Doctor Death]

Got this series of error messages after I turned on the gender field....

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT count(*) as count FROM vywhxxxh_userfield where fieldGender = 'Male';

MySQL Error : Unknown column 'fieldGender' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 28th 2008 @ 07:50:34 PM
Error Date : Thursday, August 28th 2008 @ 07:50:34 PM
Script : http://www.xxxxx.com/forums/misc.php...raphics_report
Referrer : http://www.xxxxx.com/forums/
IP Address : 70.111.71.189
Username : xxxxxxxx
Classname : vb_database

MySQL Version : 4.1.22-standard

[steven s]

Originally Posted by Jafo232

How do you know you only have one member over 70 would be my first question..

I looked at all the records of user.birthday.

[ThorstenA]

Suggestions:
- try implementing it without additional files
- use build-in statistic functions to show graphs like on admincp>post statistics.

[Doctor Death]

Originally Posted by Doctor Death

Got this series of error messages after I turned on the gender field....


MySQL Version : 4.1.22-standard

Any idea on how to solve this?