Hello Eric,

EasySocial stores all user's profile data under the table #__social_fields_data but I am not sure if this is what you really want to get? Perhaps if you could elaborate on what you are trying to achieve here?

Hello,
I would like to display the Gender and the City in the stream when the flus displays "xxx is friend with yyy"
Best regard.
Eric

Instead of querying the database table directly, you should use the API that we provide in the user object. Here is an example,

[gist]
// $userId needs to be the id of the user
$user = ES::user($userId);

// The FIELD_CODE can be obtained / generated from http://take.ms/jo2yq
echo $user->getFieldData('FIELD_CODE');

[/gist]

Hello thank you very much.

The field code is "Gender" for gender?
For example:

Echo $ user-> getFieldData ('GENDER');

Best regards.
Eric

The field code is based on what was set in the custom fields settings, see http://take.ms/jo2yq

Thank You

No problem