Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Dangeo1

Archived
  • Posts

    44
  • Joined

  • Last visited

Profile Information

  • Real Name
    Dan George
  • Location
    Atlanta, GA

Dangeo1's Achievements

  1. Thanks! Re-created order contents/address, and made a /tmp/upsxml.log file. It's not working yet, but I haven't given up.
  2. I've got a problem with my UPS rates and I'm trying to get UPS to help me solve them. Basically, their XML rates are lower than the rates actually charged. I'm a small store and take my UPS deliveries to the retail outlet for shipment. So, I sent them an e-mail complaining about it. We've checked all the "usual" suspects and now they want a capture of the XML string that was sent requesting the rate, and the response received. (along with other information). It'll be easy enough to re-create the order, but how can I go about grabbing the XML data stream?
  3. Also, I recommed a program like Editplus to use for editing your php files. It does a good job of color-coding the text to tell what things are comments, functions, HTML, etc... http://www.editplus.com/
  4. Ok, here's what I did. I used the readme.txt to manually update the admincategories.php. It appears to be working fine. But, I did notice one of the changes asks to change code that has already been replaced. "Header Tag Controller Admin MS 2.2.TXT" Find the following (approx line 603) $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); Replace with the following $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); The only place that code exists in the categories.php is already replaced with the following instruction from "Header Tag Controller Admin MS 2.2.TXT" Find the following (approx line 743) <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); } Replace with the following <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); I dunno, maybe I hacked it and turned it into a timebomb.
  5. I have attempted to install the admin portion of the header tag controller, and get the following error: 1054 - Unknown column 'c.categories_status' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name There was no mention of adding fields for the admin portion. I have added all required by Linda's part. Any help would be great.
  6. Thanks for pointing that out. :D I've been in such a rush to get the site up, I missed the standard gif. :?
  7. I am implementing the UPS XML shipping price contribution, and have discovered that "shipping_upsxml.gif" is missing. Does anybody have a valid UPS gif I can use, or should I go steal one from UPS website?
×
×
  • Create New...