Редактируем Города - Регионы- Страны в icms2

<?php
	set_time_limit(720);
 
	header ("Content-Type: text/html; charset=utf-8");
 
	mysql_connect('localhost', 'root', '');
	mysql_select_db('clear');
 
	$select_country = mysql_query("SELECT * FROM geo_countries ORDER BY name");
 
	while ($list_country = mysql_fetch_assoc($select_country)) {
 
		$i_country = $i_country + 1;
 
		mysql_query("UPDATE geo_countries SET id='$i_country' WHERE id='$list_country[id]'");
 
		echo "$list_country[id] > $i_country";
 
		$select_region = mysql_query("SELECT * FROM geo_regions WHERE country_id='$list_country[id]' ORDER BY country_id, name");
 
		while ($list_region = mysql_fetch_assoc($select_region)) {
 
			$i_region = $i_region + 1;
 
			mysql_query("UPDATE geo_regions SET country_id='$i_country' WHERE country_id='$list_region[country_id]'");
			mysql_query("UPDATE geo_regions SET id='$i_region' WHERE id='$list_region[id]'");
 
			echo "$list_country[id] - $list_region[id] > $i_country - $i_region";
 
 
			$select_city = mysql_query("SELECT * FROM geo_cities WHERE region_id='$list_region[id]' ORDER BY country_id, region_id, name");
 
			while ($list_city = mysql_fetch_assoc($select_city)) {
 
				$i_city = $i_city + 1;
 
				mysql_query("UPDATE geo_cities SET country_id='$i_country' WHERE country_id='$list_city[country_id]'");
				mysql_query("UPDATE geo_cities SET region_id='$i_region' WHERE region_id='$list_city[region_id]'");
				mysql_query("UPDATE geo_cities SET id='$i_city' WHERE id='$list_city[id]'");
 
				echo "$list_country[id] - $list_region[id] - $list_city[id] > $i_country - $i_region - $i_city";
			}
		}
	}
?>