block user on after user reg, based on fld

Yes, it is required admin approval No
and required email confirmation Yes

Ok - the entire use case really inspired me to write-up a small tutorial in our new tutorials section:

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

Feedback welcome.

Hi Nant,

Thank you so much, I was looking to do this for two months and CB Email Action gave somewhere to start. Thank you, your tutorial is perfect.

Dear Nant,

I am trying to implement your tutorial and every thing works apart from Query Actions. I receive both emails but user still can use the site after email confirmation.

My query codes are

UPDATE `#_users` SET `block` = '1' WHERE `id` = '[user_id]'

UPDATE `#_comprofiler` SET `approved`= '0' WHERE `user_id` = '[user_id]'

Is there something wrong with above.

Thank you.

you have to do the comprofiler one first - make sure that query autoaction is first in the CB Auto Actions list.

Many thanks, I changed the order and also I just realised that I need two underlines before comprofiler. It is working great now.