XF 1.1 Flush IP History of a User Group?

[taylor_smith]

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

 

[Jake Bunce]

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

Run this query:

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]

Thanks! I'll give it a shot.