Just some background...

Our organization is membership based and we have one user group defined for all our members. When someone purchases a membership, the membership user group is assigned to them (which then controls access to various resources on the website). So, when a new user (not a member yet) creates an account on our website they are assigned the "Registered" user group level. If they join our organization CBSubs will assign them the "NSRCA Membership" user group level... everything is great up to this point. If that membership expires, all the necessary changes are made to their user record, however the one change that is not made is to remove them from the "NSRCA Membership" user group. See the user groups below...




Is there a way to have CBSubs remove them from this user group, or do I need to write some SQL code to remove them using the SQL Action integration plugin? Under the "Access" tab for the plan, there is an entry to add the user to the user group. Shouldn't CBSubs automatically remove that user from the group when the plan expires?


One other question or feature request:

It would be nice to have the ability to purchase a membership for someone else. For instance, if I have 2 people in my family (my son and I) that belong to the organization, it would be nice to be able to purchase (or renew) my membership and my son's membership at the same time instead of having to log on as me first, do a purchase, and then log on as him and do a purchase. Obviously, both users would need to be users on the website in order for this to happen.

Is this possible in CBSubs? If not, can this be added?

Thanks.

Thanks. I had my grace period set at 3 months after expiration so perhaps that is why the access wasn't removed. I did create a test plan today which had a duration of 5 minutes with no grace period - I'll check to see if the user group is removed. I did write the following SQL code to delete the user group from the user though which works well:

DELETE * from `#_user_usergroup_map` WHERE `user_id` = '[user_id] AND `group_id` = (SELECT `id` FROM `#_usergroups` WHERE `title` = 'NSRCA Members');

I also will need to do something similar except that I need to add another user group to a new member (in addition to the one that the plan assigns) and obviously delete it when it expires as well. Is this possible with CBSubs? When a plan is purchased to automatically assign them to another plan at the same time?

Thanks for the consideration of adding that feature to a future release. I would imagine that would be very useful to memberships/subscription systems. Our previous membership management system used it.

I have a similar problem now.

I see that a user account has expired, but it's still assigned to 2 groups: Registered and Partners.

When he registered, was assigned to Registered and Partners group.

I would expect it would be assigned only to Registered group after expired and grace period is "None".

Why it's still assigned to "Partner" user group?

Also, how can I move it to the group "Partner Expired" after exprired? An auto Action?