1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Extended Smilie SQL Import [Deleted]

Discussion in 'Add-on Releases' started by Adam Howard, Sep 3, 2013.

  1. Adam Howard

    Adam Howard Well-Known Member

    Adam Howard submitted a new resource:

    Extended Smilie SQL Import - The SQL file for Shelley's extended smilies

    Read more about this resource...
     
    Shelley likes this.
  2. Adam Howard

    Adam Howard Well-Known Member

    Per @Shelley's request, please keep all your support questions here only (in this thread)
     
  3. The Forum Heroes

    The Forum Heroes Well-Known Member

    What's the difference between this one and the one already released and maintained for a long time now by @Sheldon as even Shelley mentioned already existed..
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    He deleted all of his resources.
     
    Adam Howard likes this.
  5. Adam Howard

    Adam Howard Well-Known Member

    ^ Support question

    Answer....

    There are 2 differences.

    He deleted his and so it was discontinued.

    Mine will be continued so long as Shelley releases updates, so will I. And the other difference is this one came from my database base (not Sheldon's).

    Shelley seems OK with also (see attached).
     

    Attached Files:

  6. The Forum Heroes

    The Forum Heroes Well-Known Member

    Oh ok, didn't know that. I just knew he maintained the sql though several updates of Shelley adding more smiles.
     
  7. Shelley

    Shelley Well-Known Member

    Seriously? You post a screenshot me agreeing?
     
    SneakyDave and The Forum Heroes like this.
  8. The Forum Heroes

    The Forum Heroes Well-Known Member

    Oh how this forum needs Luke's post rating just for epic replies such as this.. This deserves reply of the year :)
     
    SneakyDave likes this.
  9. Adam Howard

    Adam Howard Well-Known Member

    I take screen shots of anyone who agrees to let me do X, Y, or Z for a point of reference. Just so it does not come into question later by other individuals.

    Nothing aimed personally at you @Shelley. Just general practice and policy for good measure. :)
     
    DetroitCrow likes this.
  10. 0ptima

    0ptima Well-Known Member

    There are duplicate entries for troll. One of them looks like the blackeye smilie.
     
    Adam Howard likes this.
  11. Adam Howard

    Adam Howard Well-Known Member

    You're right.

    Should be

    :blackeye:
    :shiner:


    Will post an update to correct this shortly.
     
  12. Adam Howard

    Adam Howard Well-Known Member

    0ptima likes this.
  13. DRaver

    DRaver Active Member

    I get an error when I try to import the sql file:

    Code:
    SQL-Befehl:
    
    -- -- Dumping data for table `xf_smilie` -- INSERT INTO `xf_smilie` (`smilie_id`, `title`, `smilie_text`, `image_url`, `sprite_mode`, `sprite_params`) VALUES (1, 'Smile', ':)\n:-)\n(:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:19;s:1:"h";i:19;s:1:"x";i:0;s:1:"y";i:0;}'), (2, 'Wink', ';)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:18;s:1:"h";i:18;s:1:"x";i:-60;s:1:"y";i:-21;}'), (3, 'Frown', ':(', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:18;s:1:"h";i:18;s:1:"x";i:-40;s:1:"y";i:-42;}'), (4, 'Mad', ':mad:\n>:(\n:@', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:18;s:1:"h";i:18;s:1:"x";i:-60;s:1:"y";i:0;}'), (5, 'Confused', ':confused:', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:18;s:1:"h";i:18;s:1:"x";i:-40;s:1:"y";i:-21;}'), (6, 'Cool', ':cool:\n8-)', 'styles/default/xenforo/xenforo-smilies-sprite.png', 1, 'a:4:{s:1:"w";i:18;s:1:"h";i:18;s[...]
    
    MySQL meldet: Dokumentation
    
    #1062 - Duplicate entry '1' for key 'PRIMARY' 
     
  14. Adam Howard

    Adam Howard Well-Known Member

    You have to first empty xf_smilie

    Key word is empty, not drop.
     
  15. DRaver

    DRaver Active Member

    Thanks, this works. Now I have 134 smilies.

    But in my editor, I have only 12 smilies.

    smile.JPG

    How can I display all smilies?
     
    Last edited: Oct 17, 2013
  16. Adam Howard

    Adam Howard Well-Known Member

    Go into the smilie manager. Click on edit on one of the new smilies (something that didn't come with default XenForo). Don't change anything, just click on save. This should force them to "repopulate" and display.
     
    Shelley likes this.
  17. DRaver

    DRaver Active Member

    Thanks, this works :)
     
    Adam Howard likes this.
  18. C.Stanley

    C.Stanley Active Member

    So how to use this?
     
  19. Adam Howard

    Adam Howard Well-Known Member

    • Download this resource http://xenforo.com/community/resources/xenforo-extended-smilies.906/
    • Extract it and follow the instructions
    • Download the current resource (the one you are visiting now)
    • Extract the zip
    • Backup your database
    • empty the table xf_smilie inside your database (you can do this using phpMyAdmin for example)
    • Import the supplied xf_smilie.sql file into your database
    • Go to your AdminCP
    • Edit 1 smilie (don't change anything, just click edit, then save)

    DONE :)
     
    C.Stanley likes this.
  20. C.Stanley

    C.Stanley Active Member

    Sounds like it works but im lost lol
     

Share This Page