Фото родительских товаров на дочерние товары при формировании файла для Яндекса - [VM1] Модификации и хаки

$mysql_query_category = mysql_query("SELECT category_id, category_name FROM jos_vm_category" );
	while($array_query_category = mysql_fetch_array($mysql_query_category))   
    {		
		  $category_id = $array_query_category['category_id']; 
		  $category_name = htmlspecialchars( $array_query_category['category_name'] );
		  $text .= "<category id='$category_id'>$category_name</category>";
		  $category_id_massiv[] = $array_query_category['category_id'];
	  }
	$text .= "</categories>";
    
  $text .= "<offers>";

  foreach ($category_id_massiv AS $category_id)
    {
      $mysql_query_product = mysql_query("SELECT
      jos_vm_product_category_xref.product_id,  
      jos_vm_product.product_parent_id, 
      product_name, 
      product_s_desc,
	  product_in_stock,
      product_thumb_image, 
      product_s_desc 
      FROM jos_vm_product, jos_vm_product_category_xref
      WHERE jos_vm_product_category_xref.product_id=jos_vm_product.product_parent_id
      AND product_publish='Y'
	AND
      jos_vm_product_category_xref.category_id='$category_id' " );
	
      
      while ($array_query_product = mysql_fetch_array($mysql_query_product))
        {         
         $product_id   = $array_query_product['product_parent_id'];
         $product_name = htmlspecialchars($array_query_product['product_name']);
         $picture      = $array_query_product['product_thumb_image'];
         $description  = htmlspecialchars($array_query_product['product_s_desc']);
		           
          $mysql_query_price = mysql_query ("SELECT product_price FROM jos_vm_product_price 
           WHERE product_id='$product_id'");
          while ($array_query_price = mysql_fetch_array($mysql_query_price))
          { 
 
          $product_in_stock  = htmlspecialchars($array_query_product['product_in_stock']);
		  if($product_in_stock	==	0) { $aviable	=	'false'; }
		  else { $aviable	=	'true'; }
         $text .= "<offer id='".$product_id."' available='".$aviable."'>";    
    $url_f = htmlspecialchars("http://$domen_url/index.php?page=shop.product_details&option=com_virtuemart&flypage=shop.flypage&product_id=$product_id&category_id=$category_id");
    $text.="<url>".$url_f."</url>"; 
                
         $text .= "<price>". ceil ($array_query_price['product_price'])."</price>";            
         $text .= "<currencyId>RUR</currencyId>";
         $text .= "<categoryId>$category_id</categoryId>";
         $text .= "<picture>http://".$domen_url."/components/com_virtuemart/shop_image/product/$picture</picture>";
         $text .= "<store>true</store>";  
         $text .= "<pickup>true</pickup>";  
         $text .= "<name>$product_name</name>";  
         $text .= "<description>$description</description>";
         $text .= "<manufacturer_warranty>true</manufacturer_warranty>";
         $text .= "</offer>";
         }
           
        }
        
    }
  

  <td align="center" valign="top" bgcolor="#F5F5F5" style="border-bottom:1px solid #CCC;">
	  <?php if ($db->f("product_in_stock")>0) {
	  echo "Есть <font style=\"font-style:italic;\"></font>";
	  } else {
	  echo "На заказ";
	  } ?>