darf ich euch mal sagen das ich noch nicht mal verstehen was Ihr mir sagen wollt...
<?php
/*
$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require(\'includes/application_top.php\');
global $customer_group_id;
if(!isset($customer_group_id)) { $customer_group_id = \'0\'; }
// 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);
?>
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>
<html xmlns=http://www.w3.org/1999/xhtml>
<html <?php echo HTML_PARAMS; ?>>
<head>
<?php
// BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . \'header_tags.php\') ) {
require(DIR_WS_INCLUDES . \'header_tags.php\');
} else {
?>
<title><?php echo TITLE; ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v2.5.2
?>
<base href="<?php echo (($request_type == \'SSL\') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<?php require(DIR_WS_INCLUDES . \'header.php\'); ?>
<?php if ((LOOK_INDEX == \'Nur linke Spalte\') || (LOOK_INDEX == \'Linke und rechte Spalte\')) {
include(DIR_WS_MODULES . FILENAME_BODY);
}
else
{
include(DIR_WS_MODULES . FILENAME_NO_BODY);
}?>
<?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);
?>
<?php echo HEADING_TITLE; ?> |
<?php echo tep_image(DIR_WS_IMAGES . $category[\'categories_image\'], $category[\'categories_name\'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?> |
|
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
include(DIR_WS_MODULES . FILENAME_CAT_TEXTBOX_MODULE); // added for Subcategory textboxes
}
?>
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 \' \' . tep_image(DIR_WS_IMAGES . $categories[\'categories_image\'], $categories[\'categories_name\'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . \'
\' . $categories[\'categories_name\'] . \' | \' . "\\n";
if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
echo \' \' . "\\n";
echo \' \' . "\\n";
}
}
// needed for the new products module shown below
$new_products_category_id = $current_category_id;
?>
|
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
<?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?> |
|
| <?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;
}
// BOF Separate Pricing Per Customer
if(!tep_session_is_registered(\'sppc_customer_group_id\')) {
$customer_group_id = \'0\';
} else {
$customer_group_id = $sppc_customer_group_id;
}
// this will build the table with specials prices for the retail group or update it if needed
// this function should have been added to includes/functions/database.php
if ($customer_group_id == \'0\') {
tep_db_check_age_specials_retail_table();
}
$status_product_prices_table = false;
$status_need_to_get_prices = false;
// find out if sorting by price has been requested
if ( (isset($HTTP_GET_VARS[\'sort\'])) && (ereg(\'[1-8][ad]\', $HTTP_GET_VARS[\'sort\'])) && (substr($HTTP_GET_VARS[\'sort\'], 0, 1) <= sizeof($column_list)) && $customer_group_id != \'0\' ){
$_sort_col = substr($HTTP_GET_VARS[\'sort\'], 0 , 1);
if ($column_list[$_sort_col-1] == \'PRODUCT_LIST_PRICE\') {
$status_need_to_get_prices = true;
}
}
if ($status_need_to_get_prices == true && $customer_group_id != \'0\') {
$product_prices_table = TABLE_PRODUCTS_GROUP_PRICES.$customer_group_id;
// the table with product prices for a particular customer group is re-built only a number of times per hour
// (setting in /includes/database_tables.php called MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE, in minutes)
// to trigger the update the next function is called (new function that should have been
// added to includes/functions/database.php)
tep_db_check_age_products_group_prices_cg_table($customer_group_id);
$status_product_prices_table = true;
} // end if ($status_need_to_get_prices == true && $customer_group_id != \'0\')
// EOF Separate Pricing Per Customer
$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
// BOF Separate Pricing Per Customer
if ($status_product_prices_table == true) {
// RK: Geändert wegen mySQL
// $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . 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\'] . "\'";
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(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 { // either retail or no need to get correct special prices
// RK: Geändert wegen mySQL
// $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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id 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\'] . "\'";
$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_RETAIL_PRICES . " 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\'] . "\'";
} // end else { // either retail...
// EOF Separate Pricing Per Customer
} else {
// We show them all
// BOF Separate Pricing Per Customer
if ($status_product_prices_table == true) {
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(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 { // either retail or no need to get correct special prices
// RK: Geändert wegen mySQL
// $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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id 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\'] . "\'";
$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_RETAIL_PRICES . " 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\'] . "\'";
} // end else { // either retail...
// EOF Separate Pricing Per Customer
}
} 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;
// BOF Separate Pricing Per Customer
if ($status_product_prices_table == true) {
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(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 { // either retail or no need to get correct special prices
// RK: Geändert wegen mySQL
// $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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) 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 . "\'";
$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_RETAIL_PRICES . " s using(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 . "\'";
} // end else { // either retail...
// EOF Separate Pricing Per Customer
} else {
// We show them all
// BOF Separate Pricing Per Customer
if ($status_product_prices_table == true) {
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_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 . "\'";
} else { // either retail or no need to get correct special prices
// RK: Geändert wegen mySQL
// $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, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id 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 . "\'";
$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_RETAIL_PRICES . " 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 . "\'";
} // end else { // either retail...
// EOF Separate Pricing per Customer
}
}
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\') {
// BOF Product Sort
$HTTP_GET_VARS[\'sort\'] = \'products_sort_order\';
$listing_sql .= " order by p.products_sort_order asc";
// EOF Product Sort
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;
}
}
?>
<?php echo HEADING_TITLE; ?> |
// 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 \' \' . 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> | \' . "\\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\'];
}
?>
<?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?> |
|
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
<?php
if (PRODUCT_LISTING_DISPLAY_STYLE == \'columns\')
{
include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING_COL);
}
if (PRODUCT_LISTING_DISPLAY_STYLE == \'list\')
{
include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING_LIST);
}
?>
|
| <?php
} else { // default page
?>
|
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'1\'); ?> |
if (SHOW_CUST_GREETING == \'true\') {
?>
<?php echo mws_boxHeader (\'\'. WELCOME_TEXT . \'\'); ?>
<?php echo tep_customer_greeting(); ?>
<?php echo mws_boxFooter (\'\'); ?>
|
} else {
}
?>
<?php define(\'LATEST_NEWS_BOX\', "normal");
include(DIR_WS_MODULES . FILENAME_LATEST_NEWS); ?> |
<?php echo mws_boxHeader (\'\'. HEADLINE .\'\'); ?>
<?php include(DIR_WS_LANGUAGES . $language . \'/\' . FILENAME_DEFINE_MAINPAGE); ?> |
if (SHOW_HIGHLIGHT_PROD == \'true\') {
?>
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
<?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?> |
}
?>
if (SHOW_NEW_PROD == \'true\') {
?>
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> |
}
?>
include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
if (SHOW_CLOUDSEARCH == \'true\') {
?>
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?> |
<?php include(DIR_WS_MODULES . \'searchtag.php\'); ?> |
}
?>
|
| <?php
}
?>
<?php if ((LOOK_INDEX == \'Nur rechte Spalte\') || (LOOK_INDEX == \'Linke und rechte Spalte\')) {
include(DIR_WS_MODULES . FILENAME_BODY_EOF);
}
else
{
include(DIR_WS_MODULES . FILENAME_NO_BODY_EOF);
}
?>
<?php require(DIR_WS_INCLUDES . \'footer.php\'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . \'application_bottom.php\'); ?>
Marco Schröder
MAS Glas Shop
www.mas-glas.de 
Beitrag erstellen
EinloggenKostenlos registrieren