Hi,
ich habe mich jetzt mit dem Ampel Modul abgekämpft und bekomme es nicht zum Laufen, zumal das Modul für XTC303 ist und ich 304SP1 am Laufen habe.
Schon alleine mit dem Code komme ich nicht klar:
Beispiel:
includes => modules => new_products.php
----------------------------------------------------------------------------------------------------------------------
Zeile 37-51:
$new_products_query = "select distinct p.products_fsk18,
p.products_id,
p.products_image,
p.products_price,
p.products_tax_class_id
from " . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,
" . TABLE_CATEGORIES . " c
where c.categories_status='1' and
p.products_id = p2c.products_id and
p2c.categories_id = '0' ".$fsk_lock."
".$group_check."
".$fsk_lock."
and p.products_status = '1'
order by p.products_date_added DESC limit " . MAX_DISPLAY_NEW_PRODUCTS;
----------------------------------------------------------------------------------------------------------------------
ersetzen durch:
----------------------------------------------------------------------------------------------------------------------
$new_products_query = "select distinct p.products_fsk18,
p.products_id,
p.products_image,
p.products_quantity,
p.products_price,
p.products_tax_class_id
from " . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,
" . TABLE_CATEGORIES . " c
where c.categories_status='1' and
p.products_id = p2c.products_id and
p2c.categories_id = '0' ".$fsk_lock."
".$group_check."
".$fsk_lock."
and p.products_status = '1'
order by p.products_date_added DESC limit " . MAX_DISPLAY_NEW_PRODUCTS;
Bei mir sieht die Zeile 36(37) - 51(44) so aus:
$new_products_query = "SELECT * FROM
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_DESCRIPTION." pd WHERE
p.products_id=pd.products_id and
p.products_startpage = '1'
".$group_check."
".$fsk_lock."
and p.products_status = '1' and pd.language_id = '".(int) $_SESSION['languages_id']."'
order by p.products_startpage_sort ASC limit ".MAX_DISPLAY_NEW_PRODUCTS;