vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Statistics Modifications - Age And Gender Demographics (https://vborg.vbsupport.ru/showthread.php?t=189175)

Jafo232 08-25-2008 10:00 PM

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:


Jafo232 08-26-2008 01:40 PM

Reserved....

BTLSDREDD 08-26-2008 02:10 PM

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 08-26-2008 02:15 PM

3.6x?

steven s 08-26-2008 02:26 PM

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

SVTCobraLTD 08-26-2008 02:58 PM

Installed on 3.6.10pl3

View report at http://www.yoursitename.com/forums/m...raphics_report

Jafo232 08-26-2008 04:03 PM

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

Jafo232 08-26-2008 04:06 PM

Quote:

Originally Posted by 1996 328ti (Post 1607408)
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 08-26-2008 04:20 PM

Nice idea, thanks.

Jafo232 08-26-2008 04:28 PM

Quote:

Originally Posted by AndyA (Post 1607487)
Nice idea, thanks.

Your welcome, now CLICK INSTALL.. hehe..

TilkiBey 08-26-2008 04:34 PM

INSTALLED
nice idea;)

Turbo&Auto 08-26-2008 04:47 PM

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 08-26-2008 05:21 PM

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

FleaBag 08-26-2008 09:26 PM

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

Thanks!

steven s 08-26-2008 11:56 PM

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

THANKS!

steven s 08-27-2008 01:26 AM

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 08-27-2008 01:44 AM

Quote:

Originally Posted by 1996 328ti (Post 1607772)
Very cool!
Now you know what would be cooler?
A bar graph. :)

THANKS!

How about a pie chart?

Jafo232 08-27-2008 01:46 AM

Quote:

Originally Posted by 1996 328ti (Post 1607828)
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 08-27-2008 09:50 AM

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

choccyclaire 08-27-2008 11:01 AM

Nice little feature.

Hornstar 08-28-2008 04:21 AM

Thats pretty cool ^^ thanks for sharing.

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

abrecher 08-28-2008 05:24 AM

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

Jafo232 08-28-2008 05:31 AM

Quote:

Originally Posted by hornstar1337 (Post 1608734)
Thats pretty cool ^^ thanks for sharing.

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

Umm Gender? Male Female Undisclosed..

PGAmerica 08-28-2008 03:35 PM

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 08-28-2008 03:59 PM

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

PGAmerica 08-28-2008 04:31 PM

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 08-28-2008 10:52 PM

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

Quote:

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 08-29-2008 12:37 AM

Quote:

Originally Posted by Jafo232 (Post 1607840)
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 08-30-2008 11:29 AM

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

Doctor Death 08-30-2008 12:55 PM

Quote:

Originally Posted by Doctor Death (Post 1609437)
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 08-30-2008 01:27 PM

Quote:

Originally Posted by Doctor Death (Post 1610576)
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 08-31-2008 10:13 AM

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

ThorstenA 08-31-2008 10:14 AM

Quote:

Originally Posted by Magnumutz (Post 1611079)
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
Quote:

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

Jafo232 09-02-2008 04:45 PM

Quote:

Originally Posted by ThorstenA (Post 1610592)
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 09-02-2008 06:20 PM

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 09-02-2008 06:32 PM

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 09-07-2008 10:33 AM

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

Jafo232 09-08-2008 11:48 AM

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

Goomzee 09-12-2008 07:50 AM

how do i set gendar setting

http://www.mknexusonline.com/forums/...raphics_report

Doctor Death 09-12-2008 09:23 AM

Quote:

Originally Posted by Jafo232 (Post 1612925)
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!


All times are GMT. The time now is 05:50 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01410 seconds
  • Memory Usage 1,791KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete