my knowledge of PHP is poor, but do I assume correctly that is a metter of putting a call here to ignore certain categories ? (modules/specials_index.php)
PHP Code:
if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$specials_index_query = "select p.products_id, p.products_image, pd.products_name
from (" . TABLE_PRODUCTS . " p
left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
where p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' and s.status = 1 and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
} else {
$specials_index_query = "select distinct p.products_id, p.products_image, pd.products_name
from (" . TABLE_PRODUCTS . " p
left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id ), " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
TABLE_CATEGORIES . " c
where p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and c.parent_id = '" . (int)$new_products_category_id . "'
and p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' and s.status = '1' and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
}
or is it here to affect ALL "specials" enties, such as the box on the main page also
functions/specials.php
Bookmarks