Auto-approve selected registrations

Thank you for your patience.

I couldn't work out what you meant by 'the below' so do you mean I can put this query

UPDATE `#__comprofiler` SET `approved`= '1' WHERE `user_id` = '[user_id]'; UPDATE `#__users` SET `block`= '0' WHERE `id`= '[user_id]'

into the Activation box of SQL Query 1 for the Plan and it will result in registrations that are paid online being approved automatically?

Would it also follow that when a Pending Payment is Completed (using the Basket's Pay button) the update would run on that subscription?

We don't need the update to do anything else. The normal 'on activation' email is all that goes out when the payment is completed (in fact this is what brought the problem to light as new users who paid online were getting login credentials but couldn't log in because they hadn't been Approved).

Nothing depends on the approval triggers or the welcome email.

Thank you for considering the option of a new type of CB Auto Action as well.

www.joomlapolis.com/support/tutorials/107-use-cases/18219-cb-auto-actions-changing-approval-workflow-based-on-cb-field-value

Does this tutorial help?

Thanks Nant. It was this tutorial that helped me determine the SQL update that I need.

Basically, we want to approve a registration/subscription at the point where it is activated as a result of payment being completed. Payment can be online at the time of registration by PayPal or offline by cheque etc. (maybe days later)

If I put this query

UPDATE `#__comprofiler` SET `approved`= '1' WHERE `user_id` = '[user_id]'; UPDATE `#__users` SET `block`= '0' WHERE `id`= '[user_id]'

into the Activation box of SQL Query 1 for the Plan will it do what we want?

Believe there needs to be a linebreak after ; for it to parse multiple queries at once, but yes that query would set the users approval state and change their block status. However, I strongly suggest using CB Auto Actions and a code action as follows.

Action: Code
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditional 1: [var3] Equal To PLAN_ID_HERE
Conditional 2: [var2] Equal To A
Method: PHP
Code:
The above should do normal PHP approval on the user after the PLAN_ID_HERE plan has been activated. This should allow normal approval emails and triggers to fire.

Thank you so much for taking the time to create the code for me and the detailed information on how to set up the CB Auto Action. I set the method to PHP(eval) rather than PHP(create_function) which I trust is correct?

I understand some of the PHP but not all (I am a VB programmer, not PHP) so I copied and pasted the code as given.

I will keep an eye on the outcomes as we receive new registrations.

Once again, many thanks, especially for your patience

A lot of hosts disable eval. So if it errors you'll need to use create_function. Be sure to do test registrations manually instead of waiting for a user to register. I suggest cloning your site, implementing the action, and thoroughly testing on the clone so you live site is untouched until you're confident it meets your needs.