Contributions

I find a bug when add the Flash Carousel and the Featured products in the index.php (An error about "featured_products_category_id" variable is showed )

I solved the problem modifying the file catalog/modules/includes/featured.php in line 20:
old:
$featured_products_category_id = new_products_category_id;
new:
$featured_products_category_id = (isset($new_products_category_id))?$new_products_category_id:'0';


No full package!!!!!!
the download only includes the modified file.

To install, simply unzip the file on your store base directory.

---
Adolfo
Negoweb Negocios en Internet S.L.

- Fixed for register_globals off.
When off, after selecting a product from the search results the select box of all products still displays since $action was undefined.

- Changed setup for adding new product:
Instead of only being able to search, there are now two buttons on the main page. a "Search" button which will give you the option to search for a new product, and a "New Product" button which will allow you to use the 'old' way of just selecting a product from the dropdown.

(Note: if you do only want the search feature instead of both, look at lines 221-225 in featured.php to switch it)

- Updated global variables to short versions - ie $_GET, $_POST instead of $HTTP_GET_VARS and $HTTP_POST_VARS (not a biggie, just nicer ;) )


NOT full package!

Included:
admin/featured.php
admin/select_featured.php

This is an updated version of Featured Products. The only changes in this version are clarifications in the install file and an addition in the "Modified Files" folder to reflect the changes from the prior 1.6.2 version. Please notify (either PM or forum) of any problems found.

Please note: the file select_featured.php in admin/includes/languages/english is currently only available in English. I would try to translate but I do not wish to offend anyone so if there is someone who can help with this it would be great. Thanks.

This is a FULL PACKAGE.

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

It's turning out to be one of those days...

Featured Products v1.6.2 (final) introduces a new search function (based on the Select Specials contribution) for the featured products administration. Instead of using a dropdown you may now search for your products by either title or model number to quicken the featured product selection.

This is the final upload of Featured Products v1.6.2 with full search integration. Please disregard both previous 1.6.2 versions of this contribution. Thanks.

This is an update to the previous upload. I have fixed a typo and revised some code that was not correctly mirrored from the Select Specials contribution. Sorry about that.

This is a FULL PACKAGE. Please disregard the previous upload. Thanks.

This update includes a small mod to eliminate the product dropdown when picking featured products and replaces it with a search function.

This search works like, and was taken from, the Select Specials contribution found here: http://addons.oscommerce.com/info/2044

This is a FULL PACKAGE. To install simply follow the instructions included in the zip file. If you have installed a previous version of Featured Products then you can follow the instructions for a manual install found in the "Extra Mods" file in this zip. The manual install is extremely simple and will take no longer than a few minutes.

if you get this error

1054 - Unknown column 'p.products_id' in 'on clause'

do this in /includes/modules/featured.php


find this
$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);


and change into...



$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c )left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);
}

Update more easy to install

Tooltip is a Rollover zoomimage javascript.
Easy to install.

Note: this update only work with 3images contrib or Additional_Images contrib


Exemple: www.expodreams.com/gallery/index.php

Enjoy!

All I did was roll up the previous 2 mods:

1. sql addition for admin options
2. tooltip and additional images compatibility

I'm not supporting this - I just have a hard time with partial packages and thought someone else might benefit.

Scott

Rollover zoom on featured images.
Easy to install.

Woks with (or without) the Additional_Images contrib.(tested with v2.0.0).

Exemple: www.expodreams.com/gallery/index.php

Enjoy!

Addition of configuration options to control:
* whether to display featured items in nested categories
* to only show featured items that are on special

Download "Featured Products 161 with STS 453 instructions" by Phocea and then copy featured.php over catalog/includes/modules/featured.php

Look over sql to decide what needs to be added to an existing installation. Most likely just the last two statements for the new configurable options.

Fixed an error I introduces in the featured module when using it directly on the index page.

Full package replacing 1.6.0

*Optimized the SQL query in the featured module, listing and box:
- uses left joins
- added joins with specials and product_description table
- removed call to tep_get_special_price and tep_get_products_name.
*Fixed module to get all featured in subcategory (logic was there but not used!)
*Few other small fixes and code cleanup
*Added an index on the featured table SQL creation

This is a full package not including previous mods for disable categories or SPPC

This only contains the file includes/modules/featured.php
The original file only shows featured products from the category that you are in plus categories nested 1 level down (if you are not on the main page).
This version shows products from the category that you are in plus all nested categories under it.

You need SambaMambo's fix *only* if you have installed TotalB2B mod.

Because only TotalB2B mod changes parameter structure of display_price() function, and generates "missing argument" errors.

3 Changes to do in :
open /includes/modules/featured.php
find $currencies->display_price
add
$featured_products['products_id']

Go to here for example :
http://forums.oscommerce.com/index.php?showtopic=292023&st=0&gopid=1217721&#entry1217721

After installaling this contribution and i get an SQL error for /module/feature.php not able to load on index.php, sql 5 error syntax, due to mising
'MAX_DISPLAY_FEATURED_PRODUCTS_LISTING' in SQL database.

I found a fix to add this in Application_Top.php

define('MAX_DISPLAY_FEATURED_PRODUCTS_LISTING', '10');
define('MAX_DISPLAY_FEATURED_PRODUCTS', '6');
define('FEATURED_PRODUCTS_DISPLAY', 'true');

But instead i found an easier way to if we insert this SQL to the database. Problem fixed.

I'm not the programmer but would like to share what i found.

INSERT into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Maximum Display of Featured Listing', 'MAX_DISPLAY_FEATURED_PRODUCTS_LISTING', '10', 'This is the maximum amount of items listing on the front page.', '39', '2', now(), now()
);

Laden Sie die Contribution "Featured_Products_v4.3" herunter und installieren Sie diese nach Anleitung.

Anschliessend die Dateien in die entsprechenden Verzeichnisse einspielen fertig :-O).
Alles auf eigene Gefahr.

If you want to show new products of the mont while there is no featured products.

add this code to /includes/modules/featured.php


if ($num == 0)
{
include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);
}

before the closing

?>

Featured Products Flash Timeline Version 0.1 from Osicommerce

This addon lists featured products with different floating style and interacts with mouse move. Compatible with Cre loaded ecommerce system and featured sets contribution.

Demo : http://osicommerce.com/demo1/dynamic_showcase.php

NOTE : Install featured products contribution first to use this addon!




INSTALLATION STEPS

1-Upload following files to your store

catalog/galeri.swf
catalog/galleryTimeline.php
catalog/featured_flash.php
catalog/includes/languages/english/featured_flash.php

2-Open your filename.php (in catalog/includes) and add this line:

define('FILENAME_FEATURED_FLASH', 'featured_flash.php');


3-Open your index.php (in catalog/includes/languages/english) and add this line:

define('TABLE_HEADING_FEATURED_FLASH', 'Featured in Action');


4-Open your featured.php (in catalog/includes/modules) and make following change:

FIND:

$info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>');


CHANGE WITH:
$info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>&nbsp;&nbsp;&nbsp;&nbsp;<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_FLASH) . '">' . TABLE_HEADING_FEATURED_FLASH . '</a>');



5-Finished.Have Fun!

SUGGESTIONS:
# Add over 10 featured products to best result
# Use UltraPics image contrib to prevent image size problem, with this way you can control thumbnail listing images.

UltraPics contribution url (use dated --5 Nov 2006-- version): http://www.oscommerce.com/community/contributions,1642


send your question to osi@osicommerce.com

If you need customization for this contrib please contact me.

kadir

Changed the button in featured admin to be a little clearer. Instead of delete it now says remove as featured item.

NOTE: COMPLETE STEPS 1 AND 2 for each language you use.


1. upload catalog/admin/includes/languages/english/images/buttons/button_delete_featured.gif
2. in catalog/admin/featured.php
***FIND***
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . '&nbsp;<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

***CHANGE TO:***
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete_featured.gif', IMAGE_DELETE_FEATURED) . '&nbsp;<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

2. In catalog/admin/includes/languages/english/featured.php:

***ADD***
define('IMAGE_DELETE_FEATURED', 'Remove product from Featured Product list');

***CHANGE***
define('TEXT_INFO_DELETE_INTRO', 'Are you sure you want to delete this featured product?');

***TO***
define('TEXT_INFO_DELETE_INTRO', 'Are you sure you want to remove this product from the Featured Product list?');

***FIND***
define('TEXT_INFO_HEADING_DELETE_FEATURED', 'Delete Featured Product');

***CHANGE TO***
define('TEXT_INFO_HEADING_DELETE_FEATURED', 'Remove From Featured Product List');

3. in catalog/admin/featured.php
***FIND***
$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

***CHANGE TO:***
$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=delete') . '">' . tep_image_button('button_delete_featured.gif', IMAGE_DELETE_FEATURED) . '</a>');


***FIND***
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b>');

***CHANGE TO***
$heading[] = array('text' => '<center> <b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b></center>');

The 10 aUG 2007 modification belowf or enable/disable categories doesn't allow one to list products in disabled categories as featured items.
This neglects business workflow,
Most people use disable categories to prepare products for future use (e.g a holiday collection), hence they should be able to get everything ready, including listing some products as featured before those categories are active.

I modified the query in featured_products.php so only products in active categories are shown.
Around line 59, find
$featured_products_array = array();
$featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name";

REPLACE WITH:
// ################## Added Enable Disable Categorie Featured products mod by Bruin_03#################
$featured_products_array = array();
$featured_products_query_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, c.categories_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from ". TABLE_PRODUCTS ." p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "') LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_FEATURED . " f ON (p.products_id = f.products_id)
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 c.categories_status='1' AND p.products_status = '1' AND f.status = '1'
ORDER BY p.products_date_added
DESC, pd.products_name";

// ################## OEF Added Enable Disable Categorie Featured products mod by Bruin_03#################

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

Featured Products 1.5.9 Updated

These instructions were modified by Bill Kellum (bkellum) to assist STS users to install the Featured Products 1.5.9 contribution.

If you do not use STS (Simple Template System), then you can still use these simple instructions to install the Featured Products contribution but should discard steps 15, 15.1 and 15.2.

For those who prefer to make code modifications using a file comparison program, I have included all of the files (both new and modified) in this package. Manual code modifications have been updated as well in very simple to follow steps.

Credit goes to all those before who have contributed to this wonderful contribution.

Support links provided in text.

This is a full package other than some language files not provided; however, all previous language edits have been included.

Whole package install with instructions (v4.3.3) that had been removed.

Includes the instructions for STS.

Short set of instructions detailing how to make use of Featured Products 1.5.9 with STS 4.3.3.

Also an update to the Admin interface which allows enable/disable contribution by choosing true/false from a pick list (like most other true/false options in Admin) rather than typing the word true or false.

Included vertical scrolling function to the Featured Box and adding little text to the portuguese language and it can be included to the other languages. This text is important to show the correct name of the box in the center of mainpage.

Dutch Language Files

This package keep the same thing in "Featured Products 1.5.8 Complete Pack". Just a little changes to 'install_english.txt' and 'instalacion_spanish.txt'. It clearly explained the way to uninstall/disable the featured products package.

* Totally removing the Featured Products Infobox means removing each of the lines that were added during the INSTALLATION part of this documentation, and then remove the files that were added.

COMPLETE PACK - VERSION ONLY FOR DEFAULT INSTALLATION OF OSCOMMERCE

This version Featured Products 1.5.8 include:
--------------------------------------------

- ALL the before versions and fixes since version "Featured Products v1.5.5" of Cédric R of date 17 Jun 2005. All credits are for they.

( without SPPC installed (24 May 2006), specials valin form (12 May 2006) and depper categories (7 Apr 2006) )

- Fixed: dont duplicate New Products module when desactive this featured module

- Featured infobox for columns

- Add install instructions in spanish

- screenshots

* See changelog.txt file for a detailed info of all changes.



FOR SPPC USERS: if you have installed SPPC contributions then have to do extra installation of version "Featured Products v1.5.6 by guardianms of 24 May 2006

FOR "Specials valid from" users (http://www.oscommerce.com/community/contributions,2520/ by Felix Schwarz) then do the modification of this version 1.5.8 and then fixed of version: Specials valid from - Calendar Fix dwdonline 12 May 2006, in file catalog/admin/featured.php

FOR deeper categories installed do the modification of this version 1.5.8 and the fix of version: mysql5 fix deeper categories by saho of 7 Apr 2006, in file catalog/includes/modules/featured.php



DEMO:

http://www.oscommerce-demo.com/demo01/

(Note: this demo include graphical modification of modules not include in this contribution)




------- in spanish -------



PACK COMPLETO - VERSION PARA CATALOGOS QUE NO TENGAN INSTALADO LA CONTRIBUCION SPPC

Esta version Featured Products 1.5.8 incluye:
--------------------------------------------

- TODOS los cambios y correcciones anteriores desde la version: "Featured Products v1.5.5" de Cédric R de fecha 17 Jun 2005. Los creditos corresponde a ellos.

( menos la version para SPPC (24 May 2006), specials valin form (12 May 2006) y depper categories (7 Apr 2006) )

- Correccion: para que no duplique el modulo de "Nuevos Productos en mes..." cuando se desactiva este modulo de Productos Destacados

- Incluye tambien el modulo para mostrar un producto destacado en una de las columnas.

- Instrucciones de instalacion en español

- screenshots

* Ver el archivo changelog.txt para ver en detalle los cambios de cada version hasta esta.



PARA USUARIOS DE SPPC: si tiene instalado la contribucion Separate Pricing Per Costumer SPPC entonces para la instalacion de esta contribucion siga las instrucciones de la version "Featured Products v1.5.6 de guardianms de fecha 24 May 2006

PARA USUARIOS de la contribucion "Specials valid from" (http://www.oscommerce.com/community/contributions,2520/ de Felix Schwarz) instale esta version 1.5.8 y despues realice la correccion indicada en la version: Specials valid from - Calendar Fix de dwdonline del 12 May 2006, en el archivo catalog/admin/featured.php

PARA USUARIOS de deeper categories haga la modificacion de esta version 1.5.8 y luego haga la correccion indicada en la version: mysql5 fix deeper categories de saho de fecha 7 Apr 2006, en el archivo catalog/includes/modules/featured.php



DESCRIPCION:
-----------
Esta contribucion añade un nuevo modulo similar al de "Nuevos Productos en mes..."
Pero los productos pueden ser seleccionados desde el admin, tambien se puede seleccionar una fecha de caducidad a partir de la cual no se muestren.
Se puede seleccionar desde el admin mostrar o no este modulo, y el numero de productos destacados que mostrara.
En la portada mostrara una seleccion de los indicados como productos destacados, y en las categorias que tengan subcategorias mostrara solo los productos destacados que pertenezcan a esa categoria, en caso de no haber ninguno de esa categoria no mostrara el modulo.

Ademas incluye un modulo para la columna derecha o izquierda que muestra un producto destacado aleatorio.

New package including portuguese translation of files and database.

Tradução do módulo produtos destacados para o português, incluindo admin. Pacote completo com as demais traduções.

If you use the Contribution Infobox Admin, there have to be made some slight modifications on 18.11.2004 Featured Products Infobox by Lutz Hecht.

1. Rename the file featured_box.php that comes with 18.11.2004 Featured Products Infobox into featured.php. Infobox Admin already has an entry in its table for this, so no modifications on the database have to be made

2. Whenever the filename featured_box.php is mentioned in the readme of 18.11.2004 Featured Products Infobox, change it to featured.php

3. In the readme of 18.11.2004 Featured Products Infobox are only the languages German and English included. You have to make your modifications in all languages you have installed, of course.

Added the ability to add or delete multiple products at the same time. This is not the cleanest hack, but works none the less. It is a combination of the multiple categories quick add and featured products. Screen shots included. Does not include anything past v1.5.5.

If you have "Specials valid from" http://www.oscommerce.com/community/contributions,2520/ by Felix Schwarz the calendar will not work on your featured.php in the admin section as the java script was changed. This is a simple fix for that. Even if you do not have that contribution - and the calendar is not working this should fix it.

The last package was not for deeper categories fix. This statement is if you have deeper categories installed.

This fixes the 1054 error you get after upgrading to mysql 5. replace statement in catalog/includes/modules/featured.php

Good Luck

Just a little correction of a syntax in "featured_products_french.sql"

with precedent bug_fix

Complete package
(All credits goes to their respective owners)

well as i know many people would require the featured module along with the new products column. So there you go... its a pretty simple editing and no files to download...


Before you begin:

BACKUP!! BACKUP!! BACKUP!!


in catalog/index.php instead of replacing the values as said in the readme find the following line:

<?php echo TEXT_MAIN; ?></td></tr>

Add After:

<?
// FEATURED PRODUCT START...
?>

<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td>
</tr>
<?
// FEATURED PRODUCT END...
?>

****** Thats it you are done...Njoy!!...

The featured products contribution suffers from the same MS2 bug (bug report 1316) as new products ie "Even on a clean install new products will only show up in the new products category if they are one Category level or less in. Anything beyond that they do not show up." Here's the fix for the featured products contribution:

In "catalog/includes/modules/featured.php"

after line #34:

$info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name));

insert the following:

$subcategories_array = array();
tep_get_subcategories($subcategories_array, $featured_products_category_id);
$featured_products_category_id_list = tep_array_values_to_string($subcategories_array);
if ($featured_products_category_id_list == '') {
$featured_products_category_id_list .= $featured_products_category_id;
} else {
$featured_products_category_id_list .= ',' . $featured_products_category_id;
}

You now need to change original line #35 (after the additional lines of code above it will now be around line #43):

$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);


so that it becomes:

$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (" . $featured_products_category_id_list . ") and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);


Finally, if you haven't previously installed the 'new products bug fix', bug report ID 1316, then you will also need to add the following function to 'catalog/include/functions/general.php':

function tep_array_values_to_string($array, $separator = ',') {
$get_string = '';
if (sizeof($array) > 0) {
while (list($key, $value) = each($array)) {
$get_string .= $value . $separator;
}
$remove_chars = strlen($separator);
$get_string = substr($get_string, 0, -$remove_chars);
}
return $get_string;
}

Thanks for adding the languages to this contribution, I need them badly. But please check out the syntax errors. I tried the french and english databases, but both gave errors. waiting eagerly ;-)

Featured Products v1.5.2 + German (v1.5.3) + Catalan (v1.5.4) + French = v1.5.5

This package contains the complete contribution from 25th of january, plus french translated files and sql file in french for french administration.

If you had renamed the "categories_description" table in your database you would get an error.

Only changed the /includes/modules/featured.php on Line 20 as follows:

ORIGINAL:
$cat_name_query = tep_db_query("select categories_name from categories_description where categories_id = '" . $featured_products_category_id . "' limit 1");
$cat_name_fetch = tep_db_fetch_array($cat_name_query);


FIXED:
$cat_name_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $featured_products_category_id . "' limit 1");

Best adaptation for all languages:

Step 5:
Add the following line to /catalog/admin/includes/boxes/catalog.php, right before the line that contains <a href="'. tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>');

'<a href="' . tep_href_link(FILENAME_FEATURED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_FEATURED_PRODUCTS . '</a><br>' .

Step 6:
Add the following line to /catalog/admin/includes/languages/english.php, right before the line that contains define('BOX_CATALOG_PRODUCTS_EXPECTED', 'Products Expected');

define('BOX_CATALOG_FEATURED_PRODUCTS', 'Featured Products');

with the readme.txt ready

Featured Products v1.5.2 + German (v1.5.3) + Catalan = v1.5.4

This package contain the complete contribution plus catalan translated files and sql file in catalan for catalan administration.

After a long time trying to get a featured products contrib working, I finally found version 1.5.2 and got it working.
At first I could not get things working. I was receiving many errors and not seeing the 'features' tool in the admin page of my website. It was then that I realized that using a PHP editor and ENSURING it was saving the files, did the charm. I can't tell you how many times I removed files/edits and redid everything to try to track down the error. a PHP editor will save you MUCH debugging as it doesn't add invisible white spaces that KILL code.

SCROLL DOWN AND DOWNLOAD VERSION 1.5.2. It works. Any problems or help needed, contact me at whitestype@yahoo.com

(don't download this file, download 1.5.2 below - ignore the comments from others in the readme UNTIL you get to the first instruction)

A really usefull contribution if someone could tell me what files go in what folders?

The permutations in guessing are endless and simply cant spend the time on it.

Could someone who has implemented this on 2.2 please help?

Apologies if this cry for help has gone into the wrong section!

A.

Infobox für rechte oder linke Seite Boxen Spalte
Readme in Deutsch und Englisch

Neue Dateien:
featured_box.php

Info. box for right or left side boxes column
Readme in German and English

New files:
featured_box.php

Step 6:
Add the following lines to /catalog/includes/filenames.php

define('FILENAME_FEATURED', 'featured.php');

Updated:

Step 6:
Add the following lines to /catalog/includes/filenames.php

define('FILENAME_FEATURED', 'featured.php');
define('FILENAME_FEATURED_PRODUCTS', 'featured_products.php');

Jetzt gibt's die Version in Deutsch.

An den entsprechenden Stellen wurde die Installationbeschreibung für die deutsche Sprache angepasst.

Neue Dateien:
featured.php
featured_products.php
featured_products_german.sql

What?

Added back the featured_products.php page linked from the module and corrected a minor bug which resulted in a divide by zero on that page.

Featured Products v1.5.1
Appended by Raffles: 02 February 2004
Spanish translation added to this contribution. This package contain the complete contribution plus spanish translated files and sql file in spanish for spanish administration.

Just a small correction:
Featured instead of CATALOG_BOX_FEATURED!

Jesse, great job with the admin control. Much needed. However upon installing your complete version noticed that you left out some language files and it would not function when installed fresh.

I dropped in the files and reloaded.

I installed the last version and some files that were either not used or have somehow been broken from 1.3. So here is an extremely easy Featured replacement for you front page only. It also has an sql install that will give you admin control to turn it on or off. You can also designate the amount of products you wish to display from admin. Very easy and quick install. Simple to read instructions thanks to a previous contributor who gets named in the file.

This does the same as the last guy's seems we finished bout the same time.

I posted mine anyway because it also corrects the missing language define in
includes/languages/english/featured_products.php

I also commented out the add to cart button in /featured_products.php because it skips the product info page. That doesn't work good with master products. remove the tags and the button will show up again.

Featured Products InfoBox V1.3 by Aubrey Killian was orignally writen for an earlier version of osCommerce, and doesnt quite work in the current version of osCommerce. Whilst there are bits of pieces of information all over the forums and the contribution section to help users install V1.3 and get it up to date and working properly, this updated version simply takes the awesome work by Aubrey and the knowledge and help from others to make one all-inclusive contribution and things a bit easier. This contribution (V1.4) includes all the files and instructions that I used in my own installation to get things up and running in V2.2 MS2.

I take no credit for the original work or mods, and also dont take any responsibility if this doesnt work!

In Featured Products v1.3 install notes is told that you should
insert "define('TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY', 'Featured Products in %s');"
before very last curly bracket in /catalog/includes/languages/english/default.php,
but looks like in MS2 osCommerce version you need to edit
/catalog/includes/languages/english/index.php and insert not before last curly bracket,
but together with first inserted line "define('TABLE_HEADING_FEATURED_PRODUCTS', 'Featured Products');"
At least in my case it worked only this way.
PS: you don't need to download any file :)

This is the featured_products.php file needed to works fine in ms2

by all means it is not perferct but it works with no errors.

Is is one file. please download the full version featured_products1.3

Is is only a replacement..
Do not delete your file. just change the name to old..

I'm including in this package the files that should be replaced. Also, I've changed the random generator so that would be truly random.

** INSTRUCTIONS **

You just need to replace catalog/featured_products.php and catalog/includes/modules/featured.php with the files provided.

If you have many featured articles, you will only see the last products added.

With this little modification to this great contribution's source code, you can have your featured products rotate!

You just have to edit the file catalog/featured_products.php, go to line 56. It's the one that begins with a

$featured_products_query_raw = "select p.products_id,

Move to the end of it.

Where it says:

order by p.products_date_added DESC, pd.products_name

And replace with:

order by rand(now())


Save, and that's it! You should see a different featured products listing every time you see the featured products box or go to featured products.

(Note: No need to download the attached file, it's just a GPL licence)

Update of previous version.
Fixes some display bugs, including heading color and missing URL bugs on the Featured Products listing.
Now uses breadcrumbs too...

Blurb:
The purpose of this contribution is to replace the "New Products"
Infobox that appears on the main page and top-level category pages,
to show selected (by the admin) products in the infobox, instead
of new products. It's been written in such a way that the Infobox
will *not* show up if there are no featured products to display.

This is an updated version of my previous contribution.

Featured Products infobox is a replacement for the What's New infobox (middle of the page, not left or right column boxes). It features an on/off define to be able to switch the box on or off.

New in this version :
A page similar to the Products_New page, listing all the featured products...

This infobox will contain admin-specified (via admin interface) products. That's it. Just a featured products box really. :)

Read the README file for upgrade instructions from previous versions...

This is an updated version of my previous contribution. This works on yesterday's snapshot.

Featured Products infobox is a replacement for the What's New infobox (middle of the page, not left or right column boxes). It features an on/off define to be able to switch the box on or off (new in this version)

This infobox will contain admin-specified (via admin interface) products. That's it. Just a featured products box really. :)

The only thing missing from this contribution (I'll try to include in a later version) is a page similar to the Products_New page, listing all the featured products...

I've created this Featured Products infobox as a replacement for the New Products infobox. Includes admin page to add/delete featured products. It shows only featured products for the current category, or products from *all* categories when on the main default.php page. See lengthy README file inside archive file for more details, and installation instructions. No files get replaced, only small modifications done, so any cvs user should be safe.