本文整理汇总了PHP中tep_get_zone_name函数的典型用法代码示例。如果您正苦于以下问题:PHP tep_get_zone_name函数的具体用法?PHP tep_get_zone_name怎么用?PHP tep_get_zone_name使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了tep_get_zone_name函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: array
?>
</label>
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int) $country . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('state', $zones_array);
} else {
echo tep_draw_input_field('state');
}
} else {
echo tep_draw_input_field('state', isset($entry['entry_country_id']) ? tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']) : '');
}
?>
</div>
<?php
}
?>
<div class="form-group">
<label><?php
echo (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<sup class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</sup>' : '') . ENTRY_COUNTRY;
?>
</label>
<?php
echo tep_get_country_list('country', isset($entry['entry_country_id']) ? $entry['entry_country_id'] : STORE_COUNTRY);
?>
</div>
示例2: array
if (tep_not_null(ENTRY_CITY_TEXT)) {
$xoopsTpl->assign("city_entry", '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>');
}
if (ACCOUNT_STATE == 'true') {
$xoopsTpl->assign("state", 1);
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int) $country . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
$xoopsTpl->assign("cstate", tep_draw_pull_down_menu('state', $zones_array));
} else {
$xoopsTpl->assign("cstate", tep_draw_input_field('state'));
}
} else {
$xoopsTpl->assign("cstate", tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state'])));
}
if (tep_not_null(ENTRY_STATE_TEXT)) {
$xoopsTpl->assign("state_entry", ' <span class="inputRequirement">' . ENTRY_STATE_TEXT);
}
}
$xoopsTpl->assign("country", tep_get_country_list('country', $entry['entry_country_id']));
if (tep_not_null(ENTRY_COUNTRY_TEXT)) {
$xoopsTpl->assign("country_entry", '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>');
}
if (isset($HTTP_GET_VARS['edit']) && $customer_default_address_id != $HTTP_GET_VARS['edit'] || isset($HTTP_GET_VARS['edit']) == false) {
$xoopsTpl->assign("primary", 1);
$xoopsTpl->assign("primary_field", tep_draw_checkbox_field('primary', 'on', false, 'id="primary"'));
}
示例3: array
?>
</td>
<td class="main" width="70%">
<?php
if ($action == 'save' && isset($entry_state_has_zones) && $entry_state_has_zones === true) {
$Qzones = $osC_Database->query('select zone_name from :table_zones where zone_country_id = :zone_country_id order by zone_name');
$Qzones->bindTable(':table_zones', TABLE_ZONES);
$Qzones->bindInt(':zone_country_id', $_POST['ab_country']);
$Qzones->execute();
$zones_array = array();
while ($Qzones->next()) {
$zones_array[] = array('id' => $Qzones->value('zone_name'), 'text' => $Qzones->value('zone_name'));
}
echo osc_draw_pull_down_menu('ab_state', $zones_array, '', '', ACCOUNT_STATE > 0);
} else {
echo osc_draw_input_field('ab_state', isset($Qab) ? tep_get_zone_name($Qab->value('entry_country_id'), $Qab->value('entry_zone_id'), $Qab->value('entry_state')) : '', '', ACCOUNT_STATE > 0);
}
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main" width="30%"><?php
echo ENTRY_COUNTRY;
?>
</td>
<td class="main" width="70%"><?php
echo osc_draw_pull_down_menu('ab_country', tep_get_countries(), isset($Qab) ? $Qab->value('entry_country_id') : STORE_COUNTRY, '', true);
?>
示例4: array
</label>
<div class="col-sm-9">
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int) $country . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('state', $zones_array, 0, 'id="inputState"');
} else {
echo tep_draw_input_field('state', NULL, 'id="inputState" placeholder="' . ENTRY_STATE . '"');
}
} else {
echo tep_draw_input_field('state', isset($entry['entry_country_id']) ? tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']) : '', 'required aria-required="true" id="inputState" placeholder="' . ENTRY_STATE . '"');
}
if (tep_not_null(ENTRY_STATE_TEXT)) {
echo '<span class="help-block">' . ENTRY_STATE_TEXT . '</span>';
}
?>
</div>
</div>
<?php
}
?>
<div class="form-group has-feedback">
<label for="inputCountry" class="control-label col-sm-3"><?php
echo ENTRY_COUNTRY;
示例5: array
if ($entry_state_error == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($cInfo->entry_country_id) . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('entry_state', $zones_array) . ' ' . ENTRY_STATE_ERROR;
} else {
echo tep_draw_input_field('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)) . ' ' . ENTRY_STATE_ERROR;
}
} else {
echo $entry_state . tep_draw_hidden_field('entry_zone_id') . tep_draw_hidden_field('entry_state');
}
} else {
echo tep_draw_input_field('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state));
}
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main"><?php
echo ENTRY_COUNTRY;
?>
</td>
<td class="main">
<?php
if ($error == true) {
示例6: array
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$Qzones = $OSCOM_Db->prepare('select zone_name from :table_zones where zone_country_id = :zone_country_id order by zone_name');
$Qzones->bindInt(':zone_country_id', $country);
$Qzones->execute();
while ($Qzones->fetch()) {
$zones_array[] = array('id' => $Qzones->value('zone_name'), 'text' => $Qzones->value('zone_name'));
}
echo HTML::selectField('state', $zones_array, 0, 'id="inputState" aria-describedby="atState"');
} else {
echo HTML::inputField('state', NULL, 'id="inputState" placeholder="' . OSCOM::getDef('entry_state_text') . '"');
}
} else {
echo HTML::inputField('state', isset($entry['entry_country_id']) ? tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']) : '', 'id="inputState" placeholder="' . OSCOM::getDef('entry_state_text') . '"');
}
if (tep_not_null(OSCOM::getDef('entry_state_text'))) {
echo '<span id="atState" class="help-block">' . OSCOM::getDef('entry_state_text') . '</span>';
}
?>
</div>
</div>
<?php
}
?>
<div class="form-group has-feedback">
<label for="inputCountry" class="control-label col-sm-3"><?php
echo OSCOM::getDef('entry_country');
示例7: array
if ($entry_state_error) {
if ($entry_state_has_zones) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($country) . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('state', $zones_array) . ' ' . ENTRY_STATE_ERROR;
} else {
echo tep_draw_input_field('state') . ' ' . ENTRY_STATE_ERROR;
}
} else {
echo $state . tep_draw_hidden_field('zone_id') . tep_draw_hidden_field('state');
}
} else {
echo '<label class="sr-only"></label>' . tep_draw_input_field('state', '', 'class="form-control" placeholder="' . ENTRY_STATE . '"', tep_get_zone_name($account['entry_country_id'], isset($account['entry_zone_id']) ? $account['entry_zone_id'] : 0, isset($account['entry_state']) ? $account['entry_state'] : 0));
}
?>
</div>
<?php
}
?>
<div class="form-group">
<?php
if ($is_read_only) {
echo $account['entry_postcode'];
} elseif ($error) {
if ($entry_post_code_error) {
echo tep_draw_input_field('postcode', '', 'maxlength="10"') . ' ' . ENTRY_POST_CODE_ERROR;
} else {
echo $postcode . tep_draw_hidden_field('postcode');
示例8: confirmation
function confirmation()
{
global $customer_id, $order, $currencies;
$months_array = array();
for ($i = 1; $i < 13; $i++) {
$months_array[] = array('id' => tep_output_string(sprintf('%02d', $i)), 'text' => tep_output_string_protected(sprintf('%02d', $i)));
}
$today = getdate();
$years_array = array();
for ($i = $today['year']; $i < $today['year'] + 10; $i++) {
$years_array[] = array('id' => tep_output_string(strftime('%Y', mktime(0, 0, 0, 1, 1, $i))), 'text' => tep_output_string_protected(strftime('%Y', mktime(0, 0, 0, 1, 1, $i))));
}
$months_string = '<select data-stripe="exp_month">';
foreach ($months_array as $m) {
$months_string .= '<option value="' . tep_output_string($m['id']) . '">' . tep_output_string($m['text']) . '</option>';
}
$months_string .= '</select>';
$years_string = '<select data-stripe="exp_year">';
foreach ($years_array as $y) {
$years_string .= '<option value="' . tep_output_string($y['id']) . '">' . tep_output_string($y['text']) . '</option>';
}
$years_string .= '</select>';
$content = '';
if (MODULE_PAYMENT_STRIPE_TOKENS == 'True') {
$tokens_query = tep_db_query("select id, card_type, number_filtered, expiry_date from customers_stripe_tokens where customers_id = '" . (int) $customer_id . "' order by date_added");
if (tep_db_num_rows($tokens_query) > 0) {
$content .= '<table id="stripe_table" border="0" width="100%" cellspacing="0" cellpadding="2">';
while ($tokens = tep_db_fetch_array($tokens_query)) {
$content .= '<tr class="moduleRow" id="stripe_card_' . (int) $tokens['id'] . '">' . ' <td width="40" valign="top"><input type="radio" name="stripe_card" value="' . (int) $tokens['id'] . '" /></td>' . ' <td valign="top"><strong>' . tep_output_string_protected($tokens['card_type']) . '</strong> ****' . tep_output_string_protected($tokens['number_filtered']) . ' ' . tep_output_string_protected(substr($tokens['expiry_date'], 0, 2) . '/' . substr($tokens['expiry_date'], 2)) . '</td>' . '</tr>';
}
$content .= '<tr class="moduleRow" id="stripe_card_0">' . ' <td width="40" valign="top"><input type="radio" name="stripe_card" value="0" /></td>' . ' <td valign="top">' . MODULE_PAYMENT_STRIPE_CREDITCARD_NEW . '</td>' . '</tr>' . '</table>';
}
}
$content .= '<div class="messageStackError payment-errors"></div>' . '<table id="stripe_table_new_card" border="0" width="100%" cellspacing="0" cellpadding="2">' . '<tr>' . ' <td width="30%">' . MODULE_PAYMENT_STRIPE_CREDITCARD_OWNER . '</td>' . ' <td><input type="text" data-stripe="name" value="' . tep_output_string($order->billing['firstname'] . ' ' . $order->billing['lastname']) . '" /></td>' . '</tr>' . '<tr>' . ' <td width="30%">' . MODULE_PAYMENT_STRIPE_CREDITCARD_NUMBER . '</td>' . ' <td><input type="text" maxlength="20" autocomplete="off" data-stripe="number" /></td>' . '</tr>' . '<tr>' . ' <td width="30%">' . MODULE_PAYMENT_STRIPE_CREDITCARD_EXPIRY . '</td>' . ' <td>' . $months_string . ' / ' . $years_string . '</td>' . '</tr>';
if (MODULE_PAYMENT_STRIPE_VERIFY_WITH_CVC == 'True') {
$content .= '<tr>' . ' <td width="30%">' . MODULE_PAYMENT_STRIPE_CREDITCARD_CVC . '</td>' . ' <td><input type="text" size="5" maxlength="4" autocomplete="off" data-stripe="cvc" /></td>' . '</tr>';
}
if (MODULE_PAYMENT_STRIPE_TOKENS == 'True') {
$content .= '<tr>' . ' <td width="30%"> </td>' . ' <td>' . tep_draw_checkbox_field('cc_save', 'true') . ' ' . MODULE_PAYMENT_STRIPE_CREDITCARD_SAVE . '</td>' . '</tr>';
}
$content .= '</table>';
$address = array('address_line1' => $order->billing['street_address'], 'address_city' => $order->billing['city'], 'address_zip' => $order->billing['postcode'], 'address_state' => tep_get_zone_name($order->billing['country_id'], $order->billing['zone_id'], $order->billing['state']), 'address_country' => $order->billing['country']['iso_code_2']);
foreach ($address as $k => $v) {
$content .= '<input type="hidden" data-stripe="' . tep_output_string($k) . '" value="' . tep_output_string($v) . '" />';
}
if (!$this->templateClassExists()) {
$content .= $this->getSubmitCardDetailsJavascript();
}
$confirmation = array('title' => $content);
return $confirmation;
}
示例9: tep_get_zone_name
}
?>
</td>
</tr>
<?php
if (ACCOUNT_STATE == 'true') {
?>
<tr>
<td class="main" width="150"><?php
echo ENTRY_STATE;
?>
</td>
<td class="main">
<?php
// +Country-State Selector
$entry_state = tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state);
$zones_array = array();
$zones_query = tep_db_query("select zone_name, zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int) $cInfo->entry_country_id . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']);
}
if (count($zones_array) > 0) {
echo tep_draw_pull_down_menu('entry_zone_id', $zones_array, $cInfo->entry_zone_id);
echo tep_draw_hidden_field('entry_state', '');
} else {
echo tep_draw_input_field('entry_state', $entry_state);
}
// -Country-State Selector
?>
</td>
</tr>
示例10: array
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_array[] = array('id' => '', 'text' => '');
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($a_country) . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_hidden_field('a_zone_id') . tep_draw_pull_down_menu('a_state', $zones_array) . ' ' . '<span class=\'errorText\'>' . ENTRY_STATE_ERROR . '</span>';
} else {
echo tep_draw_hidden_field('a_zone_id') . tep_draw_input_field('a_state') . ' ' . '<span class=\'errorText\'>' . ENTRY_STATE_ERROR . '</span>';
}
} else {
echo $state . tep_draw_hidden_field('a_zone_id') . tep_draw_hidden_field('a_state');
}
} else {
echo tep_draw_hidden_field('a_zone_id') . tep_draw_input_field('a_state', tep_get_zone_name(isset($affiliate['affiliate_country_id']) ? $affiliate['affiliate_country_id'] : 0, isset($affiliate['affiliate_zone_id']) ? $affiliate['affiliate_zone_id'] : 0, isset($affiliate['affiliate_state']) ? $affiliate['affiliate_state'] : '')) . ' ' . ENTRY_STATE_TEXT;
}
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main"> <?php
echo ENTRY_POST_CODE;
?>
</td>
<td class="main">
<?php
if ($is_read_only == true) {
示例11: array
if ($entry_state_error == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$Qzones = $OSCOM_Db->get('zones', 'zone_name', ['zone_country_id' => $cInfo->entry_country_id], 'zone_name');
while ($Qzones->fetch()) {
$zones_array[] = ['id' => $Qzones->value('zone_name'), 'text' => $Qzones->value('zone_name')];
}
echo HTML::selectField('entry_state', $zones_array) . ' ' . OSCOM::getDef('entry_state_error', ['min_length' => ENTRY_STATE_MIN_LENGTH]);
} else {
echo HTML::inputField('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)) . ' ' . OSCOM::getDef('entry_state_error', ['min_length' => ENTRY_STATE_MIN_LENGTH]);
}
} else {
echo tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state) . HTML::hiddenField('entry_zone_id') . HTML::hiddenField('entry_state');
}
} else {
echo HTML::inputField('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state));
}
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main"><?php
echo OSCOM::getDef('entry_country');
?>
</td>
<td class="main">
<?php
if ($error == true) {
示例12: tep_db_prepare_input
$ship_country = tep_db_prepare_input($_POST['ship_country']);
// $ship_zone_id = get_zone($ship_country, $ship_state);
$ship_zone_id = tep_db_prepare_input($_POST['ship_state']);
//$ship_zone_id = tep_db_prepare_input($_POST['ship_state']);
$ship_state = tep_get_zone_name($ship_country, $ship_zone_id, '');
if (!isset($cc_expires) && isset($cc_expires_month) && isset($cc_expires_year)) {
$cc_expires = "{$cc_expires_month}{$cc_expires_year}";
}
if ($_POST['bill_same'] != '1') {
$bill_street_address = tep_db_prepare_input($_POST['bill_street_address']);
$bill_suburb = tep_db_prepare_input($_POST['bill_suburb']);
$bill_postcode = tep_db_prepare_input($_POST['bill_postcode']);
$bill_city = tep_db_prepare_input($_POST['bill_city']);
$bill_country = tep_db_prepare_input($_POST['bill_country']);
$bill_zone_id = tep_db_prepare_input($_POST['bill_state']);
$bill_state = tep_get_zone_name($bill_country, $bill_zone_id, '');
} else {
$bill_street_address = $ship_street_address;
$bill_suburb = $ship_suburb;
$bill_postcode = $ship_postcode;
$bill_city = $ship_city;
$bill_state = $ship_state;
$bill_country = $ship_country;
$bill_zone_id = $ship_zone_id;
}
$telephone = tep_db_prepare_input($_POST['telephone']);
$company = tep_db_prepare_input($_POST['company']);
if (isset($_POST['newsletter'])) {
$newsletter = tep_db_prepare_input($_POST['newsletter']);
} else {
$newsletter = false;
示例13: tep_get_zone_name
<tr>
<td class="main" width="200"><?php
echo ENTRY_STATE;
?>
</td>
<td class="main">
<?php
$entry_state = tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state);
if ($error == true) {
if ($entry_state_error == true) {
echo tep_draw_input_field('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)) . ' ' . ENTRY_STATE_ERROR;
} else {
echo $entry_state . tep_draw_hidden_field('entry_zone_id') . tep_draw_hidden_field('entry_state');
}
} else {
echo tep_draw_input_field('entry_state', tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state), '', ENTRY_STATE_MIN_LENGTH == 'true' ? true : false);
}
?>
</td>
</tr>
<?php
}
if (ACCOUNT_POSTCODE == 'true') {
?>
<tr>
<td class="main" width="200"><?php
echo ENTRY_POST_CODE;
?>
</td>
<td class="main">
<?php
示例14: array
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$Qzones = $OSCOM_Db->prepare('select zone_name from :table_zones where zone_country_id = :zone_country_id order by zone_name');
$Qzones->bindInt(':zone_country_id', $country);
$Qzones->execute();
while ($Qzones->fetch()) {
$zones_array[] = array('id' => $Qzones->value('zone_name'), 'text' => $Qzones->value('zone_name'));
}
echo HTML::selectField('state', $zones_array);
} else {
echo HTML::inputField('state');
}
} else {
echo HTML::inputField('state', isset($entry['entry_country_id']) ? tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']) : '');
}
if (tep_not_null(ENTRY_STATE_TEXT)) {
echo '<span class="help-block">' . ENTRY_STATE_TEXT . '</span>';
}
?>
</div>
</div>
<?php
}
?>
<div class="form-group has-feedback">
<label for="inputCountry" class="control-label col-sm-3"><?php
echo ENTRY_COUNTRY;
示例15: tep_db_query
if (isset($_POST['billing_same_as_customer'])) {
$_SESSION['billing_same_as_customer'] = $_POST['billing_same_as_customer'];
}
if (isset($_POST['shipping_same_as_billing'])) {
$_SESSION['shipping_same_as_billing'] = $_POST['shipping_same_as_billing'];
}
// Update Order Info
//figure out the new currency value
$currency_value_query = tep_db_query("SELECT value \n FROM " . TABLE_CURRENCIES . " \n WHERE code = '" . $_POST['update_info_payment_currency'] . "'");
$currency_value = tep_db_fetch_array($currency_value_query);
//figure out the country, state
$update_customer_state = tep_get_zone_name($_POST['update_customer_country_id'], $_POST['update_customer_zone_id'], $_POST['update_customer_state']);
$update_customer_country = tep_get_country_name($_POST['update_customer_country_id']);
$update_billing_state = tep_get_zone_name($_POST['update_billing_country_id'], $_POST['update_billing_zone_id'], $_POST['update_billing_state']);
$update_billing_country = tep_get_country_name($_POST['update_billing_country_id']);
$update_delivery_state = tep_get_zone_name($_POST['update_delivery_country_id'], $_POST['update_delivery_zone_id'], $_POST['update_delivery_state']);
$update_delivery_country = tep_get_country_name($_POST['update_delivery_country_id']);
$sql_data_array = array('customers_name' => tep_db_input(tep_db_prepare_input($_POST['update_customer_name'])), 'customers_company' => tep_db_input(tep_db_prepare_input($_POST['update_customer_company'])), 'customers_street_address' => tep_db_input(tep_db_prepare_input($_POST['update_customer_street_address'])), 'customers_suburb' => tep_db_input(tep_db_prepare_input($_POST['update_customer_suburb'])), 'customers_city' => tep_db_input(tep_db_prepare_input($_POST['update_customer_city'])), 'customers_state' => tep_db_input(tep_db_prepare_input($update_customer_state)), 'customers_postcode' => tep_db_input(tep_db_prepare_input($_POST['update_customer_postcode'])), 'customers_country' => tep_db_input(tep_db_prepare_input($update_customer_country)), 'customers_telephone' => tep_db_input(tep_db_prepare_input($_POST['update_customer_telephone'])), 'customers_email_address' => tep_db_input(tep_db_prepare_input($_POST['update_customer_email_address'])), 'billing_name' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_name'] : $_POST['update_billing_name'])), 'billing_company' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_company'] : $_POST['update_billing_company'])), 'billing_street_address' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_street_address'] : $_POST['update_billing_street_address'])), 'billing_suburb' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_suburb'] : $_POST['update_billing_suburb'])), 'billing_city' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_city'] : $_POST['update_billing_city'])), 'billing_state' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $update_customer_state : $update_billing_state)), 'billing_postcode' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_postcode'] : $_POST['update_billing_postcode'])), 'billing_country' => tep_db_input(tep_db_prepare_input(isset($_POST['billing_same_as_customer']) && $_POST['billing_same_as_customer'] == 'on' ? $update_customer_country : $update_billing_country)), 'delivery_name' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_name'] : $_POST['update_billing_name'] : $_POST['update_delivery_name'])), 'delivery_company' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_company'] : $_POST['update_billing_company'] : $_POST['update_delivery_company'])), 'delivery_street_address' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_street_address'] : $_POST['update_billing_street_address'] : $_POST['update_delivery_street_address'])), 'delivery_suburb' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_suburb'] : $_POST['update_billing_suburb'] : $_POST['update_delivery_suburb'])), 'delivery_city' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_city'] : $_POST['update_billing_city'] : $_POST['update_delivery_city'])), 'delivery_state' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $update_customer_state : $update_billing_state : $update_delivery_state)), 'delivery_postcode' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $_POST['update_customer_postcode'] : $_POST['update_billing_postcode'] : $_POST['update_delivery_postcode'])), 'delivery_country' => tep_db_input(tep_db_prepare_input(isset($_POST['shipping_same_as_billing']) && $_POST['shipping_same_as_billing'] == 'on' ? $_POST['billing_same_as_customer'] == 'on' ? $update_customer_country : $update_billing_country : $update_delivery_country)), 'payment_method' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_method'])), 'currency' => tep_db_input(tep_db_prepare_input($_POST['update_info_payment_currency'])), 'currency_value' => tep_db_input(tep_db_prepare_input($currency_value['value'])), 'cc_type' => tep_db_prepare_input($_POST['update_info_cc_type']), 'cc_owner' => tep_db_prepare_input($_POST['update_info_cc_owner']), 'cc_number' => tep_db_input(tep_db_prepare_input($_POST['update_info_cc_number'])), 'cc_expires' => tep_db_prepare_input($_POST['update_info_cc_expires']), 'last_modified' => 'now()');
tep_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = \'' . tep_db_input($oID) . '\'');
$order_updated = true;
// UPDATE STATUS HISTORY & SEND EMAIL TO CUSTOMER IF NECESSARY #####
$check_status_query = tep_db_query(" SELECT customers_name, customers_email_address, orders_status, date_purchased FROM " . TABLE_ORDERS . " WHERE orders_id = '" . (int) $oID . "'");
$check_status = tep_db_fetch_array($check_status_query);
if ($check_status['orders_status'] != $_POST['status'] || tep_not_null($_POST['comments'])) {
tep_db_query("UPDATE " . TABLE_ORDERS . " SET \n orders_status = '" . tep_db_input($_POST['status']) . "', \n last_modified = now() \n WHERE orders_id = '" . (int) $oID . "'");
// Notify Customer ?
$customer_notified = '0';
if (isset($_POST['notify']) && $_POST['notify'] == 'on') {
$notify_comments = '';
if (isset($_POST['notify_comments']) && $_POST['notify_comments'] == 'on') {
$notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $_POST['comments']) . "\n\n";