Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 10-27-2007, 01:34 PM
dragon_1973 dragon_1973 is offline
 
Join Date: Sep 2005
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How to upload a large number of smilies?

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.
Reply With Quote
  #2  
Old 10-27-2007, 01:41 PM
MR.BOSS MR.BOSS is offline
 
Join Date: Sep 2007
Posts: 131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

good luck uploading them
Reply With Quote
  #3  
Old 10-27-2007, 02:05 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can upload 1,000 at a time if you wish, just upload them to the smiles folder, and go to your smiley manager
Reply With Quote
  #4  
Old 10-27-2007, 04:14 PM
MR.BOSS MR.BOSS is offline
 
Join Date: Sep 2007
Posts: 131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Loco.M View Post
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
Reply With Quote
  #5  
Old 10-27-2007, 04:18 PM
ChrisLM2001 ChrisLM2001 is offline
 
Join Date: May 2003
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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).
Reply With Quote
  #6  
Old 10-27-2007, 04:58 PM
Awjvail Awjvail is offline
 
Join Date: Jun 2007
Location: Canada
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #7  
Old 10-27-2007, 05:08 PM
dragon_1973 dragon_1973 is offline
 
Join Date: Sep 2005
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 10-27-2007, 05:13 PM
ChrisLM2001 ChrisLM2001 is offline
 
Join Date: May 2003
Posts: 126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
'images/smilies/extras/alien.gif'
Try it with the forward slash...

Code:
'/images/smilies/extras/alien.gif'
On some servers you may even have to add it as

Code:
'../images/smilies/extras/alien.gif'
Reply With Quote
  #9  
Old 10-27-2007, 05:17 PM
dragon_1973 dragon_1973 is offline
 
Join Date: Sep 2005
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #10  
Old 10-27-2007, 05:53 PM
Awjvail Awjvail is offline
 
Join Date: Jun 2007
Location: Canada
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OMG lol
Never even noticed that

Thank jesus.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:27 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04040 seconds
  • Memory Usage 2,243KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete