Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with mod code


clarocque

Recommended Posts

Can anyone tell me what I have to change to get my specials window to show items with more thatn one status id?

 

I have changed it so I can set the status id to:

1 for window # 1

2 for window # 3

3 for window # 1 and 2

 

But how do i set the /includes/boxes/specials.php to show 1 or 3?

 

this is the code for that but I dont know how to change the one to allow 1 or 3.

if ($random_product = tep_random_select("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 p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {

 

Any help would be greatly appreciated...

 

Chris

osC Contributions I have published.

 

Note: Some I only provided minor changes, updates or additions!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...