$meta_des=""; $meta_tit=""; $dhtml = new dhtml(); $q = mysql_query("select product.id as 'id_product', product.sleva_akce, product.prize as 'price', product.folder as 'folder', product.akce as 'in_action', product_lang.nazev as 'name_of_product', product_lang.anotace as 'anotace', url.nazev as 'name_url', maker.jmeno_vyrobce, dph.dph from product inner join product_lang on product.id = product_lang.id_product inner join url on product.id = url.id_typ inner join dph on product.dph = dph.id left join maker on product.kod_vyrobce = maker.id where product.akce = 1 and product_lang.lang = '".$language->vratjazyk()."' and url.typ = 'product' and url.lang = '".$language->vratjazyk()."'"); while ($zaznam = mysql_fetch_array($q)) { $q1 = mysql_query("select name from product_undercarts where id_product = ".$zaznam['id_product']); if (mysql_num_rows($q1)==0) { $podkarts=false; $stock->init_stock_num_front($zaznam['id_product'],'NONE'); $zaznam['lze_objednat']=$stock->verify($zaznam['id_product']); $zaznam['podkarta']=$podkarts; } else { $podkarts=true; $zaznam['podkarta']=$podkarts; } if ($zaznam['sleva_akce']!=0) { $zaznam['procentualni_sleva']=round(100-($zaznam['price']/(($zaznam['sleva_akce']/100))),0); $zaznam['sleva_akce']=$language->prepocitat_mena($zaznam['sleva_akce']); $zaznam['sleva_akce_without_dph']=$language->prepocitat_mena($zaznam['sleva_akce']/(100+($zaznam['dph']))*100); } $zaznam['price']=$language->prepocitat_mena($zaznam['price']); $zaznam['price_without_dph']=($zaznam['price']/(100+($zaznam['dph']))*100); if (!file_exists($_SERVER['DOCUMENT_ROOT'].'/media/product/'.$zaznam['folder'].'/hlavni.png')) {$zaznam['hlavnifoto1']='/media/default_product.png';} else {$zaznam['hlavnifoto1']='/media/product/'.$zaznam['folder'].'/hlavni.png';} $zaznamakce [] = $zaznam; } $smarty->assign('zaznamakce',$prom->upravitpromennetisk($zaznamakce)); $smarty->assign('url',$_GET['url']); ?>