Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

CreedFeed

Members
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • Real Name
    Steve

CreedFeed's Achievements

  1. I received a notice from Authorize.net that there are new MasterCard and Discover processing requirements and that all Merchants must support them. Authorize.net is requiring support by June 30, 2010. For more information about these new requirements, Authorize.net has an FAQ up here: http://www.authorize.net/support/pafaqs/ Are there any plans by OSCommerce or anyone who coded the Authorize.net plugin to be adding support for these new requirements before the June 30 deadline?
  2. I just installed 4.3.0 ALPHA following all instructions as described in the text document and it works perfectly. So far I have not run into any issues. Rates are displayed as expected.
  3. I just resolved the sort order problem in my install. I'm not sure what modules everyone has installed but I had QT Pro Version 4.1 installed as well as a few other custom hacks. To fix the problem I just changed the query used in QT Pro which pulls up the attributes and replaced it with the query that is in the INSTALL file for Attribute Sets Plus. Take the query in Step 6 of the ASP Install instructions and paste it into file catalog/includes/classes/pad_base.php on approximately line 369. Not sure what exact line as my copy may have been hacked more since. In catalog/includes/classes/pad_base.php find: (note that I edited this query in my file to include more data so you can't simply search directly for this query, you're going to have to figure out exactly where it is. In my file it's on line 369 somewhere inside the function definition function _build_attributes_array($build_stocked, $build_nonstocked) { $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pov.prod_opt_val_desc, pov.prod_opt_val_pic, pov.prod_opt_val_price, pov.prod_opt_val_pref, 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 . "'"); and 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 Backup your code before making any changes. I'm not responsible for any problems that happen with your site if you implement this change.
×
×
  • Create New...