Здравствуйте!
Не могли бы подсказать, как мне добавить в файл зкспорта название товаров и категорий на втором языке.
// get products
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
$req=mysql_query('SELECT pd.product_id, pc.category_id,cd.name AS cat, pd.name AS name, p.price as price, ps.price as aprice, p.model,p.image FROM product_description pd
INNER JOIN product p
ON (pd.product_id=p.product_id)
LEFT JOIN product_special ps ON (ps.product_id=p.product_id)
INNER JOIN product_to_category pc
ON (pc.product_id=pd.product_id)
INNER JOIN category c ON(c.category_id=pc.category_id )
INNER JOIN category_description cd ON(cd.category_id=c.parent_id or cd.category_id=c.category_id and c.parent_id=0)
WHERE cd.language_id=3 and pd.language_id=3 and p.status=1
');
$fp=fopen('/salidzini.xml','w');
$start='<?xml version="1.0" encoding="utf-8"?>
<root>
';
fwrite($fp,$start);
while($row=mysql_fetch_assoc($req)){
$price=number_format($row['price'],2,'.','');
$aprice=number_format($row['aprice'],2,'.','');
$image=str_replace(" ","%20",$row['image']);
$xml.="<item>\n";
$xml.="\t\t<name>".$row['name']."</name>\n";
$xml.="\t\t<link>".HTTP_SERVER."index.php?route=product/product&product_id=".$row['product_id']."</link>\n";
if ($aprice == 0) {$xml.="\t\t<price>".$price."</price>\n";}
else {$xml.="\t\t<price>".$aprice."</price>\n";}
$xml.="\t\t<image>".HTTP_SERVER."image/".$image."</image>\n";
$xml.="\t\t<category_full>".$row['cat']."</category_full>\n";
$xml.="\t\t<category_link>".HTTP_SERVER."index.php?route=product/category&path=".$row['category_id']."</category_link>\n";
$xml.="</item>\n";
}
fwrite($fp,$xml);
fwrite($fp,'</root>');