[BETA] phpBB3 Football MOD Version 0.9.3

In diesem Forum können Mod-Autoren ihre Mods vorstellen, die sich noch im Entwicklungsstatus befinden. Der Einbau in Foren im produktiven Betrieb wird nicht empfohlen.
Forumsregeln
phpBB 3.0 hat das Ende seiner Lebenszeit überschritten
phpBB 3.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 3.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf die neuste phpBB-Version, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Antworten
tekknodevil
Mitglied
Beiträge: 142
Registriert: 08.12.2009 20:45
Wohnort: Dresden
Kontaktdaten:
Kontaktdaten von tekknodevil

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von tekknodevil »

Hallo football,

hast Du schon eine Idee, wie das mit den Relegationsspielen der Ligen 1-3 gelöst werden könnte? Das einfachste wäre sicherlich ein neues Tippspiel zu erstellen, allerdings finde ich dies dann recht unübersichtlich.

Grüße
Nach oben
Benutzeravatar
football
Mitglied
Beiträge: 862
Registriert: 03.05.2009 10:37
Kontaktdaten:
Kontaktdaten von football

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von football »

DespoBerry hat geschrieben: mit delivery block werden manchmal die spieltagsnamen angezeigt und manchmal durch #. Spieltag ersetzt.
wie wird das gesteuert??
Per fehlerhaftem Programm. :oops:
in football/block/delivery.php
ersetze (3 mal)

Code: Alles auswählen

				WHEN m.matchday_name = '' 
					THEN m.matchday_name 
					ELSE CONCAT(m.matchday, '." . sprintf($user->lang['MATCHDAY']) . "')

Code: Alles auswählen

				WHEN '' 
					THEN CONCAT(m.matchday, '." . sprintf($user->lang['MATCHDAY']) . "') 
					ELSE m.matchday_name
Das andere Problem mit der Anzeige unter "Alle Tipps" ist ein wenig kniffliger:
in /football/block/all_bets.php
füge nach

Code: Alles auswählen

$match_index = 0;
folgendes

Code: Alles auswählen

$last_match_index = 0;
ein,

füge nach

Code: Alles auswählen

		if ($match_index > 0) 
		{
			$total = 0;
			$count_user = 0;
			$bet_index = 0;
folgendes

Code: Alles auswählen

			$last_match_index = 0;
ein,

füge nach

Code: Alles auswählen

	$match_index++;
folgendes

Code: Alles auswählen

	$last_match_index++;
ein,

ersetze

Code: Alles auswählen

		if ($bet_index == $split_after)
		{
			$sum_total[$user_bet['username']] += $total;
			$matchday_sum_total += $total;
			$template->assign_block_vars('match_panel.user_row.points', array(
				'COLOR_STYLE' 	=> $colorstyle_total,
				'POINTS_TOTAL' 	=> $sum_total[$user_bet['username']],
				)
			);
			$bet_index = 0;
		}
durch

Code: Alles auswählen

		if ($bet_index == $last_match_index)
		{
			$sum_total[$user_bet['username']] += $total;
			$matchday_sum_total += $total;
			$template->assign_block_vars('match_panel.user_row.points', array(
				'COLOR_STYLE' 	=> $colorstyle_total,
				'POINTS_TOTAL' 	=> $sum_total[$user_bet['username']],
				)
			);
			$bet_index = 0;
		}
Kein Support per PN oder E-Mail. Support-Anfragen beantworte ich nur über diese Community.
Nach oben
Benutzeravatar
football
Mitglied
Beiträge: 862
Registriert: 03.05.2009 10:37
Kontaktdaten:
Kontaktdaten von football

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von football »

tekknodevil hat geschrieben:Hallo football,

hast Du schon eine Idee, wie das mit den Relegationsspielen der Ligen 1-3 gelöst werden könnte? Das einfachste wäre sicherlich ein neues Tippspiel zu erstellen, allerdings finde ich dies dann recht unübersichtlich.

Grüße
Für mich gehören diese Spiele nicht in die Liga-Tipprunde und passen dort vom Schema auch nicht rein. Wenn du sie unbedingt tippen möchtest, bleibt dir die Erstellung einer eigenen Liga (eventuell aller Relegationsspiele) nicht erspart.
Kein Support per PN oder E-Mail. Support-Anfragen beantworte ich nur über diese Community.
Nach oben
tekknodevil
Mitglied
Beiträge: 142
Registriert: 08.12.2009 20:45
Wohnort: Dresden
Kontaktdaten:
Kontaktdaten von tekknodevil

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von tekknodevil »

football hat geschrieben:
tekknodevil hat geschrieben:Hallo football,

hast Du schon eine Idee, wie das mit den Relegationsspielen der Ligen 1-3 gelöst werden könnte? Das einfachste wäre sicherlich ein neues Tippspiel zu erstellen, allerdings finde ich dies dann recht unübersichtlich.

Grüße
Für mich gehören diese Spiele nicht in die Liga-Tipprunde und passen dort vom Schema auch nicht rein. Wenn du sie unbedingt tippen möchtest, bleibt dir die Erstellung einer eigenen Liga (eventuell aller Relegationsspiele) nicht erspart.
Alles klärchen. Danke
Nach oben
Ruhrpottler
Mitglied
Beiträge: 317
Registriert: 16.05.2004 12:08

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von Ruhrpottler »

So, die WM ist vorbei und der Mod hat super funktioniert und wurde von unseren Usern bestens angenommen.
Es werden jetzt natürlich die ersten Stimmen laut, dass man das Tippspielsystem bitte auch für die neue BuLi-Saison nutzen soll.

Frage: Wie stellt man das jetzt am besten an?
Momentan haben wir ja nur die Daten der WM drin. Also die Spielpläne und die WM Mannschaften. Daten von irgendwelchen Bundesligaclubs haben wir überhaupt nicht drin.
Wie pflegt man die ein? Gibts da irgendwelche Scripte? Oder muss man das alles von Hand machen? Wenn ja wie?
Nach oben
Benutzeravatar
DreamPromise
Mitglied
Beiträge: 3793
Registriert: 27.01.2004 17:56

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von DreamPromise »

Moin moin

dann hast du sicher diesen Beitrag übersehen --> viewtopic.php?f=88&t=204908&start=700#p1186540 :wink:
Nach oben
Schorschi
Mitglied
Beiträge: 147
Registriert: 21.08.2004 20:48

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von Schorschi »

Oder diesen. :D

viewtopic.php?f=88&t=206251&start=10#p1187018
Ich benutze: phpbb Olympus 3.0.7-PL1 mit eigenem Style auf ProSilver-Basis. MODs: Formel 1 WebTipp, Who was here, UPS und ein paar Spiele. Mein Forum.
Nach oben
Benutzeravatar
football
Mitglied
Beiträge: 862
Registriert: 03.05.2009 10:37
Kontaktdaten:
Kontaktdaten von football

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von football »

Die Premier League habe ich diese Saison zum ersten mal aufgenommen, die Primera Division soll nach folgen sobald der Spielplan steht.

Für die Premier League wurden auch die ersten Spiele terminiert und es gibt auch gleich eine Überraschung, denn das
Spiel Blackpool FC - Wigan Athletic
wurde gedreht bzw. Hin- und Rückspiel getauscht.

Code: Alles auswählen

REPLACE INTO phpbb_footb_matches VALUES(2011, 7, 2,564,561,'','',1,0,'2010-08-14 16:00:00','','D','D',0,'','');
REPLACE INTO phpbb_footb_matches VALUES(2011, 7, 325,561,564,'','',1,0,'2010-08-14 16:00:00','','D','D',0,'','');

Update phpbb_footb_matches Set match_datetime='2010-08-14 13:45:00' WHERE season=2011 AND league=7 AND match_no=10;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=2;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=3;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=4;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=6;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=7;
Update phpbb_footb_matches Set match_datetime='2010-08-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=9;
Update phpbb_footb_matches Set match_datetime='2010-08-14 18:30:00' WHERE season=2011 AND league=7 AND match_no=8;

Update phpbb_footb_matches Set match_datetime='2010-08-15 17:00:00' WHERE season=2011 AND league=7 AND match_no=1;

Update phpbb_footb_matches Set match_datetime='2010-08-16 21:00:00' WHERE season=2011 AND league=7 AND match_no=5;


Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=12;
Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=14;
Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=16;
Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=17;
Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=19;
Update phpbb_footb_matches Set match_datetime='2010-08-21 16:00:00' WHERE season=2011 AND league=7 AND match_no=20;
Update phpbb_footb_matches Set match_datetime='2010-08-21 18:15:00' WHERE season=2011 AND league=7 AND match_no=18;

Update phpbb_footb_matches Set match_datetime='2010-08-22 14:30:00' WHERE season=2011 AND league=7 AND match_no=15;
Update phpbb_footb_matches Set match_datetime='2010-08-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=11;

Update phpbb_footb_matches Set match_datetime='2010-08-23 21:00:00' WHERE season=2011 AND league=7 AND match_no=13;


Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=23;
Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=24;
Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=26;
Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=28;
Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=29;
Update phpbb_footb_matches Set match_datetime='2010-08-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=30;
Update phpbb_footb_matches Set match_datetime='2010-08-28 18:30:00' WHERE season=2011 AND league=7 AND match_no=21;

Update phpbb_footb_matches Set match_datetime='2010-08-29 14:30:00' WHERE season=2011 AND league=7 AND match_no=22;
Update phpbb_footb_matches Set match_datetime='2010-08-29 16:00:00' WHERE season=2011 AND league=7 AND match_no=25;
Update phpbb_footb_matches Set match_datetime='2010-08-29 17:00:00' WHERE season=2011 AND league=7 AND match_no=27;


Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=32;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=34;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=35;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=37;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=38;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=39;
Update phpbb_footb_matches Set match_datetime='2010-09-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=40;

Update phpbb_footb_matches Set match_datetime='2010-09-12 14:30:00' WHERE season=2011 AND league=7 AND match_no=33;
Update phpbb_footb_matches Set match_datetime='2010-09-12 17:00:00' WHERE season=2011 AND league=7 AND match_no=36;

Update phpbb_footb_matches Set match_datetime='2010-09-13 21:00:00' WHERE season=2011 AND league=7 AND match_no=31;


Update phpbb_footb_matches Set match_datetime='2010-09-18 13:45:00' WHERE season=2011 AND league=7 AND match_no=45;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=41;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=42;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=43;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=44;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=47;
Update phpbb_footb_matches Set match_datetime='2010-09-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=48;
Update phpbb_footb_matches Set match_datetime='2010-09-18 18:30:00' WHERE season=2011 AND league=7 AND match_no=46;

Update phpbb_footb_matches Set match_datetime='2010-09-19 14:30:00' WHERE season=2011 AND league=7 AND match_no=50;
Update phpbb_footb_matches Set match_datetime='2010-09-19 17:00:00' WHERE season=2011 AND league=7 AND match_no=49;


Update phpbb_footb_matches Set match_datetime='2010-09-25 13:45:00' WHERE season=2011 AND league=7 AND match_no=57;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=51;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=53;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=54;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=55;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=58;
Update phpbb_footb_matches Set match_datetime='2010-09-25 16:00:00' WHERE season=2011 AND league=7 AND match_no=59;

Update phpbb_footb_matches Set match_datetime='2010-09-26 13:00:00' WHERE season=2011 AND league=7 AND match_no=60;
Update phpbb_footb_matches Set match_datetime='2010-09-26 15:05:00' WHERE season=2011 AND league=7 AND match_no=56;
Update phpbb_footb_matches Set match_datetime='2010-09-26 17:10:00' WHERE season=2011 AND league=7 AND match_no=52;


Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=61;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=62;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=63;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=64;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=65;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=68;
Update phpbb_footb_matches Set match_datetime='2010-10-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=69;

Update phpbb_footb_matches Set match_datetime='2010-10-03 14:30:00' WHERE season=2011 AND league=7 AND match_no=70;
Update phpbb_footb_matches Set match_datetime='2010-10-03 17:00:00' WHERE season=2011 AND league=7 AND match_no=66;

Update phpbb_footb_matches Set match_datetime='2010-10-04 21:00:00' WHERE season=2011 AND league=7 AND match_no=67;


Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=72;
Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=74;
Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=75;
Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=76;
Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=78;
Update phpbb_footb_matches Set match_datetime='2010-10-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=79;
Update phpbb_footb_matches Set match_datetime='2010-10-16 18:30:00' WHERE season=2011 AND league=7 AND match_no=73;

Update phpbb_footb_matches Set match_datetime='2010-10-17 14:30:00' WHERE season=2011 AND league=7 AND match_no=71;
Update phpbb_footb_matches Set match_datetime='2010-10-17 17:00:00' WHERE season=2011 AND league=7 AND match_no=80;

Update phpbb_footb_matches Set match_datetime='2010-10-18 21:00:00' WHERE season=2011 AND league=7 AND match_no=77;


Update phpbb_footb_matches Set match_datetime='2010-10-23 13:45:00' WHERE season=2011 AND league=7 AND match_no=90;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=81;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=82;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=84;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=87;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=88;
Update phpbb_footb_matches Set match_datetime='2010-10-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=89;
Update phpbb_footb_matches Set match_datetime='2010-10-23 18:30:00' WHERE season=2011 AND league=7 AND match_no=85;

Update phpbb_footb_matches Set match_datetime='2010-10-24 14:30:00' WHERE season=2011 AND league=7 AND match_no=86;
Update phpbb_footb_matches Set match_datetime='2010-10-24 17:00:00' WHERE season=2011 AND league=7 AND match_no=83;


Update phpbb_footb_matches Set match_datetime='2010-10-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=91;
Update phpbb_footb_matches Set match_datetime='2010-10-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=92;
Update phpbb_footb_matches Set match_datetime='2010-10-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=95;
Update phpbb_footb_matches Set match_datetime='2010-10-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=97;
Update phpbb_footb_matches Set match_datetime='2010-10-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=100;
Update phpbb_footb_matches Set match_datetime='2010-10-30 18:30:00' WHERE season=2011 AND league=7 AND match_no=99;

Update phpbb_footb_matches Set match_datetime='2010-10-31 13:00:00' WHERE season=2011 AND league=7 AND match_no=94;
Update phpbb_footb_matches Set match_datetime='2010-10-31 14:30:00' WHERE season=2011 AND league=7 AND match_no=96;
Update phpbb_footb_matches Set match_datetime='2010-10-31 17:00:00' WHERE season=2011 AND league=7 AND match_no=93;

Update phpbb_footb_matches Set match_datetime='2010-11-01 21:00:00' WHERE season=2011 AND league=7 AND match_no=98;


Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=102;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=103;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=104;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=105;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=106;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=107;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=109;
Update phpbb_footb_matches Set match_datetime='2010-11-06 16:00:00' WHERE season=2011 AND league=7 AND match_no=110;

Update phpbb_footb_matches Set match_datetime='2010-11-07 14:30:00' WHERE season=2011 AND league=7 AND match_no=101;
Update phpbb_footb_matches Set match_datetime='2010-11-07 14:30:00' WHERE season=2011 AND league=7 AND match_no=108;


Update phpbb_footb_matches Set match_datetime='2010-11-09 20:45:00' WHERE season=2011 AND league=7 AND match_no=111;
Update phpbb_footb_matches Set match_datetime='2010-11-09 20:45:00' WHERE season=2011 AND league=7 AND match_no=115;
Update phpbb_footb_matches Set match_datetime='2010-11-09 21:00:00' WHERE season=2011 AND league=7 AND match_no=112;
Update phpbb_footb_matches Set match_datetime='2010-11-09 21:00:00' WHERE season=2011 AND league=7 AND match_no=114;

Update phpbb_footb_matches Set match_datetime='2010-11-10 20:45:00' WHERE season=2011 AND league=7 AND match_no=116;
Update phpbb_footb_matches Set match_datetime='2010-11-10 20:45:00' WHERE season=2011 AND league=7 AND match_no=118;
Update phpbb_footb_matches Set match_datetime='2010-11-10 20:45:00' WHERE season=2011 AND league=7 AND match_no=120;
Update phpbb_footb_matches Set match_datetime='2010-11-10 21:00:00' WHERE season=2011 AND league=7 AND match_no=113;
Update phpbb_footb_matches Set match_datetime='2010-11-10 21:00:00' WHERE season=2011 AND league=7 AND match_no=117;
Update phpbb_footb_matches Set match_datetime='2010-11-10 21:00:00' WHERE season=2011 AND league=7 AND match_no=119;


Update phpbb_footb_matches Set match_datetime='2010-11-13 13:45:00' WHERE season=2011 AND league=7 AND match_no=129;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=122;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=123;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=124;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=125;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=126;
Update phpbb_footb_matches Set match_datetime='2010-11-13 16:00:00' WHERE season=2011 AND league=7 AND match_no=128;
Update phpbb_footb_matches Set match_datetime='2010-11-13 18:30:00' WHERE season=2011 AND league=7 AND match_no=127;

Update phpbb_footb_matches Set match_datetime='2010-11-14 15:00:00' WHERE season=2011 AND league=7 AND match_no=121;
Update phpbb_footb_matches Set match_datetime='2010-11-14 17:10:00' WHERE season=2011 AND league=7 AND match_no=130;


Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=131;
Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=132;
Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=134;
Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=137;
Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=138;
Update phpbb_footb_matches Set match_datetime='2010-11-20 16:00:00' WHERE season=2011 AND league=7 AND match_no=140;
Update phpbb_footb_matches Set match_datetime='2010-11-20 18:30:00' WHERE season=2011 AND league=7 AND match_no=136;

Update phpbb_footb_matches Set match_datetime='2010-11-21 14:30:00' WHERE season=2011 AND league=7 AND match_no=135;
Update phpbb_footb_matches Set match_datetime='2010-11-21 17:00:00' WHERE season=2011 AND league=7 AND match_no=139;

Update phpbb_footb_matches Set match_datetime='2010-11-22 21:00:00' WHERE season=2011 AND league=7 AND match_no=133;


Update phpbb_footb_matches Set match_datetime='2010-11-27 13:45:00' WHERE season=2011 AND league=7 AND match_no=150;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=141;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=143;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=144;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=145;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=147;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=148;
Update phpbb_footb_matches Set match_datetime='2010-11-27 16:00:00' WHERE season=2011 AND league=7 AND match_no=149;

Update phpbb_footb_matches Set match_datetime='2010-11-28 14:30:00' WHERE season=2011 AND league=7 AND match_no=146;
Update phpbb_footb_matches Set match_datetime='2010-11-28 17:00:00' WHERE season=2011 AND league=7 AND match_no=142;


Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=151;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=152;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=153;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=154;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=155;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=156;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=157;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=158;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=159;
Update phpbb_footb_matches Set match_datetime='2010-12-04 16:00:00' WHERE season=2011 AND league=7 AND match_no=160;


Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=162;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=163;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=164;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=165;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=166;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=167;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=168;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=169;
Update phpbb_footb_matches Set match_datetime='2010-12-11 16:00:00' WHERE season=2011 AND league=7 AND match_no=170;

Update phpbb_footb_matches Set match_datetime='2010-12-12 14:30:00' WHERE season=2011 AND league=7 AND match_no=161;


Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=171;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=172;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=173;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=174;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=176;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=177;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=178;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=179;
Update phpbb_footb_matches Set match_datetime='2010-12-18 16:00:00' WHERE season=2011 AND league=7 AND match_no=180;

Update phpbb_footb_matches Set match_datetime='2010-12-19 13:00:00' WHERE season=2011 AND league=7 AND match_no=175;


Update phpbb_footb_matches Set match_datetime='2010-12-26 14:00:00' WHERE season=2011 AND league=7 AND match_no=182;
Update phpbb_footb_matches Set match_datetime='2010-12-26 14:00:00' WHERE season=2011 AND league=7 AND match_no=186;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=181;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=183;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=184;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=185;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=187;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=188;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=189;
Update phpbb_footb_matches Set match_datetime='2010-12-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=190;


Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=191;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=192;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=193;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=194;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=195;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=196;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=197;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=198;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=199;
Update phpbb_footb_matches Set match_datetime='2010-12-28 16:00:00' WHERE season=2011 AND league=7 AND match_no=200;


Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=201;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=202;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=203;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=204;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=205;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=206;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=207;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=208;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=209;
Update phpbb_footb_matches Set match_datetime='2011-01-01 16:00:00' WHERE season=2011 AND league=7 AND match_no=210;


Update phpbb_footb_matches Set match_datetime='2011-01-04 20:45:00' WHERE season=2011 AND league=7 AND match_no=211;
Update phpbb_footb_matches Set match_datetime='2011-01-04 20:45:00' WHERE season=2011 AND league=7 AND match_no=212;
Update phpbb_footb_matches Set match_datetime='2011-01-04 21:00:00' WHERE season=2011 AND league=7 AND match_no=213;
Update phpbb_footb_matches Set match_datetime='2011-01-04 21:00:00' WHERE season=2011 AND league=7 AND match_no=214;
Update phpbb_footb_matches Set match_datetime='2011-01-04 21:00:00' WHERE season=2011 AND league=7 AND match_no=215;

Update phpbb_footb_matches Set match_datetime='2011-01-05 20:45:00' WHERE season=2011 AND league=7 AND match_no=216;
Update phpbb_footb_matches Set match_datetime='2011-01-05 20:45:00' WHERE season=2011 AND league=7 AND match_no=219;
Update phpbb_footb_matches Set match_datetime='2011-01-05 21:00:00' WHERE season=2011 AND league=7 AND match_no=217;
Update phpbb_footb_matches Set match_datetime='2011-01-05 21:00:00' WHERE season=2011 AND league=7 AND match_no=218;
Update phpbb_footb_matches Set match_datetime='2011-01-05 21:00:00' WHERE season=2011 AND league=7 AND match_no=220;


Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=221;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=222;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=223;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=225;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=227;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=228;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=229;
Update phpbb_footb_matches Set match_datetime='2011-01-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=230;

Update phpbb_footb_matches Set match_datetime='2011-01-16 13:00:00' WHERE season=2011 AND league=7 AND match_no=224;
Update phpbb_footb_matches Set match_datetime='2011-01-16 13:00:00' WHERE season=2011 AND league=7 AND match_no=226;


Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=231;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=232;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=233;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=234;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=235;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=236;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=237;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=238;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=239;
Update phpbb_footb_matches Set match_datetime='2011-01-22 16:00:00' WHERE season=2011 AND league=7 AND match_no=240;


Update phpbb_footb_matches Set match_datetime='2011-02-01 20:45:00' WHERE season=2011 AND league=7 AND match_no=242;
Update phpbb_footb_matches Set match_datetime='2011-02-01 20:45:00' WHERE season=2011 AND league=7 AND match_no=244;
Update phpbb_footb_matches Set match_datetime='2011-02-01 20:45:00' WHERE season=2011 AND league=7 AND match_no=246;
Update phpbb_footb_matches Set match_datetime='2011-02-01 21:00:00' WHERE season=2011 AND league=7 AND match_no=241;
Update phpbb_footb_matches Set match_datetime='2011-02-01 21:00:00' WHERE season=2011 AND league=7 AND match_no=243;
Update phpbb_footb_matches Set match_datetime='2011-02-01 21:00:00' WHERE season=2011 AND league=7 AND match_no=245;
Update phpbb_footb_matches Set match_datetime='2011-02-01 21:00:00' WHERE season=2011 AND league=7 AND match_no=247;

Update phpbb_footb_matches Set match_datetime='2011-02-02 21:00:00' WHERE season=2011 AND league=7 AND match_no=248;
Update phpbb_footb_matches Set match_datetime='2011-02-02 21:00:00' WHERE season=2011 AND league=7 AND match_no=249;
Update phpbb_footb_matches Set match_datetime='2011-02-02 21:00:00' WHERE season=2011 AND league=7 AND match_no=250;


Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=251;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=252;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=253;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=254;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=255;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=256;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=257;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=258;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=259;
Update phpbb_footb_matches Set match_datetime='2011-02-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=260;


Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=261;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=262;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=263;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=264;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=265;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=266;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=267;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=268;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=269;
Update phpbb_footb_matches Set match_datetime='2011-02-12 16:00:00' WHERE season=2011 AND league=7 AND match_no=270;


Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=271;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=272;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=273;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=274;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=275;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=276;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=277;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=278;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=279;
Update phpbb_footb_matches Set match_datetime='2011-02-26 16:00:00' WHERE season=2011 AND league=7 AND match_no=280;


Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=281;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=282;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=283;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=284;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=285;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=286;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=287;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=288;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=289;
Update phpbb_footb_matches Set match_datetime='2011-03-05 16:00:00' WHERE season=2011 AND league=7 AND match_no=290;


Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=291;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=292;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=293;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=294;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=295;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=296;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=297;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=298;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=299;
Update phpbb_footb_matches Set match_datetime='2011-03-19 16:00:00' WHERE season=2011 AND league=7 AND match_no=300;


Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=301;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=302;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=303;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=304;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=305;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=306;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=307;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=308;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=309;
Update phpbb_footb_matches Set match_datetime='2011-04-02 16:00:00' WHERE season=2011 AND league=7 AND match_no=310;


Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=311;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=312;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=313;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=314;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=316;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=317;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=318;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=319;
Update phpbb_footb_matches Set match_datetime='2011-04-09 16:00:00' WHERE season=2011 AND league=7 AND match_no=320;

Update phpbb_footb_matches Set match_datetime='2011-04-10 16:00:00' WHERE season=2011 AND league=7 AND match_no=315;


Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=321;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=322;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=323;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=324;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=325;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=326;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=327;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=328;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=329;
Update phpbb_footb_matches Set match_datetime='2011-04-16 16:00:00' WHERE season=2011 AND league=7 AND match_no=330;


Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=331;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=332;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=333;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=334;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=335;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=336;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=337;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=338;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=339;
Update phpbb_footb_matches Set match_datetime='2011-04-23 16:00:00' WHERE season=2011 AND league=7 AND match_no=340;


Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=341;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=342;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=343;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=344;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=345;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=346;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=348;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=349;
Update phpbb_footb_matches Set match_datetime='2011-04-30 16:00:00' WHERE season=2011 AND league=7 AND match_no=350;

Update phpbb_footb_matches Set match_datetime='2011-05-01 13:00:00' WHERE season=2011 AND league=7 AND match_no=347;


Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=351;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=352;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=353;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=354;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=355;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=356;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=357;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=358;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=359;
Update phpbb_footb_matches Set match_datetime='2011-05-07 16:00:00' WHERE season=2011 AND league=7 AND match_no=360;


Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=362;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=363;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=365;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=366;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=367;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=368;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=369;
Update phpbb_footb_matches Set match_datetime='2011-05-14 16:00:00' WHERE season=2011 AND league=7 AND match_no=370;

Update phpbb_footb_matches Set match_datetime='2011-05-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=361;
Update phpbb_footb_matches Set match_datetime='2011-05-15 16:00:00' WHERE season=2011 AND league=7 AND match_no=364;


Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=371;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=372;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=373;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=374;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=375;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=376;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=377;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=378;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=379;
Update phpbb_footb_matches Set match_datetime='2011-05-22 17:00:00' WHERE season=2011 AND league=7 AND match_no=380;
Das fängt ja schon gut. In der Bundesliga hatte ich einen solchen Fall noch nicht.
Kein Support per PN oder E-Mail. Support-Anfragen beantworte ich nur über diese Community.
Nach oben
DespoBerry
Mitglied
Beiträge: 108
Registriert: 14.09.2007 07:54

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von DespoBerry »

hallo,

ich habe gerade versucht bei einem bestehenden spieltag das tippabgabedatum einzutragen.
leider bekomme ich da folgenden fehler:

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

Falscher datetime-Wert gekürzt: '' [1292]

SQL

UPDATE phpbb_footb_matches SET status = 0 WHERE season = 2011 AND league = 9 AND matchday = 1 AND status > 0 AND match_datetime >= FROM_UNIXTIME('1282320000')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_football_matchdays.php
LINE: 503
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_football_matchdays->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Nach oben
helluvaguy
Mitglied
Beiträge: 124
Registriert: 29.05.2001 02:00

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Beitrag von helluvaguy »

Also bei mir hat der Mod zur WM wirklich sehr gut funktioiniert, dafür nochmals meinen Dank. Ich habe da aber Fragen zur Darstellung der Sondertipps.

Bei den Ergebnissen werden die Sondertipps ja am (Spiel)Tag der Tippabgabe angezeigt. Wäre es möglich, das am (Spieltag)Eintragsdatum anzeigen zu lassen?
Bei mir war es bei der Ergebnisdarstellung der Sondertipps so, dass NICHT angezeigt wurde, welche Tipper Punkte bekommen haben. Ist das so richtig oder habe ich da evtl. eine Fehlfunktion im Tippspiel?

Eine Frage habe ich da noch, da ich beim Querlesen die Lösung nicht finden konnte hier im Beitrag. Ich hatte nur die WM als Liga (#6), habe nun aber eine zweite Liga (#7) erstellt und möchte das diese als "Standard" angezeigt bekommen, wenn das Tippspiel aufgerufen wird. Ich weiß, irgendwie wurde darüber schon mal geschprochen, aber ich finde das nicht.

Danke für den Input
Nach oben
Antworten

Zurück zu „[3.0.x] Mods in Entwicklung“