$county->code = trim($data[0]);
$county->var_name = $county->mod_write_check(trim($data[1]));
$county->name = trim($data[1]);
$county->statecode = trim($data[2]);
$save = $county->save();
}
fclose($file);
$message = "<div class='success'>County codes loaded from " . $filename . " </div>";
$session->message($message);
redirect_to($_SERVER['PHP_SELF']);
}
//delete all the countys from list
if (isset($_POST['deletecounty'])) {
global $db, $database;
$county = new County();
$county->delete_by_country($countrycode);
/* We should remove the county definition from counties, cities and zips tables also for this country */
//$db->query("update ".TBL_COUNTIES." set statecode='' where countrycode='$countrycode' ");
$db->query("update " . TBL_CITY . " set countycode='' where countrycode='{$countrycode}' ");
$message = "<div class='success'>County codes for #COUNTRY# are deleted </div>";
$message = str_replace('#COUNTRY#', $countrycode, $message);
/* Analyze the table to adjust index values */
//$db->optimize_table( TBL_COUNTRY );
$db->optimize_table(TBL_STATES);
$db->optimize_table(TBL_COUNTIES);
$db->optimize_table(TBL_CITY);
$session->message($message);
redirect_to($_SERVER['PHP_SELF']);
}
//get the states files
$files = array();
