Hi, I am using a miniBB installation for a dev board, and we had that desire to see edited post taken into account when sorting the topic list by Latest Replies.
I don't know about slowing down the database (as there is an index on topic_last_post_time already), and I admit we have a particular setup: a few members only discussing development issues (limiting the kind of things Ivan is referring to ;)), but on the code modifications side, that's very easy!!
I'll give the mods I've done below (based on miniBB 2.0 RC6b), if that can help someone else:
in bb_func_editmsg.php, line 74
-- REPLACE --------
if ($fif!=0) $errorMSG.=$l_topicTextUpdated."<br />";
-- BY ---------------
if ($fif!=0) { $errorMSG.=$l_topicTextUpdated."<br />"; $topic_last_post_id=$post; $topic_last_post_time='now()'; updateArray(array('topic_last_post_id','topic_last_post_time'),$Tt,'to pic_id',$topic); }
in bb_func_ldisc.php, line 21
-- REPLACE --------
if ($user_sort==1) $orderBy='topic_id DESC'; else $orderBy='topic_last_post_id DESC';
-- BY ---------------
if ($user_sort==1) $orderBy='topic_id DESC'; else $orderBy='topic_last_post_time DESC';
Thanks for the work you're doing on miniBB!! |