Froogle Exporter and Hidden Products

sixonetonoffun <[email protected]> 10 Aug 2003 22:25:36 -0000

Newsgroups	gmane.comp.web.oscommerce.tips
Message-ID	<4d88d6ee0eca58653d54b0e3827eeb76@osCommerce-Forums>

This message was sent from: Tips and Tricks
http://forums.oscommerce.com/viewtopic.php?p=211485#211485
----------------------------------------------------------------

Froogle Exporter version 1.20 and Lynda's Hidden Products 

I didn't see this specific topic covered anywhere (But I wouldn't be suprised if it is) so I thought I'd start a new one.
To NOT show Hidden Products in your Froogle dump file.

What I did was simple enough and seems to work fine. If there is a better way please chime in. I've only tested on one installation so take it at face value. Might be better coded in as another option but this worked out too.

[code]
About line 973 find
			ptoc.categories_id = subc.categories_id

Change to 
			ptoc.categories_id = subc.categories_id AND
                        p.products_customers_approved = 0

About line 1027 find
			ptoc.categories_id = subc.categories_id
Change to
			ptoc.categories_id = subc.categories_id AND
                        p.products_customers_approved = 0

About line 1110 find
			ptoc.categories_id = subc.categories_id
Change to 
			ptoc.categories_id = subc.categories_id AND
                        p.products_customers_approved = 0
About line 1207
	        	ptoc.categories_id = subc.categories_id
Change to 
		        ptoc.categories_id = subc.categories_id AND
                        p.products_customers_approved = 0

About line 1559 find
			$sql = "SELECT MAX( products_id) max FROM products";

Change to 
                        $sql = "SELECT MAX( products_id) max FROM products WHERE p.products_customers_approved = 0";
[/code]