sort threads by dateline for certain forums..

[ralphuk100]

How do I sort threads by dateline descending for individual forums? Thanks.

[Andreas]

This might help you:
https://vborg.vbsupport.ru/showpost....2&postcount=38

[ralphuk100]

Originally Posted by KirbyDE

This might help you:
https://vborg.vbsupport.ru/showpost....2&postcount=38

Thanks! That looks spot on...the only thing I am unsure about is part 1 - where do I add the code for the dropdown list? what page? Where...can I add a new option on the ACP?

[Andreas]

You have to turn on debug mode:

Place $debug = 1; in config.php.

Then go to ACP / vBulletin Options / vBulletin Options / Forum Display Options (forumdisplay) and click Add Setting

[ralphuk100]

Thanks - will install this hack now

[ralphuk100]

Im about half way into this hack....can it not be applied to individual forums? Thats really what I need...to be able to have the news forum sorted by created date and all others sorted by last post.

[Andreas]

Yes, it can be defined on a per-forum basis.

[ralphuk100]

I completed your hack fine, all instructions followed precisely and now I get this error when I try to view a forum:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT threadid
FROM thread AS thread

WHERE forumid = 27
AND sticky = 0
AND visible = 1




ORDER BY sticky DESC, DESC
LIMIT 0, 50

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC
LIMIT 0, 50' at line 11

mysql error number: 1064

Any ideas?

[ralphuk100]

UPDATE: The hack works fine but not by setting an option in forumdisplay. This gets errors (thought that was for global changes). If I define a sort order in the individual forum that forum is then ok. Any ideas?

Also - what var do I need to change to have dateline displayed in the last post column on a forum? Thanks.

UPDATE 2: Although updating an individual forums default sort stops errors it does not seem to obey the sort.....url to forums is www.southportforums.com/forumsvb3/ - have a look at news spot...should be sorted by article last post at the moment...obviously is not

[Andreas]

I guess there is a small mistake in the instructions
The default value in the database should be 0 instead of -1

[sql]ALTER TABLE forum CHANGE defsortfield defsortfield TINYINT( 1 ) DEFAULT 0 NOT NULL [/sql]
[sql]UPDATE forum SET defsortfield=0 WHERE defsortfield=-1[/sql]

Then edit any forum to rebuild the cache.
This should stop the SQL errors.