Community Add-Ons

Just a few corrections.

Includes all of the original files with the update to remove duplicates. Also changed scrolling_new_products.php so box links to new products instead of specials.

Full Package

only bug correct
--------------
replace this:

$rp_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where products_status = '1' and p.products_id not in (select products_id from " . TABLE_SPECIALS . " where status = 1) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

with this:

$rp_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where products_status = '1' and p.products_id not in (select products_id from " . TABLE_SPECIALS . " where status = 1) and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

---------------------------
No file included.

http://lavoriamopervoi.com/ecommercepervoi-vita-negozio-online-p-131.html

This is a modified version of the 'Web 2.0 Scrolling Specials' script released last week after a request from a member.

Same base functionality but does the following;
1. Selects a number of the latest products (how ever many you specified for the 'new products' box in admin) and scrolls through these like the Web 2.0 Scrolling Specials.

Modified to avoid specials and repeating products through the use of this and our other contribution.