XF 1.1 Flush IP History of a User Group?

Jake Bunce

XenForo moderator
Staff member
How might I instruct my SYSOP to flush the IP history of a particular user group?
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.
 
Top