# # Football Mod Backup League Script # Dump of # Season 2012 # League 40 (EM 2012) # DATE : 24-07-2012 21:11:48 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, 40, 'EM 2012', 'EM', 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, 40, 1, 3, '2012-06-08 15:00:00', '', '', '1.Spieltag', '8') ,(2012, 40, 2, 3, '2012-06-12 15:00:00', '', '', '2.Spieltag', '8') ,(2012, 40, 3, 3, '2012-06-16 15:00:00', '', '', '3.Spieltag', '8') ,(2012, 40, 4, 3, '2012-07-01 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, 40, 6108, 'Dänemark', 'Dänemark', 'Denmark.png', 'B', 3) ,(2012, 40, 6110, 'Deutschland', 'Deutschl.', 'Germany.png', 'B', 4) ,(2012, 40, 6111, 'England', 'England', 'England.png', 'D', 4) ,(2012, 40, 6115, 'Frankreich', 'Frankr.', 'France.png', 'D', 4) ,(2012, 40, 6117, 'Griechenland', 'Griechenl.', 'Greece.png', 'A', 4) ,(2012, 40, 6118, 'Irland', 'Irland', 'Ireland.png', 'C', 3) ,(2012, 40, 6121, 'Italien', 'Italien', 'Italy.png', 'C', 4) ,(2012, 40, 6124, 'Kroatien', 'Kroatien', 'Croatia.png', 'C', 3) ,(2012, 40, 6133, 'Niederlande', 'Holland', 'Netherlands.png', 'B', 3) ,(2012, 40, 6137, 'Polen', 'Polen', 'Poland.png', 'A', 3) ,(2012, 40, 6138, 'Portugal', 'Portugal', 'Portugal.png', 'B', 4) ,(2012, 40, 6140, 'Russland', 'Russland', 'Russia.png', 'A', 3) ,(2012, 40, 6144, 'Schweden', 'Schweden', 'Sweden.png', 'D', 3) ,(2012, 40, 6149, 'Spanien', 'Spanien', 'Spain.png', 'C', 4) ,(2012, 40, 6150, 'Tschechien', 'Tschechien', 'Czech-Republic.png', 'A', 4) ,(2012, 40, 6154, 'Ukraine', 'Ukraine', 'Ukraine.png', 'D', 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 (2012, 40, 1, 6137, 6117, '1', '1', 1, 3, '2012-06-08 18:00:00', 'A', '', '', 0, '', '') ,(2012, 40, 2, 6140, 6150, '4', '1', 1, 3, '2012-06-08 20:45:00', 'A', '', '', 0, '', '') ,(2012, 40, 3, 6133, 6108, '0', '1', 1, 3, '2012-06-09 18:00:00', 'B', '', '', 0, '', '') ,(2012, 40, 4, 6110, 6138, '1', '0', 1, 3, '2012-06-09 20:45:00', 'B', '', '', 0, '', '') ,(2012, 40, 5, 6149, 6121, '1', '1', 1, 3, '2012-06-10 18:00:00', 'C', '', '', 0, '', '') ,(2012, 40, 6, 6118, 6124, '1', '3', 1, 3, '2012-06-10 20:45:00', 'C', '', '', 0, '', '') ,(2012, 40, 7, 6115, 6111, '1', '1', 1, 3, '2012-06-11 18:00:00', 'D', '', '', 0, '', '') ,(2012, 40, 8, 6154, 6144, '2', '1', 1, 3, '2012-06-11 20:45:00', 'D', '', '', 0, '', '') ,(2012, 40, 9, 6117, 6150, '1', '2', 2, 3, '2012-06-12 18:00:00', 'A', '', '', 0, '', '') ,(2012, 40, 10, 6137, 6140, '1', '1', 2, 3, '2012-06-12 20:45:00', 'A', '', '', 0, '', '') ,(2012, 40, 11, 6108, 6138, '2', '3', 2, 3, '2012-06-13 18:00:00', 'B', '', '', 0, '', '') ,(2012, 40, 12, 6133, 6110, '1', '2', 2, 3, '2012-06-13 20:45:00', 'B', '', '', 0, '', '') ,(2012, 40, 13, 6121, 6124, '1', '1', 2, 3, '2012-06-14 18:00:00', 'C', '', '', 0, '', '') ,(2012, 40, 14, 6149, 6118, '4', '0', 2, 3, '2012-06-14 20:45:00', 'C', '', '', 0, '', '') ,(2012, 40, 15, 6144, 6111, '2', '3', 2, 3, '2012-06-15 21:00:00', 'D', '', '', 0, '', '') ,(2012, 40, 16, 6154, 6115, '0', '2', 2, 3, '2012-06-15 18:00:00', 'D', '', '', 0, '', '') ,(2012, 40, 17, 6150, 6137, '1', '0', 3, 3, '2012-06-16 20:45:00', 'A', '', '', 0, '', '') ,(2012, 40, 18, 6117, 6140, '1', '0', 3, 3, '2012-06-16 20:45:00', 'A', '', '', 0, '', '') ,(2012, 40, 19, 6138, 6133, '2', '1', 3, 3, '2012-06-17 20:45:00', 'B', '', '', 0, '', '') ,(2012, 40, 20, 6108, 6110, '1', '2', 3, 3, '2012-06-17 20:45:00', 'B', '', '', 0, '', '') ,(2012, 40, 21, 6124, 6149, '0', '1', 3, 3, '2012-06-18 20:45:00', 'C', '', '', 0, '', '') ,(2012, 40, 22, 6121, 6118, '2', '0', 3, 3, '2012-06-18 20:45:00', 'C', '', '', 0, '', '') ,(2012, 40, 23, 6111, 6154, '1', '0', 3, 3, '2012-06-19 20:45:00', 'D', '', '', 0, '', '') ,(2012, 40, 24, 6144, 6115, '2', '0', 3, 3, '2012-06-19 20:45:00', 'D', '', '', 0, '', '') ,(2012, 40, 25, 6150, 6138, '0', '1', 4, 3, '2012-06-21 20:45:00', '', 'G A1', 'G B2', 1, '', '') ,(2012, 40, 26, 6110, 6117, '4', '2', 4, 3, '2012-06-22 20:45:00', '', 'G B1', 'G A2', 1, '', '') ,(2012, 40, 27, 6149, 6115, '2', '0', 4, 3, '2012-06-23 20:45:00', '', 'G C1', 'G D2', 1, '', '') ,(2012, 40, 28, 6111, 6121, '0', '0', 4, 3, '2012-06-24 20:45:00', '', 'G D1', 'G C2', 1, '2', '4') ,(2012, 40, 29, 6138, 6149, '0', '0', 4, 3, '2012-06-27 20:45:00', '', 'W 25', 'W 27', 1, '2', '4') ,(2012, 40, 30, 6110, 6121, '1', '2', 4, 3, '2012-06-28 20:45:00', '', 'W 26', 'W 28', 1, '', '') ,(2012, 40, 31, 6149, 6121, '4', '0', 4, 3, '2012-07-01 20:45:00', '', 'W 29', 'W 30', 1, '', '');