<?
$PAGE_START = explode(" ",microtime());
//Connection and Config
include("includes/connect.php");
include("includes/config.php");
include("includes/functions.php");
include("includes/functions.inc.php");
$id=(int)$_GET['id'];
$cname=get_category_name($id);
//Need better error checking
if (!isset($_GET['id'])){
	//echo "need better error handling";
	//exit();
	$id=1; //default to news
}
//Get Country code used in geo targetting ads using cookies.
/*
$tpl_ip=GetIP();
$gi = geoip_open("includes/GeoIPCity.dat",GEOIP_STANDARD);
$tpl_country_code=geoip_country_code_by_addr($gi, $tpl_ip);
$tpl_country_name=geoip_country_name_by_addr($gi, $tpl_ip);
geoip_close($gi);
*/
if (isset($_COOKIE["golgeo"])) {
    	$tpl_country  = $_COOKIE['golgeo'];
       list($tpl_country_code,$tpl_country_name)=explode("|",$tpl_country);
} else  {
	$tpl_ip=GetIP();
	include("includes/geoip.inc");
   	$gi = geoip_open("includes/GeoIPCity.dat",GEOIP_STANDARD);
	$tpl_country_code=geoip_country_code_by_addr($gi, $tpl_ip);
	$tpl_country_name=geoip_country_name_by_addr($gi, $tpl_ip);
	geoip_close($gi);
       $tpl_country=$tpl_country_code."|".$tpl_country_name;
	setcookie("golgeo", $tpl_country,  time()+2419200, "/", ".go-jamaica.com", 0); //28 day  cookie
}
//Geo-targeting finish 

//Get Categories
/*
$query="SELECT DISTINCT CategoryName, CategoryID ";
$query.="FROM articles AS a, category AS b ";
$query.="WHERE a.ArticleCategoryID=b.CategoryID AND a.ArticleStatusID=1 AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= a.ArticleDate ";
$query.="ORDER BY CategoryID";
*/
$query="SELECT CategoryName, CategoryID ";
$query.="FROM category";

//echo $query;
//Run Query
mysql_select_db($db);
$results = mysql_query ($query) or die ("Invalid query 1");
$i=0;
while ($row = mysql_fetch_object($results)){
	if (!in_array($row->CategoryID,array(4,8,9,10,11) )){
		$tpl_categoryid[$i]=$row->CategoryID;
		$tpl_categoryname[$i]=stripslashes($row->CategoryName);
		$i++;
	}
}
$tpl_categorycount = count($tpl_categoryname);

//Write Query To Get Stories for this category.
//$query="SELECT * FROM $ARTICLETABLE WHERE ArticleCategoryID=$id and ArticleStatusID=1 order by ArticleID Desc Limit 30";
$query="SELECT a.ArticleID as ID, ArticleTitle, ArticleSummary, ArticleDate, ImageName FROM $ARTICLETABLE as a ";
$query.="left join articleimages as b on a.ArticleID=b.ArticleID and b.ImageDefault= 'Y' WHERE ArticleStatusID=1 and ArticleCategoryID=$id Order By ID Desc ";
$query.="limit 0,30";
//echo $query;
//Run Query
$results = mysql_db_query ($db,$query) or die ("Invalid query");

//If articles present //loop through articles
$j=0;
while ($row = mysql_fetch_object($results)){
	//clean Data
	$tpl_aid[$j]=$row->ID;
	//$tpl_aid[$j]=$row->ArticleID;
	$tpl_title[$j]=stripslashes($row->ArticleTitle);
	$tpl_summary[$j]=stripslashes($row->ArticleSummary);
	$tpl_postdate[$j]=stripslashes($row->ArticleDate);

	//image
	if ($row->ImageName==NULL){
		$tpl_articleimagename[$j]="/newimages/botlogojpg.jpg";
		}
	else{
		$tempimagename=$row->ImageName;
		$img_name=substr($tempimagename,0,strrpos($tempimagename,"."));
		$img_ext=substr($tempimagename,strrpos($tempimagename,".")+1,strlen($tempimagename));
		$tpl_articleimagename[$j]="/news/".$img_name."_120".".".$img_ext; //must match what we create...
		//echo "<!--$tpl_articleimagename[$j]-->";
	}
	$j++;
}
//end loop


//Get News Feeds(Gleaner,Sports,Star,Blogs)
// include lastRSS
include ("../tools/lastRSS.php");

// Create lastRSS object
$rss = new lastRSS;

// Set cache dir and cache time limit (1200 seconds)
// (don't forget to chmod chace dir to 777 to allow writing)
$rss->cache_dir = '/home/gojamaica/www/gojamaica/cache/temp';
$rss->cache_time = 1800;
$rss->CDATA = "strip";
$rss->items_limit=5;
$rss->stripHTML=true;

//$rssfeed='http://www.jamaica-gleaner.com/feed/rss.xml';

switch ($id) {
    case 1:
        $tpl_rsstitle='Lead Stories';
        $rssfeed='http://www.jamaica-gleaner.com/feed/rss.xml';
        break;
    case 2:
	 $tpl_rsstitle='Sports';
        $rssfeed='http://www.jamaica-gleaner.com/feed/sports.xml';
        break;
    case 3:
	 $tpl_rsstitle='Business';
        $rssfeed='http://www.jamaica-gleaner.com/feed/business.xml';
        break;
    case 6:
	 $tpl_rsstitle='Caribbean';
        $rssfeed='http://www.jamaica-gleaner.com/feed/carib.xml';
        break;
   case 7:
	 $tpl_rsstitle='International';
        $rssfeed='http://www.jamaica-gleaner.com/feed/int.xml';
        break;
    case 10:
	 $tpl_rsstitle='Entertainment';
        $rssfeed='http://www.jamaica-gleaner.com/feed/ent.xml';
        break;
    default:
	 $tpl_rsstitle='News';
        $rssfeed='http://www.jamaica-gleaner.com/feed/news.xml';

}

//include template;
include("tpl_category.html");
?>