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!
Latest News: (loading..)
0
14 replies to this topic
#1
Posted 03 February 2012, 19:47
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!
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!
#2
Posted 04 February 2012, 19:22
The beginning of the xsell code:
Change the last line of that code to this:
<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.
"Headers already sent" - The definitive help
"Cannot redeclare ..." - How to find/fix it
SSL Implementation Help
Like this post? "Like" it again over there >
"Headers already sent" - The definitive help
"Cannot redeclare ..." - How to find/fix it
SSL Implementation Help
Like this post? "Like" it again over there >
#3
Posted 06 February 2012, 16:11
germ, on 04 February 2012, 19:22, said:
The beginning of the xsell code:
Change the last line of that code to this:
<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 im@imwebdesigning.com <mailto:im@imwebdesigning.com>
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'); ?>
#4
Posted 07 February 2012, 11:20
Are you looking in your includes/modules/xsell file. If you view source of your wab page the code quotred above is there.
REMEMBER BACKUP, BACKUP AND BACKUP
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
#5
Posted 07 February 2012, 14:55
14steve14, on 07 February 2012, 11:20, said:
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
}
}
?>
#7
Posted 07 February 2012, 17:15
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.
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
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
#8
Posted 07 February 2012, 17:19
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
I will say I have not re written a single piece of code on this thing at all
#9
Posted 07 February 2012, 17:21
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);
}
}
?>
#10
Posted 07 February 2012, 17:26
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?
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?
#13
Posted 10 February 2012, 15:03
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.
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
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
I am not a coder. OSC has a steep learning curve, but in general the program does work. If it doesnt work, the chances are it is something you have done.
#15
Posted 15 February 2012, 14:57
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:
==============================
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:
