[SOLVED] cbMenuItem to Field

it give a 1 on the profil

and none on the profil thaht i am not in conetionen whit

but what now

You can condition it with a substitution IF usage now. Example as follows.

[cb:if cb_myfield="1"]I am connected to this user![/cb:if]
[cb:if cb_myfield!="1"]I am NOT connected to this user![/cb:if]

See the below for further substitution usage information.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

yes but thaht not giv me a link

database query

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

this work for me to remove a connection, but i dont give me nothing, when there is no connection.

I have try an try many options

can you please make me one thaht SELECT them I'm not friends with

the only thing working is when there is a connection.



then i put a link til remove connection


but so i need a Query just like pic 1 but one that shows only those I'm not connected with.

so i can put a link thaht say add connection

The query outputs a 1 if the displayed user is connected to the viewing user. If you want to check if the viewing user is connected to the displayed user you just reverse the referenceid and memberid as follows. The URL to add or remove a connection I've already provided you, but you need to add the HTML to utilize them.


You're trying to do a query select. That's not correct. You need just a regular Query field. You then condition the query fields value either in the query fields layout parameters or in a separate Custom HTML field as shown below.

www.joomlapolis.com/forum/153-professional-member-support/234912-cbmenuitem-to-field?start=6#286576