/**
* import russian capital cities
*/
public static function importCapitalCity()
{
$arItems = array();
$arFilter = array("UF_COUNTRY.UF_TITLE" => "Россия", "UF_ACTIVE" => 1);
$arSelect = array("ID", "UF_TITLE");
$result = CityTable::getList(array('filter' => $arFilter, 'select' => $arSelect));
while ($arCity = $result->fetch()) {
$arItems[$arCity["UF_TITLE"]] = $arCity["ID"];
}
$file = $_SERVER["DOCUMENT_ROOT"] . "/local/modules/hawkart.megatv/data/capital_cities.txt";
$lines = file($file);
foreach ($lines as $line_num => $line) {
$pos = strripos($line, ".svg ");
if ($pos === false) {
$pos = strripos($line, ".png ");
}
if ($pos === false) {
$pos = strripos($line, ".jpg ");
}
$city = substr($line, $pos + 5);
$city = trim($city);
$pos = strripos($line, "Flag");
$region = substr($line, 0, $pos);
$region = trim($region);
if (intval($arItems[$city]["ID"]) == 0) {
$arFields = array("UF_TITLE" => $city, "UF_REGION" => $region, "UF_ACTIVE" => 1, "UF_COUNTRY_ID" => 15);
$result = CityTable::add($arFields);
if ($result->isSuccess()) {
$id = $result->getId();
$arItems[$city] = $id;
}
}
}
}
