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';