That's because you're using single quotes. You need to use ` not ' for columns and table escaping. Single quote is for value escaping. Please read up on MYSQL documentation and SQL tutorials found below carefully to become more familiar with SQL.
2 - where can i find the list and uses of table of CB (for exemple #_session, #cbsubs_subscriptions' ....
Browse your database using phpmyadmin or whatever database software you host provides.
3 - I would like to filter a list of users online with the same 'gender' that the user connected' like :
You would need to have something like the below.
Online:
Code:
( ( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` ) > 0 ) AND ( `cb_gender` = '[cb_gender]' )
Offline:
Code:
( ( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` ) = 0 ) AND ( `cb_gender` = '[cb_gender]' )
The substitution will substitute in the viewing users gender. This will likely return no results if you're viewing as a public user since they won't have a gender field value so I recommend making the userlist accessible to registered users only.
Please see the below tutorial for further substitution usage information.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
But in the list, how to show users online in first and then offline ones Following?
Or sort by last date first visit?
It must also write a manual request?
This topic is regards to an Advanced Filter. Sorting is a completely different query and usage. I'm guessing you're sorting by Last Online field, which is just a datetime; it's not an indication of them actively being logged in. To sort by online status you need to use an Advanced Sort By which adds directly to the ORDER BY of the query. The below Advanced Sort By will probably work.
Online First
Code:
( SELECT s.`time` FROM `#__session` AS s WHERE s.`userid` = u.`id` LIMIT 1 ) DESC
Offline First
Code:
( SELECT s.`time` FROM `#__session` AS s WHERE s.`userid` = u.`id` LIMIT 1 ) ASC
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
