<?php
include_once("inc/includes.php");

$xtpl = new XTemplate('templates/news_home.html');

$rowsPerPage = 2;

$pageNum = 1;

if(isset($_GET['page'])) {
	$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;

$count = 0;

$queryFilter = "WHERE Visibile > '0' AND ItemLang = '".LANG."'";

$Query = "SELECT * FROM ".TABLE_NEWS." $queryFilter ORDER BY DateIns DESC, ID DESC LIMIT $offset, $rowsPerPage";
$query = mysqli_query($conn, $Query);
$totNews = mysqli_num_rows($query);
while($items = mysqli_fetch_array($query)) {

	$count++; 

	$xtpl->assign('ID', $items['ID']);
	$xtpl->assign('nDate', date("d-m-Y", $items['DateIns']));
	$xtpl->assign('newsTitle', $items['ItemTitle']);
	$xtpl->assign('newsAbstract', txtAbstract($items['Abstract'], 150));		
	
	$linkRev = SITE_URL."news/".cleanString($items['ItemTitle'])."-".$items['ID'];
	
	$xtpl->assign('linkRev', $linkRev);
	
	if($count == $rowsPerPage) {
		$xtpl->assign('last', '-last');	
	}

	
	$xtpl->assign('nImg', "");
	
		
		$QueryImg = "SELECT * FROM ".TABLE_NEWS_IMGS." WHERE SecId = '2' AND RefId = '".$items['ID']."' LIMIT 0,1";
		$queryImg = mysqli_query($conn, $QueryImg);
		while($infoImg = mysqli_fetch_array($queryImg)) {
		
			$xtpl->assign('nImg', PATH_V_NEWS_IMG.$infoImg['ItemImg']);
			$xtpl->parse('main.viewNews.viewnImg');
			
		}
		
		$xtpl->parse('main.viewNews');
}

if((int)$totNews == 0) {
	$xtpl->parse('main.viewNoNews');
}


$xtpl->parse('main');
$xtpl->out('main');
?>