Jump to content
Sign in to follow this  
barne214

XSELL Mod

Recommended Posts

I'm trying to add a stock status to the output of the xsell mod.

 

I assume I'd have to make the changes to /catalog/includes/modules/xsell_products.php. Can anybody help point me in the right direction? Thanks - Jim.

 

<?php

/* 

$Id: xsell_products.php, v1  2002/09/11



osCommerce, Open Source E-Commerce Solutions 

<http://www.oscommerce.com> 



Copyright (c) 2002 osCommerce 



Released under the GNU General Public License 

*/ 



if ($HTTP_GET_VARS['products_id']) { 

$xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); 

$num_products_xsell = tep_db_num_rows($xsell_query); 

if ($num_products_xsell >= MIN_DISPLAY_XSELL) { 

?> 

<!-- 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['specials_new_products_price'] = tep_get_products_special_price($xsell['products_id']); 



if ($xsell['specials_new_products_price']) { 

     $xsell_price =  '<s>' . $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</s><br>'; 

     $xsell_price .= '<span class="productSpecialPrice">' . $currencies->display_price($xsell['specials_new_products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</span>'; 

   } else { 

     $xsell_price =  $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_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><br>' . $xsell_price. '<br><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 > 2) {

         $col = 0;

         $row ++;

       }

     }

     new contentBox($info_box_contents);

?>

<!-- xsell_products_eof //-->









<?php

   }

 }

?>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×