Question Sort threads by creation date and not by most recent post?

Hello all,
Thank you for any help in advance. What I am trying to do is sort the thread order by the creation date of the thread rather than the most recent post inside that thread... if that makes sense. I have done quite a bit of redesign on the template but can't seem to find a way to do this little trick.

Below is an image of what I am trying to do... I have outlined in green what I am trying to sort by and the red how it is currently being sorted.


Again, thank you so much for any help!

I've had this up for quite some time, just wanted to bump this topic as its received no reply yet. I really need some sort of idea of how this can be done or IF it is not possible at all.

If it is not possible, is there a way to do custom sticky ordering as there is with phpBB?

Thanks

It should be pretty easy -- just change tiny bit in (ORDER BY) in SQL query. The problem is that it probably needs to be configurable?

Custom sticky ordering is also possible, but missing GUI. If you have ordering=2,3 etc, they are sorted from largest to smallest. Unfortunately as there's no way to do it from Kunena, it must be done from phpmyadmin. Or create own page for it..

Hello Matias,
Thank you for pointing me in that direction, I wouldnt have thought about doing it from the database specifically. Would you happen to know what table I would be looking in? jos_categories perhaps? Is there maybe a tutorial on that somewhere or could you give me a little more information on how I could go about setting that?

As always your help is greatly appreciated

Hello,

look in components\com_kunena\template\default_ex\latestx.php, you need to find the right query and add/change the order with the value that you want for order the topics by creation date.

OK, thank you for that information. I will try that tonight and report back.

Thanks again for the assistance

OK, so I opened up the latestx.php file but I can't make heads nor tales of it. Forgive my lack of intelligence, I am still learning the ins and outs of all this. Could you possibly point me in the right direction? I believe you are talking about this line, but I am probably wrong (starting to feel pretty stupid):

Hi,

try in this way
BTW: you are using outdated kunena, update is always recommended.

Hi @quila,
Thank you for that, I tried your suggestion but did not see any change in the on page ordering.

Thank you for informing me of the update also