Agora Groups

Hi again
I am using CBsubs to provide paid access to material on a website I'm building. One part of that is the Agora forum for users of specific groups. However at the moment I have to assign new subscribers manually to the specific Agora Group.

CBsubs offers a method of executing SQL commands when a new user registers. I believe that this could be used to autoassign new users to an Agora Group automatically, based on the subscription which they have acquired. Similarly, they can be unsubscribed when their subscription has run out.

My problem is that I am not a developer and have no idea how to write such a script to add to the CBsubs SQL plugin.

I suggest examining your database to see how Agoras tables are structured then build a query based off this. Please review various other threads pertaining to SQL Actions usage for examples on how to build queries. I've never used Agora so have no further advise unfortunately.

Kyle (Krileon)Community Builder Team MemberBefore posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forumsCB links:
Documentation
-
Templates
-
CBSubs
-
Hosting
-
Forge
-
Incubator
-
GroupJive
--If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
--Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

With Kyle's assistance I am proposing the following SQL script to add a user to an Agora group:

Code to add user to agora group with group_id=GID (GID should be an integer number - check table jos_agora_groups for your specific agora group) with role_id=RID (RID should be an integer number - check jos_agora_roles for your specific role - usually role_id of 2 is used for member)