Age And Gender Demographics

[Jafo232]

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 (https://vborg.vbsupport.ru/member.php?u=7590) from Social Knowledge (http://www.socialknowledge.net/) and released here for others to enjoy.

Please don't forget to:

Click Install (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=189175)

[Jafo232]

Reserved....

[BTLSDREDD]

I've installed the product, but how do I go about viewing the report?

I hope I installed correctly.

Uploaded the demographics.php to the root directory.
installed the plugin XML file with the plugin manager.

Everything seems fine, but I can't find the report. help?

[iogames]

3.6x?

[steven s]

I've been waiting for this for sometime. :)
I'm guessing that the chart is updated in realtime?

[SVTCobraLTD]

Installed on 3.6.10pl3

View report at http://www.yoursitename.com/forums/misc.php?do=demographics_report

[Jafo232]

The first post in this thread tells you where or am I missing something?

[Jafo232]

I've been waiting for this for sometime. :)
I'm guessing that the chart is updated in realtime?

Yes, it does the query in real time. I would imagine you might want to control access to this. For our purposes, this was only for generating reports for advertising and is therefore closed to the public.

[AndyA]

Nice idea, thanks.

[Jafo232]

Nice idea, thanks.

Your welcome, now CLICK INSTALL.. hehe..

[TilkiBey]

INSTALLED
nice idea;)

[Turbo&Auto]

For the profile field I used a single selection Radio button field with Male or Female as the selections. This wasnt in the instructions and the male/female portion wont work without it :)

[Jafo232]

Thought it was rather self explanatory in the options page, but oh well..

[FleaBag]

A nice page to show potential advertisers, or for those just plain curious! :)

Thanks!

[steven s]

Very cool!
Now you know what would be cooler?
A bar graph. :)

THANKS!

[steven s]

I have one member over 70 although the stats are as follows.
Are 0000-00-00 birthdates messing with the data?

Under 20 7.27%
20 - 29 47.27%
30 - 39 14.74%
40 - 49 7.20%
50 - 59 3.94%
60 - 69 1.31%
Over 70 18.27%

[Jafo232]

Very cool!
Now you know what would be cooler?
A bar graph. :)

THANKS!

How about a pie chart?

[Jafo232]

I have one member over 70 although the stats are as follows.
Are 0000-00-00 birthdates messing with the data?


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

[aryshi]

nice :)
if there is include other filds like country will be great

[choccyclaire]

Nice little feature.

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

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?do=demographics_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]

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]

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?

[ThorstenA]

Any idea on how to solve this?
This product tries to get a custom table. As there is no custom table, an error occurs.

Most likely there is a problem with installation procedure of your product. When installing a product, custom tables are inserted.

[Magnumutz]

How does it know who is a Male and who's a Female?
I mean, vB doesn't have defaults for that.

[ThorstenA]

How does it know who is a Male and who's a Female?
I mean, vB doesn't have defaults for that.

From product description
It will also show genders if you have the profile field for it (multiple radio button field)

[Jafo232]

This product tries to get a custom table. As there is no custom table, an error occurs.

Most likely there is a problem with installation procedure of your product. When installing a product, custom tables are inserted.

No this is not correct..

The user did not define the settings properly in the admincp.

[Karri]

This is probably a REALLY dumb question. For the gender inputs it says "Male first, Female second, and a third answer third." For my radio buttons I have it alphabetically so it is Female, Male, Other. So do I list it in the order I defined it in my profile field or put male first as the instructions say?

[Jafo232]

No, you do as the instructions say. You just need to use the same words as you did when you made the profile fields (i.e. Male, Female, Zygote, etc..)..

[chris1979]

Any way to make it work if we have a drop down box instead of a radio button for the gender field?

[Jafo232]

It should work the same way for a drop down as it would for a radio button.

[Goomzee]

how do i set gendar setting

http://www.mknexusonline.com/forums/misc.php?do=demographics_report

[Doctor Death]

No this is not correct..

The user did not define the settings properly in the admincp.

What settings would that be? There are not a lot of them!

[BigDog56]

Works great! thank you!

[360themes]

i need to know from 10 - 16 ... can u edit your code? or help me to edit step by step?

[Hannan]

Thanks for your nice hack!!

[Emmmmrz]

i need to know from 10 - 16 ... can u edit your code? or help me to edit step by step?I also would like a younger age group shown; my forum is very much based on teen usage. 10-14;15-16; 17-19 would be ideal age groups; considering it goes all the way up to 70; but the majority of net addicts are the younger age set.

[shlomot]

Already voted and marked installed long time ago.

Just wanted to mention that it works great on vB 3.8 RC1

[Emmmmrz]

i need to know from 10 - 16 ... can u edit your code? or help me to edit step by step?I also would like a younger age group shown; my forum is very much based on teen usage.
10-13
14-16
17-19
20-30
31-40
41-69
70+
would be ideal age groups; considering it goes all the way up to 70; but the majority of net addicts are the younger age set.Umm... Never heard anything, is this even possible?Or set it so you can change the age options per forum, so Admins can set it to their own needs.

Maybe add an option for Location(country) of users? Different interests, Other profile options as well?

[Twisted Chaos]

I can do this for you. Let me know via a PM or email.

[z0diac]

Installed then uninstalled. No way to have it not show gender (since my site doesn't ask for it, it's not needed). No way to view the stats exept entering the URL manually. A good mod for some though (who know how to edit their QuickLinks or Navbar to add a link to the output)

[almqdad]

it works fine except for gender feild I am getting this

Gender Settings Are Not Defined

what i am suppost to do

please advice

[Keesa]

it works fine except for gender feild I am getting this



what i am suppost to do

please advice

You have to have done it as a radio button, single selection.

enter the field # of your gender, for example 14 (if gender is field14 when you added it as a profile field into vBulletin)

Then, in Gender Inputs, you put Male or Female

Hope that helps!

[Keesa]

Installed then uninstalled. No way to have it not show gender (since my site doesn't ask for it, it's not needed). No way to view the stats exept entering the URL manually. A good mod for some though (who know how to edit their QuickLinks or Navbar to add a link to the output)

I wonder why you would need to edit your quick links or NavBar? Just curious because this is a report we would not allow all users to see and so therefore, we can just ask our staff management to bookmark it.

It's really quite a wonderful mod.

[NTMID8]

Hello... thanks for the great product! I have it installed and working well.

I would actually like to collect information on a couple other demographics and have those reported as well. I've no issue creating the profile fields, but wondered if you could tell me what template or code edits I would need to make to add additional reporting?

Thanks!

[Keesa]

I too would love this with more data for 20 and under.

13-15, 16-19

[VonDoom]

Installed. Thanks for this I can see some intresting data coming out of this.

[Flood]

Where exactly am i putting the upload. I'm confused? I installed it in the public_html with no luck

[StarBuG]

Any chance that this mod will be available for vB4?