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); } } }