Alphabetizing Smilies

[Firyou]

Hello, I was wondering if there is a certain wait to automatically organize the smiley list with a php script that I can run as a task? Or even a SQL query? I have over 500 smilies and it would take a little long to do it manually lol. My forum is running on 4.2.0 PL4

tyia for any help

[kh99]

I think you could write a query to select all smilies and order by category then title, and loop through the results updating the displayorder field for each one. I'm not an SQL expert so I'd be curious to know if there's some way to do that in SQL with a single query.

[Zachery]

Alphabetize by what? File Name? Smilie code?

[Firyou]

Alphabetize by what? File Name? Smilie code?

Filename

[Firyou]

any idea?