Wird nicht umgesetzt Countdownboxen für die 1 & 2 Bundesliga... - LMP - Vorschläge und Wünsche

php:

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

$lmpLeagueID = '110101';
$lmpNextMatch = $db->query_first("SELECT m.matchID, m.matchDateTime, t1.teamName AS team1Name, t2.teamName AS team2Name, o.lmpValue AS lmpDeadline4Tip FROM bb".$n."_lmp_".$lmpLeagueID."_matches m LEFT JOIN bb".$n."_lmp_000000_options o ON (lmpVarname='lmpDeadline4Tip') LEFT JOIN bb".$n."_lmp_".$lmpLeagueID."_teams t1 ON (m.team1ID=t1.teamID) LEFT JOIN bb".$n."_lmp_".$lmpLeagueID."_teams t2 ON (m.team2ID=t2.teamID) WHERE m.matchOK = 0 AND m.matchDateTime-(o.lmpValue*60) > ".time()." ORDER BY m.matchDateTime ASC, m.matchID ASC LIMIT 0,1");
$lmpCutoffNextMatch = intval($lmpNextMatch['matchDateTime']) - (intval($lmpNextMatch['lmpDeadline4Tip'])*60);
$lmpMatchDayCountDown = LmpLeagueCountdownTimer($lmpCutoffNextMatch, time());
$lmpMatchID = intval($lmpNextMatch['matchID']);
$lmpTeam1 = stripslashes($lmpNextMatch['team1Name']);
$lmpTeam2 = stripslashes($lmpNextMatch['team2Name']);
$lmpMatchDayCountDown = "Annahmeschlu&szlig; f&uuml;r den Tipp zum Spiel <b>".$lmpTeam1." - ".$lmpTeam2."</b><br >in der 1. Fu&szlig;ball Bundesliga ist in ".$lmpMatchDayCountDown;
 
function LmpLeagueCountdownTimer($lmpTargetTime, $lmpActualTime) {
	global $lmpTargetDate;
	if ($lmpTargetTime > $lmpActualTime) {
    	$lmpTimeDiff = $lmpTargetTime - $lmpActualTime;
    	$lmpMonths = floor($lmpTimeDiff / (60 * 60 * 24 * 30.4166));
    	$lmpOddTime = $lmpTimeDiff-($lmpMonths * (60 * 60 * 24 * 30.4166));
    	$lmpDays = floor($lmpOddTime / 86400);
    	$lmpOddTime = $lmpOddTime-($lmpDays * 86400);
    	$lmpHours = floor($lmpOddTime /3600);
    	$lmpOddTime = $lmpOddTime-($lmpHours * 3600);
    	$lmpMinutes = floor($lmpOddTime / 60);
    	$lmpOddTime = $lmpOddTime-($lmpMinutes * 60);
		if ($lmpMonths == 0) $lmpMonths = "";
		else if ($lmpMonths == 1) $lmpMonths = "<b>".$lmpMonths."</b> Monat";
		else if ($lmpMonths > 1) $lmpMonths = "<b>".$lmpMonths."</b> Monate";
		if ($lmpDays == 0) $lmpDays = "<b>0</b> Tagen";
		else if ($lmpDays == 1) $lmpDays = "<b>".$lmpDays."</b> Tag";
		else if ($lmpDays > 1) $lmpDays = "<b>".$lmpDays."</b> Tagen";
		if ($lmpHours == 0) $lmpHours = "<b>0</b> Stunden";
		else if ($lmpHours == 1) $lmpHours = "<b>".$lmpHours."</b> Stunde";
		else if ($lmpHours > 1) $lmpHours = "<b>".$lmpHours."</b> Stunden";
		if ($lmpMinutes == 0) $lmpMinutes = "<b>0</b> Minuten";
		else if ($lmpMinutes == 1) $lmpMinutes = "<b>".$lmpMinutes."</b> Minute";
		else if ($lmpMinutes > 1) $lmpMinutes = "<b>".$lmpMinutes."</b> Minuten";
		$lmpTargetDate = $lmpMonths.' '.$lmpDays.' '.$lmpHours.' '.$lmpMinutes;
	} else {
		$lmpTargetDate = '';
	}
	return $lmpTargetDate;
}

$lmpLeagueID = '110102'; $lmpNextMatch = $db->query_first("SELECT m.matchID, m.matchDateTime, t1.teamName AS team1Name, t2.teamName AS team2Name, o.lmpValue AS lmpDeadline4Tip FROM bb".$n."_lmp_".$lmpLeagueID."_matches m LEFT JOIN bb".$n."_lmp_000000_options o ON (lmpVarname='lmpDeadline4Tip') LEFT JOIN bb".$n."_lmp_".$lmpLeagueID."_teams t1 ON (m.team1ID=t1.teamID) LEFT JOIN bb".$n."_lmp_".$lmpLeagueID."_teams t2 ON (m.team2ID=t2.teamID) WHERE m.matchOK = 0 AND m.matchDateTime-(o.lmpValue*60) > ".time()." ORDER BY m.matchDateTime ASC, m.matchID ASC LIMIT 0,1"); $lmpCutoffNextMatch = intval($lmpNextMatch['matchDateTime']) - (intval($lmpNextMatch['lmpDeadline4Tip'])*60); $lmpMatchDayCountDown2 = LmpLeagueCountdownTimer($lmpCutoffNextMatch, time()); $lmpMatchID = intval($lmpNextMatch['matchID']); $lmpTeam1 = stripslashes($lmpNextMatch['team1Name']); $lmpTeam2 = stripslashes($lmpNextMatch['team2Name']); $lmpMatchDayCountDown2 = "Annahmeschluß für den Tipp zum Spiel <b>".$lmpTeam1." - ".$lmpTeam2."</b><br >in der 2. Fußball Bundesliga ist in ".$lmpMatchDayCountDown2;