MS2-Max Bug in main page specials???

[midwestwebsites]

The specials box in the center of my main page only displays the 3 most recently added products rather than rotating through the list of entire store specials like the box that displays only 1 product at at time on the right.

Is this a bug or do I have something configured wrong?

[michael_s]

No, it is not a bug. You need to configure the box to show more than 3 specials. Do this in the admin under:

Maximum Values - Special Products

Set it to more than 3

It does not rotate through specials. That is not a feature of center box.

http://forums.oscommerce.com/index.php?showtopic=91342 is very similar to what you're talking about. You might be able to make that work on the specials.

Thank you Msasek and Guest! I've been wanting that center box to rotate for a long time now! That link Guest, is what gave me the code change.

Here it is for those of you interested:

in catalog/includes/modules/default_specials.php

Change this:

$new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_SPECIAL_PRODUCTS);


to this:

$new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by RAND() limit " . MAX_DISPLAY_SPECIAL_PRODUCTS);


It works, it actually works!!

[midwestwebsites]

That was my post above. I had logged in but I must have taken too long to reply and been logged out. Thanks again!