Smiley Sprite Settings

[Kier]

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.

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.

 

[bambua]

Just ran it on my test site and worked perfectly.

 

[bambua]

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.

 

[John L.]

Worked perfectly! Thanks so much for this Kier. Love this software.

 

[Paul B]

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.

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.

 

[Shelley]

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.

 

[bambua]

Yay for reading. I need coffee.

 

[Kevin]

Kier, thanks for compiling the list.

 

[gldtn]

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.

Would be nice to get them in there

 

[dtmcl]

Thanks for the sql but they do not appear, I have tried editing/saving smilies and refreshing my browser cache but this is what has happened

http://www.adminforums.org/help/smilies

 

[Paul B]

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.

 

[dtmcl]

Thanks Brogan, that worked

 

[Kier]

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.

 

[Dan]

The settings for alien, poop and ninja are the following:

Poop -20 and -84
Alien -60 and -105
Ninja -40 and -63

 

[Paul B]

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.

 

[kkm323]

Failed, I'll do it manually

1. Deleted TABLE xf_smilie
2. Import xf_smilie.sql
3. #1146 - Table 'xenforo.xf_smilie' doesn't exist
   
   
   

 

[Paul B]

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.

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 ;

 

[gldtn]

The settings for alien, poop and ninja are the following:

Poop -20 and -84
Alien -60 and -105
Ninja -40 and -63

Devil: -80 -105

 

[Dan]

Devil: -80 -105

Thats the one I was missing.

 

[Kevin]

The settings for alien, poop and ninja are the following:

Poop -20 and -84
Alien -60 and -105
Ninja -40 and -63

Devil: -80 -105

The last one....

Geek -80 and 0