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]

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

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