Log in

View Full Version : SQL Query - Display new threads first


Firecracker
07-04-2007, 08:51 PM
I know how to do the automatic query to have all your users display new/old posts first. But what's the the query to make the all display new threads first ? I know you can set it as default for new users, but haw to mass change it for existing users?
Only automatic query is the "Thread Display Mode - Linear". No subcategory for 'New Threads First'.

Thx in advance!

snakes1100
07-05-2007, 06:40 AM
admincp --> maintenance --> execute sql query --> Posts - new first/old first

Your asking for posts in one part of your post, then asking about threads, the above is for posts anyways.

Firecracker
07-05-2007, 07:56 PM
admincp --> maintenance --> execute sql query --> Posts - new first/old first

Your asking for posts in one part of your post, then asking about threads, the above is for posts anyways.

That's the query I already know. That was my first sentence. There doesn't seem to be an automatic query for threads though. So I'm asking what the manual query is.
Thx!