Delete multiple avatars from admin ctrl panel?

[Sue]

What the title says.

That would be helpful :)

:banana:

:D

[Velocd]

It could be done, but most are lazy and just use the query method via PhpMyAdmin:


delete from avatar where CONDITION;


CONDITION could be replace with:

avatarid>avatarid#
avatar=avatarid#

Or if you are using the avatar-category hack:

avatarcat=cat#

And other conditions.

Hopefully this helps alittle :p

[Strider Xero]

huh? i dont get how to do that.

[Strider Xero]

nevermind, i figured i it out myself.

For those of you who are like me, confused and mysql clueless, here's a helpful and better tip.

1. From phpMyAdmin, go to the table called 'avatar'.
2. There should be a text box that says 'Run SQL query..."
3. Delete the text thats in that text box.
4.)Now type in:

delete from avatar where avatarid#>avatarid#

Basically, if you have 100 avatars, and you'd like to delete all of them, your code would look like this:
delete from avatar where avatarid#1>avatarid#100

Click on 'Go' and you should be all set!

[WetWired]

Actually I think he meant somthing more like "avatarid>50". Why what you typed worked, I don't know, but I am assuming you meant to delete all of the avatars anyway.