admin/includes/modules/new_attributes_select.phpFinde, Zeile 38 ca. $query = "SELECT * FROM ".TABLE_PRODUCTS_DESCRIPTION." where products_id LIKE '%' AND language_id = '" . $_SESSION['languages_id'] . "' ORDER BY products_name ASC";
ersetze gegen: $query = "SELECT
p.products_model,
p.products_id,
pd.products_name
FROM ".
TABLE_PRODUCTS." p, ".
TABLE_PRODUCTS_DESCRIPTION." pd
where
p.products_id = pd.products_id
and p.products_id LIKE '%'
AND pd.language_id = '" . $_SESSION['languages_id'] . "'
ORDER BY
p.products_model asc,
pd.products_name ASC";
Finde, kurz darunter: $title = $line['products_name'];
ersetze gegen: $title = sprintf("[%s] %s", $line['products_model'], $line['products_name']); Finde: $copy_query = xtc_db_query("SELECT pd.products_name, pd.products_id FROM ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_ATTRIBUTES." pa where pa.products_id = pd.products_id AND pd.products_id LIKE '%' AND pd.language_id = '" . $_SESSION['languages_id'] . "' GROUP BY pd.products_id ORDER BY pd.products_name ASC");
Ersetze gegen: $copy_query = xtc_db_query("SELECT
p.products_model,
pd.products_name,
pd.products_id
FROM ".
TABLE_PRODUCTS." p, ".
TABLE_PRODUCTS_DESCRIPTION." pd, ".
TABLE_PRODUCTS_ATTRIBUTES." pa
where
p.products_id = pd.products_id
AND pa.products_id = pd.products_id
AND pd.products_id LIKE '%'
AND pd.language_id = '" . $_SESSION['languages_id'] . "'
GROUP BY
pd.products_id
ORDER BY
p.products_model ASC,
pd.products_name ASC");
Finde, kurz dahinter: echo '<option value="' . $copy_res['products_id'] . '">' . $copy_res['products_name'] . '</option>';
Ersetze gegen: echo '<option value="' . $copy_res['products_id'] . '">['.$copy_res['products_model'].'] '.$copy_res['products_name'] . '</option>';
Gruß
Hen
[
EDIT Tomcraft 20.04.2011: Anleitung korrigiert.]