Adam Howard
Well-known member
If this is in the wrong forum, please forgive me.
The summery of that code is
UPDATE xf_user_field SET field_choices = X multiple choices WHERE field_id = 'country'
It was imputed in manually. And I'm having a small "brain fart" on how to undo that.
I don't think it would be as easy as dropping that table from within phpMyAdmin (or would be) ?
PHP:
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'
The summery of that code is
UPDATE xf_user_field SET field_choices = X multiple choices WHERE field_id = 'country'
It was imputed in manually. And I'm having a small "brain fart" on how to undo that.
I don't think it would be as easy as dropping that table from within phpMyAdmin (or would be) ?