if (CUSTOMERS_APPROVAL_AUTHORIZATION == 2 and $customers_authorization == 1) {
$customers_authorization = 2;
$messageStack->add_session(ERROR_CUSTOMER_APPROVAL_CORRECTION2, 'caution');
}
if (CUSTOMERS_APPROVAL_AUTHORIZATION == 1 and $customers_authorization == 2) {
$customers_authorization = 1;
$messageStack->add_session(ERROR_CUSTOMER_APPROVAL_CORRECTION1, 'caution');
}
$default_address_id = zen_db_prepare_input($_POST['default_address_id']);
$entry_street_address = zen_db_prepare_input($_POST['entry_street_address']);
$entry_suburb = zen_db_prepare_input($_POST['entry_suburb']);
$entry_postcode = zen_db_prepare_input($_POST['entry_postcode']);
$entry_city = zen_db_prepare_input($_POST['entry_city']);
$entry_country_id = zen_db_prepare_input($_POST['entry_country_id']);
$entry_company = zen_db_prepare_input($_POST['entry_company']);
$entry_state = zen_convert_to_zone_name(zen_db_prepare_input($_POST['entry_state']));
if (isset($_POST['entry_zone_id'])) {
$entry_zone_id = zen_db_prepare_input($_POST['entry_zone_id']);
}
if (strlen($customers_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
$error = true;
$entry_firstname_error = true;
} else {
$entry_firstname_error = false;
}
if (strlen($customers_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
$error = true;
$entry_lastname_error = true;
} else {
$entry_lastname_error = false;
}
$entry_state_has_zones = $check->fields['total'] > 0;
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_array[] = array('id' => PULL_DOWN_ALL, 'text' => PULL_DOWN_ALL);
$zones_values = $db->Execute("select zone_name\r\n from " . TABLE_ZONES . "\r\n where zone_country_id = '" . (int) $country . "'\r\n order by zone_id");
while (!$zones_values->EOF) {
$zones_array[] = array('id' => zen_convert_to_zone_name_m17n($zones_values->fields['zone_name']), 'text' => zen_convert_to_zone_name_m17n($zones_values->fields['zone_name']));
$zones_values->MoveNext();
}
$zone_query = "select distinct zone_id, zone_name\r\n from " . TABLE_ZONES . "\r\n where zone_country_id = '" . (int) $country . "'\r\n and zone_code = '" . strtoupper(zen_db_input($state)) . "'";
$zone = $db->Execute($zone_query);
if ($zone->RecordCount() > 0) {
$zone_id = $zone->fields['zone_id'];
$zone_name = zen_convert_to_zone_name_m17n($zone->fields['zone_name']);
} else {
$zone_query = "select distinct zone_id, zone_name\r\n from " . TABLE_ZONES . "\r\n where zone_country_id = '" . (int) $country . "'\r\n and (zone_name like '" . zen_convert_to_zone_name(zen_db_input($state)) . "'\r\n or zone_code like '" . strtoupper(zen_db_input($state)) . "')";
$zone = $db->Execute($zone_query);
if ($zone->RecordCount() > 0) {
$zone_id = $zone->fields['zone_id'];
$zone_name = zen_convert_to_zone_name_m17n($zone->fields['zone_name']);
}
}
if (!$zone_name) {
$error = true;
$messageStack->add('create_account', ENTRY_STATE_ERROR_SELECT);
}
} else {
if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_STATE_ERROR);
}
if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
$error = true;
$messageStack->add('checkout_address', ENTRY_TELEPHONE_NUMBER_ERROR);
}
if (ACCOUNT_STATE == 'true') {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_array[] = array('id' => PULL_DOWN_ALL, 'text' => PULL_DOWN_ALL);
$zones_values = $db->Execute("select zone_name\r\n from " . TABLE_ZONES . "\r\n where zone_country_id = '" . (int) $country . "'\r\n order by zone_id");
while (!$zones_values->EOF) {
$zones_array[] = array('id' => zen_convert_to_zone_name_m17n($zones_values->fields['zone_name']), 'text' => zen_convert_to_zone_name_m17n($zones_values->fields['zone_name']));
$zones_values->MoveNext();
}
$zone_query = "SELECT distinct zone_id\r\n FROM " . TABLE_ZONES . "\r\n WHERE zone_country_id = :zoneCountryID\r\n AND (zone_name like ':zone1'\r\n OR zone_code like ':zone2')";
$zone_query = $db->bindVars($zone_query, ':zoneCountryID', $country, 'integer');
$zone_query = $db->bindVars($zone_query, ':zone1', zen_convert_to_zone_name($state), 'noquotestring');
$zone_query = $db->bindVars($zone_query, ':zone2', strtoupper($state), 'noquotestring');
$zone = $db->Execute($zone_query);
if ($zone->RecordCount() == 1) {
$zone_id = $zone->fields['zone_id'];
} else {
$error = true;
$messageStack->add('checkout_address', ENTRY_STATE_ERROR_SELECT);
}
} else {
if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
$error = true;
$messageStack->add('checkout_address', ENTRY_STATE_ERROR);
}
}
}
