article_cats.php

<?php
/*---------------------------------------------------------------------+
| ExiteCMS Content Management System                                   |
+----------------------------------------------------------------------+
| Copyright 2006-2008 Exite BV, The Netherlands                        |
| for support, please visit http://www.exitecms.org                    |
+----------------------------------------------------------------------+
| Some code derived from PHP-Fusion, copyright 2002 - 2006 Nick Jones  |
+----------------------------------------------------------------------+
| Released under the terms & conditions of v2 of the GNU General Public|
| License. For details refer to the included gpl.txt file or visit     |
| http://gnu.org                                                       |
+----------------------------------------------------------------------+
| $Id::                                                               $|
+----------------------------------------------------------------------+
| Last modified by $Author::                                          $|
| Revision number $Rev::                                              $|
+---------------------------------------------------------------------*/
require_once dirname(__FILE__)."/includes/core_functions.php";
require_once PATH_ROOT."/includes/theme_functions.php";

define('AC_OVERVIEW_LIMIT', 5);

// load the locale for this module
locale_load("main.article_cats");

// make sure the cat_id is valid
if (isset($cat_id) && !isNum($cat_id)) fallback(FUSION_SELF);

// temp storage for template variables
$variables = array();
$article_cats = array();

// compose the query where clause based on the localisation method choosen
switch ($settings['article_localisation']) {
	case "none":
		$where = "";
		break;
	case "single":
		$where = "";
		break;
	case "multiple":
		$where = "article_cat_locale = '".$settings['locale_code']."' ";
		break;
}

// make the selection based on the presence of cat_id 
if (isset($cat_id)) {
	$sql = " AND article_cat_id='".$cat_id."'";
	$sql2 = "";
	$show_all = true;
} else {
	$sql = "";
	$sql2 = " LIMIT ".AC_OVERVIEW_LIMIT;
	$show_all = false;
	// get the number of uncategorised article items
	$count = dbcount("(article_id)", "articles", "article_cat='0'");
	// only show them if there are article items available
	if ($count) {
		$data = array();
		$data['itemcount'] = $count;
		// set a flag to indicate there are more items then shown
		$data['more'] = (!isset($cat_id) && $data['itemcount'] > AC_OVERVIEW_LIMIT);
		$data['article_cat_image'] = "";
		$data['article_cat_name'] = $locale['403'];
		// get not categorised article first
		if ($data['itemcount']) {
			$result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='0'".($where==""?"":(" AND ".$where))." ORDER BY article_datestamp DESC ".$sql2);
			while ($data2 = dbarray($result2)) {
				$data2['article_snippet'] = stripslashes($data2['article_snippet']);
				$data['items'][] = $data2;
			}
		}
		$article_cats[] = $data;
	}
}
// get the available article_cats
$result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE ".groupaccess('article_cat_access').$sql.($where==""?"":(" AND ".$where))." ORDER BY article_cat_id");
while ($data = dbarray($result)) {
	// total number of items for this news_cat
	$data['itemcount'] = dbcount("(article_id)", "articles", "article_cat='".$data['article_cat_id']."'");
	// set a flag to indicate there are more items then shown
	$data['more'] = (!isset($cat_id) && $data['itemcount'] > AC_OVERVIEW_LIMIT);
	// get all news items for this cat (limit if showing an overview)
	$data['items'] = array();
	if ($data['itemcount']) {
		$result2 = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='".$data['article_cat_id']."' ORDER BY article_datestamp DESC ".$sql2);
		while ($data2 = dbarray($result2)) {
			$data2['article_snippet'] = stripslashes($data2['article_snippet']);
			$data['items'][] = $data2;
		}
	}
	$article_cats[] = $data;
}
$variables['article_cats'] = $article_cats;
$variables['show_all'] = $show_all;
$variables['overview_limit'] = AC_OVERVIEW_LIMIT;

// define the body panel variables
$template_panels[] = array('type' => 'body', 'name' => 'article_cats', 'template' => 'main.article_cats.tpl', 'locale' => "main.article_cats");
$template_variables['article_cats'] = $variables;

// Call the theme code to generate the output for this webpage
require_once PATH_THEME."/theme.php";
?>