2
Hmm, maybe i was too drunk that night...
Anyway found it.
Just change this:
le="color: #000000"><?php $sql = "SELECT t.topic_title, s.storyid, s.topicid, s.title, s.comments, s.counter FROM ".$xoopsDB->prefix("stories")." s, ".$xoopsDB->prefix("topics")." t WHERE s.topicid=t.topic_id ORDER BY s.storyid DESC LIMIT $limit";
Into this:
le="color: #000000"><?php $sql = "SELECT t.topic_title, s.storyid, s.topicid, s.title, s.comments, s.counter, s.published, s.expired FROM ".$xoopsDB->prefix("stories")." s, ".$xoopsDB->prefix("topics")." t WHERE s.topicid=t.topic_id AND s.published < ".time()." AND s.published > 0 AND (s.expired = 0 OR s.expired > ".time().") ORDER BY s.storyid DESC LIMIT $limit";
Happy xooping!
