How do I delete avatars?

[porkyaaa]

some people uploaded avatars to the fourm. How do I delete them? I cant find them anywhere

[Jake Bunce]

This query should do it (backup first):

DELETE FROM customavatar

You can run this query in your:

Admin CP -> Import & Maintenance -> Execute SQL Query

You must have permission to execute queries in your includes/config.php file:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '';

[porkyaaa]

is there another way to do it? is there a way I can choose and save some of the avatars?

[Steve Machol]

Perhaps you could explain exactly what you want to do.

[porkyaaa]

I just want to see all the custom avatars people uploaded and delete some but not all of it

[Steve Machol]

Then you can delete one at a time in each user's profile on the Admin CP.

[Jake Bunce]

I made these scripts to delete avatars for a single group. They are kind of crude and don't do any reporting, but they might be of use to you.