How to upload a large number of smilies?

[dragon_1973]

ok... so I'm trying to do this by hand (nothing fancy or reproducable).

1) On a windows machine I did a "dir > list.txt"
2) Upload all the smilies to the server in the directory images/smilies/extras
3) Create a new image category, and open the imagecategories table to find out it's id.
4) open the file list.txt in a macro-enabled editor. I use Notepad++ (A god send if you are a developer or open large files)
5) Create a macro to turn each line:
"02/04/2004 12:00 AM 238 alien.gif"
to
"insert into smilie(title,smilietext,smiliepath,imagecategoryid ,displayorder) values('alien','_alien_','images/smilies/extras/alien.gif',5,1)"

Then... take those SQLs and run them on your database.

Now, the problem I have is this... the smilies are in the list when I view it in admin, and the showup in the editors as they should. However, when you click on the smilie, preview, or post your post, the smilie is not there, just the text... _alien_ in this example.

In admin, if I edit the smilie and then save it, it works. And when I look in the database, the record looks the same.

So... question is, when you save a smilie, what else is written or updated? obviously not just this table.

Thx.