1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. 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

Discussion in 'Other Resources [Archive]' started by Kier, Oct 7, 2011.

  1. Kier

    Kier XenForo Developer Staff Member

    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.

    Attached Files:

    maszd, meinzel, Shyuan and 14 others like this.
  2. bambua

    bambua Well-Known Member

    Just ran it on my test site and worked perfectly.
  3. bambua

    bambua Well-Known Member

    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.
  4. John L.

    John L. Well-Known Member

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

    Brogan XenForo Moderator Staff Member

  6. Shelley

    Shelley Well-Known Member

    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.
    gldtn likes this.
  7. bambua

    bambua Well-Known Member

    Yay for reading. I need coffee.
  8. Kevin

    Kevin Well-Known Member

    Kier, thanks for compiling the list. :)
  9. gldtn

    gldtn Well-Known Member

    Would be nice to get them in there :D
  10. ShadyX

    ShadyX Well-Known Member

  11. Brogan

    Brogan XenForo Moderator Staff Member

    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.
    ShadyX likes this.
  12. ShadyX

    ShadyX Well-Known Member

    Thanks Brogan, that worked :D
  13. Kier

    Kier XenForo Developer Staff Member

    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.
    ShadyX likes this.
  14. Dan

    Dan Well-Known Member

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

    Poop -20 and -84
    Alien -60 and -105
    Ninja -40 and -63
    MrC, snowman and ShadyX like this.
  15. Brogan

    Brogan XenForo Moderator Staff Member

    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.
  16. kkm323

    kkm323 Well-Known Member

    Failed, I'll do it manually :cry:
    1. Deleted TABLE xf_smilie
    2. Import xf_smilie.sql
    3. #1146 - Table 'xenforo.xf_smilie' doesn't exist

  17. Brogan

    Brogan XenForo Moderator Staff Member

    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`)
  18. gldtn

    gldtn Well-Known Member

    Devil: -80 -105
    MrC, snowman and Dan like this.
  19. Dan

    Dan Well-Known Member

    Thats the one I was missing.
    gldtn likes this.
  20. Kevin

    Kevin Well-Known Member

    The last one....

    Geek -80 and 0
    Turt, MrC, snowman and 3 others like this.

Share This Page