if (ACCOUNT_STATE == 'true') {
if ($zone_id > 0) {
$sql_data_array['entry_zone_id'] = $zone_id;
$sql_data_array['entry_state'] = '';
} else {
$sql_data_array['entry_zone_id'] = '0';
$sql_data_array['entry_state'] = $state;
}
}
zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
$address_id = $db->Insert_ID();
$sql = "update " . TABLE_CUSTOMERS . "\n set customers_default_address_id = '" . (int) $address_id . "'\n where customers_id = '" . (int) $_SESSION['customer_id'] . "'";
$db->Execute($sql);
$sql = "insert into " . TABLE_CUSTOMERS_INFO . "\n (customers_info_id, customers_info_number_of_logons,\n customers_info_date_account_created)\n values ('" . (int) $_SESSION['customer_id'] . "', '0', now())";
$db->Execute($sql);
if (enable_shippingAddress()) {
// create shipping address
$sql_data_array = array(array('fieldName' => 'customers_id', 'value' => $_SESSION['customer_id'], 'type' => 'integer'), array('fieldName' => 'entry_firstname', 'value' => $firstname_shipping, 'type' => 'string'), array('fieldName' => 'entry_lastname', 'value' => $lastname_shipping, 'type' => 'string'), array('fieldName' => 'entry_street_address', 'value' => $street_address_shipping, 'type' => 'string'), array('fieldName' => 'entry_postcode', 'value' => $postcode_shipping, 'type' => 'string'), array('fieldName' => 'entry_city', 'value' => $city_shipping, 'type' => 'string'), array('fieldName' => 'entry_country_id', 'value' => $country_shipping, 'type' => 'integer'));
if (ACCOUNT_GENDER == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_gender', 'value' => $gender_shipping, 'type' => 'enum:m|f');
}
if (ACCOUNT_COMPANY == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_company', 'value' => $company_shipping, 'type' => 'string');
}
if (ACCOUNT_SUBURB == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_suburb', 'value' => $suburb_shipping, 'type' => 'string');
}
if (ACCOUNT_STATE == 'true') {
if ($zone_id_shipping > 0) {
$sql_data_array[] = array('fieldName' => 'entry_zone_id', 'value' => $zone_id_shipping, 'type' => 'integer');
$sql_data_array[] = array('fieldName' => 'entry_state', 'value' => '', 'type' => 'string');
if (ACCOUNT_STATE == 'true') {
if ($zone_id > 0) {
$sql_data_array['entry_zone_id'] = $zone_id;
$sql_data_array['entry_state'] = '';
} else {
$sql_data_array['entry_zone_id'] = '0';
$sql_data_array['entry_state'] = $state;
}
}
zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
$address_id = $db->Insert_ID();
$zco_notifier->notify('NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_ADDRESS_BOOK_RECORD', array_merge(array('address_id' => $address_id), $sql_data_array));
$sql = "update " . TABLE_CUSTOMERS . "\n set customers_default_address_id = '" . (int) $address_id . "'\n where customers_id = '" . (int) $_SESSION['customer_id'] . "'";
$db->Execute($sql);
// shipping address
if ($_GET['main_page'] != "create_account" && enable_shippingAddress()) {
// create shipping address
$sql_data_array = array(array('fieldName' => 'customers_id', 'value' => $_SESSION['customer_id'], 'type' => 'integer'), array('fieldName' => 'entry_firstname', 'value' => $firstname_shipping, 'type' => 'string'), array('fieldName' => 'entry_lastname', 'value' => $lastname_shipping, 'type' => 'string'), array('fieldName' => 'entry_street_address', 'value' => $street_address_shipping, 'type' => 'string'), array('fieldName' => 'entry_postcode', 'value' => $postcode_shipping, 'type' => 'string'), array('fieldName' => 'entry_city', 'value' => $city_shipping, 'type' => 'string'), array('fieldName' => 'entry_country_id', 'value' => $country_shipping, 'type' => 'integer'));
if (ACCOUNT_GENDER == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_gender', 'value' => $gender_shipping, 'type' => 'enum:m|f');
}
if (ACCOUNT_COMPANY == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_company', 'value' => $company_shipping, 'type' => 'string');
}
if (ACCOUNT_SUBURB == 'true') {
$sql_data_array[] = array('fieldName' => 'entry_suburb', 'value' => $suburb_shipping, 'type' => 'string');
}
if (ACCOUNT_STATE == 'true') {
if ($zone_id_shipping > 0) {
$sql_data_array[] = array('fieldName' => 'entry_zone_id', 'value' => $zone_id_shipping, 'type' => 'integer');
$sql_data_array[] = array('fieldName' => 'entry_state', 'value' => '', 'type' => 'string');
