/** * 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; } } } }