Hi,
This is a great contribution but I'm having an issue displaying the attributes.
Everything looks good in the admin panel but the display shows nothing on product_info.php.
<td class="main">Size:</td>
<td class="main"><select name="id[2]"></select></td>
Also, I tried to apply a single attribute without using attribute set and the same issue occured.
This is the code I had, which correctly displays the attributes:
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
This is what I'm trying to replace it with:
// BOF Linkmatics attributes sets plus
$products_options_query = tep_db_query("
SELECT pov.products_options_values_id, pov.products_options_values_name,
pa.options_values_price, pa.price_prefix , pase.sort_order
FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " .
TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " pas2pa, " .
TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " .
TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, " .
TABLE_PRODUCTS_OPTIONS_VALUES . " pov
WHERE pa.products_id = '" . (int)$_GET['products_id'] . "'
AND pa.options_id = '" . $products_options_name['products_options_id'] . "'
AND pas2pa.products_id = pa.products_id
AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id
AND pas.products_options_id = pa.options_id
AND pase.products_attributes_sets_id = pas.products_attributes_sets_id
AND pase.options_values_id = pa.options_values_id
AND pov.products_options_values_id = pa.options_values_id
AND pov.language_id = '" . $languages_id . "'
ORDER BY pase.sort_order, pa.options_values_id");
// >>>>> BOF Linkmatics attributes sets plus patch v1.01
if (tep_db_num_rows($products_options_query)== 0 ) {
$products_options_query = tep_db_query("
SELECT pov.products_options_values_id, pov.products_options_values_name,
pa.options_values_price, pa.price_prefix , pa.options_values_id
FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " .
TABLE_PRODUCTS_OPTIONS_VALUES . " pov
WHERE pa.products_id = '" . (int)$_GET['products_id'] . "'
AND pa.options_id = '" . $products_options_name['products_options_id'] . "'
AND pov.products_options_values_id = pa.options_values_id
AND pov.language_id = '" . $languages_id . "'
ORDER BY pa.options_values_id");
}
// <<<<< EOF Linkmatics attributes sets plus patch v1.01
// EOF Linkmatics attributes sets plus
Any ideas?
Thanks