okat
$katname
id
$katid
Timestamp
".$TimeDate."T".$TimeTime."Z
";
IF (file_exists($pfad."pics/landLeben/okat_".$katid."_1.jpg")) {
$thumb=htmlentities("http://www.sonntags-einkaufen.com/LandLeben/tmp/app/icon_okat_".$katid."_1.jpg");
$thumbname=htmlentities("icon_okat_".$katid."_1.jpg");
$filename=$pfad."pics/landLeben/okat_".$katid."_1.jpg";
$Datum=filemtime($filename);
$arr=explode("-",$Von);
$zarr=explode(":",$UVon);
$VonDate=date("Y-m-d", $Datum);
$VonTime=date("H:i:s", $Datum);
$zbody.=" Thumb
$thumb
Thumbname
$thumbname
Timestamp
".$VonDate."T".$VonTime."Z
";
$userfile=$pfad."pics/landLeben/okat_".$katid."_1.jpg";
$newname=$pfad."LandLeben/tmp/app/icon_okat_".$katid."_1.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");
}
}
$zbody.=" UKat
";
$ukats=""; $ukatsname=""; $ukatid=""; $ukatname="";
$ssubresult=mysql_query("select id,Name,timestamp FROM ll_ukat WHERE cleared != '1'");
while($zeile=mysql_fetch_array($ssubresult)) {
$unterkatid=$zeile["id"];
$unterkatname=$zeile["Name"];
$subresult=mysql_query("select id,timestamp FROM ll_adresse WHERE cleared != '1' AND ((Oberkat = '$katid' AND Unterkat = '$unterkatid') OR (Oberkat2 = '$katid' AND Unterkat2 = '$unterkatid') OR (Oberkat3 = '$katid' AND Unterkat3 = '$unterkatid') OR (Oberkat4 = '$katid' AND Unterkat4 = '$unterkatid') OR (Oberkat5 = '$katid' AND Unterkat5 = '$unterkatid'))");
while($zeile=mysql_fetch_array($subresult)) {
$ortid=$zeile["id"];
IF (!in_array($unterkatid,$ukatid)) {
$ukatid[]=$unterkatid;
$ukatname[$unterkatid]=$unterkatname;
$UTimestamp[$ortid]=$zeile["timestamp"];
$arr=explode(" ",$UTimestamp[$ortid]);
$ukatdate[$unterkatid]=$arr[0];
$ukattime[$unterkatid]=$arr[1];
ECHO "$katid: $ortid $UTimeDate[$ortid] $UTimeTime[$ortid]
";
}
}
}
$mng=count($ukatid);
asort($ukatname);
reset($ukatname);
$zbody.="
";
foreach ($ukatname as $key => $val) {
$trans = array('&' => 'amp;');
$val=strtr($val, $trans) ;
$zbody.="
id
$key
name
$val
Timestamp
".$ukatdate[$key]."T".$ukattime[$key]."Z
";
IF (file_exists($pfad."pics/landLeben/ukat_".$key."_1.jpg")) {
$thumb=htmlentities("http://www.sonntags-einkaufen.com/LandLeben/tmp/app/icon_ukat_".$key."_1.jpg");
$thumbname=htmlentities("icon_ukat_".$key."_1.jpg");
$filename=$pfad."landLeben/tmp/app/icon_ukat_".$key."_1.jpg";
$Datum=filemtime($filename);
$arr=explode("-",$Von);
$zarr=explode(":",$UVon);
$VonDate=date("Y-m-d", $Datum);
$VonTime=date("H:i:s", $Datum);
$zbody.=" Thumb
$thumb
Thumbname
$thumbname
Timestamp
".$VonDate."T".$VonTime."Z
";
$userfile=$pfad."pics/landLeben/ukat_".$key."_1.jpg";
$newname=$pfad."LandLeben/tmp/app/icon_ukat_".$key."_1.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");
}
}
$zbody.="
";
}
$zbody.="
";
}
$trans = array("(null)" => "", "ß" => "ß", """ => "", "&" => "", '"' => '', '“' => '', '„' => '', '&' => 'amp;');
$zbody=strtr("$zbody", $trans) ;
$body="
";
$body.=$zbody;
$body.="
";
$body=utf8_encode($body);
$filename=$pfad."LandLeben/tmp/kat2.plist";
IF (file_exists($filename)) {unlink($filename);} // löschen der alten Datei
$handle = fopen("$filename", "a");
fwrite($handle, $body);
ECHO "
PList";
require("fileinfo.php");