From: Brian Quinion <openstreetmap@brian.quinion.co.uk>
Date: Mon, 3 Dec 2012 14:14:40 +0000 (+0000)
Subject: Merge branch 'master' of github.com:twain47/Nominatim
X-Git-Tag: v2.2.0~175
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/df7b81dc06bea97c926bf113d4dfe0f6e0669923?hp=69fb829dd034d6f61d5b80f950175f133983ab1e

Merge branch 'master' of github.com:twain47/Nominatim
---

diff --git a/utils/country_languages.php b/utils/country_languages.php
new file mode 100755
index 00000000..8360ae66
--- /dev/null
+++ b/utils/country_languages.php
@@ -0,0 +1,34 @@
+#!/usr/bin/php -Cq
+<?php
+
+        require_once(dirname(dirname(__FILE__)).'/lib/init-cmd.php');
+        ini_set('memory_limit', '800M');
+        ini_set('display_errors', 'stderr');
+
+        $aCMDOptions = array(
+                "Import country language data from osm wiki",
+                array('help', 'h', 0, 1, 0, 0, false, 'Show Help'),
+                array('quiet', 'q', 0, 1, 0, 0, 'bool', 'Quiet output'),
+                array('verbose', 'v', 0, 1, 0, 0, 'bool', 'Verbose output'),
+        );
+        getCmdOpt($_SERVER['argv'], $aCMDOptions, $aCMDResult, true, true);
+
+	include(CONST_BasePath.'/settings/phrase_settings.php');
+
+	if (true)
+	{
+		$sURL = 'http://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";
+			}
+		}
+	}