function insert_coords($id_lang, $id_country, $x, $y)
{
if (!is_numeric($id_lang) || !is_numeric($id_country) || !is_numeric($x) || !is_numeric($y)) {
return "error";
}
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'location_coords` WHERE `id_country` = \'' . $id_country . '\';');
if (!Db::getInstance()->Execute('INSERT INTO `' . _DB_PREFIX_ . 'location_coords` (`x`, `y`, `id_country`) VALUES (\'' . (int) $x . '\', \'' . (int) $y . '\', \'' . (int) $id_country . '\');')) {
echo "error while inserting data<br />";
}
return show_countries($id_lang);
}
?>
" /><p></p>
<?php
echo fc_text('zip');
?>
<input name="zip" size="5" maxlength="15" value="<?php
echo $zip;
?>
" /><p></p>
<?php
echo fc_text('country');
?>
<select name="country" size="1">
<option value="">[select a country]</option>
<?php
print show_countries($zid, $lid, $country, $lang_iso);
?>
</select><p></p>
<?php
}
?>
<select name="szid" size="<?php
echo $zt;
?>
" onChange="submit(); return false;">
<?php
$fcsz->query("select subzid,subzsid,subzdescr from subzone " . "where subzid={$zid} and subzparent={$subzparent} order by subzseq");
while ($fcsz->next_record()) {
?>
<option value="<?php
echo $fcsz->f("subzsid");
}
?>
" />
</td><td class="contributecell" bgcolor="#FFFFFF">
<select name="billing_country" size="1">
<option value="">[ <?php
echo fc_text('selectctry');
?>
]</option>
<?php
if ($cc) {
$billiso = $fcc->f("custbnatl");
} else {
$billiso = '';
}
print show_countries($zid, $lid, $billiso, $lang_iso);
?>
</select>
</td></tr>
</table>
<table class="text" border="0" cellpadding="0">
<tr><td class="contributecell" bgcolor="#FFFFFF">
<?php
echo fc_text('dayphone') . fc_text('reqflag');
?>
<br />
<input type="text" name="billing_acode" size="3" maxsize="3"
value="<?php
if ($cc) {
echo $fcc->f("custbacode");
$fct->query("select\nshipid,shipcalc,shipdescr,shippercent,shipitem,shipitem2,shipsvccode " . "from ship where shipid={$curshipid}");
if ($fct->next_record()) {
$tmp = $fct->f("shipcalc");
$shipcalc = './' . $tmp;
if (empty($tmp) || !file_exists($shipcalc)) {
$shipcalc = "";
}
$fct->free_result();
} else {
$shipcalc = "";
}
if ($zflag1 & $flag_zonetclink) {
$smarty->assign('zonetclink', TRUE);
}
//if(empty($shipcalc)){
// echo fc_text('noshipcalc').'<br />';
//}
// END OF ESSENTIAL CART DISPLAY CODE FROM LINE 1 TO HERE
$smarty->assign_by_ref('salutations', $salutearray);
$billiso = !empty($cc) ? $fcc->f("custsnatl") : '';
$smarty->assign('billCountryOptions', show_countries($zid, $lid, $billiso, $lang_iso));
$shipiso = !empty($cc) ? $fcc->f("custsnatl") : '';
$smarty->assign('shipCountryOptions', show_countries($zid, $lid, $shipiso, $lang_iso));
$allowupdate = 0;
$fco->free_result();
$fcol->free_result();
//show CC if nonzero total
if (($ttotal || $mtotal) && $zflag1 & $flag_zonecc) {
$smarty->assign('displayCC', TRUE);
}
require_once BITCART_PKG_PATH . 'bitcart_footer_inc.php';
