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

Smilie Sprites SQL File [Deleted]

Discussion in 'Other Releases' started by Sheldon, May 8, 2013.

  1. Sheldon

    Sheldon Well-Known Member

  2. DarkGizmo

    DarkGizmo Active Member

    Will this cause duplicates for the ones we already have? or will it just overwrite?
     
  3. MattW

    MattW Well-Known Member

    You'll need to truncate the smilies table first, otherwise you'll get a duplicate key error when you try to import them.

    "Duplicate entry '1' for key 'PRIMARY'"
     
  4. IcEWoLF

    IcEWoLF Well-Known Member

    Thanks for this resource stewart1champ and of course Shelley for making some awesome smilies!
     
  5. Sheldon

    Sheldon Well-Known Member

    Lisa likes this.
  6. Eoj Nawoh

    Eoj Nawoh Active Member

    Nvm, I found the issue, when downloading the sprite sheet, you must ensure that the image is full scale before doing so, otherwise it messes it all up.

    Thanks for the great work stewart!
     
  7. Sheldon

    Sheldon Well-Known Member

    Did you truncate your table first?
    Are you using a Smilie Manager?
     
  8. Sheldon

    Sheldon Well-Known Member

    Did you upload the smilies to this area: /styles/default/xenforo/
     
  9. Francesco V.

    Francesco V. Active Member

    Hi stewart and thanks a lot for this resource.
    I don't know if this happens only to me but in my case smileys of the last row of the sprite file are not shown in smiley mngmt area of Xenforo.
     
  10. Sheldon

    Sheldon Well-Known Member

    Go in, edit a smilie. Do nothing. Hit save. Go back in, they should appear.
     
  11. Francesco V.

    Francesco V. Active Member

    Maybe i found the issue. Actually this issue is not only for the last row but for some smiley that have a starting slash / in the url pointing the sprite file.

    /styles/default/xenforo/xenforo-extended-sprite.png

    when i use styles/default/xenforo/xenforo-extended-sprite.png the file is pointed correctly
     
  12. Eoj Nawoh

    Eoj Nawoh Active Member

    No I found my issue. When I downloaded the sprite sheet, I didn't zoom in 100%, so the image itself was smaller. Causing all the smilies to be off.
     
  13. IcEWoLF

    IcEWoLF Well-Known Member

    stewart1champ, could you please provide the command on how to truncate the smilie table?
     
  14. oman

    oman Well-Known Member

    Code:
    TRUNCATE xf_smilie;
    or

    [​IMG]
     
    IcEWoLF likes this.
  15. IcEWoLF

    IcEWoLF Well-Known Member

    Thanks Oman!
     
  16. Sheldon

    Sheldon Well-Known Member

  17. IcEWoLF

    IcEWoLF Well-Known Member

    stewart1champ, if I disable [dc] Smilie Manager, then run this file and then re-enable dc smile manager, will this work?
     
  18. Sheldon

    Sheldon Well-Known Member

    No. I don't think it will.
     
  19. The Forum Heroes

    The Forum Heroes Well-Known Member

    Could you please update the SQL to include the 1. Jaw Drop , 2. Turtle, 3. Cow, 4. Beaver update Shelley added?
     
  20. Sheldon

    Sheldon Well-Known Member

    http://xenforo.com/community/resources/smilie-sprites-sql-file.1797/update?update=4257

    Posted a few minutes after her update. No need for me to update the SQL where she changed "Playful"... location stayed the same, only image changed.

    I update these shortly after a release (as long as I am at my PC).
     

Share This Page