It's not hard to do, but you will need to change the PHP file news_top.php, found in modules/news/blocks/.
Best to first make a copy of news_top.php, in case something goes wrong
Then you need to replace the sql statements in the function b_news_top_show with the following code :
le="color: #000000"><?php if ( $options[3] == 0 ) { $sql = "SELECT storyid, title, published, expired, counter, topic_title 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 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);
Next, find $news = array(); in the same function.
After that replace the $title = with the following code :
le="color: #000000"><?php $topic_title = $myts->makeTboxData4Show($myrow["topic_title"]); $title = $topic_title . " :: " . $myts->makeTboxData4Show($myrow["title"]);
The complete function should look like this :
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 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 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 = $topic_title . " :: " . $myts->makeTboxData4Show($myrow["title"]); if (strlen($title) > $options[2]) { $title = xoops_substr($title,0,$options[2]+3); } $news['title'] = $title; $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; }
Hope that helps, I'm not very good at explaining how to make code changes - I'm better at just doing it
Rowd
