Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

delted product showing


Guest

Recommended Posts

<?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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...