No tak to jsme na tom stejně.
Když to někdo pak napíše, tak už to vypadá triviálně, co?

V tý úpravě si myslím, že bude problém v definici tý proměný:
$tax_rate = zen_get_tax_rate($products->fields['products_tax_class_id']);

Hodil jsem to přímo do cyklu za while, ale nevím jestli je to dobře. Možná by bylo lepší žádnou proměnou nevytvářet, a rovnou tam hodit zen_get_tax_rate($products->fields['products_tax_class_id'])

TAG nevim, todle je pro seznam a funguje mi to:

$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";
while(!$products->EOF)
{
$tax_rate=zen_get_tax_rate($products->fields['products_tax_class_id']);
$products_description = strip_tags($products->fields['products_description']);
if (strlen($products_description) > 512){
$products_description = substr($products_description, 0, 512) . '..';
}
$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";
//echo " <MANUFACTURER>" . $products->fields['manufacturers_name'] . "</MANUFACTURER>\n";
$text.= " <PRODUCT>" . clean($products->fields['products_name']) . "</PRODUCT>\n";
$text.= " <DESCRIPTION>" . clean($products_description) . "</DESCRIPTION>\n";
$text.= " <URL>" . $link . "</URL>\n";
$text.= " <IMGURL>".HTTP_SERVER.DIR_WS_CATALOG.DIR_WS_IMAGES. $products->fields['products_image'] . "</IMGURL>\n";
$text.= " <PRICE>".$products->fields['products_price'] . "</PRICE>\n";
$text.= " <VAT>".($tax_rate/100)."</VAT>\n";
$text.= " </SHOPITEM>\n";

a jeste:

$text.= " <PRICE_VAT>".((($products->fields['products_price'])*($tax_rate+100))/100) . "</PRICE_VAT>\n";

takze bych rekl ze je to dobre, mne to takle funguje ...

Citát:

Mrknu na to. Ale nevím jak z toho mohlo vzniknout desetinné místo, když v databázi je to např. jako 19.

napsal jsem samo blbost, uz jsem to opravil ... sorry
Citát:

Hmm, tak chybu jsem neudělal, mám to jako ty. Ale obě ceny jsou stejné a DPH mi píše 0. Počkám až to někdo vyzkouší.

Mno myslim ze by tam mela bejt jina fce

misto
zen_get_tax_rate

zen_get_tax_rate_value

Maybe

No SUPER, je to tak. Už to šlape.
Apropo kde zjistím tyto chytrý funkce?

Opravený verze již ke stažení v sekci "Ke stažení"

Btw může se tam umazat celkem 4x jestli umim pocitat

$affil = '';
if (isset($_GET['ref'])){
$ref = $_GET['ref'];
$affil = "&ref=$ref&";
}

, je to tam k ničemu... bylo to použito v první verzi...

Co se týče if sleva tak sleva napsal bych to takhle, nezkoušel jsem to ale vypada to ze to bude fungovat... maybe me nekde vypadla zavorka ...


switch($action) {
case ('centrum'):


$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";
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'];
}





$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.= " <MANUFACTURER>" . clean($products->fields['manufacturers_name']) . "</MANUFACTURER>\n";
$text.= " <PRODUCT>" . clean($products->fields['products_name']) . "</PRODUCT>\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(dodelat kategorii) . "</CATEGORYTEXT>\n";
$text.= " <IMGURL>".HTTP_SERVER.DIR_WS_CATALOG.DIR_WS_IMAGES. $products->fields['products_image'] . "</IMGURL>\n";
$text.= " </SHOPITEM>\n";

$products->MoveNext();