Deleting / Removing all avatars in a usergroup?

[kopfgeldjaeger]

Is there a query or something I can run that will remove every avatar in a certain usergroup?

We are removing the option for regular members to have an avatar due to bandwidth issues but I cannot figure out how to remove all of the avatars that were set before I shut this option off.

There are 23,000 regular members with avatars right now so removing them by hand is not an option.

Thank you in advance!

[kopfgeldjaeger]

Okay, from another post I figured out how to run the Query, however I get an error:

[B]An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'warrifl_forums.customavatar' doesn't exist[/B] 

The Query I used is here:

DELETE FROM customavatar WHERE userid IN (2); 

With "2" being the Usergroup ID.

Any idea what I am doing wrong?

[Jose Amaral Rego]

No usergroup(s) id within customavatar table with uploaded avatar(s). This only has single id(s) per user.

DELETE FROM `customavatar` WHERE `customavatar`.`userid` = 1

This script seems to have work for 3.0.x, but will need to ask over at www.vBulletin.org about this, as I have not tried using Jake's script to see if this actually works with current vBulletin.

http://www.vbulletin.com/forum/showthread.php?t=101614

IN (X); <-- It is in array or multiple(s)