Userlist, only show users who are online.

You can condition against the registerDate column in the _users table for that. You'll need to use the "u" table prefix (e.g. u.`registerDate`). See MYSQL documentation below regarding date functions.

dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

How long they are considered new is entirely up to you. Example as follows compares registerDate to todays date minus 1 month.


That basically means "Has the user registered within 1 month from today? If so lets display them otherwise they are not new.".

I did it this way:

( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`registerDate` >= DATE_SUB( NOW(), INTERVAL 1 MONTH ) > 0 AND ue.`cb_gender` = '[cb:if cb_gender="m"]f[cb:else]m[/cb:else][/cb:if]'

Unfortunately does not work What must I change?

Don't replace the user id check. You are just needing to add another AND statement to the query. See my below reply where I've added an AND statement. You'd add another for the registerDate check.

www.joomlapolis.com/forum/149-usage/241665-userlist-only-show-users-who-are-online?start=6#314748

Recommend the below resources to get you started on how to write SQL. We do not provide coding assistance here so I can not keep assisting you further with writing SQL.

Documentation
dev.mysql.com/doc/refman/5.7/en/entering-queries.html
dev.mysql.com/doc/refman/5.7/en/examples.html
dev.mysql.com/doc/refman/5.7/en/functions.html

Free Lessons
www.codecademy.com/learn/learn-sql
www.khanacademy.org/computing/computer-programming/sql
sqlbolt.com/
www.udemy.com/topic/sql/free/