Smilie Sprites SQL File [Deleted]

[Sheldon]

stewart1champ submitted a new resource:

Smilie Sprites SQL File - Add all smilies quickly

Simple zip file containing SQL coordinates of the Extended Smilie Pack.

Will add all original smilies, plus these listed here:

http://xenforo.com/community/resources/xenforo-extended-smilies.906/

If you have [dc] Smilie Manager installed, this SQL file will not work.

If you do not know what you are doing, this SQL file is likely not for you.

Read more about this resource...

 

[DarkGizmo]

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

 

[MattW]

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

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'"

 

[IcEWoLF]

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

 

[Sheldon]

stewart1champ updated Smilie Sprites SQL File with a new update entry:

Added 5 additional released...

Added the 5 additional smilies recently released.

Read the rest of this update entry...

 

[Eoj Nawoh]

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!

 

[Sheldon]

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.

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

 

[Sheldon]

Did you upload the smilies to this area: /styles/default/xenforo/

 

[Francesco V.]

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.

 

[Sheldon]

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.

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

 

[Francesco V.]

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

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

 

[Eoj Nawoh]

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

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.

 

[IcEWoLF]

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

 

[oman]

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

TRUNCATE xf_smilie;

or

 

[IcEWoLF]

Thanks Oman!

 

[Sheldon]

stewart1champ updated Smilie Sprites SQL File with a new update entry:

Updated with 4 smilies.

4 smilies added.

Read the rest of this update entry...

 

[IcEWoLF]

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

 

[Sheldon]

No. I don't think it will.

 

[Mike Edge]

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

 

[Sheldon]

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

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).