tfriebe
Themenersteller
Beginner (30 Beiträge)

Duplicate content trotz angepasster htaccess (Seite 6)



gelöschter Benutzer
am 03.07.2012, 18:30 Uhr schrieb

Ich verstehs auch nicht ...

Es sollte sich alles über die .htaccess steuern lassen und die Session ID stellst du am besten in der php.ini um.

Alternativ kannst du das auch mit folgendem PHP Code direkt zu beginn der index.php fixen. Der Code muss vor der ersten Ausgabe Ausgeführt werden.
[PHP]<?php
ini_set(\'session.use_cookies\',1);
ini_set(\'session.use_only_cookies\',1);
?>[/php]


joerg
Avatar joerg
Fachinformatiker Anwendungsentwicklung
Content Gott (1941 Beiträge)
am 03.07.2012, 18:54 Uhr schrieb joerg

Hallo Thomas

Du meinst wir sollten mal jetzt PHP zu Hilfe nehmen?

Wenn Marco dann eh schon in der index.php sich befindet kann er auch gleich dann unter deinen Kode folgendes einfügen.

<?php
if (preg_match(\'#^/index.php#\',$_SERVER[\'REQUEST_URI\']) OR substr($_SERVER[\'HTTP_HOST\'],0,4) != \'www.\') {

header(\'Location: www.\'.$_SERVER[\'HTTP_HOST\'].preg_replace(\';


exit;}
?>


Gruß
Jörg


Zufällige Umleitung zu der Startseite einer meiner Domains
Meine ungewöhnlichen Tools

MASGlas
Avatar MASGlas
Glaser
Beginner (37 Beiträge)
am 03.07.2012, 19:50 Uhr schrieb MASGlas

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>&lt;?php echo TITLE; ?&gt;</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);
?>







include(DIR_WS_MODULES . FILENAME_CAT_TEXTBOX_MODULE); // added for Subcategory textboxes
}
?>









<?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\'); ?>












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 \' \' . "\\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;
?>

\' . tep_image(DIR_WS_IMAGES . $categories[\'categories_image\'], $categories[\'categories_name\'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . \'
\' . $categories[\'categories_name\'] . \'
<?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;
}
}
?>














// 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 \' \' . "\\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 HEADING_TITLE; ?>\' . 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>
<?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\') {
?>


} else {
}
?>














if (SHOW_HIGHLIGHT_PROD == \'true\') {
?>






}
?>

if (SHOW_NEW_PROD == \'true\') {
?>






}
?>
include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
if (SHOW_CLOUDSEARCH == \'true\') {
?>







}
?>


<?php echo mws_boxHeader (\'\'. WELCOME_TEXT . \'\'); ?>
<?php echo tep_customer_greeting(); ?>
<?php echo mws_boxFooter (\'\'); ?>
<?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); ?>
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?>
<?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?>
<?php echo tep_draw_separator(\'pixel_trans.gif\', \'100%\', \'10\'); ?>
<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>
<?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



« zurück zu: .htaccess

Das Seitenreport Forum hat aktuell 5277 Themen und 36111 Beiträge.
Insgesamt sind 48343 Mitglieder registriert.