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

Posted: 18 years ago
No.


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

O.B.E.S.E.

Owned by Mynci!

Posted: 18 years ago
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

Posted: 18 years ago
but thats the first post - i want to go to the last post

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

Posted: 18 years ago
[Old link]
(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?

Posted: 18 years ago
Check yer PM.

light,

:R

POI THEO(R)IST

Posted: 18 years ago
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]






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' => ''.$forumdata['topic_title'].'', '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', '');

} else {

// yup, it is..

$xoopsTpl->assign('topic_lock_image', '');

}

$xoopsTpl->assign('topic_move_image', '');

$xoopsTpl->assign('topic_delete_image', '');

// is the topic sticky?

if ( $forumdata['topic_sticky'] != 1 ) {

// nope, not yet..

$xoopsTpl->assign('topic_sticky_image', '');

} else {

// yup it is sticking..

$xoopsTpl->assign('topic_sticky_image', '');

}

// 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'] = '';

}

if ( $eachposter->isActive() ) {

$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => ''.$eachposter->getVar('uname').'');

} 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 = '';

} else {

$post_image = '';

}

if ($current != $key) {

$subject = ''.$arr[$key]['obj']->subject().'';

$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 = ''.$arr[$key]['obj']->subject().'';

$thisprefix = substr($prefix, 0, -6)."»";

$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 .= "  ";

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' => ""));

} else {

$xoopsTpl->assign('viewer_can_post', false);

if ( $show_reg == 1 ) {

$xoopsTpl->assign('forum_post_or_register', ''._MD_REGTOPOST.'');

} 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'] = "";

}

if ( $eachposter->isActive() ) {

$poster_status = $eachposter->isOnline() ? _MD_ONLINE : '';

$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => ''.$eachposter->getVar('uname').'', '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 .= "

----------------
". $myts->makeTareaData4Show($eachposter->getVar("user_sig", "N"), 0, 1, 1)."

";

}

} 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 = '';

} else {

$post_image = '';

}

$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'] = '';

}

if ( $eachposter->isActive() ) {

$poster_status = $eachposter->isOnline() ? _MD_ONLINE : '';

$posterarr = array('poster_uid' => $eachposter->getVar('uid'), 'poster_uname' => ''.$eachposter->getVar('uname').'', '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 .= '

----------------
'. $myts->makeTareaData4Show($eachposter->getVar('user_sig', 'N'), 0, 1, 1).'

';

}

} 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 = '';

} else {

$post_image = '';

}

$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.'&forum='.$forum.'&viewmode='.$viewmode.'&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

Posted: 18 years ago
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.