いつもパソコンの前

$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);

↓（・・・カスタマーズテーブルよりデータを検索する際にニックネームの取得を追加）

$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_hn, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);

$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);

↓（更新ページでカスタマーズテーブルのデータを検索する際にニックネームの取得を追加）

$account_query = tep_db_query(”select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_hn, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from ” . TABLE_CUSTOMERS . ” c, ” . TABLE_ADDRESS_BOOK . ” a where c.customers_id = ’” . $customer_id . “’ and a.customers_id = c.customers_id and a.address_book_id = ’” . $customer_default_address_id . “’”);

（２２２行目）

$update_query_customers = $update_query_customers . “customers_firstname = ’” . $_POST[’firstname’] . “’ “;

↓（・・・カスタマーズテーブル登録の際にニックネームを追加する。）

$update_query_customers = $update_query_customers . “customers_firstname = ’” . $_POST[’firstname’] . “’, customers_hn = ’” . $_POST[’hn’] . “’ “;

（２３９行目）

$update_query_address = $update_query_address . “entry_firstname = ’” . $_POST[’firstname’] . “’, entry_lastname = ’” . $_POST[’lastname’] . “’ “;

↓（・・・アドレスブック更新の際にニックネームを追加する。）

$update_query_address = $update_query_address . “entry_firstname = ’” . $_POST[’firstname’] . “’, entry_lastname = ’” . $_POST[’lastname’] . “’, entry_hn = ’” . $_POST[’hn’] . “’ “;

（４８行目～追加）
if (strlen(trim($_POST[’hn’])) < 4) {
$error = true;
$entry_hn_error = true;
} else {
$entry_hn_error = false;
}