Sort by latest reply

[Torstein]

I'm thinking of making a forum out of a few categories on my CNR installation, and for it to function as a normal forum, I'd like to sort the news (forum topics) by latest reply.

Something like:

Code: Select all

<?php
$number = "20";
$category = "Forum";
$sort = array ('latest_reply', 'DESC');
include ('show_news.php');
?>

Is there any way to do this?

[FI-DD]

1. Put this in a new file in the main CuteNews.RU directory and run in once:

Code: Select all

<?php
include('./head.php');

$sql->altertable(array(
         'table'     => 'news',
         'name'     => 'latest_comment',
         'action'  => 'insert',
         'values'  =>  array(
                         'type'      =>   'int',
                         'default'   =>   '0'
                        )
         ));

?>

Delete this file after running it.

2. Open inc/show.addcomment.php and change this:

Code: Select all

$sql->update(array(
'table'    => 'news',
'where'    => array("id = $id"),
'values' => array('comments' => count($sql->select(array('table' => 'comments', 'where' => array("post_id = $id")))))
));

to this:

Code: Select all

$sql->update(array(
'table'    => 'news',
'where'    => array("id = $id"),
'values' => array('comments' => count($sql->select(array('table' => 'comments', 'where' => array("post_id = $id")))),
               'latest_comment' => $time

            )
));

3. Open inc/mod/addnews.mdu and change this:

Code: Select all

'category' => $category,

to this:

Code: Select all

'category' => $category,
'latest_comment' => $added_time,

4. Now you can use $sort = array('latest_comment', 'DESC'); in your include code.

[Torstein]

Sorry for asking this before actually trying the code, but will this make the initial post count as a reply?

I mean if a thread has no replies, but was posted after the last reply in some other thread, will the thread with no replies still be displayed above the other?

[FI-DD]

Yep, that's the way it works now.

[erlendfl]

HellO!
Tried this mod, and it works perfectly.
Only one problem, when I combine this with the guest-can-add-news-hack the guest-added news shows up at the bottom, not on top.
I don't have that problem when I publish new articles from the admin-panel into the same include-code. I've tried figure it out, but all I'm doing is messing up the code.

Thanks for all your help!

[FI-DD]

You need to do step #3 in quest.php as well.

[erlendfl]

You need to do step #3 in quest.php as well.

Yes, I've already done that. But you see the problem is not if I post a comment there, it is when I just post news-articles from guest.php. If I use standard include-codes it is not a problem...

[scottdallas]

This seems to be working/functioning quite well. Thanks FI-DD

One thing that might be relevant to keep in mind while adding this to your cutenews.ru installation is that if you already have comments on your website they will not show up using this method of sorting. Only comments made AFTER this patch has been applied will follow these new rules. This is due to the new mysql stuff FI-DD did.

[erlendfl]

HellO!
Tried this mod, and it works perfectly.
Only one problem, when I combine this with the guest-can-add-news-hack the guest-added news shows up at the bottom, not on top.
I don't have that problem when I publish new articles from the admin-panel into the same include-code. I've tried figure it out, but all I'm doing is messing up the code.

Thanks for all your help!

Weird, I removed and added som code over and over again, and it suddenly worked. So problem solved

[scottdallas]

Haha I like your approach. Similar to murdering someone. Okay, I've been watching too much CSI. I just imagine you bashing your FTP repeatedly with the same file until it's finally a bloody mess and says okay fine I give up. You win.

Glad it's working.