Mass Delete of Avatars

[WoodiE]

Is there anyway I can delete a large number of avatars at once, instead of doing a remove one at a time?

I have deleted them from the server, but then my users have a red X under their names.

-WoodiE

[Xenon]

try to run this queries:
UPDATE user SET avatarid=0 WHERE avatarid=xx
replace xx with every avatarid you have deleted the avatars..