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.

[Anonymous]

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.

[Anonymous]

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!