<?php
function no_accent($product_desc) {
$pattern = array("/é/", "/'/", "/è/", "/ç/", "/ /", "/€/", "/’/", "/&/", "/ê/", "/à/");
$rep_pat = array("é", "'", "è", "ç", " ", "€", "'", "&", "ê", "à");
$new_product_desc = preg_replace($pattern, $rep_pat, $product_desc);
return $new_product_desc;
}
$dbhost="db1569.1and1.fr";
$dbbasename="db252586330";
$dbuser="dbo252586330";
$dbpassword="uzW393KS";
$connect=@mysql_pconnect($dbhost,$dbuser,$dbpassword) or die ('ERREUR DE CONNEXION SQL 1 : Trop de personnes connectés');
@mysql_select_db($dbbasename) or die ('ERREUR DE CONNEXION SQL : Trop de personnes connectés');
Header( 'Content-Type: text/xml' );
echo '<?xml-stylesheet version="1.0" encoding="UTF-8" ?>';
echo '<catalogue lang="FR" date="'. date('d/m/Y'). '">';
$sql=@mysql_query('SELECT category_id , category_name from jos_vm_category');
while($res=@mysql_fetch_assoc($sql))
{
$cat[$res['category_id']]=$res['category_name'];
}
$sql=@mysql_query('SELECT * from jos_vm_product_category_xref');
while($res=@mysql_fetch_assoc($sql))
{
$cats[$res['product_id']][strtolower($cat[$res['category_id']])]=strtoupper(substr($cat[$res['category_id']],0,1)).strtolower(substr($cat[$res['category_id']],1,10000));
}
$sql=@mysql_unbuffered_query('SELECT *
FROM jos_vm_product
LEFT JOIN jos_vm_product_mf_xref ON jos_vm_product_mf_xref.product_id = jos_vm_product.product_id
LEFT JOIN jos_vm_manufacturer ON jos_vm_product_mf_xref.manufacturer_id = jos_vm_manufacturer.manufacturer_id
LEFT JOIN jos_vm_product_price ON jos_vm_product_price.product_id = jos_vm_product.product_id where product_price IS NOT NULL');
while($res=@mysql_fetch_assoc($sql))
{
// $product_desc= str_replace('é','é',$res['product_desc']);
$product_desc = $res['product_desc'];
$new_product_desc = no_accent($product_desc);
echo '<produit num="'.$res['product_id'].'">'."\n";
echo '<category><![CDATA['.implode(',',$cats[$res['product_id']]) . ']]></category>';
echo '<brand><![CDATA['.$res['mf_name'].']]></brand>';
echo '<manufacturer_id><![CDATA['. $res['product_sku'] .']]></manufacturer_id>';
echo '<merchant_id><![CDATA['. $res['product_id'] .']]></merchant_id>';
echo '<designation><![CDATA['. $res['product_name'] .']]></designation>';
echo '<description><![CDATA['. substr(strip_tags(str_replace(array('<BR>','<br>'), "</P>\n<P>",$new_product_desc)),0,245) .'...]]></description>';
echo '<ean13></ean13>';
echo '<shipping_cost>2.80 8.40</shipping_cost>';
echo '<shipping_to>FR DE IT GB BE LU PM AD CA RE SZ GF PF SC CH TF GN ES WF NC MC</shipping_to>';
echo '<stock_detail>Pièce neuve livraison en 48 heures</stock_detail>';
echo '<in_stock>O</in_stock>';//vous pouvez modifier ce champ: O= en stock, Y = en stock et N pour pas disponnible
$p=round(100*(($res['product_price']*19.6/100)+$res['product_price']))/100;
echo '<price>'. $p .'</price>';
echo '<fp monnaie="EUR">-1</fp>';
echo '<product_url><![CDATA[
http://www.mediscount.fr/index.php?o...ge&product_id='. $res['product_id'] .']]></product_url>';
echo '<image_url><![CDATA[
http://www.mediscount.fr/components/...image/product/'. $res['product_thumb_image'].']]></image_url>';
echo '</produit>';
}
echo '</catalogue>';
?>
Partager