From b17a29ca705f07c294f5dc34396f59420f008d1b Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Fri, 18 Jan 2013 17:50:44 +0100 Subject: Get images for relations, too --- sources/wiki/get_image_info.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sources/wiki') diff --git a/sources/wiki/get_image_info.rb b/sources/wiki/get_image_info.rb index cabd169..caaf952 100755 --- a/sources/wiki/get_image_info.rb +++ b/sources/wiki/get_image_info.rb @@ -53,7 +53,7 @@ api = MediaWikiAPI::API.new('wiki.openstreetmap.org') db = SQLite3::Database.new(dir + '/taginfo-wiki.db') db.results_as_hash = true -image_titles = db.execute("SELECT DISTINCT(image) AS title FROM wikipages WHERE image IS NOT NULL AND image != ''"). +image_titles = db.execute("SELECT DISTINCT(image) AS title FROM wikipages WHERE image IS NOT NULL AND image != '' UNION SELECT DISTINCT(image) AS title FROM relation_pages WHERE image IS NOT NULL AND image != ''"). map{ |row| row['title'] }. select{ |title| title.match(%r{^(file|image):}i) } -- cgit v1.2.3