# # Football Mod Backup League Script # Dump of # Season 2012 # League 4 (DFB Pokal) # DATE : 26-06-2012 06:04:04 GMT # REPLACE INTO phpbb_footb_leagues (season, league, league_name, league_name_short, league_type, matchdays, matches_on_matchday, win_result, win_result_02, win_matchday, win_season, points_mode, points_result, points_tendency, points_diff, points_last, join_by_user, join_in_season, bet_in_time, rules_post_id, bet_ko_type, bet_points) VALUES (2012, 4, 'DFB Pokal', 'DFB', 2, 4, 0, '0', '0', '0', '0', 1, 10, 3, 0, 1, 0, 0, 0, 0, 1, 0.00); REPLACE INTO phpbb_footb_matchdays (season, league, matchday, status, delivery_date, delivery_date_2, delivery_date_3, matchday_name, matches) VALUES (2012, 4, 1, 3, '2011-07-29 15:00:00', '', '', '1. Runde', '32'),(2012, 4, 2, 3, '2011-10-25 15:00:00', '', '', '2. Runde', '16'),(2012, 4, 3, 3, '2011-12-20 15:00:00', '', '', 'Achtelfinale', '8'),(2012, 4, 4, 3, '2012-05-12 15:00:00', '', '', 'Viertelfinale - Finale', '7'); REPLACE INTO phpbb_footb_teams (season, league, team_id, team_name, team_name_short, team_symbol, group_id, matchday) VALUES (2012, 4, 1, 'Bayern München', 'Bayern', '', '', 4),(2012, 4, 2, 'Bor. Mönchengladbach', 'Gladbach', '', '', 4),(2012, 4, 3, 'Hamburger SV', 'Hamburg', '', '', 3),(2012, 4, 4, '1. FC Nürnberg', 'Nürnberg', '', '', 3),(2012, 4, 5, 'VfL Bochum', 'Bochum', '', '', 3),(2012, 4, 6, '1. FSV Mainz 05', 'Mainz', '', '', 3),(2012, 4, 7, 'Alemannia Aachen', 'Aachen', '', '', 1),(2012, 4, 8, 'VfB Stuttgart', 'Stuttgart', '', '', 4),(2012, 4, 9, 'FC Schalke 04', 'Schalke', '', '', 3),(2012, 4, 10, 'Energie Cottbus', 'Cottbus', '', '', 1),(2012, 4, 11, 'VfL Wolfsburg', 'Wolfsburg', '', '', 1),(2012, 4, 12, 'Borussia Dortmund', 'Dortmund', '', '', 4),(2012, 4, 13, 'Eintracht Frankfurt', 'Frankfurt', '', '', 2),(2012, 4, 14, 'Bayer Leverkusen', 'Leverkusen', '', '', 1),(2012, 4, 15, 'Hannover 96', 'Hannover', '', '', 2),(2012, 4, 16, 'Hertha BSC', 'Berlin', '', '', 4),(2012, 4, 17, 'Werder Bremen', 'Bremen', '', '', 1),(2012, 4, 18, 'Arminia Bielefeld', 'Bielefeld', '', '', 1),(2012, 4, 19, '1. FC Kaiserslautern', 'Lautern', '', '', 3),(2012, 4, 20, 'TSV 1860 München', 'München', '', '', 2),(2012, 4, 21, 'Hansa Rostock', 'Rostock', '', '', 1),(2012, 4, 23, 'FC Augsburg', 'Augsburg', '', '', 3),(2012, 4, 24, '1. FC Köln', 'Köln', '', '', 2),(2012, 4, 25, 'Eintracht Braunschweig', 'Braunschw.', '', '', 1),(2012, 4, 26, 'Karlsruher SC', 'Karlsruhe', '', '', 2),(2012, 4, 27, 'SpVgg Greuther Fürth', 'Fürth', '', '', 4),(2012, 4, 28, 'SC Freiburg', 'Freiburg', '', '', 1),(2012, 4, 29, 'SpVgg Unterhaching', 'Uhachingen', '', '', 2),(2012, 4, 30, 'Erzgebirge Aue', 'Aue', '', '', 2),(2012, 4, 31, 'MSV Duisburg', 'Duisburg', '', '', 2),(2012, 4, 33, 'SC Paderborn 07', 'Paderborn', '', '', 2),(2012, 4, 34, 'Rot-Weiss Essen', 'Essen', '', '', 2),(2012, 4, 37, 'Rot Weiss Ahlen', 'Ahlen', '', '', 1),(2012, 4, 38, 'Dynamo Dresden', 'Dresden', '', '', 2),(2012, 4, 41, 'Rot-Weiß Oberhausen', 'Oberhausen', '', '', 1),(2012, 4, 42, 'VfL Osnabrück', 'Osnabrück', '', '', 1),(2012, 4, 43, 'Jahn Regensburg', 'Regensburg', '', '', 1),(2012, 4, 44, '1. FC Saarbrücken', 'Saarbrück.', '', '', 1),(2012, 4, 46, 'Eintracht Trier', 'Trier', '', '', 2),(2012, 4, 47, '1899 Hoffenheim', 'Hoffenheim', '', '', 4),(2012, 4, 48, 'SV Wehen Wiesbaden', 'Wehen', '', '', 1),(2012, 4, 49, 'FC St. Pauli', 'St. Pauli', '', '', 1),(2012, 4, 53, 'SV Sandhausen', 'Sandhausen', '', '', 1),(2012, 4, 63, 'Holstein Kiel', 'Kiel', '', '', 4),(2012, 4, 66, '1. FC Union Berlin', 'Un. Berlin', '', '', 1),(2012, 4, 67, 'SV Babelsberg 03', 'Babelsberg', '', '', 1),(2012, 4, 71, 'FSV Frankfurt', 'F. Frankf.', '', '', 2),(2012, 4, 72, 'FC Ingolstadt 04', 'Ingolstadt', '', '', 2),(2012, 4, 74, 'FC Oberneuland', 'Oberneul.', '', '', 1),(2012, 4, 78, 'Hallescher FC', 'Halle', '', '', 1),(2012, 4, 85, '1. FC Heidenheim 1846', 'Heidenheim', '', '', 2),(2012, 4, 89, 'Fortuna Düsseldorf', 'Düsseldorf', '', '', 3),(2012, 4, 91, 'Kickers Emden', 'Emden', '', '', 1),(2012, 4, 93, 'TSV Germania Windeck', 'Windeck', '', '', 1),(2012, 4, 102, 'ZFC Meuselwitz', 'Meuselwitz', '', '', 1),(2012, 4, 119, 'Eimsbütteler TV', 'Eimsbüttel', '', '', 1),(2012, 4, 120, 'FC Anker Wismar', 'A. Wismar', '', '', 1),(2012, 4, 121, 'FC Teningen', 'Teningen', '', '', 1),(2012, 4, 122, 'Hessen Kassel', 'H. Kassel', '', '', 1),(2012, 4, 123, 'RB Leipzig', 'RB Leipzig', '', '', 2),(2012, 4, 124, 'SC Wiedenbrück', 'Wiedenbr.', '', '', 1),(2012, 4, 125, 'SVN Zweibrücken', 'Zweibrück.', '', '', 1),(2012, 4, 126, 'VfB Oldenburg', 'Oldenburg', '', '', 1),(2012, 4, 128, 'BFC Dynamo', 'BFC Dynamo', '', '', 1); REPLACE INTO phpbb_footb_matches (season, league, match_no, team_id_home, team_id_guest, goals_home, goals_guest, matchday, status, match_datetime, group_id, formula_home, formula_guest, ko_match, goals_overtime_home, goals_overtime_guest) VALUES (2012, 4, 1, 121, 9, '1', '11', 1, 3, '2011-07-31 17:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 2, 34, 66, '2', '2', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '6', '5'),(2012, 4, 3, 122, 89, '0', '3', 1, 3, '2011-07-31 17:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 4, 74, 72, '1', '4', 1, 3, '2011-07-31 14:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 5, 63, 10, '3', '0', 1, 3, '2011-07-30 19:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 6, 29, 28, '3', '2', 1, 3, '2011-07-31 14:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 7, 128, 19, '0', '3', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 8, 26, 7, '3', '1', 1, 3, '2011-07-31 14:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 9, 102, 16, '0', '4', 1, 3, '2011-07-31 16:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 10, 78, 13, '0', '2', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 11, 85, 17, '2', '1', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 12, 93, 47, '1', '1', 1, 3, '2011-07-31 16:00:00', '', 'D', 'D', 1, '1', '3'),(2012, 4, 13, 53, 12, '0', '3', 1, 3, '2011-07-30 19:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 14, 38, 14, '3', '3', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '4', '3'),(2012, 4, 15, 123, 11, '3', '2', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 16, 46, 49, '2', '1', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 17, 18, 4, '1', '5', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 18, 37, 33, '0', '10', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 19, 125, 6, '0', '0', 1, 3, '2011-07-31 17:30:00', '', 'D', 'D', 1, '1', '2'),(2012, 4, 20, 44, 30, '1', '1', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '1', '3'),(2012, 4, 21, 119, 27, '0', '10', 1, 3, '2011-07-31 14:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 22, 124, 24, '0', '3', 1, 3, '2011-07-31 17:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 23, 25, 1, '0', '3', 1, 3, '2011-08-01 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 24, 120, 15, '0', '6', 1, 3, '2011-07-31 14:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 25, 67, 31, '0', '2', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 26, 43, 2, '1', '3', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 27, 91, 71, '1', '1', 1, 3, '2011-07-30 19:30:00', '', 'D', 'D', 1, '1', '5'),(2012, 4, 28, 126, 3, '1', '2', 1, 3, '2011-07-30 15:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 29, 48, 8, '1', '2', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 30, 42, 20, '2', '2', 1, 3, '2011-07-29 20:30:00', '', 'D', 'D', 1, '2', '3'),(2012, 4, 31, 21, 5, '2', '2', 1, 3, '2011-07-30 19:30:00', '', 'D', 'D', 1, '5', '7'),(2012, 4, 32, 41, 23, '1', '1', 1, 3, '2011-07-30 19:30:00', '', 'D', 'D', 1, '1', '2'),(2012, 4, 33, 63, 31, '2', '0', 2, 3, '2011-10-26 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 34, 123, 23, '0', '1', 2, 3, '2011-10-25 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 35, 29, 5, '1', '4', 2, 3, '2011-10-25 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 36, 46, 3, '1', '1', 2, 3, '2011-10-25 20:30:00', '', 'D', 'D', 1, '1', '2'),(2012, 4, 37, 85, 2, '0', '0', 2, 3, '2011-10-25 19:00:00', '', 'D', 'D', 1, '3', '4'),(2012, 4, 38, 34, 16, '0', '3', 2, 3, '2011-10-26 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 39, 12, 38, '2', '0', 2, 3, '2011-10-25 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 40, 27, 33, '4', '0', 2, 3, '2011-10-25 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 41, 30, 4, '1', '2', 2, 3, '2011-10-26 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 42, 47, 24, '2', '1', 2, 3, '2011-10-25 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 43, 15, 6, '0', '0', 2, 3, '2011-10-26 19:00:00', '', 'D', 'D', 1, '0', '1'),(2012, 4, 44, 89, 20, '3', '0', 2, 3, '2011-10-25 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 45, 1, 72, '6', '0', 2, 3, '2011-10-26 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 46, 8, 71, '3', '0', 2, 3, '2011-10-26 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 47, 13, 19, '0', '0', 2, 3, '2011-10-26 20:30:00', '', 'D', 'D', 1, '0', '1'),(2012, 4, 48, 26, 9, '0', '2', 2, 3, '2011-10-26 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 49, 8, 3, '2', '1', 3, 3, '2011-12-21 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 50, 47, 23, '2', '1', 3, 3, '2011-12-20 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 51, 16, 19, '3', '1', 3, 3, '2011-12-21 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 52, 89, 12, '0', '0', 3, 3, '2011-12-20 20:30:00', '', 'D', 'D', 1, '4', '5'),(2012, 4, 53, 63, 6, '2', '0', 3, 3, '2011-12-21 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 54, 2, 9, '3', '1', 3, 3, '2011-12-21 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 55, 5, 1, '1', '2', 3, 3, '2011-12-20 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 56, 4, 27, '0', '1', 3, 3, '2011-12-20 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 57, 47, 27, '0', '1', 4, 3, '2012-02-08 19:00:00', '', 'D', 'D', 1, '', ''),(2012, 4, 58, 16, 2, '0', '0', 4, 3, '2012-02-08 19:00:00', '', 'D', 'D', 1, '0', '2'),(2012, 4, 59, 8, 1, '0', '2', 4, 3, '2012-02-08 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 60, 63, 12, '0', '4', 4, 3, '2012-02-07 20:30:00', '', 'D', 'D', 1, '', ''),(2012, 4, 61, 27, 12, '0', '0', 4, 3, '2012-03-20 20:30:00', '', 'D', 'D', 1, '0', '1'),(2012, 4, 62, 2, 1, '0', '0', 4, 3, '2012-03-21 20:30:00', '', 'D', 'D', 1, '2', '4'),(2012, 4, 63, 12, 1, '5', '2', 4, 3, '2012-05-12 20:00:00', '', 'W 61', 'W 62', 1, '', '');