[Solved] Display/Sort forum threadlist with xthread field ?

[akm]

(03-14-2012 07:21 AM)ZiNgA BuRgA Wrote:  You can check MyBB's debug page ("advanced details" link at bottom of each page) and see if the query is sorting by the thread field.

Interesting, thank you for the direction !
Am not sure how to interpret the debug info.
Have attached a PDF copy.

In the sample case in this thread, the sorting threadfield key was ct_ .
In this real case (the PDF) it is cl_ , along with several other customfields... sl_, hrn_, hrp_, bp_, bpg_, and tow_  (not used in sorting).
The templateprefix is cr_.

The sorting is setup (theoretically) to be done with either the 'subject' or 'cl_' .
The test of 'subject' sorting is working, but the cl_ is not... actually it acts like it is being sorted by post date.

Hopefully you have a chance to take a look at the PDF and pass on some clue/s.
Can see Sort Queries with (among other things) threadfield 'keys' and with 'lastpost' (default shown at forumdisplay.php, whatever that means)...

Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

// Sort by which field? if(!isset($mybb->input['sortby']) && !empty($foruminfo['defaultsortby'])) { $mybb->input['sortby'] = $foruminfo['defaultsortby']; } $t = "t."; $sortby = htmlspecialchars($mybb->input['sortby']); switch($mybb->input['sortby']) { case "subject": $sortfield = "subject"; break; case "replies": $sortfield = "replies"; break; case "views": $sortfield = "views"; break; case "starter": $sortfield = "username"; break; case "rating": $t = ""; $sortfield = "averagerating"; $sortfield2 = ", t.totalratings DESC"; break; case "started": $sortfield = "dateline"; break; default: $sortby = "lastpost"; $sortfield = "lastpost"; $mybb->input['sortby'] = "lastpost"; break; }

---