I missed your post earlier, JFM... sorry
To make the topic separate you will need to add ', topicid ' to both of the sql statements, like this:
le="color: #000000"><?php topic_title, topicid FROM
Then change the $topic_title and $topic lines to this:
le="color: #000000"><?php $topic_title = $myts->makeTboxData4Show($myrow["topic_title"]); $title = $myts->makeTboxData4Show($myrow["title"]); $topic_id = $myrow["topicid"]; if ((strlen($title) + strlen($topic_title)) > $options[2]) { $title = xoops_substr($title,0,$options[2]+3); } $news['topic_title'] = $topic_title; $news['title'] = $title; $news['topic_id'] = intval($topic_id); $news['id'] = $myrow['storyid'];
By doing it this way it still uses the preference you set for restricting the length of the news title - the difference being that it uses that setting on topic and title, as one line.
Finally you will need to change the template news_block_new.html
Between the foreach lines, put this line:
le="color: #000000"><?php <li><a href="<{$xoops_url}>/modules/news/index.php?storytopic=<{$news.topic_id}>"><{$news.topic_title}></a> :: <a href="<{$xoops_url}>/modules/news/article.php?storyid=<{$news.id}>"><{$news.title}></a> (<{$news.date}>)</li>
If you want to add different styles to topic and title, assign a different class to each one, as dionesku outlined above.
If you don't want to have the topic name as a link, then just remove the "a" html tag - look online for html tutorials if you need help with that, there are tons of them and they explain it much better than I can.
Rowd
For reference, here's the whole function:
le="color: #000000"><?php function b_news_top_show($options) { global $xoopsDB; $myts =& MyTextSanitizer::getInstance(); $block = array(); $options_new = array_slice ( $options, 3 ); $topicpick = '('.implode ( ',', $options_new ).')'; if ( $options[3] == 0 ) { $sql = "SELECT storyid, title, published, expired, counter, topic_title, topicid FROM ".$xoopsDB->prefix("stories")." , ".$xoopsDB->prefix("topics")." t WHERE published < ".time()." AND published > 0 AND (expired = 0 OR expired > ".time().") AND topicid = t.topic_id ORDER BY ".$options[0]." DESC"; } else { $sql = "SELECT storyid, title, published, expired, counter, topic_title, topicid FROM ".$xoopsDB->prefix("stories")." , ".$xoopsDB->prefix("topics")." t WHERE published < ".time()." AND published > 0 AND (expired = 0 OR expired > ".time().") AND topicid in ".$topicpick." AND topicid = t.topic_id ORDER BY ".$options[0]." DESC"; } $result = $xoopsDB->query($sql,$options[1],0); while ( $myrow = $xoopsDB->fetchArray($result) ) { $news = array(); $topic_title = $myts->makeTboxData4Show($myrow["topic_title"]); $title = $myts->makeTboxData4Show($myrow["title"]); $topic_id = $myrow["topicid"]; if ((strlen($title) + strlen($topic_title)) > $options[2]) { $title = xoops_substr($title,0,$options[2]+3); } $news['topic_title'] = $topic_title; $news['title'] = $title; $news['topic_id'] = intval($topic_id); $news['id'] = $myrow['storyid']; if ( $options[0] == "published" ) { $news['hits'] = formatTimestamp($myrow['published'],"s"); $news['date'] = formatTimestamp($myrow['published'],"s"); } elseif ( $options[0] == "counter" ) { $news['hits'] = $myrow['counter']; $news['date'] = $myrow['counter']; } $block['stories'][] = $news; } return $block; }
