What's the query for setting "Default Sort Field"?

[MrApples]

to Last Post and Descending. I've searched for this and cannot find it.

[Floris]

Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768)
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768

[MrApples]

It's not that. I would have found it then.

That controls the post order within a topic, I am looking for the topic order within a forum. "Default Sort Field"

[Floris]

That is a per forum setting, admincp> forums > forum manager > modify the forum where you want to set this for. I am not aware of a query to set this for all the forums in one go.

[MrApples]

Looked in the code to get this.

UPDATE vforum SET defaultsortfield = 'lastpost'
UPDATE vforum SET defaultsortorder = 'desc'

Not sure if that worked(i have a sort preference, dunno how to get rid of it), although it did set the columns correctly.

[Baitona]

Hi There are two methods:

1.

That is a per forum setting, admincp> forums > forum manager > modify the forum where you want to set this for. I am not aware of a query to set this for all the forums in one go.

2.
UPDATE `NAME_OF_UR_DATABASE`.`forum` SET `defaultsortfield` = 'lastpost',
`defaultsortorder` = 'desc';

and it is will work