Disable Activity Summary Email per user hard DB query?

Status: This content is read-only, or is not open for further replies.

frm

Guest

offline

OP
Dec 31, 2024
0
143

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:

Code:

UPDATE `xf_user_option`
INNER JOIN `xf_user`
ON `xf_user_option`.`user_id` = `xf_user`.`user_id`
AND `xf_user`.`email` = '[email protected]'
SET `xf_user_option`.`show_dob_year` = 0, `xf_user_option`.`show_dob_date` = 0, `xf_user_option`.`content_show_signature` = 0...