17 Feb 2008, 10:15 AM
New Zenner
- Join Date:
- Dec 2007
- Posts:
- 3
- Plugin Contributions:
- 0
New Products show's inactive products
I just did a clean install of version 1.3.7 and found that the new products module was showing up inactive products as well as active products.
Digging around in /includes/modules/new_products.php the fix is on line 46 to edit so that it reads
$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id in (" . $list_of_products . ")
and p.products_status = 1";
Hope this helps someone.
