=".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"; } $result2 = dbquery("SELECT news_id, news_subject, news_news FROM ".DB_NEWS." 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"); while ($data2 = dbarray($result2)) { echo THEME_BULLET." ".$data2['news_subject']." ".$data2['news_news']." \n"; } echo "
".THEME_BULLET." ".$locale['406'].""; echo "

\n"; } } if (!$res) { redirect(FUSION_SELF); } } 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; } $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 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)) { echo THEME_BULLET." ".$data2['news_subject']."
".$data2['news_news']."
\n"; } 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)) { echo THEME_BULLET." ".$data['news_subject']."
".$data2['news_news']."
\n"; } $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"; ?>