<?php
	set_time_limit(0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("kladr1", $con);
	$f = fopen("Regions.csv", "r");
	$out = "";
	while(!feof($f)){
		$region = fgetcsv($f, 1000, ';');
		$query1 = mysql_query("SELECT * FROM kladr".$region[0].";");
		for($i = 1; $i <= mysql_num_rows($query1); $i++){
			$obj = mysql_fetch_object($query1);
			$data[$obj->parentcode]++;
		}
		$query1 = mysql_query("SELECT * FROM kladr".$region[0].";");
		for($i = 1; $i <= mysql_num_rows($query1); $i++){
			$obj = mysql_fetch_object($query1);
			if($data[$obj->code] == "")
				$data[$obj->code] = "0";
			$out .= "{$obj->row_id},{$obj->code},{$obj->parentcode},'{$obj->socr}','{$obj->name}',{$obj->postindex},{$obj->okato},{$obj->status},{$obj->level},0,{$data[$obj->code]}\n";
		}
		$fout = fopen("kladr".$region[0].".csv", "w");
		fwrite($fout, $out);
		fclose($fout);
		unset($data);
		$out = "";
	}
	fclose($f);
?>