Betreff: Aw:: block recent topics newbb 4.03
von beduino am 17.09.2010 14:03:16
Hello Bleekk
first: thank you !
But the first columm [name of forum] still blank
I edit the newbb_block.php. Only to confirm [maybe I made something wrong ...] I comment the old lines
1. 262
$query = 'SELECT'.
' t.topic_id, t.topic_replies, t.forum_id, t.topic_title, t.topic_views, t.type_id, t.topic_time, t.topic_poster, t.poster_name,'.
//' f.forum_name'.
' f.forum_name, f.forum_last_post_id'.
' FROM ' . $GLOBALS["xoopsDB"]->prefix('bb_topics') . ' AS t '.
' LEFT JOIN ' . $GLOBALS["xoopsDB"]->prefix('bb_forums') . ' AS f ON f.forum_id=t.forum_id'.
' WHERE 1=1 ' .
2. 297
foreach ($rows as $arr) {
$topic_page_jump = '';
$topic['topic_subject'] = empty($type_list[$arr["type_id"]])?"":"[".$type_list[$arr["type_id"]]."] ";
$topic['forum_id'] = $arr['forum_id'];
//$topic['forum_name'] = $myts->htmlSpecialChars($arr['forum_name']);
//$topic['id'] = $arr['topic_id'];
$topic['forum_name'] = $myts->htmlSpecialChars($arr['forum_name']);
$topic['forum_last_post_id'] = $arr['forum_last_post_id'];
3. 322
// $seo_forum_url = '<a href="'.XOOPS_URL.'/modules/newbb/viewforum.php?forum='.$topic['forum_id'].'">'.$topic['forum_name'].'</a>';
$seo_url = '<a href="'.XOOPS_URL.'/modules/newbb/viewtopic.php?post_id='.$topic['forum_last_post_id'].'">'.$topic['title'].'</a>';
Thank you again
| 
