View Single Post
  #8  
Old 01-04-2006, 10:55 PM
akanevsky akanevsky is offline
 
Join Date: Apr 2005
Posts: 3,972
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02749 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete