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

$xtpl = new XTemplate('templates/news-box.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."'";

$Query2 = "SELECT ID, DateIns, ItemText, ItemTitle FROM ".TABLE_NEWS." $queryFilter ORDER BY DateIns DESC, ID DESC LIMIT 0,3";
$query2 = mysqli_query($conn, $Query2);
$totNews2 = mysqli_num_rows($query2);
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');

}

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


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