osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Fix for UPS XML

This is a discussion on Fix for UPS XML within the UPS XML forums, part of the Shipping Modules category; If you have a large zones file you will run into a simple problem... Code: $zone_query = tep_db_query("select zone_code ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Features Discussion > Shipping Modules > UPS XML

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 04-11-2008, 12:23 PM
Active Member
 
Join Date: Oct 2005
Location: wherever I happen to be at the moment
Posts: 405
Thanks: 3
Thanked 63 Times in 61 Posts
Rep Power: 6
met00 is a jewel in the roughmet00 is a jewel in the roughmet00 is a jewel in the roughmet00 is a jewel in the rough
Default Fix for UPS XML

If you have a large zones file you will run into a simple problem...

Code:
 $zone_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_name = '" .  $order->delivery['state'] . "'" );
so what if your zone file contains say TWO "Maryland"'s (One in Liberia and one in the US)

Code:
 $zone_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_name = '" .  $order->delivery['state'] . "' and zone_country_id = '".$order->delivery['country']['id']."'");
Simple fix to it sending over an invalid state id of ML instead of MD.
__________________
so endith the lesson
<think>sometimes I just sit's and thinks</think>
"Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
UPS XML Rates and Services v1.0 michael_s New osCommerce Contributions 0 01-31-2008 12:01 PM
UPS XML Rates and Services v1.0 michael_s New osCommerce Contributions 0 01-02-2008 02:10 PM
UPS XML not working rhodesengr UPS XML 0 11-27-2007 08:16 PM
UPS XML Rates and Services v1.0 michael_s New osCommerce Contributions 0 01-31-2007 02:54 PM
UPS and UPS-XML Modules - Interesting kopoba11 osCMax v2 Customization/Mods 3 04-25-2006 11:44 AM


All times are GMT -8. The time now is 11:24 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2008 osCMax