Sort topics Alphabetically

[Volksdevil]

Hi,

On my old 3.0.12 I had a simple snippet in the viewforum.php file that sorted Alphabetically in chosen forums

Code: Select all

// Sort topics alphabetically
if ($forum_id == 13 || $forum_id == 14 || $forum_id == 22)
{
    $sort_by_text = array('t' => $user->lang['SUBJECT']);
    $sort_by_sql = array('t' => 't.topic_title');
    $sort_dir = 'a';
}

Note the forum ID's ($forum_id == 13 || $forum_id == 14 || $forum_id == 22)

I've just tried it on 3.1.1 and it works perfectly, but is it worth having an extension for this rather than this small tweak to the core php?

[Volksdevil]

Well just in case no extension is made for this, I can confirm that the above code still works on 3.1.1 and now on 3.1.4 and still on 3.1.6

[divingbrit]

How many times can I post 'Thank you' that is just what I want to do

[ReinerKnudsen]

Hi, thanks for the snippet.

Where exactly in the viewforum.php would I place this code?

Thx. Reiner

[Volksdevil]

Hi,

Add the above code in my first post before:
// Limit topics to certain time frame, obtain correct topic count

[ReinerKnudsen]

Works like a charm. Thank you ever so much! Whoohoo!

Reiner

[RMcGirr83]

I would probably place it before this line

Code: Select all

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

because gen_sort_selects uses the variables that you are over riding.

There is no event set for changing those variables so no extension is possible.

[divingbrit]

Thanks again to Volksdevil, but also to RMcGirr83, for explanation why an extension would not be viable.

[systemcrack]

Hi,

On my old 3.0.12 I had a simple snippet in the viewforum.php file that sorted Alphabetically in chosen forums

Code: Select all

// Sort topics alphabetically
if ($forum_id == 13 || $forum_id == 14 || $forum_id == 22)
{
    $sort_by_text = array('t' => $user->lang['SUBJECT']);
    $sort_by_sql = array('t' => 't.topic_title');
    $sort_dir = 'a';
}

Note the forum ID's ($forum_id == [color=#BF0000][b]13[/b][/color] || $forum_id == [color=#BF0000][b]14[/b][/color] || $forum_id == [color=#BF0000][b]22[/b][/color])

I've just tried it on 3.1.1 and it works perfectly, but is it worth having an extension for this rather than this small tweak to the core php?

Excuse me.. I'm not very good with the codes, you could be more specific in describing the process in order to add it too, this change.

P.S.
is it possible to put the alphabetical order by default in all forums without stating the id?

[divingbrit]

You need a text editor, I use Notepad++, you must not use something like 'word' if you look at https://www.phpbb.com/mods/installing/ which gives you an overview.
So you change a file, then upload it via ftp, and overwrite the original file

As for "is it possible to put the alphabetical order by default in all forums without stating the id?" that would be nice, but I did change 79 forums

// Sort topics alphabetically
if ($forum_id == 15 || $forum_id == 16 || $forum_id == 17|| $forum_id == 18|| $forum_id == 21|| $forum_id == 22|| $forum_id == 23|| $forum_id == 24|| $forum_id == 25|| $forum_id == 26|| $forum_id == 27|| $forum_id == 28|| $forum_id == 29|| $forum_id == 30|| $forum_id == 31| etc etc etc

[systemcrack]

You need a text editor, I use Notepad++, you must not use something like 'word' if you look at https://www.phpbb.com/mods/installing/ which gives you an overview.
So you change a file, then upload it via ftp, and overwrite the original file

As for "is it possible to put the alphabetical order by default in all forums without stating the id?" that would be nice, but I did change 79 forums

// Sort topics alphabetically
if ($forum_id == 15 || $forum_id == 16 || $forum_id == 17|| $forum_id == 18|| $forum_id == 21|| $forum_id == 22|| $forum_id == 23|| $forum_id == 24|| $forum_id == 25|| $forum_id == 26|| $forum_id == 27|| $forum_id == 28|| $forum_id == 29|| $forum_id == 30|| $forum_id == 31| etc etc etc

ok thank's... maybe I had not explained well.. I know how to install a mod, I have a forum for 2 years.. I wanted to know which file to add the code, and where in the file enter the code.

Edit:
Only now I see that he speak of the file viewforum.php

Sorry... my bad english

[MadCon88]

This would be great as extension, please someone...

https://www.phpbb.com/customise/db/mod/ ... betically/ ( viewtopic.php?t=981865 )

[systemcrack]

+1

[systemcrack]

sorry error.. delete

[systemcrack]

Up

https://www.phpbb.com/customise/db/mod/ ... betically/ ( viewtopic.php?t=981865 )