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]'