phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

[BETA] phpBB3 Football MOD Version 0.9.3

https://www.phpbb.de/community/viewtopic.php?t=204908

Seite 76 von 214

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 12.07.2010 10:44
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

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 12.07.2010 13:26
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;
		}

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 12.07.2010 13:32
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.

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 12.07.2010 14:31
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

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 13.07.2010 14:44
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?

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 13.07.2010 15:02
von DreamPromise
Moin moin

dann hast du sicher diesen Beitrag übersehen --> viewtopic.php?f=88&t=204908&start=700#p1186540 :wink:

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 13.07.2010 19:22
von Schorschi
Oder diesen. :D

viewtopic.php?f=88&t=206251&start=10#p1187018

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 14.07.2010 00:51
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.

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 14.07.2010 11:56
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()

Re: [BETA] phpBB3 Football MOD Version 0.9.1

Verfasst: 14.07.2010 12:17
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
Alle Zeiten sind UTC+02:00
Seite 76 von 214

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de