This is a discussion on Featured Products within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; This mod eliminates products from the drop down menu if they are a. a disabled product AND/OR b. a product ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| This mod eliminates products from the drop down menu if they are a. a disabled product AND/OR b. a product in a disabled category, if the enable/disable categories mod is installed. 1. in catalog/admin/featured.php: FIND: $featured_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s where s.products_id = p.products_id"); REPLACE WITH: if you do not have catagory enable diable contrib installed // 10 Aug 2007 eliminate disabled products and products in disabled categories $featured_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s on p.products_id = p2c.products_id where s.products_id = p.products_id OR p.products_status = '0'"); OR if you have catagory enable/disable contrib installed: // 10 Aug 2007 eliminate disabled products and products in disabled categories $featured_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s 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 s.products_id = p.products_id OR p.products_status = '0' OR c.categories_status = '0'"); More...
__________________ Michael Sasek osCMax Developer
|
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Featured Products | michael_s | New osCommerce Contributions | 3 | 07-27-2007 10:23 AM |
| Featured Products | michael_s | New osCommerce Contributions | 0 | 03-23-2007 12:00 PM |
| Featured Products | michael_s | New osCommerce Contributions | 0 | 02-06-2007 01:11 AM |
| Featured Products HELP Please. | lil-raskals | osCommerce 2.2 Modification Help | 0 | 10-07-2004 06:51 AM |
| Featured Products | Stu | osCMax v1.7 Discussion | 3 | 09-13-2004 07:42 PM |