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 BamaStangGuy, Nov 1, 2012.

  1. BamaStangGuy

    BamaStangGuy Well-Known Member

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

Share This Page