"; $result = mysql_query($q, $link); $value = ""; if($row = mysql_fetch_assoc($result)){ $value = $row['value']; $trans = array("?"=>" ", " "=>" "); $value = strtr($value, $trans); } return $value; } $q1 = "SELECT * FROM `catalog_product_entity`"; $result = mysql_query($q1, $link); $xml = ''."\n"; $xml .= "\n"; while($row = mysql_fetch_assoc($result)){ $entity_id = $row['entity_id']; $sku = $row['sku']; $category_path = ""; $category_ids = $row['category_ids']; $cat_id = explode(",", $category_ids); foreach($cat_id as $cat){ $category_path .= "/"; $category_path .= getValue("category_entity_varchar",$cat,47); } $cena = getValue("product_entity_decimal",$entity_id,60); $cena_specialni = getValue("product_entity_decimal",$entity_id,0); $price = $cena; if($cena_specialni!="" OR $cena_specialni!="0"){ $dnes = date(Ymd); $trans = array("-"=>""); $od = strtr(substr(getValue("product_entity_datetime",$entity_id,568),0,10),$trans)-1; $do = strtr(substr(getValue("product_entity_datetime",$entity_id,569),0,10),$trans)+1; if($dnes>$od AND $dnes<$do) { $price = $cena_specialni; } } // if($produkt[visibility] == 4) { $xml .= " \n"; $xml .= " ".getValue("product_entity_varchar",$entity_id,56)."\n"; $xml .= " ".strip_tags(getValue("product_entity_text",$entity_id,58))."\n"; $xml .= " ".$site."/".getValue("product_entity_varchar",$entity_id,83)."\n"; $xml .= " new\n"; $xml .= " ".$site.$img_path.getValue("product_entity_varchar",$entity_id,70)."\n"; $xml .= " ".$price."\n"; $xml .= " 20\n"; $xml .= " \n"; //} } $xml .= "\n"; echo $xml; ?>