Add Shipping Telephone Support Thread

When I try to install the SQL on 1.3.9h 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 address_book ADD entry_telephone VARCHAR( 32 ) NULL AFTE' at line 1
in:
[SQL CHANGES ALTER TABLE 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.


PLEASE HELP. THANKS!

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

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.

Quote:

---

Originally Posted by 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.

---

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

Verifying, works good on 1.3.9h outside of the small (but critical) typo mentioned on post #4 of this thread.

They offer installation if modifying all those files is not your thang.

Thanks! Good mod.

Anybody tested it on ZC1.9h with COWOA?
I installed but got black page while checking out. I am not sure why. It seems a big problem for me.:(
Hope somebody could offer advice.
Thanks

i need help some error to my telephoe i dont know help version 1.5

I installed this on ZC 1.5.1 with Fast and Easy Checkout and COWOA, the SQL file worked good without touching it, just don't include the first line of text "SQL CHANGES",

IMPORTANT! In the readme file, there is one error that needs fixed!, a missing }
Make sure to use this code below:

*****************************************************************
* 4) includes/modules/pages/address_book_process/header_php.php *
*****************************************************************
Add line 60
$telephone = zen_db_prepare_input(zen_sanitize_string($_POST['telephone']));

Add line 97
if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
$error = true;
$messageStack->add('addressbook', ENTRY_TELEPHONE_ERROR);
}

Add line 175
array('fieldName'=>'entry_telephone', 'value'=>$telephone, 'type'=>'string'),
Add to end of line 256 what is in the [ ]'s but DO NOT INCLUDE [ ]
$entry_query = "SELECT entry_gender, entry_company, entry_firstname, entry_lastname, [entry_telephone,]

I also added code to 2 of the FEC files so the customers phone number will show under the addresses on the checkout page, I think this is important so the customer can confirm their address AND phone number before submitting the order, especially when using the one page checkout.

After installing the mod (carefully read the readme file first and manually merge code into your files), use this code below for FEC:

*****************************************************************************
FEC files mods. This will add the phone number to the bottom of the addresses shown on the checkout page
*****************************************************************************

*****************************************************************************
* 1) FEC file /includes/modules/quick_checkout.php
*****************************************************************************
Find around line 440:
'entry_country_id' => $country);

Replace with:
'entry_country_id' => $country,
'entry_telephone' => $telephone);

Find around line 489:
array('fieldName'=>'entry_country_id', 'value'=>$country_shipping, 'type'=>'integer')

replace with:
array('fieldName'=>'entry_country_id', 'value'=>$country_shipping, 'type'=>'integer'),
array('fieldName'=>'entry_telephone', 'value'=>$telephone, 'type'=>'string')

******************************************
* 2) FEC file includes/modules/fec_create_account.php *
******************************************
Add to the end of line 489
'entry_telephone' => $telephone,
******************************************

I copied this to also have a different billing phone number show up in the customers order confirmation email and order history page, and in my Admin. It was easy after already doing this add shipping phone number add on.

Only have to edit the files where you added the delivery_telephone code, do the same thing but make it billing_telephone where the other billing_address code is.


Add Billing telephone number:

*********************************
* 5) includes/classes/order.php *
*********************************
near line add 48 with the other billing_* code
billing_telephone,
near line 147 add with the other billing code
'telephone' => $order->fields['billing_telephone'],
Add near line 603...
'billing_telephone' => $this->billing['telephone'],
***************************************
* 2) admin/includes/classes/order.php *
***************************************
Add to end of line 31 what is in the [ ]'s but DO NOT INCLUDE [ ]
[ billing_telephone,]
Add line near line 113 below the billing_country code
'telephone' => $order->fields['billing_telephone'],

At line 113 make it say billing_telephone instead of customers_telephone (you already put that there based on the directions above for the shipping telephone add on)
'telephone' => $order->fields['billing_telephone'],



First run the below sql:

ALTER TABLE orders ADD billing_telephone VARCHAR( 32 ) NULL AFTER `billing_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 ;