https://bugzilla.wikimedia.org/show_bug.cgi?id=58792
Web browser: --- Bug ID: 58792 Summary: Provide toolserver.language table Product: Wikimedia Labs Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: Unprioritized Component: tools Assignee: m...@uberbox.org Reporter: valhall...@arctus.nl CC: benap...@gmail.com, t...@tim-landscheidt.de Classification: Unclassified Mobile Platform: --- The toolserver provides the following table: mysql> describe language; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | lang | varchar(16) | NO | PRI | NULL | | | english_name | varchar(255) | YES | | NULL | | | native_name | varchar(255) | YES | | NULL | | +--------------+--------------+------+-----+---------+-------+ mysql> select * from language order by rand() limit 10; +------+--------------+------------------+ | lang | english_name | native_name | +------+--------------+------------------+ | cjp | Cabécar | NULL | | kks | Giiwo | NULL | | mqc | Mangole | NULL | | gby | Gbari | NULL | | kw | Cornish | Kernewek | | na | Nauruan | Ekakairũ Naoero | | ymd | Muda | NULL | | npa | Nar Phu | NULL | | waa | Walla Walla | NULL | | hss | Harsusi | NULL | +------+--------------+------------------+ 10 rows in set (0.00 sec) This could also be integrated with meta_p.wiki, by providing a 'language' and 'native_language' column. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l