[MK|Breaker]

Installed

i need more options for "news-forum"....i must edit the query :-P

$get_stats_latestnews = $db->query_read("SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, iF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM " . TABLE_PREFIX . "thread AS thread LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND forumid='85' OR forumid='101' OR forumid='98' OR forumid='103' OR forumid='95' OR forumid='104' OR forumid='88' OR forumid='102' OR forumid='91' OR forumid='105' OR forumid='107' OR forumid='108' OR forumid='111' OR forumid='112' OR forumid='115' OR forumid='116' AND thread.visible='1' ORDER BY threadid DESC LIMIT $resultsnr");