frm
Well-known member
I'm looking for the "activity_summary_email" [1/0] option in any table to do a mass "No" for a selected list, so that the "Yes" isn't saved, if ever enabled again.
So far I have email alerts and DOB with:
But, I can't seem to locate where the option for activity summary email is located on a per-user basis, i.e., which table/column (in 2.2).
So far I have email alerts and DOB with:
SQL:
UPDATE `xf_user_option`
INNER JOIN `xf_user`
ON `xf_user_option`.`user_id` = `xf_user`.`user_id`
AND `xf_user`.`email` = 'bounced_user@provider.com'
SET `xf_user_option`.`show_dob_year` = 0, `xf_user_option`.`show_dob_date` = 0, `xf_user_option`.`content_show_signature` = 0, `xf_user_option`.`receive_admin_email` = 0, `xf_user_option`.`email_on_conversation` = 0, `xf_user_option`.`push_on_conversation` = 0, `xf_user_option`.`creation_watch_state` = 'watch_no_email', `xf_user_option`.`interaction_watch_state` = 'watch_no_email';
But, I can't seem to locate where the option for activity summary email is located on a per-user basis, i.e., which table/column (in 2.2).