Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

morphir

Archived
  • Posts

    7
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ina

morphir's Achievements

  1. 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!
  2. Hi, I would like to apply the Master Products module with register globals off. Anyone who could help me out with that one? All help are most appriciated! Regards :thumbsup:
  3. Hi! I wonder if MS3 will have the register_globals off feature embeded ? :-"
×
×
  • Create New...