Discount Groups Problem

[bufu]

hi all,

 

I tried to find the specific forum for this contrib, but there doesnt seem to be one.

I just installed the "Discount Groups" contrib, and ever since all prices in "product_info" turned to "0.00".

in every other page it's ok.

 

i copied what i think is the problematic part. please help.

thank you very much.

 

<?php

} else {

$cPath = $HTTP_GET_VARS['cPath'];

if(is_null($cPath) or $cPath == '') {

$cPath = 0;

}

$discount = tep_get_discount($cPath);

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_writer, p.products_artist, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id 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 . "'");

 

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

if ($discount > 0) $new_price = $new_price - ($new_price/100)*$discount;

$products_price = '<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 {

$price = $product_info_values['products_price'];

if ($discount > 0) $price = $price - ($price/100)*$discount;

$products_price = $currencies->display_price($price, tep_get_tax_rate($product_info_values['products_tax_class_id']));

}