# # Football Mod Backup League Script # Dump of # Season 2011 # League 45 (Champions League) # DATE : 10-06-2011 21:56:42 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, 45, 'Champions League', 'CL', 2, 10, 0, '0', '0', '0', '0', 1, 10, 3, 0, 1, 0, 0, 0, 174, 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, 45, 1, 3, '2010-09-14 15:00:00', '', '', 'Gruppenphase 1. Spieltag', '16'),(2011, 45, 2, 3, '2010-09-28 15:00:00', '', '', 'Gruppenphase 2. Spieltag', '16'),(2011, 45, 3, 3, '2010-10-19 15:00:00', '', '', 'Gruppenphase 3. Spieltag', '16'),(2011, 45, 4, 3, '2010-11-02 15:00:00', '', '', 'Gruppenphase 4. Spieltag', '16'),(2011, 45, 5, 3, '2010-11-23 15:00:00', '', '', 'Gruppenphase 5. Spieltag', '16'),(2011, 45, 6, 3, '2010-12-07 15:00:00', '', '', 'Gruppenphase 6. Spieltag', '16'),(2011, 45, 7, 3, '2011-02-22 15:00:00', '', '', 'Achtelfinale Hin', '8'),(2011, 45, 8, 3, '2011-03-15 15:00:00', '', '', 'Achtelfinale Rück', '8'),(2011, 45, 9, 3, '2011-04-12 15:00:00', '', '', 'Viertelfinale Hin+Rück', '8'),(2011, 45, 10, 3, '2011-05-28 15:00:00', '', '', 'Halbfinale - Finale', '5'); REPLACE INTO phpbb_footb_teams (season, league, team_id, team_name, team_name_short, team_symbol, group_id, matchday) VALUES (2011, 45, 1, 'Bayern München', 'Bayern', '', 'E', 8),(2011, 45, 9, 'FC Schalke 04', 'Schalke', '', 'B', 10),(2011, 45, 17, 'Werder Bremen', 'Bremen', '', 'A', 6),(2011, 45, 2000, 'Arsenal London', 'Arsenal', '', 'H', 8),(2011, 45, 2006, 'FC Chelsea', 'Chelsea', '', 'F', 9),(2011, 45, 2013, 'Manchester United', 'Manchester', '', 'C', 10),(2011, 45, 2019, 'Tottenham Hotspur', 'Tottenham', '', 'A', 9),(2011, 45, 2107, 'FC Barcelona', 'Barcelona', '', 'D', 10),(2011, 45, 2115, 'Real Madrid', 'R. Madrid', '', 'G', 10),(2011, 45, 2123, 'FC Valencia', 'Valencia', '', 'C', 8),(2011, 45, 2200, 'AC Mailand', 'AC Mailand', '', 'G', 8),(2011, 45, 2202, 'AS Rom', 'AS Rom', '', 'E', 8),(2011, 45, 2205, 'Inter Mailand', 'Inter', '', 'A', 9),(2011, 45, 2300, 'AJ Auxerre', 'Auxerre', '', 'G', 6),(2011, 45, 2306, 'Olymp. Lyon', 'Ol. Lyon', '', 'B', 8),(2011, 45, 2307, 'Olymp. Marseille', 'Marseille', '', 'F', 8),(2011, 45, 2502, 'FC Basel', 'Basel', '', 'E', 6),(2011, 45, 2605, 'Benfica Lissabon', 'Benfica', '', 'B', 6),(2011, 45, 2606, 'Sporting Braga', 'Sp. Braga', '', 'H', 6),(2011, 45, 2700, 'Ajax Amsterdam', 'Ajax', '', 'G', 6),(2011, 45, 2703, 'Twente Enschede', 'Enschede', '', 'A', 6),(2011, 45, 2801, 'Bursaspor', 'Bursaspor', '', 'C', 6),(2011, 45, 2901, 'Rubin Kasan', 'Kasan', '', 'D', 6),(2011, 45, 2908, 'Spartak Moskau', 'Sp. Moskau', '', 'F', 6),(2011, 45, 3572, 'FC Kopenhagen', 'Kopenhagen', '', 'D', 8),(2011, 45, 3614, 'Panathinaikos Athen', 'Panathin.', '', 'D', 6),(2011, 45, 3650, 'Hapoel Tel Aviv', 'Tel Aviv', '', 'B', 6),(2011, 45, 3740, 'CFR Cluj', 'Cluj', '', 'E', 6),(2011, 45, 3753, 'Glasgow Rangers', 'G. Rangers', '', 'C', 6),(2011, 45, 3802, 'Partizan Belgrad', 'P. Belgrad', '', 'H', 6),(2011, 45, 3811, 'MSK Zilina', 'MSK Zilina', '', 'F', 6),(2011, 45, 3834, 'Schachtjor Donetsk', 'Schachtjor', '', 'H', 9); 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, 45, 1, 2703, 2205, '2', '2', 1, 3, '2010-09-14 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 2, 17, 2019, '2', '2', 1, 3, '2010-09-14 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 3, 2306, 9, '1', '0', 1, 3, '2010-09-14 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 4, 2605, 3650, '2', '0', 1, 3, '2010-09-14 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 5, 2801, 2123, '0', '4', 1, 3, '2010-09-14 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 6, 2013, 3753, '0', '0', 1, 3, '2010-09-14 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 7, 2107, 3614, '5', '1', 1, 3, '2010-09-14 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 8, 3572, 2901, '1', '0', 1, 3, '2010-09-14 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 9, 1, 2202, '2', '0', 1, 3, '2010-09-15 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 10, 3740, 2502, '2', '1', 1, 3, '2010-09-15 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 11, 3811, 2006, '1', '4', 1, 3, '2010-09-15 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 12, 2307, 2908, '0', '1', 1, 3, '2010-09-15 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 13, 2115, 2700, '2', '0', 1, 3, '2010-09-15 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 14, 2200, 2300, '2', '0', 1, 3, '2010-09-15 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 15, 2000, 2606, '6', '0', 1, 3, '2010-09-15 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 16, 3834, 3802, '1', '0', 1, 3, '2010-09-15 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 17, 2019, 2703, '4', '1', 2, 3, '2010-09-29 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 18, 2205, 17, '4', '0', 2, 3, '2010-09-29 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 19, 3650, 2306, '1', '3', 2, 3, '2010-09-29 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 20, 9, 2605, '2', '0', 2, 3, '2010-09-29 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 21, 2123, 2013, '0', '1', 2, 3, '2010-09-29 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 22, 3753, 2801, '1', '0', 2, 3, '2010-09-29 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 23, 2901, 2107, '1', '1', 2, 3, '2010-09-29 18:30:00', 'D', '', '', 0, '', ''),(2011, 45, 24, 3614, 3572, '0', '2', 2, 3, '2010-09-29 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 25, 2502, 1, '1', '2', 2, 3, '2010-09-28 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 26, 2202, 3740, '2', '1', 2, 3, '2010-09-28 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 27, 2006, 2307, '2', '0', 2, 3, '2010-09-28 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 28, 2908, 3811, '3', '0', 2, 3, '2010-09-28 18:30:00', 'F', '', '', 0, '', ''),(2011, 45, 29, 2700, 2200, '1', '1', 2, 3, '2010-09-28 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 30, 2300, 2115, '0', '1', 2, 3, '2010-09-28 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 31, 3802, 2000, '1', '3', 2, 3, '2010-09-28 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 32, 2606, 3834, '0', '3', 2, 3, '2010-09-28 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 33, 2703, 17, '1', '1', 3, 3, '2010-10-20 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 34, 2205, 2019, '4', '3', 3, 3, '2010-10-20 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 35, 2306, 2605, '2', '0', 3, 3, '2010-10-20 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 36, 9, 3650, '3', '1', 3, 3, '2010-10-20 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 37, 3753, 2123, '1', '1', 3, 3, '2010-10-20 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 38, 2013, 2801, '1', '0', 3, 3, '2010-10-20 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 39, 2107, 3572, '2', '0', 3, 3, '2010-10-20 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 40, 3614, 2901, '0', '0', 3, 3, '2010-10-20 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 41, 2202, 2502, '1', '3', 3, 3, '2010-10-19 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 42, 1, 3740, '3', '2', 3, 3, '2010-10-19 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 43, 2908, 2006, '0', '2', 3, 3, '2010-10-19 18:30:00', 'F', '', '', 0, '', ''),(2011, 45, 44, 2307, 3811, '1', '0', 3, 3, '2010-10-19 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 45, 2115, 2200, '2', '0', 3, 3, '2010-10-19 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 46, 2700, 2300, '2', '1', 3, 3, '2010-10-19 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 47, 2000, 3834, '5', '1', 3, 3, '2010-10-19 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 48, 2606, 3802, '2', '0', 3, 3, '2010-10-19 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 49, 2019, 2205, '3', '1', 4, 3, '2010-11-02 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 50, 17, 2703, '0', '2', 4, 3, '2010-11-02 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 51, 2605, 2306, '4', '3', 4, 3, '2010-11-02 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 52, 3650, 9, '0', '0', 4, 3, '2010-11-02 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 53, 2801, 2013, '0', '3', 4, 3, '2010-11-02 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 54, 2123, 3753, '3', '0', 4, 3, '2010-11-02 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 55, 3572, 2107, '1', '1', 4, 3, '2010-11-02 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 56, 2901, 3614, '0', '0', 4, 3, '2010-11-02 18:30:00', 'D', '', '', 0, '', ''),(2011, 45, 57, 3740, 1, '0', '4', 4, 3, '2010-11-03 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 58, 2502, 2202, '2', '3', 4, 3, '2010-11-03 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 59, 3811, 2307, '0', '7', 4, 3, '2010-11-03 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 60, 2006, 2908, '4', '1', 4, 3, '2010-11-03 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 61, 2200, 2115, '2', '2', 4, 3, '2010-11-03 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 62, 2300, 2700, '2', '1', 4, 3, '2010-11-03 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 63, 3834, 2000, '2', '1', 4, 3, '2010-11-03 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 64, 3802, 2606, '0', '1', 4, 3, '2010-11-03 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 65, 2019, 17, '3', '0', 5, 3, '2010-11-24 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 66, 2205, 2703, '1', '0', 5, 3, '2010-11-24 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 67, 9, 2306, '3', '0', 5, 3, '2010-11-24 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 68, 3650, 2605, '3', '0', 5, 3, '2010-11-24 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 69, 3753, 2013, '0', '1', 5, 3, '2010-11-24 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 70, 2123, 2801, '6', '1', 5, 3, '2010-11-24 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 71, 3614, 2107, '0', '3', 5, 3, '2010-11-24 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 72, 2901, 3572, '1', '0', 5, 3, '2010-11-24 18:30:00', 'D', '', '', 0, '', ''),(2011, 45, 73, 2202, 1, '3', '2', 5, 3, '2010-11-23 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 74, 2502, 3740, '1', '0', 5, 3, '2010-11-23 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 75, 2908, 2307, '0', '3', 5, 3, '2010-11-23 18:30:00', 'F', '', '', 0, '', ''),(2011, 45, 76, 2006, 3811, '2', '1', 5, 3, '2010-11-23 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 77, 2300, 2200, '0', '2', 5, 3, '2010-11-23 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 78, 2700, 2115, '0', '4', 5, 3, '2010-11-23 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 79, 2606, 2000, '2', '0', 5, 3, '2010-11-23 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 80, 3802, 3834, '0', '3', 5, 3, '2010-11-23 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 81, 17, 2205, '3', '0', 6, 3, '2010-12-07 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 82, 2703, 2019, '3', '3', 6, 3, '2010-12-07 20:45:00', 'A', '', '', 0, '', ''),(2011, 45, 83, 2605, 9, '1', '2', 6, 3, '2010-12-07 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 84, 2306, 3650, '2', '2', 6, 3, '2010-12-07 20:45:00', 'B', '', '', 0, '', ''),(2011, 45, 85, 2013, 2123, '1', '1', 6, 3, '2010-12-07 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 86, 2801, 3753, '1', '1', 6, 3, '2010-12-07 20:45:00', 'C', '', '', 0, '', ''),(2011, 45, 87, 3572, 3614, '3', '1', 6, 3, '2010-12-07 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 88, 2107, 2901, '2', '0', 6, 3, '2010-12-07 20:45:00', 'D', '', '', 0, '', ''),(2011, 45, 89, 3740, 2202, '1', '1', 6, 3, '2010-12-08 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 90, 1, 2502, '3', '0', 6, 3, '2010-12-08 20:45:00', 'E', '', '', 0, '', ''),(2011, 45, 91, 2307, 2006, '1', '0', 6, 3, '2010-12-08 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 92, 3811, 2908, '1', '2', 6, 3, '2010-12-08 20:45:00', 'F', '', '', 0, '', ''),(2011, 45, 93, 2200, 2700, '0', '2', 6, 3, '2010-12-08 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 94, 2115, 2300, '4', '0', 6, 3, '2010-12-08 20:45:00', 'G', '', '', 0, '', ''),(2011, 45, 95, 3834, 2606, '2', '0', 6, 3, '2010-12-08 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 96, 2000, 3802, '3', '1', 6, 3, '2010-12-08 20:45:00', 'H', '', '', 0, '', ''),(2011, 45, 97, 2200, 2019, '0', '1', 7, 3, '2011-02-15 20:45:00', '', '', '', 0, '', ''),(2011, 45, 98, 2123, 9, '1', '1', 7, 3, '2011-02-15 20:45:00', '', '', '', 0, '', ''),(2011, 45, 99, 2202, 3834, '2', '3', 7, 3, '2011-02-16 20:45:00', '', '', '', 0, '', ''),(2011, 45, 100, 2000, 2107, '2', '1', 7, 3, '2011-02-16 20:45:00', '', '', '', 0, '', ''),(2011, 45, 101, 2306, 2115, '1', '1', 7, 3, '2011-02-22 20:45:00', '', '', '', 0, '', ''),(2011, 45, 102, 3572, 2006, '0', '2', 7, 3, '2011-02-22 20:45:00', '', '', '', 0, '', ''),(2011, 45, 103, 2205, 1, '0', '1', 7, 3, '2011-02-23 20:45:00', '', '', '', 0, '', ''),(2011, 45, 104, 2307, 2013, '0', '0', 7, 3, '2011-02-23 20:45:00', '', '', '', 0, '', ''),(2011, 45, 105, 3834, 2202, '3', '0', 8, 3, '2011-03-08 20:45:00', '', '', '', 1, '', ''),(2011, 45, 106, 2107, 2000, '3', '1', 8, 3, '2011-03-08 20:45:00', '', '', '', 1, '', ''),(2011, 45, 107, 2019, 2200, '0', '0', 8, 3, '2011-03-09 20:45:00', '', '', '', 1, '', ''),(2011, 45, 108, 9, 2123, '3', '1', 8, 3, '2011-03-09 20:45:00', '', '', '', 1, '', ''),(2011, 45, 109, 1, 2205, '2', '3', 8, 3, '2011-03-15 20:45:00', '', '', '', 1, '', ''),(2011, 45, 110, 2013, 2307, '2', '1', 8, 3, '2011-03-15 20:45:00', '', '', '', 1, '', ''),(2011, 45, 111, 2115, 2306, '3', '0', 8, 3, '2011-03-16 20:45:00', '', '', '', 1, '', ''),(2011, 45, 112, 2006, 3572, '0', '0', 8, 3, '2011-03-16 20:45:00', '', '', '', 1, '', ''),(2011, 45, 113, 2115, 2019, '4', '0', 9, 3, '2011-04-05 20:45:00', '', 'D', 'D', 0, '', ''),(2011, 45, 114, 2006, 2013, '0', '1', 9, 3, '2011-04-06 20:45:00', '', 'D', 'D', 0, '', ''),(2011, 45, 115, 2107, 3834, '5', '1', 9, 3, '2011-04-06 20:45:00', '', 'D', 'D', 0, '', ''),(2011, 45, 116, 2205, 9, '2', '5', 9, 3, '2011-04-05 20:45:00', '', 'D', 'D', 0, '', ''),(2011, 45, 117, 2019, 2115, '0', '1', 9, 3, '2011-04-13 20:45:00', '', 'D', 'D', 1, '', ''),(2011, 45, 118, 2013, 2006, '2', '1', 9, 3, '2011-04-12 20:45:00', '', 'D', 'D', 1, '', ''),(2011, 45, 119, 3834, 2107, '0', '1', 9, 3, '2011-04-12 20:45:00', '', 'D', 'D', 1, '', ''),(2011, 45, 120, 9, 2205, '2', '1', 9, 3, '2011-04-13 20:45:00', '', 'D', 'D', 1, '', ''),(2011, 45, 121, 9, 2013, '0', '2', 10, 3, '2011-04-26 20:45:00', '', 'W 116;120', 'W 114;118', 0, '', ''),(2011, 45, 122, 2115, 2107, '0', '2', 10, 3, '2011-04-27 20:45:00', '', 'W 113;117', 'W 115;119', 0, '', ''),(2011, 45, 123, 2013, 9, '4', '1', 10, 3, '2011-05-04 20:45:00', '', 'W 114;118', 'W 116;120', 1, '', ''),(2011, 45, 124, 2107, 2115, '1', '1', 10, 3, '2011-05-03 20:45:00', '', 'W 115;119', 'W 113;117', 1, '', ''),(2011, 45, 125, 2107, 2013, '3', '1', 10, 3, '2011-05-28 20:45:00', '', 'W 122;124', 'W 121;123', 1, '', '');