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

[akm]

(03-14-2012 10:26 AM)ZiNgA BuRgA Wrote:  Yes, it is by lastpost as you can see from the query (note the ORDER BY clause):

SQL Code

1 2 3 4 5 6 7

SELECT t.*, tfd.`cl_` AS `xthreads_cl_`, tfd.`sl_` AS `xthreads_sl_`, tfd.`hrn_` AS `xthreads_hrn_`, tfd.`hrp_` AS `xthreads_hrp_`, tfd.`bp_` AS `xthreads_bp_`, tfd.`bpj_` AS `xthreads_bpj_`, tfd.`tow_` AS `xthreads_tow_`, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN `mybb_threadfields_data` tfd ON t.tid=tfd.tid WHERE t.fid='24' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20

---

If it's "cl_", then you need to use that as the key, ie sort by "tf_cl_"

Well, that seems to have done it, sorts correctly, and shows on the debug info accordingly, thanks much !

Guess just got confused with terminology 'names' and 'keys' in the undoc.

Seems almost like tf_ could be called a threadfilter 'prefix' or 'key' with cl_ the threadfield 'key', and the word 'name' just confuses the question... then tf_ used kinda like a template prefix with threadfield keys, ie tf_cl_

But then thats just me (an my beginner logic), am sure others understand better the way it is.

But for now, seems like the question is answered !