Hi,
is it possible to display only friends or only online users in user list/map module ?
-
abhinav.cyber
- Support
- Saturday, December 05 2015, 06:16 AM
Hi,
sorry for late reply, it's a weekend for us
Yes this is possible with "SQL Custom Where" parameter (this parameter is available in Users List module,User List menu item,Users Table menu Item and Users Map module) and our Content Plugin.
To see online users you can put in "SQL Custom Where" parameter this code:
To see friends you can put in "SQL Custom Where" parameter this code:
{user id raw} will be replaced by ID of current logged in user, docs about Content Plugin at http://docs.easy-profile.com/index.php/article/content-plugin.
Docs about SQL Custom Where with some example (also online users list) at http://docs.easy-profile.com/article/sql-custom-where
sorry for late reply, it's a weekend for us
Yes this is possible with "SQL Custom Where" parameter (this parameter is available in Users List module,User List menu item,Users Table menu Item and Users Map module) and our Content Plugin.
To see online users you can put in "SQL Custom Where" parameter this code:
user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0)To see friends you can put in "SQL Custom Where" parameter this code:
user_id IN (SELECT DISTINCT friend_id FROM #__jsnsocial_friends WHERE user_id={user id raw}){user id raw} will be replaced by ID of current logged in user, docs about Content Plugin at http://docs.easy-profile.com/index.php/article/content-plugin.
Docs about SQL Custom Where with some example (also online users list) at http://docs.easy-profile.com/article/sql-custom-where