vb.org Archive - Global Sort Order, Override?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Global Sort Order, Override? (https://vborg.vbsupport.ru/showthread.php?t=161958)

Global Sort Order, Override?

Hey guys, looking for a little programming help. I am trying to edit the forumdisplay.php to make all my forums/threads/etc show up alphabetical order, descending order (a,b,c,d,e,.,.,.).

I have located the code, just unsure what changes need to be made? There seems to be 2 different default sort options in the code?

PHP Code:


		
			
    // default sorting methods
    if (empty($sortfield))
    {
        $sortfield = $foruminfo['defaultsortfield']; <-- Edit?
    }
    if (empty($vbulletin->GPC['sortorder']))
    {
        $vbulletin->GPC['sortorder'] = $foruminfo['defaultsortorder'];  <-- Edit?
    }

    // look at sorting options:
    if ($vbulletin->GPC['sortorder'] != 'asc')
    {
        $sqlsortorder = 'DESC';
        $order = array('desc' => 'selected="selected"');
        $vbulletin->GPC['sortorder'] = 'desc';
    }
    else
    {
        $sqlsortorder = '';
        $order = array('asc' => 'selected="selected"');
    }

    switch ($sortfield)
    {
        case 'title':
            $sqlsortfield = 'thread.title';
            break;
        case 'lastpost':
            $sqlsortfield = 'lastpost';
            break;
        case 'replycount':
        case 'views':
        case 'postusername':
            $sqlsortfield = $sortfield;
            break;
        case 'voteavg':
            if ($foruminfo['allowratings'])
            {
                $sqlsortfield = 'voteavg';
                break;
            }
        case 'dateline':
            $sqlsortfield = 'thread.dateline';
            break;
        // else, use last post
        default:
            $handled = false;
            ($hook = vBulletinHook::fetch_hook('forumdisplay_sort')) ? eval($hook) : false;
            if (!$handled)
            {
                $sqlsortfield = 'lastpost';  <-- Edit?
                $sortfield = 'lastpost';  <-- Edit?
            }

I think i need to change all or just one/two of the options highlighted, just unsure what to change them to? Any help would be appreciated.

I did a lot of experimentation buy I only got as far as sorting them in ascending order (backwards, e,d,c,b,a). I am a newb, forgive me. :)

Just edit your forum and set the default sort field to 'Thread Title'.

Quote:

Originally Posted by Analogpoint (Post 1376247)

Just edit your forum and set the default sort field to 'Thread Title'.

I know about this but I am not going to go back and change it for a couple hundred forums. I prefer to do it this way. Can you help?

Sure, you could do it by editing the file, or with a plugin, but it's going to be a lot easier to just run the following 2 lines (as separate SQL queries) (vB ACP -> Maintenance -> Execute SQL Query)

[sql]UPDATE forum SET defaultsortfield = 'title'[/sql]

[sql]UPDATE forum SET defaultsortorder = 'asc'[/sql]

Then run "Rebuild Forum Information" in ACP -> Maintenance -> Update Counters.

Quote:

Originally Posted by Analogpoint (Post 1376469)

Thanks but is this reversible? I want a solution that is completely reversible if need be. I would prefer to edit the file whereas if I would like to change it all I have to do is upload the original.

To make these queries reversable i would just have to change it to

[sql]UPDATE forum SET defaultsortfield = 'lastpost'[/sql]

[sql]UPDATE forum SET defaultsortorder = 'desc'[/sql]

Correct?

Quote:

Originally Posted by Booost This (Post 1376705)

To make these queries reversable i would just have to change it to

[sql]UPDATE forum SET defaultsortfield = 'lastpost'[/sql]

[sql]UPDATE forum SET defaultsortorder = 'desc'[/sql]

Correct?

That's correct, that would set them back to the default vB order, where the threads with new posts are on top.

Quote:

Originally Posted by Analogpoint (Post 1376986)

That's correct, that would set them back to the default vB order, where the threads with new posts are on top.

Thank you very much, I executed the queries and rebuilt the forum info and it seems to have worked, is there any way to override this in one or two forums back to sort by last post? (DESC).

I tried to just set the forum in the forum manager but it didn't work.

Quote:

Originally Posted by Booost This (Post 1377053)

It should work, I just tested it. In the Forum Manager, edit the forum in question, and set the 'Default Sort Field' to Last Post Time, and set the 'Default Sort Order' to Descending. Then save the forum.

is there away to do this just in certain topics / threads/ cats

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01010 seconds Memory Usage 1,754KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: