'; $adr=$_SERVER['SERVER_NAME']; if($adr=="www.of.cz"){ $adr="www.belabel.cz"; } ?>https://$adr/potisk/".db::$data["RewriteName"]."/"; } db::Query("SELECT * FROM tag_product_seo INNER JOIN productname pn USING(IdProduct,IdCountry) WHERE IdCountry=".Country::$UserCountryId); while(db::Fetch()){ echo "https://$adr/darky/".db::$data["RewriteName"]."/". db::$data["Tag"].""; } db::Query("SELECT * FROM tag t inner join tagname tn using(idTag) WHERE Available=1 AND IdCountry=".Country::$UserCountryId); while(db::Fetch()){ echo ""."https://".$adr."/tag/".db::$data["RName"]."\r"; } db::Query("SELECT * FROM blog WHERE Published=1 and idcountry=".Country::$UserCountryId); while(db::Fetch()){ echo ""."https://".$adr."/blog/".db::$data["RewriteName"]."\r"; } } $prods=db::QueryArray("SELECT * FROM product p INNER JOIN productname pn USING(IdProduct) WHERE Available=1 AND ProductType='printable' AND pn.IdCountry=".Country::$UserCountryId); $motives=db::QueryArray("SELECT * FROM motiv INNER JOIN motivname mn USING(IdMotiv) WHERE Available=1 and mn.IdCountry=".Country::$UserCountryId." ORDER BY Popularity DESC"); if($lims[0]=="0"){ foreach($motives as $motiv){ echo ""."https://".$adr."/".REWRITE_PRINT."/".$motiv["RewriteName"]."\r"; } foreach($prods as $prod){ echo ""."https://".$adr."/".REWRITE_GIFTS."/".$prod["RewriteName"]."\r"; } } $list = db::QueryArray("SELECT pn.RewriteName as prod,mn.RewriteName as mot FROM design_seo INNER JOIN productname pn USING(IdProduct) INNER JOIN motivname mn USING(IdMotiv) WHERE pn.IdCountry=".Country::$UserCountryId." AND mn.IdCountry=".Country::$UserCountryId); foreach($list as $seo){ echo ""."https://".$adr."/".REWRITE_DESIGN."/".$seo["prod"]."/".$seo["mot"]."\r"; } ?>