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

XF 1.4 Disable multiple members' "Receive site mailings" option at once


Well-known member
With the following query (thanks @Andy.N) one can put several users into the Email invalid (bounced) state.
update `xf_user`
set user_state = 'email_bounce'
where email IN ('email1@domain.com', 'email2@domain.com')
The question is, does anyone know of a similar query but which would disable the accounts' "Receive site mailings" option that are associated with the said emails?

Is it possible to do with a simple query?