[Kopfgeldjaeger]

We are now not allowing avatars for regular members in order to cut down bandwidth a bit.

I have shut off avatar use for regular members but I have a problem:

I cannot figure out how to remove avatars already in use by this usergroup.

There are 23,000 members so removing them by hand is not an option.

Can someone help me by providing a query or another way to remove all of the avatars in use by a certain usergroup please?

Thank you in advance.

--------------- Added [DATE]1194837304[/DATE] at [TIME]1194837304[/TIME] ---------------

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

PHP Code:

[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:

PHP Code:

DELETE FROM customavatar WHERE userid IN (2); 


With "2" being the Usergroup ID.

Any idea what I am doing wrong?