<?php
	set_time_limit(0);
	$db = dbase_open('G:\BASE\KLADR.DBF', 0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("kladr1", $con);
	$n = 0;
	$query = "INSERT INTO kladr01 VALUES ";
	for($i = 1; $i <= 439; $i++){
		$data = dbase_get_record($db, $i);
		for($j = 0; $j <= 7; $j++){
			$data[$j] = iconv("cp866", "windows-1251", $data[$j]);
		}
		$code = $data[2];
		if($code[11].$code[12] != "00")
			continue;
		$flag = 0;
		if($code[8].$code[9].$code[10] == "000"){
			if($code[5].$code[6].$code[7] == "000"){
				if($code[2].$code[3].$code[4] == "000"){
					$query .= "INSERT INTO kladr".$code[0].$code[1]." SET code = '{$data[2]}', parentcode = '0000000000000', socr= '{$data[1]}', name = '{$data[0]}', postindex = '', ocato = '', status = '', level = 1;";
					$flag = 1;
				}
				if($flag == 0){
					$parentcode = "";
					for($j = 0; $j < 2; $j++){
						$parentcode .= $code[$j];
					}
					$parentcode .= "00000000000";
					$query .= "INSERT INTO kladr".$code[0].$code[1]." SET code = '{$data[2]}', parentcode = '{$parentcode}', socr= '{$data[1]}', name = '{$data[0]}', postindex = '', ocato = '', status = '', level = 2;";
					$flag = 1;
				}
			}
			if($flag == 0){
				$parentcode = "";
				for($j = 0; $j < 5; $j++){
					$parentcode .= $code[$j];
				}
				$parentcode .= "00000000";
				$query .= "INSERT INTO kladr".$code[0].$code[1]." SET code = '{$data[2]}', parentcode = '{$parentcode}', socr= '{$data[1]}', name = '{$data[0]}', postindex = '', ocato = '', status = '', level = 3;";
				$flag = 1;
			}
		}
		if($flag == 0){
			$parentcode = "";
			for($j = 0; $j < 8; $j++){
				$parentcode .= $code[$j];
			}
			$parentcode .= "00000";
			$query .= "INSERT INTO kladr".$code[0].$code[1]." SET code = '{$data[2]}', parentcode = '{$parentcode}', socr= '{$data[1]}', name = '{$data[0]}', postindex = '', ocato = '', status = '', level = 4;";
			$flag = 1;
		}
	}
	echo $query;
	mysql_query($query);
	dbase_close($db);
?>