Doppelt Neue Artikel bei mehreren Kategorienzuweisungen

[karrde2xl]

Hallo, habe ein Problem mit meinem Shop. Benutze die aktuellste Version xt:Commerce v3.0.4 SP2.1

Besitze einen Artikel, den ich in mehreren Unterkategorien verlinkt habe.
Wenn ich die Seite dieser Kategorie darüber aufrufe, dann sehe ich unter neue Artikel diesen doppelt, da dieser in derzeit 2 Unterkategorien eingestellt ist.

Wie kann ich verhindern, das dieser Artikel dort mehrmals zu sehen ist ? Bin in PHP nicht so bewandert und würde mich freuen wenn mir jemand damit helfen könnte.

Danke schon mal im voraus.

[karrde2xl]

Hab im Forum einen Eintrag gefunden, aber wenn ich das einsetze erhalte ich einen Fehler und keine Produkte werden angezeigt.
Ein gelöstes Problem mit new_products.php

Hier mal der Code von new_products.php

<?php

/* -----------------------------------------------------------------------------------------
$Id: new_products.php 1292 2005-10-07 16:10:55Z mz $

XT-Commerce - community made shopping
http://www.xt-commerce.com

Copyright (c) 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(new_products.php,v 1.33 2003/02/12); www.oscommerce.com
(c) 2003 nextcommerce (new_products.php,v 1.9 2003/08/17); www.nextcommerce.org

Released under the GNU General Public License
-----------------------------------------------------------------------------------------
Third Party contributions:
Enable_Disable_Categories 1.3 Autor: Mikel Williams | mikel@ladykatcostumes.com

Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

$module_smarty = new Smarty;
$module_smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');

//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0')
$fsk_lock = ' and p.products_fsk18!=1';

if ((!isset ($new_products_category_id)) || ($new_products_category_id == '0')) {
if (GROUP_CHECK == 'true')
$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

$new_products_query = "SELECT * FROM
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_DESCRIPTION." pd WHERE
p.products_id=pd.products_id and
p.products_startpage = '1'
".$group_check."
".$fsk_lock."
and p.products_status = '1' and pd.language_id = '".(int) $_SESSION['languages_id']."'
order by p.products_startpage_sort ASC limit ".MAX_DISPLAY_NEW_PRODUCTS;
} else {

if (GROUP_CHECK == 'true')
$group_check = "and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

if (MAX_DISPLAY_NEW_PRODUCTS_DAYS != '0') {
$date_new_products = date("Y.m.d", mktime(1, 1, 1, date(m), date(d) - MAX_DISPLAY_NEW_PRODUCTS_DAYS, date(Y)));
$days = " and p.products_date_added > '".$date_new_products."' ";
}
$new_products_query = "SELECT * FROM
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_DESCRIPTION." pd,
".TABLE_PRODUCTS_TO_CATEGORIES." p2c,
".TABLE_CATEGORIES." c
where c.categories_status='1'
and p.products_id = p2c.products_id and p.products_id=pd.products_id
and p2c.categories_id = c.categories_id
".$group_check."
".$fsk_lock."
and c.parent_id = '".$new_products_category_id."'
and p.products_status = '1' and pd.language_id = '".(int) $_SESSION['languages_id']."'
order by p.products_date_added DESC limit ".MAX_DISPLAY_NEW_PRODUCTS;
}
$row = 0;
$module_content = array ();
$new_products_query = "select distinct
p.products_id,
p.products_fsk18,
pd.products_name,
p.products_image,
p.products_price,
p.products_tax_class_id,
p.products_date_added,
m.manufacturers_name
from " . TABLE_PRODUCTS . " p,
" . TABLE_CATEGORIES . " c,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
left join " . TABLE_MANUFACTURERS . " m
on p.manufacturers_id = m.manufacturers_id
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd
on p.products_id = pd.products_id ".$fsk_lock."
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
where c.categories_status=1
and p.products_id = p2c.products_id
and c.categories_id = p2c.categories_id
and products_status = '1'
".$group_check."
".$fsk_lock."
".$days."
and c.parent_id = '".$new_products_category_id."'
order by p.products_date_added DESC limit ".MAX_DISPLAY_NEW_PRODUCTS;
while ($new_products = xtc_db_fetch_array($new_products_query, true)) {
$module_content[] = $product->buildDataArray($new_products);

}
if (sizeof($module_content) >= 1) {
$module_smarty->assign('language', $_SESSION['language']);
$module_smarty->assign('module_content', $module_content);

// set cache ID
if (!CacheCheck()) {
$module_smarty->caching = 0;
if ((!isset ($new_products_category_id)) || ($new_products_category_id == '0')) {
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/new_products_default.html');
} else {
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/new_products.html');
}
} else {
$module_smarty->caching = 1;
$module_smarty->cache_lifetime = CACHE_LIFETIME;
$module_smarty->cache_modified_check = CACHE_CHECK;
$cache_id = $new_products_category_id.$_SESSION['language'].$_SESSION['customers_status']['customers_status_name'].$_SESSION['currency'];
if ((!isset ($new_products_category_id)) || ($new_products_category_id == '0')) {
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/new_products_default.html', $cache_id);
} else {
$module = $module_smarty->fetch(CURRENT_TEMPLATE.'/module/new_products.html', $cache_id);
}
}
$default_smarty->assign('MODULE_new_products', $module);
}
?>