Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/trigne/public_html/yandexmarket/dbconn.inc on line 6

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/trigne/public_html/yandexmarket/market.php on line 251
Экспорт данных в Yandex - Market
Выберите, пожалуйста разделы для экспорта.

<?

include "dbconn.inc";

//замена символов

//Переменные

$name = '3zed.ru'; //короткое название магазина, примера 3zed.ru

$company = 'ООО "Фарн-РК"'; //полное наименование компании, владеющей магазином. Не публикуется.

$url = 'http://www.3zed.ru'; //url-адрес первой страницы магазина

function _deleteHTML_Elements( $f )

            {

                   $f = str_replace('&ndash;', '', $f);

                   $f = str_replace('&quot;', '', $f);

                   $f = str_replace('&raquo;', '', $f);

                   $f = str_replace('&laquo;', '', $f);

                   $f = str_replace('&ldquo;', '', $f);

                   $f = str_replace('&rdquo', '', $f);

                   $f = str_replace('&bull;', '', $f);

                   $f = str_replace('&nbsp;', '', $f);

                   $f = str_replace('&oacute;', '', $f);

            }

if (@$edit) {            

//Функция начала вывода            

                $f = $f."<?xml version=\"1.0\" encoding=\"windows-1251\"?>\n";

                $f = $f."    <!DOCTYPE yml_catalog SYSTEM \"shops.dtd\">\n";

                $f = $f."        <yml_catalog date=\"".date("Y-m-d H:i")."\">\n";

                $f = $f."            <shop>\n";

                $f = $f."                <name>".$name."</name>\n";

                $f = $f."                <company>".$company."</company>\n";

                $f = $f."                <url>".$url."</url>\n";

                $f = $f."                <currencies>\n";

                $f = $f."                    <currency id=\"RUR\" rate=\"1\"/>\n";

                $f = $f."                </currencies>\n";

//Функция экспорта категорий товаров.

                $f = $f."                <categories>\n";            

//экспорт главных категорий    

                $Query = "SELECT * FROM `trigne_vm_category` WHERE parent_id = '0'";

                $result = mysql_query($Query);

                while ($rows=mysql_fetch_array($result)) {

                //проверка на выбранные категории

                $m=$rows[catid];

                If ($rasdel[$m]=="true") {

                $f = $f."                    <category id=\"".$rows[catid]."\">".$rows[catname]."</category>\n";

                }

//экспорт подкатегорий

                $Query2 = "SELECT * FROM trigne_vm_category_xref WHERE parent_id = '$rows[catid]'";

                $result2 = mysql_query($Query2);

                while ($rows2=mysql_fetch_array($result2)) {

                

                $m=$rows2[catid];

                If ($rasdel[$m]=="true") {                

                $f = $f."                    <category id=\"".$rows2[catid]."\"  parentId=\"".$rows2[parent_id]."\">".$rows2[catname]."</category>\n";

                                          }        

                                                            }

                                                         }

                $f = $f."                </categories>\n";    

//Функция экспорта товаров.

            $f = $f."                <offers>\n";                    

//экспорт товаров из главных категорий

                $Query = "SELECT * FROM trigne_vm_category";

                $result = mysql_query($Query);

                while ($rows=mysql_fetch_array($result)) {

                //Вставка товаров из категории

                //Проверка на выбранные разделы

                $m=$rows[catid];

                If ($rasdel[$m]=="true") {    

                  $Query3 = "SELECT * FROM `kpro_shop_articles` WHERE (articlecat = '$rows[catid]') OR (articlecat_2 = '$rows[catid]')";

                  $result3 = mysql_query($Query3);

                  while ($rows3=mysql_fetch_array($result3)) {

                   $f = $f."                   <offer  id=\"".$rows3[id]."\" available=\"true\" bid=\"15\">\n";            

                   $url = "http://www.3zed.ru/detailseite,".$rows3[artnumber].",".$rows3[articlecat].",0,0,1.htm";                    

                   $f = $f."                      <url>".$url."</url>\n";

                   $f = $f."                      <price>".$rows3[price]."</price>\n";

                   $f = $f."                      <currencyId>RUR</currencyId>\n";    

                   $f = $f."                      <categoryId>".$rows[catid]."</categoryId>\n";

                   $picture = "/public_html/components/com_virtuemart/shop_image/product/".$rows3[icon];

               if(file_exists($picture) AND $rows3[icon]<>'') {

                   $f = $f."                      <picture>http://www.3zed.ru/".$picture."</picture>\n";

                                         }

                   $f = $f."                      <name>".$rows3[title]."</name>\n";

                   $f = $f."                      <vendorCode>".$rows3[artnumber]."</vendorCode>\n";

                   //проверка на доступность товара параметр $available, читается из базы

                   $descr_short = strip_tags($rows3[descr_short]);

                   $f = $f."                      <description>".$descr_short."</description>\n";    

                   $f = $f."                   </offer>\n";

                                                           }}                                    

                 }

            $f = $f."                </offers>\n";                

//Конец формирования файла        

                $f = $f."            </shop>\n";

                $f = $f."        </yml_catalog>\n";

//Запись в фаил

if(file_exists('yandex.xml')) {unlink('yandex.xml');}

                   $f = str_replace('&ndash;', '', $f);

                   $f = str_replace('&quot;', '', $f);

                   $f = str_replace('&raquo;', '', $f);

                   $f = str_replace('&laquo;', '', $f);

                   $f = str_replace('&ldquo;', '', $f);

                   $f = str_replace('&rdquo', '', $f);

                   $f = str_replace('&bull;', '', $f);

                   $f = str_replace('&nbsp;', '', $f);

                   $f = str_replace('&oacute;', '', $f);

$file_hendle = fopen("yandex.xml", "a+"); //открываем файл

fputs($file_hendle,$f); // записываем в него

fclose($file_hendle);

header("Location:market-ok.php");

} ?>











<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">

<title></title>

</head>

<body>

<form action="market.php" method="post" enctype="multipart/form-data" name="form1">

<table>    

<tr>

<td><h3>Экспорт данных в Yandex - Market</h3> Выберите, пожалуйста разделы для экспорта.

<input name="export_categor" type="hidden" value="<?=$export_categor?>" /></td>

</tr>

<?

                $Query = "SELECT * FROM `kpro_shop_cat` WHERE parent_id = '0'";

                $result = mysql_query($Query);

                while ($rows=mysql_fetch_array($result)) {?>

<? If ($rows2[catid]==="checked") {$s="checked";} else $s="";?>                            

<tr>

<td><input name="<?=$rows[catid]?>" type="checkbox" value="<?=$rows[catname]?>" checked /><b><?=$rows[catname]?></b></td>

</tr>

<?

                $Query2 = "SELECT * FROM kpro_shop_cat WHERE parent_id = '$rows[catid]'";

                $result2 = mysql_query($Query2);

                while ($rows2=mysql_fetch_array($result2)) {?>

<tr>

<?

$m=$rows2[catid];

If ($rasdel[$m]=="true") {$s="checked";} else $s="";?>

<? $k=$rows2[catid];?>

<td>&nbsp;&nbsp;<input name="rasdel[<?=$k?>]" type="checkbox" value="true" checked /><?=$rows2[catname]?></td>

</tr>

                                                           <? }

                                                     }?>

<tr>

<td><input type="submit" name="edit" Value="Продолжить"></td>

</tr>                                                    

</table></form>

<body>

</html>