This topic was marked solved by its starter, on January 19th, 2013, 04:01 PM
Been thinking about this a bit, wondering what people think.
Would it be interesting/useful to allow site owners to re-organise sticky topics into a fixed order, regardless of last post?
Technically it makes little or no difference, ordering is always done on is_sticky which is a tinyint, and that's before ordering by last post. Right now, it's simply 1 or 0, but you could introduce non-1 values to force a specific ordering. It doesn't require changing indexes, since the nature of it will still mean zero rows will form the bulk of the index (and thus render it useless) and it is not significantly expensive to pull just the sticky rows from a board.
Just wondering if it's worth the effort; it's mostly just some UI and a little bit of logic change (where it currently assumes it's 1/0 rather than non-zero/zero)
Would it be interesting/useful to allow site owners to re-organise sticky topics into a fixed order, regardless of last post?
Technically it makes little or no difference, ordering is always done on is_sticky which is a tinyint, and that's before ordering by last post. Right now, it's simply 1 or 0, but you could introduce non-1 values to force a specific ordering. It doesn't require changing indexes, since the nature of it will still mean zero rows will form the bulk of the index (and thus render it useless) and it is not significantly expensive to pull just the sticky rows from a board.
Just wondering if it's worth the effort; it's mostly just some UI and a little bit of logic change (where it currently assumes it's 1/0 rather than non-zero/zero)
