How to setup special offer prices in x-sell modul ?

[Guest]

How to setup special offer prices in x-sell modul ?

 

i tried this one:

<!-- xsell_products //-->

<?php

$info_box_contents = array();

$info_box_contents[] = array('align' => 'left', 'text' => TEXT_XSELL_PRODUCTS);

new contentBoxHeading($info_box_contents);

 

$row = 0;

$col = 0;

$info_box_contents = array();

while ($xsell = tep_db_fetch_array($xsell_query)) {

$xsell['products_name'] = tep_get_products_name($xsell['products_id']);

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="smallText" width="33%" valign="top"',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $xsell['products_image'], $xsell['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . $xsell['products_name'] . '</a>

<s><br>' . $currencies->display_price($xsell['new_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</a></s><br>

<font color="red"><b>' . $currencies->display_price(tep_get_products_special_price($xsell['products_id']), tep_get_tax_rate($xsell['products_tax_class_id'])) . '<br></b></font>

<a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $xsell['products_id'], 'NONSSL') . '">' . tep_image_button('button_buy_now.gif', TEXT_BUY . $xsell['products_name'] . TEXT_NOW) .'</a>');

$col ++;

if ($col > 1) {

$col = 0;

$row ++;

}

}

new contentBox($info_box_contents);

?>

<!-- xsell_products_eof //-->

 

 

but i only get 0.00 as special price