• 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]

Adam Howard

Well-known member
#1
Adam Howard submitted a new resource:

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

System Requirements:
  • XenForo 1.2.x
  • Shelley's extended smilies
  • knowledge how to import SQL file into database

This is the SQL export of xf_smillie so you can easily import all the smilies at once from Shelley's Extend Smillies (link)

Per @Shelley's request, please keep all your support questions here only
Read more about this resource...
 

Mike Edge

Well-known member
#3
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..
 

Adam Howard

Well-known member
#5
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..
^ 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).
 

Attachments

Shelley

Well-known member
#7
^ 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).
Seriously? You post a screenshot me agreeing?
 

DRaver

Active member
#13
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'
 

Adam Howard

Well-known member
#14
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'
You have to first empty xf_smilie

Key word is empty, not drop.
 

DRaver

Active member
#15
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:

Adam Howard

Well-known member
#19
So how to use this?
  • 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 :)