[SOLVED] userlist show only friends

make a userlist thaht show only friends/connection

hey i have try myself but cant, get it to work, so only if it is Quick and Easy for you:)

can you make a
Advanced filter, to a user list.

Thaht only show the viewing users friends/connection

Yes, but you need to add an Advanced Filter to query the _comprofiler_members table to ensure the user being displayed is connected. When querying for information keep in mind the table alias for CB is "ue" and the table alias for Joomlas table is "u". So ue.`firstname` for example is the firstname column of _comprofiler while u.`username` is the username column of _users. However for this usage your only relevant usages should be user id and suggest using u.`id`, ue.`id`, or ue.`user_id`.

like this

SELECT `accepted` FROM `#__comprofiler_members` WHERE '[cb:userdata field="user_id" user="#me" /]'

:dry:

That's the right table, but your where isn't comparing to anything and it also needs to take into account the users row. Example as follows.


The advanced filters directly at to the where clause of a query so it needs to be a condition.

sorry it dont work

Updated my reply, try that.