VBulletin query help

[geniuscrew]

I'm in need of a query to get rid of the avs of normal members - ie. not mods/admins/supermods.

Thanks.

[Xenon]

UPDATE user SET avatarid=0, hascustomavatar=0 WHERE usergroupid NOT IN (5,6,7)