Contributions

All thanks goes to geoffreywalton who found the missing code.

In catalog/admin/includes/classes/order.php

Change line 35

function query($order_id) {
$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

to

function query($order_id) {
$order_query = tep_db_query("select customers_title, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_title, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_title, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

Nothing else has changed. Zip file only contains this information.

I'm sorry for the confusing flurry of posts. This now has the correct .zip file in it.

I've not posted anything here before - I'd be very happy for anyone to look at the slight mod I made to the SQL and verify:
a) it was required
b) it was right.
thanks

I installed this contribution and was getting unknown field errors for customers_title. I've checked through the contribution and there doesn't seem to be any SQL to add the field 'customers_title' to the 'customers' table.

I added 'customers_title' to my DB using phpMyAdmin and the contribution worked fine. I've added the following line to the SQL inside the installation text.

ALTER TABLE customers ADD customers_title varchar(32);

Please backup your DB before you do any of this.

=========================================
Bug Fixes
=========================================
There are two bug fixes to the original version.

1, account_edit.php, the title field was not automatically filling from the database when a customer chooses to edit their details.
Thanks to Peter Loeffler for identifying this bug.

2, Textbox rather than aa dropdown showing in address_book_process.php

The included files have been updated with the fixes and a text file (bug_fixes.txt) with the fixes has been included for those who
have already installed this modification.

Brian Sim. 18/09/2004

****NOTE: the files included in the zip have been fixed!!****

=========================================

The fixes are.......

account_edit.php
line 124

Change

$account_query = tep_db_query("select customers_gender, customers_title, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");

to

$account_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, c.customers_telephone, c.customers_fax, a.entry_title_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$customer_id . "'");

Line 209
Change

<td class="main"><?php echo tep_get_title_list('title', STORE_TITLE) . '&nbsp;' . (tep_not_null(ENTRY_TITLE_TEXT) ? '<span class="inputRequirement">' . ENTRY_TITLE_TEXT . '</span>': ''); ?></td>

to

<td class="main"><?php echo tep_get_title_list('title', $account['entry_title_id']) . '&nbsp;' . (tep_not_null(ENTRY_TITLE_TEXT) ? '<span class="inputRequirement">' . ENTRY_TITLE_TEXT . '</span>': ''); ?></td>


And to add a dropdown to address _book_process.php edit address_book_details.php

catalog/includes/modules/address_book_details.php
line 46

Change

<td class="main"><?php echo tep_draw_input_field('title', $entry['entry_title']) . '&nbsp;' . (tep_not_null(ENTRY_TITLE_TEXT) ? '<span class="inputRequirement">' . ENTRY_TITLE_TEXT . '</span>': ''); ?></td>

to

<td class="main"><?php echo tep_get_title_list('title', $entry['entry_title_id']) . '&nbsp;' . (tep_not_null(ENTRY_TITLE_TEXT) ? '<span class="inputRequirement">' . ENTRY_TITLE_TEXT . '</span>': ''); ?></td>

This mod will add a Title dropdown box to all customer details pages including
create_account, checkout_shipping_address, checkout_payment_address and admin/customers.

***Also works with the Payment_without_account (PWA0.80) contribution!

In addition to the title dropdowns, this mod upgrades any pages which display addresses to handle the new title information such as checkout_shipping, checkout_payment, checkout_confirmation, admin/invoice, admin/invoice and admin/packingslip.

Not yet tested in a live site so treat as a bete version!