• All Purchases made this month instantly go into the draw to win a USD $ 100.00 credit to your HoP account.
 

Forums > Help! > can i link to the most recent post in a thread?

Login/Join to Participate

simian


simian

110% MONKEY EVERY TIME ALL THE TIME JUST CANT STOP THE MONKEY
Location: London

Total posts: 3149
Posted: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 ---> hug


"Switching between different kinds of chuu chuu sometimes gives this "urgh wtf?" effect because it's giving people the phi phenomenon."

Delete Topic

Fire_Moose
SILVER Member since May 2007

Fire_Moose

Elusive and Bearded
Location: Scottsdale, AZ

Total posts: 3597
Posted:No.


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


O.B.E.S.E.

Owned by Mynci!

Delete

Richee
BRONZE Member since Jan 2002

HOP librarian
Location: Prague

Total posts: 1841
Posted: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


POI THEO(R)IST

Delete

simian


simian

110% MONKEY EVERY TIME ALL THE TIME JUST CANT STOP THE MONKEY
Location: London

Total posts: 3149
Posted:but thats the first post - i want to go to the last post frown

"Switching between different kinds of chuu chuu sometimes gives this "urgh wtf?" effect because it's giving people the phi phenomenon."

Delete

UCOF
SILVER Member since Apr 2002

UCOF

Carpal \'Tunnel


Total posts: 15414
Posted:You mean like this?
(cept that will link to your post, rather than this one)

Well.. actually.. I dont know. confused

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


Delete

Richee
BRONZE Member since Jan 2002

HOP librarian
Location: Prague

Total posts: 1841
Posted:Check yer PM.

light,

:R


POI THEO(R)IST

Delete

PK_
BRONZE Member since Dec 2001

PK_

Lambretta Fanatic


Total posts: 4991
Posted: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 wink .



Hugs my friend hug


PK.

"To be an angel, one need not have wings.
In giving love there is an equal grace.
Nor need one seek the aura in the face,
As love unveils the beauty of all things."

*Francois Couperin.

Delete

PK_
BRONZE Member since Dec 2001

PK_

Lambretta Fanatic


Total posts: 4991
Posted: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.


PK.

"To be an angel, one need not have wings.
In giving love there is an equal grace.
Nor need one seek the aura in the face,
As love unveils the beauty of all things."

*Francois Couperin.

Delete