Star Product v1.0

[michael_s]

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");




More...