Antwort #3 am: 09. Februar 2018, 21:24:08
Hallo ihr Beiden
Erst einmal vielen Dank für die beiden Ideen. Ich habs mit eurer Hilfe gefunden. Es ist in der shoproot\includes\extra\default\center_modules\new_products_default.php aber es muss folgender Code:
$new_products_query = "SELECT p.*,
pd.products_name,
pd.products_short_description,
m.manufacturers_name
FROM ".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_MANUFACTURERS." m
ON p.manufacturers_id = m.manufacturers_id
JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd
ON p.products_id = pd.products_id
AND pd.products_name <> ''
AND pd.language_id = '".(int)$_SESSION['languages_id']."'
JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c
ON p.products_id = p2c.products_id
JOIN ".TABLE_CATEGORIES." c
ON c.categories_id = p2c.categories_id
AND c.categories_status = 1
WHERE p.products_status = 1
".PRODUCTS_CONDITIONS_P."
".$days."
GROUP BY p.products_id
ORDER BY MD5(CONCAT(p.products_id, CURRENT_TIMESTAMP))
LIMIT ".MAX_DISPLAY_NEW_PRODUCTS;
durch diesen ersetzt werden:
$new_products_query = "SELECT p.*,
pd.products_name,
pd.products_short_description,
m.manufacturers_name
FROM ".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_MANUFACTURERS." m
ON p.manufacturers_id = m.manufacturers_id
JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd
ON p.products_id = pd.products_id
AND pd.products_name <> ''
AND pd.language_id = '".(int)$_SESSION['languages_id']."'
JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c
ON p.products_id = p2c.products_id
JOIN ".TABLE_CATEGORIES." c
ON c.categories_id = p2c.categories_id
AND c.categories_status = 1
WHERE p.products_status = 1
AND p.products_quantity > 0
".PRODUCTS_CONDITIONS_P."
".$days."
GROUP BY p.products_id
ORDER BY MD5(CONCAT(p.products_id, CURRENT_TIMESTAMP))
LIMIT ".MAX_DISPLAY_NEW_PRODUCTS;
Dann läufts
vielen Dank!