I've set up quite a few additional user groups in Joomla 1.5 using NoixACL.

What I would like to do is assign members to a specific group when their CB plan expires. This is mainly so we can target them with specifc newletters, reminders etc.(we are a society with 1000's of members, hoping to manage our memberships with CBsubs)

Example:
*******
Active Group: Associate Member 1 Year Membership Active
Expired Group: Associate Member 1 Year Membership Expired

Is this possible?

I've been through the manual and have tried to search the forum and have found very little about it....so sorry if it's documented somewhere.

Thanks for any input

Bo

Post edited by: BoSchafers, at: 2009/08/12 16:38

Thanks for your fast reply. Also, it's fantastic that CBsubs has the capability to do what I was looking to do.

BUT! I wish I had a bit more of an understanding of the workings of Joomla and mysql....

Some clarification, please:

__users
__core_acl_groups_aro_map

These are the names of the actual database tables? In my case jos_users and jos_core_acl_groups_aro_map. Yes?

SET `usertype` = 'Registered'
`gid` = '18' WHERE `id` = [user_id];

So this is the user type/group and id that I'd like to change it to such as "Associate Member 1 Year Membership Expired". It is NOT not the value of current group? Yes? Ok. I think I got it thus far. So the update statement changes the values for that the user in the user's table.

Now to the second statement ...

SET `group_id` = '18'

I just put in the same value in group_id as for 'gid' above i.e. 18? Yes?

Sorry for being long-winded and perhaps a bit daft, but I'd just like to be sure and hopefully this will be of use to other newbies down the track.

TIA,
Bo

Ok I finally managed to test this and it works. Almost

The sql statements *are* actually putting the user into the 'Lapsed' Group at expiration. However in the 'User Management' listing the 'Group' column is displaying the old group title (not the new one).

Currently these are my sql statements I have entered in the plugin. Are these right?

[code:1]
SQL Action 1 Field:
******************

UPDATE `#__users` SET `usertype` = 'Lapsed', `gid` = '59' WHERE `id` = [user_id];

SQL Action 2 Field:
*******************

UPDATE `#__core_acl_groups_aro_map` SET `group_id` = '59' WHERE `aro_id` = [user_id];
[/code:1]