XF 1.4 Mass Unsubscribe Users from Receiving Admin Emails?

[UserMatt]

Hi,

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

Thanks,

Matt

 

[Paul B]

There is no option for that so it would require running a query directly against the database.

 

[UserMatt]

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:

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

Thanks

 

[Paul B]

It would be:

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.