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.
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.
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.
Code:
TRUNCATE TABLE xf_smilie;