}
}
$smarty->assign('country', $country_t);
}
//if load states button is press process the states
if (isset($_POST['loadstates'])) {
$state = new StateProvince();
$filename = $_POST['filename'];
$state->delete_by_country($countrycode);
$file = SITE_ROOT . "/states/" . $filename;
$file = fopen($file, "r");
while (($data = fgetcsv($file, 8000, ",")) !== FALSE) {
$state = new StateProvince();
$state->countrycode = $countrycode;
$state->code = trim($data[0]);
$state->var_name = $state->mod_write_check(trim($data[1]));
$state->name = trim($data[1]);
$save = $state->save();
}
fclose($file);
$message = "<div class='success'>State codes loaded from " . $filename . " </div>";
$session->message($message);
redirect_to($_SERVER['PHP_SELF']);
}
//delete all the states from list
if (isset($_POST['deletestates'])) {
global $db, $database;
$state = new StateProvince();
$state->delete_by_country($countrycode);
/* We should remove the state definition from counties, cities and zips tables also for this country */
$db->query("update " . TBL_COUNTIES . " set statecode='' where countrycode='{$countrycode}' ");
