Hi,
Sorry about this.
You will need to edit your shop/includes/application_top.php
Find around line 525:
PHP Code:
$check_customer_query = tep_db_query("select customers_firstname, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_id = '". $usersid ."'");
Add before it:
PHP Code:
$customers_gender = 'm';
$customers_default_address_id = '0';
$customers_newsletter = '1';
Find around line 528:
PHP Code:
tep_db_query("insert into " . TABLE_CUSTOMERS . " (customers_id, customers_username, customers_gender, customers_firstname, customers_email_address, customers_default_address_id, customers_newsletter) VALUES ('$usersid', '$vbusername', 'm', '$vbusername', '$vbemail', '0', '1')");
Replace with:
PHP Code:
$sql_data_array = array('customers_id' => $usersid,
'customers_username' => $vbusername,
'customers_gender' => $customers_gender,
'customers_firstname' => $vbusername,
'customers_email_address' => $vbemail,
'customers_default_address_id' => $customers_default_address_id,
'customers_newsletter' => $customers_newsletter);
tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);
Find around line 576:
PHP Code:
tep_db_query("update " . TABLE_CUSTOMERS . " set customers_username = '" . $vbusername . "' where customers_id = '" . $usersid . "'");
Replace with:
PHP Code:
$sql_data_array = array('customers_username' => $vbusername);
tep_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '" . $usersid . "'");