Willkommen im Thread für die Daten- und Ergebnisupdates für den Formel1 WebTipp von Dr.Death.
Diese sind SQL-Anweisungen, die ihr in der Datenbank, in der auch das Forum ist, ausführen müsst. Außerdem muss gegebenenfalls der Präfix "phpbb_" angepasst werden.
Die aktuellsten Ergebnisse sind grün hervorgehoben.
Die Saison 2010 ist zu Ende! Danke für die Benutzung der Updates! Im Frühjahr geht es dann weiter!
1. Korrekturen der Daten der Rennen:
Code: Alles auswählen
UPDATE phpbb_formel_races SET race_time = 1268568000, race_length = '6,299', race_laps = 49, race_distance = '308,651' WHERE race_id = 1;
UPDATE phpbb_formel_races SET race_time = 1269756000, race_length = '5,303', race_laps = 58, race_distance = '307,574' WHERE race_id = 2;
UPDATE phpbb_formel_races SET race_time = 1270368000, race_length = '5,543', race_laps = 56, race_distance = '310,408' WHERE race_id = 3;
UPDATE phpbb_formel_races SET race_time = 1271574000, race_length = '5,451', race_laps = 56, race_distance = '305,256' WHERE race_id = 4;
UPDATE phpbb_formel_races SET race_time = 1273406400, race_length = '4,655', race_laps = 66, race_distance = '307,230' WHERE race_id = 5;
UPDATE phpbb_formel_races SET race_time = 1274011200, race_length = '3,340', race_laps = 78, race_distance = '260,520' WHERE race_id = 6;
UPDATE phpbb_formel_races SET race_time = 1275220800, race_length = '5,338', race_laps = 58, race_distance = '309,604' WHERE race_id = 7;
UPDATE phpbb_formel_races SET race_time = 1276444800, race_length = '4,361', race_laps = 70, race_distance = '305,270' WHERE race_id = 8;
UPDATE phpbb_formel_races SET race_time = 1277640000, race_length = '5,419', race_laps = 57, race_distance = '308,883' WHERE race_id = 9;
UPDATE phpbb_formel_races SET race_time = 1278849600, race_length = '5,900', race_laps = 52, race_distance = '306,800' WHERE race_id = 10;
UPDATE phpbb_formel_races SET race_time = 1280059200, race_length = '4,574', race_laps = 67, race_distance = '306,458' WHERE race_id = 11;
UPDATE phpbb_formel_races SET race_time = 1280664000, race_length = '4,381', race_laps = 70, race_distance = '306,670' WHERE race_id = 12;
UPDATE phpbb_formel_races SET race_time = 1283083200, race_length = '7,004', race_laps = 44, race_distance = '308,176' WHERE race_id = 13;
UPDATE phpbb_formel_races SET race_time = 1284292800, race_length = '5,793', race_laps = 53, race_distance = '307,029' WHERE race_id = 14;
UPDATE phpbb_formel_races SET race_time = 1285502400, race_length = '5,073', race_laps = 61, race_distance = '309,453' WHERE race_id = 15;
UPDATE phpbb_formel_races SET race_time = 1286690400, race_length = '5,807', race_laps = 53, race_distance = '307,771' WHERE race_id = 16;
UPDATE phpbb_formel_races SET race_time = 1287900000, race_length = '5,621', race_laps = 55, race_distance = '309,155' WHERE race_id = 17;
UPDATE phpbb_formel_races SET race_time = 1289145600, race_length = '4,309', race_laps = 71, race_distance = '305,909' WHERE race_id = 18;
UPDATE phpbb_formel_races SET race_time = 1289739600, race_length = '5,554', race_laps = 55, race_distance = '305,470' WHERE race_id = 19;
Code: Alles auswählen
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (64, 'Chandhok, Karun', '', 10);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (65, 'Yamamoto, Sakon', '', 10);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (66, 'Klien, Christian', '', 10);
UPDATE phpbb_formel_drivers SET driver_team = 13 WHERE driver_name = 'Heidfeld, Nick';
Code: Alles auswählen
UPDATE phpbb_formel_races SET race_quali = '5,7,8,2,4,6,3,1,11,14,9,15,10,27,16,26,12,17,24,18,19,25,20,21', race_result = '8,7,2,5,4,3,1,6,15,9,8,7' WHERE race_id = 1;
UPDATE phpbb_formel_races SET race_quali = '5,6,8,1,7,4,3,9,11,14,2,16,15,27,10,26,17,12,19,18,24,25,20,64', race_result = '1,11,7,8,4,2,15,9,6,3,6,10' WHERE race_id = 2;
UPDATE phpbb_formel_races SET race_quali = '6,4,5,14,10,11,9,3,26,15,12,27,16,17,19,24,1,18,8,2,7,64,20,25', race_result = '5,6,4,11,14,2,7,1,17,10,6,7' WHERE race_id = 3;
UPDATE phpbb_formel_races SET race_quali = '5,6,8,4,1,2,7,11,3,14,9,17,16,12,26,10,27,15,24,18,19,25,20,64', race_result = '1,2,4,8,11,5,12,6,7,3,2,7' WHERE race_id = 4;
UPDATE phpbb_formel_races SET race_quali = '6,5,2,8,1,3,11,4,7,26,14,27,10,12,16,17,15,9,18,19,24,25,64,20', race_result = '6,8,5,3,1,7,14,11,9,17,2,5' WHERE race_id = 5;
UPDATE phpbb_formel_races SET race_quali = '6,11,5,7,2,4,3,1,9,15,10,14,16,12,27,26,17,19,18,24,25,20,64,8', race_result = '6,5,11,7,2,8,4,14,15,16,5,9' WHERE race_id = 6;
UPDATE phpbb_formel_races SET race_quali = '6,2,5,1,3,4,11,7,12,26,14,8,27,16,9,17,10,15,18,19,24,20,25,64', race_result = '2,1,6,3,4,11,7,8,14,26,12,4' WHERE race_id = 7;
UPDATE phpbb_formel_races SET race_quali = '2,6,5,8,1,15,7,11,14,4,9,10,3,12,16,17,27,26,19,18,24,20,25,64', race_result = '2,1,8,5,6,4,11,16,15,14,11,5' WHERE race_id = 8;
UPDATE phpbb_formel_races SET race_quali = '5,6,2,8,7,11,1,10,9,12,16,4,14,15,3,27,17,26,18,19,25,24,64,20', race_result = '5,2,1,9,11,14,26,8,16,4,1,3' WHERE race_id = 9;
UPDATE phpbb_formel_races SET race_quali = '5,6,8,2,4,11,7,9,27,3,14,26,10,1,15,12,16,17,19,24,18,25,64,65', race_result = '6,2,4,1,9,26,5,14,3,10,8,4' WHERE race_id = 10;
UPDATE phpbb_formel_races SET race_quali = '5,8,7,6,1,2,11,9,4,10,3,26,12,14,27,17,16,18,19,24,20,15,65,25', race_result = '8,7,5,2,1,6,11,4,3,12,5,5' WHERE race_id = 11;
UPDATE phpbb_formel_races SET race_quali = '5,6,8,7,2,4,12,11,27,10,1,9,14,3,16,15,17,26,24,19,18,25,20,65', race_result = '6,8,5,7,12,10,27,1,26,9,5,5' WHERE race_id = 12;
UPDATE phpbb_formel_races SET race_quali = '6,2,11,5,1,7,9,14,10,8,3,4,17,15,16,19,24,18,26,20,65,27,25,12', race_result = '2,6,11,7,14,4,3,26,12,15,2,4' WHERE race_id = 13;
UPDATE phpbb_formel_races SET race_quali = '8,1,7,6,2,5,4,10,11,9,14,3,26,16,12,17,27,18,19,15,24,25,20,65', race_result = '8,1,7,5,4,6,10,11,3,9,8,4' WHERE race_id = 14;
UPDATE phpbb_formel_races SET race_quali = '8,5,2,1,6,9,4,11,3,26,17,10,12,16,52,14,15,24,19,25,18,66,20,7', race_result = '8,5,6,1,4,9,11,7,14,10,8,8' WHERE race_id = 15;
UPDATE phpbb_formel_races SET race_quali = '5,6,2,11,8,1,4,9,10,3,52,7,12,26,14,17,15,16,18,19,25,24,20,65', race_result = '5,6,8,1,2,3,26,52,9,16,6,7' WHERE race_id = 16;
UPDATE phpbb_formel_races SET race_quali = '5,6,8,2,4,7,1,11,3,9,10,26,52,14,12,17,16,15,18,24,19,25,65,20', race_result = '8,2,7,3,11,15,9,26,52,10,8,9' WHERE race_id = 17;
UPDATE phpbb_formel_races SET race_quali = '10,5,6,2,8,9,11,3,7,12,1,26,4,17,16,52,15,14,24,18,19,25,66,20', race_result = '5,6,8,2,1,4,3,10,11,26,2,2' WHERE race_id = 18;
1. bis 18 Rennen der Saison:
Code: Alles auswählen
INSERT INTO `phpbb_formel_wm` (`wm_race`, `wm_driver`, `wm_team`, `wm_points`) VALUES
(1, 8, 4, 25),
(1, 7, 4, 18),
(1, 2, 1, 15),
(1, 5, 3, 12),
(1, 4, 2, 10),
(1, 3, 2, 8),
(1, 1, 1, 6),
(1, 6, 3, 4),
(1, 15, 7, 2),
(1, 9, 5, 1),
(2, 1, 1, 25),
(2, 11, 6, 18),
(2, 7, 4, 15),
(2, 8, 4, 12),
(2, 4, 2, 10),
(2, 2, 1, 8),
(2, 15, 7, 6),
(2, 9, 5, 4),
(2, 6, 3, 2),
(2, 3, 2, 1),
(3, 5, 3, 25),
(3, 6, 3, 18),
(3, 4, 2, 15),
(3, 11, 6, 12),
(3, 14, 7, 10),
(3, 2, 1, 8),
(3, 7, 4, 6),
(3, 1, 1, 4),
(3, 17, 8, 2),
(3, 10, 5, 1),
(4, 1, 1, 25),
(4, 2, 1, 18),
(4, 4, 2, 15),
(4, 8, 4, 12),
(4, 11, 6, 10),
(4, 5, 3, 8),
(4, 12, 6, 6),
(4, 6, 3, 4),
(4, 7, 4, 2),
(4, 3, 2, 1),
(5, 6, 3, 25),
(5, 8, 4, 18),
(5, 5, 3, 15),
(5, 3, 2, 12),
(5, 1, 1, 10),
(5, 7, 4, 8),
(5, 14, 7, 6),
(5, 11, 6, 4),
(5, 9, 5, 2),
(5, 17, 8, 1),
(6, 6, 3, 25),
(6, 5, 3, 18),
(6, 11, 6, 15),
(6, 7, 4, 12),
(6, 2, 1, 10),
(6, 8, 4, 8),
(6, 4, 2, 6),
(6, 14, 7, 4),
(6, 15, 7, 2),
(6, 16, 8, 1),
(7, 2, 1, 25),
(7, 1, 1, 18),
(7, 6, 3, 15),
(7, 3, 2, 12),
(7, 4, 2, 10),
(7, 11, 6, 8),
(7, 7, 4, 6),
(7, 8, 4, 4),
(7, 14, 7, 2),
(7, 26, 13, 1),
(8, 2, 1, 25),
(8, 1, 1, 18),
(8, 8, 4, 15),
(8, 5, 3, 12),
(8, 6, 3, 10),
(8, 4, 2, 8),
(8, 11, 6, 6),
(8, 16, 8, 4),
(8, 15, 7, 2),
(8, 14, 7, 1),
(9, 5, 3, 25),
(9, 2, 1, 18),
(9, 1, 1, 15),
(9, 9, 5, 12),
(9, 11, 6, 10),
(9, 14, 7, 8),
(9, 26, 13, 6),
(9, 8, 4, 4),
(9, 16, 8, 2),
(9, 4, 2, 1),
(10, 6, 3, 25),
(10, 2, 1, 18),
(10, 4, 2, 15),
(10, 1, 1, 12),
(10, 9, 5, 10),
(10, 26, 13, 8),
(10, 5, 3, 6),
(10, 14, 7, 4),
(10, 3, 2, 2),
(10, 10, 5, 1),
(11, 8, 4, 25),
(11, 7, 4, 18),
(11, 5, 3, 15),
(11, 2, 1, 12),
(11, 1, 1, 10),
(11, 6, 3, 8),
(11, 11, 6, 6),
(11, 4, 2, 4),
(11, 3, 2, 2),
(11, 12, 6, 1),
(12, 6, 3, 25),
(12, 8, 4, 18),
(12, 5, 3, 15),
(12, 7, 4, 12),
(12, 12, 6, 10),
(12, 10, 5, 8),
(12, 27, 13, 6),
(12, 1, 1, 4),
(12, 26, 13, 2),
(12, 9, 5, 1),
(13, 2, 1, 25),
(13, 6, 3, 18),
(13, 11, 6, 15),
(13, 7, 4, 12),
(13, 14, 7, 10),
(13, 4, 2, 8),
(13, 3, 2, 6),
(13, 26, 13, 4),
(13, 12, 6, 2),
(13, 15, 7, 1),
(14, 8, 4, 25),
(14, 1, 1, 18),
(14, 7, 4, 15),
(14, 5, 3, 12),
(14, 4, 2, 10),
(14, 6, 3, 8),
(14, 10, 5, 6),
(14, 11, 6, 4),
(14, 3, 2, 2),
(14, 9, 5, 1),
(15, 8, 4, 25),
(15, 5, 3, 18),
(15, 6, 3, 15),
(15, 1, 1, 12),
(15, 4, 2, 10),
(15, 9, 5, 8),
(15, 11, 6, 6),
(15, 7, 4, 4),
(15, 14, 7, 2),
(15, 10, 5, 1),
(16, 5, 3, 25),
(16, 6, 3, 18),
(16, 8, 4, 15),
(16, 1, 1, 12),
(16, 2, 1, 10),
(16, 3, 2, 8),
(16, 26, 13, 6),
(16, 52, 13, 4),
(16, 9, 5, 2),
(16, 16, 8, 1),
(17, 8, 4, 25),
(17, 2, 1, 18),
(17, 7, 4, 15),
(17, 3, 2, 12),
(17, 11, 6, 10),
(17, 15, 7, 8),
(17, 9, 5, 6),
(17, 26, 13, 4),
(17, 52, 13, 2),
(17, 10, 5, 1),
(18, 5, 3, 25),
(18, 6, 3, 18),
(18, 8, 4, 15),
(18, 2, 1, 12),
(18, 1, 1, 10),
(18, 4, 2, 8),
(18, 3, 2, 6),
(18, 10, 5, 4),
(18, 11, 6, 2),
(18, 26, 13, 1);
Code: Alles auswählen
INSERT INTO `phpbb_formel_wm` (`wm_race`, `wm_driver`, `wm_team`, `wm_points`) VALUES
(19, 5, 3, 25),
(19, 2, 1, 18),
(19, 1, 1, 15),
(19, 4, 2, 12),
(19, 11, 6, 10),
(19, 12, 6, 8),
(19, 8, 4, 6),
(19, 6, 3, 4),
(19, 17, 8, 2),
(19, 7, 4, 1);
Code: Alles auswählen
UPDATE phpbb_formel_races SET race_quali = '5,2,8,1,6,7,9,3,4,12,11,26,14,52,10,15,17,16,18,19,24,25,20,66', race_result = '5,2,1,4,11,12,8,6,17,7,2,3' WHERE race_id = 19;
Hinweise:
Um User-Tipp-Punkte zu vergeben, müsst ihr in der Moderation beim Rennen auf "Bearbeiten" und dann auf "Eintragen" gehen. Ich arbeite an einer einfacheren Lösung. It´s done when it´s done ...
Außerdem ist vor den Updates wie immer eine Sicherung empfohlen!
- für die Updates 1,3 und 5 Tabelle "phpbb_formel_races"
- für das Update 2 "phpbb_formel_drivers"
- für das Update 4 Tabelle "phpbb_formel_wm"
