How to upload a large number of smilies?

[dragon_1973]

I have a pile of smilies I'd like to upload to my forums. How can I do it without adding one at a time in the admin? I don't really care what they are titled (File name is file) or the replacement text is (although I prefer them not to have replacement text).

I can upload them to the server... but how do I get them in the database?

Thx.

[MR.BOSS]

i dont think u can add many at atime, in my forum i uploaded 100 smiles ( one by one )

good luck uploading them

[Brandon Sheley]

You can upload 1,000 at a time if you wish, just upload them to the smiles folder, and go to your smiley manager

[MR.BOSS]

Originally Posted by Loco.M

You can upload 1,000 at a time if you wish, just upload them to the smiles folder, and go to your smiley manager

well u can upload million if you want, through ftp, but how will you varify them unless u add every single smilie, in the cpanel

[ChrisLM2001]

Depending on the OS you use, for a whole mass of images, you'll upload them in an archive, .zip or a tarball. Then deflate them on the server.

But to include the smilies to use in vBulletin, you'll be spending some time inserting them one-by-one via the Smilie console (unless someone has a script to make the process bearable for 100+ at a time).

[Awjvail]

IPB has a system where you can import an XML file and it will add the smilies.. Anybody have anything like that or can code anything like that?

[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.

[ChrisLM2001]

'images/smilies/extras/alien.gif'

Try it with the forward slash...

'/images/smilies/extras/alien.gif'

On some servers you may even have to add it as

'../images/smilies/extras/alien.gif'

[dragon_1973]

On my server (FC7) it's just "images/sm..." no leading slash.

In admin the smilies show, and in the list of smilies in the editors it shows... which means the path is working.

--------------- Added [DATE]1193509277[/DATE] at [TIME]1193509277[/TIME] ---------------

Does vBulletin cache them somewhere? maybe a restart after I import them through the database this way?

--------------- Added [DATE]1193509493[/DATE] at [TIME]1193509493[/TIME] ---------------

ok... I feel like a loser... (Where is the smilie for that).

Upload to server and in the add smilies, there is a an add multiple smilies box... select all, and it does the rest!

[Awjvail]

OMG lol
Never even noticed that

Thank jesus.