On Fri, Oct 1, 2010 at 18:02, Dan McGee <[email protected]> wrote: > On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <[email protected]> wrote: >> On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <[email protected]> >> 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.
> 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. I guess the most popular will be UPDATE mirrors_mirror SET country = 'United Kindgom' WHERE country = 'Great Britain'; but my question is: since I don't see a dropdown list for selecting a country but have to enter it manually each time I add a new mirror will I have to rewrite the Country fileld for existing mirrors after each country name change? -- Roman Kyrylych (Роман Кирилич)
