taylor_smith Well-known member Mar 22, 2012 #1 How might I instruct my SYSOP to flush the IP history of a particular user group?
Jake Bunce Well-known member Mar 23, 2012 #2 taylor_smith said: How might I instruct my SYSOP to flush the IP history of a particular user group? Click to expand... Run this query: Rich (BB 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. Upvote 0 Downvote
taylor_smith said: How might I instruct my SYSOP to flush the IP history of a particular user group? Click to expand... Run this query: Rich (BB 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.