Fejl i CreLoaded 6.2 pro

[Ib Holm]

I mainpage modulet upcomming_products vises varer, som ikke er aktive.

Hvis template "original" bruges, så find filen catalog/templates/original/mainpages_modules/upcomming_products.php

Her indsætter du to to linier, som er fremhævet med rødt. og så virker det.
Bruges andre templates skal de rettes tilsvarende.

Find:
$expected_query_raw= tep_db_query("select
p.products_id,
[highlight=red] p.products_status,[/highlight]
p.products_model,
pd.products_name,
p.products_image,
products_date_available as date_expected
from " . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_DESCRIPTION . " pd
where
to_days(products_date_available) >= to_days(now())
[highlight=red]and p.products_status >= '1'[/highlight] and p.products_id = pd.products_id
and pd.language_id = '" . (int)$languages_id . "'
order by rand()
limit " . MAX_DISPLAY_UPCOMING_PRODUCTS);