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

XF 1.1 Query to change receive admin email based on list of emails

Brent W

Well-known member
#1
If I have a list of emails is there a query that I can run that will change all of those emails so that they don't receive admin emails?
 

Jake Bunce

XenForo moderator
Staff member
#2
Code:
UPDATE xf_user_option AS uo
SET uo.receive_admin_email = 0
WHERE (
	SELECT u.user_id
	FROM xf_user AS u
	WHERE u.user_id = uo.user_id
	AND u.email IN ('blah@blah.com', 'blah4444@blah.com')
);