include('includes/connect.inc.php');
mysql_select_db($db);
date_default_timezone_set('America/Jamaica');
$num_of_articles=0;
$pagesize=10;
//GET id
if (isset($_GET['cid'])){
$cid=(int)$_GET['cid'];
}
//get data
if (isset($_GET['startnum'])){
$startnum=(int)$_GET['startnum'];
}
//checkinfo
if(!isset($startnum)){
$startnum=0;
}
$endnum= $startnum + $pagesize;
/*old setup
if (isset($_GET['cid'])){
$query="select * from articlenew where Status='Show' and ArticleCategoryID=$cid order by ArticleID DESC Limit $startnum,$pagesize";
}else{
$query="select * from articlenew where Status='Show' order by ArticleID DESC Limit $startnum,$pagesize";
}
*/
if (isset($_GET['cid'])){
$query="SELECT a.ArticleID, ArticleTitle,ArticleTeaser,ArticleAddDate,ImageName FROM articlenew as a ";
$query.="left join articleimages as b on a.ArticleID=b.ArticleID and (b.ImageDefault= 'Y' or b.ImageDefault='N') WHERE Status='Show' and ArticleCategoryID=$cid Order By a.ArticleID Desc ";
$query.="limit $startnum,$pagesize";
}else{
$query="SELECT a.ArticleID as ArticleID, ArticleTitle,ArticleTeaser,ArticleAddDate, ImageName FROM articlenew as a ";
$query.="left join articleimages as b on a.ArticleID=b.ArticleID and (b.ImageDefault= 'Y' or b.ImageDefault=NULL) WHERE Status='Show' Order By a.ArticleID Desc ";
$query.="limit $startnum,$pagesize";
}
//echo $query;
$result=mysql_query($query)or die (mysql_error());
$articleids = array();
$articletitles = array();
$articleteasers = array();
$articleimagename = array();
$i=0;
while ($row = mysql_fetch_object($result)){
$articleid=$row->ArticleID;
$articletitle=stripslashes($row->ArticleTitle);
$articleteaser=$row->ArticleTeaser;
$articleteaser=stripslashes($articleteaser);
$articleteaser = str_replace("\n","
",$articleteaser);
/*if(strlen($articledesc) > 400){
$articledesc = substr($articledesc,0,400);
$articledesc = substr($articledesc,0,strrpos($articledesc," "));
$articledesc.= " ..";
}*/
$ArticleAddDate=$row->ArticleAddDate;
$ArticleAddDate=stripslashes($ArticleAddDate);
$yyyy=substr($ArticleAddDate,0,4);
$mm=substr($ArticleAddDate,5,2);
$dd=substr($ArticleAddDate,8,2);
$ArticleAddDate = date ("F d, Y", mktime(0,0,0,$mm,$dd,$yyyy));
$lastupdatedarticle = $ArticleAddDate;
//$Status=$row->Status;
//$Status=stripslashes($Status);
$articleids[$i] = $articleid;
$articletitles[$i] = $articletitle;
$articleteasers[$i] = $articleteaser;
if ($row->ImageName==NULL){
$articleimagename[$i]="default.jpg";
}
else {
$articleimagename[$i]="tn_".$row->ImageName;
}
$i++;
}
//Paging
// Query to find number of articles...
if (isset($_GET['cid'])){
$query="SELECT ArticleID,CategoryName FROM articlenew,articlecategory where Status='Show' and ArticleCategoryID=$cid and articlecategory.CategoryID=articlenew.ArticleCategoryID";
}else{
$query="SELECT ArticleID FROM articlenew where Status='Show'";
}
$results = mysql_query($query) or die ("Invalid query");
$num_of_articles=mysql_num_rows($results);
if (isset($_GET['cid'])){
$row = mysql_fetch_object($results);
$tpl_categoryname=stripslashes($row->CategoryName);
}
//Paging Begins
//Variables
//Passed variables: $num_of_articles.
//Configured: $pagesize plus
$numofsidenumbers=3;
$pagename="article_listing.php";
$newstartnum=$endnum;
$pages=$num_of_articles/$pagesize;
if (($num_of_articles%$pagesize)!=0)
{
$pages=$pages+1;
}
$pages=ceil($pages);
//echo $pages."
";
$checknum=$newstartnum-$pagesize;
//Previous
if ($checknum!=0)
{
$PAGING="";
$prevnum=$checknum-$pagesize;
if (isset($_GET['cid'])){
$PAGING.="Previous ";
}else{
$PAGING.="Previous ";
}
}
//others
for ($i=0;$i<$pages;$i++)
{
//$num_of_articles%($pagesize*$i);
$pagenum=$i+1;
$testnum=$i*$pagesize;
//echo $testnum."-".$pagenum."-".$checknum."
";
if ($testnum <$num_of_articles)
{
if ($testnum <= ($checknum + ($pagesize*$numofsidenumbers)) && $testnum >= ($checknum - ($pagesize*$numofsidenumbers)) ) {
//check which page
if($testnum!=$checknum)
{
if (isset($_GET['cid'])){
$PAGING=$PAGING."".$pagenum." ";
}else{
$PAGING=$PAGING."".$pagenum." ";
}
}
else
{
if ($num_of_articles > $pagesize)
{
// echo $pagenum;
$PAGING=$PAGING." ".$pagenum." ";
}
}
}
}
}
//Next Page
if ($checknum!=($pages-2)*$pagesize)
{
$nextnum=$checknum+$pagesize;
if (isset($_GET['cid'])){
$PAGING.="Next";
}else{
$PAGING.="Next";
}
}
if ($startnum>$num_of_articles){
$PAGING="Invalid Query....";
}
//Paging Ends
include('tpl_article_listing.php');
?>