[SOLVED] fan instead of connections

krileon wrote: There's no way to know if two users are connected or not without using CB Query Field to query the database.

ok i create a mysql field with
SELECT memberid,referenceid FROM #__comprofiler_members WHERE referenceid = {USERID} AND memberid={VIEWERID}

but the condition? should i create 2 extra field for the buttons (one with "like", one with "not like")?
there is an easier and more clean way?

You have no quotes in the query and those are not valid substitutions. An example of a valid query is as follows.


To grab the user id of the viewing user you'll also need to use the following substitution.

[cb:userfield field="user_id" user="#me" /]

Please see the below tutorial for further substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

krileon wrote: You have no quotes in the query and those are not valid substitutions. An example of a valid query is as follows.

Code:

SELECT `email` FROM `#__users` WHERE `id` = '[user_id]'

To grab the user id of the viewing user you'll also need to use the following substitution.

[cb:userfield field="user_id" user="#me" /]

Please see the below tutorial for further substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

ok but after this substitution what should i do? should i make 2 field delimiter with the 2 buttons and hiding one of them with CB substitution (testing if mysql field is empty)? this is your idea?


another little thing: could you tell me how to edit DenyConnection function for my case? i tried to switch userid and connectionid, but in this case doesnt work..

i solved in other way, thanks anyway