Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Froogle Exporter and Hidden Products


sixonetonoffun

Recommended Posts

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.

 

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...