XF 2.0 Is there a way to mass delete smilies?

[PumpinIron]

I recently upgraded to XF2 from 1.5, and I have a ton (probably well over 100) smilies I don't want. Problem is, having to go through and delete them one-by-one is getting very, very annoying.

Is there a way to mass delete them by chance?

 

[Emre]

1. Use phpmyadmin
2. Go to the xf_smilies table
3. Press browse to show the data, rather than structure

Don't forget to take a backup

 

[PumpinIron]

I figured that would be the case. Looks like it’s into the database I go!

 

[whynot]

I figured that would be the case. Looks like it’s into the database I go!

Not a safe method. Do it only when there is no other option.

 

[PumpinIron]

phpmyadmin worked like a charm! Thanks for the suggestion. I deleted them all in about 5 seconds versus what would have taken forever!

 

[AndyB]

The problem with just removing smilies from the message using phpMyAdmin is that the smilie might have been used to replace text. Now some messages will make no sense.

 

[PumpinIron]

The problem with just removing smilies from the message using phpMyAdmin is that the smilie might have been used to replace text. Now some messages will make no sense.

Trust me, none of these smilies were ever used. Somehow they ended up being massive (like 1000px wide) smiles. Not sure how that happened, but they're gone now.

 

[hIBEES]

The problem with just removing smilies from the message using phpMyAdmin is that the smilie might have been used to replace text. Now some messages will make no sense.

Any suggestions @Andy

I want to freshen mine up.

Keep the ones for that reason but not have them selectable now but new ones.