]
/*-------------------------------------------------------+

| PHP-Fusion Content Management System

| Copyright (C) 2002 - 2010 Nick Jones

| http://www.php-fusion.co.uk/

+--------------------------------------------------------+

| Filename: news_cats.php

| Author: Nick Jones (Digitanium)

+--------------------------------------------------------+

| This program is released as free software under the

| Affero GPL license. You can redistribute it and/or

| modify it under the terms of this license which you

| can read by viewing the included agpl.txt or online

| at www.gnu.org/licenses/agpl.html. Removal of this

| copyright header is strictly prohibited without

| written permission from the original author(s).

+--------------------------------------------------------*/

require_once "maincore.php";

require_once THEMES."templates/header.php";

include LOCALE.LOCALESET."news_cats.php";

add_to_title($locale['global_200'].$locale['400']);

opentable($locale['400']);

if (isset($_GET['cat_id']) && isnum($_GET['cat_id'])) {

   $res = 0;

   $result = dbquery("SELECT news_cat_name FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET['cat_id']."'");

   if (dbrows($result) || $_GET['cat_id'] == 0) {

      $data = dbarray($result);

      $rows = dbcount("(news_id)", DB_NEWS, "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'");

      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,news_breaks 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)) {

         $news_news = $data2['news_breaks'] == "y" ? nl2br(stripslashes($data2['news_news'])) : stripslashes($data2['news_news']);

         opentable($data2['news_subject']);

         echo $news_news;

         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";

?>