Ques/Help Disable Activity Summary Email per user hard DB query?

[frm]

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:
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...

Read more

Continue reading...