PDA

View Full Version : Advanced Address Management for osCommerce 2.3



michael_s
07-11-2013, 04:46 PM
Minor fix for those not using the Encrypted Credit Card with CVV contribution. Updated the orders.php file to not request the added cc_cvv2 field. I've left the line in the file commented out for those that do use the Credit Card contribution and simply put in a copy of the line without the offending field which otherwise creates an error when orders are updated.

Also for those that have installed this contribution after customers have created accounts you will need to perform the following two SQL queries to set the new billing and shipping default addresses.

UPDATE customers SET customers_default_shipping_address_id = customers_default_address_id WHERE customers_default_shipping_address_id = 0;
UPDATE customers SET customers_default_billing_address_id = customers_default_address_id WHERE customers_default_billing_address_id = 0;

For those that are just now installing the contribution the lines have been added to the am_install.sql file included with this version of the contribution so you won't have to worry about this.

Full install enclosed

More... (http://addons.oscommerce.com/info/8756)