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

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

$rowsPerPage = 100;

$pageNum = 1;

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

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

$count = 0;

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

if((int)$_GET['itemid'] > 0) {
	$queryFilter .= " AND ID = '".(int)$_GET['itemid']."'";
}

$Query = "SELECT ID, DateIns, ItemText, ItemTitle FROM ".TABLE_NEWS." $queryFilter ORDER BY DateIns DESC, ID DESC LIMIT 0,1";
$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('newsListTitle', $items['ItemTitle'], 30);
	$xtpl->assign('newsDescr', $items['ItemText']);
	
	 /*      
	$QueryImg = "SELECT * FROM ".TABLE_NEWS_IMGS." WHERE SecId = '1' AND RefId = '".$items['ID']."' LIMIT 0,1";
	$queryImg = mysqli_query($conn, $QueryImg);
	while($infoImg = mysqli_fetch_array($queryImg)) {
		$xtpl->assign('dImg', PATH_V_NEWS_IMG.$infoImg['ItemImg']);
	    $xtpl->parse('main.viewNewsDett.viewDImg');
	}
	*/
	
	$countImg = 0;
	
	$QueryImg = "SELECT * FROM ".TABLE_NEWS_IMGS." WHERE RefId = '".$items['ID']."'";
	$queryImg = mysqli_query($conn, $QueryImg);
	while($infoImg = mysqli_fetch_array($queryImg)) {
		
		$countImg++;
		$xtpl->assign('dImg', PATH_V_NEWS_IMG.$infoImg['ItemImg']);
		if($infoImg['SecId'] == 2){
			
			$xtpl->parse('main.viewNewsDett.viewDImg');
		}
		else {
			$xtpl->parse('main.viewNewsDett.viewDImgList');
		}
	    
	}
	
		
	$xtpl->parse('main.viewNewsDett');

}

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


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