The connections between users are entirely stored in _comprofiler_members and is what you'd be querying.

In _comprofiler_members the referenceid column is the user id of the user who made the connection request and memberid is the user id receiving the request. So if someone has sent you a connection request their user id would be in referenceid and yours in memberid. The accepted and pending columns are basically self explanatory.

but can somebody tell me the exact code i have to add there if i buy it?

We do not provide custom coding assistance. We only provide simple examples. I don't recommend this approach if you're not familiar with SQL or recommend hiring someone to write the SQL for you.

Please understand we do not provide custom coding assistance. Basically no extension ever will. That's entirely outside the scope of support and you should not expect it even if you subscribe. We provide simple examples and that is all. If there's any confusion regarding this see the below page.

www.joomlapolis.com/help-us-help-you

If you need complex customization's like custom queries, PHP code, etc.. I highly suggest hiring someone to develop that for you. We do not offer services to do this either (we're a small team of 3, we don't have the time; sorry). With that said the below example should probably work.


Replace #__ with your database table prefix and '[user_id]' with your actual user id then try it in phpmyadmin to see if it gives you the results you expect. Example as follows.

Thanks Kyle for always going above and beyond to help out.

@Mx150 - Please understand that Community Builder is free to you and to millions but someone is responsible for this.

All our paid members help make this possible showing their appreciation for what Community Builder is and getting some great add-ons in return.

Kyle is corect in not promising development efforts to attract a single sale - it would not be fair to mislead you.

That said - Kyle's proposal seems fine as a starter and you can hire someone that can further finetune this if needed.