X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   Additional fields for address book (https://forum.x-cart.com/showthread.php?t=62429)

qualiteam 01-24-2012 06:07 AM

Additional fields for address book
 
5 Attachment(s)
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 01-24-2012 06:12 AM

Re: Additional fields for address book
 
4 Attachment(s)
Admin back end snapshots.

qualiteam 01-24-2012 06:13 AM

Re: Additional fields for address book
 
4 Attachment(s)
Customer front end snapshots.

cflsystems 01-24-2012 06:51 AM

Re: Additional fields for address book
 
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 01-24-2012 06:46 PM

Re: Additional fields for address book
 
WOW Finally some one did it.
THANK YOU SO SO SO Much for sharing this.

carlisleglass 01-25-2012 04:03 AM

Re: Additional fields for address book
 
Did you miss
Code:

ALTER TABLE xcart_address_book ADD `addressid` INT(11) NOT NULL DEFAULT '0';
from the SQL patch?

qualiteam 01-25-2012 04:27 AM

Re: Additional fields for address book
 
There should be three SQL queries in the patch.
Including the one you mentioned.

carlisleglass 01-25-2012 04:49 AM

Re: Additional fields for address book
 
This is the contents of 'PATCH.sql.txt'
Code:

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 01-25-2012 05:29 AM

Re: Additional fields for address book
 
Quote:

Originally Posted by carlisleglass
This is the contents of 'PATCH.sql.txt'
Code:

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 01-25-2012 05:41 AM

Re: Additional fields for address book
 
For some reason my xcart installation didn't have an addressid on the address_book table, and I had to add it.


All times are GMT -8. The time now is 02:35 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.