Guest Posted November 15, 2006 Share Posted November 15, 2006 runing version 2.2 i've deleted a product but it still shows http://shop.outallnite.co.uk/osc/ if you look Rob Cain bit has no image i've scanned the SQL and still nothing its not my browser caching Link to comment Share on other sites More sharing options...
jdvb Posted November 15, 2006 Share Posted November 15, 2006 How is the default part of your index.php built up? is that a fixed setup or a contribution? please post your osc/index.php if you cannot figure it out and I will take a look for you Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2006 Share Posted November 15, 2006 <?php/* $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License*/ require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);?><html><!-- InstanceBegin template="/Templates/pagestemplate.dwt" codeOutsideHTMLIsLocked="false" --><head><!-- InstanceBeginEditable name="doctitle" --><title>OutAllNite.co.uk The North West's biggest online clubbing community</title><!-- InstanceEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --><script language="JavaScript" type="text/JavaScript"><!--function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;} function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}} function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x;} function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}}//--></script><style type="text/css"><!--body,td,th { font-family: Trebuchet MS, Verdana, sans-serif; font-size: 11px; color: #000000;}a { font-size: 11px; color: #FFFFFF;}a:visited { color: #3399CC;}a:hover { color: #999999;}a:active { color: #336699;}.style1 {color: #000000}a:link { color: #3399FF;}--></style></head><body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/oan_images/navover_10.gif','images/oan_images/navover_11.gif','images/oan_images/navover_12.gif','images/oan_images/navover_13.gif','images/oan_images/navover_14.gif','images/oan_images/navover_16.gif','images/oan_images/navover_17.gif','images/oan_images/navover_18.gif','images/oan_images/navover_19.gif')"><!-- ImageReady Slices (downloads.psd) --><!-- End ImageReady Slices --><!-- InstanceBegin template="/Templates/pagestemplate.dwt" codeOutsideHTMLIsLocked="false" --><head><tr><td align="center" valign="middle"><tr><td colspan="15" rowspan="2" align="left" valign="top" bgcolor="#FFFFFF"><!-- InstanceBeginEditable name="doctitle" --><title>OutAllNite.co.uk The North West's biggest online clubbing community</title><!-- InstanceEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --><script language="JavaScript" type="text/JavaScript"><!--function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;} function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}} function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x;} function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}}//--></script><style type="text/css"><!--body,td,th { font-family: Trebuchet MS, Verdana, sans-serif; font-size: 11px; color: #000000;}a { font-size: 11px; color: #FFFFFF;}a:visited { color: #3399CC;}a:hover { color: #999999;}a:active { color: #336699;}.style1 {color: #000000}a:link { color: #3399FF;}--></style></head><body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/oan_images/navover_10.gif','images/oan_images/navover_11.gif','images/oan_images/navover_12.gif','images/oan_images/navover_13.gif','images/oan_images/navover_14.gif','images/oan_images/navover_16.gif','images/oan_images/navover_17.gif','images/oan_images/navover_18.gif','images/oan_images/navover_19.gif')"><!-- ImageReady Slices (downloads.psd) --><!-- End ImageReady Slices --><div align="center"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000"> <tr> <td align="center" valign="middle"><div align="center"> <table width="780" height="559" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000" id="Table_01"> <tr> <td height="25" colspan="19"> <img src="images/oan_images/temp_01.gif" width="765" height="29" alt=""></td> <td width="15" height="29"> <img src="images/oan_images/temp_02.gif" width="15" height="29" alt=""></td> </tr> <tr> <td rowspan="6" background="images/oan_images/temp_03.gif"> </td> <td height="73" width="272" colspan="5" rowspan="2"> <a href="http://www.outallnite.co.uk/"><img src="images/oan_images/temp_04.gif" alt="" width="272" height="73" border="0"></a></td> <td height="60" colspan="12"><iframe id='aadab335' name='aadab335' src='http://adverts.outallnite.co.uk//adframe.php?n=aadab335&what=zone:2&target=_blank' framespacing='0' frameborder='no' scrolling='no' width='468' height='60'><a href='http://adverts.outallnite.co.uk//adclick.php?n=aadab335' target='_blank'><img src='http://adverts.outallnite.co.uk//adview.php?what=zone:2&n=aadab335' border='0' alt=''></a></iframe></td> <td rowspan="2"> <img src="images/oan_images/temp_06.gif" width="8" height="73" alt=""></td> <td rowspan="6" background="images/oan_images/temp_07.gif"> </td> </tr> <tr> <td height="13" colspan="12" background="images/oan_images/temp_08.gif"> <img src="images/oan_images/temp_08.gif" width="468" height="13" alt=""></td> </tr> <tr> <td height="59" colspan="4" rowspan="2" valign="top" background="images/oan_images/back_lpool.gif"> <img src="images/oan_images/temp_09.gif" width="252" height="59" alt=""></td> <td height="30" colspan="4" valign="bottom" background="images/oan_images/back_chat.gif"><a href="http://www.outallnite.co.uk/forum/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('forum','','images/oan_images/navover_10.gif',1)"><img src="images/oan_images/temp_10.gif" alt="Chat Forum" name="forum" width="94" height="30" border="0"></a> </td> <td height="30" colspan="2" valign="top" background="images/oan_images/back_down.gif"> <a href="http://www.outallnite.co.uk/downloads/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Downloads','','images/oan_images/navover_11.gif',1)"><img src="images/oan_images/temp_11.gif" alt="Downloads" name="Downloads" width="92" height="30" border="0"></a></td> <td height="30" colspan="3" valign="top" background="images/oan_images/back_dj.gif"> <a href="http://www.outallnite.co.uk/djsandartists/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('djs&artists','','images/oan_images/navover_12.gif',1)"><img src="images/oan_images/temp_12.gif" alt="DJ's & Artists" name="djs&artists" width="107" height="30" border="0"></a></td> <td height="30" colspan="2" valign="top" background="images/oan_images/back_shop.gif"> <a href="index.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('shoponline','','images/oan_images/navover_13.gif',1)"><img src="images/oan_images/temp_13.gif" alt="Shop Online" name="shoponline" width="94" height="30" border="0"></a></td> <td height="30" colspan="3" valign="top" background="images/oan_images/back_local.gif"> <a href="http://www.outallnite.co.uk/local/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('local','','images/oan_images/navover_14.gif',1)"><img src="images/oan_images/temp_14.gif" alt="local shopping" name="local" width="109" height="30" border="0"></a></td> </tr> <tr> <td height="29" colspan="2"> <img src="images/oan_images/temp_15.gif" width="36" height="29" alt=""></td> <td height="29" colspan="3"> <a href="http://www.outallnite.co.uk/gallery/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('galleries','','images/oan_images/navover_16.gif',1)"><img src="images/oan_images/temp_16.gif" alt="Galleries" name="galleries" width="78" height="29" border="0"></a></td> <td height="29" colspan="3"> <a href="http://www.outallnite.co.uk/clubsandevents/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('clubs','','images/oan_images/navover_17.gif',1)"><img src="images/oan_images/temp_17.gif" alt="Clubs & Events" name="clubs" width="112" height="29" border="0"></a></td> <td height="29" colspan="2"> <a href="http://www.outallnite.co.uk/barsandrestaurants/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('bars','','images/oan_images/navover_18.gif',1)"><img src="images/oan_images/temp_18.gif" alt="Bars & Resturants" name="bars" width="142" height="29" border="0"></a></td> <td height="29" colspan="2"> <a href="http://www.outallnite.co.uk/contact/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('contact','','images/oan_images/navover_19.gif',1)"><img src="images/oan_images/temp_19.gif" alt="Contact" name="contact" width="92" height="29" border="0"></a></td> <td height="29" colspan="2"> <img src="images/oan_images/temp_20.gif" width="36" height="29" alt=""></td> </tr> <tr> <td height="34" colspan="18"> <!-- InstanceBeginEditable name="title" --><img src="images/oan_images/shoponline_21.gif" width="748" height="59"><!-- InstanceEndEditable --></td> </tr> <tr> <td rowspan="2" valign="top" background="images/oan_images/leftmiddleback.gif"> <img src="images/oan_images/temp_22.gif" width="40" height="230" alt=""></td> <td colspan="15" rowspan="2" align="left" valign="top" bgcolor="#FFFFFF"><span class="style1"><!-- InstanceBeginEditable name="content" --><!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"><html <?php echo HTML_PARAMS; ?>><head><meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"><title><?php echo TITLE; ?></title><base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"><link rel="stylesheet" type="text/css" href="stylesheet.css"><body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"><!-- header //--><!-- header_eof //--> <!-- body //--><table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <!-- body_text //--><?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query);?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php require(DIR_WS_INCLUDES . 'header.php'); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr><?php if (isset($cPath) && strpos('_', $cPath)) {// check to see if there are deeper categories within the current category $category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) { $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $categories = tep_db_fetch_array($categories_query); if ($categories['total'] < 1) { // do nothing, go through the loop } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); break; // we've found the deepest category the customer is in } } } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++; $cPath_new = tep_get_path($categories['categories_id']); $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>' . "\n"; echo ' <tr>' . "\n"; } } // needed for the new products module shown below $new_products_category_id = $current_category_id;?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr> </table></td> </tr> </table></td><?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {// create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {// We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else {// We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else {// show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {// We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else {// We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } }?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td><?php// optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo '</form></td>' . "\n"; } } // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; }?> <td align="right"><?php require(DIR_WS_INCLUDES . 'header.php'); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td><?php } else { // default page?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php require(DIR_WS_INCLUDES . 'header.php'); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"><?php echo tep_customer_greeting(); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?> <table width="100%" border="0" cellpadding="2" cellspacing="0"> <tbody _base_href="http://www.outallnite.co.uk/shop/catalog/"> <tr> <td><table width="100%" border="0" cellpadding="2" cellspacing="0"> <tr> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_32"><img src="images/dj_alexK1.gif" border="0" alt="Alex K" title=" Alex K " width="80" height="70"><br> Alex K</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_23"><img src="images/barred.gif" border="0" alt="Bar Red" title=" Bar Red " width="80" height="70"><br> Bar Red</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_25"><img src="images/bestofthebest.gif" border="0" alt="Best of the Best" title=" Best of the Best " width="80" height="70"><br> Best of the Best</a></td> </tr> <tr> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_22"><img src="images/carryon.jpg" border="0" alt="Carry On Miss Behavin'" title=" Carry On Miss Behavin' " width="80" height="70"><br> Carry On Miss Behavin'</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_28"><img src="images/davebooth.gif" border="0" alt="Dave Booth" title=" Dave Booth " width="80" height="70"><br> Dave Booth</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_29"><img src="images/discoscience.gif" border="0" alt="Disco Science" title=" Disco Science " width="80" height="70"><br> Disco Science</a></td> </tr> <tr> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_21"><img src="images/jubilee.gif" border="0" alt="Jubilee" title=" Jubilee " width="80" height="70"><br> Jubilee</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_37"><img src="images/kb_cat.gif" border="0" alt="Klubbouncerz" title=" Klubbouncerz " width="80" height="70"><br> Klubbouncerz</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_10"><img src="images/leebutler.gif" border="0" alt="Lee Butler" title=" Lee Butler " width="80" height="70"><br> Lee Butler</a></td> </tr> <tr> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_35"><img src="images/liljoncat.jpg" border="0" alt="Li'l John" title=" Li'l John " width="80" height="70"><br> Li'l John</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_24"><img src="images/playdj.gif" border="0" alt="Play DJ" title=" Play DJ " width="80" height="70"><br> Play DJ</a></td> <td align="center" class="smallText" width="33%" valign="top"><a href="http://shop.outallnite.co.uk/osc/index.php?cPath=3_30"><img src="images/pleasure_room_logo.jpg" border="0" alt="Pleasure Rooms" title=" Pleasure Rooms " width="80" height="70"><br> Pleasure Rooms</a></td> </tr> <tr> &nbs Link to comment Share on other sites More sharing options...
jdvb Posted November 15, 2006 Share Posted November 15, 2006 as I figuered a fixed html insertion in your index.php you will need to edit all code after this: <?php echo tep_customer_greeting(); ?> edit: since somehow this custom html is inserted I suppose you must be able te edit this as well Do make/keep a backup Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2006 Share Posted November 15, 2006 many thanks didnt relise it edited the index.php Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.