1)
return date("Y-M-d H:i:s",mktime(0,0,0,$month,1,$year)+(86400*(8-$num)));
else
return date("Y-M-d H:i:s",mktime(0,0,0,$month,1,$year)+(86400*(1-$num)));
}
$heute=date("Y-m-d");
$zbody=""; $body="";
FOR ($ta=0; $ta <=150; $ta++) {
$wdadd="";
$suchdat = date("Y-m-d", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
$wochentag = date("D", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y))).",";
$tag = date("d", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
$Monat = date("m", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
$Jahr = date("Y", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
$Monatsname = date("F", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
$tagzahl = date("w", mktime(0,0,0, date(m) ,date(d)+$ta,date(Y)));
IF ($tag == 1) {$erster=$wochentag; $wochenzaehler=1;}
IF ($tag != 1 AND $tagzahl == 0) {$wochenzaehler++;}
ECHO "$wochentag / $wochenzaehler / $suchdat:
";
$wdadd.="OR ((TageRegeln RLIKE '$wochentag') ";
$wdadd.="AND (TageRegeln RLIKE 'JedeWoche' OR TageRegeln RLIKE 'w$wochenzaehler') ";
$wdadd.="AND (TageRegeln RLIKE 'JedenMonat') ";
$wdadd.=")";
//ECHO "select * FROM ll_termine WHERE cleared != '1' AND Von = '$suchdat' $wdadd ORDER BY Von
";
$sresult=mysql_query("select * FROM ll_termine WHERE cleared != '1' AND Von = '$suchdat' $wdadd ORDER BY Von"); //
while($zeile=mysql_fetch_array($sresult)) {
$Tid=$zeile["id"];
$Name=$zeile["Name"];
$Beschreibung=htmlspecialchars ($zeile["Beschreibung"]);
$Von=$zeile["Von"];
$Bis=$zeile["Bis"];
$UVon=$zeile["Uhrzeit_Von"];
$UBis=$zeile["Uhrzeit_Bis"];
$Plz=$zeile["Plz"];
$Ort=$zeile["Ort"];
$Strasse=$zeile["Strasse"];
$Lat=$zeile["Lat"];
$Lng=$zeile["Lng"];
$TageRegeln=$zeile["TageRegeln"];
$Timestamp=$zeile["timestamp"];
$arr=explode(" ",$Timestamp);
$TimeDate=$arr[0];
$TimeTime=$arr[1];
IF ($Von == "0000-00-00") {$Von=$suchdat;}
IF ($Bis == "0000-00-00") {$Bis=$suchdat;}
if ($TageRegeln != "") {$Von=$suchdat; $Bis=$suchdat;}
$arr=explode("-",$Von);
$zarr=explode(":",$UVon);
$VonDate=date("Y-m-d", mktime($zarr[0], $zarr[1], $zarr[2], $arr[1], $arr[2], $arr[0]));
$VonTime=date("H:i:s", mktime($zarr[0], $zarr[1], $zarr[2], $arr[1], $arr[2], $arr[0]));
$arr=explode("-",$Von);
if ($UBis == "00:00:00") {$UBis=$UVon;}
$zarr=explode(":",$UBis);
$BisDate=date("Y-m-d", mktime($zarr[0], $zarr[1], $zarr[2], $arr[1], $arr[2], $arr[0]));
$BisTime=date("H:i:s", mktime($zarr[0], $zarr[1], $zarr[2], $arr[1], $arr[2], $arr[0]));
// if ($VonTime == "00:00:00") {$VonTime="05:00:00";}
// if ($BisTime == "00:00:00") {$BisTime="05:00:00";}
ECHO "hinzugefügt: $Name $suchdat
";
$zbody.="
Name
$Name
Beschreibung
$Beschreibung
id
$Tid
Von
".$VonDate."T".$VonTime."Z
Bis
".$BisDate."T".$BisTime."Z
Ort
$Ort
Plz
$Plz
Strasse
$Strasse
Lat
$Lat
Lng
$Lng
Timestamp
".$TimeDate."T".$TimeTime."Z
";
IF (file_exists($pfad."pics/LandLeben/term_".$Tid."_1.jpg")) {
$zbody.=" Bild
http://www.sonntags-einkaufen.com/LandLeben/tmp/app/term_".$Tid."_1.jpg
Thumb
http://www.sonntags-einkaufen.com/LandLeben/tmp/app/icon_term_".$Tid."_1.jpg
Bildname
term_".$Tid."_1.jpg
Thumbname
icon_term_".$Tid."_1.jpg
";
$zbody.=" Bilder
";
FOR ($i=1; $i<=10 ;$i++) {
$userfile=$pfad."pics/LandLeben/term_".$Tid."_".$i.".jpg";
$newname=$pfad."LandLeben/tmp/app/term_".$Tid."_".$i.".jpg";
IF (!file_exists($newname) OR $renew) {
system("convert $userfile -resize '320' -quality 75% $newname");
system("convert -unsharp 1.5x1.2+1.0+0.10 $newname $newname");
}
$userfile=$pfad."pics/landLeben/term_".$Tid."_".$i.".jpg";
$newname=$pfad."LandLeben/tmp/app/icon_term_".$Tid."_".$i.".jpg";
IF (!file_exists($newname) OR $renew) {
system("convert $userfile -resize '100x100' $newname");
system("convert -unsharp 1.5x1.2+1.0+0.10 $newname $newname");
}
IF (file_exists($pfad."LandLeben/tmp/app/term_".$Tid."_".$i.".jpg")) {
$pic="http://www.sonntags-einkaufen.com/LandLeben/tmp/app/term_".$Tid."_".$i.".jpg";
$thumb="http://www.sonntags-einkaufen.com/LandLeben/tmp/app/icon_term_".$Tid."_".$i.".jpg";
$picname="term_".$Tid."_".$i.".jpg";
$thumbname="icon_term_".$Tid."_".$i.".jpg";
$zbody.="
Bild
$pic
Thumb
$thumb
Bildname
$picname
Thumbname
$thumbname
";
}
}
$zbody.="
";
}
$zbody.="
";
} // while
}
$trans = array("(null)" => "", "ß" => "ß", """ => "", "&" => "", '"' => '', '“' => '', '„' => '', '&' => 'amp;');
$zbody=strtr("$zbody", $trans) ;
$body="
";
$body.=$zbody;
$body.="
";
$body=utf8_encode($body);
$filename=$pfad."LandLeben/tmp/termine2.plist";
IF (file_exists($filename)) {unlink($filename);} // löschen der alten Datei
$handle = fopen("$filename", "a");
fwrite($handle, $body);
ECHO "
$body
";
require("fileinfo.php");