[SOLVED] Fetch connections list of user

Hi all, I apologize if I'm posting in the wrong section.

I'm wanting to know if it's possible to fetch a list of connections for a specific user via SQL? I'm looking through the list of cb tables, but I think I may be missing something.

If anybody knows how to do this, or at least where I should be looking, I would greatly appreciate some advice.

Thanks.

Yes, connections are stored in _comprofiler_members. What are you needing this for exactly as there could be another less complicated solution to do what you're wanting.

We have a client that is using Icagenda for their events, and is wanting the users to be able to select an event and then invite users that they are connected with via pm's.

I did find information regarding the API last night, however admittedly I didn't go to far into it.

edit: After testing, from the above database I can now get the connections for each user that have been accepted. I would like to ask a follow up question on how to go about sending a pm to a userID, however if I should create a new thread please do let me know.

Depends on if you want to use CB API to send the PM or just directly integrate with UddeIM. For CB API usages you need to first load in CB API as documented below.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18357-including-cb-api-for-usage-outside-of-cb

Once done you can use the below notifications API to send a PM.


The above sends a PM from the system. The below sends a PM from a user.

Thank you so much! That is working absolutely perfectly!

Edit: Topic can be closed still, however how should one go about creating in the message? I tried using shortcodes as well as <a> tags but neither seemed to work.

Edit: Topic can be closed still, however how should one go about creating in the message? I tried using shortcodes as well as <a> tags but neither seemed to work.

Just use normal HTML links then within UddeIM configuration ensure you've full bbcode enabled.