sourpickles Posted February 3, 2012 Share Posted February 3, 2012 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! Quote Link to comment Share on other sites More sharing options...
germ Posted February 4, 2012 Share Posted February 4, 2012 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=""> Quote 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 More sharing options...
sourpickles Posted February 6, 2012 Author Share Posted February 6, 2012 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'); ?> Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted February 7, 2012 Share Posted February 7, 2012 Are you looking in your includes/modules/xsell file. If you view source of your wab page the code quotred above is there. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
sourpickles Posted February 7, 2012 Author Share Posted February 7, 2012 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 } } ?> Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 7, 2012 Author Share Posted February 7, 2012 Ya know I'm wondering after really looking at this if maybe me style sheets are set up differently in my type of oscommerce? Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted February 7, 2012 Share Posted February 7, 2012 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. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
sourpickles Posted February 7, 2012 Author Share Posted February 7, 2012 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 Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 7, 2012 Author Share Posted February 7, 2012 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); } } ?> Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 7, 2012 Author Share Posted February 7, 2012 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? Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 8, 2012 Author Share Posted February 8, 2012 OK I'm wrong about the content box being there when I highlight it. It was just some weird glitch. Its just not rendering the box what so ever. It's not a different color or nothing. Just simply does not exist Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 10, 2012 Author Share Posted February 10, 2012 any other ideas or are you tapped out? I appreciate them Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted February 10, 2012 Share Posted February 10, 2012 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. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
sourpickles Posted February 13, 2012 Author Share Posted February 13, 2012 Would Looooooooooooooooooooooooooove to see them help me but so far in 3 or 4 days since I sent them a ticket they have closed my ticket with in hours with out ever even contacting me. Love those guys! Quote Link to comment Share on other sites More sharing options...
sourpickles Posted February 15, 2012 Author Share Posted February 15, 2012 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: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.