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

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

$rowsPerPage = 4;

$pageNum = 1;

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

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

$count = 0;

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

$Query = "SELECT ID, ItemTitle 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']);

	
	$linkRev = SITE_URL."news/".cleanString($items['ItemTitle'])."-".$items['ID'];
	
	$xtpl->assign('linkRev', $linkRev);
	
	$xtpl->parse('main.viewUNews');

}

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


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