Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Additional fields for address book

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 01-24-2012, 06:07 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Additional fields for address book

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.
Attached Thumbnails
Click image for larger version

Name:	snapshot3.png
Views:	695
Size:	97.6 KB
ID:	2873  
Attached Files
File Type: txt PATCH.sql.txt (236 Bytes, 328 views)
File Type: txt DIFF.patch.4_4_4.txt (30.9 KB, 276 views)
File Type: txt DIFF.patch.4_4_5.txt (31.1 KB, 259 views)
File Type: txt DIFF.patch.4_5_0.txt (40.6 KB, 240 views)
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions

Last edited by qualiteam : 06-20-2012 at 05:51 AM. Reason: 4.5.0 patch uploaded
Reply With Quote

The following 8 users thank qualiteam for this useful post:
am2003 (01-26-2012), chamberinternet (01-27-2012), cherie (01-25-2012), dtgmap (03-13-2015), GreatLakesVacuum (09-05-2012), peggyr (04-28-2012), seyfin (01-27-2012), yvesk (07-06-2012)
  #2  
Old 01-24-2012, 06:12 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Additional fields for address book

Admin back end snapshots.
Attached Thumbnails
Click image for larger version

Name:	snapshot7.png
Views:	649
Size:	62.4 KB
ID:	2874  Click image for larger version

Name:	snapshot8.png
Views:	563
Size:	40.8 KB
ID:	2875  Click image for larger version

Name:	snapshot9.png
Views:	525
Size:	69.3 KB
ID:	2876  Click image for larger version

Name:	snapshot10.png
Views:	531
Size:	39.2 KB
ID:	2877  
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
GreatLakesVacuum (09-05-2012)
  #3  
Old 01-24-2012, 06:13 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Additional fields for address book

Customer front end snapshots.
Attached Thumbnails
Click image for larger version

Name:	snapshot11.png
Views:	562
Size:	112.5 KB
ID:	2878  Click image for larger version

Name:	snapshot13.png
Views:	571
Size:	63.3 KB
ID:	2879  Click image for larger version

Name:	snapshot14.png
Views:	551
Size:	52.0 KB
ID:	2880  Click image for larger version

Name:	snapshot12.png
Views:	542
Size:	82.6 KB
ID:	2881  
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
GreatLakesVacuum (09-05-2012)
  #4  
Old 01-24-2012, 06:51 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default 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
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #5  
Old 01-24-2012, 06:46 PM
 
Nadeem Nadeem is offline
 

Advanced Member
  
Join Date: Sep 2006
Posts: 56
 

Default Re: Additional fields for address book

WOW Finally some one did it.
THANK YOU SO SO SO Much for sharing this.
__________________
X-Cart 4.4.5 | Linux/Apache | PHP 5.2.17 | MySQL 5.0.77 | FireFox
Reply With Quote
  #6  
Old 01-25-2012, 04:03 AM
  carlisleglass's Avatar 
carlisleglass carlisleglass is offline
 

eXpert
  
Join Date: Aug 2003
Location: Carlisle, UK
Posts: 316
 

Default 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?
__________________
Darren Kierman
Carlisle Glass (http://www.carlisleglass.co.uk/)
... running X-Cart Gold 4.4.5 [unix]
Reply With Quote
  #7  
Old 01-25-2012, 04:27 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Additional fields for address book

There should be three SQL queries in the patch.
Including the one you mentioned.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions

Last edited by qualiteam : 01-27-2012 at 01:48 AM.
Reply With Quote
  #8  
Old 01-25-2012, 04:49 AM
  carlisleglass's Avatar 
carlisleglass carlisleglass is offline
 

eXpert
  
Join Date: Aug 2003
Location: Carlisle, UK
Posts: 316
 

Default 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`);
__________________
Darren Kierman
Carlisle Glass (http://www.carlisleglass.co.uk/)
... running X-Cart Gold 4.4.5 [unix]
Reply With Quote
  #9  
Old 01-25-2012, 05:29 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default 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.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #10  
Old 01-25-2012, 05:41 AM
  carlisleglass's Avatar 
carlisleglass carlisleglass is offline
 

eXpert
  
Join Date: Aug 2003
Location: Carlisle, UK
Posts: 316
 

Default 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.
__________________
Darren Kierman
Carlisle Glass (http://www.carlisleglass.co.uk/)
... running X-Cart Gold 4.4.5 [unix]
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 02:14 PM.

   

 
X-Cart forums © 2001-2020