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

markku

Well-known member
With the following query (thanks @Andy.N) one can put several users into the Email invalid (bounced) state.
Code:
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?
 
Back
Top Bottom