6
i haven't really tried using this with news2, but you might
try changing the following code in news_all.php:
Quote:
$sql = "SELECT storyid, title, bodytext, topicdisplay, topicalign, published, counter FROM ".$xoopsDB->prefix("stories")." WHERE published < ".time()." AND published > 0 AND (expired = 0 OR expired > ".time().") ORDER BY ".$options[0]." DESC";
change ("stories") to ("stories2")
Quote:
$var_image = $xoopsDB->query("SELECT topicid FROM ".$xoopsDB->prefix("stories")." WHERE storyid=".$newsid."",1,0);
list ($patt_image) = $xoopsDB->fetchRow($var_image);
$var_image2 = $xoopsDB->query("SELECT topic_imgurl FROM ".$xoopsDB->prefix("topics")." WHERE topic_id=".$patt_image."",1,0);
list ($image_display) = $xoopsDB->fetchRow($var_image2);
$news['image_display'] = $image_display;
$block['stories'][] = $news;
also change ("stories") to ("stories2") and
("topics") to ("topics2")
like i said, i haven't tried this, but i should work....theoretically.