<?php
	set_time_limit(0);
	$db = dbase_open('G:\BASE\STREET.DBF', 0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("kladr1", $con);
	$region = "01";
	$query = "";
	$n = 0;
	for($i = 220000; $i <= 219999 + dbase_numrecords($db); $i++){
		$n++;
		$data = dbase_get_record($db, $n);
		for($j = 0; $j <= 7; $j++){
			$data[$j] = trim(iconv("cp866", "windows-1251", $data[$j]));
		}
		$code = $data[2];
		if($code[0].$code[1] != $region){
			$f = fopen("kladr".$region.".csv", "w");
			fwrite($f, $query);
			fclose($f);
			mysql_query("LOAD DATA INFILE 'C:/www/scripts/kladr".$region.".csv' INTO TABLE kladr".$region." FIELDS TERMINATED BY ',';", $con);
			$query = "";
			$region = $code[0].$code[1];
		}
		if($code[15].$code[16] != "00")
			continue;
		$flag = 0;
		$parentcode = "";
		for($j = 0; $j < 11; $j++){
			$parentcode .= $code[$j];
		}
		$parentcode .= "00";
		$query .= "{$i},{$data[2]},{$parentcode},{$data[1]},{$data[0]},{$data[3]},{$data[6]},{$data[7]},5,0,0\n";
	}
	
	$f = fopen("kladr89.csv", "w");
	fwrite($f, $query);
	fclose($f);

	mysql_query("LOAD DATA INFILE 'C:/www/scripts/kladr89.csv' INTO TABLE kladr89 FIELDS TERMINATED BY ',';", $con);
	dbase_close($db);
?>