Welcome to Our Community

Registration on our forums are now open for some days! Feel free to sign up today.

Unmaintained - Country Flags 1.0

Easily add country flags to your users profile and messages with small SQL mod.

  1. XenForo Rocks
    This tutorial will help you add a "Country" field to your forum so your users can easily select their country of origin and have a flag show in their profile and messages.

    ** BACK UP YOUR SQL DATABASE NOW **

    Step 1: Download resource and upload the files to the root of your forum installation.

    Step 2: Login to your Admin CP and find the "Extra.css" template. Add the following code to the bottom of this template:

    HTML:
    /* START FLAGS */
    .flag{background:url(@imagePath/xenforo/flags/flags.png) no-repeat;height:11px;width:16px;}
    .flag.flag-ad{background-position:-16px 0;}
    .flag.flag-ae{background-position:-32px 0;}
    .flag.flag-af{background-position:-48px 0;}
    .flag.flag-ag{background-position:-64px 0;}
    .flag.flag-ai{background-position:-80px 0;}
    .flag.flag-al{background-position:-96px 0;}
    .flag.flag-am{background-position:-112px 0;}
    .flag.flag-an{background-position:-128px 0;}
    .flag.flag-ao{background-position:-144px 0;}
    .flag.flag-ar{background-position:-160px 0;}
    .flag.flag-as{background-position:-176px 0;}
    .flag.flag-at{background-position:-192px 0;}
    .flag.flag-au{background-position:-208px 0;}
    .flag.flag-aw{background-position:-224px 0;}
    .flag.flag-az{background-position:-240px 0;}
    .flag.flag-ba{background-position:0 -11px;}
    .flag.flag-bb{background-position:-16px -11px;}
    .flag.flag-bd{background-position:-32px -11px;}
    .flag.flag-be{background-position:-48px -11px;}
    .flag.flag-bf{background-position:-64px -11px;}
    .flag.flag-bg{background-position:-80px -11px;}
    .flag.flag-bh{background-position:-96px -11px;}
    .flag.flag-bi{background-position:-112px -11px;}
    .flag.flag-bj{background-position:-128px -11px;}
    .flag.flag-bm{background-position:-144px -11px;}
    .flag.flag-bn{background-position:-160px -11px;}
    .flag.flag-bo{background-position:-176px -11px;}
    .flag.flag-br{background-position:-192px -11px;}
    .flag.flag-bs{background-position:-208px -11px;}
    .flag.flag-bt{background-position:-224px -11px;}
    .flag.flag-bv{background-position:-240px -11px;}
    .flag.flag-bw{background-position:0 -22px;}
    .flag.flag-by{background-position:-16px -22px;}
    .flag.flag-bz{background-position:-32px -22px;}
    .flag.flag-ca{background-position:-48px -22px;}
    .flag.flag-catalonia{background-position:-64px -22px;}
    .flag.flag-cd{background-position:-80px -22px;}
    .flag.flag-cf{background-position:-96px -22px;}
    .flag.flag-cg{background-position:-112px -22px;}
    .flag.flag-ch{background-position:-128px -22px;}
    .flag.flag-ci{background-position:-144px -22px;}
    .flag.flag-ck{background-position:-160px -22px;}
    .flag.flag-cl{background-position:-176px -22px;}
    .flag.flag-cm{background-position:-192px -22px;}
    .flag.flag-cn{background-position:-208px -22px;}
    .flag.flag-co{background-position:-224px -22px;}
    .flag.flag-cr{background-position:-240px -22px;}
    .flag.flag-cu{background-position:0 -33px;}
    .flag.flag-cv{background-position:-16px -33px;}
    .flag.flag-cy{background-position:-32px -33px;}
    .flag.flag-cz{background-position:-48px -33px;}
    .flag.flag-de{background-position:-64px -33px;}
    .flag.flag-dj{background-position:-80px -33px;}
    .flag.flag-dk{background-position:-96px -33px;}
    .flag.flag-dm{background-position:-112px -33px;}
    .flag.flag-do{background-position:-128px -33px;}
    .flag.flag-dz{background-position:-144px -33px;}
    .flag.flag-ec{background-position:-160px -33px;}
    .flag.flag-ee{background-position:-176px -33px;}
    .flag.flag-eg{background-position:-192px -33px;}
    .flag.flag-eh{background-position:-208px -33px;}
    .flag.flag-england{background-position:-224px -33px;}
    .flag.flag-er{background-position:-240px -33px;}
    .flag.flag-es{background-position:0 -44px;}
    .flag.flag-et{background-position:-16px -44px;}
    .flag.flag-eu{background-position:-32px -44px;}
    .flag.flag-fi{background-position:-48px -44px;}
    .flag.flag-fj{background-position:-64px -44px;}
    .flag.flag-fk{background-position:-80px -44px;}
    .flag.flag-fm{background-position:-96px -44px;}
    .flag.flag-fo{background-position:-112px -44px;}
    .flag.flag-fr{background-position:-128px -44px;}
    .flag.flag-ga{background-position:-144px -44px;}
    .flag.flag-gb{background-position:-160px -44px;}
    .flag.flag-gd{background-position:-176px -44px;}
    .flag.flag-ge{background-position:-192px -44px;}
    .flag.flag-gf{background-position:-208px -44px;}
    .flag.flag-gh{background-position:-224px -44px;}
    .flag.flag-gi{background-position:-240px -44px;}
    .flag.flag-gl{background-position:0 -55px;}
    .flag.flag-gm{background-position:-16px -55px;}
    .flag.flag-gn{background-position:-32px -55px;}
    .flag.flag-gp{background-position:-48px -55px;}
    .flag.flag-gq{background-position:-64px -55px;}
    .flag.flag-gr{background-position:-80px -55px;}
    .flag.flag-gs{background-position:-96px -55px;}
    .flag.flag-gt{background-position:-112px -55px;}
    .flag.flag-gu{background-position:-128px -55px;}
    .flag.flag-gw{background-position:-144px -55px;}
    .flag.flag-gy{background-position:-160px -55px;}
    .flag.flag-hk{background-position:-176px -55px;}
    .flag.flag-hm{background-position:-192px -55px;}
    .flag.flag-hn{background-position:-208px -55px;}
    .flag.flag-hr{background-position:-224px -55px;}
    .flag.flag-ht{background-position:-240px -55px;}
    .flag.flag-hu{background-position:0 -66px;}
    .flag.flag-id{background-position:-16px -66px;}
    .flag.flag-ie{background-position:-32px -66px;}
    .flag.flag-il{background-position:-48px -66px;}
    .flag.flag-in{background-position:-64px -66px;}
    .flag.flag-io{background-position:-80px -66px;}
    .flag.flag-iq{background-position:-96px -66px;}
    .flag.flag-ir{background-position:-112px -66px;}
    .flag.flag-is{background-position:-128px -66px;}
    .flag.flag-it{background-position:-144px -66px;}
    .flag.flag-jm{background-position:-160px -66px;}
    .flag.flag-jo{background-position:-176px -66px;}
    .flag.flag-jp{background-position:-192px -66px;}
    .flag.flag-ke{background-position:-208px -66px;}
    .flag.flag-kg{background-position:-224px -66px;}
    .flag.flag-kh{background-position:-240px -66px;}
    .flag.flag-ki{background-position:0 -77px;}
    .flag.flag-km{background-position:-16px -77px;}
    .flag.flag-kn{background-position:-32px -77px;}
    .flag.flag-kp{background-position:-48px -77px;}
    .flag.flag-kr{background-position:-64px -77px;}
    .flag.flag-kw{background-position:-80px -77px;}
    .flag.flag-ky{background-position:-96px -77px;}
    .flag.flag-kz{background-position:-112px -77px;}
    .flag.flag-la{background-position:-128px -77px;}
    .flag.flag-lb{background-position:-144px -77px;}
    .flag.flag-lc{background-position:-160px -77px;}
    .flag.flag-li{background-position:-176px -77px;}
    .flag.flag-lk{background-position:-192px -77px;}
    .flag.flag-lr{background-position:-208px -77px;}
    .flag.flag-ls{background-position:-224px -77px;}
    .flag.flag-lt{background-position:-240px -77px;}
    .flag.flag-lu{background-position:0 -88px;}
    .flag.flag-lv{background-position:-16px -88px;}
    .flag.flag-ly{background-position:-32px -88px;}
    .flag.flag-ma{background-position:-48px -88px;}
    .flag.flag-mc{background-position:-64px -88px;}
    .flag.flag-md{background-position:-80px -88px;}
    .flag.flag-me{background-position:-96px -88px;}
    .flag.flag-mg{background-position:-112px -88px;}
    .flag.flag-mh{background-position:-128px -88px;}
    .flag.flag-mk{background-position:-144px -88px;}
    .flag.flag-ml{background-position:-160px -88px;}
    .flag.flag-mm{background-position:-176px -88px;}
    .flag.flag-mn{background-position:-192px -88px;}
    .flag.flag-mo{background-position:-208px -88px;}
    .flag.flag-mp{background-position:-224px -88px;}
    .flag.flag-mq{background-position:-240px -88px;}
    .flag.flag-mr{background-position:0 -99px;}
    .flag.flag-ms{background-position:-16px -99px;}
    .flag.flag-mt{background-position:-32px -99px;}
    .flag.flag-mu{background-position:-48px -99px;}
    .flag.flag-mv{background-position:-64px -99px;}
    .flag.flag-mw{background-position:-80px -99px;}
    .flag.flag-mx{background-position:-96px -99px;}
    .flag.flag-my{background-position:-112px -99px;}
    .flag.flag-mz{background-position:-128px -99px;}
    .flag.flag-na{background-position:-144px -99px;}
    .flag.flag-nc{background-position:-160px -99px;}
    .flag.flag-ne{background-position:-176px -99px;}
    .flag.flag-nf{background-position:-192px -99px;}
    .flag.flag-ng{background-position:-208px -99px;}
    .flag.flag-ni{background-position:-224px -99px;}
    .flag.flag-nl{background-position:-240px -99px;}
    .flag.flag-no{background-position:0 -110px;}
    .flag.flag-np{background-position:-16px -110px;}
    .flag.flag-nr{background-position:-32px -110px;}
    .flag.flag-nu{background-position:-48px -110px;}
    .flag.flag-nz{background-position:-64px -110px;}
    .flag.flag-om{background-position:-80px -110px;}
    .flag.flag-pa{background-position:-96px -110px;}
    .flag.flag-pe{background-position:-112px -110px;}
    .flag.flag-pf{background-position:-128px -110px;}
    .flag.flag-pg{background-position:-144px -110px;}
    .flag.flag-ph{background-position:-160px -110px;}
    .flag.flag-pk{background-position:-176px -110px;}
    .flag.flag-pl{background-position:-192px -110px;}
    .flag.flag-pm{background-position:-208px -110px;}
    .flag.flag-pn{background-position:-224px -110px;}
    .flag.flag-pr{background-position:-240px -110px;}
    .flag.flag-ps{background-position:0 -121px;}
    .flag.flag-pt{background-position:-16px -121px;}
    .flag.flag-pw{background-position:-32px -121px;}
    .flag.flag-py{background-position:-48px -121px;}
    .flag.flag-qa{background-position:-64px -121px;}
    .flag.flag-re{background-position:-80px -121px;}
    .flag.flag-ro{background-position:-96px -121px;}
    .flag.flag-rs{background-position:-112px -121px;}
    .flag.flag-ru{background-position:-128px -121px;}
    .flag.flag-rw{background-position:-144px -121px;}
    .flag.flag-sa{background-position:-160px -121px;}
    .flag.flag-sb{background-position:-176px -121px;}
    .flag.flag-sc{background-position:-192px -121px;}
    .flag.flag-scotland{background-position:-208px -121px;}
    .flag.flag-sd{background-position:-224px -121px;}
    .flag.flag-se{background-position:-240px -121px;}
    .flag.flag-sg{background-position:0 -132px;}
    .flag.flag-sh{background-position:-16px -132px;}
    .flag.flag-si{background-position:-32px -132px;}
    .flag.flag-sk{background-position:-48px -132px;}
    .flag.flag-sl{background-position:-64px -132px;}
    .flag.flag-sm{background-position:-80px -132px;}
    .flag.flag-sn{background-position:-96px -132px;}
    .flag.flag-so{background-position:-112px -132px;}
    .flag.flag-sr{background-position:-128px -132px;}
    .flag.flag-ss{background-position:-144px -132px;}
    .flag.flag-st{background-position:-160px -132px;}
    .flag.flag-sv{background-position:-176px -132px;}
    .flag.flag-sy{background-position:-192px -132px;}
    .flag.flag-sz{background-position:-208px -132px;}
    .flag.flag-tc{background-position:-224px -132px;}
    .flag.flag-td{background-position:-240px -132px;}
    .flag.flag-tf{background-position:0 -143px;}
    .flag.flag-tg{background-position:-16px -143px;}
    .flag.flag-th{background-position:-32px -143px;}
    .flag.flag-tj{background-position:-48px -143px;}
    .flag.flag-tk{background-position:-64px -143px;}
    .flag.flag-tl{background-position:-80px -143px;}
    .flag.flag-tm{background-position:-96px -143px;}
    .flag.flag-tn{background-position:-112px -143px;}
    .flag.flag-to{background-position:-128px -143px;}
    .flag.flag-tr{background-position:-144px -143px;}
    .flag.flag-tt{background-position:-160px -143px;}
    .flag.flag-tv{background-position:-176px -143px;}
    .flag.flag-tw{background-position:-192px -143px;}
    .flag.flag-tz{background-position:-208px -143px;}
    .flag.flag-ua{background-position:-224px -143px;}
    .flag.flag-ug{background-position:-240px -143px;}
    .flag.flag-um{background-position:0 -154px;}
    .flag.flag-us{background-position:-16px -154px;}
    .flag.flag-uy{background-position:-32px -154px;}
    .flag.flag-uz{background-position:-48px -154px;}
    .flag.flag-va{background-position:-64px -154px;}
    .flag.flag-vc{background-position:-80px -154px;}
    .flag.flag-ve{background-position:-96px -154px;}
    .flag.flag-vg{background-position:-112px -154px;}
    .flag.flag-vi{background-position:-128px -154px;}
    .flag.flag-vn{background-position:-144px -154px;}
    .flag.flag-vu{background-position:-160px -154px;}
    .flag.flag-wales{background-position:-176px -154px;}
    .flag.flag-wf{background-position:-192px -154px;}
    .flag.flag-ws{background-position:-208px -154px;}
    .flag.flag-ye{background-position:-224px -154px;}
    .flag.flag-yt{background-position:-240px -154px;}
    .flag.flag-za{background-position:0 -165px;}
    .flag.flag-zm{background-position:-16px -165px;}
    .flag.flag-zw{background-position:-32px -165px;}
    Step 3: While still logged into the Admin CP, head to "Users" > "User Custom Fields" and "Create a New Field" with the following settings:
    • Field ID: country
      Do not change this to anything else!
    • Title: Country
    • Description: Whatever you want...
    • Field Type: Drop down selection
    • Option for Field Choices: Add a test field with a value of "test" and text of "Test".
    • General Options: Set the "Value Display HTML" to:
    HTML:
    <img src="/styles/default/xenforo/clear.png" class="flag flag-{$choice}" alt="{$value}" /> {$value}
    
    Step 4:Login to your Control Panel and access phpMyAdmin. Find your XenForo database and locate the table called "xf_user_field". Execute the following SQL code:
    HTML:
    UPDATE xf_user_field SET field_choices = 'a:236:{s:2:"af";s:11:"Afghanistan";s:2:"al";s:7:"Albania";s:2:"dz";s:7:"Algeria";s:2:"as";s:14:"American Samoa";s:2:"ad";s:7:"Andorra";s:2:"ao";s:6:"Angola";s:2:"ai";s:8:"Anguilla";s:2:"ag";s:19:"Antigua And Barbuda";s:2:"ar";s:9:"Argentina";s:2:"am";s:7:"Armenia";s:2:"aw";s:5:"Aruba";s:2:"au";s:9:"Australia";s:2:"at";s:7:"Austria";s:2:"az";s:10:"Azerbaijan";s:2:"bs";s:7:"Bahamas";s:2:"bh";s:7:"Bahrain";s:2:"bd";s:10:"Bangladesh";s:2:"bb";s:8:"Barbados";s:2:"by";s:7:"Belarus";s:2:"be";s:7:"Belgium";s:2:"bz";s:6:"Belize";s:2:"bj";s:5:"Benin";s:2:"bm";s:7:"Bermuda";s:2:"bt";s:6:"Bhutan";s:2:"bo";s:31:"Bolivia, Plurinational State Of";s:2:"ba";s:22:"Bosnia And Herzegovina";s:2:"bw";s:8:"Botswana";s:2:"bv";s:13:"Bouvet Island";s:2:"br";s:6:"Brazil";s:2:"io";s:30:"British Indian Ocean Territory";s:2:"bn";s:17:"Brunei Darussalam";s:2:"bg";s:8:"Bulgaria";s:2:"bf";s:12:"Burkina Faso";s:2:"bi";s:7:"Burundi";s:2:"kh";s:8:"Cambodia";s:2:"cm";s:8:"Cameroon";s:2:"ca";s:6:"Canada";s:2:"cv";s:10:"Cape Verde";s:2:"ky";s:14:"Cayman Islands";s:2:"cf";s:24:"Central African Republic";s:2:"td";s:4:"Chad";s:2:"cl";s:5:"Chile";s:2:"cn";s:5:"China";s:2:"co";s:8:"Colombia";s:2:"km";s:7:"Comoros";s:2:"cg";s:5:"Congo";s:2:"cd";s:37:"Congo, The Democratic Republic Of The";s:2:"ck";s:12:"Cook Islands";s:2:"cr";s:10:"Costa Rica";s:2:"ci";s:12:"Cote Divoire";s:2:"hr";s:7:"Croatia";s:2:"cu";s:4:"Cuba";s:2:"cy";s:6:"Cyprus";s:2:"cz";s:14:"Czech Republic";s:2:"dk";s:7:"Denmark";s:2:"dj";s:8:"Djibouti";s:2:"dm";s:8:"Dominica";s:2:"do";s:18:"Dominican Republic";s:2:"ec";s:7:"Ecuador";s:2:"eg";s:5:"Egypt";s:2:"sv";s:11:"El Salvador";s:2:"gq";s:17:"Equatorial Guinea";s:2:"er";s:7:"Eritrea";s:2:"ee";s:7:"Estonia";s:2:"et";s:8:"Ethiopia";s:2:"fk";s:27:"Falkland Islands (malvinas)";s:2:"fo";s:13:"Faroe Islands";s:2:"fj";s:4:"Fiji";s:2:"fi";s:7:"Finland";s:2:"fr";s:6:"France";s:2:"gf";s:13:"French Guiana";s:2:"pf";s:16:"French Polynesia";s:2:"tf";s:27:"French Southern Territories";s:2:"ga";s:5:"Gabon";s:2:"gm";s:6:"Gambia";s:2:"ge";s:7:"Georgia";s:2:"de";s:7:"Germany";s:2:"gh";s:5:"Ghana";s:2:"gi";s:9:"Gibraltar";s:2:"gr";s:6:"Greece";s:2:"gl";s:9:"Greenland";s:2:"gd";s:7:"Grenada";s:2:"gp";s:10:"Guadeloupe";s:2:"gu";s:4:"Guam";s:2:"gt";s:9:"Guatemala";s:2:"gn";s:6:"Guinea";s:2:"gw";s:13:"Guinea-bissau";s:2:"gy";s:6:"Guyana";s:2:"ht";s:5:"Haiti";s:2:"hm";s:33:"Heard Island And Mcdonald Islands";s:2:"va";s:29:"Holy See (vatican City State)";s:2:"hn";s:8:"Honduras";s:2:"hk";s:9:"Hong Kong";s:2:"hu";s:7:"Hungary";s:2:"is";s:7:"Iceland";s:2:"in";s:5:"India";s:2:"id";s:9:"Indonesia";s:2:"ir";s:25:"Iran, Islamic Republic Of";s:2:"iq";s:4:"Iraq";s:2:"ie";s:7:"Ireland";s:2:"il";s:6:"Israel";s:2:"it";s:5:"Italy";s:2:"jm";s:7:"Jamaica";s:2:"jp";s:5:"Japan";s:2:"jo";s:6:"Jordan";s:2:"kz";s:10:"Kazakhstan";s:2:"ke";s:5:"Kenya";s:2:"ki";s:8:"Kiribati";s:2:"kp";s:37:"Korea, Democratic Peoples Republic Of";s:2:"kr";s:18:"Korea, Republic Of";s:2:"kw";s:6:"Kuwait";s:2:"kg";s:10:"Kyrgyzstan";s:2:"la";s:31:"Lao Peoples Democratic Republic";s:2:"lv";s:6:"Latvia";s:2:"lb";s:7:"Lebanon";s:2:"ls";s:7:"Lesotho";s:2:"lr";s:7:"Liberia";s:2:"ly";s:22:"Libyan Arab Jamahiriya";s:2:"li";s:13:"Liechtenstein";s:2:"lt";s:9:"Lithuania";s:2:"lu";s:10:"Luxembourg";s:2:"mo";s:5:"Macao";s:2:"mk";s:42:"Macedonia, The Former Yugoslav Republic Of";s:2:"mg";s:10:"Madagascar";s:2:"mw";s:6:"Malawi";s:2:"my";s:8:"Malaysia";s:2:"mv";s:8:"Maldives";s:2:"ml";s:4:"Mali";s:2:"mt";s:5:"Malta";s:2:"mh";s:16:"Marshall Islands";s:2:"mq";s:10:"Martinique";s:2:"mr";s:10:"Mauritania";s:2:"mu";s:9:"Mauritius";s:2:"yt";s:7:"Mayotte";s:2:"mx";s:6:"Mexico";s:2:"fm";s:31:"Micronesia, Federated States Of";s:2:"md";s:20:"Moldova, Republic Of";s:2:"mc";s:6:"Monaco";s:2:"mn";s:8:"Mongolia";s:2:"me";s:10:"Montenegro";s:2:"ms";s:10:"Montserrat";s:2:"ma";s:7:"Morocco";s:2:"mz";s:10:"Mozambique";s:2:"mm";s:7:"Myanmar";s:2:"na";s:7:"Namibia";s:2:"nr";s:5:"Nauru";s:2:"np";s:5:"Nepal";s:2:"nl";s:11:"Netherlands";s:2:"nc";s:13:"New Caledonia";s:2:"nz";s:11:"New Zealand";s:2:"ni";s:9:"Nicaragua";s:2:"ne";s:5:"Niger";s:2:"ng";s:7:"Nigeria";s:2:"nu";s:4:"Niue";s:2:"nf";s:14:"Norfolk Island";s:2:"mp";s:24:"Northern Mariana Islands";s:2:"no";s:6:"Norway";s:2:"om";s:4:"Oman";s:2:"pk";s:8:"Pakistan";s:2:"pw";s:5:"Palau";s:2:"ps";s:31:"Palestinian Territory, Occupied";s:2:"pa";s:6:"Panama";s:2:"pg";s:16:"Papua New Guinea";s:2:"py";s:8:"Paraguay";s:2:"pe";s:4:"Peru";s:2:"ph";s:11:"Philippines";s:2:"pn";s:8:"Pitcairn";s:2:"pl";s:6:"Poland";s:2:"pt";s:8:"Portugal";s:2:"pr";s:11:"Puerto Rico";s:2:"qa";s:5:"Qatar";s:2:"re";s:7:"Reunion";s:2:"ro";s:7:"Romania";s:2:"ru";s:18:"Russian Federation";s:2:"rw";s:6:"Rwanda";s:2:"sh";s:44:"Saint Helena, Ascension And Tristan Da Cunha";s:2:"kn";s:21:"Saint Kitts And Nevis";s:2:"lc";s:11:"Saint Lucia";s:2:"pm";s:25:"Saint Pierre And Miquelon";s:2:"vc";s:32:"Saint Vincent And The Grenadines";s:2:"ws";s:5:"Samoa";s:2:"sm";s:10:"San Marino";s:2:"st";s:21:"Sao Tome And Principe";s:2:"sa";s:12:"Saudi Arabia";s:2:"sn";s:7:"Senegal";s:2:"rs";s:6:"Serbia";s:2:"sc";s:10:"Seychelles";s:2:"sl";s:12:"Sierra Leone";s:2:"sg";s:9:"Singapore";s:2:"sk";s:8:"Slovakia";s:2:"si";s:8:"Slovenia";s:2:"sb";s:15:"Solomon Islands";s:2:"so";s:7:"Somalia";s:2:"za";s:12:"South Africa";s:2:"gs";s:44:"South Georgia And The South Sandwich Islands";s:2:"ss";s:11:"South Sudan";s:2:"es";s:5:"Spain";s:2:"lk";s:9:"Sri Lanka";s:2:"sd";s:5:"Sudan";s:2:"sr";s:8:"Suriname";s:2:"sz";s:9:"Swaziland";s:2:"se";s:6:"Sweden";s:2:"ch";s:11:"Switzerland";s:2:"sy";s:20:"Syrian Arab Republic";s:2:"tw";s:25:"Taiwan, Province Of China";s:2:"tj";s:10:"Tajikistan";s:2:"tz";s:28:"Tanzania, United Republic Of";s:2:"th";s:8:"Thailand";s:2:"tl";s:11:"Timor-leste";s:2:"tg";s:4:"Togo";s:2:"tk";s:7:"Tokelau";s:2:"to";s:5:"Tonga";s:2:"tt";s:19:"Trinidad And Tobago";s:2:"tn";s:7:"Tunisia";s:2:"tr";s:6:"Turkey";s:2:"tm";s:12:"Turkmenistan";s:2:"tc";s:24:"Turks And Caicos Islands";s:2:"tv";s:6:"Tuvalu";s:2:"ug";s:6:"Uganda";s:2:"ua";s:7:"Ukraine";s:2:"ae";s:20:"United Arab Emirates";s:2:"gb";s:14:"United Kingdom";s:2:"us";s:13:"United States";s:2:"um";s:36:"United States Minor Outlying Islands";s:2:"uy";s:7:"Uruguay";s:2:"uz";s:10:"Uzbekistan";s:2:"vu";s:7:"Vanuatu";s:2:"ve";s:33:"Venezuela, Bolivarian Republic Of";s:2:"vn";s:8:"Viet Nam";s:2:"vg";s:23:"Virgin Islands, British";s:2:"vi";s:20:"Virgin Islands, U.S.";s:2:"wf";s:17:"Wallis And Futuna";s:2:"eh";s:14:"Western Sahara";s:2:"ye";s:5:"Yemen";s:2:"zm";s:6:"Zambia";s:2:"zw";s:8:"Zimbabwe";}' WHERE field_id = 'country'
    
    Step 5: Head back to your Admin CP and head to "Users" > "User Custom Fields" and edit the "Country" field. Save it one more time to ensure the changes have taken effect.

    Enjoy!

    The flag icons are the property of famfamfam.com and I did not create them. The sprite image was provided by flag-sprites.com.
    izibitzi, jon doe and Naveed Ahmed like this.