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

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.

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