1
Mods & Plugins (Releases & Support) / Re: [MOD]Another Simple News Publishing Mod
« on: October 18, 2007, 06:59:14 PM »
All the time the news is appearing on the frontpage, but as soon I click for more news, the error message is gone but no news is showing up. Only the working paging. The header is saying "No news" while there are more as 10 newsmessages. I've the next changes in news.php in the root section:
if($news_id=="")
$sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
else
$sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id AND news_id = ".$news_id." ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
if($news_id=="")
$sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
else
$sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id AND news_id = ".$news_id." ORDER BY news_date DESC LIMIT $offset, $newsPerPage";