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