Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

reihtec

Archived
  • Posts

    1
  • Joined

  • Last visited

Profile Information

  • Real Name
    Mahomed

reihtec's Achievements

  1. Hi Chris, Firstly thank you for a great contribuition. I must say that the install wasn't bad although I came across one major problem. The same one as a lot of people are having, where previous attributes aren't showing and all you have on the product_info page is a blank dropdown. I made sure all the code was ok, and changed one bit of code in your 1.01 patch and it worked. In summary, I changed the query in the 1.01 patch to the original one and it worked. For all those having problem, here is the steps: 1) Follow Step 6 in the install readme 2) Instead of the code in the readme, paste this text // 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 ) { /* BELOW IS THE LINE I ADDED */ $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 . "'"."order by pov.products_options_values_id"); } // <<<<< EOF Linkmatics attributes sets plus patch v1.01 // EOF Linkmatics attributes sets plus Note that this query has been changed to order the attributes in the order they were added into the db, if you want it in alphabetical order, remove this bit of code ."order by pov.products_options_values_id"
×
×
  • Create New...