# # Extension Football Prediction League - Football Backup Script # Dump of # Season 2018 # League 60 (WM 2018) # DATE : 29-07-2018 09:41:10 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 (2018, 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 (2018, 60, 1, 3, '2018-06-14 12:00:00', '', '', 'Gruppenphase 1. Spieltag', '16'),(2018, 60, 2, 3, '2018-06-19 19:00:00', '', '', 'Gruppenphase 2. Spieltag', '16'),(2018, 60, 3, 3, '2018-06-25 12:00:00', '', '', 'Gruppenphase 3. Spieltag', '16'),(2018, 60, 4, 3, '2018-06-30 16:00:00', '', '', 'Achtelfinale', '8'),(2018, 60, 5, 2, '2018-07-14 16: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 (2018, 60, 6104, 'Belgien', 'Belgien', 'Belgium.png', 'G', 4),(2018, 60, 6108, 'Dänemark', 'Dänemark', 'Denmark.png', 'C', 4),(2018, 60, 6110, 'Deutschland', 'Deutschl.', 'Germany.png', 'F', 3),(2018, 60, 6111, 'England', 'England', 'England.png', 'G', 4),(2018, 60, 6115, 'Frankreich', 'Frankr.', 'France.png', 'C', 4),(2018, 60, 6119, 'Island', 'Island', 'Iceland.png', 'D', 3),(2018, 60, 6124, 'Kroatien', 'Kroatien', 'Croatia.png', 'D', 4),(2018, 60, 6137, 'Polen', 'Polen', 'Poland.png', 'H', 3),(2018, 60, 6138, 'Portugal', 'Portugal', 'Portugal.png', 'B', 4),(2018, 60, 6140, 'Russland', 'Russland', 'Russia.png', 'A', 4),(2018, 60, 6144, 'Schweden', 'Schweden', 'Sweden.png', 'F', 4),(2018, 60, 6145, 'Schweiz', 'Schweiz', 'Switzerland.png', 'E', 4),(2018, 60, 6146, 'Serbien', 'Serbien', 'Serbia.png', 'E', 3),(2018, 60, 6149, 'Spanien', 'Spanien', 'Spain.png', 'B', 4),(2018, 60, 6200, 'Argentinien', 'Argentina', 'Argentina.png', 'D', 4),(2018, 60, 6202, 'Brasilien', 'Brasilien', 'Brazil.png', 'E', 4),(2018, 60, 6205, 'Kolumbien', 'Kolumbien', 'Colombia.png', 'H', 4),(2018, 60, 6207, 'Peru', 'Peru', 'Peru.png', 'C', 3),(2018, 60, 6208, 'Uruguay', 'Uruguay', 'Uruguay.png', 'A', 4),(2018, 60, 6301, 'Australien', 'Austral.', 'Australia.png', 'C', 3),(2018, 60, 6312, 'Iran', 'Iran', 'Iran.png', 'B', 3),(2018, 60, 6313, 'Japan', 'Japan', 'Japan.png', 'H', 4),(2018, 60, 6336, 'Saudi-Arabien', 'Saudi-Ar.', 'Saudi-Arabia.png', 'A', 3),(2018, 60, 6340, 'Südkorea', 'Südkorea', 'South-Korea.png', 'F', 3),(2018, 60, 6407, 'Costa Rica', 'Costa Rica', 'Costa-Rica.png', 'E', 3),(2018, 60, 6425, 'Mexiko', 'Mexiko', 'Mexico.png', 'F', 4),(2018, 60, 6429, 'Panama', 'Panama', 'Panama.png', 'G', 3),(2018, 60, 6500, 'Ägypten', 'Ägypten', 'Egypt.png', 'A', 3),(2018, 60, 6529, 'Marokko', 'Marokko', 'Morocco.png', 'B', 3),(2018, 60, 6535, 'Nigeria', 'Nigeria', 'Nigeria.png', 'D', 3),(2018, 60, 6541, 'Senegal', 'Senegal', 'Senegal.png', 'H', 3),(2018, 60, 6552, 'Tunesien', 'Tunesien', 'Tunisia.png', 'G', 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, trend, odd_1, odd_x, odd_2, rating) VALUES (2018, 60, 1, 6140, 6336, '5', '0', 1, 3, '2018-06-14 17:00:00', 'A', 'D', 'D', 0, '', '', '0|10|90', 0.00, 0.00, 0.00, 0.00),(2018, 60, 2, 6500, 6208, '0', '1', 1, 3, '2018-06-15 14:00:00', 'A', 'D', 'D', 0, '', '', '0|10|90', 0.00, 0.00, 0.00, 0.00),(2018, 60, 3, 6529, 6312, '0', '1', 1, 3, '2018-06-15 17:00:00', 'B', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 4, 6138, 6149, '3', '3', 1, 3, '2018-06-15 20:00:00', 'B', 'D', 'D', 0, '', '', '23|27|50', 0.00, 0.00, 0.00, 0.00),(2018, 60, 5, 6115, 6301, '2', '1', 1, 3, '2018-06-16 12:00:00', 'C', 'D', 'D', 0, '', '', '53|20|27', 0.00, 0.00, 0.00, 0.00),(2018, 60, 6, 6207, 6108, '0', '1', 1, 3, '2018-06-16 18:00:00', 'C', 'D', 'D', 0, '', '', '0|10|90', 0.00, 0.00, 0.00, 0.00),(2018, 60, 7, 6200, 6119, '1', '1', 1, 3, '2018-06-16 15:00:00', 'D', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 8, 6124, 6535, '2', '0', 1, 3, '2018-06-16 21:00:00', 'D', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 9, 6407, 6146, '0', '1', 1, 3, '2018-06-17 14:00:00', 'E', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 10, 6202, 6145, '1', '1', 1, 3, '2018-06-17 20:00:00', 'E', 'D', 'D', 0, '', '', '41|29|30', 0.00, 0.00, 0.00, 0.00),(2018, 60, 11, 6110, 6425, '0', '1', 1, 3, '2018-06-17 17:00:00', 'F', 'D', 'D', 0, '', '', '43|38|19', 0.00, 0.00, 0.00, 0.00),(2018, 60, 12, 6144, 6340, '1', '0', 1, 3, '2018-06-18 14:00:00', 'F', 'D', 'D', 0, '', '', '35|50|15', 0.00, 0.00, 0.00, 0.00),(2018, 60, 13, 6104, 6429, '3', '0', 1, 3, '2018-06-18 17:00:00', 'G', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 14, 6552, 6111, '1', '2', 1, 3, '2018-06-18 20:00:00', 'G', 'D', 'D', 0, '', '', '14|17|69', 0.00, 0.00, 0.00, 0.00),(2018, 60, 15, 6137, 6541, '1', '2', 1, 3, '2018-06-19 17:00:00', 'H', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 16, 6205, 6313, '1', '2', 1, 3, '2018-06-19 14:00:00', 'H', 'D', 'D', 0, '', '', '100|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 17, 6140, 6500, '3', '1', 2, 3, '2018-06-19 20:00:00', 'A', 'D', 'D', 0, '', '', '80|20|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 18, 6208, 6336, '1', '0', 2, 3, '2018-06-20 17:00:00', 'A', 'D', 'D', 0, '', '', '65|17|18', 0.00, 0.00, 0.00, 0.00),(2018, 60, 19, 6138, 6529, '1', '0', 2, 3, '2018-06-20 14:00:00', 'B', 'D', 'D', 0, '', '', '41|23|36', 0.00, 0.00, 0.00, 0.00),(2018, 60, 20, 6312, 6149, '0', '1', 2, 3, '2018-06-20 20:00:00', 'B', 'D', 'D', 0, '', '', '32|33|35', 0.00, 0.00, 0.00, 0.00),(2018, 60, 21, 6115, 6207, '1', '0', 2, 3, '2018-06-21 17:00:00', 'C', 'D', 'D', 0, '', '', '68|10|22', 0.00, 0.00, 0.00, 0.00),(2018, 60, 22, 6108, 6301, '1', '1', 2, 3, '2018-06-21 14:00:00', 'C', 'D', 'D', 0, '', '', '82|0|18', 0.00, 0.00, 0.00, 0.00),(2018, 60, 23, 6200, 6124, '0', '3', 2, 3, '2018-06-21 20:00:00', 'D', 'D', 'D', 0, '', '', '35|26|39', 0.00, 0.00, 0.00, 0.00),(2018, 60, 24, 6535, 6119, '2', '0', 2, 3, '2018-06-22 17:00:00', 'D', 'D', 'D', 0, '', '', '0|23|77', 0.00, 0.00, 0.00, 0.00),(2018, 60, 25, 6202, 6407, '2', '0', 2, 3, '2018-06-22 14:00:00', 'E', 'D', 'D', 0, '', '', '94|6|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 26, 6146, 6145, '1', '2', 2, 3, '2018-06-22 20:00:00', 'E', 'D', 'D', 0, '', '', '19|63|18', 0.00, 0.00, 0.00, 0.00),(2018, 60, 27, 6110, 6144, '2', '1', 2, 3, '2018-06-23 20:00:00', 'F', 'D', 'D', 0, '', '', '15|20|65', 0.00, 0.00, 0.00, 0.00),(2018, 60, 28, 6340, 6425, '1', '2', 2, 3, '2018-06-23 17:00:00', 'F', 'D', 'D', 0, '', '', '3|17|80', 0.00, 0.00, 0.00, 0.00),(2018, 60, 29, 6104, 6552, '5', '2', 2, 3, '2018-06-23 14:00:00', 'G', 'D', 'D', 0, '', '', '67|26|7', 0.00, 0.00, 0.00, 0.00),(2018, 60, 30, 6111, 6429, '6', '1', 2, 3, '2018-06-24 14:00:00', 'G', 'D', 'D', 0, '', '', '80|20|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 31, 6313, 6541, '2', '2', 2, 3, '2018-06-24 17:00:00', 'H', 'D', 'D', 0, '', '', '75|0|25', 0.00, 0.00, 0.00, 0.00),(2018, 60, 32, 6137, 6205, '0', '3', 2, 3, '2018-06-24 20:00:00', 'H', 'D', 'D', 0, '', '', '42|0|58', 0.00, 0.00, 0.00, 0.00),(2018, 60, 33, 6208, 6140, '3', '0', 3, 3, '2018-06-25 16:00:00', 'A', 'D', 'D', 0, '', '', '43|35|22', 0.00, 0.00, 0.00, 0.00),(2018, 60, 34, 6336, 6500, '2', '1', 3, 3, '2018-06-25 16:00:00', 'A', 'D', 'D', 0, '', '', '36|0|64', 0.00, 0.00, 0.00, 0.00),(2018, 60, 35, 6149, 6529, '2', '2', 3, 3, '2018-06-25 20:00:00', 'B', 'D', 'D', 0, '', '', '87|13|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 36, 6312, 6138, '1', '1', 3, 3, '2018-06-25 20:00:00', 'B', 'D', 'D', 0, '', '', '22|23|55', 0.00, 0.00, 0.00, 0.00),(2018, 60, 37, 6108, 6115, '0', '0', 3, 3, '2018-06-26 16:00:00', 'C', 'D', 'D', 0, '', '', '45|10|45', 0.00, 0.00, 0.00, 0.00),(2018, 60, 38, 6301, 6207, '0', '2', 3, 3, '2018-06-26 16:00:00', 'C', 'D', 'D', 0, '', '', '67|33|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 39, 6119, 6124, '1', '2', 3, 3, '2018-06-26 20:00:00', 'D', 'D', 'D', 0, '', '', '11|6|83', 0.00, 0.00, 0.00, 0.00),(2018, 60, 40, 6535, 6200, '1', '2', 3, 3, '2018-06-26 20:00:00', 'D', 'D', 'D', 0, '', '', '64|13|23', 0.00, 0.00, 0.00, 0.00),(2018, 60, 41, 6146, 6202, '0', '2', 3, 3, '2018-06-27 20:00:00', 'E', 'D', 'D', 0, '', '', '27|21|52', 0.00, 0.00, 0.00, 0.00),(2018, 60, 42, 6145, 6407, '2', '2', 3, 3, '2018-06-27 20:00:00', 'E', 'D', 'D', 0, '', '', '65|13|22', 0.00, 0.00, 0.00, 0.00),(2018, 60, 43, 6425, 6144, '0', '3', 3, 3, '2018-06-27 16:00:00', 'F', 'D', 'D', 0, '', '', '48|17|35', 0.00, 0.00, 0.00, 0.00),(2018, 60, 44, 6340, 6110, '2', '0', 3, 3, '2018-06-27 16:00:00', 'F', 'D', 'D', 0, '', '', '16|0|84', 0.00, 0.00, 0.00, 0.00),(2018, 60, 45, 6111, 6104, '0', '1', 3, 3, '2018-06-28 20:00:00', 'G', 'D', 'D', 0, '', '', '59|15|26', 0.00, 0.00, 0.00, 0.00),(2018, 60, 46, 6429, 6552, '1', '2', 3, 3, '2018-06-28 20:00:00', 'G', 'D', 'D', 0, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 47, 6541, 6205, '0', '1', 3, 3, '2018-06-28 16:00:00', 'H', 'D', 'D', 0, '', '', '20|30|50', 0.00, 0.00, 0.00, 0.00),(2018, 60, 48, 6313, 6137, '0', '1', 3, 3, '2018-06-28 16:00:00', 'H', 'D', 'D', 0, '', '', '87|13|0', 0.00, 0.00, 0.00, 0.00),(2018, 60, 49, 6115, 6200, '4', '3', 4, 3, '2018-06-30 16:00:00', '', 'G C1', 'G D2', 1, '', '', '37|22|41', 0.00, 0.00, 0.00, 0.00),(2018, 60, 50, 6208, 6138, '2', '1', 4, 3, '2018-06-30 20:00:00', '', 'G A1', 'G B2', 1, '', '', '38|27|35', 0.00, 0.00, 0.00, 0.00),(2018, 60, 51, 6149, 6140, '1', '1', 4, 3, '2018-07-01 16:00:00', '', 'G B1', 'G A2', 1, '4', '5', '48|27|25', 0.00, 0.00, 0.00, 0.00),(2018, 60, 52, 6124, 6108, '1', '1', 4, 3, '2018-07-01 20:00:00', '', 'G D1', 'G C2', 1, '4', '3', '41|18|41', 0.00, 0.00, 0.00, 0.00),(2018, 60, 53, 6202, 6425, '2', '0', 4, 3, '2018-07-02 16:00:00', '', 'G E1', 'G F2', 1, '', '', '39|15|46', 0.00, 0.00, 0.00, 0.00),(2018, 60, 54, 6104, 6313, '3', '2', 4, 3, '2018-07-02 20:00:00', '', 'G G1', 'G H2', 1, '', '', '39|24|37', 0.00, 0.00, 0.00, 0.00),(2018, 60, 55, 6144, 6145, '1', '0', 4, 3, '2018-07-03 16:00:00', '', 'G F1', 'G E2', 1, '', '', '39|23|38', 0.00, 0.00, 0.00, 0.00),(2018, 60, 56, 6205, 6111, '1', '1', 4, 3, '2018-07-03 20:00:00', '', 'G H1', 'G G2', 1, '4', '5', '19|22|59', 0.00, 0.00, 0.00, 0.00),(2018, 60, 57, 6208, 6115, '0', '2', 5, 3, '2018-07-06 16:00:00', '', 'W 49', 'W 50', 1, '', '', '41|30|29', 0.00, 0.00, 0.00, 0.00),(2018, 60, 58, 6202, 6104, '1', '2', 5, 3, '2018-07-06 20:00:00', '', 'W 53', 'W 54', 1, '', '', '44|3|53', 0.00, 0.00, 0.00, 0.00),(2018, 60, 59, 6144, 6111, '0', '2', 5, 3, '2018-07-07 16:00:00', '', 'W 55', 'W 56', 1, '', '', '38|26|36', 0.00, 0.00, 0.00, 0.00),(2018, 60, 60, 6140, 6124, '1', '1', 5, 3, '2018-07-07 20:00:00', '', 'W 51', 'W 52', 1, '5', '6', '24|41|35', 0.00, 0.00, 0.00, 0.00),(2018, 60, 61, 6115, 6104, '1', '0', 5, 3, '2018-07-10 20:00:00', '', 'W 57', 'W 58', 1, '', '', '36|18|46', 0.00, 0.00, 0.00, 0.00),(2018, 60, 62, 6124, 6111, '1', '1', 5, 3, '2018-07-11 20:00:00', '', 'W 60', 'W 59', 1, '2', '1', '40|14|46', 0.00, 0.00, 0.00, 0.00),(2018, 60, 63, 6104, 6111, '2', '0', 5, 3, '2018-07-14 16:00:00', '', 'L 61', 'L 62', 1, '', '', '42|17|41', 0.00, 0.00, 0.00, 0.00),(2018, 60, 64, 6115, 6124, '4', '2', 5, 2, '2018-07-15 17:00:00', '', 'W 61', 'W 62', 1, '', '', '35|30|35', 0.00, 0.00, 0.00, 0.00);