Dazu mußt du die advanced_search_result.php wie folgt ändern:
SUCHE:
$select_str = "SELECT distinct
$add_select
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_short_description,
pd.products_description ";
$from_str = "FROM ".TABLE_PRODUCTS." AS p LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd ON (p.products_id = pd.products_id) ";
ERSETZE:
$select_str = "SELECT distinct
$add_select
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_short_description,
pd.products_description,
c.categories_status,
cd.categories_name ";
$from_str = "FROM ".TABLE_PRODUCTS." AS p
LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd ON (p.products_id = pd.products_id) " . "
LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p2c.products_id = pd.products_id " . "
LEFT JOIN ".TABLE_CATEGORIES." c ON c.categories_id = p2c.categories_id " . "
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON c.categories_id = cd.categories_id ";
--------------------
SUCHE:
//where-string
$where_str = "
WHERE p.products_status = 1
AND pd.language_id = '".$_SESSION['languages_id']."'"
ERSETZE:
//where-string
$where_str = "WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '".$_SESSION['languages_id']."'"
--------------------
SUCHE:
if (SEARCH_IN_ATTR == 'true') {
FÜGE DAVOR EIN:
$where_str .= "OR cd.categories_name LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR cd.categories_name LIKE ('%".$ent_keyword."%') " : '';
Hier könntest du dann natürlich auch noch in der Kategoriedescription suchen.
Dazu dann noch das darunter:
$where_str .= "OR cd.categories_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR cd.categories_description LIKE ('%".$ent_keyword."%') " : '';
So werden dann alle Produkte dieser Kategorie gefunden.