=".time().") AND news_draft='0'"); if ($rows) { $res = 1; echo "\n"; if ($_GET['cat_id'] != 0) { /* echo "\n\n"; /* echo "\n\n\n\n\n\n\n

\n"; / / echo "".$locale['401']." ".$data['news_cat_name']." \n".$locale['402']." $rows	\n"; */ } else { echo "
".$locale['403']." \n"; echo "".$locale['401']." $rows	\n"; } //start new code// $result2 = dbquery( "SELECT tn., tc., tu.user_id, tu.user_name, tu.user_status FROM ".DB_NEWS." tn LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id WHERE news_cat='".$_GET['cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'\|\|news_start<=".time().") AND (news_end='0'\|\|news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC" ); //end new code// while ($data2 = dbarray($result2)) { $news_news = $data2['news_breaks'] == "y" ? nl2br(stripslashes($data2['news_news'])) : stripslashes($data2['news_news']); opentable($data2['news_subject']); echo $news_news; //Bottom Bar Begin $nfooter_info = array( "news_id" => $data2['news_id'], "user_id" => $data2['user_id'], "user_name" => $data2['user_name'], "user_status" => $data2['user_status'], "news_date" => $data2['news_datestamp'], "news_subject" => $data2['news_subject'], "news_ext" => $data2['news_extended'] ? "y" : "n", "news_reads" => $data2['news_reads'], /* deze regel weggehaald "news_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data2['news_id']."' AND comment_hidden='0'"), / "news_allow_comments" => $data2['news_allow_comments'], "news_sticky" => $data2['news_sticky'] ); render_nfooter($nfooter_info); //Bottom Bar End closetable(); } / Ivo removed here: echo "
".THEME_BULLET." ".$locale['406']."";*/ echo "

\n"; } } if (!$res) { redirect(FUSION_SELF); } /* met de volgende code wordt de overzicht pagina van alle nieuws categorieen getoond */ } else { $res = 0; $result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." ORDER BY news_cat_id"); if (dbrows($result)) { echo "\n"; while ($data = dbarray($result)) { $rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'"); echo "\n\n"; echo "\n\n"; } $res = 1; } /* vanaf hier wordt alle niet categoriseerd nieuws getoond */ $result = dbquery("SELECT * FROM ".DB_NEWS." WHERE news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10"); if (dbrows($result)) { if ($res == 0) { echo "

\n"; echo "".$locale['401']." ".$data['news_cat_name']."
\n".$locale['402']." $rows

\n"; if ($rows) { $result2 = dbquery("SELECT news_id, news_subject,news_breaks,news_news FROM ".DB_NEWS." WHERE news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10"); while ($data2 = dbarray($result2)) { $news_news = $data2['news_breaks'] == "y" ? nl2br(stripslashes($data2['news_news'])) : stripslashes($data2['news_news']); opentable("".$data2['news_subject'].""); /* blue is kleur van link naar nieuws in newcat overzicht van alle categorieen */ echo $news_news; closetable(); } if ($rows > 10) { echo "

".THEME_BULLET." ".$locale['405']."

\n"; } } else { echo THEME_BULLET." ".$locale['404']."\n"; } echo "

\n"; } $nrows = dbcount("(news_id)", DB_NEWS, "news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'"); echo "\n\n\n\n"; } if ($res == 1) { echo "

".$locale['403']."
\n"; echo "".$locale['402']." $nrows

\n"; while ($data = dbarray($result)) { opentable("".$data['news_subject'].""); $news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']); echo $news_news; closetable(); } $res = 1; if ($nrows > 10) { echo "

".THEME_BULLET." ".$locale['405']."

\n"; } echo "

\n"; } else { echo "

\n".$locale['407']."

\n

\n"; } } closetable(); require_once THEMES."templates/footer.php"; ?>