Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

delive

Members
  • Content count

    5
  • Joined

  • Last visited

  1. delive

    Attribute Sets Plus

    Hi, This is a great contribution but I'm having an issue displaying the attributes. Everything looks good in the admin panel but the display shows nothing on product_info.php. <td class="main">Size:</td> <td class="main"><select name="id[2]"></select></td> Also, I tried to apply a single attribute without using attribute set and the same issue occured. This is the code I had, which correctly displays the attributes: $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 . "'"); This is what I'm trying to 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 Any ideas? Thanks
  2. delive

    Automatically send data feed to Froogle

    I'm having an issue. When I use the feeder, it says its uploaded correctly, but when I check my google base, there is nothing in it. Is there some sort of delay? I dont see why this is happening.
  3. delive

    Authorize.net Checkout Issue

    Has anyone else had this problem before?
  4. delive

    Authorize.net Checkout Issue

    Yes, I have the transaction key and username directly from authorize.net. I still can't figure out why this is happening, any other ideas?
  5. delive

    Authorize.net Checkout Issue

    Hi, My website is running functionally SSL certs and I'm having a problem when a user trys to checkout and purchase their product. If they checkout using check or money order, the process goes through fine. The issue is when using Authorize.net. Right after they hit confirm order, the page is then directed to https://secure.authorize.net/gateway/transact.dll and an email is sent to that user confirming their order, but the page doesn't show anything from authorize.net. The page shows the login page for oscommerce and the order is not logged in authorize.net or oscommerce at all. Does anyone know why this is happening? It is extremely frusterating. I read another post about an issue of not having cURL installed, but: CURL support enabled CURL Information libcurl/7.15.3 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6 Thanks
×