Icy Phoenix

Hiii

where i can chage (in which file) extention of flags example Antartica.gif to Antartica.png

why i m asking this..i setuped two forums for testing normal and RC and this happend to me...

all icy forums have flag .png (this forum , one my and all other that i visited) but other one my (not RC ) have ext .gif for all flags i dunno why !



Thanks

It seems you have a corrupted FLAG table.

You should solve in this way:

• Make sure you have all IP flags from the install package in the correct folder...
  
• EMPTY your PHPBB_FLAGS table (replace PHPBB_ with your TABLE prefix)...
  
• Execute this SQL on your DB via phpMyAdmin (replace PHPBB_ with your TABLE prefix):
  
  Spoiler: [ Show ]

  Spoiler: [ Hide ]

  Code: [Hide] [Select]

  Code: [Show]

  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (1, 'Afghanistan', 'afghanistan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (2, 'AI', 'ai.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (3, 'Albania', 'albania.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (4, 'Algeria', 'algeria.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (5, 'AN', 'an.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (6, 'Andorra', 'andorra.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (7, 'Antiguabarbuda', 'antiguabarbuda.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (8, 'AO', 'ao.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (9, 'Argentina', 'argentina.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (10, 'Armenia', 'armenia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (11, 'AS', 'as.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (12, 'Australia', 'australia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (13, 'Austria', 'austria.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (14, 'AW', 'aw.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (15, 'AX', 'ax.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (16, 'Azerbaijan', 'azerbaijan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (17, 'Bahamas', 'bahamas.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (18, 'Bahrain', 'bahrain.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (19, 'Bangladesh', 'bangladesh.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (20, 'Barbados', 'barbados.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (21, 'Belarus', 'belarus.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (22, 'Belgium', 'belgium.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (23, 'Belize', 'belize.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (24, 'Benin', 'benin.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (25, 'Bhutan', 'bhutan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (26, 'BM', 'bm.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (27, 'Bolivia', 'bolivia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (28, 'Bosnia Herzegovina', 'bosnia_herzegovina.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (29, 'Botswana', 'botswana.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (30, 'Brazil', 'brazil.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (31, 'Brunei', 'brunei.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (32, 'Bulgaria', 'bulgaria.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (33, 'Burkinafaso', 'burkinafaso.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (34, 'Burma', 'burma.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (35, 'Burundi', 'burundi.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (36, 'BV', 'bv.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (37, 'Cambodia', 'cambodia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (38, 'Cameroon', 'cameroon.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (39, 'Canada', 'canada.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (40, 'CC', 'cc.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (41, 'Central African Republic', 'central_african_republic.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (42, 'Chad', 'chad.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (43, 'Chile', 'chile.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (44, 'China', 'china.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (45, 'CK', 'ck.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (46, 'Columbia', 'columbia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (47, 'Comoros', 'comoros.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (48, 'Congo', 'congo.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (49, 'Costa Rica', 'costa_rica.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (50, 'Croatia', 'croatia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (51, 'Cuba', 'cuba.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (52, 'CV', 'cv.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (53, 'CX', 'cx.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (54, 'Cyprus', 'cyprus.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (55, 'Czech Republic', 'czech_republic.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (56, 'Dem Rep Congo', 'dem_rep_congo.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (57, 'Denmark', 'denmark.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (58, 'Djibouti', 'djibouti.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (59, 'Dominica', 'dominica.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (60, 'Dominican Rep', 'dominican_rep.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (61, 'Ecuador', 'ecuador.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (62, 'Egypt', 'egypt.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (63, 'EH', 'eh.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (64, 'Elsalvador', 'elsalvador.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (65, 'England', 'england.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (66, 'Eq Guinea', 'eq_guinea.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (67, 'Eritrea', 'eritrea.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (68, 'Estonia', 'estonia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (69, 'Ethiopia', 'ethiopia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (70, 'FAM', 'fam.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (71, 'Fiji', 'fiji.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (72, 'Finland', 'finland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (73, 'FK', 'fk.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (74, 'FO', 'fo.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (75, 'France', 'france.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (76, 'Gabon', 'gabon.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (77, 'Gambia', 'gambia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (78, 'Georgia', 'georgia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (79, 'Germany', 'germany.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (80, 'Ghana', 'ghana.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (81, 'GI', 'gi.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (82, 'GL', 'gl.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (83, 'GP', 'gp.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (84, 'Greece', 'greece.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (85, 'Grenada', 'grenada.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (86, 'Grenadines', 'grenadines.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (87, 'GS', 'gs.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (88, 'GU', 'gu.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (89, 'Guatemala', 'guatemala.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (90, 'Guinea', 'guinea.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (91, 'Guinea Bissau', 'guinea_bissau.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (92, 'Guyana', 'guyana.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (93, 'Haiti', 'haiti.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (94, 'Honduras', 'honduras.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (95, 'Hong Kong', 'hong_kong.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (96, 'Hungary', 'hungary.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (97, 'Iceland', 'iceland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (98, 'India', 'india.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (99, 'Indonesia', 'indonesia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (100, 'IO', 'io.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (101, 'Iran', 'iran.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (102, 'Iraq', 'iraq.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (103, 'Ireland', 'ireland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (104, 'Israel', 'israel.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (105, 'Italia', 'italia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (106, 'Ivory Coast', 'ivory_coast.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (107, 'Jamaica', 'jamaica.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (108, 'Japan', 'japan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (109, 'Jordan', 'jordan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (110, 'Kazakhstan', 'kazakhstan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (111, 'Kenya', 'kenya.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (112, 'Kiribati', 'kiribati.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (113, 'KP', 'kp.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (114, 'Kuwait', 'kuwait.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (115, 'KY', 'ky.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (116, 'Kyrgyzstan', 'kyrgyzstan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (117, 'Laos', 'laos.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (118, 'Latvia', 'latvia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (119, 'Lebanon', 'lebanon.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (120, 'Liberia', 'liberia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (121, 'Libya', 'libya.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (122, 'Liechtenstein', 'liechtenstein.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (123, 'Lithuania', 'lithuania.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (124, 'LS', 'ls.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (125, 'Luxembourg', 'luxembourg.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (126, 'Macau', 'macau.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (127, 'Madagascar', 'madagascar.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (128, 'Malawi', 'malawi.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (129, 'Malaysia', 'malaysia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (130, 'Maldives', 'maldives.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (131, 'Mali', 'mali.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (132, 'Malta', 'malta.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (133, 'Mauritania', 'mauritania.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (134, 'Mauritius', 'mauritius.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (135, 'Mexico', 'mexico.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (136, 'MH', 'mh.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (137, 'Micronesia', 'micronesia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (138, 'MK', 'mk.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (139, 'Moldova', 'moldova.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (140, 'Monaco', 'monaco.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (141, 'Mongolia', 'mongolia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (142, 'Morocco', 'morocco.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (143, 'Mozambique', 'mozambique.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (144, 'MP', 'mp.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (145, 'MS', 'ms.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (146, 'Namibia', 'namibia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (147, 'Nauru', 'nauru.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (148, 'NC', 'nc.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (149, 'Nepal', 'nepal.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (150, 'Netherlands', 'netherlands.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (151, 'New Zealand', 'new_zealand.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (152, 'NF', 'nf.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (153, 'Nicaragua', 'nicaragua.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (154, 'Niger', 'niger.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (155, 'Nigeria', 'nigeria.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (156, 'Norway', 'norway.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (157, 'NU', 'nu.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (158, 'Oman', 'oman.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (159, 'Pakistan', 'pakistan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (160, 'Panama', 'panama.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (161, 'Papua New Guinea', 'papua_new_guinea.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (162, 'Paraguay', 'paraguay.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (163, 'Peru', 'peru.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (164, 'PF', 'pf.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (165, 'Philippines', 'philippines.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (166, 'PM', 'pm.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (167, 'PN', 'pn.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (168, 'Poland', 'poland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (169, 'Portugal', 'portugal.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (170, 'PS', 'ps.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (171, 'Puerto Rico', 'puerto_rico.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (172, 'PW', 'pw.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (173, 'Qatar', 'qatar.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (174, 'Quebec', 'quebec.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (175, 'Romania', 'romania.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (176, 'Russia', 'russia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (177, 'Rwanda', 'rwanda.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (178, 'Sao Tome', 'sao_tome.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (179, 'Saudi Arabia', 'saudi_arabia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (180, 'Scotland', 'scotland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (181, 'Senegal', 'senegal.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (182, 'Serbia', 'serbia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (183, 'Seychelles', 'seychelles.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (184, 'SH', 'sh.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (185, 'Sierraleone', 'sierraleone.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (186, 'Singapore', 'singapore.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (187, 'Slovakia', 'slovakia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (188, 'Slovenia', 'slovenia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (189, 'SM', 'sm.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (190, 'Solomon Islands', 'solomon_islands.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (191, 'Somalia', 'somalia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (192, 'South Africa', 'south_africa.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (193, 'South Korea', 'south_korea.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (194, 'Spain', 'spain.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (195, 'Sri Lanka', 'sri_lanka.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (196, 'Stkitts Nevis', 'stkitts_nevis.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (197, 'Stlucia', 'stlucia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (198, 'Sudan', 'sudan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (199, 'Suriname', 'suriname.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (200, 'Sweden', 'sweden.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (201, 'Switzerland', 'switzerland.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (202, 'Syria', 'syria.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (203, 'SZ', 'sz.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (204, 'Taiwan', 'taiwan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (205, 'Tajikistan', 'tajikistan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (206, 'Tanzania', 'tanzania.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (207, 'TF', 'tf.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (208, 'Thailand', 'thailand.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (209, 'TK', 'tk.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (210, 'TL', 'tl.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (211, 'Togo', 'togo.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (212, 'Tonga', 'tonga.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (213, 'Trinidat And Tobago', 'trinidat_and_tobago.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (214, 'Tunisia', 'tunisia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (215, 'Turkey', 'turkey.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (216, 'Turkmenistan', 'turkmenistan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (217, 'Tuvala', 'tuvala.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (218, 'TV', 'tv.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (219, 'Uganda', 'uganda.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (220, 'UK', 'uk.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (221, 'Ukraine', 'ukraine.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (222, 'UM', 'um.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (223, 'United Arabic Emirates', 'united_arabic_emirates.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (224, 'Uruguay', 'uruguay.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (225, 'USA', 'usa.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (226, 'Uzbekistan', 'uzbekistan.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (227, 'Vanuatu', 'vanuatu.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (228, 'Vatican', 'vatican.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (229, 'Venezuela', 'venezuela.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (230, 'VG', 'vg.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (231, 'VI', 'vi.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (232, 'Vietnam', 'vietnam.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (233, 'Wales', 'wales.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (234, 'Western Samoa', 'western_samoa.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (235, 'WF', 'wf.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (236, 'Yemen', 'yemen.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (237, 'YT', 'yt.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (238, 'Yugoslavia', 'yugoslavia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (239, 'Zambia', 'zambia.png');
  INSERT INTO `phpbb_flags` (`flag_id`, `flag_name`, `flag_image`) VALUES (240, 'Zimbabwe', 'zimbabwe.png');

Let me know if it works.

i done what u sayed...but didnt helped

see...



and nothing changed
i also emptyed cash

That is because you did upgrade from another mod which uses GIF flags instead of PNG... you should replace all old flags with the new ones in the DB as well...

damt...i deleted in `ip_users` this table `user_from_flag`

i tryed to replace it with this



the erorr i recive is - #1054 - Unknown column 'user_from_flag' in 'field list'

how can i repair this?
i m using phpMyAdmin - 2.8.2.4

Limun, please use spoiler the spoiler next time.

Limun wrote: [View Post]

damt...i deleted in `ip_users` this table `user_from_flag`

...

the erorr i recive is - #1054 - Unknown column 'user_from_flag' in 'field list'

how can i repair this?
i m using phpMyAdmin - 2.8.2.4

Try this:



Let me know...

uff this flags...

ok i added table...but now its empty



how to add 4155 members in it

i have some becups like



when i execute this INSERT INTO `ip_users` (`user_from_flag`) VALUES (NULL),
i recive #1062 - Duplicate entry '0' for key 1



anyway if is not resolwable its not important this is on test forum with 4000members

but how to awoid that this happend when i m going to upgrade a real running forum ?
i mean there i have that with .gif flags and i even dont remeber whic mod is that..
Thanks MG..