// Starten der Session
session_start($PHPSESSID);
// Fehlermeldungen abschalten
error_reporting (0);
// Verbindung zum internen Web-Server
require ("../admin/install/connect.inc");
$db = mysql_connect("$connect_server","$connect_user","$connect_pass");
mysql_select_db("$connect_datenbank",$db);
$heute=date("Y-m-d");
$zbody=""; $body="";
$result=mysql_query("select id,Name FROM helgo_okat WHERE cleared != '1' AND Name != '' ORDER BY Name");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$katname=$zeile["Name"];
$zbody.="
okat
$katname
id
$katid
";
$filename=$pfad."pics/helgoland/okat_".$katid."_1.jpg";
if (file_exists($filename)) {
$thumb=htmlentities("http://www.sonntags-einkaufen.com/helgoland/tmp/app/icon_okat_".$katid."_1.jpg");
$thumbname=htmlentities("icon_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/helgoland/okat_".$katid."_1.jpg";
$newname=$pfad."helgoland/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 FROM helgo_ukat WHERE cleared != '1'");
while($zeile=mysql_fetch_array($ssubresult)) {
$unterkatid=$zeile["id"];
$unterkatname=$zeile["Name"];
$subresult=mysql_query("select id FROM helgo_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;
}
}
}
$mng=count($ukatid);
asort($ukatname);
reset($ukatname);
$zbody.="
";
foreach ($ukatname as $key => $val) {
$zbody.="
id
$key
name
$val
";
$filename=$pfad."pics/helgoland/ukat_".$key."_1.jpg";
if (file_exists($filename)) {
$thumb=htmlentities("http://www.sonntags-einkaufen.com/helgoland/tmp/app/icon_ukat_".$key."_1.jpg");
$thumbname=htmlentities("icon_ukat_".$key."_1.jpg");
$filename=$pfad."helgoland/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/helgoland/ukat_".$key."_1.jpg";
$newname=$pfad."helgoland/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.="
";
}
$body="
";
$body.=$zbody;
$body.="
";
$body=utf8_encode($body);
$filename=$pfad."helgoland/tmp/kat2.plist";
if (file_exists($filename)) {unlink($filename);} // löschen der alten Datei
$handle = fopen("$filename", "a");
fwrite($handle, $body);
// ECHO "
$body
";
ECHO "
PList";
ECHO "Fertig
";
require("fileinfo.php");