X-Cart forums

[qualiteam]

In order to add this feature you can try the following modification (patches for X-Cart 4.4.4):

1. Apply the attached PATCH.sql
2. Apply the attached DIFF.patch

http://help.qtmsoft.com/index.php?title=X-Cart:Applying_Patches

See the attached snapshots.

Once the patches are applied new options will be available on profile options page in admin back end and customer front end.

New "Address book" fields will appear on checkout and address book pages.

See the attached snapshots (next posts).

Note: Only default build-in fields can be used for shipping calculations.

[qualiteam]

Admin back end snapshots.

[qualiteam]

Customer front end snapshots.

[cflsystems]

Thanks for that Alex. Maybe you can consider it being included in 4.4.5 by default. Also very very helpful will be to have position for all fields so they can be sorted any way

[Nadeem]

WOW Finally some one did it.
THANK YOU SO SO SO Much for sharing this.

[carlisleglass]

Did you miss

ALTER TABLE xcart_address_book ADD `addressid` INT(11) NOT NULL DEFAULT '0';

from the SQL patch?

[qualiteam]

There should be three SQL queries in the patch.
Including the one you mentioned.

[carlisleglass]

This is the contents of 'PATCH.sql.txt'

ALTER TABLE xcart_register_field_values ADD `addressid` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE xcart_register_field_values DROP PRIMARY KEY;
ALTER TABLE xcart_register_field_values ADD PRIMARY KEY (`fieldid`, `userid`, `addressid`);

[qualiteam]

Originally Posted by carlisleglass

This is the contents of 'PATCH.sql.txt'

ALTER TABLE xcart_register_field_values ADD `addressid` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE xcart_register_field_values DROP PRIMARY KEY;
ALTER TABLE xcart_register_field_values ADD PRIMARY KEY (`fieldid`, `userid`, `addressid`);

Yes, these are the SQL queries that are required.

The addressid field is already in the address book table, it is called "id" there.

It seems I was wrong when I said your query is required.
I missed the table name in your query. Sorry.

So, all the required SQL can be found in my first post.

[carlisleglass]

For some reason my xcart installation didn't have an addressid on the address_book table, and I had to add it.