Graphic Wanted : some smilieys for AVForums

[Paul B]

What determines the sort order of smileys in Redactor? It seems random. Really need to be able to organise these so the smiley drop down is tidied up.

It is based on the smilie_id in the xf_smilie table, which itself is based on the order the smilies are added.

If you want to re-order them, you can simply edit the smilie_id and then edit and save one of the smilies in the ACP to update them.

 

[Kevin]

What determines the sort order of smileys in Redactor? It seems random. Really need to be able to organise these so the smiley drop down is tidied up.

Trichome is correct, the sort order is using the table "smilie_id" value so it means that the order that they are entered is the value that they are shown in (they are presented left to right wrapping to fit the box).

The add-on Shelley linked to should work if you have a lot smilies.

If you are just after a quick & dirty change you can change the /library/XenForo/Model/Smilie.php file at line 86 (for XF 1.2 at least) in the 'getAllSmiliesForCache' to change the "ORDER BY" to something else (eg: "title" to sort them alphabetically by their name or "smilie_text" to sort them by their description). If you change the query go in to your ACP afterwards and touch one of the smilies so that it updates your cache.

 

[Stuart Wright]

Thanks all. That addon is a quick fox for now. Not responsive and leaves the original redactor smiley button working in tandem, but I expect a better solution will be along soon.

 

[Shelley]

Trichome is correct, the sort order is using the table "smilie_id" value so it means that the order that they are entered is the value that they are shown in (they are presented left to right wrapping to fit the box).

The add-on Shelley linked to should work if you have a lot smilies.

If you are just after a quick & dirty change you can change the /library/XenForo/Model/Smilie.php file at line 86 (for XF 1.2 at least) in the 'getAllSmiliesForCache' to change the "ORDER BY" to something else (eg: "title" to sort them alphabetically by their name or "smilie_text" to sort them by their description). If you change the query go in to your ACP afterwards and touch one of the smilies so that it updates your cache.

Still can't believe we have to go through all that fuss just to adjust sorting.