=".time().")"); if ($rows) { $res = 1; echo "\n"; if ($cat_id != 0) { echo "\n\n"; echo "\n\n\n\n\n\n\n\n\n


\n"; echo "".$locale['401']." ".$data['news_cat_name']."
\n".$locale['402']." $rows		\n"; } else { echo "
None-Categorised News
\n"; echo "".$locale['401']." $rows		\n"; } $result2 = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='$cat_id' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC"); while ($data2 = dbarray($result2)) { echo " ".$data2['news_subject']."
\n"; } echo "
".$locale['406']." "; echo "
\n"; } } if (!$res) redirect(FUSION_SELF); } else { $res = 0; $result = dbquery("SELECT * FROM ".$db_prefix."news_cats ORDER BY news_cat_id"); if (dbrows($result)) { echo "\n"; while ($data = dbarray($result)) { $rows = dbcount("(news_id)", "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().")"); echo "\n\n"; echo "


\n"; echo "".$locale['401']." ".$data['news_cat_name']."
\n".$locale['402']." $rows		\n"; if ($rows) { $result2 = dbquery("SELECT * FROM ".$db_prefix."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().") ORDER BY news_datestamp DESC LIMIT 10"); while ($data2 = dbarray($result2)) { echo " ".$data2['news_subject']."
\n"; } if ($rows > 10) echo "
".$locale['405']."
\n"; } else { echo " ".$locale['404']."\n"; } } $res = 1; } $result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 10"); if (dbrows($result)) { if ($res == 0) echo "\n"; $nrows = dbcount("(news_id)", "news", "news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")"); echo "\n\n\n\n\n\n
".$locale['403']."
\n"; echo "".$locale['402']." $nrows		\n"; while ($data = dbarray($result)) { echo " ".$data['news_subject']."
\n"; } $res = 1; if ($nrows > 10) echo "\n"; } if ($res == 1) { echo "
\n"; } else { echo "

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

\n
\n"; } } closetable(); require_once "side_right.php"; require_once "footer.php"; ?>