How can i find age and gender on my server?
I want to know the location please.
Thanks,
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
How to find age and gender [Solved] | Forum
Donamix
Mar 4 '14
What are you trying to do Donamix? Do you wish to change words to something else?
Not really, i want to get user information for my mobile app :)
John
Mar 4 '14
I'm sorry about that. ow_base_question is just for the question layout.
You have to go to ow_user and find the ID of the person you're interested in. (Say ID is 2).
Then you go to ow_question_data and look through the userid column until you find that user id.
Then look for sex (1 male, 0 female) and birth date.
Why in the blazes you would want to go to all that trouble defies explanation. Especially when you can use your site to find the information immediately.
You have to go to ow_user and find the ID of the person you're interested in. (Say ID is 2).
Then you go to ow_question_data and look through the userid column until you find that user id.
Then look for sex (1 male, 0 female) and birth date.
Why in the blazes you would want to go to all that trouble defies explanation. Especially when you can use your site to find the information immediately.
Donamix
Mar 4 '14
As i said, i want to get user information
For profiles of logged in users in the chat of my mobile app
Anyway, where is ow_question_data?
John
Mar 4 '14
That is not the way to do it. Your database is not there for that reason. You only need to hit one wrong key and you could bring your site down. I'm sorry to say it, but the mere fact you are asking these questions proves beyond doubt that you do NOT have the skill necessary to be fooling around with a relational database. Please take my advice and leave well alone!
Donamix
Mar 4 '14
Grrrr, i don't need your advice, you probably wasted my time.
Who are you to tell me leave? i have an app for my site on google play
I have implemented stuff on my app more complicated than this
I'm pretty sure i can do it, you just didn't get my question.you type too much and make no sense!
im on the last line of the projectI'll just wait an answer from oxwall team,Thanks for your time ;)
Shane
Mar 4 '14
Hi
Im by no means an expert here but I think you might be looking for the table ow_base_question_data
You might want to run a select statement similar to
SELECT userID,questionName,textValue,dateValue FROM ow_base_question_data WHERE questionName="birthdate"OR questionName="sex";
Im sure others want improve on this.... its not pretty
John
Mar 4 '14
I spent a lot of time helping you and returning my effort with abuse could see you thrown off this forum. It's pretty obvious you're way out of your depth because you don't even know your way around the database you wish to play with. So I left the word "base" off the table name. Big deal. Surely you know how to do a search in MysqlAdmin.? it's basic stuff. I never bothered telling you how to do a select statement because you don't know how to spell and your chances of getting it right would be zilch!
Team ross
Mar 4 '14
Shane, John +1
ow_base_question_data
Guys, please, this talk won't do any good to anyone. If I see you continue railing against each other, I will lock this post.
Donamix
Mar 5 '14
Look at this pic, under Basic info
This is a plug in? No it is not,
So, This info must be in my database.
Team
Donamix
Mar 5 '14
the sex and age info are in the ow_base_question_data table.
It's not correct, I am investigating source code, i will find out
Team ross
Mar 5 '14
Donamix, the user data is actually stored in the above mentioned table.
If you are talking about the method which takes those values from the database, you can look at user lists example. There is age and sex is indicated under user thumbnails.
So you can take a look here: ow_systems_plugins/base/controllers/user_list.php
public function getFields( $userIdList )
If it is not what you're looking for, please provide more details what you're doing and how to you want to achieve this.
