Right now the Recent Topics block sorts the most recent topics by the time the topic was started (topic_time) in the php code from what I can tell. I've been on other sites where this block keeps the original title of the post, but sorts the titles in the block by the last post time (not the original topic time). In other words isf someone posts a reply to a topic that is 3 or 4 down on the list in the block, the block bumps that title up to the top, so you know which topic has been replied to most recently - not when it was originally posted.
I've played around with the code and tried replacing topic_time with last_post_time and last_post but this does nothing but FUBAR the block and I'm lost.
/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com) */
/* http://phpnuke.org */
/* */
/* This is a 2 min hack of the old forum block to work with the phpBB2 */
/* port. */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
/* Additional security & Abstraction layer conversion */
/* 2003 chatserv */
/* http://www.nukefixes.com -- http://www.nukeresources.com */
/************************************************************************/
if (eregi("block-Forums.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
global $prefix, $db, $sitename;
$result = $db->sql_query("SELECT forum_id, topic_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_time DESC LIMIT 50");
All that seemed to do was reverse it. It showed the oldest topic posted first, then second oldest etc... posting a reply to any of the topics did nothing to change their position in the list.
What I'm looking for is something that will show the newest posts descending. So if someone hits a replies to a topic, that topic title gets bumped to the top of the list.
thareb Nuke Soldier
Joined: Feb 04, 2005
Posts: 18
Posted:
Wed Dec 28, 2005 8:28 am
Right now for instance the top ten topics in my list are:
Quote:
Battlegrounds
Blackfathom Deeps
7S Excel Bank Spreadsheet
Merry Christmas/Joyeux Noel!
Guild bank cash flow analysis
ANNOUNCEMENT: NEW BANKERS
Aaarrghhh!!
Who is Kaminori?
Mel Gibson hiding in the Apocalypto trailer
For the Horde!
So for instance if someone replies to the "Guild bank cash flow analysis" topic in the forums the block should then read:
Quote:
Guild bank cash flow analysis
Battlegrounds
Blackfathom Deeps
7S Excel Bank Spreadsheet
Merry Christmas/Joyeux Noel!
ANNOUNCEMENT: NEW BANKERS
Aaarrghhh!!
Who is Kaminori?
Mel Gibson hiding in the Apocalypto trailer
For the Horde!
thareb Nuke Soldier
Joined: Feb 04, 2005
Posts: 18
Posted:
Wed Dec 28, 2005 9:02 am
Okay I found this mod that does exactly what I want - but it scrolls. It's called Scrolling Forums Block 10.
Anyone know of a block that does what this one does without the scrolling?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
