<? 
//////////////////////////////////////////////////
// Calliope version 0.1 - August-November 2005
//////////////////////////////////////////////////

// Prepare page
require ("pagestart.php");

$page_title = "";
$template->assign("PAGE_TITLE", $page_title);

// Get order
$main_order_by = get_config_value('main_order_by');
$news_limit = get_config_value('news_limit');
$date_format = get_config_value('date_format');

// Get news
$news_value = get_config_value('news');
if ($news_value == "Yes") {
	$query_news = "SELECT id, headline, text, DATE_FORMAT(date, '$date_format') AS date FROM $news_table ORDER BY id DESC LIMIT $news_limit";
	$news = mysql_query($query_news) or exit("Error: ".mysql_error());
	while ($news_item = mysql_fetch_array($news)) { 
		$news_string .= format_news($news_item, '1');
	}

	$template->assign_if("news", "1");
	$template->assign("NEWS", $news_string);
}


// Get last updated
$query_date = "SELECT DATE_FORMAT(date, '$date_format') AS date FROM $chapters_table ORDER BY id DESC LIMIT 1";
$date_result = mysql_query($query_date) or die(mysql_error());
$date_fetch = mysql_fetch_array($date_result);
$template->assign("DATE", $date_fetch['date']);

// Get cats info
$cats = get_catlist($main_order_by, "00000", 'index');
$template->assign("CATS", $cats);


// Process template

$template->pparse("layout/index.tmpl");

// End connection to the database
endconnect();
?>