• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
  • This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

Smiley Sprite Settings

Kier

XenForo Developer
Staff member
#1
This SQL dump contains the settings we use here on XenForo.com to turn all our smilies into sprites.

Note that this attempts to insert a whole new set of smilies into your database, so you may want to empty the table first, but please note that this will wipe-out any extra smilies you may have defined.
Code:
TRUNCATE TABLE xf_smilie;
Once you have imported the SQL, go and edit a single smilie and save it, and the cache will be rebuilt ready for your members to use.
 

Attachments

bambua

Well-known member
#3
Just as an fyi, make sure you go in and save one smilie in the acp after you do this, it didn't work on my forums until I did that to update the cache.
 

Shelley

Well-known member
#6
Could we possibly get the sql file for "poop" "alien" "ninja" and the other two smilies as the total amounts to 35 not 30 if that's possible as we are using the full 35 smilies. Thanks.
 

Brogan

XenForo moderator
Staff member
#11
I had the same problem.

No matter what I couldn't get the smilies to appear in the editor dropdown.

Try adding a new smiley and see if that fixes it.
 

Kier

XenForo Developer
Staff member
#13
The things that will rebuild the smiley cache are editing the image path or the smiley text - the other settings in the smiley editor won't trigger a recache.
 

Brogan

XenForo moderator
Staff member
#15
No, only 11 are defined out of the box.

You need to run that script in phpMyAdmin to add the others, or add them manually in the ACP.
 

Brogan

XenForo moderator
Staff member
#17
You should not have deleted the table, just empty/truncate it.

You won't be able to create any smilies now as the table doesn't exist.

You will need to restore that table from a backup, or run this script.

Code:
CREATE TABLE IF NOT EXISTS `xf_smilie` (
  `smilie_id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `smilie_text` text NOT NULL,
  `image_url` varchar(200) NOT NULL,
  `sprite_mode` tinyint(3) unsigned NOT NULL default '0',
  `sprite_params` text NOT NULL,
  PRIMARY KEY  (`smilie_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;