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

XF 1.1 Flush IP History of a User Group?

Discussion in 'XenForo Questions and Support' started by taylor_smith, Mar 22, 2012.

  1. taylor_smith

    taylor_smith Well-Known Member

    How might I instruct my SYSOP to flush the IP history of a particular user group?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query:

    Code:
    DELETE
    FROM xf_ip
    WHERE user_id IN (
    	SELECT ugr.user_id
    	FROM xf_user_group_relation AS ugr
    	WHERE ugr.user_group_id = 4
    );
    
    You need to specify the group id.
     
    taylor_smith likes this.
  3. taylor_smith

    taylor_smith Well-Known Member

    Thanks! I'll give it a shot. :)
     

Share This Page