1. 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

Discussion in 'XenForo Questions and Support' started by Brent W, Nov 1, 2012.

  1. Brent W

    Brent W Formerly BamaStangGuy

    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?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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')
    );
    
     
    Brent W and vVv like this.

Share This Page