PDA

View Full Version : Mass Smilie Deletion


formerEVO?
11-23-2002, 07:53 PM
How do you delete a large amount or all your smilies at once? I kinda made a bad mistake and installed alot of smilies before putting in the code to get the smilies. So i have 500 smilies to use, but none of them work, because when you click on them, you get a space. So how do you delete all of them. That's what i want to know. Can someone direct me to this hack, or make it for me.

If this is not a doable hack, can someone give me the query to use in phpMyAdmin?

Logician
11-23-2002, 11:00 PM
delete FROM `smilie` where smilieid>20 should delete the non-default smilies off the smilie table.