• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Mass Unsubscribe Users from Receiving Admin Emails?

#3
There is no option for that so it would require running a query directly against the database.
That makes sense, thanks. Do you have any idea what the query would be?

In vBulletin I used:

Code:
UPDATE user SET options = options - 16 WHERE options & 16 AND email IN (
'email@email.com',
'email@email.com',
'email@email.com'
)
Thanks
 

Brogan

XenForo moderator
Staff member
#4
It would be:
Code:
UPDATE xf_user_option SET receive_admin_email = 0;
That would do it for all users though, so you would need to factor in the user IDs to the query.