FUDforum: How To » force announcements above stickies

Home » FUDforum » How To » force announcements above stickies

Tue, 13 September 2005 14:29

Marticus

Messages: 272
Registered: June 2002

Karma:

Senior Member

This seems to have done the trick.

ORDER BY (CASE WHEN thread_opt>=4 THEN 4294967294 WHEN thread_opt>=2 THEN 4294967296 ELSE {SQL_TABLE_PREFIX}thread.last_post_date END) ASC');

Thanks for the pointer. By the way, that's a very clever approach to ordering, at least from my perspective.

[Updated on: Tue, 13 September 2005 14:31]

		force announcements above stickies By: Marticus on Mon, 12 September 2005 14:05
		Re: force announcements above stickies By: Ilia on Mon, 12 September 2005 14:14
		Re: force announcements above stickies By: Marticus on Mon, 12 September 2005 14:21
		Re: force announcements above stickies By: Ilia on Mon, 12 September 2005 14:37
		Re: force announcements above stickies By: Marticus on Mon, 12 September 2005 17:57
		Re: force announcements above stickies By: Ilia on Mon, 12 September 2005 20:39
		Re: force announcements above stickies By: Marticus on Tue, 13 September 2005 14:29
		Re: force announcements above stickies By: Marticus on Tue, 13 September 2005 14:42
		Re: force announcements above stickies By: Ilia on Tue, 13 September 2005 16:36

Previous Topic:	How to sort for popular topics
Next Topic:	Rank picture for admin and moderator

Goto Forum:

]

Current Time: Fri Sep 20 00:10:36 GMT 2024

Total time taken to generate the page: 0.03969 seconds