Add Shipping Telephone Support Thread

[orange_juice]

Go with the longer line. This mod was done under 1.3.9a and the longer line was added in 1.3.9d.

All right!

Since I have a few modules installed, it was easier for me to install the Add Shipping Telephone Module according to the template override system.
Therefore, I modified the structure of the directory tree in my installation and I have adjusted it in a way that it changes only 5 core files:

./admin/includes/classes/order.php
./admin/includes/functions/functions_customers.php
./admin/customers.php
./includes/classes/order.php
./includes/functions/functions_customers.php

The other ones are inserted as override files in the template system so it is easier to control them if they need changing or so:

./includes/languages/YOUR_TEMPLATE/english.php
./includes/modules/YOUR_TEMPLATE/create_account.php
./includes/modules/YOUR_TEMPLATE/pages/address_book/header_php.php
./includes/modules/YOUR_TEMPLATE/pages/address_book_process/header_php.php
./includes/modules/YOUR_TEMPLATE/checkout_new_address.php
./includes/modules/YOUR_TEMPLATE/checkout_address_book.php
./includes/templates/YOUR_TEMPLATE/templates/tpl_modules_address_book_details.php
./includes/templates/YOUR_TEMPLATE/templates/tpl_modules_checkout_new_address.php

Thank you again for this contribution.

Kind regards,
orange_juice

[orange_juice]

All right!

Since I have a few modules installed, it was easier for me to install the Add Shipping Telephone Module according to the template override system.
Therefore, I modified the structure of the directory tree in my installation and I have adjusted it in a way that it changes only 5 core files:

./admin/includes/classes/order.php
./admin/includes/functions/functions_customers.php
./admin/customers.php
./includes/classes/order.php
./includes/functions/functions_customers.php

The other ones are inserted as override files in the template system so it is easier to control them if they need changing or so:

./includes/languages/YOUR_TEMPLATE/english.php
./includes/modules/YOUR_TEMPLATE/create_account.php
./includes/modules/YOUR_TEMPLATE/pages/address_book/header_php.php
./includes/modules/YOUR_TEMPLATE/pages/address_book_process/header_php.php
./includes/modules/YOUR_TEMPLATE/checkout_new_address.php
./includes/modules/YOUR_TEMPLATE/checkout_address_book.php
./includes/templates/YOUR_TEMPLATE/templates/tpl_modules_address_book_details.php
./includes/templates/YOUR_TEMPLATE/templates/tpl_modules_checkout_new_address.php

Thank you again for this contribution.

Kind regards,
orange_juice

I faced a problem ...

The address book telephone number was erased just after I inserted it ...

I reinstalled the module replacing all the core files, as per default, and now everything works OK.

Sorry for rushing!

Kind regards,
orange_juice

[beco1979]

A quick question I hope someone might know, Will this work with version 1.38a? Hope so. If not, can anyone help or recommend?
Many thanks, Im almost ready to cut the ribbon on our store!

[JTheed]

A quick question I hope someone might know, Will this work with version 1.38a? Hope so. If not, can anyone help or recommend?
Many thanks, Im almost ready to cut the ribbon on our store!

Yes, It should work fine in 1.38a

[mdmoose]

When I try to install the SQL on 1.3.9g i receive the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL CHANGES ALTER TABLE zen_address_book ADD entry_telephone VARCHAR( 32 ) NULL ' at line 1
in:
[SQL CHANGES ALTER TABLE zen_address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER entry_lastname ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Not very savvy with any of the SQL. Anyone have any ideas?

[JTheed]

When I try to install the SQL on 1.3.9g i receive the following error:



Not very savvy with any of the SQL. Anyone have any ideas?

Try it without the zen_ at zen_address_book so it should be:

ALTER TABLE address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER entry_lastname

JT

[mdmoose]

Oddly enough in the sql I was using it was formatted as you said. But the error message still says it has zen_address_book.
SQL as follows:

SQL CHANGES

ALTER TABLE address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTER `entry_lastname` ;

ALTER TABLE orders ADD delivery_telephone VARCHAR( 32 ) NULL AFTER `delivery_country` ;

UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =1 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =2 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =3 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =4 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =5 LIMIT 1 ;
UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE `address_format`.`address_format_id` =6 LIMIT 1 ;

[HBELLC]

Hello,
I have 1.3.9h and the super order also installed when i went to install this mod and inserted the sql into the database i get this.

1054 Unknown column 'address_format.address_format_id' in 'where clause'
in:
[UPDATE zen_address_format SET address_format = '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country$cr$telephone' WHERE address_format.address_format_id =1 LIMIT 1 ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Now i checked and rechecked all looks good as i can see but i keep getting this error.

Is something wrong or am i doing something wrong?

Thanks

[bindaaz]

I got this mode working in 1.5.0. Let me know if someone needs any assistance. I only changed the sql a bit. Otherwise I merged the changes to the 1.5.0 files and it works perfect now.

[DIHI]

I got this mode working in 1.5.0. Let me know if someone needs any assistance. I only changed the sql a bit. Otherwise I merged the changes to the 1.5.0 files and it works perfect now.

Hello :)

This sounds perfect for what I am looking to do, any chance of an idiots guide to installing it with version 1.5?

Thanks in advance