Userlist showing
only friends/connection
only with accepted:
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` = u.`id` AND conn.`referenceid` = '[user_id]' AND conn.`accepted` AND `pending` = 0 ) != 1 ) = 0
with un-accepted:
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` = u.`id` AND conn.`referenceid` = '[user_id]' AND conn.`accepted` = 1 ) >= 1 )
Only users i Pending approval from
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` = u.`id` AND conn.`referenceid` = '[user_id]' AND conn.`accepted` AND `pending` != 0 ) != 1 ) = 0
users that want to be my friends / user i need to approv
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`referenceid` = u.`id` AND conn.`memberid` = '[user_id]' AND conn.`accepted` AND `pending` != 0 ) != 1 ) = 0
Only users i Pending approval from with a avatar
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` = u.`id` AND conn.`referenceid` = '[user_id]' AND conn.`accepted` AND `pending` AND `avatar` != 0 ) != 1 ) = 0
it works, like that
and a big thank to krileon for help me to learn
