<?
case ('srovnanicen'):

                                $text= '<?xml version="1.0" encoding="' . CHARSET . '"?>
                                ';
                                ?>
<?php
$counts = $db->Execute("SELECT count(*) as number_active FROM " . TABLE_PRODUCTS . " WHERE products_status='1'");
$sql_products .= "select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image, m.manufacturers_name ";
$sql_products .= "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), ";
$sql_products .= TABLE_PRODUCTS_DESCRIPTION . " pd ";
$sql_products .= "where p.products_id = pd.products_id ";
$sql_products .= "and p.products_status = 1 and pd.language_id = '" . $_SESSION['languages_id']. "'";

$products = $db->Execute($sql_products);
$text.= "\n<SHOP>\n";
$text.= "<NAME>" . STORE_NAME . "</NAME>\n";
$text.= "<URL>" . HTTP_SERVER.DIR_WS_CATALOG . "</URL>\n";
while(!$products->EOF)
{

$product_id = $products->fields['products_id'];
$specials = $db->Execute("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and status='1'");
if ($specials->RecordCount() > 0) {
$price = $specials->fields['specials_new_products_price'];
} else {
$price = $products->fields['products_price'];
}
$categories = $db->Execute("select c.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " f where f.products_id = '" . (int)$product_id . "' and f.categories_id = c.categories_id ");


$tax_rate=zen_get_tax_rate_value($products->fields['products_tax_class_id']);
$link = HTTP_SERVER.DIR_WS_CATALOG."index.php?main_page=".zen_get_info_page($products->fields['products_id']). '&products_id=' . $products->fields['products_id'];
$text.= " <SHOPITEM>\n";
$text.= " <PRODUCT>" . clean($products->fields['products_name']) . "</PRODUCT>\n";
$text.= " <MANUFACTURER>" . clean($products->fields['manufacturers_name']) . "</MANUFACTURER>\n";
$text.= " <DESCRIPTION>" . clean($products->fields['products_description']) . "</DESCRIPTION>\n";
$text.= " <URL>" . $link . "</URL>\n";
$text.= " <PRICE>" .$price . "</PRICE>\n";
$text.= " <PRICE_VAT>" . ((($price)*($tax_rate+100))/100) . "</PRICE_VAT>\n";
$text.= " <VAT>" . ($tax_rate/100) . "</VAT>\n";
$text.= " <CATEGORYTEXT>" . clean($categories->fields['categories_name']) . "</CATEGORYTEXT>\n";
$text.= " <IMGURL>".HTTP_SERVER.DIR_WS_CATALOG.DIR_WS_IMAGES. $products->fields['products_image'] . "</IMGURL>\n";
$text.= " </SHOPITEM>\n";

$products->MoveNext();
    }
$text.= "</SHOP>";
$filename = "../rss/srovnanicen.xml";
$fd = fopen ($filename, "wb");  
$out = fwrite ($fd, $text);  
$zipfile = new zipfile();
$filedata = $text;    
$zipfile -> add_file($filedata, "srovnanicen.xml");
$filename = "../rss/srovnanicen.zip";
$fd = fopen ($filename, "wb");  
$out = fwrite ($fd, $zipfile -> file());  
fclose ($fd);
echo '<br><b>XML SrovnaniCen vytvořeno!</b><br>Celkem: ' . $counts->fields['number_active'] . ' produktů.<br>';
break;

                                ?>
                              </td>
                            </table>
                          </td>
                        </tr>
                        <tr>
                          <td>
                            <table>
                              <td>

 <tr>
                    <td class="main" width="15%" align="left" valign="top">
                      SrovnaniCen RSS
                    </td>
                    <td class="main" align="left" valign="middle">
                      <?php echo '<a href="' . zen_href_link(FILENAME_RSS, 'action=srovnanicen') . '">' . zen_image_button('button_update.gif', IMAGE_UPDATE) . '</a>'; ?>
                  </tr>
                  <tr>