[TEP-COMMIT] CVS: catalog/catalog/includes/modules upcoming_products.php,1.27,1.28

Update of /pack/cvsroots/oscommerce/catalog/catalog/includes/modules
In directory sunsite.dk:/tmp/cvs-serv21900/includes/modules

Modified Files:
	upcoming_products.php 
Log Message:
Properly fix bug 1481

Index: upcoming_products.php
===================================================================
RCS file: /pack/cvsroots/oscommerce/catalog/catalog/includes/modules/upcoming_products.php,v
retrieving revision 1.27
retrieving revision 1.28
diff -u -d -r1.27 -r1.28
--- upcoming_products.php	2004/02/16 07:29:50	1.27
+++ upcoming_products.php	2004/03/14 13:55:39	1.28
@@ -10,7 +10,7 @@
   Released under the GNU General Public License
 */
 
-  $Qupcoming = $osC_Database->query('select p.products_id, pd.products_name, p.products_date_available as date_expected from :table_products p, :table_products_description pd where to_days(p.products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = :language_id order by :expected_products_field :expected_products_sort limit :max_display_upcoming_products');
+  $Qupcoming = $osC_Database->query('select p.products_id, pd.products_name, p.products_date_available as date_expected, p.products_status from :table_products p, :table_products_description pd where p.products_status = '1' and to_days(p.products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = :language_id order by :expected_products_field :expected_products_sort limit :max_display_upcoming_products');
   $Qupcoming->bindRaw(':table_products', TABLE_PRODUCTS);
   $Qupcoming->bindRaw(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
   $Qupcoming->bindInt(':language_id', $osC_Session->value('languages_id'));



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click