<?
// index.php

include($DOCUMENT_ROOT."/includes/initiate.php");
include($DOCUMENT_ROOT."/includes/functions.php");

if ($id) $filter = "and id = $id";
if ($q and $y) {
	$orderfilter = "";
	$qfilter = "and QUARTER(date)=$q and YEAR(date)=$y";
	if ($q == 1) {
		$cur_qtr = "January - March, "; 
	} elseif ($q == 2) {
		$cur_qtr = "April - June, ";
	} elseif ($q == 3) {
		$cur_qtr = "July - September, ";
	} elseif ($q == 4) {
		$cur_qtr = "October - December, ";
	}
	$cur_qtr .= "$y";
	$smarty->assign('cur_qtr', $cur_qtr);
}
if (!$q) { 
	$limitfilter  = "limit 4"; 
	$orderfilter = "DESC";
}

function insert_Get_UserName ($vars){
	$userid = $vars[id];
	$user_query = sql_query("select * from admin_users where id = $userid");
	$author = ($user_query[0][real_name]);
	return $author;
}

$news_query = sql_query("select * from news where deleted_p=0 $filter $qfilter $cur_min_filter order by date $orderfilter $limitfilter "); 
$smarty->assign('news', $news_query);

$qtr_query = sql_query("select distinct quarter(date) as q, year(date) as y from news where deleted_p=0 $cur_min_filter order by date desc");
$smarty->assign('qtr', $qtr_query);

$smarty->assign('id', $id);

$smarty->assign('color','g');
$smarty->display('news.tpl.html');


mysql_close();
?>