Userlist, only show users who are online.

Hi,
what do I have to set to display in a user list only users who are online?

Thx, Thomas

ok, this is fine:
( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` AND s.`guest` = 0 ) > 0

but it indicates men and women. I need it separately.
If a man is logged in, it should only show women who are online. If a woman is logged in, she only sees men who are online now.

I need help. How can I sort it out that only women or only men are displayed online?
Thomas

The Advanced filtering directly adds to the WHERE clause of the userlist query. Your first usage will work fine to filter to online users. If you also want to filter by a field you need to add an AND clause to your usage and add the field filtering there. Example as follows.

( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` AND s.`guest` = 0 ) > 0 AND ue.`FIELD_NAME` = 'FIELD_VALUE'

Thanks for the hint, but it does not work out. I use a cb_gender field that the users have to fill in as mandatory. Unfortunately I am not so good with database queries. I have now inserted cb_gender in her example. What should be included in FIELD_VALUE?

( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` AND s.`guest` = 0 ) > 0 AND ue.`cb_gender` = 'FIELD_VALUE'

Thanks for possible solutions

You should use a checkbox or dropdown field and then use the value that you've inserted in the value field.