[SOLVED] Automatically upgrade GroupJive members on joining a group based on usergroup

Hi

I would like to know if it is possible to automatically upgrade a user who is in a particular Joomla usergroup, to Moderator status when they join any GroupJive group.

I am using the Moderator status to distinguish types of user from other group members, and currently Admin has to promote users manually.

I can see that some actions are possible using Auto Actions and combining gj_onAfterJoinGroup and gj_onAfterUpdateUser, so I'm hoping this one is also possible?

Thanks

Yes, that's possible. You will have to use a Query to do that though since the GroupJive action has no usecase for changing status (have added a feature ticket to implement this). You'd create a Query action acting on gj_onAfterJoinGroup as follows.

Global
Triggers: gj_onAfterJoinGroup
Type: Query
User: Automatic
Access: select your usergroup here that you want this to apply to
Action
Query:

Hi
pretty sure I've set this up correctly, but I'm getting this error message;

An 1146 error occured during your request.

The Join request goes ahead, the user is added to a group but not promoted to Moderator.

Thanks

Your database table prefix probably isn't jos_. I've edited the sample code replacing jos_ with #_ to work with any table. Please retry.

Brilliant, that works, thank you.

I did notice the "jos"prefix in there in fact, when I got an error, and tried changing it to my database prefix, but still got the error message. I'm going to check I got the prefix right, as it should work, shouldn't it?

Thank you as well for adding this as a feature ticket.