Yeah! Great contribution. But i cant get the hang of what you mean in the install procedure at step 6. to 6.1 an 6.2, wich are as followes:
Step 6. This code retrieves the attributes and orders them according to the required sort order.
It also orders attributes by the table 'id' number (the order in which they are created)
if the attributes are not part of a set. If you do not like this default orderring then
remove the following line from the new code:
ORDER BY pase.sort_order, pa.options_values_id");
and replace with:
ORDER BY pase.sort_order");
**HINT**: In a fresh copy of osCommerce's /catalog/product_info.php page, look at line 134 for this
query.
******** 6.1a: Change this query:
$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 . "'");
******** 6.1b: To this query by adding an "order by" clause to the end of the statement.
Note: (this is not tested outside my own install. I think this will work but if it doesn't let me know and I'll work out what I've missed!)
// 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");
// EOF Linkmatics attributes sets plus
What iam i supposed to replace, and visa versa.. Hope that you get my problem.
It would be great if you could be a little more spesific. Thanks, and again: GREAT CONTR.! :thumbsup:
Best Regards!