Here is a list of abbreviations that do not match, and potentially need to be remapped:
Code:
dz => ag => ac
at => au => as => aq => ay
ad => an => nt
ai => av
aw => aa
az => aj
bs => bf => uv
bz => bh => ba => bk
mm => bm => bd => bg => bu
bi => by => bo => bl
bj => bn
bw => bc
vg => vi => vq
kh => cb
ky => cj
tp => tt => td => cd => cg => cf => ct
cl => ci => iv
km => cn => ch => sz => wz
cx => kt
cc => ck => cw
cr => cs
cz => ez
dk => da
dm => do => dr
sj => sv => es => sp
gu => gq => ek
ee => en
gf => fg
pf => fp
tf => fs
de => gm => ga => gb
ge => gg => gk
gd => gj
gn => gv
gw => pu
ht => ha
va => vt
hn => ho
il => is => ic
iq => iz
jp => ja
ki => kr => ks
kp => kn => sc => se => sw
kw => ku
lv => lg
lb => le
lr => li => ls => lt => lh
mc => mn => mg => ma => mo
mw => mi
ms => mh => rm
mq => mb
om => mu => mp => cq
yt => mf
na => wa
ng => ni => nu => ne => ng
pw => ps
py => pa => pm => sb => bp
pg => pp
ph => rp
pn => pc
pt => po
pr => rq
ru => rs
lc => st
sg => sn => sg
sk => lo
zm => za => sf
gs => sx
lk => ce
sd => su
sr => ns
tj => ti
tg => to => tn => ts
tc => tk => tl
tr => tu
tm => tx
ua => up
vu => nh
vn => vm
eh => wi
ye => ym
zw => zi
Kind of long, isn't it?
Option #1: A couple of volunteers could help me do the actual remap, which would be easy using Search&Replace program.
Pros: None. Cons: All script country databases known to me use the same abbr's as the current ones. All online country databases use the same abbr as cia.gov, or they use something completely different; It would be hard to update the database.
Option #2: Find a website that has acceptable information about countries and that uses matching abbreviations.
Pros: No works involved. Cons: CIA has the fullest list of countries, and perhaps the most valid ones.
Option #3: Simply insert the CIA data into the database.
Pros: No work required, is relatively simple in comparison with #1. Cons: A bit more storage space (negligible).
Code:
>> Any possible performance issues with this, does it add queries etc?
Yes, it does add queries. And yes, there are a couple of performance issues. I am currently working on their elimination.
>> Also, is this only visable to admin/mods, or everyone (or is this an option, I would guess it would be)?
That is up to you. You can configure the list usergroups who have access to the script.