Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Specials not showing on product_info.php


Irin

Recommended Posts

I've added the add-on "easy advanced specials admin", but I have a problem with it. The add-on applies the specials on all my pages and modules, except the product_info.php page. If I go into the product info page, I can only see the original price. There is no discount price. Please help...

 

Here is the code with the specials code in it:

 

$product_info_query = tep_db_query("select p.products_date_added, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_part, p.products_quantity, p.products_image, p.products_pdfupload, p.products_fileupload, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_lead_time, p.minorder, p.products_bundle from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

$pf->loadProduct((int)$HTTP_GET_VARS['products_id'], (int)$languages_id);
$products_price=$pf->getPriceString();

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
  $products_price_short = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
} else {
  $products_price_short = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
}

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...