Doporucuji si koupit starsi apple a mas po virech

Suped ikec funguje.

Jen kdyz clovek dava kategorii tak musi dat ne tu hlavni ale podkategorie. Jinak se to vygeneruje. To je jen pro ostatni

Super dekuji

ale kam to mam strcit?


jedna se o tento script

$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'];
$products_description = strip_tags($products->fields['products_description']);
if (strlen($products_description) > 512){
$products_description = substr($products_description, 0, 512) . '..';
}
$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']);
$plink = zen_seo_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id'], 'NONSSL', false);
$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>" . $plink . "</URL>\n";
$text.= " <IMGURL>".HTTP_SERVER.DIR_WS_CATALOG.DIR_WS_IMAGES. $products->fields['products_image'] . "</IMGURL>\n";
$text.= " <PRICE>". $price . "</PRICE>\n";
$text.= " <VAT>".($tax_rate/100) . "</VAT>\n";
$text.= " </SHOPITEM>\n";

$products->MoveNext();
}
$text.= "</SHOP>";
$zipfile = new zipfile();
$filedata = $text;
$zipfile -> add_file($filedata, "seznam.xml");
$filename = "../rss/seznam.zip";
$fd = fopen ($filename, "wb");
$out = fwrite ($fd, $zipfile -> file());
fclose ($fd);

Dobry den

Da se nejak upravit xml generator aby mi v jednom xml negeneroval urcitou kategorii?

Jiank to budu muset upravovat rucne

No jo ale j atam zadne Here nemam. Pise mi to v levi nahore a podlklad je zluty. co ted? pls

No kdyz vezmu ze na plesech jsou taky tomboly a losuje se a neni u toho notar

Dobry den

nevite kde bych mel co odmazat aby se mi pod kategorii nezobrazovalo nadpis nové zboží? Ale potrebuji aby se mi rozbrazovalo v oknem kdyz zakaznik prohlíží zboží.

Připojit soubor:

---

  nove zbozi.jpg (9.11 KB)

Dobry den

chtel jsem se zeptat chtel bych mozna udelat nejaolu soutez jako napriklad:

Kdo odpovi na tuto otazku dostanoou prvni tri vylosovani slevu na zbozi znacky XX slevu 500 Kč nebo v procentech.

Je toto napadnutelne? Nejsem registrovan ze muzu delat nejake souteze . Musi byt u toho notar? atd....

No optimalizoval jsem tabulky v DB a vse funguje.

Zdar mam jeden maly problem a nevim co s tim

Kdyz damneco hledat tak mi vyskoci

1194 Table 'pd' is marked as crashed and should be repaired
in:
[select count(distinct p.products_id) as total FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 2 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 2 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%cr9ek%' OR p.products_model LIKE '%cr9ek%' OR m.manufacturers_name LIKE '%cr9ek%' OR (mtpd.metatags_keywords LIKE '%cr9ek%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%cr9ek%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%cr9ek%') ))]

trochu nechapu.. Fungovalo to a nanic jsemnesahal