Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

X-Sell Contrib help

smithygotlost

By smithygotlost
in General Add-Ons Support

 Share

Recommended Posts

smithygotlost

smithygotlost

Posted
Posted

i have installed x-sell contrib on our online shop link below

 

http://noizetrip.com/vibomusic/shop/produc...products_id=493

 

the some reason the x-sell is not 100% of the table how cna i solve this code below

 

product_info.php

<?php

/*

 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/



 require('includes/application_top.php');



 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);



 $product_check_query = tep_db_query("select count(*) as total 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_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function popupWindow(url) {

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')

}

//--></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->



<!-- body //-->





 <tr><td width="7"></td>

  <td valign="top" width="761">

   <table border="0" cellspacing="0" cellpadding="0" width="761">

	<tr><td width="206" valign="top"><?php require(DIR_WS_INCLUDES . 'column_left.php'); ?></td>

		<td width="8"></td>

		<td width="547" valign="top">

		 <table border="0" cellspacing="0" cellpadding="0">

		  <tr><td height="10" colspan="3"></td></tr>

		  <tr><td><img src="images/m33.gif" alt=""></td>





<?php

 if ($product_check['total'] < 1) {

?>



			  <td width="534" height="25" class="bg3"><span class="tx2">	   <?= TEXT_PRODUCT_NOT_FOUND; ?></span></td>

			  <td><?=tep_image(DIR_WS_IMAGES.'/m35.gif')?></td></tr>

		  <tr><td height="10" colspan="3"></td></tr>

		 </table>

		<table border="0" cellspacing="0" cellpadding="0" width="100%">

		<tr><td>



<?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>



<table cellpadding="0" cellspacing="0" border="0" width="100%">

 <tr>

	<td><table border="0" width="100%" cellspacing="1" cellpadding="2">

	  <tr>

		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

		  <tr>

			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

		  </tr>

		</table></td>

	  </tr>

	</table></td>

  </tr>

</table>

<?php

 } else {

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, 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'])) {

  $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 {

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

}



if (tep_not_null($product_info['products_model'])) {

  $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

  $products_name = $product_info['products_name'];

}

?>

			  <td width="534" height="25" class="bg3"><span class="tx2">	   <?php echo $products_name; ?></span></td>

			  <td><?=tep_image(DIR_WS_IMAGES.'/m35.gif')?></td></tr>

		  <tr><td height="10" colspan="3"></td></tr>

		 </table>

		<table border="0" cellspacing="0" cellpadding="0" width="100%">

		<tr><td>



<?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>



		 <table border="0" cellspacing="0" cellpadding="0" class="bg5">

		  <tr><td width="252" align="center">

<?

		$fileToResize = DIR_FS_CATALOG . DIR_WS_IMAGES . $product_info['products_image'];

		$resizedImageResult = resizeImage($fileToResize,SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);

		$resizedImage = $resizedImageResult[0];

		$resizedImageWidth = $resizedImageResult[1];

		$resizedImageHeight = $resizedImageResult[2];



?>

<script language="javascript"><!--

document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image($resizedImage, addslashes($product_info['products_name']),$resizedImageWidth,$resizedImageHeight,'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image($resizedImage, addslashes($product_info['products_name']),$resizedImageWidth,$resizedImageHeight, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>

</noscript>

			</td>				  

			  <td width="294" valign="top">		

			   <table border="0" cellspacing="0" cellpadding="0" width="263" align="center">

				<tr><td>

<!-- <br style="line-height:1px;"><br style="line-height:5px;"><span class="ml5_2"><?=$products_name;?></span> -->

						<br style="line-height:1px;"><br style="line-height:5px;"><span class="tx6"><?php echo stripslashes($product_info['products_description']); ?></span>

<!--							<br style="line-height:1px;"><br style="line-height:5px;">

						<br><span class="tx4">Price: <b><?=$products_price?></b></span>

						<br style="line-height:1px;"><br style="line-height:15px;"><?php //echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart.gif', IMAGE_BUTTON_IN_CART); ?> <?php // echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?>							
-->
				</td></tr>		

			   </table>

		  </td></tr>							

		 </table>







<table cellpadding="0" cellspacing="0" border="0" width="100%">

  <tr>

	<td class="main">
<br/><br/>
<?php

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

	  <table border="0" cellspacing="0" cellpadding="2" align="center">

		<tr>

		  <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
		</tr>

<?php

  $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

  while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {

	$products_options_array = array();

	$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

	while ($products_options = tep_db_fetch_array($products_options_query)) {

	  $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);

	  if ($products_options['options_values_price'] != '0') {

		$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

	  }

	}



	if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

	  $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

	} else {

	  $selected_attribute = false;

	}

?>

		<tr>

		  <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>

		  <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
		</tr>

<?php

  }

?>
	  </table>

<?php

}

?>


		<div align="center">				<br style="line-height:1px;"><br style="line-height:5px;">

						<br><span class="tx4">Price: <b><?=$products_price?></b></span>

						<br style="line-height:1px;"><br style="line-height:15px;"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart.gif', IMAGE_BUTTON_IN_CART); ?> <?php  echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?>							

   </div>

	</td>

  </tr>

  <tr>

	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

  </tr>

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

  <tr>

	<td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>

  </tr>

  <tr>

	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

  </tr>

<?php

}



if (tep_not_null($product_info['products_url'])) {

?>

  <tr>

	<td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

  </tr>

  <tr>

	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

  </tr>

<?php

}



if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

  <tr>

	<td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>

  </tr>

<?php

} else {

?>

  <tr>

	<td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>

  </tr>

<?php

}

?>

  <tr>

	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

  </tr>

  <tr>

	<td>
<?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
<?php
//added for cross -sell
  if ( (USE_CACHE == 'true') && !SID) {
echo tep_cache_also_purchased(3600);
 include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
  } else {
  include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
  }
?>	   </td>

  </tr>

<tr><td><? include(DIR_WS_MODULES . 'viewed_products.php');?></td></tr>

</table></form>

<!-- body_eof //-->



		   </td></tr>

		  <tr><td height="12" colspan="2" bgcolor="#FFFFFF"></td></tr>

		  <tr><td height="2" colspan="2" bgcolor="#7F7F7F"></td></tr>

		 </table>

	</td></tr>

   </table>

 </td></tr>					





<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->



</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

x-sell_products.php

 

<?php
/*
$Id: xsell_products.php, v1  2002/09/11
// adapted for Separate Pricing Per Customer v4 2005/02/24

osCommerce, Open Source E-Commerce Solutions
<http://www.oscommerce.com>

Copyright (c) 2002 osCommerce

Released under the GNU General Public License
*/
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_XSELL_PRODUCTS);

// BOF Separate Pricing Per Customer
if(!tep_session_is_registered('sppc_customer_group_id')) {
$customer_group_id = '0';
} else {
 $customer_group_id = $sppc_customer_group_id;
}

if ($HTTP_GET_VARS['products_id']) {

//Cache
$dircache = DIR_FS_CACHE_XSELL . $HTTP_GET_VARS['products_id'] . '/';
$filename = $dircache  . $languages_id . '-' . $customer_group_id . '.php';
$cache = '<?php 
 $info_box_contents = array();
 $info_box_contents[] = array(\'align\' => \'center\', \'text\' => TEXT_XSELL_PRODUCTS);
 new contentBoxHeading($info_box_contents);
 $info_box_contents = array();';
if (file_exists($filename))
{require $filename;}
else
{
//Fin cache

if ($customer_group_id != '0') {
$xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_GROUPS . " pg using(products_id), " . 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' and pg.customers_group_id = '".$customer_group_id."' order by sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED);
} else {
$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 sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED);
}
// EOF Separate Pricing Per Customer

$num_products_xsell = tep_db_num_rows($xsell_query);
if ($num_products_xsell > 0) {
?>
<!-- xsell_products //-->
<?php
 $info_box_contents = array('params' => 'class="smallText" width="33%" valign="top"',);
 $info_box_contents[] = array('align' => 'left', 'text' => TEXT_XSELL_PRODUCTS);
 new contentBoxHeading($info_box_contents);

 $row = 0;
 $col = 4;
 $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']));
  }
   //Cache
   $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>';
   //Fin cache
   $info_box_contents[$row][$col] = array('align' => 'center',
										  'params' => 'class="smallText" width="33%" valign="top"',
										  'text' => $text); //Modifié Cache
   //Cache
   $cache .= '$info_box_contents[' .$row . '][' . $col . '] = array(\'align\' => \'center\',
										  \'params\' => \'class="smallText" width="22%" valign="top"\',
										  \'text\' => \'' . str_replace("'", "\'", $text) .'\');';
   //Fin cache	   
   $col ++;
   if ($col > 2) {
	 $col = 0;
	 $row ++;
   }
 }
new contentBox($info_box_contents);
//Cache
 $cache .= 'new contentBox($info_box_contents); ?>';
 if(!is_dir($dircache)) { mkdir($dircache,0777); }
 $fp = fopen($filename , 'w');
 $fout = fwrite($fp , $cache);
 fclose($fp);
}
//Fin Cache

?>
<!-- xsell_products_eof //-->
<?php
  }
}
?>

 

thanks

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...