This mod only allows you to select products that have an enabled status. Optional categories staus included.
in catalog/admin/star_product.php:

FIND:
$star_query = tep_db_query(”select p.products_id, pd.products_name from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd where p.products_id = pd.products_id and pd.language_id = ‘” . $languages_id . “‘ order by pd.products_name”);


REPLACE WITH: (if you do not have Enable & Disable Categories contrib installed)
$star_query = tep_db_query(”select p.products_id, pd.products_name, p.products_status from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd where p.products_id = pd.products_id and pd.language_id = ‘” . $languages_id . “‘ and p.products_status = ‘1′ order by pd.products_name”);

OR

REPLACE WITH: (if you have Enable & Disable Categories contrib installed)
$star_query = tep_db_query(”select p.products_id, pd.products_name, p.products_status from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd left join ” . TABLE_PRODUCTS_TO_CATEGORIES . ” p2c on p.products_id = p2c.products_id left join ” . TABLE_CATEGORIES . ” c on p2c.categories_id = c.categories_id where p.products_id = pd.products_id and pd.language_id = ‘” . $languages_id . “‘ and p.products_status = ‘1′ and c.categories_status = ‘1′ order by pd.products_name”);

This entry was posted on Thursday, July 30th, 2009 at 6:14 pm and is filed under eCommerce Site News. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.