Static Topics

[kenny]

These 2 little code snippets allow you to change the way topics are ordered in your forums.
The 1st snippet changes all forums and the 2nd allows you to customise which forums stay static.
By static, I mean the order in which the topics were created - topic_time

Code: Select all

Snippet 1
---------

OPEN: viewforum.php

FIND:
-----
$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

REPLACE WITH:
-------------
$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

Code: Select all

Snippet 2
---------

OPEN: viewforum.php

FIND:
-----
$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

REPLACE WITH:
-------------
$static_forums = array("1", "2", "3"); // replace 1, 2, 3 with your forum ID's. Add/remove as necessary

if (in_array($forum_id, $static_forums))
{
   $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');
}
else
{
   $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');
}

You can add/remove forum id's as necessary


[kenny]

Updated the code for Snippet 2 - little bit more efficient

Code: Select all

This code has now been updated in the 1st post - please see the 1st post for the updated Snippet 2


[kenny]

I should also note that I have this little snippet installed on this board as a test and deomstration.
The array currently holds 1 forum id - 2 (Announcements forum) .
So you'll see that although my reply is later than the post at the top, the topic doesn't move as the sort is based on 1st post time

[kenny]

Stickified so people understand why this forum is like it is

Edit: This forum is no longer static (as of 22/05/2009)

[Hubble]

I can't find anywhere the code in order to update the Snippet 2.
I managed to change the first code in Snippet 2, but I also want to update... if you say it is a lill' more efficient.
Thank you! Hope you will help me

[kenny]

The code in the 1st post for Snippet 2, is the more efficient code.
The code in the 2nd post, was for people who had already grabbed the old stuff
I'll update my posts to reflect that

[ghostt]

hallo this is a very good snippet i use it for long time.
now i want to know if it would be possible to sort the Subforums alphabetically.

rgds

[kenny]

It is with this MOD

[ghostt]

thank you but i need this for subforums. if i create some new subforums in an eypacialy forum they have to be in a row alphabeticaly from a-z

maybe you know a Code Snippets for it

[kenny]

Ah, I read forums as topics sorry. I don't know of any Snippets or MODs to do this I'm afraid. I'm thinking that it may be slightly hard to accomplish, just going by the way that forums are displayed. You can re-arrange them manually in the ACP - might be worth biting the bullet now and sorting them, then if you add a forum later on you only have to move that one