WM 2018 Kaderdaten

microspick · 3. Juni 2018

Brasilien

Code

(2200, 22, 'T', 23, 'Santana de Moraes', 'Ederson', 'Ederson', 1, 0, '1993-08-17', 'Manchester City', 'England'),
(2201, 22, 'T', 1, 'Ramses Becker', 'Alisson', 'Alisson', 24, 0, '1992-10-02', 'AS Rom', 'Italien'),
(2202, 22, 'T', 0, 'Ramos', 'Cássio', 'Cássio', 1, 0, '1987-06-06', 'Corinthians Sao Paulo', 'Brasilien'),
(2203, 22, 'V', 13, 'Aoás Corrêa', 'Marcos', 'Marquinhos', 24, 0, '1994-05-14', 'FC Paris Saint-Germain', 'Frankreich'),
(2204, 22, 'V', 14, 'Silva', 'Thiago', '', 68, 5, '1984-09-22', 'FC Paris Saint-Germain', 'Frankreich'),
(2205, 22, 'V', 3, 'de Souza Filho', 'João Miranda', 'Miranda', 44, 2, '1984-09-07', 'Inter Mailand', 'Italien'),
(2206, 22, 'V', 20, 'Geromel', 'Pedro', '', 2, 0, '1985-09-21', 'Grêmio Porto Alegre', 'Brasilien'),
(2207, 22, 'V', 12, 'da Silva Júnior', 'Marcelo Vieira', 'Marcelo', 51, 5, '1988-05-12', 'Real Madrid', 'Spanien'),
(2208, 22, 'V', 0, 'Luís', 'Filipe', '', 31, 2, '1985-08-09', 'Atletico Madrid', 'Spanien'),
(2209, 22, 'V', 14, 'Luiz da Silva', 'Danilo', 'Danilo', 16, 1, '1991-07-15', 'Manchester City', 'England'),
(2210, 22, 'V', 22, 'Conserva Lemos', 'Fágner', 'Fágner', 4, 0, '1989-06-11', 'Corinthians Sao Paulo', 'Brasilien'),
(2211, 22, 'M', 5, 'Casemiro', 'Carlos Henrique', 'Casimero', 22, 0, '1992-02-23', 'Real Madrid', 'Spanien'),
(2212, 22, 'M', 17, 'Luis Roza', 'Fernando', 'Fernandinho', 41, 2, '1985-05-04', 'Manchester City', 'England'),
(2213, 22, 'M', 15, 'Bezerra Maciel Júnior', 'José Paulo', 'Paulinho', 47, 12, '1988-07-25', 'FC Barcelona', 'Spanien'),
(2214, 22, 'M', 18, 'de Paula Santos', 'Frederico Rodrigues', 'Fred', 7, 0, '1993-03-05', 'Shakhtar Donetsk', 'Ukraine'),
(2215, 22, 'M', 8, 'Augusto', 'Renato', '', 28, 5, '1988-02-08', 'Beijing Sinobo Guoan', 'China'),
(2216, 22, 'A', 0, 'da Silva Santos Júnior', 'Neymar', 'Neymar', 83, 53, '1992-02-05', 'FC Paris Saint-Germain', 'Frankreich'),
(2217, 22, 'A', 11, 'Coutinho', 'Philippe', '', 35, 9, '1992-06-12', 'FC Barcelona', 'Spanien'),
(2218, 22, 'A', 21, 'Barcellos Freda', 'Taison', 'Taison', 6, 1, '1988-01-13', 'Shakhtar Donetsk', 'Ukraine'),
(2219, 22, 'A', 7, 'de Souza', 'Douglas Costa', 'Douglas Costa', 24, 3, '1990-09-14', 'Juventus Turin', 'Italien'),
(2220, 22, 'A', 19, 'da Silva', 'Willian Borges', 'Willian', 54, 8, '1988-08-09', 'FC Chelsea', 'England'),
(2221, 22, 'A', 20, 'Firmino', 'Roberto', '', 18, 5, '1991-10-02', 'FC Liverpool', 'England'),
(2222, 22, 'A', 9, 'de Jesus', 'Gabriel Fernando', 'Gabriel Jesus', 15, 9, '1997-04-03', 'Manchester City', 'England');

Alles anzeigen

ingoh · 3. Juni 2018

Costa Rica

Code

(3400, 34, 'T', 1, 'Keylor', 'Navas', '', 78, 0, '1986-12-12', 'Real Madrid', 'Spanien'),
(3401, 34, 'T', 23, 'Moreira', 'Leonel', '', 7, 0, '1990-04-02', 'CS Herediano', 'Costa Rica'),
(3402, 34, 'T', 0, 'Pemberton', 'Patrick', '', 38, 0, '1982-04-24', 'LD Alajuelense', 'Costa Rica'),
(3403, 34, 'V', 3, 'González', 'Giancarlo', '', 66, 2, '1988-02-08', 'FC Bologna', 'Italien'),
(3404, 34, 'V', 6, 'Duarte', 'Óscar', '', 36, 2, '1989-06-03', 'Espanyol Barcelona', 'Spanien'),
(3405, 34, 'V', 19, 'Waston', 'Kendall', '', 24, 2, '1988-01-01', 'Vancouver Whitecaps', 'Kanada'),
(3406, 34, 'V', 15, 'Calvo', 'Francisco', '', 35, 3, '1992-07-08', 'Minnesota United FC', 'USA'),
(3407, 34, 'V', 22, 'Gutiérrez', 'Kenner', '', 9, 0, '1989-06-09', 'LD Alajuelense', 'Costa Rica'),
(3408, 34, 'V', 2, 'Acosta', 'Jhonny', '', 66, 2, '1983-07-21', 'Rionegro Águilas', 'Kolumbien'),
(3409, 34, 'V', 8, 'Oviedo', 'Bryan', '', 41, 1, '1990-02-18', 'AFC Sunderland', 'England'),
(3410, 34, 'V', 0, 'Matarrita', 'Ronald', '', 21, 2, '1994-07-09', 'New York City FC', 'USA'),
(3411, 34, 'V', 16, 'Gamboa', 'Cristian', '', 64, 3, '1989-10-24', 'Celtic Glasgow', 'Schottland'),
(3412, 34, 'V', 4, 'Smith', 'Ian', '', 1, 0, '1998-03-06', 'IFK Norrköping', 'Schweden'),
(3413, 34, 'M', 20, 'Guzmán', 'David', '', 43, 0, '1990-02-18', 'Portland Timbers', 'USA'),
(3414, 34, 'M', 17, 'Tejeda', 'Yeltsin', '', 47, 0, '1992-03-17', 'FC Lausanne-Sport', 'Schweiz'),
(3415, 34, 'M', 0, 'Azofeifa', 'Randall', '', 58, 3, '1984-12-30', 'CS Herediano', 'Costa Rica'),
(3416, 34, 'M', 5, 'Borges', 'Celso', '', 109, 18, '1988-05-27', 'Deportivo La Coruna', 'Spanien'),
(3417, 34, 'M', 14, 'Azofeifa', 'Wilmer', '', 1, 0, '1994-06-04', 'Santos de Guápiles FC', 'Costa Rica'),
(3418, 34, 'M', 0, 'Venegas', 'Johan', '', 44, 9, '1988-11-27', 'Deportivo Saprissa', 'Costa Rica'),
(3419, 34, 'M', 10, 'Ruíz', 'Bryan', '', 109, 23, '1985-08-18', 'Sporting Lissabon', 'Portugal'),
(3420, 34, 'M', 13, 'Wallace', 'Rodney', '', 29, 4, '1988-06-17', 'New York City FC', 'USA'),
(3421, 34, 'A', 12, 'Colindres', 'Daniel', '', 12, 0, '1985-01-10', 'Deportivo Saprissa', 'Costa Rica'),
(3422, 34, 'A', 0, 'Campbell', 'Joel', '', 74, 14, '1992-06-26', 'Real Betis Sevilla', 'Spanien'),
(3423, 34, 'A', 0, 'Bolaños', 'Christian', '', 80, 7, '1984-05-17', 'Deportivo Saprissa', 'Costa Rica'),
(3424, 34, 'A', 21, 'Ureña', 'Marcos', '', 7, 3, '1990-03-05', 'Los Angeles FC', 'USA'),
(3425, 34, 'A', 0, 'Ramírez', 'David', '', 17, 4, '1993-05-28', 'Deportivo Saprissa', 'Costa Rica'),
(3426, 34, 'A', 9, 'Ruiz', 'Yendrick', '', 7, 0, '1987-04-12', 'CS Herediano', 'Costa Rica');

Alles anzeigen

microspick · 3. Juni 2018

Serbien

Code

(3000, 30, 'T', 12, 'Dmitrovic', 'Marko', '', 2, 0, '1992-01-24', 'SD Eibar', 'Spanien'),
(3001, 30, 'T', 23, 'Rajkovic', 'Predrag', '', 7, 0, '1995-10-31', 'Maccabi Tel Aviv', 'Israel'),
(3002, 30, 'T', 1, 'Stojkovic', 'Vladimir', '', 79, 0, '1983-07-28', 'FK Partizan Belgrad ', 'Serbien'),
(3003, 30, 'V', 13, 'Spajic', 'Uros', '', 5, 0, '1993-02-13', 'RSC Anderlecht', 'Belgien'),
(3004, 30, 'V', 13, 'Veljkovic', 'Milos', '', 2, 0, '1995-09-26', 'SV Werder Bremen', 'Deutschland'),
(3005, 30, 'V', 25, 'Milenkovic', 'Nikola', '', 1, 0, '1997-10-12', 'AC Florenz', 'Italien'),
(3006, 30, 'V', 6, 'Ivanovic', 'Branislav', '', 102, 12, '1984-02-22', 'Zenit St. Petersburg', 'Russland'),
(3007, 30, 'V', 3, 'Tosic', 'Dusko', '', 22, 1, '1985-01-19', 'Besiktas Istanbul', 'Türkei'),
(3008, 30, 'V', 11, 'Kolarov', 'Aleksandar', '', 74, 10, '1985-11-10', 'AS Rom', 'Italien'),
(3009, 30, 'V', 27, 'Rodic', 'Milan', '', 0, 0, '1991-04-02', 'Roter Stern Belgrad', 'Serbien'),
(3010, 30, 'V', 2, 'Rukavina', 'Antonio', '', 45, 0, '1984-01-26', 'FC Villarreal', 'Spanien'),
(3011, 30, 'M', 21, 'Matic', 'Nemanja', '', 38, 2, '1988-08-01', 'Manchester United', 'England'),
(3012, 30, 'M', 4, 'Milivojevic', 'Luka', '', 26, 1, '1991-04-07', 'Crystal Palace', 'England'),
(3013, 30, 'M', 19, 'Milinkovic-Savic', 'Sergej', '', 2, 0, '1995-02-27', 'Lazio Rom', 'Italien'),
(3014, 30, 'M', 18, 'Grujic', 'Marko', '', 6, 0, '1996-04-13', 'FC Liverpool', 'England'),
(3015, 30, 'M', 10, 'Tadic', 'Dusan', '', 51, 13, '1988-11-20', 'FC Southampton', 'England'),
(3016, 30, 'M', 22, 'Ljajic', 'Adem', '', 27, 5, '1991-09-29', 'FC Turin', 'Italien'),
(3017, 30, 'M', 7, 'Zivkovic', 'Andrija', '', 9, 0, '1996-07-11', 'Benfica Lissabon', 'Portugal'),
(3018, 30, 'A', 17, 'Kostic', 'Filip', '', 21, 2, '1992-11-01', 'Hamburger SV', 'Deutschland'),
(3019, 30, 'A', 0, 'Radonjic', 'Nemanja', '', 1, 0, '1996-02-15', 'Roter Stern Belgrad', 'Serbien'),
(3020, 30, 'A', 9, 'Mitrovic', 'Aleksandar', '', 35, 13, '1994-09-16', 'Newcastle United', 'England'),
(3021, 30, 'A', 8, 'Prijovic', 'Aleksandar', '', 8, 1, '1990-04-21', 'PAOK Thessaloniki', 'Griechenland'),
(3022, 30, 'A', 26, 'Jovic', 'Luka', '', 0, 0, '1997-12-23', 'Eintracht Frankfurt', 'Deutschland');

Alles anzeigen

FiedlWdd · 3. Juni 2018

Tunesien

Code

(6600, 66, 'T', 40, 'Hassen', 'Mouez', '', 3, 0, '1995-03-05', 'LB Châteauroux', 'Frankreich'),
(6601, 66, 'T', 1, 'Ben Mustapha', 'Farouk', '', 14, 0, '1989-07-01', 'Al-Shabab Riad', 'Saudi-Arabien'),
(6602, 66, 'T', 16, 'Mathlouthi', 'Aymen', 'Balbouli', 70, 0, '1984-09-14', 'Al-Batin', 'Saudi-Arabien'),
(6603, 66, 'V', 28, 'Bronn', 'Dylan', '', 4, 0, '1995-06-19', 'KAA Gent', 'Belgien'),
(6604, 66, 'V', 3, 'Benalouane', 'Yohan', '', 3, 0, '1987-03-28', 'Leicester City', 'England'),
(6605, 66, 'V', 4, 'Meriah', 'Yassine', '', 16, 1, '1993-07-02', 'Club Sportif Sfaxien', 'Tunesien'),
(6606, 66, 'V', 2, 'Ben Youssef', 'Syam', '', 43, 1, '1989-03-31', 'Kasimpasa', 'Türkei'),
(6607, 66, 'V', 6, 'Bedoui', 'Rami', '', 10, 0, '1990-01-19', 'Etoile Sportive du Sahel', 'Tunesien'),
(6608, 66, 'V', 5, 'Haddadi', 'Oussama', '', 8, 0, '1992-01-28', 'FCO Dijon', 'Frankreich'),
(6609, 66, 'V', 12, 'Maâloul', 'Ali', '', 48, 0, '1990-01-01', 'El Ahly Kairo', 'Ägypten'),
(6610, 66, 'V', 21, 'Nagguez', 'Hamdi', '', 17, 0, '1992-10-28', 'Zamalek SC', 'Ägypten'),
(6611, 66, 'M', 17, 'Skhiri', 'Ellyes', '', 4, 0, '1995-05-10', 'HSC Montpellier', 'Frankreich'),
(6612, 66, 'M', 14, 'Ben Amor', 'Mohamed Amine', '', 26, 2, '1992-05-03', 'Al-Ahli Dschidda', 'Saudi-Arabien'),
(6613, 66, 'M', 25, 'Khalil', 'Ahmed', '', 2, 0, '1994-12-21', 'Club Africain Tunis', 'Tunesien'),
(6614, 66, 'M', 13, 'Sassi', 'Ferjani', '', 40, 3, '1992-03-18', 'Al-Nasr Riad', 'Saudi-Arabien'),
(6615, 66, 'M', 20, 'Chaalali', 'Ghaylène', '', 7, 1, '1994-02-28', 'Esperance Tunis', 'Tunesien'),
(6616, 66, 'M', 10, 'Khazri', 'Wahbi', '', 37, 12, '1991-02-08', 'FC Stade Rennes', 'Frankreich'),
(6617, 66, 'M', 7, 'Khaoui', 'Saîf-Eddine', '', 4, 0, '1995-04-27', 'ES Troyes AC', 'Frankreich'),
(6618, 66, 'A', 23, 'Sliti', 'Naïm', '', 19, 3, '1992-07-27', 'FCO Dijon', 'Frankreich'),
(6619, 66, 'A', 18, 'Srarfi', 'Bassem', '', 4, 0, '1997-06-25', 'OGC Nizza', 'Frankreich'),
(6620, 66, 'A', 8, 'Ben Youssef', 'Fakhreddine', '', 38, 5, '1991-06-23', 'Al-Ettifaq', 'Saudi-Arabien'),
(6621, 66, 'A', 24, 'Badri', 'Anice', '', 9, 3, '1990-09-18', 'Esperance Tunis', 'Tunesien'),
(6622, 66, 'A', 11, 'Khalifa', 'Saber', '', 44, 7, '1986-10-14', 'Club Africain Tunis', 'Tunesien'),

Alles anzeigen

stegmuellerm · 3. Juni 2018

Und hier ist der aktuelle komplette Dump für diejenigen welche sich nicht auf die Suche von Tippfehlern machen wollen und auch schon mal die Daten zu testen

Das ist der Stand bis einschlißlich Tunesien

microspick · 3. Juni 2018

Panama

Code

(8100, 81, 'T', 0, 'Penedo', 'Jaime', '', 130, 0, '1981-09-26', 'Dinamo Bukarest', 'Rumänien'),
(8101, 81, 'T', 12, 'Calderón', 'José', '', 31, 0, '1985-08-14', 'UD Universitario', 'Panama'),
(8102, 81, 'T', 1, 'Rodríguez', 'Álex', '', 6, 0, '1990-08-05', 'San Francisco FC', 'Panama'),
(8103, 81, 'V', 23, 'Baloy', 'Felipe', '', 99, 3, '1981-02-24', 'CSD Municipal', 'Guatemala'),
(8104, 81, 'V', 5, 'Torres', 'Román', '', 106, 10, '1986-03-20', 'Seattle Sounders FC', 'Vereinigte Staaten'),
(8105, 81, 'V', 13, 'Machado', 'Adolfo', '', 74, 1, '1985-02-14', 'Houston Dynamo', 'Vereinigte Staaten'),
(8106, 81, 'V', 3, 'Cummings', 'Hárold', '', 51, 0, '1992-03-01', 'San Jose Earthquakes', 'Vereinigte Staaten'),
(8107, 81, 'V', 4, 'Escobar', 'Fidel', '', 21, 1, '1995-01-09', 'New York Red Bulls', 'Vereinigte Staaten'),
(8108, 81, 'V', 17, 'Ovalle', 'Luis', '', 24, 0, '1988-09-07', 'CD Olimpia', 'Honduras'),
(8109, 81, 'V', 0, 'Davis', 'Éric', '', 37, 0, '1991-03-31', 'DAC Dunajska Streda', 'Tschechoslowakische Republik'),
(8110, 81, 'V', 2, 'Murillo', 'Michael', '', 21, 2, '1996-02-11', 'New York Red Bulls', 'Vereinigte Staaten'),
(8111, 81, 'M', 20, 'Godoy', 'Aníbal', '', 86, 1, '1990-02-10', 'San Jose Earthquakes', 'Vereinigte Staaten'),
(8112, 81, 'M', 6, 'Gómez', 'Gabriel', '', 141, 12, '1984-05-29', 'Atlético Bucaramanga', 'Kolumbien'),
(8113, 81, 'M', 11, 'Cooper', 'Armando', '', 98, 7, '1987-11-26', 'Club Universidad de Chile', 'Chile'),
(8115, 81, 'M', 22, 'Rodríguez', 'José Luis', '', 0, 0, '1998-06-19', 'KAA Gent Reserve', 'Belgien'),
(8116, 81, 'M', 8, 'Bárcenas', 'Yoel', '', 27, 0, '1993-10-23', 'Cafetaleros de Tapachula', 'Mexiko'),
(8117, 81, 'A', 25, 'Díaz', 'Ismael', '', 10, 2, '1997-05-12', 'Deportivo de La Coruña B', 'Spanien'),
(8118, 81, 'A', 14, 'Pimentel', 'Valentin', '', 21, 1, '1991-05-30', 'CD Plaza Amador', 'Panama'),
(8119, 81, 'A', 7, 'Pérez', 'Blas', '', 115, 40, '1981-03-13', 'CSD Municipal', 'Guatemala'),
(8120, 81, 'A', 9, 'Torres', 'Gabriel', '', 71, 15, '1988-10-31', 'Huachipato FC', 'Chile'),
(8121, 81, 'A', 16, 'Arroyo', 'Abdiel', '', 33, 5, '1993-12-13', 'LD Alajuelens', 'Costa Rica'),
(8122, 81, 'A', 18, 'Tejada', 'Luis', '', 104, 42, '1982-03-28', 'Sport Boys Callao', 'Peru'),
(8123, 81, 'A', 18, 'Avila', 'Ricardo', '', 5, 0, '1997-02-04', 'KAA Gent Reserve', 'Belgien');

Alles anzeigen

noschwabe · 3. Juni 2018

Australien

Code

(1800, 18, 'T', 1, 'Ryan', 'Mathew', '', 43, 0, '1992-04-08', 'Brighton & Hove Albion', 'England'),
(1801, 18, 'T', 12, 'Jones', 'Bradley', '', 5, 0, '1982-03-19', 'Feyenoord', 'Niederlande'),
(1802, 18, 'T', 18, 'Vuković', 'Daniel', '', 1, 0, '1985-03-27', 'KRC Genk', 'Belgien'),
(1803, 18, 'V', 16, 'Behich', 'Aziz ', '', 22, 2, '1990-12-16', 'Bursaspor', 'Türkei'),
(1804, 18, 'V', 2, 'Degenek', 'Miloš', '', 18, 0, '1994-04-28', 'Yokohama F. Marinos', 'Japan'),
(1805, 18, 'V', 6, 'Jurman', 'Matthew', '', 4, 0, '1989-12-08', 'Suwon Bluewings', 'Südkorea '),
(1806, 18, 'A', 14, 'Maclaren', 'Jamie', '', 6, 0, '1993-07-29', 'Hibernian FC', 'Schottland'),
(1807, 18, 'V', 3, 'Meredith', 'James', '', 2, 0, '1995-09-03', 'Millwall FC', 'England'),
(1808, 18, 'V', 5, 'Milligan', 'Mark', '', 69, 6, '1985-08-04', 'Al Ahli SFC', 'Saudi-Arabien '),
(1809, 18, 'V', 19, 'Risdon', 'Joshua', '', 7, 0, '1992-07-27', 'Western Sydney Wanderers', 'Australien'),
(1810, 18, 'V', 20, 'Sainsbury', 'Trent Lucas', '', 34, 3, '1990-05-18', 'Grasshopper Club Zürich', 'Schweiz'),
(1811, 18, 'A', 21, 'Petratos', 'Dimitri', '', 2, 0, '1992-11-10', 'Newcastle United Jets', 'Australien'),
(1812, 18, 'M', 4, 'Cahill', 'Tim', '', 106, 51, '1979-12-06', 'Millwall FC', 'England'),
(1813, 18, 'M', 22, 'Irvine', 'Jackson', '', 18, 2, '1993-03-07', 'Hull City', 'England'),
(1814, 18, 'M', 15, 'Jedinak', 'Michael John', '', 75, 13, '1984-08-03', 'Aston Villa', 'England'),
(1815, 18, 'M', 10, 'Kruse', 'Robbie', '', 63, 5, '1988-10-05', 'VfL Bochum', 'Deutschland'),
(1816, 18, 'M', 7, 'Leckie', 'Mathew Allan', '', 52, 8, '1991-02-04', 'Hertha BSC', 'Deutschland'),
(1817, 18, 'M', 8, 'Luongo', 'Massimo', '', 6, 2, '1992-09-25', 'Queens Park Rangers', 'England'),
(1818, 18, 'M', 13, 'Mooy', 'Aaron', '', 33, 5, '1989-09-15', 'Huddersfield Town', 'England'),
(1819, 18, 'M', 11, 'Nabbout', 'Andrew', '', 3, 1, '1992-12-17', 'Urawa Red Diamonds', 'Japan'),
(1820, 18, 'M',23, 'Rogić', 'Tomas Petar', '', 36, 7, '1992-12-16', 'Celtic FC', 'Schottland'),
(1822, 18, 'A', 17, 'Arzani', 'Daniel', '', 1, 0, '1999-01-04', 'Melbourne City FC', 'Australien'),
(1823, 18, 'A', 9, 'Jurić', 'Tomi', '', 34, 8, '1991-07-22', 'FC Luzern', 'Schweiz'),

Alles anzeigen

microspick · 3. Juni 2018

Zitat von noschwabe

Australien

Code

(1800, 18, 'T', 1, 'Ryan', 'Mathew', '', 43, 0, '1992-04-08', 'Brighton & Hove Albion', 'England'),

(1801, 18, 'T', 25, 'Jones', 'Bradley', '', 5, 0, '1982-03-19', 'Feyenoord', 'Niederlande'),

(1802, 18, 'T', 0, 'Vuković', 'Daniel', '', 1, 0, '1985-03-27', 'KRC Genk', 'Belgien'),

(1803, 18, 'V', 23, 'Behich', 'Aziz ', '', 22, 2, '1990-12-16', 'Bursaspor', 'Türkei'),

(1804, 18, 'V', 2, 'Degenek', 'Miloš', '', 18, 0, '1994-04-28', 'Yokohama F. Marinos', 'Japan'),

(1805, 18, 'V', 6, 'Jurman', 'Matthew', '', 4, 0, '1989-12-08', 'Suwon Bluewings', 'Südkorea '),

(1806, 18, 'V', 26, 'Karačić', 'Fran', '', 0, 0, '1996-05-12', 'Lokomotiva Zagreb', 'Kroatien'),

(1807, 18, 'V', 3, 'Meredith', 'James', '', 2, 0, '1995-09-03', 'Millwall FC', 'England'),

(1808, 18, 'V', 5, 'Milligan', 'Mark', '', 69, 6, '1985-08-04', 'Al Ahli SFC', 'Saudi-Arabien '),

(1809, 18, 'V', 4, 'Risdon', 'Joshua', '', 7, 0, '1992-07-27', 'Western Sydney Wanderers', 'Australien'),

(1810, 18, 'V', 20, 'Sainsbury', 'Trent Lucas', '', 34, 3, '1990-05-18', 'Grasshopper Club Zürich', 'Schweiz'),

(1811, 18, 'M', 0, 'Brillante', 'Joshua ', '', 5, 0, '1993-03-25', 'Sydney FC', 'Australien'),

(1812, 18, 'M', 7, 'Cahill', 'Tim', '', 106, 51, '1979-12-06', 'Millwall FC', 'England'),

(1813, 18, 'M', 0, 'Irvine', 'Jackson', '', 18, 2, '1993-03-07', 'Hull City', 'England'),

(1814, 18, 'M', 15, 'Jedinak', 'Michael John', '', 75, 13, '1984-08-03', 'Aston Villa', 'England'),

(1815, 18, 'M', 17, 'Kruse', 'Robbie', '', 63, 5, '1988-10-05', 'VfL Bochum', 'Deutschland'),

(1816, 18, 'M', 11, 'Leckie', 'Mathew Allan', '', 52, 8, '1991-02-04', 'Hertha BSC', 'Deutschland'),

(1817, 18, 'M', 6, 'Luongo', 'Massimo', '', 6, 2, '1992-09-25', 'Queens Park Rangers', 'England'),

(1818, 18, 'M', 10, 'Mooy', 'Aaron', '', 33, 5, '1989-09-15', 'Huddersfield Town', 'England'),

(1819, 18, 'M', 19, 'Nabbout', 'Andrew', '', 3, 1, '1992-12-17', 'Urawa Red Diamonds', 'Japan'),

(1820, 18, 'M',18, 'Rogić', 'Tomas Petar', '', 36, 7, '1992-12-16', 'Celtic FC', 'Schottland'),

(1821, 18, 'M', 0, 'Troisi', 'James', '', 39, 5, '1988-07-03', 'Melbourne Victory', 'Australien'),

(1822, 18, 'A', 14, 'Arzani', 'Daniel', '', 1, 0, '1999-01-04', 'Melbourne City FC', 'Australien'),

(1823, 18, 'A', 9, 'Jurić', 'Tomi', '', 34, 8, '1991-07-22', 'FC Luzern', 'Schweiz'),

(1824, 18, 'A', 0, 'Maclaren', 'Jamie', '', 6, 0, '1993-07-29', 'Hibernian FC', 'Schottland'),

(1825, 18, 'A', 0, 'Petratos', 'Dimitri', '', 2, 0, '1992-11-10', 'Newcastle United Jets', 'Australien'),

(1826, 18, 'A', 13, 'Rukavytsya', 'Nikita', '', 21, 1, '1987-06-22', 'Maccabi Haifa', 'Israel'),

Alles anzeigen

Zu spät gesehen. Hatte den Kader auch eben fertig

Hier meiner zum Vergleich aus transfermarkt.de

Code

(1800, 18, 'T', 1, 'Ryan', 'Mathew', '', 43, 0, '1992-04-08', 'Brighton & Hove Albion', 'England'),
(1801, 18, 'T', 12, 'Jones', 'Brad', '', 5, 0, '1982-03-19', 'Feyenoord Rotterdam', 'Niederlande'),
(1802, 18, 'T', 18, 'Vukovic', 'Danny', '', 1, 0, '1985-03-27', 'KRC Genk', 'Belgien'),
(1803, 18, 'V', 6, 'Jurman', 'Matthew', '', 4, 0, '1989-12-08', 'Suwon Samsung Bluewings FC', 'Japan'),
(1804, 18, 'V', 20, 'Sainsbury', 'Trent', '', 34, 3, '1992-01-05', 'Grasshopper Club Zürich', 'Schweiz'),
(1805, 18, 'V', 2, 'Degenek', 'Milos', '', 18, 0, '1994-04-28', 'Yokohama F. Marinos', 'Japan'),
(1806, 18, 'V', 16, 'Behich', 'Aziz', '', 22, 2, '1990-12-16', 'Bursaspor', 'Türkei'),
(1807, 18, 'V', 3, 'Meredith', 'James', '', 2, 0, '1988-04-04', 'FC Millwall', 'England'),
(1808, 18, 'V', 19, 'Risdon', 'Joshua', '', 7, 0, '1992-07-27', 'Western Sydney Wanderers', 'Australien'),
(1809, 18, 'M', 15, 'Jedinak', 'Mile', '', 75, 18, '1984-08-03', 'Aston Villa', 'England'),
(1810, 18, 'M', 22, 'Irvine', 'Jackson', '', 18, 2, '1993-07-03' 'Hull City', 'England'),
(1811, 18, 'M', 5, 'Milligan', 'Mark', '', 70, 6, '1985-08-04', 'Al-Ahli Dschidda', 'Saudi Arabien'),
(1812, 18, 'M', 13, 'Mooy', 'Aaron', '', 33, 5, '1990-09-15', 'Huddersfield Town', 'England'),
(1813, 18, 'M', 21, 'Luongo', 'Massimo', '', 35, 5, '1992-09-25', 'Queens Park Rangers', 'England'),
(1814, 18, 'M', 23, 'Rogic', 'Tom', '', 36, 7, '1992-12-16', 'Celtic Glasgow', 'Schottland'),
(1815, 18, 'M', 4, 'Cahill', 'Tim', '', 105, 50, '1979-12-06', 'FC Millwall', 'England'),
(1816, 18, 'M', 24, 'Petratos', 'Dimitri', '', 2, 0, '1992-11-10', 'Newcastle United Jets', 'Australien'),
(1817, 18, 'A', 10, 'Kruse', 'Robbie', '', 63, 5, '1988-10-05', 'VfL Bochum', 'Deutschland'),
(1818, 18, 'A', 7, 'Leckie', 'Mathew', '', 52, 8, '1991-02-04', 'Hertha BSC', 'Deutschland'),
(1819, 18, 'A', 26, 'Arzani', 'Daniel', '', 1, 0, '1999-01-04', 'Melbourne City FC', 'Australien'),
(1820, 18, 'A', 9, 'Juric', 'Tomi', '', 34, 8, '1991-07-22', 'FC Luzern', 'Schweiz'),
(1821, 18, 'A', 30, 'Maclaren', 'Jamie', '', 6, 0, '1993-07-29', 'SV Darmstadt 98', 'Deutschland'),
(1822, 18, 'A', 11, 'Nabbout', 'Andrew', '', 3, 1, '1992-12-17', 'Urawa Red Diamonds', 'Japan');

Alles anzeigen

ingoh · 3. Juni 2018

Peru

Code

(4500, 45, 'T', 1, 'Gallese', 'Pedro', '', 37, 0, '1990-04-23', 'Tiburones Rojos de Veracruz', 'Mexiko'),
(4501, 45, 'T', 12, 'Cáceda', 'Carlos', '', 6, 0, '1991-09-27', 'Deportivo Municipal', 'Peru'),
(4502, 45, 'T', 21, 'Carvallo', 'José', '', 5, 0, '1986-03-01', 'Club UTC', 'Peru'),
(4503, 45, 'V', 15, 'Ramos', 'Christian', '', 67, 3, '1988-11-04', 'Tiburones Rojos', 'Mexiko'),
(4504, 45, 'V', 4, 'Santamaría', 'Anderson', '', 4, 0, '1992-01-10', 'Puebla FC', 'Mexiko'),
(4505, 45, 'V', 5, 'Araujo', 'Miguel', '', 7, 0, '1994-10-24', 'Alianza Lima', 'Peru'),
(4506, 45, 'V', 2, 'Rodríguez', 'Alberto', '', 73, 0, '1984-03-31', 'Junior FC', 'Kolumbien'),
(4507, 45, 'V', 6, 'Trauco', 'Miguel', '', 24, 0, '1992-07-03', 'Flamengo Rio de Janeiro', 'Brasilien'),
(4508, 45, 'V', 22, 'Loyola', 'Nilson', '', 3, 0, '1994-10-26', 'FBC Melgar', 'Peru'),
(4509, 45, 'V', 17, 'Advíncula', 'Luis', '', 64, 0, '1990-03-02', 'Lobos BUAP', 'Mexiko'),
(4510, 45, 'V', 3, 'Corzo', 'Aldo', '', 24, 0, '1989-05-20', 'Universitario de Deportes', 'Peru'),
(4511, 45, 'M', 23, 'Aquino', 'Pedro', '', 11, 0, '1995-04-13', 'Lobos BUAP', 'Mexiko'),
(4512, 45, 'M', 24, 'Cartagena', 'Wilder', '', 2, 0, '1994-09-23', 'Tiburones Rojos de Veracruz', 'Mexiko'),
(4513, 45, 'M', 13, 'Tapia', 'Renato', '', 29, 3, '1995-07-28', 'Feyenoord Rotterdam', 'Niederlande'),
(4514, 45, 'M', 19, 'Yotún', 'Yoshimar', '', 70, 2, '1990-04-07', 'Orlando City SC', 'USA'),
(4515, 45, 'M', 7, 'Hurtado', 'Paolo', '', 31, 3, '1990-07-27', 'Vitória Guimarães SC', 'Portugal'),
(4516, 45, 'M', 8, 'Cueva', 'Christian', '', 43, 7, '1991-11-23', 'FC São Paulo', 'Brasilien'),
(4517, 45, 'M', 16, 'Peña', 'Sergio', '', 5, 0, '1995-09-28', 'FC Granada', 'Spanien'),
(4518, 45, 'A', 20, 'Flores', 'Édison', '', 27, 9, '1994-05-14', 'Aalborg BK', 'Dänemark'),
(4519, 45, 'A', 18, 'Carrillo', 'André', '', 44, 4, '1991-06-14', 'FC Watford', 'England'),
(4520, 45, 'A', 10, 'Farfán', 'Jefferson', '', 81, 24, '1984-10-26', 'Lokomotiv Moskau', 'Russland'),
(4521, 45, 'A', 14, 'Polo', 'Andy', '', 15, 1, '1994-09-29', 'Portland Timbers', 'USA'),
(4522, 45, 'A', 11, 'Ruidíaz', 'Raúl', '', 29, 4, '1990-07-25', 'Monarcas Morelia', 'Mexiko'),
(4523, 45, 'A', 0, 'Guerrero', 'Paolo', '', 87, 33, '1984-01-01', 'Flamengo Rio de Janeiro', 'Brasilien');

Alles anzeigen

ingoh · 3. Juni 2018

Dänemark

Code

(2900, 29, 'T', 1, 'Schmeichel', 'Kasper', '', 34, 0, '1986-11-05', 'Leicester City', 'England'),
(2901, 29, 'T', 16, 'Lössl', 'Jonas', '', 1, 0, '1989-02-01', 'Huddersfield Town', 'England'),
(2902, 29, 'T', 22, 'Rönnow', 'Frederik', '', 7, 0, '1992-08-04', 'Bröndby IF', 'Dänemark'),
(2903, 29, 'V', 6, 'Christensen', 'Andreas', '', 15, 1, '1996-04-10', 'FC Chelsea', 'England'),
(2904, 29, 'V', 3, 'Vestergaard', 'Jannik', '', 16, 1, '1992-08-03', 'Borussia Mönchengladbach', 'Deutschland'),
(2905, 29, 'V', 4, 'Kjær', 'Simon', '', 77, 3, '1989-03-26', 'FC Sevilla', 'Spanien'),
(2906, 29, 'V', 13, 'Zanka', '', '', 12, 0, '1990-04-23', 'Huddersfield Town', 'England'),
(2907, 29, 'V', 5, 'Knudsen', 'Jonas', '', 3, 0, '1992-09-16', 'Ipswich Town', 'England'),
(2908, 29, 'V', 14, 'Dalsgaard', 'Henrik', '', 10, 0, '1989-07-27', 'FC Brentford', 'England'),
(2909, 29, 'V', 17, 'Stryger Larsen', 'Jens', '', 12, 1, '1991-02-21', 'Udinese Calcio', 'Italien'),
(2910, 29, 'M', 19, 'Schöne', 'Lasse', '', 35, 3, '1986-05-27', 'Ajax Amsterdam', 'Niederlande'),
(2911, 29, 'M', 7, 'Kvist', 'William', '', 79, 2, '1985-02-24', 'FC Kopenhagen', 'Dänemark'),
(2912, 29, 'M', 8, 'Delaney', 'Thomas', '', 26, 4, '1991-09-03', 'SV Werder Bremen', 'Deutschland'),
(2913, 29, 'M', 18, 'Lerager', 'Lukas', '', 3, 0, '1993-07-12', 'FC Girondins Bordeaux', 'Frankreich'),
(2914, 29, 'M', 2, 'Krohn-Dehli', 'Michael', '', 57, 5, '1983-06-06', 'Deportivo La Coruna', 'Spanien'),
(2915, 29, 'M', 10, 'Eriksen', 'Christian', '', 77, 21, '1992-02-14', 'Tottenham Hotspur', 'England'),
(2916, 29, 'A', 23, 'Sisto', 'Pione', '', 13, 1, '1995-02-04', 'Celta Vigo', 'Spanien'),
(2917, 29, 'A', 15, 'Fischer', 'Viktor', '', 18, 3, '1994-06-09', 'FC Kopenhagen', 'Dänemark'),
(2918, 29, 'A', 9, 'Jörgensen', 'Nicolai', '', 30, 8, '1991-01-15', 'Feyenoord Rotterdam', 'Niederlande'),
(2919, 29, 'A', 11, 'Dolberg', 'Kasper', '', 5, 1, '1997-10-06', 'Ajax Amsterdam', 'Niederlande'),
(2920, 29, 'A', 20, 'Poulsen', 'Yussuf', '', 27, 3, '1994-06-15', 'RasenBallsport Leipzig', 'Deutschland'),
(2921, 29, 'A', 12, 'Braithwaite', 'Martin', '', 19, 1, '1991-06-05', 'FC Girondins Bordeaux', 'Frankreich'),
(2922, 29, 'A', 21, 'Cornelius', 'Andreas', '', 18, 4, '1993-03-16', 'Atalanta Bergamo', 'Italien');

Alles anzeigen

stegmuellerm · 3. Juni 2018

Und hier ist der aktuelle komplette Dump für diejenigen welche sich nicht auf die Suche von Tippfehlern machen wollen und auch schon mal die Daten zu testen

Das ist der Stand bis einschlißlich Dänemark

FiedlWdd · 3. Juni 2018

Nigeria

Code

(200, 2, 'T', 1, 'Akpeyi', 'Daniel', '', 7, 0, '1986-08-03', 'Chippa United', 'Südafrika'),
(201, 2, 'T', 23, 'Uzoho', 'Francis', '', 3, 0, '1998-10-28', 'Deportivo de La Coruña B', 'Spanien'),
(202, 2, 'T', 16, 'Ezenwa', 'Ikechukwu', '', 24, 0, '1988-10-16', 'Enyimba Aba', 'Nigeria'),
(203, 2, 'T', 28, 'Ajiboye', 'Dele', '', 3, 0, '1990-08-07', 'Warri Wolves FC', 'Nigeria'),
(204, 2, 'V', 20, 'Awaziem', 'Chidozie', '', 4, 0, '1997-01-01', 'FC Nantes', 'Frankreich'),
(205, 2, 'V', 6, 'Balogun', 'Leon', '', 16, 0, '1988-06-28', '1.FSV Mainz 05', 'Deutschland'),
(206, 2, 'V', 4, 'Omeruo', 'Kenneth', '', 37, 0, '1993-10-17', 'Kasimpasa', 'Türkei'),
(207, 2, 'V', 5, 'Troost-Ekong', 'William', '', 19, 0, '1993-09-01', 'Bursaspor', 'Türkei'),
(208, 2, 'V', 27, 'Eze', 'Stephen', '', 13, 0, '1994-03-08', 'Lokomotive Plovdiv', 'Bulgarien'),
(209, 2, 'V', 3, 'Echiéjilé', 'Uwa Elderson', 'Elderson', 60, 3, '1988-01-20', 'Cercle Brügge', 'Belgien'),
(210, 2, 'V', 2, 'Ebuehi', 'Tyronne', '', 4, 0, '1995-12-16', 'ADO Den Haag', 'Niederlande'),
(211, 2, 'V', 18, 'Aina', 'Ola', '', 4, 0, '1996-10-08', 'FC Chelsea', 'England'),
(212, 2, 'V', 21, 'Idowu', 'Bryan', '', 3, 1, '1992-05-18', 'Amkar Perm', 'Russland'),
(213, 2, 'M', 13, 'Ndidi', 'Wilfred', '', 16, 0, '1996-12-16', 'Leicester City', 'England'),
(214, 2, 'M', 26, 'Obi', 'John Mikel', '', 83, 6, '1987-04-22', 'Tianjin Teda', 'China'),
(215, 2, 'M', 17, 'Onazi', 'Ogenyi', '', 50, 1, '1992-12-25', 'Trabzonspor', 'Türkei'),
(216, 2, 'M', 22, 'Agbo', 'Uche', '', 2, 0, '1995-12-04', 'Standard Lüttich', 'Belgien'),
(217, 2, 'M', 8, 'Agu', 'Mikel', '', 5, 0, '1993-05-27', 'Bursaspor', 'Türkei'),
(218, 2, 'M', 12, 'Shehu', 'Abdullahi', '', 22, 0, '1993-03-12', 'Bursaspor', 'Türkei'),
(219, 2, 'M', 25, 'Obi', 'Joel', '', 15, 0, '1991-05-22', 'FC Turin', 'Italien'),
(220, 2, 'M', 19, 'Ogu', 'John', '', 18, 2, '1988-04-20', 'Hapoel Beer Sheva', 'Israel'),
(221, 2, 'M', 11, 'Moses', 'Victor', '', 32, 11, '1990-12-12', 'FC Chelsea', 'England'),
(222, 2, 'M', 24, 'Etebo', 'Oghenekaro', '', 12, 1, '1995-11-09', 'UD Las Palmas', 'Spanien'),
(223, 2, 'A', 10, 'Iwobi', 'Alex', '', 16, 1, '1996-05-03', 'FC Arsenal', 'England'),
(224, 2, 'A', 15, 'Simon', 'Moses', '', 21, 4, '1995-07-12', 'KAA Gent', 'Belgien'),
(225, 2, 'A', 7, 'Musa', 'Ahmed', '', 69, 13, '1992-10-14', 'ZSKA Moskau', 'Russland'),
(226, 2, 'A', 14, 'Iheanacho', 'Kelechi', '', 15, 8, '1996-10-03', 'Leicester City', 'England'),
(227, 2, 'A', 9, 'Ighalo', 'Odion', '', 17, 4, '1989-06-16', 'Changchun Yatai', 'China'),
(228, 2, 'A', 29, 'Nwankwo', 'Simeon Tochukwu', 'Simy', 0, 0, '1992-05-07', 'FC Crotone', 'Italien'),
(229, 2, 'A', 30, 'Lokosa', 'Junior', '', 0, 0, '1993-08-23', 'Kano Pillars', 'Nigeria'),

Alles anzeigen

Guerreiro84 · 4. Juni 2018

Kader der FIFA: https://img.fifa.com/image/upload/hzfqyndmnqazczvc5xdb.pdf

Denke es wird die nächsten Tage noch mit Spielen und Toren auf der Website veröffentlicht.

Guerreiro84 · 4. Juni 2018

Saudi Arabien:

Code

( 7200 , 72 ,'T', 1 ,'Almuaiouf','Abdullah','', 9 , 0 ,'1987-01-23','Al Hilal SFC ','Saudi-Arabien') ,
( 7201 , 72 ,'V', 2 ,'Alharbi','Mansour','', 37 , 1 ,'1987-10-19','Al Ahli SC ','Saudi-Arabien') ,
( 7202 , 72 ,'V', 3 ,'Hawsawi','Osama','', 133 , 7 ,'1984-03-31','Al Hilal SFC ','Saudi-Arabien') ,
( 7203 , 72 ,'V', 4 ,'Albulayhi','Ali','', 1 , 0 ,'1989-11-21','Al Hilal SFC ','Saudi-Arabien') ,
( 7204 , 72 ,'V', 5 ,'Othman','Omar','', 40 , 3 ,'1985-09-27','Al Nassr FC ','Saudi-Arabien') ,
( 7205 , 72 ,'V', 6 ,'Alburayk','Mohammed','', 9 , 1 ,'1992-09-15','Al Hilal SFC ','Saudi-Arabien') ,
( 7206 , 72 ,'M', 7 ,'Alfaraj','Salman','', 40 , 3 ,'1989-08-01','Al Hilal SFC ','Saudi-Arabien') ,
( 7207 , 72 ,'M', 8 ,'Alshehri','Yahia','', 55 , 7 ,'1990-06-26','CD Leganés ','Spanien') ,
( 7208 , 72 ,'M', 9 ,'Bahbir','Hatan','', 3 , 0 ,'1992-07-16','Al Shabab FC ','Saudi-Arabien') ,
( 7209 , 72 ,'A', 10 ,'Alsahlawi','Mohammed','', 38 , 28 ,'1987-01-10','Al Nassr FC ','Saudi-Arabien') ,
( 7210 , 72 ,'M', 11 ,'Alkhaibri','Abdulmalek','', 35 , 0 ,'1986-03-13','Al Hilal SFC ','Saudi-Arabien') ,
( 7211 , 72 ,'M', 12 ,'Kanno','Mohamed','', 5 , 1 ,'1994-09-22','Al Hilal SFC ','Saudi-Arabien') ,
( 7212 , 72 ,'V', 13 ,'Alshahrani','Yasir','', 34 , 0 ,'1992-05-25','Al Hilal SFC ','Saudi-Arabien') ,
( 7213 , 72 ,'M', 14 ,'Otayf','Abdullah','', 14 , 1 ,'1992-08-03','Al Hilal SFC ','Saudi-Arabien') ,
( 7214 , 72 ,'M', 15 ,'Alkhaibari','Abdullah','', 3 , 0 ,'1996-08-16','Al Shabab FC ','Saudi-Arabien') ,
( 7215 , 72 ,'M', 16 ,'Almoqahwi','Hussain','', 15 , 1 ,'1988-03-24','Al Ahli SC ','Saudi-Arabien') ,
( 7216 , 72 ,'M', 17 ,'Aljassam','Taiseer','', 129 , 18 ,'1984-07-25','Al Ahli SC ','Saudi-Arabien') ,
( 7217 , 72 ,'M', 18 ,'Aldawsari','Salem','', 30 , 4 ,'1991-08-19','Villarreal CF ','Spanien') ,
( 7218 , 72 ,'A', 19 ,'Almuwallad','Fahad','', 42 , 10 ,'1994-09-14','Levante UD ','Spanien') ,
( 7219 , 72 ,'A', 20 ,'Asiri','Muhannad','', 17 , 4 ,'1986-10-14','Al Ahli SC ','Saudi-Arabien') ,
( 7220 , 72 ,'T', 21 ,'Almosailem','Yasser','', 32 , 0 ,'1984-02-27','Al Ahli SC ','Saudi-Arabien') ,
( 7221 , 72 ,'T', 22 ,'Alowais','Mohammed','', 5 , 0 ,'1991-10-10','Al Ahli SC ','Saudi-Arabien') ,
( 7222 , 72 ,'V', 23 ,'Hawsawi','Motaz','', 15 , 0 ,'1992-02-17','Al Ahli SC ','Saudi-Arabien') ;

Alles anzeigen

Guerreiro84 · 4. Juni 2018

Schweden

Code

( 4800 , 48 ,'T', 1 ,'Olsen','Robin','', 17 , 0 ,'1990.01.08','FC Kopenhagen','Dänemark') ,
( 4801 , 48 ,'V', 2 ,'Lustig','Mikael','', 64 , 6 ,'1986-12-13','Celtic Glasgow','Schottland') ,
( 4802 , 48 ,'V', 3 ,'Lindelof','Victor','', 20 , 1 ,'1994-07-17','Manchester United','England') ,
( 4803 , 48 ,'V', 4 ,'Granqvist','Andreas','', 71 , 6 ,'1985-04-16','FC Krasnodar ','Russland') ,
( 4804 , 48 ,'V', 5 ,'Olsson','Martin','', 43 , 5 ,'1988-05-17','Swansea City','Wales') ,
( 4805 , 48 ,'V', 6 ,'Augustinsson','Ludwig','', 14 , 0 ,'1994-04-21','SV Werder Bremen ','Deutschland') ,
( 4806 , 48 ,'M', 7 ,'Larsson','Sebastian','', 98 , 6 ,'1985-06-06','Hull City FC ','England') ,
( 4807 , 48 ,'M', 8 ,'Ekdal','Albin','', 33 , 0 ,'1989-07-28','Hamburger SV ','Deutschland') ,
( 4808 , 48 ,'A', 9 ,'Berg','Marcus','', 55 , 18 ,'1986-08-17','Al Ain FC','VAE') ,
( 4809 , 48 ,'A', 10 ,'Forsberg','Emil','', 35 , 6 ,'1991-10-23','RB Leipzig ','Deutschland') ,
( 4810 , 48 ,'A', 11 ,'Guidetti','John','', 20 , 1 ,'1992-04-15','Deportivo Alavés ','Spanien') ,
( 4811 , 48 ,'T', 12 ,'Johnsson','Karl-Johan','', 5 , 0 ,'1990-01-28','EA Guingamp ','Frankreich') ,
( 4812 , 48 ,'M', 13 ,'Svensson','Gustav','', 12 , 0 ,'1987-02-07','Seattle Sounders FC','USA') ,
( 4813 , 48 ,'V', 14 ,'Helander','Filip','', 4 , 0 ,'1993-04-22','Bologna FC ','Italien') ,
( 4814 , 48 ,'M', 15 ,'Hiljemark','Oscar','', 21 , 2 ,'1992-06-28','Genoa CFC ','Italien') ,
( 4815 , 48 ,'V', 16 ,'Krafth','Emil','', 12 , 0 ,'1994-08-02','Bologna FC ','Italien') ,
( 4816 , 48 ,'M', 17 ,'Claesson','Viktor','', 20 , 3 ,'1992-01-02','FC Krasnodar ','Russland') ,
( 4817 , 48 ,'V', 18 ,'Jansson','Pontus','', 15 , 0 ,'1991-02-13','Leeds United FC ','England') ,
( 4818 , 48 ,'M', 19 ,'Rohden','Marcus','', 10 , 1 ,'1991-05-11','FC Crotone ','Italien') ,
( 4819 , 48 ,'A', 20 ,'Toivonen','Ola','', 57 , 13 ,'1986-07-03','Toulouse FC ','Frankreich') ,
( 4820 , 48 ,'A', 21 ,'Durmaz','Jimmy','', 45 , 3 ,'1989-03-22','Toulouse FC','Frankreich') ,
( 4821 , 48 ,'A', 22 ,'Thelin','Isaac Kiese','', 19 , 2 ,'1992-06-24','KV Waasland-Beveren','Belgien') ,
( 4822 , 48 ,'T', 23 ,'Nordfeldt','Kristoffer','', 8 , 0 ,'1989-06-23','Swansea City','Wales') ;

Alles anzeigen

stegmuellerm · 4. Juni 2018

welche spielernummern habt ihr denn jetzt verteilt, denn nach der offiziellen Meldung brauchen wir die anderen ja nicht in der Datenbank oder ?

stegmuellerm · 4. Juni 2018

Deutschland und Dänemark würde dann so aussehen:

Deutschland:

Code

(2700,27,'T',1,'NEUER','Manuel','',74,0,'1986-03-27','FC Bayern München','Deutschland'),
(2701,27,'T',12,'TRAPP','Kevin','',3,0,'1990-07-08','Paris St. Germain','Frankreich'),
(2702,27,'T',22,'TER STEGEN','Marc-André','',19,0,'1992-04-30','FC Barcelona','Spanien'),
(2703,27,'V',2,'PLATTENHARDT','Marvin','',6,0,'1992-01-26','Hertha BSC Berlin','Deutschland'),
(2704,27,'V',3,'HECTOR','Jonas','',36,3,'1990-05-27','1.FC Köln','Deutschland'),
(2705,27,'V',4,'GINTER','Matthias','',17,0,'1994-01-19','Bor. Mönchengladbach','Deutschland'),
(2706,27,'V',5,'HUMMELS','Mats','',63,5,'1988-12-16','Borussia Dortmund','Deutschland'),
(2707,27,'V',15,'SUELE','Niklas','',9,0,'1995-09-03','FC Bayern München','Deutschland'),
(2708,27,'V',16,'RUEDIGER','Antonio','',23,1,'1993-03-03','FC Chelsea','England'),
(2709,27,'V',17,'BOATENG','Jerôme','',37,0,'1988-09-03','FC Bayern München','Deutschland'),
(2710,27,'V',18,'KIMMICH','Joshua','',27,3,'1995-02-08','FC Bayern München','Deutschland'),
(2711,27,'M',6,'KHEDIRA','Sami','',73,7,'1987-04-04','Juventus Turin','Italien'),
(2712,27,'M',8,'KROOS','Toni','',82,12,'1990-01-04','Real Madrid','Spanien'),
(2713,27,'M',10,'OEZIL','Mesut','',89,22,'1988-10-15','FC Arsenal','England'),
(2714,27,'M',14,'GORETZKA','Leon','',14,6,'1995-02-06','FC Schalke 04','Deutschland'),
(2715,27,'M',19,'RUDY','Sebastian','',24,1,'1990-02-28','FC Bayern München','Deutschland'),
(2716,27,'M',21,'GUENDOGAN','Ilkay','',24,4,'1990-10-24','Manchester City','England'),
(2717,27,'A',7,'DRAXLER','Julian','',42,6,'1993-09-20','Paris St. Germain','Frankreich'),
(2718,27,'A',9,'WERNER','Timo','',12,7,'1996-03-06','RB Leipzig','Deutschland'),
(2719,27,'A',11,'REUS','Marco','',29,9,'1989-05-31','Borussia Dortmund','Deutschland'),
(2720,27,'A',13,'MUELLER','Thomas','',90,38,'1989-09-13','FC Bayern München','Deutschland'),
(2721,27,'A',20,'BRANDT','Julian','',14,1,'1996-05-02','Bayer 04 Leverkusen','Deutschland'),
(2722,27,'A',23,'GOMEZ','Mario','',73,31,'1985-07-10','VfB Stuttgart','Deutschland'),

Alles anzeigen

Dänemark:

Code

(2900,29,'T',1,'SCHMEICHEL','Kasper','',34,0,'1986-11-05','Leicester City','England'),
(2901,29,'T',16,'LOSSL','Jonas','',1,0,'1989-02-01','Huddersfield Town','England'),
(2902,29,'T',22,'RONNOW','Frederik','',7,0,'1992-08-04','Bröndby IF','Dänemark'),
(2903,29,'V',3,'VESTERGAARD','Jannik','',16,1,'1992-08-03','Borussia Mönchengladbach','Deutschland'),
(2904,29,'V',4,'KIAER','Simon','',77,3,'1989-03-26','FC Sevilla','Spanien'),
(2905,29,'V',5,'KNUDSEN','Jonas','',3,0,'1992-09-16','Ipswich Town','England'),
(2906,29,'V',6,'CHRISTENSEN','Andreas','',15,1,'1996-04-10','FC Chelsea','England'),
(2907,29,'V',13,'JORGENSEN','Matthias','',12,0,'1990-04-23','Huddersfield Town','England'),
(2908,29,'V',14,'DALSGAARD','Henrik','',10,0,'1989-07-27','FC Brentford','England'),
(2909,29,'V',17,'STRYGER LARSEN','Jens','',12,1,'1991-02-21','Udinese Calcio','Italien'),
(2910,29,'M',2,'KROHN-DEHLI','Michael','',57,5,'1983-06-06','Deportivo La Coruna','Spanien'),
(2911,29,'M',7,'KVIST','William','',79,2,'1985-02-24','FC Kopenhagen','Dänemark'),
(2912,29,'M',8,'DELANEY','Thomas','',26,4,'1991-09-03','SV Werder Bremen','Deutschland'),
(2913,29,'M',10,'ERIKSEN','Christian','',77,21,'1992-02-14','Tottenham Hotspur','England'),
(2914,29,'M',18,'LERAGER','Lukas','',3,0,'1993-07-12','FC Girondins Bordeaux','Frankreich'),
(2915,29,'M',19,'SCHONE','Lasse','',35,3,'1986-05-27','Ajax Amsterdam','Niederlande'),
(2916,29,'A',9,'JORGENSEN','Nicolai','',30,8,'1991-01-15','Feyenoord Rotterdam','Niederlande'),
(2917,29,'A',11,'BRAITHWAITE','Martin','',19,1,'1991-06-05','FC Girondins Bordeaux','Frankreich'),
(2918,29,'A',12,'DOLBERG','Kasper','',5,1,'1997-10-06','Ajax Amsterdam','Niederlande'),
(2919,29,'A',15,'FISCHER','Viktor','',18,3,'1994-06-09','FC Kopenhagen','Dänemark'),
(2920,29,'A',20,'POULSEN','Yussuf Yurary','',27,3,'1994-06-15','RasenBallsport Leipzig','Deutschland'),
(2921,29,'A',21,'CORNELIUS','Andreas','',18,4,'1993-03-16','Atalanta Bergamo','Italien'),
(2922,29,'A',23,'SISTO','Pione','',13,1,'1995-02-04','Celta Vigo','Spanien'),

Alles anzeigen

Guerreiro84 · 4. Juni 2018

Bei Deutschland habe ich halt die 4 Spieler gelöscht die nicht dabei sind.

MichaR2112 · 4. Juni 2018

Hallo,

welcher Cronjob muss denn eingerichtet sein?

stegmuellerm · 4. Juni 2018

Zitat von Guerreiro84

Bei Deutschland habe ich halt die 4 Spieler gelöscht die nicht dabei sind.

find ich nicht so toll, wir haben noch so viel Zeit dass wir einmal ne sauber sortierte DB-Dump erstellen, wo auch nur das drin ist was gebraucht wird an Spieler

Tags