( ( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` AND conn.`pending` = u.`id` AND conn.`referenceid` = '[user_id]' AND conn.`accepted` = 1 ) = 0 ) >= 1 )
( ( SELECT COUNT(*) FROM `#__comprofiler_members` AS conn WHERE conn.`memberid` = u.`id` AND conn.`referenceid` AND `pending` = '[user_id]' = 1 AND conn.`accepted`AND `pending` != 0 ) = 1 )
( ( 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
Last edit: 8 years 2 weeks ago by smFruen. Reason: more code