Aim not sure whichTorrentStrike
Quote:
Originally Posted by BEST
(Post 35186)
hello I need your help once, and that is about a strike source torrent with the registration get this error
SQL error: Table 'test.ip2nationcountries' does not exist
SQL error code: 1146
Date: Friday 08th of June 2012 06:27:55 PM
where I get the sql entry, please help
|
If it is Torrentstrike Fullymodded v1.0 then this should create the tabel for country.
PHP Code:
CREATE TABLE `countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=200 ;
And for the countries flags this sould do it.
PHP Code:
INSERT INTO `countries` VALUES (1, 'Sweden', 'sweden.gif');
INSERT INTO `countries` VALUES (2, 'United States of America', 'usa.gif');
INSERT INTO `countries` VALUES (3, 'Russia', 'russia.gif');
INSERT INTO `countries` VALUES (4, 'Finland', 'finland.gif');
INSERT INTO `countries` VALUES (5, 'Canada', 'canada.gif');
INSERT INTO `countries` VALUES (6, 'France', 'france.gif');
INSERT INTO `countries` VALUES (7, 'Germany', 'germany.gif');
INSERT INTO `countries` VALUES (8, 'China', 'china.gif');
INSERT INTO `countries` VALUES (9, 'Italy', 'italy.gif');
INSERT INTO `countries` VALUES (10, 'Denmark', 'denmark.gif');
INSERT INTO `countries` VALUES (11, 'Norway', 'norway.gif');
INSERT INTO `countries` VALUES (12, 'United Kingdom', 'uk.gif');
INSERT INTO `countries` VALUES (13, 'Ireland', 'ireland.gif');
INSERT INTO `countries` VALUES (14, 'Poland', 'poland.gif');
INSERT INTO `countries` VALUES (15, 'Netherlands', 'netherlands.gif');
INSERT INTO `countries` VALUES (16, 'Belgium', 'belgium.gif');
INSERT INTO `countries` VALUES (17, 'Japan', 'japan.gif');
INSERT INTO `countries` VALUES (18, 'Brazil', 'brazil.gif');
INSERT INTO `countries` VALUES (19, 'Argentina', 'argentina.gif');
INSERT INTO `countries` VALUES (20, 'Australia', 'australia.gif');
INSERT INTO `countries` VALUES (21, 'New Zealand', 'newzealand.gif');
INSERT INTO `countries` VALUES (23, 'Spain', 'spain.gif');
INSERT INTO `countries` VALUES (24, 'Portugal', 'portugal.gif');
INSERT INTO `countries` VALUES (25, 'Mexico', 'mexico.gif');
INSERT INTO `countries` VALUES (26, 'Singapore', 'singapore.gif');
INSERT INTO `countries` VALUES (27, 'India', 'india.gif');
INSERT INTO `countries` VALUES (28, 'Albania', 'albania.gif');
INSERT INTO `countries` VALUES (29, 'South Africa', 'southafrica.gif');
INSERT INTO `countries` VALUES (30, 'South Korea', 'southkorea.gif');
INSERT INTO `countries` VALUES (31, 'Jamaica', 'jamaica.gif');
INSERT INTO `countries` VALUES (32, 'Luxembourg', 'luxembourg.gif');
INSERT INTO `countries` VALUES (33, 'Hong Kong', 'hongkong.gif');
INSERT INTO `countries` VALUES (34, 'Belize', 'belize.gif');
INSERT INTO `countries` VALUES (35, 'Algeria', 'algeria.gif');
INSERT INTO `countries` VALUES (36, 'Angola', 'angola.gif');
INSERT INTO `countries` VALUES (37, 'Austria', 'austria.gif');
INSERT INTO `countries` VALUES (38, 'Yugoslavia', 'yugoslavia.gif');
INSERT INTO `countries` VALUES (39, 'Western Samoa', 'westernsamoa.gif');
INSERT INTO `countries` VALUES (40, 'Malaysia', 'malaysia.gif');
INSERT INTO `countries` VALUES (41, 'Dominican Republic', 'dominicanrep.gif');
INSERT INTO `countries` VALUES (42, 'Greece', 'greece.gif');
INSERT INTO `countries` VALUES (43, 'Guatemala', 'guatemala.gif');
INSERT INTO `countries` VALUES (44, 'Israel', 'israel.gif');
INSERT INTO `countries` VALUES (45, 'Pakistan', 'pakistan.gif');
INSERT INTO `countries` VALUES (46, 'Czech Republic', 'czechrep.gif');
INSERT INTO `countries` VALUES (47, 'Serbia', 'serbia.gif');
INSERT INTO `countries` VALUES (48, 'Seychelles', 'seychelles.gif');
INSERT INTO `countries` VALUES (49, 'Taiwan', 'taiwan.gif');
INSERT INTO `countries` VALUES (50, 'Puerto Rico', 'puertorico.gif');
INSERT INTO `countries` VALUES (51, 'Chile', 'chile.gif');
INSERT INTO `countries` VALUES (52, 'Cuba', 'cuba.gif');
INSERT INTO `countries` VALUES (53, 'Congo', 'congo.gif');
INSERT INTO `countries` VALUES (54, 'Afghanistan', 'afghanistan.gif');
INSERT INTO `countries` VALUES (55, 'Turkey', 'turkey.gif');
INSERT INTO `countries` VALUES (56, 'Uzbekistan', 'uzbekistan.gif');
INSERT INTO `countries` VALUES (57, 'Switzerland', 'switzerland.gif');
INSERT INTO `countries` VALUES (58, 'Kiribati', 'kiribati.gif');
INSERT INTO `countries` VALUES (59, 'Philippines', 'philippines.gif');
INSERT INTO `countries` VALUES (60, 'Burkina Faso', 'burkinafaso.gif');
INSERT INTO `countries` VALUES (61, 'Nigeria', 'nigeria.gif');
INSERT INTO `countries` VALUES (62, 'Iceland', 'iceland.gif');
INSERT INTO `countries` VALUES (63, 'Nauru', 'nauru.gif');
INSERT INTO `countries` VALUES (64, 'Slovenia', 'slovenia.gif');
INSERT INTO `countries` VALUES (66, 'Turkmenistan', 'turkmenistan.gif');
INSERT INTO `countries` VALUES (67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif');
INSERT INTO `countries` VALUES (68, 'Andorra', 'andorra.gif');
INSERT INTO `countries` VALUES (69, 'Lithuania', 'lithuania.gif');
INSERT INTO `countries` VALUES (70, 'Macedonia', 'macadonia.gif');
INSERT INTO `countries` VALUES (71, 'Netherlands Antilles', 'nethantilles.gif');
INSERT INTO `countries` VALUES (72, 'Ukraine', 'ukraine.gif');
INSERT INTO `countries` VALUES (73, 'Venezuela', 'venezuela.gif');
INSERT INTO `countries` VALUES (74, 'Hungary', 'hungary.gif');
INSERT INTO `countries` VALUES (75, 'Romania', 'romania.gif');
INSERT INTO `countries` VALUES (76, 'Vanuatu', 'vanuatu.gif');
INSERT INTO `countries` VALUES (77, 'Vietnam', 'vietnam.gif');
INSERT INTO `countries` VALUES (78, 'Trinidad & Tobago', 'trinidadandtobago.gif');
INSERT INTO `countries` VALUES (79, 'Honduras', 'honduras.gif');
INSERT INTO `countries` VALUES (80, 'Kyrgyzstan', 'kyrgyzstan.gif');
INSERT INTO `countries` VALUES (81, 'Ecuador', 'ecuador.gif');
INSERT INTO `countries` VALUES (82, 'Bahamas', 'bahamas.gif');
INSERT INTO `countries` VALUES (83, 'Peru', 'peru.gif');
INSERT INTO `countries` VALUES (84, 'Cambodia', 'cambodia.gif');
INSERT INTO `countries` VALUES (85, 'Barbados', 'barbados.gif');
INSERT INTO `countries` VALUES (86, 'Bangladesh', 'bangladesh.gif');
INSERT INTO `countries` VALUES (87, 'Laos', 'laos.gif');
INSERT INTO `countries` VALUES (88, 'Uruguay', 'uruguay.gif');
INSERT INTO `countries` VALUES (89, 'Antigua Barbuda', 'antiguabarbuda.gif');
INSERT INTO `countries` VALUES (90, 'Paraguay', 'paraguay.gif');
INSERT INTO `countries` VALUES (92, 'Union of Soviet Socialist Republics', 'ussr.gif');
INSERT INTO `countries` VALUES (93, 'Thailand', 'thailand.gif');
INSERT INTO `countries` VALUES (94, 'Senegal', 'senegal.gif');
INSERT INTO `countries` VALUES (95, 'Togo', 'togo.gif');
INSERT INTO `countries` VALUES (96, 'North Korea', 'northkorea.gif');
INSERT INTO `countries` VALUES (97, 'Croatia', 'croatia.gif');
INSERT INTO `countries` VALUES (98, 'Estonia', 'estonia.gif');
INSERT INTO `countries` VALUES (99, 'Colombia', 'colombia.gif');
INSERT INTO `countries` VALUES (100, 'Lebanon', 'lebanon.gif');
INSERT INTO `countries` VALUES (101, 'Latvia', 'latvia.gif');
INSERT INTO `countries` VALUES (102, 'Costa Rica', 'costarica.gif');
INSERT INTO `countries` VALUES (103, 'Egypt', 'egypt.gif');
INSERT INTO `countries` VALUES (104, 'Bulgaria', 'bulgaria.gif');
INSERT INTO `countries` VALUES (105, 'Isla de Muerte', 'jollyroger.gif');
INSERT INTO `countries` VALUES (106, 'Moldova', 'moldova.gif');
INSERT INTO `countries` VALUES (107, 'Armenia', 'armenia.gif');
INSERT INTO `countries` VALUES (108, 'Azerbaijan', 'azerbaijan.gif');
INSERT INTO `countries` VALUES (109, 'Bahrain', 'bahrain.gif');
INSERT INTO `countries` VALUES (110, 'Belarus', 'belarus.gif');
INSERT INTO `countries` VALUES (111, 'Benin', 'benin.gif');
INSERT INTO `countries` VALUES (112, 'Bhutan', 'bhutan.gif');
INSERT INTO `countries` VALUES (113, 'Bolivia', 'bolivia.gif');
INSERT INTO `countries` VALUES (114, 'Botswana', 'botswana.gif');
INSERT INTO `countries` VALUES (115, 'Brunei', 'brunei.gif');
INSERT INTO `countries` VALUES (116, 'Union of Myanmar', 'burma.gif');
INSERT INTO `countries` VALUES (117, 'Burundi', 'burund.gif');
INSERT INTO `countries` VALUES (118, 'Cameroon', 'cameroon.gif');
INSERT INTO `countries` VALUES (119, 'Central African Republic', 'centralafricanrep.gif');
INSERT INTO `countries` VALUES (120, 'Chad', 'chad.gif');
INSERT INTO `countries` VALUES (121, 'Comoros', 'comoros.gif');
INSERT INTO `countries` VALUES (122, 'Cyprus', 'cyprus.gif');
INSERT INTO `countries` VALUES (123, 'Democratic Republic of the Congo', 'demrepcongo.gif');
INSERT INTO `countries` VALUES (124, 'Djibouti', 'djiboutil.gif');
INSERT INTO `countries` VALUES (125, 'Dominica', 'dominica.gif');
INSERT INTO `countries` VALUES (126, 'El Salvador', 'elsalvado.gif');
INSERT INTO `countries` VALUES (127, 'Equatorial Guinea', 'eq_guinea.gif');
INSERT INTO `countries` VALUES (128, 'Eritrea', 'eritrea.gif');
INSERT INTO `countries` VALUES (129, 'Ethiopia', 'ethiopia.gif');
INSERT INTO `countries` VALUES (130, 'Fiji', 'fiji.gif');
INSERT INTO `countries` VALUES (131, 'Gabon', 'gabon.gif');
INSERT INTO `countries` VALUES (132, 'Gambia', 'gambia.gif');
INSERT INTO `countries` VALUES (133, 'Georgia', 'georgia.gif');
INSERT INTO `countries` VALUES (134, 'Ghana', 'ghana.gif');
INSERT INTO `countries` VALUES (135, 'Grenada', 'grenada.gif');
INSERT INTO `countries` VALUES (136, 'St. Vincent & the Grenadines', 'grenadines.gif');
INSERT INTO `countries` VALUES (137, 'Guinea-Bissau', 'guineabissau.gif');
INSERT INTO `countries` VALUES (138, 'Guinea', 'guineal.gif');
INSERT INTO `countries` VALUES (139, 'Guyana', 'guyana.gif');
INSERT INTO `countries` VALUES (140, 'Haiti', 'haiti.gif');
INSERT INTO `countries` VALUES (141, 'Hong Kong', 'hong_kong.gif');
INSERT INTO `countries` VALUES (142, 'Indonesia', 'indonesia.gif');
INSERT INTO `countries` VALUES (143, 'Iran', 'iran.gif');
INSERT INTO `countries` VALUES (144, 'Iraq', 'iraq.gif');
INSERT INTO `countries` VALUES (145, 'Ivory Coast', 'ivorycoast.gif');
INSERT INTO `countries` VALUES (146, 'Jordan', 'jordan.gif');
INSERT INTO `countries` VALUES (147, 'Kazakhstan', 'kazakhstan.gif');
INSERT INTO `countries` VALUES (148, 'Kenya', 'kenya.gif');
INSERT INTO `countries` VALUES (149, 'Kuwait', 'kuwait.gif');
INSERT INTO `countries` VALUES (150, 'Liberia', 'liberia.gif');
INSERT INTO `countries` VALUES (151, 'Libya', 'libya.gif');
INSERT INTO `countries` VALUES (152, 'Liechtenstein', 'liechtenstein.gif');
INSERT INTO `countries` VALUES (153, 'Macao', 'macau.gif');
INSERT INTO `countries` VALUES (154, 'Madagascar', 'madagascar.gif');
INSERT INTO `countries` VALUES (155, 'Malawi', 'malawi.gif');
INSERT INTO `countries` VALUES (156, 'Maldives', 'maldives.gif');
INSERT INTO `countries` VALUES (157, 'Mali', 'mali.gif');
INSERT INTO `countries` VALUES (158, 'Malta', 'malta.gif');
INSERT INTO `countries` VALUES (159, 'Mauritania', 'mauritania.gif');
INSERT INTO `countries` VALUES (160, 'Mauritius', 'mauritius.gif');
INSERT INTO `countries` VALUES (161, 'Micronesia', 'micronesia.gif');
INSERT INTO `countries` VALUES (162, 'Monaco', 'monaco.gif');
INSERT INTO `countries` VALUES (163, 'Mongolia', 'mongolia.gif');
INSERT INTO `countries` VALUES (164, 'Morocco', 'morocco.gif');
INSERT INTO `countries` VALUES (165, 'Mozambique', 'mozambique.gif');
INSERT INTO `countries` VALUES (166, 'Namibia', 'namibia.gif');
INSERT INTO `countries` VALUES (167, 'Nepal', 'nepal.gif');
INSERT INTO `countries` VALUES (168, 'Nicaragua', 'nicaragua.gif');
INSERT INTO `countries` VALUES (169, 'Niger', 'niger.gif');
INSERT INTO `countries` VALUES (170, 'North Korea', 'north_korea.gif');
INSERT INTO `countries` VALUES (171, 'Oman', 'oman.gif');
INSERT INTO `countries` VALUES (172, 'Panama', 'panama.gif');
INSERT INTO `countries` VALUES (173, 'Papua New Guinea', 'papuanewguinea.gif');
INSERT INTO `countries` VALUES (174, 'Qatar', 'qatar.gif');
INSERT INTO `countries` VALUES (175, 'Rwanda', 'rawanda.gif');
INSERT INTO `countries` VALUES (176, 'Sao Tome and Principe', 'sao_tome.gif');
INSERT INTO `countries` VALUES (177, 'Saudi Arabia', 'saudiarabia.gif');
INSERT INTO `countries` VALUES (178, 'Sierra Leone', 'sierraleone.gif');
INSERT INTO `countries` VALUES (179, 'Slovakia', 'slovakia.gif');
INSERT INTO `countries` VALUES (180, 'Solomon Islands', 'solomon_islands.gif');
INSERT INTO `countries` VALUES (181, 'Somalia', 'somalia.gif');
INSERT INTO `countries` VALUES (182, 'South Korea', 'south_korea.gif');
INSERT INTO `countries` VALUES (183, 'Sri Lanka', 'srilanka.gif');
INSERT INTO `countries` VALUES (184, 'St. Kitts & Nevis', 'stkitts_nevis.gif');
INSERT INTO `countries` VALUES (185, 'Saint Lucia', 'stlucia.gif');
INSERT INTO `countries` VALUES (186, 'Sudan', 'sudan.gif');
INSERT INTO `countries` VALUES (187, 'Suriname', 'suriname.gif');
INSERT INTO `countries` VALUES (188, 'Syria', 'syria.gif');
INSERT INTO `countries` VALUES (189, 'Tajikistan', 'tajikistan.gif');
INSERT INTO `countries` VALUES (190, 'Tanzania', 'tanzania.gif');
INSERT INTO `countries` VALUES (191, 'Tonga', 'tonga.gif');
INSERT INTO `countries` VALUES (192, 'Tunisia', 'tunisia.gif');
INSERT INTO `countries` VALUES (193, 'Tuvalu', 'tuvala.gif');
INSERT INTO `countries` VALUES (194, 'United Arab Emirates', 'uae.gif');
INSERT INTO `countries` VALUES (195, 'Uganda', 'uganda.gif');
INSERT INTO `countries` VALUES (196, 'Yemen', 'yemen.gif');
INSERT INTO `countries` VALUES (197, 'Zaire', 'zaire.gif');
INSERT INTO `countries` VALUES (198, 'Zambia', 'zambia.gif');
INSERT INTO `countries` VALUES (199, 'Zimbabwe', 'zimbabwe.gif');
|
