Removing avatars

[GCC LLC]

Is there a way to remove avatars from certain usergroups? Some users still have avatars from years ago and its producing a lot of dead links.

[Jake Bunce]

Custom avatars? Or those defined in your:

Admin CP -> Avatars -> Avatar Manager

To remove custom avatars, run this query (backup first):

DELETE FROM customavatar AS customavatar
USING customavatar
LEFT JOIN user AS user ON (user.userid = customavatar.userid)
WHERE user.usergroupid = [color=red]X[/color]

Where X is the usergroupid of the primary usergroup for which you want to delete custom avatars.

To remove predefined avatars, run this query (backup first):

UPDATE user
SET avatarid = 0
WHERE usergroupid = [color=red]X[/color]

Where X is the usergroupid of the primary usergroup for which you want to delete predefined avatars.