// Starten der Session
session_start($PHPSESSID);
// Fehlermeldungen
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");
$result=mysql_query("select * FROM gnarr_okat WHERE cleared !='1'");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$gnarrokat[$katid]=$zeile["Name"];
}
$result=mysql_query("select * FROM gnarr_ukat WHERE cleared !='1'");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$gnarrukat[$katid]=$zeile["Name"];
}
$result=mysql_query("select * FROM ll_okat WHERE cleared !='1'");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$llokat[$katid]=$zeile["Name"];
}
$result=mysql_query("select * FROM ll_ukat WHERE cleared !='1'");
while($zeile=mysql_fetch_array($result)) {
$katid=$zeile["id"];
$llukat[$katid]=$zeile["Name"];
}
$result=mysql_query("select * FROM ll_adresse WHERE cleared !='1'");
while($zeile=mysql_fetch_array($result)) {
$oid=$zeile["id"];
$Firma=$zeile["Firma"];
$Vorname=$zeile["Vorname"];
$Nachname=$zeile["Nachname"];
$Oberkat=$zeile["Oberkat"];
$Oberkat2=$zeile["Oberkat2"];
$Oberkat3=$zeile["Oberkat3"];
$Oberkat4=$zeile["Oberkat4"];
$Oberkat5=$zeile["Oberkat5"];
$Oberkat6=$zeile["Oberkat6"];
$Unterkat=$zeile["Unterkat"];
$Unterkat2=$zeile["Unterkat2"];
$Unterkat3=$zeile["Unterkat3"];
$Unterkat4=$zeile["Unterkat4"];
$Unterkat5=$zeile["Unterkat5"];
$Unterkat6=$zeile["Unterkat6"];
$gnarrenburgId=$zeile["gnarrenburgId"];
$sresult=mysql_query("select * FROM gnarr_adresse WHERE id='$gnarrenburgId'");
while($zeile=mysql_fetch_array($sresult)) {
$goid=$zeile["id"];
$gOberkat=$zeile["Oberkat"];
$gOberkat2=$zeile["Oberkat2"];
$gOberkat3=$zeile["Oberkat3"];
$gOberkat4=$zeile["Oberkat4"];
$gOberkat5=$zeile["Oberkat5"];
$gOberkat6=$zeile["Oberkat6"];
$gUnterkat=$zeile["Unterkat"];
$gUnterkat2=$zeile["Unterkat2"];
$gUnterkat3=$zeile["Unterkat3"];
$gUnterkat4=$zeile["Unterkat4"];
$gUnterkat5=$zeile["Unterkat5"];
$gUnterkat6=$zeile["Unterkat6"];
$gLat=$zeile["Lat"];
$gLng=$zeile["Lng"];
$gDeaktiviert=$zeile["Deaktiviert"];
}
if (($Oberkat AND !$Unterkat) OR ($Oberkat2 AND !$Unterkat2) OR ($Oberkat3 AND !$Unterkat3) OR ($Oberkat4 AND !$Unterkat4) OR ($Oberkat5 AND !$Unterkat5) OR ($Oberkat6 AND !$Unterkat6)) {
ECHO "
$oid $Firma Vorname Nachname (";
if ($gUnterkat AND !$Unterkat) {ECHO "ukat: $gnarrukat[$gUnterkat] / ";}
if ($gUnterkat2 AND !$Unterkat2) {ECHO "ukat2: $gnarrukat[$gUnterkat2] / ";}
if ($gUnterkat3 AND !$Unterkat3) {ECHO "ukat3: $gnarrukat[$gUnterkat3] / ";}
if ($gUnterkat4 AND !$Unterkat4) {ECHO "ukat4: $gnarrukat[$gUnterkat4] / ";}
if ($gUnterkat5 AND !$Unterkat5) {ECHO "ukat5: $gnarrukat[$gUnterkat5] / ";}
if ($gUnterkat6 AND !$Unterkat6) {ECHO "ukat6: $gnarrukat[$gUnterkat6]";}
ECHO ")";
}
}