I have generated a list of around 300 email addresses, which I want to change from "valid" userstate into "awaiting email confirmation (from edit)" userstate.
At the same time, I want to change for the same email adresses the setting for getting admin email to "no", same for email notifications of new postings and email notifications for conversations/PMs
I tried this in the xf_user table in the SQL tab:
UPDATE xf_user AS xfuser INNER JOIN xf_user_option AS user_option ON (xfuser.user_id = user_option.user_id) INNER JOIN xf_thread_watch AS thread_watch ON (xfuser.user_id = thread_watch.user_id) SET xfuser.user_state = 'email_confirm_edit', user_option.receive_admin_email = 0, user_option.email_on_conversation = 0, thread_watch.email_subscribe = 0 WHERE email IN ('EMAIL1', 'EMAIL2', 'EMAIL3')
Thanks in advance