Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Cross-Sell (X-Sell)


sourpickles

Recommended Posts

So I thought I'd try this again and see if anyone may know the answer. I asked this almost 2 years ago when I added this to our page. Basically when I add the products to xsell my as I call it "bubble" isn't white. As you can see in this link....... http://playersink.com/product_info.php?products_id=7193&osCsid=aeiqd26s4q6ovadlld7kinap71 ........ the main product description bubble is white but the xsell product is not. I was told that I must have a different template type because they never seen this before but didn't say how to go about fixing it. I know just enough php to be dangerous so I rather not go through and start messing with things just to do it. What we have works but it's just not clean and uniform.

 

Ideas on how to fix this? If you want to see any of the php or anything please just ask and I'll post. I'd love to get this working right finally :)

 

Thanks all!

Link to comment
Share on other sites

The beginning of the xsell code:

 

<table class="cont_heading_table" border="0" cellpadding="0" cellspacing="0" width="100%">
 <tr>
<td class="cont_heading_l"><img src="images/cont_heading_left.gif" alt="" border="0" height="5" width="5"></td>
<td class="cont_heading_td">We Also Recommend</td>
<td class="cont_heading_r"><img src="images/cont_heading_right.gif" alt="" border="0" height="5" width="5"></td>
 </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="">

 

Change the last line of that code to this:

 

<table class="prod_table" border="0" cellpadding="0" cellspacing="0" width="">

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

The beginning of the xsell code:

 

<table class="cont_heading_table" border="0" cellpadding="0" cellspacing="0" width="100%">
 <tr>
<td class="cont_heading_l"><img src="images/cont_heading_left.gif" alt="" border="0" height="5" width="5"></td>
<td class="cont_heading_td">We Also Recommend</td>
<td class="cont_heading_r"><img src="images/cont_heading_right.gif" alt="" border="0" height="5" width="5"></td>
 </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="">

 

Change the last line of that code to this:

 

<table class="prod_table" border="0" cellpadding="0" cellspacing="0" width="">

 

Not finding this at all. I think I remember some one showing me this code last time too. Here is my code for the entire xsell php document...

 

Thanks for your help! Do you see it in there rewritten? I dont even see the IMG files in the code at all. It's like I have a different php as everyone else from the same files....? Never deleted any this so not sure what's going on here. Again thanks a bunch!

 

 

<?php
/* $Id$
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2002 osCommerce

Released under the GNU General Public License
xsell.php
Original Idea From Isaac Mualem [email protected] <mailto:[email protected]>
Complete Recoding From Stephen Walker admin@[member='snjcomputers'].com
*/
 require('includes/application_top.php');
 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();

 switch($_GET['action']){
   case 'update_cross' :
     if ($_POST['product']){
       foreach ($_POST['product'] as $temp_prod){
         tep_db_query('delete from ' . TABLE_PRODUCTS_XSELL . ' where xsell_id = "'.$temp_prod.'" and products_id = "'.$_GET['add_related_product_ID'].'"');
         tep_db_query('delete from ' . TABLE_PRODUCTS_XSELL . ' where xsell_id = "'.$_GET['add_related_product_ID'].'" and products_id = "'.$temp_prod.'"'); 
       }
     }

     $sort_start_query = tep_db_query('select sort_order from ' . TABLE_PRODUCTS_XSELL . ' where products_id = "'.$_GET['add_related_product_ID'].'" order by sort_order desc limit 1');
     $sort_start = tep_db_fetch_array($sort_start_query);
     $sort = (($sort_start['sort_order'] > 0) ? $sort_start['sort_order'] : '0');
     if ($_POST['cross']){
       foreach ($_POST['cross'] as $temp){
         $sort++;
         $insert_array = array();
         $insert_array = array('products_id' => $_GET['add_related_product_ID'],
                               'xsell_id' => $temp,
                               'sort_order' => $sort);
         tep_db_perform(TABLE_PRODUCTS_XSELL, $insert_array);
       } // foreach $temp
     } // if cross
// insert reciprocable x-sell products BOF
     if ($_POST['reciprocal_link_cross']){
       foreach ($_POST['reciprocal_link_cross'] as $temp2) {
         $sort_start_query2 = tep_db_query('select sort_order from ' . TABLE_PRODUCTS_XSELL . ' where products_id = "'.$temp2.'" order by sort_order desc limit 1');
         $sort_start2 = tep_db_fetch_array($sort_start_query2);
         $sort2 = (($sort_start2['sort_order'] > 0) ? $sort_start2['sort_order'] : '0');
         $sort2++;
         $insert_array = array();
         $insert_array = array('products_id' => $temp2,
                               'xsell_id' => $_GET['add_related_product_ID'],
                               'sort_order' => $sort2);
         tep_db_perform(TABLE_PRODUCTS_XSELL, $insert_array);
       } // foreach $temp2
     } // if reciprocal_link_cross
// insert reciprocable x-sell products EOF
     $messageStack->add(CROSS_SELL_SUCCESS, 'success');
//Cache
     $cachedir = DIR_FS_CACHE_XSELL . $_GET['add_related_product_ID'];
     if(is_dir($cachedir)) {
       rdel($cachedir);
     }
//Fin Cache
     break;

   case 'update_sort' :
     foreach ($_POST as $key_a => $value_a){
       tep_db_query('update ' . TABLE_PRODUCTS_XSELL . ' set sort_order = "' . $value_a . '" where xsell_id = "' . $key_a . '"');
     }
     $messageStack->add(SORT_CROSS_SELL_SUCCESS, 'success');
     break;
 }
?>
<!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>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<style>
.productmenutitle{
cursor:pointer;
margin-bottom: 0px;
background-color:orange;
color:#FFFFFF;
font-weight:bold;
font-family:ms sans serif;
width:100%;
padding:3px;
font-size:12px;
text-align:center;
/*/*/border:1px solid #000000;/* */
}
.productmenutitle1{
cursor:pointer;
margin-bottom: 0px;
background-color: red;
color:#FFFFFF;
font-weight:bold;
font-family:ms sans serif;
width:100%;
padding:3px;
font-size:12px;
text-align:center;
/*/*/border:1px solid #000000;/* */
}
</style>
<script language="JavaScript1.2">

function cOn(td)
{
if(document.getElementById||(document.all && !(document.getElementById)))
{
td.style.backgroundColor="#CCCCCC";
}
}

function cOnA(td)
{
if(document.getElementById||(document.all && !(document.getElementById)))
{
td.style.backgroundColor="#CCFFFF";
}
}

function cOut(td)
{
if(document.getElementById||(document.all && !(document.getElementById)))
{
td.style.backgroundColor="DFE4F4";
}
}
</script>
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
 <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
 </table></td>
 <td width="100%" valign="top">
<!-- body_text //-->
 <table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
   <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10');?></td>
  </tr>
  <tr>
   <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
  </tr>
  <tr>
   <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '15');?></td>
  </tr>
  <tr>
   <td class="smallText" align="center">
<?php
   echo tep_draw_form('search', FILENAME_XSELL_PRODUCTS, '', 'get'). tep_draw_hidden_field('add_related_product_ID', $add_related_product_ID);
   echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('search');
   echo '</form>';
?>
               </td>
  </tr>
  <tr>
   <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '15');?></td>
  </tr>

 </table>

<?php
 if ($_GET['add_related_product_ID'] == ''){
?>
 <table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999" align="center">
  <tr class="dataTableHeadingRow">
   <td class="dataTableHeadingContent" width="75"><?php echo TABLE_HEADING_PRODUCT_ID;?></td>
   <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_MODEL;?></td>
   <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_IMAGE;?></td>
   <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME;?></td>
   <td class="dataTableHeadingContent" nowrap><?php echo TABLE_HEADING_CURRENT_SELLS;?></td>
   <td class="dataTableHeadingContent" colspan="2" nowrap align="center"><?php echo TABLE_HEADING_UPDATE_SELLS;?></td>
  </tr>
<?php
if (isset($HTTP_GET_VARS['search'])) {
   $search = tep_db_prepare_input($HTTP_GET_VARS['search']);
    $products_query_raw = 'select p.products_id, p.products_model, p.products_price, p.products_tax_class_id, p.products_image, pd.products_name, p.products_id from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" and (pd.products_name like "%' . tep_db_input($search) . '%" or p.products_model like "%' . tep_db_input($search) . '%") order by pd.products_name asc';}else{$products_query_raw = 'select p.products_id, p.products_model, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_id from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" order by pd.products_name asc';}
   $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
   $products_query = tep_db_query($products_query_raw);
   while ($products = tep_db_fetch_array($products_query)) {
?>
  <tr onMouseOver="cOn(this); this.style.cursor='pointer'; this.style.cursor='hand';" onMouseOut="cOut(this);" bgcolor='#DFE4F4' onClick=document.location.href="<?php echo tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $products['products_id'], 'NONSSL');?>">
   <td class="dataTableContent" valign="top"> <?php echo $products['products_id'];?> </td>
<?php
if ($products['products_model'] == NULL) {
  $products_model = TEXT_NONE;
} else {
  $products_model = $products['products_model'];
}
?>
   <td class="dataTableContent" valign="top"> <?php echo $products_model;?> </td>
   <td class="dataTableContent" align="center"> <?php echo tep_image(DIR_WS_CATALOG_IMAGES .$products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);?> </td>
   <td class="dataTableContent" valign="top"> <?php echo $products['products_name'];?> </td>
   <td class="dataTableContent" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
   $products_cross_query = tep_db_query('select p.products_id, p.products_model, pd.products_name, p.products_id, x.products_id, x.xsell_id, x.sort_order, x.ID from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd, '.TABLE_PRODUCTS_XSELL.' x where x.xsell_id = p.products_id and x.products_id = "'.$products['products_id'].'" and p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" order by x.sort_order asc');
       $i=0;
   while ($products_cross = tep_db_fetch_array($products_cross_query)){
               $i++;
?>
        <tr>
         <td class="dataTableContent"> <?php echo $i . '.  <b>' . $products_cross['products_model'] . '</b> ' . $products_cross['products_name'];?> </td>
        </tr>
<?php
       }
   if ($i <= 0){
?>
        <tr>
         <td class="dataTableContent"> -- </td>
        </tr>
<?php
       }else{
?>
        <tr>
         <td class="dataTableContent"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10');?></td>
        </tr>
<?php
}
?>
   </table></td>
   <td class="dataTableContent" valign="top"> <a href="<?php echo tep_href_link(FILENAME_XSELL_PRODUCTS, tep_get_all_get_params(array('action')) . 'add_related_product_ID=' . $products['products_id'], 'NONSSL');?>"><?php echo TEXT_EDIT_SELLS;?></a> </td>
   <td class="dataTableContent" valign="top" align="center"> <?php echo (($i > 0) ? '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, tep_get_all_get_params(array('action')) . 'sort=1&add_related_product_ID=' . $products['products_id'], 'NONSSL') .'">'.TEXT_SORT.'</a> ' : '--')?></td>
  </tr>
<?php
       }
?>
  <tr>
   <td colspan="7"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="infoBoxContent">
    <tr>
     <td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
     <td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?></td>
    </tr>
   </table></td>
  </tr>
 </table>
<?php
}elseif($HTTP_GET_VARS['add_related_product_ID'] != '' && $HTTP_GET_VARS['sort'] == ''){
       $products_name_query = tep_db_query('select pd.products_name, p.products_model, p.products_image, p.products_price from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = "'.$HTTP_GET_VARS['add_related_product_ID'].'" and p.products_id = pd.products_id and pd.language_id ="'.(int)$languages_id.'"');
       $products_name = tep_db_fetch_array($products_name_query);
?>
 <table border="0" cellspacing="0" cellpadding="0" bgcolor="#999999" align="center">
  <tr>
   <td><?php echo tep_draw_form('update_cross', FILENAME_XSELL_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=update_cross', 'post');?><table cellpadding="1" cellspacing="1" border="0">
        <tr>
         <td colspan="6"><table cellpadding="3" cellspacing="0" border="0" width="100%">
          <tr class="dataTableHeadingRow">
          <td valign="middle" align="left"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . '/'.$products_name['products_image'], "", SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);?></td>
<?php
if ($products_name['products_model'] == NULL) {
  $products_model = TEXT_NONE;
} else {
  $products_model = $products_name['products_model'];
}
?>
           <td valign="middle" align="left"><span class="main"><?php echo TEXT_SETTING_SELLS.$products_name['products_name'].' ('.TEXT_MODEL.': '.$products_model.') ('.TEXT_PRODUCT_ID.': '.$_GET['add_related_product_ID'].')';?></span></td>
           <td valign="middle" align="center"><?php echo tep_image_submit('button_update.gif')?></td>
<td valign="middle" align="center"><?php echo '<a href="'.tep_href_link(FILENAME_XSELL_PRODUCTS, 'men_id=catalog').'">' . tep_image_button('button_cancel.gif') . '</a>'; ?></td>
          </tr>
         </table></td>
        </tr>
        <tr class="dataTableHeadingRow">
           <td class="dataTableHeadingContent" width="75"> <?php echo TABLE_HEADING_PRODUCT_ID;?> </td>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_MODEL;?> </td>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_IMAGE;?> </td>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_CROSS_SELL_THIS;?> </td>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_NAME;?> </td>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_PRICE;?> </td>
         </tr>
<?php
   if (isset($HTTP_GET_VARS['search'])) {
     $search = tep_db_prepare_input($HTTP_GET_VARS['search']);$products_query_raw = 'select p.products_id, p.products_image, p.products_model, p.products_price, pd.products_name from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" and (pd.products_name like "%' . tep_db_input($search) . '%" or p.products_model like "%' . tep_db_input($search) . '%") order by pd.products_name asc';}else{$products_query_raw = 'select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_price from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" order by pd.products_name asc';}
     $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
     $products_query = tep_db_query($products_query_raw);
     while ($products = tep_db_fetch_array($products_query)) {
       $xsold_query = tep_db_query('select * from '.TABLE_PRODUCTS_XSELL.' where products_id = "'.$_GET['add_related_product_ID'].'" and xsell_id = "'.$products['products_id'].'"');
       $xsold_query_reciprocal = tep_db_query('select * from '.TABLE_PRODUCTS_XSELL.' where products_id = "'.$products['products_id'].'" and xsell_id = "'.$_GET['add_related_product_ID'].'"');
?>
        <tr bgcolor='#DFE4F4'>
         <td class="dataTableContent" align="center"> <?php echo $products['products_id'];?> </td>
<?php
if ($products['products_model'] == NULL) {
  $products_model = TEXT_NONE;
} else {
  $products_model = $products['products_model'];
}
?>
         <td class="dataTableContent" align="center"> <?php echo $products_model;?> </td>
         <td class="dataTableContent" align="center"> <?php echo ((is_file(DIR_FS_CATALOG_IMAGES . '/'.$products['products_image'])) ?  tep_image(DIR_WS_CATALOG_IMAGES . '/'.$products['products_image'], "", SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) : TEXT_NONE);?> </td>
         <td class="dataTableContent"> <?php echo tep_draw_hidden_field('product[]', $products['products_id']) . tep_draw_checkbox_field('cross[]', $products['products_id'], ((tep_db_num_rows($xsold_query) > 0) ? true : false), '', ' onMouseOver="this.style.cursor=\'hand\'"');?> <label onMouseOver="this.style.cursor='hand'"><?php echo TEXT_CROSS_SELL;?><br> <?php echo tep_draw_hidden_field('product[]', $products['products_id']) . tep_draw_checkbox_field('reciprocal_link_cross[]', $products['products_id'], ((tep_db_num_rows($xsold_query_reciprocal) > 0) ? true : false), '', ' onMouseOver="this.style.cursor=\'hand\'"');?> <label onMouseOver="this.style.cursor='hand'"><?php echo TEXT_RECIPROCAL_LINK;?></label> </td>
         <td class="dataTableContent"> <?php echo $products['products_name'];?> </td>
         <td class="dataTableContent"> <?php echo $currencies->format($products['products_price']);?> </td>
        </tr>
<?php
   }
?>
       </table></form></td>
  </tr>
  <tr>
   <td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="infoBoxContent">
    <tr>
     <td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td>
     <td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?></td>
    </tr>
   </table></td>
  </tr>
 </table>
<?php
}elseif($HTTP_GET_VARS['add_related_product_ID'] != '' && $HTTP_GET_VARS['sort'] != ''){
       $products_name_query = tep_db_query('select pd.products_name, p.products_model, p.products_image, p.products_price from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = "'.$HTTP_GET_VARS['add_related_product_ID'].'" and p.products_id = pd.products_id and pd.language_id ="'.(int)$languages_id.'"');
       $products_name = tep_db_fetch_array($products_name_query);
?>
 <table border="0" cellspacing="0" cellpadding="0" bgcolor="#999999" align="center">
  <tr>
   <td><?php echo tep_draw_form('update_sort', FILENAME_XSELL_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=update_sort', 'post');?>
  <table cellpadding="1" cellspacing="1" border="0">
        <tr>
         <td colspan="6"><table cellpadding="3" cellspacing="0" border="0" width="100%">
          <tr class="dataTableHeadingRow">
          <td valign="middle" align="left"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . '/'.$products_name['products_image'], "", SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);?></td>
<?php
if ($products_name['products_model'] == NULL) {
  $products_model = TEXT_NONE;
} else {
  $products_model = $products_name['products_model'];
}
?>
           <td valign="middle" align="left"><span class="main"><?php echo TEXT_SETTING_SELLS.$products_name['products_name'].' ('.TEXT_MODEL.': '.$products_model.') ('.TEXT_PRODUCT_ID.': '.$_GET['add_related_product_ID'].')';?></span></td>
           <td valign="middle" align="center"><?php echo tep_image_submit('button_update.gif')?></td>
<td valign="middle" align="center"><?php echo '<a href="'.tep_href_link(FILENAME_XSELL_PRODUCTS, 'men_id=catalog').'">' . tep_image_button('button_cancel.gif') . '</a>'; ?></td>
          </tr>
         </table></td>
        </tr>
    <tr class="dataTableHeadingRow">
         <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_ID;?> </td>
         <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_MODEL;?> </td>
         <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_IMAGE;?> </td>
         <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_PRODUCT_NAME;?> </td>
         <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_PRICE;?> </td>
         <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT_SORT;?> </td>
        </tr>
<?php
   $products_query_raw = 'select p.products_id as products_id, p.products_price, p.products_image, p.products_model, pd.products_name, x.products_id as xproducts_id, x.xsell_id, x.sort_order, x.ID from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd, '.TABLE_PRODUCTS_XSELL.' x where x.xsell_id = p.products_id and x.products_id = "'.$HTTP_GET_VARS['add_related_product_ID'].'" and p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" order by x.sort_order asc';
   $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
       $sort_order_drop_array = array();
       for($i=1;$i<=$products_query_numrows;$i++){
       $sort_order_drop_array[] = array('id' => $i, 'text' => $i);
       }
   $products_query = tep_db_query($products_query_raw);
while ($products = tep_db_fetch_array($products_query)){
?>
        <tr bgcolor='#DFE4F4'>
         <td class="dataTableContent" align="center"> <?php echo $products['products_id'];?> </td>
<?php
if ($products['products_model'] == NULL) {
  $products_model = TEXT_NONE;
} else {
  $products_model = $products['products_model'];
}
?>
         <td class="dataTableContent" align="center"> <?php echo $products_model;?> </td>
         <td class="dataTableContent" align="center"> <?php echo ((is_file(DIR_FS_CATALOG_IMAGES . '/'.$products['products_image'])) ?  tep_image(DIR_WS_CATALOG_IMAGES . '/'.$products['products_image'], "", SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) : TEXT_NONE);?> </td>
         <td class="dataTableContent" align="center"> <?php echo $products['products_name'];?> </td>
         <td class="dataTableContent" align="center"> <?php echo $currencies->format($products['products_price']);?> </td>
         <td class="dataTableContent" align="center"> <?php echo tep_draw_pull_down_menu($products['products_id'], $sort_order_drop_array, $products['sort_order']);?> </td>
    </tr>
<?php
}
?>
   </table></form></td>
  </tr>
  <tr>
   <td colspan="7">
<table border="0" width="100%" cellspacing="0" cellpadding="2" class="infoBoxContent">
     <tr>
      <td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
      <td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?></td>
     </tr>
    </table>
   </td>
  </tr>
 </table>
<?php
}
?>
<!-- body_text_eof //-->
 </td>
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

Are you looking in your includes/modules/xsell file. If you view source of your wab page the code quotred above is there.

 

Nope not there.... Here is the code from that file which is called 'xsell_products.php'. This is the path as you stated....../playersink.com/includes/modules

 

Telling you it's like my stuff is different from otheres. I even just downloaded the newer version and looked and it's exactly what I have here so I'm 199% lost..... see that extra 99%? I'm THAT lost haha

 

 

<?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);
if ((USE_CACHE == 'true') && empty($SID)) {
// include currencies class and create an instance
require_once(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
}

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, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price
from " . TABLE_PRODUCTS_XSELL . " xp left join " . TABLE_PRODUCTS . " p on xp.xsell_id = p.products_id
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'
left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 
where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "'
and p.products_status = '1'
order by sort_order asc limit " . MAX_DISPLAY_XSELL);

$num_products_xsell = tep_db_num_rows($xsell_query);
if ($num_products_xsell > 0) {
?>
<!-- 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)) {
if (tep_not_null($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']));
}
      $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_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=buy_now&product_to_buy_id=' . $xsell['products_id'], 'NONSSL') . '">' . tep_image_button('button_buy_now.gif', TEXT_BUY . $xsell['products_name'] . TEXT_NOW) .'</a>';
      $info_box_contents[$row][$col] = array('align' => 'center',
                                             'params' => 'class="smallText" width="33%" valign="top"',
                                             'text' => $text) ; 
 $col ++;
      if ($col > 2) {
        $col = 0;
        $row ++;
      }
    }
new contentBox($info_box_contents);
?>
<!-- xsell_products_eof //-->
<?php
  }
}
?>

Link to comment
Share on other sites

In your catalog/product_info.php whats the code around

 

include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);

 

That is where the module is called.

 

Also in a stylesheet somewhere you must have the following

 

cont_heading_l

cont_heading_td

cont_heading_r

ableBox_output_td main

 

I expect the bottom one will control the background colour whick looks like #AEB6BD or something close.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

oh hey... I was just about to try and upload an image but if you drag your mouse it acts like there is a box there. Ya know what I mean? a section turns blue and highlighted. I'll take a look at my stylesheets. I just had it opened but didnt see any of that at all.

 

I will say I have not re written a single piece of code on this thing at all

Link to comment
Share on other sites

Here is that section in my product_info.php file

 

 

<?php
//added for cross -sell
   if ((USE_CACHE == 'true') && empty($SID)) {
     echo tep_cache_xsell_products(3600); //added for Xsell
     echo tep_cache_also_purchased(3600);
   } else {
     include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS); //added for Xsell
     include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
   }
 }
?>

Link to comment
Share on other sites

also looking over my style sheet I have all but the last you mentioned

 

ableBox_output_td main

 

I can not find that one at all on my stylesheet but I also dont see it in any of the php code that would say it would direct it to even look for that line of code?

Link to comment
Share on other sites

Open the page in your web browser and click view source. You will find any related divs or tables.

 

That code is not in a standard oscommerce set up, so either you are using a template or the code has been altered. If you are using a template try contacting the template supplier and ask them for support.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

Lots of help they are!

 

==============================

 

Thank you for reaching the Technical Department of Template-Help.com!

 

We apologize for the delayed reply.

 

Please note that we do not bear any responsibility for incompatibility of our products with some third-party software (plug-ins, add-ons, modules, search engines, scripts, extensions etc) other than those which are specified as compatible in a description available on the preview page of each product. We don't guarantee that our products are fully compatible with any third-party programs and we do not provide support for third-party applications.

 

We recommend you to visit our partner site of custom design:

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.

×
×
  • Create New...