Antwort #1 am: 22. Juni 2011, 09:04:42
Hallo martin63,
ich denke Du solltest dann noch in der eigentlichen Produktabfrage einbauen das er nur Produkte raussucht die auch die Manufacturers ID haben:
include/classes/specials.php in Z.35ff
$specials_query_raw = "select p.products_id,
pd.products_name,
p.products_price,
p.products_tax_class_id,p.products_shippingtime,
p.products_image,p.products_vpe_status,p.products_vpe_value,p.products_vpe,p.products_fsk18,
s.specials_new_products_price from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_SPECIALS." s
where p.products_status = '1'
and s.products_id = p.products_id
and p.products_id = pd.products_id
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and s.status = '1' order by s.specials_date_added DESC";
ändern in:
if ($_GET['filter']['specials']) { // <= Hier passend ändern...
$manufacturers_id = " and p.manufacturers_id = '" . (int)$_GET['filter']['specials'] ."' ";
}
$specials_query_raw = "select p.products_id,
pd.products_name,
p.products_price,
p.products_tax_class_id,p.products_shippingtime,
p.products_image,p.products_vpe_status,p.products_vpe_value,p.products_vpe,p.products_fsk18,
s.specials_new_products_price from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_SPECIALS." s
where p.products_status = '1'
and s.products_id = p.products_id
and p.products_id = pd.products_id
".$manufacturers_id."
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and s.status = '1' order by s.specials_date_added DESC";
Ist ungetestet und muss evtl. noch ein wenig angepasst werden.
Vor allen Dingen die $_GET Variable könnte falsch sein.
Viele Grüße
Franky