Nederlands-, Vlaamstalige pHp-Fusion support site voor België en Nederland.
PHP-Fusion is een open-source "Content Magagement System" (CMS) geschreven in PHP en MySQL. Het beheren van uw site gaat met een eenvoudig en begrijpbaar administratie systeem. PHP-Fusion bevat o.a. een forum, shoutbox, enquêtes, profielpagina's, nieuws, fotogalerij, weblinks enz. Uiteraard is de standaardinstallatie nog uit te breiden met infusies (modules) en andere thema's (skins).
]
/*-------------------------------------------------------+
| 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";
}
$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 "
/* 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";
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 "
/* 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"; }
$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 "
