| How to order by locked status first, date secondly? [message #26110] |
Tue, 05 July 2005 09:56  |
Tension
Messages: 2
Registered: July 2005
Karma: 0
|
Junior Member |
|
|
(I hope this is the correct place to ask.)
Is it possible to sort a forum first by locked/unlocked status, and only after that in date? I admin a forum where lots of posts are locked quite fast and are in the majority. I'd like to filter them out by first sorting them by locked status (unlocked messages first, locked messages after that) and only apply order-by-date after that.
I know another way to achieve this would be to move all locked topics to another forum, but then I get loads of "This thread has been moved to <forum>" messages which are even more annoying.
Any help would greatly be appreciated.
--Tension
|
|
|
|
| Re: How to order by locked status first, date secondly? [message #26115 is a reply to message #26110] |
Tue, 05 July 2005 13:13  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
There is no way to filter out or sort topics inside the forum based on their locked/unlocked status. If you want to get such a list use an SQL query to fetch topics where (thread_opt & 1) > 0.
FUDforum Core Developer
|
|
|
|
| Re: How to order by locked status first, date secondly? [message #26118 is a reply to message #26115] |
Tue, 05 July 2005 13:40 |
Tension
Messages: 2
Registered: July 2005
Karma: 0
|
Junior Member |
|
|
| Ilia wrote on Tue, 05 July 2005 15:13 |
There is no way to filter out or sort topics inside the forum based on their locked/unlocked status. If you want to get such a list use an SQL query to fetch topics where (thread_opt & 1) > 0.
|
Thanks for the quick response, but it does not really help. In what file are the fetch topic routines defined? Where should I tinker?
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]