Query needed to del all cusotm avatars from one usergroup id :)

[corsacrazy]

as title says pls , i need to run a query to drop all custom avatars from one usergroup id, cheers

[Velocd]

DELETE FROM `customavatar` LEFT JOIN `user` USING (userid) WHERE user.usergroupid=$usergroupid

This should work, but it's untested, so try it first on a dummy table.