[arch-dev-public] Mirror country names (was: Mirror status page)
roman.kyrylych at gmail.com
Wed Oct 6 05:05:32 EDT 2010
On Fri, Oct 1, 2010 at 18:56, Dan McGee <dpmcgee at gmail.com> wrote:
> On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych
> <roman.kyrylych at gmail.com> wrote:
>> On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee at gmail.com> wrote:
>>> 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?
> Are you missing what this does? The SQL is to rewrite all existing
> mirrors using those country names, it has nothing to do with new ones.
That's exactly what my intention was.
I am missing your point.
Existing ones would just have to be entered correctly.
Or do you want to change the field in the admin GUI
from text input to selectbox?
Roman Kyrylych (Роман Кирилич)
More information about the arch-dev-public