XF 1.4 Mass Unsubscribe Users from Receiving Admin Emails?

UserMatt

Member
Hi,

Is there a way/command to mass unsubscribe a list of users (email addresses) from receiving admin emails?

Thanks,

Matt
 
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
 
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.
 
Top Bottom