Can i link to the most recent post in a thread?

can i link to the most recent post in a thread?

eg. a link that when people click on it will take them to the most recently posted reply in a particular thread. Rather than a link to the reply that is currently the most recent, but then won't be after someone else posts another one after it. Er. Yeah. That mostly made sense.

First helpful answer will WIN this fantabulous hug --->

No.


i actually dont know but assume no, i just wanted to hug a monkey

When you link a thread, but not the whole URL,
only to "..number=245252". Than the link will
jump to the first post of the thread.

hug for free,

:R

but thats the first post - i want to go to the last post

You mean like this?
(cept that will link to your post, rather than this one)

Well.. actually.. I dont know.

Im not sure how you find the post number out to link to it anyway..
Perhaps ask Dom to do some typing perhaps?

Check yer PM.

light,

:R

IMHO this is possible... as I will try to explain my reasons.

The site uses a SQL database... this is OK and can support quite large forums as we well know over the years and all thanks to Dom's input there in helping Malcolm getting it up and running.

A post is entered in to the database under a "post table" and that then references to a "tread table", also in that data there is the "poster", "date", "time" etcetera to link that post to what ever forum and thread it has to belong to.

So if:
forum = 34
Thread = 23798
Post = 2332484
That could be any thing!.

When a thread is made it creates a new reference in the SQL DB, so if 2345 was the last a new one would be 2346... the same goes for a POST, the post reference number will be entered in sequential form.

[Quote]<?php



include 'header.php';
$forum = isset($HTTP_GET_VARS['forum']) ? intval($HTTP_GET_VARS['forum']) : 0;
$topic_id = isset($HTTP_GET_VARS['topic_id']) ? intval($HTTP_GET_VARS['topic_id']) : 0;
if ( empty($forum) ) {
redirect_header('index.php',2,_MD_ERRORFORUM);
exit();
} elseif ( empty($topic_id) ) {
redirect_header('viewforum.php?forum='.$forum,2,_MD_ERRORTOPIC);
exit();
}
$topic_time = (isset($HTTP_GET_VARS['topic_time'])) ? intval($HTTP_GET_VARS['topic_time']) : 0;
$post_id = !empty($HTTP_GET_VARS['post_id']) ? intval($HTTP_GET_VARS['post_id']) : 0;

//use users preferences
if (is_object($xoopsUser)) {
$viewmode = $xoopsUser->getVar('umode');
$order = ($xoopsUser->getVar('uorder') == 1) ? 'DESC' : 'ASC';
} else {
$viewmode = 'flat';
$order = 'ASC';
}

// newbb does not have nested mode
if ($viewmode == 'nest') {
$viewmode = 'thread';
}

// override mode/order if any requested
if (isset($HTTP_GET_VARS['viewmode']) && ($HTTP_GET_VARS['viewmode'] == 'flat' || $HTTP_GET_VARS['viewmode'] == 'thread')) {
$viewmode = $HTTP_GET_VARS['viewmode'];
}
if (isset($HTTP_GET_VARS['order']) && ($HTTP_GET_VARS['order'] == 'ASC' || $HTTP_GET_VARS['order'] == 'DESC')) {
$order = $HTTP_GET_VARS['order'];
}

if ($viewmode != 'flat') {
$xoopsOption['template_main'] = 'forum_viewtopic_thread.html';
} else {
$xoopsOption['template_main'] = 'forum_viewtopic_flat.html';
}

include XOOPS_ROOT_PATH.'/header.php';
include_once 'class/class.forumposts.php';

if ( isset($HTTP_GET_VARS['move']) && 'next' == $HTTP_GET_VARS['move'] ) {
$sql = 'SELECT t.topic_id, t.topic_title, t.topic_time, t.topic_status, t.topic_sticky, t.topic_last_post_id, f.forum_id, f.forum_name, f.forum_access, f.forum_type, f.allow_html, f.allow_sig, f.posts_per_page, f.hot_threshold, f.topics_per_page FROM '.$xoopsDB->prefix('forum_topics').' t LEFT JOIN '.$xoopsDB->prefix('forum_forums').' f ON f.forum_id = t.forum_id WHERE t.topic_time > '.$topic_time.' AND t.forum_id = '.$forum.' ORDER BY t.topic_time ASC LIMIT 1';
} elseif ( isset($HTTP_GET_VARS['move']) && 'prev' == $HTTP_GET_VARS['move']) {
$sql = 'SELECT t.topic_id, t.topic_title, t.topic_time, t.topic_status, t.topic_sticky, t.topic_last_post_id, f.forum_id, f.forum_name, f.forum_access, f.forum_type, f.allow_html, f.allow_sig, f.posts_per_page, f.hot_threshold, f.topics_per_page FROM '.$xoopsDB->prefix('forum_topics').' t LEFT JOIN '.$xoopsDB->prefix('forum_forums').' f ON f.forum_id = t.forum_id WHERE t.topic_time < '.$topic_time.' AND t.forum_id = '.$forum.' ORDER BY t.topic_time DESC LIMIT 1';
} else {
$sql = 'SELECT t.topic_id, t.topic_title, t.topic_time, t.topic_status, t.topic_sticky, t.topic_last_post_id, f.forum_id, f.forum_name, f.forum_access, f.forum_type, f.allow_html, f.allow_sig, f.posts_per_page, f.hot_threshold, f.topics_per_page FROM '.$xoopsDB->prefix('forum_topics').' t LEFT JOIN '.$xoopsDB->prefix('forum_forums').' f ON f.forum_id = t.forum_id WHERE t.topic_id = '.$topic_id.' AND t.forum_id = '.$forum;
}

if ( !$result = $xoopsDB->query($sql) ) {
redirect_header('viewforum.php?forum='.$forum,2,_MD_ERROROCCURED);
exit();
}

if ( !$forumdata = $xoopsDB->fetchArray($result) ) {
redirect_header('viewforum.php?forum='.$forum,2,_MD_FORUMNOEXIST);
exit();
}
$xoopsTpl->assign('topic_id', $forumdata['topic_id']);
$topic_id = $forumdata['topic_id'];
$xoopsTpl->assign('forum_id', $forumdata['forum_id']);
$forum = $forumdata['forum_id'];
$can_post = 0;
$show_reg = 0;
if ( $forumdata['forum_type'] == 1 ) {
// this is a private forum.
$accesserror = 0;
if ( $xoopsUser ) {
if ( !$xoopsUser->isAdmin($xoopsModule->mid()) ) {
if ( !check_priv_forum_auth($xoopsUser->getVar('uid'), $forum, false) ) {
$accesserror = 1;
}
} else {
$isadminormod = 1;
}
} else {
$accesserror = 1;
}
if ( $accesserror == 1 ) {
redirect_header("index.php",2,_MD_NORIGHTTOACCESS);
exit();
}
$can_post = 1;
$show_reg = 1;
} else {
// this is not a priv forum
if ( $forumdata['forum_access'] == 1 ) {
// this is a reg user only forum
if ( $xoopsUser ) {
$can_post = 1;
} else {
$show_reg = 1;
}
} elseif ( $forumdata['forum_access'] == 2 ) {
// this is an open forum
$can_post = 1;
} else {
// this is an admin/moderator only forum
if ( $xoopsUser ) {
if ( $xoopsUser->isAdmin($xoopsModule->mid()) || is_moderator($forum, $xoopsUser->getVar('uid')) ) {
$can_post = 1;
$isadminormod = 1;
}
}
}
}
$myts =& MyTextSanitizer::getInstance();
$forumdata['topic_title'] = $myts->makeTboxData4Show($forumdata['topic_title']);$forumdata['forum_name'] = $myts->makeTboxData4Show($forumdata['forum_name']);
$xoopsTpl->assign(array('topic_title' => '<a href="'.$bbUrl['root'].'viewtopic.php?viewmode='.$viewmode.'&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'">'.$forumdata['topic_title'].'</a>', 'forum_name' => $forumdata['forum_name'], 'topic_time' => $forumdata['topic_time'], 'lang_nexttopic' => _MD_NEXTTOPIC, 'lang_prevtopic' => _MD_PREVTOPIC));

// add image links to admin page if the user viewing this page is a forum admin
if ( $xoopsUser ) {
$xoopsTpl->assign('viewer_userid', $xoopsUser->getVar('uid'));
if ( !empty($isadminormod) || $xoopsUser->isAdmin($xoopsModule->mid()) || is_moderator( $forum, $xoopsUser->getVar('uid')) ) {
// yup, the user is admin
// the forum is locked?
if ( $forumdata['topic_status'] != 1 ) {
// nope
$xoopsTpl->assign('topic_lock_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=lock&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['locktopic'].'" alt="'._MD_LOCKTOPIC.'" /></a>');
} else {
// yup, it is..
$xoopsTpl->assign('topic_lock_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=unlock&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['unlocktopic'].'" alt="'._MD_UNLOCKTOPIC.'" /></a>');
}
$xoopsTpl->assign('topic_move_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=move&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['movetopic'].'" alt="'._MD_MOVETOPIC.'" /></a>');
$xoopsTpl->assign('topic_delete_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=del&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['deltopic'].'" alt="'._MD_DELETETOPIC.'" /></a>');
// is the topic sticky?
if ( $forumdata['topic_sticky'] != 1 ) {
// nope, not yet..
$xoopsTpl->assign('topic_sticky_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=sticky&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['sticky'].'" alt="'._MD_STICKYTOPIC.'" /></a>');
} else {
// yup it is sticking..
$xoopsTpl->assign('topic_sticky_image', '<a href="'.$bbUrl['root'].'topicmanager.php?mode=unsticky&amp;topic_id='.$topic_id.'&amp;forum='.$forum.'"><img src="'.$bbImage['unsticky'].'" alt="'._MD_UNSTICKYTOPIC.'" /></a>');
}
// need to set this also
$xoopsTpl->assign('viewer_is_admin', true);
} else {
// nope, the user is not a forum admin..
$xoopsTpl->assign('viewer_is_admin', false);
}
} else {
// nope, the user is not a forum admin, not even registered
$xoopsTpl->assign(array('viewer_is_admin' => false, 'viewer_userid' => 0));
}

function showTree(&$arr, $current=0, $key=0, $prefix='', $foundusers=array()){
global $xoopsConfig;
if ($key != 0) {
if ( 0 != $arr[$key]['obj']->uid() ) {
if (!isset($foundusers[$arr[$key]['obj']->uid()])) {
$eachposter = new XoopsUser($arr[$key]['obj']->uid());
$foundusers[$arr[$key]['obj']->uid()] =& $eachposter;
} else {
$eachposter =& $foundusers[$arr[$key]['obj']->uid()];
}
$poster_rank = $eachposter->rank();
if ( $poster_rank['image'] != '' ) {
$poster_rank['image'] = '<img src="'.XOOPS_UPLOAD_URL.'/'.$poster_rank['image'].'" alt="" />';
}
if ( $eachposter->isActive() ) {
$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$eachposter->getVar('uid').'">'.$eachposter->getVar('uname').'</a>');
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous']);
}
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous']);
}
$posticon = $arr[$key]['obj']->icon();
if ( isset($posticon) && $posticon != '' ) {
$post_image = '<img src="'.XOOPS_URL.'/images/subject/'.$posticon.'" alt="" />';
} else {
$post_image = '<img src="'.XOOPS_URL.'/images/icons/no_posticon.gif" alt="" />';
}
if ($current != $key) {
$subject = '<a href="viewtopic.php?viewmode=thread&amp;topic_id='.$arr[$key]['obj']->topic().'&amp;forum='.$arr[$key]['obj']->forum().'&amp;post_id='.$arr[$key]['obj']->postid().'#'.$arr[$key]['obj']->postid().'">'.$arr[$key]['obj']->subject().'</a>';
$GLOBALS['xoopsTpl']->append("topic_trees", array_merge($posterarr, array("post_id" => $arr[$key]['obj']->postid(), "post_parent_id" => $arr[$key]['obj']->parent(), "post_date" => formatTimestamp($arr[$key]['obj']->posttime(), "m"), "post_image" => $post_image, "post_title" => $subject, "post_prefix" => $prefix)));
} else {
$subject = '<b>'.$arr[$key]['obj']->subject().'</b>';
$thisprefix = substr($prefix, 0, -6)."<b>&raquo;</b>";
$GLOBALS['xoopsTpl']->append("topic_trees", array_merge($posterarr, array("post_id" => $arr[$key]['obj']->postid(), "post_parent_id" => $arr[$key]['obj']->parent(), "post_date" => formatTimestamp($arr[$key]['obj']->posttime(), "m"), "post_image" => $post_image, "post_title" => $subject, "post_prefix" => $thisprefix)));
}
}
if ( isset($arr[$key]['replies']) && !empty($arr[$key]['replies']) ){
$prefix .= "&nbsp;&nbsp;";
foreach($arr[$key]['replies'] as $replykey) {
$current = ( $current == 0 ) ? $replykey : $current;
showTree($arr, $current, $replykey, $prefix, $foundusers);
}
}
}

if ($order == 'DESC') {
$xoopsTpl->assign(array('order_current' => 'DESC', 'order_other' => 'ASC', 'lang_order_other' => _OLDESTFIRST));
} else {
$xoopsTpl->assign(array('order_current' => 'ASC', 'order_other' => 'DESC', 'lang_order_other' => _NEWESTFIRST));
}

// initialize the start number of select query
$start = !empty($HTTP_GET_VARS['start']) ? intval($HTTP_GET_VARS['start']) : 0;

$total_posts = get_total_posts($topic_id, 'topic');
if ($total_posts > 50) {
$viewmode ="flat";
// hide link to theaded view
$xoopsTpl->assign('lang_threaded', "" );
$xoopsTpl->assign('lang_flat', _FLAT );
} else {
$xoopsTpl->assign(array('lang_threaded' => _THREADED, 'lang_flat' => _FLAT));
}

if ( $can_post == 1 ) {
$xoopsTpl->assign(array('viewer_can_post' => true, 'forum_post_or_register' => "<a href=\"newtopic.php?forum=".$forum."\"><img src=\"".$bbImage['post']."\" alt=\""._MD_POSTNEW."\" /></a>"));
} else {
$xoopsTpl->assign('viewer_can_post', false);
if ( $show_reg == 1 ) {
$xoopsTpl->assign('forum_post_or_register', '<a href="'.XOOPS_URL.'/user.php?xoops_redirect='.htmlspecialchars($xoopsRequestUri).'">'._MD_REGTOPOST.'</a>');
} else {
$xoopsTpl->assign('forum_post_or_register', '');
}
}

if ( $viewmode == "thread" ) {
$start = 0;
$postsArray = ForumPosts::getAllPosts($topic_id, "ASC", $total_posts, $start);
$xoopsTpl->assign('topic_viewmode', 'thread');

$newObjArr = array();
foreach ( $postsArray as $eachpost ) {
$key1 = $eachpost->postid();
if ( (!empty($post_id) && $post_id == $key1) || ( empty($post_id) && $eachpost->parent() == 0 ) ) {
$post_text = $eachpost->text();
if ( 0 != $eachpost->uid() ) {
$eachposter = new XoopsUser($eachpost->uid());
$poster_rank = $eachposter->rank();
if ( $poster_rank['image'] != "" ) {
$poster_rank['image'] = "<img src='".XOOPS_UPLOAD_URL."/".$poster_rank['image']."' alt='' />";
}
if ( $eachposter->isActive() ) {
$poster_status = $eachposter->isOnline() ? _MD_ONLINE : '';
$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$eachposter->getVar('uid').'">'.$eachposter->getVar('uname').'</a>', 'poster_avatar' => $eachposter->getVar('user_avatar'), 'poster_from' => $eachposter->getVar('user_from'), 'poster_regdate' => formatTimestamp($eachposter->getVar('user_regdate'), 's'), 'poster_postnum' => $eachposter->getVar('posts'), 'poster_sendpmtext' => sprintf(_SENDPMTO,$eachposter->getVar('uname')), 'poster_rank_title' => $poster_rank['title'], 'poster_rank_image' => $poster_rank['image'], 'poster_status' => $poster_status);
if ( 1 == $forumdata['allow_sig'] && $eachpost->attachsig() == 1 && $eachposter->attachsig() == 1 ) {
$myts =& MytextSanitizer::getInstance();
$post_text .= "<p><br />----------------<br />". $myts->makeTareaData4Show($eachposter->getVar("user_sig", "N"), 0, 1, 1)."</p>";
}
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous'], 'poster_avatar' => '', 'poster_from' => '', 'poster_regdate' => '', 'poster_postnum' => '', 'poster_sendpmtext' => '', 'poster_rank_title' => '', 'poster_rank_image' => '');
}
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous'], 'poster_avatar' => '', 'poster_from' => '', 'poster_regdate' => '', 'poster_postnum' => '', 'poster_sendpmtext' => '', 'poster_rank_title' => '', 'poster_rank_image' => '');
}
$posticon = $eachpost->icon();
if ( isset($posticon) && $posticon != '' ) {
$post_image = '<a name="'.$eachpost->postid().'"><img src="'.XOOPS_URL.'/images/subject/'.$eachpost->icon().'" alt="" /></a>';
} else {
$post_image = '<a name="'.$eachpost->postid().'"><img src="'.XOOPS_URL.'/images/icons/posticon.gif" alt="" /></a>';
}
$xoopsTpl->append('topic_posts', array_merge($posterarr, array('post_id' => $eachpost->postid(), 'post_parent_id' => $eachpost->parent(), 'post_date' => formatTimestamp($eachpost->posttime(), 'm'), 'post_poster_ip'=> $eachpost->posterip(), 'post_image' => $post_image, 'post_title' => $eachpost->subject(), 'post_text' => $post_text)));
}
$newObjArr[$key1]['obj'] = $eachpost;
$key2 = $eachpost->parent();
$newObjArr[$key2]['replies'][] = $key1;
$newObjArr[$key2]['leaf'] = $key1;
}
showTree($newObjArr, $post_id);
$xoopsTpl->assign(array('lang_subject' => _MD_SUBJECT, 'lang_date' => _MD_DATE));
} else {
$xoopsTpl->assign(array('topic_viewmode' => 'flat', 'lang_top' => _MD_TOP, 'lang_subject' => _MD_SUBJECT, 'lang_bottom' => _MD_BOTTOM));
$postsArray = ForumPosts::getAllPosts($topic_id, $order, $forumdata['posts_per_page'], $start, $post_id);
$foundusers = array();
foreach ( $postsArray as $eachpost ) {
$post_text = $eachpost->text();
if ( 0 != $eachpost->uid() ) {
if (!isset($foundusers['user'.$eachpost->uid()])) {
$eachposter = new XoopsUser($eachpost->uid());
$foundusers['user'.$eachpost->uid()] =& $eachposter;
} else {
$eachposter =& $foundusers['user'.$eachpost->uid()];
}
$poster_rank = $eachposter->rank();
if ( $poster_rank['image'] != '' ) {
$poster_rank['image'] = '<img src="'.XOOPS_UPLOAD_URL.'/'.$poster_rank['image'].'" alt="" />';
}
if ( $eachposter->isActive() ) {
$poster_status = $eachposter->isOnline() ? _MD_ONLINE : '';
$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$eachposter->getVar('uid').'">'.$eachposter->getVar('uname').'</a>', 'poster_avatar' => $eachposter->getVar('user_avatar'), 'poster_from' => $eachposter->getVar('user_from'), 'poster_regdate' => formatTimestamp($eachposter->getVar('user_regdate'), 's'), 'poster_postnum' => $eachposter->getVar('posts'), 'poster_sendpmtext' => sprintf(_SENDPMTO,$eachposter->getVar('uname')), 'poster_rank_title' => $poster_rank['title'], 'poster_rank_image' => $poster_rank['image'], 'poster_status' => $poster_status);
if ( 1 == $forumdata['allow_sig'] && $eachpost->attachsig() == 1 && $eachposter->attachsig() == 1 ) {
$myts =& MytextSanitizer::getInstance();
$post_text .= '<p><br />----------------<br />'. $myts->makeTareaData4Show($eachposter->getVar('user_sig', 'N'), 0, 1, 1).'</p>';
}
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous'], 'poster_avatar' => '', 'poster_from' => '', 'poster_regdate' => '', 'poster_postnum' => '', 'poster_sendpmtext' => '', 'poster_rank_title' => '', 'poster_rank_image' => '');
}
} else {
$posterarr = array('poster_uid' =>0, 'poster_uname' => $xoopsConfig['anonymous'], 'poster_avatar' => '', 'poster_from' => '', 'poster_regdate' => '', 'poster_postnum' => '', 'poster_sendpmtext' => '', 'poster_rank_title' => '', 'poster_rank_image' => '');
}
$posticon = $eachpost->icon();
if ( isset($posticon) && $posticon != '' ) {
$post_image = '<a name="'.$eachpost->postid().'"><img src="'.XOOPS_URL.'/images/subject/'.$eachpost->icon().'" alt="" /></a>';
} else {
$post_image = '<a name="'.$eachpost->postid().'"><img src="'.XOOPS_URL.'/images/icons/no_posticon.gif" alt="" /></a>';
}
$xoopsTpl->append('topic_posts', array_merge($posterarr, array('post_id' => $eachpost->postid(), 'post_parent_id' => $eachpost->parent(), 'post_date' => formatTimestamp($eachpost->posttime(), 'm'), 'post_poster_ip'=> $eachpost->posterip(), 'post_image' => $post_image, 'post_title' => $eachpost->subject(), 'post_text' => $post_text)));
unset($eachposter);
}
if ( $total_posts > $forumdata['posts_per_page'] ) {
include XOOPS_ROOT_PATH.'/class/pagenav.php';
$nav = new XoopsPageNav($total_posts, $forumdata['posts_per_page'], $start, "start", 'topic_id='.$topic_id.'&amp;forum='.$forum.'&amp;viewmode='.$viewmode.'&amp;order='.$order);
$xoopsTpl->assign('forum_page_nav', $nav->renderNav(4));
} else {
$xoopsTpl->assign('forum_page_nav', '');
}
}

// create jump box
$xoopsTpl->assign(array('forum_jumpbox' => make_jumpbox($forum), 'lang_forum_index' => sprintf(_MD_FORUMINDEX,$xoopsConfig['sitename']), 'lang_from' => _MD_FROM, 'lang_joined' => _MD_JOINED, 'lang_posts' => _MD_POSTS, 'lang_poster' => _MD_POSTER, 'lang_thread' => _MD_THREAD, 'lang_edit' => _EDIT, 'lang_delete' => _DELETE, 'lang_reply' => _REPLY, 'lang_postedon' => _MD_POSTEDON));

// Read in cookie of 'lastread' times
$topic_lastread = forum_get_topics_viewed();
// if cookie is not set for this topic, update view count and set cookie
if ( empty($topic_lastread[$topic_id]) ) {
$sql = 'UPDATE '.$xoopsDB->prefix('forum_topics').' SET topic_views = topic_views + 1 WHERE topic_id ='. $topic_id;
$xoopsDB->queryF($sql);
}
// Update cookie
forum_add_topics_viewed($topic_lastread, $topic_id, time(), $bbCookie['path'], $bbCookie['domain'], $bbCookie['secure']);
include XOOPS_ROOT_PATH.'/footer.php';
?>
[/Quote]

As you can see from the PHP as it calls to Fetch the last posts in the forums, you could easily look at the PHP coding for the forum here and call the last posts in the same way from another site.

Another way that you could do it is by displaying a site from within one of your websites modules if you have a Content Management System, I know that Joomla comes with such a module as standard, so you could always talk with Mech about those features... as in my opinion that would be the more simpler way of doing things, thus keeping your users on your site and not linking directly to another and loosing your users to that site.

Yet another way you could do this is via RSS Feeds and display those from your site as latest news items.

As I do not understand what you are doing I can only advise the above, I hope that in some way this helps and that I win some miraculous prize too .

Hugs my friend

That code will do you no good unless your using Xoops CMS.

I forgot to mention that you'd have to use a wildcard type code to get the latest post! as say topic 3456 has the last post number as 21213 there is no chance really that the next reply will be 21214... plus I don't know how to access the HoP DB from another site to do this, you'd have to speak with Dom on that one.