Contributions

The previous mySQL 5 fix did not work for me so I looked around and found some answers and modified /includes/modules/featured_sets.php again at it is working on my shop with mySQL 5.

Just wanted to share this with others.

Only featured_sets.php included.

On my server the file:

catalogincludesmodulesfeatured_sets.php

was displaying an error for my SQL server 5. I identified the SQL problem being on line 90-91. At the end of line 90 add a '(' just before the closing quote and on line 91 add a ')' after

TABLE_MANUFACTURERS_INFO . " mi

and it works. I have attached the updated featured_sets.php file.

Thankyou for the contribution.

This is a complete package

+ Added color picker to product/manufacturer separating lines.
Special thanks to Matt Kruse <matt (at) mattkruse (dot) com> for this javascript.
+ fixed separating lines so that horizontal and verticle lines are the same color
+ Added separating line thickness.
+ Fixed Category Features not excluding products with "off" status.
+ Fixed issue where products with "off" status were displaying in Catagory features.
+ Fixed SQL 5.0 incompatibility.
+ Added section (Featured) title to a couple sets for visitor clearity.

Support:
http://forums.oscommerce.com/index.php?showtopic=196872

----------------------------------
Abstract
----------------------------------

The contribution allows these 4 featured sets:

- Featured Products
- Featured Products by Category
- Featured Products by Manufacturer
- Featured Manufacturers

The admin has many choices for each section (one section shown here):

- Display products in featured boxes.
- Choose to display products from just current category or all featured products.
- Supports unlimited depth of categories
- Optionally displaying buy now buttons.
- Built in optional support for sidkiller(#952) on buy now buttons.
- Choose to display on catalog home, categories, product list, and product info pages.
- Choose layout and position of featured products section.
- Set Maximum number of Featured products to display.
- Display featured products in a column/row layout.
- Specify a specific description or select number of words from default description.
- Supports Asian characters by providing a number of characters description limit.
- Expire feature time periods with ability to suspend expiry.
- Choose from 4 featured products set layouts.
- Choose from 6 featured products set styles.
- Display a box shadow and set the shadow direction.
- Display featured products set in single group box or in individual boxes.
- Set the sort order for the feature products or display random.
- Sort ascending or descending.
- Products vertical line height.
- Products vertical line color.
- Products horizontal line color.
- All formatting is controlled by stylesheet.css entries.
- Turn featured sets on or off.
- Specify the display order for each of the 4 featured sets.

+ Based on Wolfens Featured Sets v1.03. See changelog for a list of changes.

Support:
http://forums.oscommerce.com/index.php?showtopic=196872