Sorting topics on last post but locked topics on the bottom

[Kris]

What do I alter in the query in MessageIndex.php ?

I'd like to get the topiclist like default but with the locked topics all down at the end of the page.

[Chris Cromer]

Open MessageIndex.php and look for:

Code Select Expand

ORDER BY
" . (!empty($modSettings['enableStickyTopics']) ? 't.isSticky' . ($fake_ascending ? '' : ' DESC') . ',
' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC') . "

and replace it with this:

Code Select Expand

ORDER BY
" . (!empty($modSettings['enableStickyTopics']) ? 't.isSticky' . ($fake_ascending ? '' : ' DESC') . ',
' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC') . ',
t.locked ASC' . "

[Kris]

Chris,

Don't see any difference in the display... 

[Chris Cromer]

Found the problem, replace it with this instead:

Code Select Expand

ORDER BY
" . (!empty($modSettings['enableStickyTopics']) ? 't.isSticky' . ($fake_ascending ? '' : ' DESC') . ',
t.locked ASC,
' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC') . "

And this time it's tested to work.

[Kris]

Chris,

Will test tonight when I can access the code
Thanks!

[Kris]

Chris,

Will test tonight when I can access the code
Thanks!

And works