From fda330005eaecf52a385e6b96928bc818f54334e Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Jakub=20Klinkovsk=C3=BD?= Date: Sat, 25 Jul 2015 22:50:30 +0200 Subject: Improve interwiki entries for Wikimedia Foundation projects The entries have been separated into other block in the SQL script for readability, this does not matter with respect to the database. Old entries were removed or replaced with the new site's URL and more meaningful prefix. There are also couple of convenient aliases for the most frequently used entries. --- maintenance/arch-interwiki.sql | 30 +++++++++++++++++++----------- 1 file changed, 19 insertions(+), 11 deletions(-) diff --git a/maintenance/arch-interwiki.sql b/maintenance/arch-interwiki.sql index 4ada5f82..2c5618bd 100644 --- a/maintenance/arch-interwiki.sql +++ b/maintenance/arch-interwiki.sql @@ -6,7 +6,6 @@ DELETE FROM /*$wgDBprefix*/interwiki; INSERT INTO /*$wgDBprefix*/interwiki (iw_prefix,iw_url,iw_local,iw_api) VALUES ('arxiv','http://www.arxiv.org/abs/$1',0,''), -('commons','https://commons.wikimedia.org/wiki/$1',0,'https://commons.wikimedia.org/w/api.php'), ('doi','http://dx.doi.org/$1',0,''), ('emacswiki','http://www.emacswiki.org/cgi-bin/wiki.pl?$1',0,''), ('foldoc','http://foldoc.org/?$1',0,''), @@ -14,23 +13,32 @@ INSERT INTO /*$wgDBprefix*/interwiki (iw_prefix,iw_url,iw_local,iw_api) VALUES ('gentoo','https://wiki.gentoo.org/wiki/$1',0,'https://wiki.gentoo.org/api.php'), ('linuxwiki','http://linuxwiki.de/$1',0,''), ('lqwiki','http://wiki.linuxquestions.org/wiki/$1',0,''), -('mediawikiwiki','https://www.mediawiki.org/wiki/$1',0,'https://www.mediawiki.org/w/api.php'), -('mediazilla','https://bugzilla.wikimedia.org/$1',0,''), -('metawikimedia','https://meta.wikimedia.org/wiki/$1',0,'https://meta.wikimedia.org/w/api.php'), ('mozillawiki','http://wiki.mozilla.org/$1',0,'https://wiki.mozilla.org/api.php'), -('mw','https://www.mediawiki.org/wiki/$1',0,'https://www.mediawiki.org/w/api.php'), ('rfc','http://www.rfc-editor.org/rfc/rfc$1.txt',0,''), ('sourceforge','http://sourceforge.net/$1',0,''), -('wikia','http://www.wikia.com/wiki/$1',0,''), -('wikibooks','https://en.wikibooks.org/wiki/$1',0,'https://en.wikibooks.org/w/api.php'), -('wikimedia','https://wikimediafoundation.org/wiki/$1',0,'https://wikimediafoundation.org/w/api.php'), -('wikinews','https://en.wikinews.org/wiki/$1',0,'https://en.wikinews.org/w/api.php'), +('wikia','http://www.wikia.com/wiki/$1',0,'') +; + +-- Wikimedia Foundation projects and related +-- based on this table: https://meta.wikimedia.org/wiki/Help:Interwiki_linking#Project_titles_and_shortcuts +INSERT INTO /*$wgDBprefix*/interwiki (iw_prefix,iw_url,iw_local,iw_api) VALUES ('wikipedia','https://en.wikipedia.org/wiki/$1',0,'https://en.wikipedia.org/w/api.php'), +('w','https://en.wikipedia.org/wiki/$1',0,'https://en.wikipedia.org/w/api.php'), +('wiktionary','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php'), +('wikt','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php'), +('wikinews','https://en.wikinews.org/wiki/$1',0,'https://en.wikinews.org/w/api.php'), +('wikibooks','https://en.wikibooks.org/wiki/$1',0,'https://en.wikibooks.org/w/api.php'), ('wikiquote','https://en.wikiquote.org/wiki/$1',0,'https://en.wikiquote.org/w/api.php'), ('wikisource','https://wikisource.org/wiki/$1',0,'https://wikisource.org/w/api.php'), ('wikispecies','https://species.wikimedia.org/wiki/$1',0,'https://species.wikimedia.org/w/api.php'), ('wikiversity','https://en.wikiversity.org/wiki/$1',0,'https://en.wikiversity.org/w/api.php'), ('wikivoyage','https://en.wikivoyage.org/wiki/$1',0,'https://en.wikivoyage.org/w/api.php'), -('wikt','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php'), -('wiktionary','https://en.wiktionary.org/wiki/$1',0,'https://en.wiktionary.org/w/api.php') +('wikimedia','https://wikimediafoundation.org/wiki/$1',0,'https://wikimediafoundation.org/w/api.php'), +('wmf','https://wikimediafoundation.org/wiki/$1',0,'https://wikimediafoundation.org/w/api.php'), +('commons','https://commons.wikimedia.org/wiki/$1',0,'https://commons.wikimedia.org/w/api.php'), +('metawikimedia','https://meta.wikimedia.org/wiki/$1',0,'https://meta.wikimedia.org/w/api.php'), +('meta','https://meta.wikimedia.org/wiki/$1',0,'https://meta.wikimedia.org/w/api.php'), +('mw','https://www.mediawiki.org/wiki/$1',0,'https://www.mediawiki.org/w/api.php'), +('phabricator','https://phabricator.wikimedia.org/$1',0,''), +('phab','https://phabricator.wikimedia.org/$1',0,'') ; -- cgit v1.2.3