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)
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

Gurpartap Singh - June 27, 2009 - 16:08
Status:active» postponed (maintainer needs more info)

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

 
 

Drupal is a registered trademark of Dries Buytaert.