# # Football Mod Backup League Script # Dump of # Season 2011 # League 70 (WM Frauen) # DATE : 03-10-2011 21:57:25 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 (2011, 70, 'WM Frauen', 'WMF', 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 (2011, 70, 1, 3, '2011-06-26 15:00:00', '', '', 'Gruppenphase 1. Spieltag', '8'),(2011, 70, 2, 3, '2011-06-30 15:00:00', '', '', 'Gruppenphase 2. Spieltag', '8'),(2011, 70, 3, 3, '2011-07-05 15:00:00', '', '', 'Gruppenphase 3. Spieltag', '8'),(2011, 70, 4, 3, '2011-07-15 15:00:00', '', '', 'Viertelfinale - Finale', '8'); REPLACE INTO phpbb_footb_teams (season, league, team_id, team_name, team_name_short, team_symbol, group_id, matchday) VALUES (2011, 70, 7110, 'Deutschland', 'Deutschl.', 'Germany.png', 'A', 4),(2011, 70, 7111, 'England', 'England', 'England.png', 'B', 4),(2011, 70, 7115, 'Frankreich', 'Frankr.', 'France.png', 'A', 4),(2011, 70, 7135, 'Norwegen', 'Norwegen', 'Norway.png', 'D', 3),(2011, 70, 7144, 'Schweden', 'Schweden', 'Sweden.png', 'C', 4),(2011, 70, 7202, 'Brasilien', 'Brasilien', 'Brazil.png', 'D', 4),(2011, 70, 7205, 'Kolumbien', 'Kolumbien', 'Colombia.png', 'C', 3),(2011, 70, 7301, 'Australien', 'Austral.', 'Australia.png', 'D', 4),(2011, 70, 7313, 'Japan', 'Japan', 'Japan.png', 'B', 4),(2011, 70, 7329, 'Nordkorea', 'Nordkorea', 'North-Korea.png', 'C', 3),(2011, 70, 7422, 'Kanada', 'Kanada', 'Canada.png', 'A', 3),(2011, 70, 7425, 'Mexiko', 'Mexiko', 'Mexico.png', 'B', 3),(2011, 70, 7439, 'USA', 'USA', 'United-States.png', 'C', 4),(2011, 70, 7503, 'Äquatorialguinea', 'Ä. Guinea', 'Equatorial-Guinea.png', 'D', 3),(2011, 70, 7535, 'Nigeria', 'Nigeria', 'Nigeria.png', 'A', 3),(2011, 70, 7605, 'Neuseeland', 'Neuseel.', 'New-Zealand.png', 'B', 3); 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 (2011, 70, 1, 7535, 7115, '0', '1', 1, 3, '2011-06-26 15:00:00', 'A', '', '', 0, '', ''),(2011, 70, 2, 7110, 7422, '2', '1', 1, 3, '2011-06-26 18:00:00', 'A', '', '', 0, '', ''),(2011, 70, 3, 7313, 7605, '2', '1', 1, 3, '2011-06-27 15:00:00', 'B', '', '', 0, '', ''),(2011, 70, 4, 7425, 7111, '1', '1', 1, 3, '2011-06-27 18:00:00', 'B', '', '', 0, '', ''),(2011, 70, 5, 7205, 7144, '0', '1', 1, 3, '2011-06-28 15:00:00', 'C', '', '', 0, '', ''),(2011, 70, 6, 7439, 7329, '2', '0', 1, 3, '2011-06-28 18:15:00', 'C', '', '', 0, '', ''),(2011, 70, 7, 7135, 7503, '1', '0', 1, 3, '2011-06-29 15:00:00', 'D', '', '', 0, '', ''),(2011, 70, 8, 7202, 7301, '1', '0', 1, 3, '2011-06-29 18:15:00', 'D', '', '', 0, '', ''),(2011, 70, 9, 7422, 7115, '0', '4', 2, 3, '2011-06-30 18:00:00', 'A', '', '', 0, '', ''),(2011, 70, 10, 7110, 7535, '1', '0', 2, 3, '2011-06-30 20:45:00', 'A', '', '', 0, '', ''),(2011, 70, 11, 7313, 7425, '4', '0', 2, 3, '2011-07-01 15:00:00', 'B', '', '', 0, '', ''),(2011, 70, 12, 7605, 7111, '1', '2', 2, 3, '2011-07-01 18:15:00', 'B', '', '', 0, '', ''),(2011, 70, 13, 7329, 7144, '0', '1', 2, 3, '2011-07-02 14:00:00', 'C', '', '', 0, '', ''),(2011, 70, 14, 7439, 7205, '3', '0', 2, 3, '2011-07-02 18:00:00', 'C', '', '', 0, '', ''),(2011, 70, 15, 7301, 7503, '3', '2', 2, 3, '2011-07-03 14:00:00', 'D', '', '', 0, '', ''),(2011, 70, 16, 7202, 7135, '3', '0', 2, 3, '2011-07-03 18:15:00', 'D', '', '', 0, '', ''),(2011, 70, 17, 7422, 7535, '0', '1', 3, 3, '2011-07-05 20:45:00', 'A', '', '', 0, '', ''),(2011, 70, 18, 7115, 7110, '2', '4', 3, 3, '2011-07-05 20:45:00', 'A', '', '', 0, '', ''),(2011, 70, 19, 7605, 7425, '2', '2', 3, 3, '2011-07-05 18:15:00', 'B', '', '', 0, '', ''),(2011, 70, 20, 7111, 7313, '2', '0', 3, 3, '2011-07-05 18:15:00', 'B', '', '', 0, '', ''),(2011, 70, 21, 7144, 7439, '2', '1', 3, 3, '2011-07-06 20:45:00', 'C', '', '', 0, '', ''),(2011, 70, 22, 7329, 7205, '0', '0', 3, 3, '2011-07-06 20:45:00', 'C', '', '', 0, '', ''),(2011, 70, 23, 7503, 7202, '0', '3', 3, 3, '2011-07-06 18:00:00', 'D', '', '', 0, '', ''),(2011, 70, 24, 7301, 7135, '2', '1', 3, 3, '2011-07-06 18:00:00', 'D', '', '', 0, '', ''),(2011, 70, 25, 7111, 7115, '1', '1', 4, 3, '2011-07-09 18:00:00', '', 'G B1', 'G A2', 1, '3', '4'),(2011, 70, 26, 7110, 7313, '0', '0', 4, 3, '2011-07-09 20:45:00', '', 'G A1', 'G B2', 1, '0', '1'),(2011, 70, 27, 7144, 7301, '3', '1', 4, 3, '2011-07-10 13:00:00', '', 'G C1', 'G D2', 1, '', ''),(2011, 70, 28, 7202, 7439, '1', '1', 4, 3, '2011-07-10 17:30:00', '', 'G D1', 'G C2', 1, '3', '5'),(2011, 70, 29, 7115, 7439, '1', '3', 4, 3, '2011-07-13 18:00:00', '', 'W 25', 'W 28', 1, '', ''),(2011, 70, 30, 7313, 7144, '3', '1', 4, 3, '2011-07-13 20:45:00', '', 'W 26', 'W 27', 1, '', ''),(2011, 70, 31, 7115, 7144, '1', '2', 4, 3, '2011-07-16 17:30:00', '', 'L 29', 'L 30', 1, '', ''),(2011, 70, 32, 7439, 7313, '1', '1', 4, 3, '2011-07-17 20:45:00', '', 'W 29', 'W 30', 1, '3', '5');