On one of my latest projects, upon signing up a user selects a country, for example “Australia”.
I have a neat set of flag icons… and I was wondering if there is some sort of script already made where if the country = Australia, it converts it to au…
Thanks 
If you know the country’s iso 3166 code, then have that the same as the flag file name.
I can post my table of country names with iso codes if you don’t have them.
Here it is as a SQL dump:
CREATE TABLE IF NOT EXISTS `country` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL,
`is_active` tinyint(1) default '0',
`iso_3166_a2` varchar(2) NOT NULL,
`iso_3166_a3` varchar(3) NOT NULL,
`iso_3166_num` varchar(3) NOT NULL,
`culture` varchar(10) NOT NULL default 'en',
`prefix_with_the` tinyint(1) NOT NULL default '0',
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name_index_idx` (`name`),
UNIQUE KEY `iso_3166_a2_index_idx` (`iso_3166_a2`),
KEY `is_active_index_idx` (`is_active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=237 ;
--
-- Dumping data for table `country`
--
INSERT INTO `country` (`id`, `name`, `is_active`, `iso_3166_a2`, `iso_3166_a3`, `iso_3166_num`, `culture`, `prefix_with_the`, `created_at`) VALUES
(1, 'Afghanistan', 0, 'AF', 'AFG', '4', 'en', 0, '2010-02-16 20:39:43'),
(2, 'Albania', 0, 'AL', 'ALB', '8', 'en', 0, '2010-02-16 20:39:43'),
(3, 'Algeria', 0, 'DZ', 'DZA', '12', 'en', 0, '2010-02-16 20:39:43'),
(4, 'American Samoa', 0, 'AS', 'ASM', '16', 'en', 0, '2010-02-16 20:39:43'),
(5, 'Andorra', 0, 'AD', 'AND', '20', 'en', 0, '2010-02-16 20:39:43'),
(6, 'Angola', 0, 'AO', 'AGO', '24', 'en', 0, '2010-02-16 20:39:43'),
(7, 'Anguilla', 0, 'AI', 'AIA', '660', 'en', 0, '2010-02-16 20:39:43'),
(8, 'Antarctica', 0, 'AQ', 'ATA', '10', 'en', 0, '2010-02-16 20:39:43'),
(9, 'Antigua and Barbuda', 0, 'AG', 'ATG', '28', 'en', 0, '2010-02-16 20:39:43'),
(10, 'Argentina', 0, 'AR', 'ARG', '32', 'en', 0, '2010-02-16 20:39:43'),
(11, 'Armenia', 0, 'AM', 'ARM', '51', 'en', 0, '2010-02-16 20:39:43'),
(12, 'Aruba', 0, 'AW', 'ABW', '533', 'en', 0, '2010-02-16 20:39:43'),
(13, 'Australia', 0, 'AU', 'AUS', '36', 'en', 0, '2010-02-16 20:39:43'),
(14, 'Austria', 0, 'AT', 'AUT', '40', 'en', 0, '2010-02-16 20:39:43'),
(15, 'Azerbaijan', 0, 'AZ', 'AZE', '31', 'en', 0, '2010-02-16 20:39:43'),
(16, 'Bahamas', 0, 'BS', 'BHS', '44', 'en', 0, '2010-02-16 20:39:43'),
(17, 'Bahrain', 0, 'BH', 'BHR', '48', 'en', 0, '2010-02-16 20:39:43'),
(18, 'Bangladesh', 0, 'BD', 'BGD', '50', 'en', 0, '2010-02-16 20:39:43'),
(19, 'Barbados', 0, 'BB', 'BRB', '52', 'en', 0, '2010-02-16 20:39:43'),
(20, 'Belarus', 0, 'BY', 'BLR', '112', 'en', 0, '2010-02-16 20:39:43'),
(21, 'Belgium', 0, 'BE', 'BEL', '56', 'en', 0, '2010-02-16 20:39:43'),
(22, 'Belize', 0, 'BZ', 'BLZ', '84', 'en', 0, '2010-02-16 20:39:43'),
(23, 'Benin', 0, 'BJ', 'BEN', '204', 'en', 0, '2010-02-16 20:39:43'),
(24, 'Bermuda', 0, 'BM', 'BMU', '60', 'en', 0, '2010-02-16 20:39:43'),
(25, 'Bhutan', 0, 'BT', 'BTN', '64', 'en', 0, '2010-02-16 20:39:43'),
(26, 'Bolivia', 0, 'BO', 'BOL', '68', 'en', 0, '2010-02-16 20:39:43'),
(27, 'Bosnia', 0, 'BA', 'BIH', '70', 'en', 0, '2010-02-16 20:39:43'),
(28, 'Botswana', 0, 'BW', 'BWA', '72', 'en', 0, '2010-02-16 20:39:43'),
(29, 'Bouvetoya', 0, 'BV', 'BVT', '74', 'en', 0, '2010-02-16 20:39:43'),
(30, 'Brazil', 0, 'BR', 'BRA', '76', 'en', 0, '2010-02-16 20:39:43'),
(31, 'British Indian Ocean', 0, 'IO', 'IOT', '86', 'en', 1, '2010-02-16 20:39:43'),
(32, 'British Virgin Islands', 0, 'VG', 'VGB', '92', 'en', 1, '2010-02-16 20:39:43'),
(33, 'Brunei', 0, 'BN', 'BRN', '96', 'en', 0, '2010-02-16 20:39:43'),
(34, 'Bulgaria', 0, 'BG', 'BGR', '100', 'en', 0, '2010-02-16 20:39:43'),
(35, 'Burkina Faso', 0, 'BF', 'BFA', '854', 'en', 0, '2010-02-16 20:39:43'),
(36, 'Burundi', 0, 'BI', 'BDI', '108', 'en', 0, '2010-02-16 20:39:43'),
(37, 'Cambodia', 0, 'KH', 'KHM', '116', 'en', 0, '2010-02-16 20:39:43'),
(38, 'Cameroon', 0, 'CM', 'CMR', '120', 'en', 0, '2010-02-16 20:39:43'),
(39, 'Canada', 1, 'CA', 'CAN', '124', 'en', 0, '2010-02-16 20:39:43'),
(40, 'Cape Verde', 0, 'CV', 'CPV', '132', 'en', 0, '2010-02-16 20:39:43'),
(41, 'Cayman Islands', 0, 'KY', 'CYM', '136', 'en', 1, '2010-02-16 20:39:43'),
(42, 'Central African Republic', 0, 'CF', 'CAF', '140', 'en', 1, '2010-02-16 20:39:43'),
(43, 'Chad', 0, 'TD', 'TCD', '148', 'en', 0, '2010-02-16 20:39:43'),
(44, 'Chile', 0, 'CL', 'CHL', '152', 'en', 0, '2010-02-16 20:39:43'),
(45, 'China', 0, 'CN', 'CHN', '156', 'en', 0, '2010-02-16 20:39:43'),
(46, 'Christmas Island', 0, 'CX', 'CXR', '162', 'en', 0, '2010-02-16 20:39:43'),
(47, 'Cocos Islands', 0, 'CC', 'CCK', '166', 'en', 0, '2010-02-16 20:39:43'),
(48, 'Colombia', 0, 'CO', 'COL', '170', 'en', 0, '2010-02-16 20:39:43'),
(49, 'Comoros', 0, 'KM', 'COM', '174', 'en', 0, '2010-02-16 20:39:43'),
(50, 'Democratic Republic of the Congo', 0, 'CD', 'COD', '180', 'en', 0, '2010-02-16 20:39:43'),
(51, 'Republic of the Congo', 0, 'CG', 'COG', '178', 'en', 0, '2010-02-16 20:39:43'),
(52, 'Cook Islands', 0, 'CK', 'COK', '184', 'en', 1, '2010-02-16 20:39:43'),
(53, 'Costa Rica', 0, 'CR', 'CRI', '188', 'en', 0, '2010-02-16 20:39:43'),
(54, 'Ivory Coast', 0, 'CI', 'CIV', '384', 'en', 0, '2010-02-16 20:39:43'),
(55, 'Cuba', 0, 'CU', 'CUB', '192', 'en', 0, '2010-02-16 20:39:43'),
(56, 'Cyprus', 0, 'CY', 'CYP', '196', 'en', 0, '2010-02-16 20:39:43'),
(57, 'Czech Republic', 0, 'CZ', 'CZE', '203', 'en', 0, '2010-02-16 20:39:43'),
(58, 'Denmark', 0, 'DK', 'DNK', '208', 'en', 0, '2010-02-16 20:39:43'),
(59, 'Djibouti', 0, 'DJ', 'DJI', '262', 'en', 0, '2010-02-16 20:39:43'),
(60, 'Dominica', 0, 'DM', 'DMA', '212', 'en', 0, '2010-02-16 20:39:43'),
(61, 'Dominican Republic', 0, 'DO', 'DOM', '214', 'en', 1, '2010-02-16 20:39:43'),
(62, 'Ecuador', 0, 'EC', 'ECU', '218', 'en', 0, '2010-02-16 20:39:43'),
(63, 'Egypt', 0, 'EG', 'EGY', '818', 'en', 0, '2010-02-16 20:39:43'),
(64, 'El Salvador', 0, 'SV', 'SLV', '222', 'en', 0, '2010-02-16 20:39:43'),
(65, 'Equatorial Guinea', 0, 'GQ', 'GNQ', '226', 'en', 0, '2010-02-16 20:39:43'),
(66, 'Eritrea', 0, 'ER', 'ERI', '232', 'en', 0, '2010-02-16 20:39:43'),
(67, 'Estonia', 0, 'EE', 'EST', '233', 'en', 0, '2010-02-16 20:39:43'),
(68, 'Ethiopia', 0, 'ET', 'ETH', '231', 'en', 0, '2010-02-16 20:39:43'),
(69, 'Faeroe Islands', 0, 'FO', 'FRO', '234', 'en', 1, '2010-02-16 20:39:43'),
(70, 'Falkland Islands', 0, 'FK', 'FLK', '238', 'en', 1, '2010-02-16 20:39:43'),
(71, 'Fiji', 0, 'FJ', 'FJI', '242', 'en', 0, '2010-02-16 20:39:43'),
(72, 'Finland', 0, 'FI', 'FIN', '246', 'en', 0, '2010-02-16 20:39:43'),
(73, 'France', 0, 'FR', 'FRA', '250', 'en', 0, '2010-02-16 20:39:43'),
(74, 'French Guiana', 0, 'GF', 'GUF', '254', 'en', 0, '2010-02-16 20:39:43'),
(75, 'French Polynesia', 0, 'PF', 'PYF', '258', 'en', 0, '2010-02-16 20:39:43'),
(76, 'French Southern Territories', 0, 'TF', 'ATF', '260', 'en', 0, '2010-02-16 20:39:43'),
(77, 'Gabon', 0, 'GA', 'GAB', '266', 'en', 0, '2010-02-16 20:39:43'),
(78, 'Gambia', 0, 'GM', 'GMB', '270', 'en', 0, '2010-02-16 20:39:43'),
(79, 'Georgia', 0, 'GE', 'GEO', '268', 'en', 0, '2010-02-16 20:39:43'),
(80, 'Germany', 0, 'DE', 'DEU', '276', 'en', 0, '2010-02-16 20:39:43'),
(81, 'Ghana', 0, 'GH', 'GHA', '288', 'en', 0, '2010-02-16 20:39:43'),
(82, 'Gibraltar', 0, 'GI', 'GIB', '292', 'en', 0, '2010-02-16 20:39:43'),
(83, 'Greece', 0, 'GR', 'GRC', '300', 'en', 0, '2010-02-16 20:39:43'),
(84, 'Greenland', 0, 'GL', 'GRL', '304', 'en', 0, '2010-02-16 20:39:43'),
(85, 'Grenada', 0, 'GD', 'GRD', '308', 'en', 0, '2010-02-16 20:39:43'),
(86, 'Guadaloupe', 0, 'GP', 'GLP', '312', 'en', 0, '2010-02-16 20:39:43'),
(87, 'Guam', 0, 'GU', 'GUM', '316', 'en', 0, '2010-02-16 20:39:43'),
(88, 'Guatemala', 0, 'GT', 'GTM', '320', 'en', 0, '2010-02-16 20:39:43'),
(89, 'Guinea', 0, 'GN', 'GIN', '324', 'en', 0, '2010-02-16 20:39:43'),
(90, 'Guinea-Bissau', 0, 'GW', 'GNB', '624', 'en', 0, '2010-02-16 20:39:43'),
(91, 'Guyana', 0, 'GY', 'GUY', '328', 'en', 0, '2010-02-16 20:39:43'),
(92, 'Haiti', 0, 'HT', 'HTI', '332', 'en', 0, '2010-02-16 20:39:43'),
(93, 'Heard and McDonald Islands', 0, 'HM', 'HMD', '334', 'en', 0, '2010-02-16 20:39:43'),
(94, 'Honduras', 0, 'HN', 'HND', '340', 'en', 0, '2010-02-16 20:39:43'),
(95, 'Hong Kong', 0, 'HK', 'HKG', '344', 'en', 0, '2010-02-16 20:39:43'),
(96, 'Croatia', 0, 'HR', 'HRV', '191', 'en', 0, '2010-02-16 20:39:43'),
(97, 'Hungary', 0, 'HU', 'HUN', '348', 'en', 0, '2010-02-16 20:39:43'),
(98, 'Iceland', 0, 'IS', 'ISL', '352', 'en', 0, '2010-02-16 20:39:43'),
(99, 'India', 0, 'IN', 'IND', '356', 'en', 0, '2010-02-16 20:39:43'),
(100, 'Indonesia', 0, 'ID', 'IDN', '360', 'en', 0, '2010-02-16 20:39:43'),
(101, 'Iran', 0, 'IR', 'IRN', '364', 'en', 0, '2010-02-16 20:39:43'),
(102, 'Iraq', 0, 'IQ', 'IRQ', '368', 'en', 0, '2010-02-16 20:39:43'),
(103, 'Ireland', 0, 'IE', 'IRL', '372', 'en', 0, '2010-02-16 20:39:43'),
(104, 'Israel', 0, 'IL', 'ISR', '376', 'en', 0, '2010-02-16 20:39:43'),
(105, 'Italy', 0, 'IT', 'ITA', '380', 'en', 0, '2010-02-16 20:39:43'),
(106, 'Jamaica', 0, 'JM', 'JAM', '388', 'en', 0, '2010-02-16 20:39:43'),
(107, 'Japan', 0, 'JP', 'JPN', '392', 'en', 0, '2010-02-16 20:39:43'),
(108, 'Jordan', 0, 'JO', 'JOR', '400', 'en', 0, '2010-02-16 20:39:43'),
(109, 'Kazakhstan', 0, 'KZ', 'KAZ', '398', 'en', 0, '2010-02-16 20:39:43'),
(110, 'Kenya', 0, 'KE', 'KEN', '404', 'en', 0, '2010-02-16 20:39:43'),
(111, 'Kiribati', 0, 'KI', 'KIR', '296', 'en', 0, '2010-02-16 20:39:43'),
(112, 'North Korea', 0, 'KP', 'PRK', '408', 'en', 0, '2010-02-16 20:39:43'),
(113, 'South Korea', 0, 'KR', 'KOR', '410', 'en', 0, '2010-02-16 20:39:43'),
(114, 'Kuwait', 0, 'KW', 'KWT', '414', 'en', 0, '2010-02-16 20:39:43'),
(115, 'Kyrgyzstan', 0, 'KG', 'KGZ', '417', 'en', 0, '2010-02-16 20:39:43'),
(116, 'Lao', 0, 'LA', 'LAO', '418', 'en', 0, '2010-02-16 20:39:43'),
(117, 'Latvia', 0, 'LV', 'LVA', '428', 'en', 0, '2010-02-16 20:39:43'),
(118, 'Lebanon', 0, 'LB', 'LBN', '422', 'en', 0, '2010-02-16 20:39:43'),
(119, 'Lesotho', 0, 'LS', 'LSO', '426', 'en', 0, '2010-02-16 20:39:43'),
(120, 'Liberia', 0, 'LR', 'LBR', '430', 'en', 0, '2010-02-16 20:39:43'),
(121, 'Libya', 0, 'LY', 'LBY', '434', 'en', 0, '2010-02-16 20:39:43'),
(122, 'Liechtenstein', 0, 'LI', 'LIE', '438', 'en', 0, '2010-02-16 20:39:43'),
(123, 'Lithuania', 0, 'LT', 'LTU', '440', 'en', 0, '2010-02-16 20:39:43'),
(124, 'Luxembourg', 0, 'LU', 'LUX', '442', 'en', 0, '2010-02-16 20:39:43'),
(125, 'Macao', 0, 'MO', 'MAC', '446', 'en', 0, '2010-02-16 20:39:43'),
(126, 'Macedonia', 0, 'MK', 'MKD', '807', 'en', 0, '2010-02-16 20:39:43'),
(127, 'Madagascar', 0, 'MG', 'MDG', '450', 'en', 0, '2010-02-16 20:39:43'),
(128, 'Malawi', 0, 'MW', 'MWI', '454', 'en', 0, '2010-02-16 20:39:43'),
(129, 'Malaysia', 0, 'MY', 'MYS', '458', 'en', 0, '2010-02-16 20:39:43'),
(130, 'Maldives', 0, 'MV', 'MDV', '462', 'en', 0, '2010-02-16 20:39:43'),
(131, 'Mali', 0, 'ML', 'MLI', '466', 'en', 0, '2010-02-16 20:39:43'),
(132, 'Malta', 0, 'MT', 'MLT', '470', 'en', 0, '2010-02-16 20:39:43'),
(133, 'Marshall Islands', 0, 'MH', 'MHL', '584', 'en', 1, '2010-02-16 20:39:43'),
(134, 'Martinique', 0, 'MQ', 'MTQ', '474', 'en', 0, '2010-02-16 20:39:43'),
(135, 'Mauritania', 0, 'MR', 'MRT', '478', 'en', 0, '2010-02-16 20:39:43'),
(136, 'Mauritius', 0, 'MU', 'MUS', '480', 'en', 0, '2010-02-16 20:39:43'),
(137, 'Mayotte', 0, 'YT', 'MYT', '175', 'en', 0, '2010-02-16 20:39:43'),
(138, 'Mexico', 0, 'MX', 'MEX', '484', 'en', 0, '2010-02-16 20:39:43'),
(139, 'Micronesia', 0, 'FM', 'FSM', '583', 'en', 0, '2010-02-16 20:39:43'),
(140, 'Moldova', 0, 'MD', 'MDA', '498', 'en', 0, '2010-02-16 20:39:43'),
(141, 'Monaco', 0, 'MC', 'MCO', '492', 'en', 0, '2010-02-16 20:39:43'),
(142, 'Mongolia', 0, 'MN', 'MNG', '496', 'en', 0, '2010-02-16 20:39:43'),
(143, 'Montserrat', 0, 'MS', 'MSR', '500', 'en', 0, '2010-02-16 20:39:43'),
(144, 'Morocco', 0, 'MA', 'MAR', '504', 'en', 0, '2010-02-16 20:39:43'),
(145, 'Mozambique', 0, 'MZ', 'MOZ', '508', 'en', 0, '2010-02-16 20:39:43'),
(146, 'Myanmar', 0, 'MM', 'MMR', '104', 'en', 0, '2010-02-16 20:39:43'),
(147, 'Namibia', 0, 'NA', 'NAM', '516', 'en', 0, '2010-02-16 20:39:43'),
(148, 'Nauru', 0, 'NR', 'NRU', '520', 'en', 0, '2010-02-16 20:39:43'),
(149, 'Nepal', 0, 'NP', 'NPL', '524', 'en', 0, '2010-02-16 20:39:43'),
(150, 'Netherlands Antilles', 0, 'AN', 'ANT', '530', 'en', 0, '2010-02-16 20:39:43'),
(151, 'Netherlands', 0, 'NL', 'NLD', '528', 'en', 1, '2010-02-16 20:39:43'),
(152, 'New Caledonia', 0, 'NC', 'NCL', '540', 'en', 0, '2010-02-16 20:39:43'),
(153, 'New Zealand', 0, 'NZ', 'NZL', '554', 'en', 0, '2010-02-16 20:39:43'),
(154, 'Nicaragua', 0, 'NI', 'NIC', '558', 'en', 0, '2010-02-16 20:39:43'),
(155, 'Niger', 0, 'NE', 'NER', '562', 'en', 0, '2010-02-16 20:39:43'),
(156, 'Nigeria', 0, 'NG', 'NGA', '566', 'en', 0, '2010-02-16 20:39:43'),
(157, 'Niue', 0, 'NU', 'NIU', '570', 'en', 0, '2010-02-16 20:39:43'),
(158, 'Norfolk Island', 0, 'NF', 'NFK', '574', 'en', 0, '2010-02-16 20:39:43'),
(159, 'Northern Mariana', 0, 'MP', 'MNP', '580', 'en', 0, '2010-02-16 20:39:43'),
(160, 'Norway', 0, 'NO', 'NOR', '578', 'en', 0, '2010-02-16 20:39:43'),
(161, 'Oman', 0, 'OM', 'OMN', '512', 'en', 0, '2010-02-16 20:39:43'),
(162, 'Pakistan', 0, 'PK', 'PAK', '586', 'en', 0, '2010-02-16 20:39:43'),
(163, 'Palau', 0, 'PW', 'PLW', '585', 'en', 0, '2010-02-16 20:39:43'),
(164, 'Palestine', 0, 'PS', 'PSE', '275', 'en', 0, '2010-02-16 20:39:43'),
(165, 'Panama', 0, 'PA', 'PAN', '591', 'en', 0, '2010-02-16 20:39:43'),
(166, 'Papua New Guinea', 0, 'PG', 'PNG', '598', 'en', 0, '2010-02-16 20:39:43'),
(167, 'Paraguay', 0, 'PY', 'PRY', '600', 'en', 0, '2010-02-16 20:39:43'),
(168, 'Peru', 0, 'PE', 'PER', '604', 'en', 0, '2010-02-16 20:39:43'),
(169, 'Philippines', 0, 'PH', 'PHL', '608', 'en', 0, '2010-02-16 20:39:43'),
(170, 'Pitcairn Island', 0, 'PN', 'PCN', '612', 'en', 0, '2010-02-16 20:39:43'),
(171, 'Poland', 0, 'PL', 'POL', '616', 'en', 0, '2010-02-16 20:39:43'),
(172, 'Portugal', 0, 'PT', 'PRT', '620', 'en', 0, '2010-02-16 20:39:43'),
(173, 'Puerto Rico', 0, 'PR', 'PRI', '630', 'en', 0, '2010-02-16 20:39:43'),
(174, 'Qatar', 0, 'QA', 'QAT', '634', 'en', 0, '2010-02-16 20:39:43'),
(175, 'Reunion Island', 0, 'RE', 'REU', '638', 'en', 0, '2010-02-16 20:39:43'),
(176, 'Romania', 0, 'RO', 'ROU', '642', 'en', 0, '2010-02-16 20:39:43'),
(177, 'Russia', 0, 'RU', 'RUS', '643', 'en', 0, '2010-02-16 20:39:43'),
(178, 'Rwanda', 0, 'RW', 'RWA', '646', 'en', 0, '2010-02-16 20:39:43'),
(179, 'St. Helena', 0, 'SH', 'SHN', '654', 'en', 0, '2010-02-16 20:39:43'),
(180, 'St. Kitts and Nevis', 0, 'KN', 'KNA', '659', 'en', 0, '2010-02-16 20:39:43'),
(181, 'St. Lucia', 0, 'LC', 'LCA', '662', 'en', 0, '2010-02-16 20:39:43'),
(182, 'St. Pierre and Miquelon', 0, 'PM', 'SPM', '666', 'en', 0, '2010-02-16 20:39:43'),
(183, 'St. Vincent and the Grenadines', 0, 'VC', 'VCT', '670', 'en', 0, '2010-02-16 20:39:43'),
(184, 'Samoa', 0, 'WS', 'WSM', '882', 'en', 0, '2010-02-16 20:39:43'),
(185, 'San Marino', 0, 'SM', 'SMR', '674', 'en', 0, '2010-02-16 20:39:43'),
(186, 'Sao Tome and Principe', 0, 'ST', 'STP', '678', 'en', 0, '2010-02-16 20:39:43'),
(187, 'Saudi Arabia', 0, 'SA', 'SAU', '682', 'en', 0, '2010-02-16 20:39:43'),
(188, 'Senegal', 0, 'SN', 'SEN', '686', 'en', 0, '2010-02-16 20:39:43'),
(189, 'Serbia and Montenegro', 0, 'CS', 'SCG', '891', 'en', 0, '2010-02-16 20:39:43'),
(190, 'Seychelles', 0, 'SC', 'SYC', '690', 'en', 0, '2010-02-16 20:39:43'),
(191, 'Sierra Leone', 0, 'SL', 'SLE', '694', 'en', 0, '2010-02-16 20:39:43'),
(192, 'Singapore', 0, 'SG', 'SGP', '702', 'en', 0, '2010-02-16 20:39:43'),
(193, 'Slovakia', 0, 'SK', 'SVK', '703', 'en', 0, '2010-02-16 20:39:43'),
(194, 'Slovenia', 0, 'SI', 'SVN', '705', 'en', 0, '2010-02-16 20:39:43'),
(195, 'Solomon Islands', 0, 'SB', 'SLB', '90', 'en', 0, '2010-02-16 20:39:43'),
(196, 'Somalia', 0, 'SO', 'SOM', '706', 'en', 0, '2010-02-16 20:39:43'),
(197, 'South Africa', 0, 'ZA', 'ZAF', '710', 'en', 0, '2010-02-16 20:39:43'),
(198, 'South Georgia', 0, 'GS', 'SGS', '239', 'en', 0, '2010-02-16 20:39:43'),
(199, 'Spain', 0, 'ES', 'ESP', '724', 'en', 0, '2010-02-16 20:39:43'),
(200, 'Sri Lanka', 0, 'LK', 'LKA', '144', 'en', 0, '2010-02-16 20:39:43'),
(201, 'Sudan', 0, 'SD', 'SDN', '736', 'en', 0, '2010-02-16 20:39:43'),
(202, 'Suriname', 0, 'SR', 'SUR', '740', 'en', 0, '2010-02-16 20:39:43'),
(203, 'Swaziland', 0, 'SZ', 'SWZ', '748', 'en', 0, '2010-02-16 20:39:43'),
(204, 'Sweden', 0, 'SE', 'SWE', '752', 'en', 0, '2010-02-16 20:39:43'),
(205, 'Switzerland', 0, 'CH', 'CHE', '756', 'en', 0, '2010-02-16 20:39:43'),
(206, 'Syria', 0, 'SY', 'SYR', '760', 'en', 0, '2010-02-16 20:39:43'),
(207, 'Taiwan', 0, 'TW', 'TWN', '158', 'en', 0, '2010-02-16 20:39:43'),
(208, 'Tajikistan', 0, 'TJ', 'TJK', '762', 'en', 0, '2010-02-16 20:39:43'),
(209, 'Thailand', 0, 'TH', 'THA', '764', 'en', 0, '2010-02-16 20:39:43'),
(210, 'Timor-Leste', 0, 'TL', 'TLS', '626', 'en', 0, '2010-02-16 20:39:43'),
(211, 'Togo', 0, 'TG', 'TGO', '768', 'en', 0, '2010-02-16 20:39:43'),
(212, 'Tokelau', 0, 'TK', 'TKL', '772', 'en', 0, '2010-02-16 20:39:43'),
(213, 'Tonga', 0, 'TO', 'TON', '776', 'en', 0, '2010-02-16 20:39:43'),
(214, 'Trinidad and Tobago', 0, 'TT', 'TTO', '780', 'en', 0, '2010-02-16 20:39:43'),
(215, 'Tunisia', 0, 'TN', 'TUN', '788', 'en', 0, '2010-02-16 20:39:43'),
(216, 'Turkey', 0, 'TR', 'TUR', '792', 'en', 0, '2010-02-16 20:39:43'),
(217, 'Turkmenistan', 0, 'TM', 'TKM', '795', 'en', 0, '2010-02-16 20:39:43'),
(218, 'Turks and Caicos Islands', 0, 'TC', 'TCA', '796', 'en', 0, '2010-02-16 20:39:43'),
(219, 'Tuvalu', 0, 'TV', 'TUV', '798', 'en', 0, '2010-02-16 20:39:43'),
(220, 'US Virgin Islands', 0, 'VI', 'VIR', '850', 'en', 1, '2010-02-16 20:39:43'),
(221, 'Uganda', 0, 'UG', 'UGA', '800', 'en', 0, '2010-02-16 20:39:43'),
(222, 'Ukraine', 0, 'UA', 'UKR', '804', 'en', 0, '2010-02-16 20:39:43'),
(223, 'United Arab Emirates', 0, 'AE', 'ARE', '784', 'en', 1, '2010-02-16 20:39:43'),
(224, 'United Kingdom', 1, 'GB', 'GBR', '826', 'en', 1, '2010-02-16 20:39:43'),
(225, 'US Outlying Islands', 0, 'UM', 'UMI', '581', 'en', 1, '2010-02-16 20:39:43'),
(226, 'United States', 1, 'US', 'USA', '840', 'en', 1, '2010-02-16 20:39:43'),
(227, 'Uruguay', 0, 'UY', 'URY', '858', 'en', 0, '2010-02-16 20:39:43'),
(228, 'Uzbekistan', 0, 'UZ', 'UZB', '860', 'en', 0, '2010-02-16 20:39:43'),
(229, 'New Hebrides', 0, 'VU', 'VUT', '548', 'en', 0, '2010-02-16 20:39:43'),
(230, 'Venezuela', 0, 'VE', 'VEN', '862', 'en', 0, '2010-02-16 20:39:43'),
(231, 'Vietnam', 0, 'VN', 'VNM', '704', 'en', 0, '2010-02-16 20:39:43'),
(232, 'Wallis and Futuna Islands', 0, 'WF', 'WLF', '876', 'en', 0, '2010-02-16 20:39:43'),
(233, 'Western Sahara', 0, 'EH', 'ESH', '732', 'en', 0, '2010-02-16 20:39:43'),
(234, 'Yemen', 0, 'YE', 'YEM', '887', 'en', 0, '2010-02-16 20:39:43'),
(235, 'Zambia', 0, 'ZM', 'ZMB', '894', 'en', 0, '2010-02-16 20:39:43'),
(236, 'Zimbabwe', 0, 'ZW', 'ZWE', '716', 'en', 0, '2010-02-16 20:39:43');