<?

$title="";

include("config.php");
require('../includes/functions.php');
require("mainfile.php");
if(!logged()) {
logout();
}

$rows=array();
$upit=mysql_query("SELECT id,cid,naslov,slikam,vcena,akcija,akcijavcena,novo,pdv FROM `proizvodi` WHERE `active`=1 AND `deleted`=0 ORDER BY rand() LIMIT 8 ");
while($row=mysql_fetch_assoc($upit)){
	if($row['akcija']){
		$row['pdvcena']=$row['akcijavcena']*(($row['pdv']+100)/100);
		$row['vcena']=number_format($row['akcijavcena'], 2, ',', '.');
	}else{
		$row['pdvcena']=$row['vcena']*(($row['pdv']+100)/100);
		$row['vcena']=number_format($row['vcena'], 2, ',', '.');

	}
	$row['pdvcena']=number_format($row['pdvcena'], 2, ',', '.');
	$row['url']=makeurl(stripslashes($row['naslov']));
	$rows[]=$row;
}	

$smarty->assignByRef("randomproizvodi",$rows);


#### Slider

$rows1=array();
$upit=mysql_query("SELECT * FROM `slider` WHERE `tip`=2 ORDER BY `slid` DESC");
while($row=mysql_fetch_assoc($upit)){
	$rows1[]=$row;
}	

$smarty->assignByRef("slider",$rows1);




$smarty->display("header.html");
$smarty->display("index.html");
$smarty->display("footer.html");



?>