XF 2.3 SQL query to remove existing subscriptions?

ibrian

Well-known member
I'm trying to tidy up an old forum, but there are a lot of inactive members who have the "Receive activity summary email" option checked, and I'd like to unchecked it to reduce bounced emails.

I presume there must be a simple SQL query I can run in phpmyadmin to change the option for all members from checked to unchecked.

Could anyone advise what this might be, please?

Many thanks for any replies.
 
Batch update users appears to have an option to bulk change activity summary setting! And if you do not want anyone to use this feature, I suppose you can disable the feature as well? Setting is here: admin.php?options/groups/emailOptions/#activitySummaryEmail
 
Back
Top Bottom