Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PhaseClone

Pioneers
  • Posts

    5
  • Joined

  • Last visited

Reputation Activity

  1. Like
    PhaseClone got a reaction from twigster in [Contribution] QTpro - Quantity Tracking Professional   
    @@twigster
     
    try this:
     
    edit your pad_base.php file:
     
    FIND:
     

    $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)$this->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 . "'");
     
    REPLACE WITH:
     

    // Begin QT Pro 4.6.1 (sort by products options values id MOD) 7-2-13 $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)$this->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"); /* $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)$this->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 . "'"); */ // End QT Pro 4.6.1 (sort by products options values id MOD) 7-2-13
     
    The old code is still preserved in the system for you to restore if you need. Please note, this sorts the options by ID, so the order you put them into osCommerce becomes the order that osCommerce displays them.
×
×
  • Create New...