On Friday, February 10, 2012, Raul Kern <raunator(a)gmail.com> wrote:
Hallo,
would like to add two new fileds to monuments_all table
(
http://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_2011/Monumen…
):
article varchar(255) NOT NULL DEFAULT ''
and
registrant_url varchar(255) NOT NULL DEFAULT ''
article would contain wiki article title (in most cases the article
about the monument) extracted from the name field -- first wikilink in
the name field
article would be formatted same as page_title in
http://www.mediawiki.org/wiki/Manual:Page_table -- i.e. spaces
replaced with '_'.
Article title on which wiki, and in which language? Marble Arch, Mramorový
oblouk (Londýn) or マーブル・アーチ? It's easy enough to say "the Wikipedia in the
language spoken there", but what would we do for Switzerland or Belgium,
and how would the software know? Let's not just assume enwiki imperialism.
:-) The name on Commons might be a sensible alternative, but I imagine that
lots of monuments don't (yet) have good links from their Commons pages if
they exist at all to Wikipedia/etc. useful articles on them...
J.
--
James D. Forrester
jdforrester(a)wikimedia.org | jdforrester(a)gmail.com
[[Wikipedia:User:Jdforrester|James F.]]