snubbr.com

What does DAV/2 mod_Verisign SSL/2.2.3 OpenVerisign SSL/0.9.8d PHP/4.4.4 mod_apreq2-20051231/2.5.7 m

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Got a quick question: What does DAV/2 mod_Verisign SSL/2.2.3 OpenVerisign SSL/0.9.8d PHP/4.4.4 mod_apreq2-20051231/2.5.7 m Thanks in advance for any comment. Another question I got... I am having a problem with adding the customer fax number into the order confirmation email.

I can insert the customers telephone number into the email no problem by adding the line.

Tep_db_output($order->customer['telephone']).

To the.

Checkout_process.php.

File in the catalog directory.

But when I enter fax, the information doesnt show up........

Any help or insight into this will be greatly appricated.

Thanks.

Sean..

Comments (58)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some investigation and get back to you if I bump into an decent answer. You should email the people at Verisign as they probably can answer it..

Comment #1

Another way:.

Add this code to.

/catalog/.

Checkout_process.php.

$fax_query = tep_db_query("select customers_fax from "TABLE_CUSTOMERS" where customers_id = '"(int)$customer_id"'");.

$fax = tep_db_fetch_array($fax_query);.

Then where you want to use the fax number do it similar to this:.

Echo $fax['customers_fax'];.

Note to the previous poster:.

I'm.

Not.

Trying to "one up" you here..

I started piddling with the code to do this, and when I get ready to post it I find someone else has already replied!.

So, I thought I'd just post my code anyway since I spent the time to work on it...

Comment #2

None taken, I find your way easier, in this way, is there no need to add fax number field in the classes/order.php??..

Comment #3

No need that I can see to make any other changes. All the OP wants to do is add it to the email not to the order that gets stored in the DB..

I tested this code and it worked (in another PHP file)..

Although simply adding the fax number to the query already in the code (like you've suggested) would be better..

Trouble is I can't test that!.

And I'm not sure I could even do it successfully..

I'm not very MYSQL literate..

That's why I took the approach I did...

Comment #4

Thanks guys.

Worked great..

I really appreciate your time..

Comment #5

I am having a problem with adding the customer fax number into the order confirmation email.

I can insert the customers telephone number into the email no problem by adding the line.

Tep_db_output($order->customer['telephone']).

To the.

Checkout_process.php.

File in the catalog directory.

But when I enter fax, the information doesnt show up........

Any help or insight into this will be greatly appricated.

Thanks.

Sean..

Comment #6

First you should have a field called customers_fax in customer table (most probably this is already there).

In checkout_process.php, below $payment_modules->before_process();.

Look for $sql_data_array = array('customers_id' => $customer_id,.

In there below customer_telephone add.

'customers_fax' => $order->customer['fax'],.

Open catalog/includes/classes/order.php.. look for $order_id = tep_db_prepare_input($order_id); $order_query = tep_db_query(.

Add.

Customers_fax,.

After customers_telephone.

Look for $this->customer = array('id' same page.. add.

'fax' => $order['customers_fax'],.

Below telephone.

Look for $customer_address_query = tep_db_query( add.

C.customers_fax,.

After telephone.

Look for $this->customer = array('firstname' => $customer_address['customers_firstname'], add.

'fax' => $customer_address['customers_fax'],.

After telephone.

To make this appear in admin/order.php.

Make changes in admin/order.php.

Add this above include(DIR_WS_CLASSES'order.php');.

// Look up things in orders.

$the_extra_query= tep_db_query("select * from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_id= $the_extra['customers_id'];.

// Look up things in customers.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];.

Add this where you need to show the fax no..

<tr>.

<td class="main"><b><?php echo 'FAX #:'; ?></b></td>.

<td class="main"><?php echo $the_customers_fax; ?></td>.

</tr>..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.