1
Hello,
I wanted to add "Latest Post" and "Newest Thread" to the newbb index page where the forums are listed. Here is what I added, please rigorize if needed.
In newbb_index.html (added to the Last Post cell):
Newest Thread: <a href="viewtopic.php?topic_id=<{$forum.forum_newest_thread_id}>&forum=<{$forum.forum_id}>"><{$forum.forum_newest_thread|truncate:25:"...":true}></a> by <{$forum.forum_newest_thread_creator}> <br /> Last Post: <a href="viewtopic.php?topic_id=<{$forum.forum_lastpost_id}>&forum=<{$forum.forum_id}>#forumpost<{$forum.forum_lastpost_thread_id}>">Re: <{$forum.forum_lastpost_thread|truncate:25:"...":true}></a> by <{$forum.forum_lastpost_user}>
In include/functions.php (anywhere is fine for these):
function newbb_getTopicNameFromId( $topic_id )
{
global $xoopsDB;
$query = "select topic_title FROM " . $xoopsDB -> prefix('bb_topics') . " WHERE topic_id = " . $topic_id . "";
$result = $xoopsDB -> query($query);
while (list($title) = $xoopsDB -> fetchRow($result))
{
$topic_name = $title;
}
return $topic_name;
}
function newbb_getNewestThread($forum_id){
$array = array();
global $xoopsDB;
$query = "select topic_title,topic_id,topic_poster FROM " . $xoopsDB -> prefix('bb_topics') . " WHERE forum_id = " . $forum_id . " ORDER BY topic_id DESC LIMIT 1";
$result = $xoopsDB -> query($query);
foreach(mysql_fetch_assoc($result) as $key => $value)
{
$array[$key] = $value;
}
return $array;
}
In forum.php (this goes in the function &display(&$forums_obj) at the bottom of the file, I added mine right above the line "$_forum_data['forum_lastpost_time'] = newbb_formatTimestamp($post_obj->getVar('post_time'));"):
$_forum_data['forum_lastpost_id'] = $post_obj->getVar("topic_id");
$_forum_data['forum_lastpost_thread'] = newbb_getTopicNameFromId($post_obj->getVar("topic_id"));
$_forum_data['forum_lastpost_thread_id'] = $forum_obj->getVar("forum_last_post_id");
$_newest_thread = newbb_getNewestThread($_forum_data["forum_id"]);
$_forum_data['forum_newest_thread'] = $_newest_thread["topic_title"];
$_forum_data['forum_newest_thread_id'] = $_newest_thread["topic_id"];
$_forum_data['forum_newest_thread_creator'] = $users_linked[$_newest_thread["topic_poster"]];
