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

$xtpl = new XTemplate('templates/news-evidenza.html');

$rowsPerPage = 100;

$pageNum = 1;

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

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

$count = 0;


$Query2 = "SELECT ID, DateIns, ItemText, ItemTitle FROM ".TABLE_NEWS." WHERE in_evidenza = 1 ORDER BY DateIns DESC, ID DESC LIMIT 1";
$query2 = mysqli_query($conn, $Query2);
$totNews2 = mysqli_num_rows($query2);

if((int)$totNews2 > 0)
{
	while($items2 = mysqli_fetch_array($query2)) {

		$count++; 

		$xtpl->assign('ID', $items2['ID']);
		$xtpl->assign('nDateB', date("d/m/Y", $items2['DateIns']));
		$xtpl->assign('newsListTitleB', $items2['ItemTitle']);
		
				
		$QueryImg = "SELECT * FROM ".TABLE_NEWS_IMGS." WHERE SecId = '1' AND RefId = '".$items2['ID']."' LIMIT 0,1";
		$queryImg = mysqli_query($conn, $QueryImg);
		while($infoImg = mysqli_fetch_array($queryImg)) {
			$xtpl->assign('dImgB', PATH_V_NEWS_IMG.$infoImg['ItemImg']);
			$xtpl->parse('main.viewNewsDett.viewDImg');
		}
		
		$xtpl->parse('main.viewListNews');
	}
}
else
{}

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


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