X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/279ea25e7debfeef06a0247d55499ee02b6b4de6..0862e21a1bdd7d88719c1062db2f25c073b32fc2:/utils/country_languages.php?ds=sidebyside diff --git a/utils/country_languages.php b/utils/country_languages.php old mode 100755 new mode 100644 index 7e200e5b..63f6525c --- a/utils/country_languages.php +++ b/utils/country_languages.php @@ -1,34 +1,31 @@ -#!/usr/bin/php -Cq $s) - { - $aLanguages[$i] = '"'.pg_escape_string($s).'"'; - } - echo "UPDATE country_name set country_default_language_codes = '{".join(',',$aLanguages)."}' where country_code = '".pg_escape_string($aMatch[1])."';\n"; - } - } - } +include(CONST_Phrase_Config); + +if (true) { + $sURL = 'https://wiki.openstreetmap.org/wiki/Special:Export/Nominatim/Country_Codes'; + $sWikiPageXML = file_get_contents($sURL); + if (preg_match_all('#\\| ([a-z]{2}) \\|\\| [^|]+\\|\\| ([a-z,]+)#', $sWikiPageXML, $aMatches, PREG_SET_ORDER)) { + foreach ($aMatches as $aMatch) { + $aLanguages = explode(',', $aMatch[2]); + foreach ($aLanguages as $i => $s) { + $aLanguages[$i] = '"'.pg_escape_string($s).'"'; + } + echo "UPDATE country_name set country_default_language_codes = '{".join(',', $aLanguages)."}' where country_code = '".pg_escape_string($aMatch[1])."';\n"; + } + } +}