Sort smileys by weight and id
YorickDowne - February 15, 2009 - 11:10
| Project: | Smileys |
| Version: | 6.x-1.0-alpha5 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
Currently, smileys are sorted by weight only. This means that the order that they appear in a .pak file is not kept, as they will not get into the DB in that exact row order. By changing the code from "ORDER BY weight" to "ORDER BY weight, id" same-weight items will appear in the order that they were in the .pak file.
An example use is the use of smileys to allow users to post game "builds" - one smiley per option available, in this particular case "Mercenaries" for the game "Atlantica". When using "ORDER BY weight, id" they follow the (deliberate) order in the .pak file.

#1
I tried your change to the included Example package, but to no effect. :S