On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <pierre@archlinux.de> wrote:
On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <dpmcgee@gmail.com> wrote:
Getting this tied to an actual country object could make GeoIP integration of some sort be useful later down the road.
That was my intention.
Haven't seen any progress on this. :)
Hmm, did you expect me to do something? I am quite busy atm; maybe I got some time at the week end.
I just expect other people to chip in when they have motivation to fix it, I can't do everything either. We can make this real easy: mysql> select distinct country from mirrors_mirror order by country; +----------------+ | country | +----------------+ | Any | | Australia | | Austria | | Belarus | | Belgium | | Brazil | | Bulgaria | | Canada | | Chile | | China | | Colombia | | Czech Republic | | Denmark | | Estonia | | Finland | | France | | Germany | | Great Britain | | Greece | | Hungary | | India | | Indonesia | | Ireland | | Israel | | Italy | | Japan | | Kazakhstan | | Latvia | | Lithuania | | Netherlands | | New Caledonia | | New Zealand | | Norway | | Poland | | Portugal | | Romania | | Russia | | Slovakia | | Spain | | Sweden | | Switzerland | | Taiwan | | Turkey | | Ukraine | | United States | | Vietnam | +----------------+ 46 rows in set (0.01 sec) If there is something in here that is wrong, let's just write some SQL to fix it up: UPDATE mirrors_mirror SET country = 'Best Country Ever!' WHERE country = 'Germany'; If you can put together mappings like this to get the names adjusted to whatever that ISO standard # was, we'll be in business. -Dan