# # Football Mod Backup League Script # Dump of # Season 2014 # League 60 (WM) # DATE : 24-07-2014 20:43:20 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 (2014, 60, 'WM', 'WM', 2, 5, 0, '0', '0', '0', '0', 1, 10, 3, 0, 0, 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 (2014, 60, 1, 3, '2014-06-12 18:00:00', '', '', 'Gruppenphase 1. Spieltag', '16'),(2014, 60, 2, 3, '2014-06-17 18:00:00', '', '', 'Gruppenphase 2. Spieltag', '16'),(2014, 60, 3, 3, '2014-06-23 18:00:00', '', '', 'Gruppenphase 3. Spieltag', '16'),(2014, 60, 4, 3, '2014-06-28 18:00:00', '', '', 'Achtelfinale', '8'),(2014, 60, 5, 3, '2014-07-12 18: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 (2014, 60, 6104, 'Belgien', 'Belgien', 'Belgium.png', 'H', 4),(2014, 60, 6106, 'Bosnien-Herzegowina', 'Bosnien-H.', 'Bosnia-Herzegovina.png', 'F', 3),(2014, 60, 6110, 'Deutschland', 'Deutschl.', 'Germany.png', 'G', 4),(2014, 60, 6111, 'England', 'England', 'England.png', 'D', 3),(2014, 60, 6115, 'Frankreich', 'Frankr.', 'France.png', 'E', 4),(2014, 60, 6117, 'Griechenland', 'Griechenl.', 'Greece.png', 'C', 4),(2014, 60, 6121, 'Italien', 'Italien', 'Italy.png', 'D', 3),(2014, 60, 6124, 'Kroatien', 'Kroatien', 'Croatia.png', 'A', 3),(2014, 60, 6133, 'Niederlande', 'Holland', 'Netherlands.png', 'B', 4),(2014, 60, 6138, 'Portugal', 'Portugal', 'Portugal.png', 'G', 3),(2014, 60, 6140, 'Russland', 'Russland', 'Russia.png', 'H', 3),(2014, 60, 6145, 'Schweiz', 'Schweiz', 'Switzerland.png', 'E', 4),(2014, 60, 6149, 'Spanien', 'Spanien', 'Spain.png', 'B', 3),(2014, 60, 6200, 'Argentinien', 'Argentina', 'Argentina.png', 'F', 4),(2014, 60, 6202, 'Brasilien', 'Brasilien', 'Brazil.png', 'A', 4),(2014, 60, 6203, 'Chile', 'Chile', 'Chile.png', 'B', 4),(2014, 60, 6204, 'Ecuador', 'Ecuador', 'Ecuador.png', 'E', 3),(2014, 60, 6205, 'Kolumbien', 'Kolumbien', 'Colombia.png', 'C', 4),(2014, 60, 6208, 'Uruguay', 'Uruguay', 'Uruguay.png', 'D', 4),(2014, 60, 6301, 'Australien', 'Austral.', 'Australia.png', 'B', 3),(2014, 60, 6312, 'Iran', 'Iran', 'Iran.png', 'F', 3),(2014, 60, 6313, 'Japan', 'Japan', 'Japan.png', 'C', 3),(2014, 60, 6340, 'Südkorea', 'Südkorea', 'South-Korea.png', 'H', 3),(2014, 60, 6407, 'Costa Rica', 'Costa Rica', 'Costa-Rica.png', 'D', 4),(2014, 60, 6419, 'Honduras', 'Honduras', 'Honduras.png', 'E', 3),(2014, 60, 6425, 'Mexiko', 'Mexiko', 'Mexico.png', 'A', 4),(2014, 60, 6439, 'USA', 'USA', 'United-States.png', 'G', 4),(2014, 60, 6501, 'Algerien', 'Algerien', 'Algeria.png', 'H', 4),(2014, 60, 6511, 'Elfenbeinküste', 'Elfenbein', 'Cote-dIvoire.png', 'C', 3),(2014, 60, 6515, 'Ghana', 'Ghana', 'Ghana.png', 'G', 3),(2014, 60, 6518, 'Kamerun', 'Kamerun', 'Cameroon.png', 'A', 3),(2014, 60, 6535, 'Nigeria', 'Nigeria', 'Nigeria.png', 'F', 4); 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 (2014, 60, 1, 6202, 6124, '3', '1', 1, 3, '2014-06-12 22:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 2, 6425, 6518, '1', '0', 1, 3, '2014-06-13 18:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 3, 6149, 6133, '1', '5', 1, 3, '2014-06-13 21:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 4, 6203, 6301, '3', '1', 1, 3, '2014-06-14 00:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 5, 6205, 6117, '3', '0', 1, 3, '2014-06-14 18:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 6, 6208, 6407, '1', '3', 1, 3, '2014-06-14 21:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 7, 6111, 6121, '1', '2', 1, 3, '2014-06-15 00:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 8, 6511, 6313, '2', '1', 1, 3, '2014-06-15 03:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 9, 6145, 6204, '2', '1', 1, 3, '2014-06-15 18:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 10, 6115, 6419, '3', '0', 1, 3, '2014-06-15 21:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 11, 6200, 6106, '2', '1', 1, 3, '2014-06-16 00:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 12, 6110, 6138, '4', '0', 1, 3, '2014-06-16 18:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 13, 6312, 6535, '0', '0', 1, 3, '2014-06-16 21:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 14, 6515, 6439, '1', '2', 1, 3, '2014-06-17 00:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 15, 6104, 6501, '2', '1', 1, 3, '2014-06-17 18:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 16, 6140, 6340, '1', '1', 1, 3, '2014-06-18 00:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 17, 6202, 6425, '0', '0', 2, 3, '2014-06-17 21:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 18, 6301, 6133, '2', '3', 2, 3, '2014-06-18 18:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 19, 6149, 6203, '0', '2', 2, 3, '2014-06-18 21:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 20, 6518, 6124, '0', '4', 2, 3, '2014-06-19 00:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 21, 6205, 6511, '2', '1', 2, 3, '2014-06-19 18:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 22, 6208, 6111, '2', '1', 2, 3, '2014-06-19 21:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 23, 6313, 6117, '0', '0', 2, 3, '2014-06-20 00:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 24, 6121, 6407, '0', '1', 2, 3, '2014-06-20 18:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 25, 6145, 6115, '2', '5', 2, 3, '2014-06-20 21:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 26, 6419, 6204, '1', '2', 2, 3, '2014-06-21 00:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 27, 6200, 6312, '1', '0', 2, 3, '2014-06-21 18:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 28, 6110, 6515, '2', '2', 2, 3, '2014-06-21 21:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 29, 6535, 6106, '1', '0', 2, 3, '2014-06-22 00:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 30, 6104, 6140, '1', '0', 2, 3, '2014-06-22 18:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 31, 6340, 6501, '2', '4', 2, 3, '2014-06-22 21:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 32, 6439, 6138, '2', '2', 2, 3, '2014-06-23 00:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 33, 6301, 6149, '0', '3', 3, 3, '2014-06-23 18:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 34, 6133, 6203, '2', '0', 3, 3, '2014-06-23 18:00:00', 'B', 'D', 'D', 0, '', ''),(2014, 60, 35, 6518, 6202, '1', '4', 3, 3, '2014-06-23 22:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 36, 6124, 6425, '1', '3', 3, 3, '2014-06-23 22:00:00', 'A', 'D', 'D', 0, '', ''),(2014, 60, 37, 6121, 6208, '0', '1', 3, 3, '2014-06-24 18:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 38, 6407, 6111, '0', '0', 3, 3, '2014-06-24 18:00:00', 'D', 'D', 'D', 0, '', ''),(2014, 60, 39, 6313, 6205, '1', '4', 3, 3, '2014-06-24 22:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 40, 6117, 6511, '2', '1', 3, 3, '2014-06-24 22:00:00', 'C', 'D', 'D', 0, '', ''),(2014, 60, 41, 6535, 6200, '2', '3', 3, 3, '2014-06-25 18:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 42, 6106, 6312, '3', '1', 3, 3, '2014-06-25 18:00:00', 'F', 'D', 'D', 0, '', ''),(2014, 60, 43, 6419, 6145, '0', '3', 3, 3, '2014-06-25 22:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 44, 6204, 6115, '0', '0', 3, 3, '2014-06-25 22:00:00', 'E', 'D', 'D', 0, '', ''),(2014, 60, 45, 6138, 6515, '2', '1', 3, 3, '2014-06-26 18:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 46, 6439, 6110, '0', '1', 3, 3, '2014-06-26 18:00:00', 'G', 'D', 'D', 0, '', ''),(2014, 60, 47, 6340, 6104, '0', '1', 3, 3, '2014-06-26 22:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 48, 6501, 6140, '1', '1', 3, 3, '2014-06-26 22:00:00', 'H', 'D', 'D', 0, '', ''),(2014, 60, 49, 6202, 6203, '1', '1', 4, 3, '2014-06-28 18:00:00', '', 'G A1', 'G B2', 1, '4', '3'),(2014, 60, 50, 6205, 6208, '2', '0', 4, 3, '2014-06-28 22:00:00', '', 'G C1', 'G D2', 1, '', ''),(2014, 60, 51, 6133, 6425, '2', '1', 4, 3, '2014-06-29 18:00:00', '', 'G B1', 'G A2', 1, '', ''),(2014, 60, 52, 6407, 6117, '1', '1', 4, 3, '2014-06-29 22:00:00', '', 'G D1', 'G C2', 1, '6', '4'),(2014, 60, 53, 6115, 6535, '2', '0', 4, 3, '2014-06-30 18:00:00', '', 'G E1', 'G F2', 1, '', ''),(2014, 60, 54, 6110, 6501, '0', '0', 4, 3, '2014-06-30 22:00:00', '', 'G G1', 'G H2', 1, '2', '1'),(2014, 60, 55, 6200, 6145, '0', '0', 4, 3, '2014-07-01 18:00:00', '', 'G F1', 'G E2', 1, '1', '0'),(2014, 60, 56, 6104, 6439, '0', '0', 4, 3, '2014-07-01 22:00:00', '', 'G H1', 'G G2', 1, '2', '1'),(2014, 60, 57, 6115, 6110, '0', '1', 5, 3, '2014-07-04 18:00:00', '', 'W 53', 'W 54', 1, '', ''),(2014, 60, 58, 6202, 6205, '2', '1', 5, 3, '2014-07-04 22:00:00', '', 'W 49', 'W 50', 1, '', ''),(2014, 60, 59, 6200, 6104, '1', '0', 5, 3, '2014-07-05 18:00:00', '', 'W 55', 'W 56', 1, '', ''),(2014, 60, 60, 6133, 6407, '0', '0', 5, 3, '2014-07-05 22:00:00', '', 'W 51', 'W 52', 1, '4', '3'),(2014, 60, 61, 6202, 6110, '1', '7', 5, 3, '2014-07-08 22:00:00', '', 'W 58', 'W 57', 1, '', ''),(2014, 60, 62, 6133, 6200, '0', '0', 5, 3, '2014-07-09 22:00:00', '', 'W 60', 'W 59', 1, '2', '4'),(2014, 60, 63, 6202, 6133, '0', '3', 5, 3, '2014-07-12 22:00:00', '', 'L 61', 'L 62', 1, '', ''),(2014, 60, 64, 6110, 6200, '0', '0', 5, 3, '2014-07-13 21:00:00', '', 'W 61', 'W 62', 1, '1', '0');