moved public files to public, old and yet untouched files to directories ending with _old

14 files changed, 1876 insertions, 0 deletions

diff --git a/www-ssl_old/admin/UserPicture.php b/www-ssl_old/admin/UserPicture.php
new file mode 100644
index 00000000..25f8b54b
--- /dev/null
+++ b/www-ssl_old/admin/UserPicture.php
@@ -0,0 +1,132 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "UserPicture";
+$header = "Verwaltung der User Picture";
+
+include ("includes/header.php");
+include ("includes/funktion_schichtplan_aray.php");
+
+if (IsSet ($_GET["action"])) {
+	UnSet ($SQL);
+
+	switch ($_GET["action"]) {
+		case 'FormUpload' :
+			echo "Hier kannst Du ein Foto hochladen f&ouml;r:";
+			echo "<form action=\"./UserPicture.php?action=sendPicture\" method=\"post\" enctype=\"multipart/form-data\">\n";
+			echo "\t<select name=\"UID\">\n";
+			$usql = "SELECT * FROM `User` ORDER BY `Nick`";
+			$uErg = mysql_query($usql, $con);
+			for ($k = 0; $k < mysql_num_rows($uErg); $k++)
+				echo "\t\t<option value=\"" . mysql_result($uErg, $k, "UID") . "\">" . mysql_result($uErg, $k, "Nick") . "</option>\n";
+			echo "\t</select>\n";
+			echo "\t<input type=\"hidden\" name=\"action\" value=\"sendPicture\">\n";
+			echo "\t<input name=\"file\" type=\"file\" size=\"50\" maxlength=\"" . get_cfg_var("post_max_size") . "\">\n";
+			echo "\t(max " . get_cfg_var("post_max_size") . "Byte)<br />\n";
+			echo "\t<input type=\"submit\" value=\"" . Get_Text("upload"), "\">\n";
+			echo "</form>\n";
+			break;
+		case 'sendPicture' :
+			if (($_FILES["file"]["size"] > 0) && (isset ($_POST["UID"]))) {
+				if (($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/png") || ($_FILES["file"]["type"] == "image/gif")) {
+					$data = addslashes(fread(fopen($_FILES["file"]["tmp_name"], "r"), filesize($_FILES["file"]["tmp_name"])));
+
+					if (GetPicturShow($_POST['UID']) == "")
+						$SQL = "INSERT INTO `UserPicture` " .
+						"( `UID`,`Bild`, `ContentType`, `show`) " .
+						"VALUES ('" . $_POST['UID'] . "', '$data', '" . $_FILES["file"]["type"] . "', 'N')";
+					else
+						$SQL = "UPDATE `UserPicture` SET " .
+						"`Bild`='$data', " .
+						"`ContentType`='" . $_FILES["file"]["type"] . "' " .
+						"WHERE `UID`='" . $_POST['UID'] . "'";
+
+					echo "Upload Pictur:'" . $_FILES["file"]["name"] . "', " .
+					"MIME-Type: " . $_FILES["file"]["type"] . ", " .
+					$_FILES["file"]["size"] . " Byte " .
+					"for " . UID2Nick($_POST["UID"]);
+				} else
+					Print_Text("pub_einstellungen_send_KO");
+			} else
+				Print_Text("pub_einstellungen_send_KO");
+			break;
+
+		case 'SetN' :
+			if (IsSet ($_GET["UID"])) {
+				echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gesperrt:<br />";
+				$SQL = "UPDATE `UserPicture` SET `show`='N' WHERE `UID`='" . $_GET["UID"] . "'";
+			} else
+				echo "Fehlerhafter Aufruf";
+			break;
+		case 'SetY' :
+			if (IsSet ($_GET["UID"])) {
+				echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde Freigegeben:<br />";
+				$SQL = "UPDATE `UserPicture` SET `show`='Y' WHERE `UID`='" . $_GET["UID"] . "'";
+			} else
+				echo "Fehlerhafter Aufruf";
+			break;
+		case 'del' :
+			echo "Wollen Sie das Bild von '" . UID2Nick($_GET["UID"]) . "' wirklich l&ouml;schen? " .
+			"<a href=\"./UserPicture.php?action=delYes&UID=" . $_GET["UID"] . "\">Yes</a>";
+			break;
+		case 'delYes' :
+			if (IsSet ($_GET["UID"])) {
+				echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gel&ouml;scht:<br />";
+				$SQL = "DELETE FROM `UserPicture` WHERE `UID`='" . $_GET["UID"] . "' LIMIT 1";
+			} else
+				echo "Fehlerhafter Aufruf";
+			break;
+		default :
+			echo "Fehlerhafter Aufruf";
+
+	} //switch
+
+	// Update ???
+	if (IsSet ($SQL)) {
+		// hier muesste das SQL ausgefuehrt werden...
+		$Erg = mysql_query($SQL, $con);
+		if ($Erg == 1)
+			echo "&Auml;nderung wurde gesichert...<br />";
+		else {
+			echo "Fehler beim speichern... bitte noch ein mal probieren :)";
+			echo "<br /><br />" . mysql_error($con) . "<br />($SQL)<br />";
+		}
+	} // Ende Update                
+	echo "<br />\n<hr width=\"100%\">\n<br />\n\n";
+} //IF IsSet($action)
+
+//ausgabe der Liste
+$Sql = "SELECT * FROM `UserPicture` WHERE `UID`>0;";
+$Erg = mysql_query($Sql, $con);
+
+echo "Hallo " . $_SESSION['Nick'] . ",<br />\nhier hast du die M&ouml;glichkeit, die Bilder der Engel freizugeben:<br /><br />\n";
+
+echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+echo "<tr class=\"contenttopic\">\n";
+echo "\t<td>User</td>\n";
+echo "\t<td>Bild</td>\n";
+echo "\t<td>Status</td>\n";
+echo "\t<td>L&ouml;schen</td>\n";
+echo "</tr>";
+
+for ($t = 0; $t < mysql_num_rows($Erg); $t++) {
+	$UIDs = mysql_result($Erg, $t, "UID");
+	echo "\t<tr class=\"content\">\n";
+
+	echo "\t\t<td>" . UID2Nick(mysql_result($Erg, $t, "UID")) . "</td>\n";
+	echo "\t\t<td>" . displayPictur($UIDs, 0) . "</td>\n";
+
+	if (GetPicturShow($UIDs) == "Y")
+		echo "\t\t<td><a href=\"./UserPicture.php?action=SetN&UID=$UIDs\">sperren</a></td>\n";
+	elseif (GetPicturShow($UIDs) == "N") echo "\t\t<td><a href=\"./UserPicture.php?action=SetY&UID=$UIDs\">freigeben</a></td>\n";
+	else
+		echo "\t\t<td>ERROR: show='" . GetPicturShow($UIDs) . "'</td>\n";
+	echo "\t\t<td><a href=\"./UserPicture.php?action=del&UID=$UIDs\">del</a></td>\n";
+	echo "\t</tr>\n";
+} // ende Auflistung Raeume
+echo "</table>";
+
+echo "<br /><a href=\"./UserPicture.php?action=FormUpload\">picture upload</a>\n";
+
+include ("includes/footer.php");
+?>
diff --git a/www-ssl_old/admin/aktiv.php b/www-ssl_old/admin/aktiv.php
new file mode 100644
index 00000000..8db62f98
--- /dev/null
+++ b/www-ssl_old/admin/aktiv.php
@@ -0,0 +1,105 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "akive Engel";
+$header = "Liste der aktiven Engel";
+include ("includes/header.php");
+include ("includes/funktion_db_list.php");
+
+echo "<form action=\"./aktiv.php\" method=\"post\">";
+echo Get_Text("pub_aktive_Text1") . "<br />\n";
+echo Get_Text("pub_aktive_Text2") . "<br /><br />\n";
+
+// auswahlbox
+echo Get_Text("pub_aktive_Text31") . "\n";
+echo "<select name=\"Anzahl\">\n";
+for ($i = 0; $i < 50; $i++)
+	echo "\t<option value=\"$i\">$i</option>\n";
+echo "</select>";
+echo Get_Text("pub_aktive_Text32") . "<br /><br />\n";
+echo "<input type=\"submit\" name=\"SendType\" value=\"Show..\">\n";
+echo "<input type=\"submit\" name=\"SendType\" value=\"Write..\">\n";
+echo "</form>\n";
+
+echo "<form action=\"./aktiv.php\" method=\"post\">\n";
+echo "\t<br /><input type=\"submit\" name=\"ResetActive\" value=\"reset Active setting\">\n";
+echo "</form>\n";
+
+if (Isset ($_POST["ResetActive"])) {
+	$SQLreset = "UPDATE `User` SET `Aktiv`='0'";
+	$ErgReset = db_query($SQLreset, "Reset Active");
+	if ($ErgReset != 1)
+		echo "Fehler beim zuruecksetzen der Activ\n";
+	else
+		echo "Active wurde erfolgreich zurueckgesetzt\n";
+}
+
+if (IsSet ($_POST["Anzahl"]))
+	echo "<br />\n\n" . Get_Text("pub_aktive_Text5_1") . $_POST["Anzahl"] . Get_Text("pub_aktive_Text5_2") . ":";
+
+echo "<br /><br />\n\n";
+
+//ausgabe tabelle
+echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+echo "<tr class=\"contenttopic\">\n";
+echo "\t<td>" . Get_Text("pub_aktive_Nick") . "</td>\n";
+echo "\t<td>" . Get_Text("pub_aktive_Anzahl") . "</td>\n";
+echo "\t<td>" . Get_Text("pub_aktive_Time") . "</td>\n";
+echo "\t<td>" . Get_Text("pub_aktive_Time") . " Weight</td>\n";
+echo "\t<td>Freeloader " . Get_Text("pub_aktive_Anzahl") . "</td>\n";
+echo "\t<td>Freeloader " . Get_Text("pub_aktive_Time") . "</td>\n";
+echo "\t<td>" . Get_Text("pub_aktive_Time") . " result</td>\n";
+echo "\t<td>" . Get_Text("pub_aktive_Active") . "</td>\n";
+echo "</tr>\n";
+
+$SQL = "
+SELECT d.UID, d.nr, d.len, d.lenWeight, f.nr AS nrFree, f.len AS lenFree, d.lenWeight - COALESCE(f.len, 0) as lenReal
+  FROM
+    (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d
+    LEFT JOIN
+    (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f
+    USING(UID)
+  ORDER BY lenReal DESC, nr DESC, UID";
+
+$Erg = mysql_query($SQL, $con);
+echo mysql_error($con);
+$rowcount = mysql_num_rows($Erg);
+
+$aktivecount = 0;
+for ($i = 0; $i < $rowcount; $i++) {
+	echo "\n\n\t<tr class=\"content\">\n";
+	echo "\t\t<td>" . UID2Nick(mysql_result($Erg, $i, "UID")) . "</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "nr") . "x</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "len") . "h</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "lenWeight") . "h</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "nrFree") . "x</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "lenFree") . "h</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "lenReal") . "h</td>\n";
+
+	echo "\t\t<td>";
+	if (IsSet ($_POST["Anzahl"])) {
+		if ($_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal")) {
+			$aktivecount++;
+			if ($_POST["SendType"] == "Show..")
+				echo "show set";
+			else {
+				$SQL2 = "UPDATE `User` SET `Aktiv`='1' WHERE `UID`='" . mysql_result($Erg, $i, "UID") . "' LIMIT 1";
+				$Erg2 = db_query($SQL2, "update Active State");
+				if ($Erg2 != 1)
+					echo "Fehler beim speichern bei Engel " . UID2Nick(mysql_result($Erg, $i, "UID"));
+				else
+					echo "write set";
+			}
+		}
+	}
+	echo "</td>\n";
+	echo "\t</tr>\n";
+} // ende Auflistung aktive Engel 
+
+echo "</table>";
+
+echo "<br />Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)<br /><br />";
+
+include ("includes/footer.php");
+?>
+
diff --git a/www-ssl_old/admin/dbUpdateFromXLS.php b/www-ssl_old/admin/dbUpdateFromXLS.php
new file mode 100644
index 00000000..88879de7
--- /dev/null
+++ b/www-ssl_old/admin/dbUpdateFromXLS.php
@@ -0,0 +1,252 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "DB Update from XML";
+$header = "DB Update from XML";
+include ("includes/header.php");
+include ("includes/funktion_xml.php");
+
+///////////
+// DEBUG //
+///////////
+$ShowDataStrukture = 0;
+$EnableRoomFunctions = 1;
+$EnableRooms = 1;
+$EnableSchudleFunctions = 1;
+$EnableSchudle = 1;
+$EnableSchudleDB = 1;
+
+/*##############################################################################################
+        erstellt Arrays der Reume
+  ##############################################################################################*/
+function CreateRoomArrays() {
+	global $Room, $RoomID, $RoomName, $con;
+
+	$sql = "SELECT `RID`, `Name` FROM `Room` " .
+	"WHERE `Show`='Y'" .
+	"ORDER BY `Number`, `Name`;";
+	$Erg = mysql_query($sql, $con);
+	$rowcount = mysql_num_rows($Erg);
+
+	for ($i = 0; $i < $rowcount; $i++) {
+		$Room[$i]["RID"] = mysql_result($Erg, $i, "RID");
+		$Room[$i]["Name"] = mysql_result($Erg, $i, "Name");
+		$RoomID[mysql_result($Erg, $i, "RID")] = mysql_result($Erg, $i, "Name");
+		$RoomName[mysql_result($Erg, $i, "Name")] = mysql_result($Erg, $i, "RID");
+	}
+}
+CreateRoomArrays();
+
+/*##############################################################################################
+                   F I L E
+  ##############################################################################################*/
+echo "\n\n<br />\n<h1>XML File:</h1>\n";
+if (isset ($_POST["PentabarfUser"]) && isset ($_POST["password"]) && isset ($_POST["PentabarfURL"])) {
+	echo "Update XCAL-File from Pentabarf..";
+	if ($PentabarfGetWith == "fsockopen") {
+
+		//backup error messeges and delate
+		$Backuperror_messages = $error_messages;
+		$fp = fsockopen("ssl://$PentabarfXMLhost", 443, $errno, $errstr, 30);
+		//  $error_messages = $Backuperror_messages;
+
+		if (!$fp) {
+			echo "<h2>fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!" .
+			"[$errstr ($errno)]</h2>";
+		} else {
+			if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) {
+				$head = 'GET /' . $PentabarfXMLpath . $_POST["PentabarfURL"] . ' HTTP/1.1' . "\r\n" .
+				'Host: ' . $PentabarfXMLhost . "\r\n" .
+				'User-Agent: Engelsystem' . "\r\n" .
+				'Authorization: Basic ' .
+				base64_encode($_POST["PentabarfUser"] . ':' . $_POST["password"]) . "\r\n" .
+				"\r\n";
+				fputs($fp, $head);
+				$Zeilen = -1;
+				while (!feof($fp)) {
+					$Temp = fgets($fp, 1024);
+
+					// ende des headers
+					if ($Temp == "f20\r\n") {
+						$Zeilen = 0;
+						$Temp = "";
+					}
+
+					//file ende?
+					if ($Temp == "0\r\n")
+						break;
+
+					if (($Zeilen > -1) && ($Temp != "ffb\r\n")) {
+						//steuerzeichen ausfiltern
+						if (strpos("#$Temp", "\r\n") > 0)
+							$Temp = substr($Temp, 0, strlen($Temp) - 2);
+						if (strpos("#$Temp", "1005") > 0)
+							$Temp = "";
+						if (strpos("#$Temp", "783") > 0)
+							$Temp = "";
+						//schreiben in file
+						fputs($fileOut, $Temp);
+						$Zeilen++;
+					}
+				}
+				fclose($fileOut);
+
+				echo "<br />Es wurden $Zeilen Zeilen eingelesen<br />";
+			} else
+				echo "<h2>fail: File '$Tempdir/engelXML' not writeable!</h2>";
+			fclose($fp);
+		}
+	}
+	elseif ($PentabarfGetWith == "fopen") {
+		//user uns password in url einbauen
+		$FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" .
+		$PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"];
+
+		if (($fileIn = fopen($FileNameIn, "r")) != FALSE) {
+			if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) {
+				$Zeilen = 0;
+				while (!feof($fileIn)) {
+					$Zeilen++;
+					fputs($fileOut, fgets($fileIn));
+				}
+				fclose($fileOut);
+				echo "<br />Es wurden $Zeilen Zeilen eingelesen<br />";
+			} else
+				echo "<h2>fail: File '$Tempdir/engelXML' not writeable!</h2>";
+			fclose($fileIn);
+		} else
+			echo "<h2>fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!</h2>";
+	}
+	elseif ($PentabarfGetWith == "wget") {
+		$Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " .
+		"https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] .
+		" --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" .
+		" --no-check-certificate";
+		echo system($Command, $Status);
+		if ($Status == 0)
+			echo "OK.<br />";
+		else
+			echo "fail ($Status)($Command).<br />";
+	}
+	elseif ($PentabarfGetWith == "lynx") {
+		$Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " .
+		"https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML";
+		echo system($Command, $Status);
+		if ($Status == 0)
+			echo "OK.<br />";
+		else
+			echo "fail ($Status)($Command).<br />";
+	}
+	elseif ($PentabarfGetWith == "fopen") {
+		//user uns password in url einbauen
+		$FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" .
+		$PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"];
+
+		if (($fileIn = fopen($FileNameIn, "r")) != FALSE) {
+			if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) {
+				$Zeilen = 0;
+				while (!feof($fileIn)) {
+					$Zeilen++;
+					fputs($fileOut, fgets($fileIn));
+				}
+				fclose($fileOut);
+				echo "<br />Es wurden $Zeilen Zeilen eingelesen<br />";
+			} else
+				echo "<h2>fail: File '$Tempdir/engelXML' not writeable!</h2>";
+			fclose($fileIn);
+		} else
+			echo "<h2>fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!</h2>";
+	}
+	elseif ($PentabarfGetWith == "wget") {
+		$Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " .
+		"https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] .
+		" --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" .
+		" --no-check-certificate";
+		echo system($Command, $Status);
+		if ($Status == 0)
+			echo "OK.<br />";
+		else
+			echo "fail ($Status)($Command).<br />";
+	}
+	elseif ($PentabarfGetWith == "lynx") {
+		$Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " .
+		"https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML";
+		echo system($Command, $Status);
+		if ($Status == 0)
+			echo "OK.<br />";
+		else
+			echo "fail ($Status)($Command).<br />";
+	} else
+		echo "<h1>The PentabarfGetWith='$PentabarfGetWith' not supported</h1>";
+} else {
+	echo "<form action=\"dbUpdateFromXLS.php\" method=\"post\">\n";
+	echo "<table border=\"0\">\n";
+	echo "\t<tr><td>XCAL-File: https://$PentabarfXMLhost/$PentabarfXMLpath</td>" .
+	"<td><input name=\"PentabarfURL\" type=\"text\" size=\"4\" maxlength=\"5\" " .
+	"value=\"$PentabarfXMLEventID\"></td></tr>\n";
+	echo "\t<tr><td>Username:</td>" .
+	"<td><input name=\"PentabarfUser\" type=\"text\" size=\"30\" maxlength=\"30\"></td></tr>\n";
+	echo "\t<tr><td>Password:</td>" .
+	"<td><input name=\"password\" type=\"password\" size=\"30\" maxlength=\"30\"></td></tr>\n";
+	echo "\t<tr><td></td><td><input type=\"submit\" name=\"FileUpload\" value=\"upload\"></td></tr>\n";
+	echo "</table>\n";
+	echo "</form>\n";
+}
+
+//readXMLfile("xml.php.xml");
+if (readXMLfile("$Tempdir/engelXML") == 0) {
+	$XMLmain = getXMLsubPease($XMLmain, "VCALENDAR");
+
+	if ($ShowDataStrukture) {
+		echo "<pre><br />";
+		echo $XMLmain->name;
+		echo "<br />";
+		print_r(array_values($XMLmain->sub));
+		echo "</pre>";
+	}
+
+	/*
+	echo "<br />";
+	$Feld=7;
+	echo "$Feld#". $XMLmain->sub[$Feld]->name. "<br />";
+	echo "$Feld#". $XMLmain->sub[$Feld]->sub;
+	//print_r(array_values ($XMLmain->sub[$Feld]->sub));
+	while(list($key, $value) = each($XMLmain->sub[$Feld]->sub))
+	  echo "?ID".$value->sub[1]->data. "=". $value->sub[2]->data. "\n";
+	echo "</pre>";
+	*/
+
+	/*##############################################################################################
+	                   V e r s i o n
+	  ##############################################################################################*/
+
+	echo "<hr>\n";
+	$XMLrelease = getXMLsubPease($XMLmain, "X-WR-CALDESC");
+	echo "release: " . $XMLrelease->data . "<br />\n";
+	//$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE");
+	//echo "release date: ". $XMLreleaseDate->data. "<br />\n";
+	echo "<hr>\n";
+
+	/*##############################################################################################
+	                   V e r s i o n
+	  ##############################################################################################*/
+	if ($EnableRoomFunctions)
+		include ("includes/funktion_xml_room.php");
+
+	if ($EnableSchudleFunctions)
+		include ("includes/funktion_xml_schudle.php");
+
+	/*##############################################################################################
+	                 U P D A T E  A L L 
+	  ##############################################################################################*/
+	echo "\n\n<br />\n<h1>Update ALL:</h1>\n";
+
+	echo "<form action=\"dbUpdateFromXLS.php\">\n";
+	echo "\t<input type=\"submit\" name=\"UpdateALL\" value=\"now\">\n";
+	echo "</form>\n";
+
+} //if XMLopenOOK
+
+include ("includes/footer.php");
+?>
+
diff --git a/www-ssl_old/admin/dect.php b/www-ssl_old/admin/dect.php
new file mode 100644
index 00000000..4e9f472a
--- /dev/null
+++ b/www-ssl_old/admin/dect.php
@@ -0,0 +1,69 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Engelsystem - DECT";
+$header = "DECT send call";
+include ("includes/header.php");
+
+include ("config/config_IAX.php");
+//include ("includes/funktion_modem.php");
+include ("includes/funktion_cron.php");
+
+if (!isset ($_GET["dial"]))
+	$_GET["dial"] = "";
+if (!isset ($_GET["custum"]))
+	$_GET["custum"] = "";
+
+if ($_GET["dial"] == "dial") {
+	if ($_GET["DECT"] == "")
+		$Number = $_GET["custum"];
+	else
+		$Number = $_GET["DECT"];
+
+	if (strlen($_GET["timeh"]) == 1)
+		$_GET["timeh"] = "0" . $_GET["timeh"];
+
+	if (strlen($_GET["timem"]) == 1)
+		$_GET["timem"] = "0" . $_GET["timem"];
+
+	//  SetWackeup( $Number, $_GET["timeh"], $_GET["timem"]);
+	DialNumberIAX($Number, $_GET["timeh"], $_GET["timem"], 0);
+
+	$_GET["custum"] = $Number;
+}
+
+echo "<form action=\"./dect.php\" method=\"GET\">\n";
+echo "<table>\n";
+
+echo "<tr><th>Number</th><th>h:m</th><th></th></tr>\n";
+
+echo "<tr><td>\n";
+// Listet alle Nicks auf
+echo "<select name=\"DECT\">\n";
+echo "\t<option value=\"\">costum</option>\n";
+
+$usql = "SELECT * FROM `User` WHERE NOT `DECT`='' ORDER BY `Nick`";
+$uErg = mysql_query($usql, $con);
+$urowcount = mysql_num_rows($uErg);
+for ($k = 0; $k < $urowcount; $k++) {
+	echo "\t<option value=\"" . mysql_result($uErg, $k, "DECT") . "\">" .
+	mysql_result($uErg, $k, "Nick") .
+	" (" . mysql_result($uErg, $k, "DECT") . ")" .
+	"</option>\n";
+}
+echo "</select>\n";
+
+echo "<input type=\"text\" name=\"custum\" size=\"4\" maxlength=\"4\" value=\"" . $_GET["custum"] . "\">\n";
+echo "</td>\n";
+
+echo "<td><input type=\"text\" name=\"timeh\" size=\"2\" maxlength=\"2\" value=\"" . gmdate("H", time() + 90 + 3600) . "\">:";
+echo "<input type=\"text\" name=\"timem\" size=\"2\" maxlength=\"2\" value=\"" . gmdate("i", time() + 90 + 3600) . "\"></td>\n";
+echo "<td><input type=\"submit\" name=\"dial\" value=\"dial\"></td>\n";
+echo "</tr>";
+echo "</table>\n";
+
+echo "</form>";
+
+include ("includes/footer.php");
+?>
+
diff --git a/www-ssl_old/admin/free.php b/www-ssl_old/admin/free.php
new file mode 100644
index 00000000..b45fadcf
--- /dev/null
+++ b/www-ssl_old/admin/free.php
@@ -0,0 +1,98 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Erzengel";
+$header = "Freie Engel";
+include ("includes/header.php");
+include ("includes/funktion_db_list.php");
+
+echo "Hallo " . $_SESSION['Nick'] . ",<br />\n";
+
+echo "<br /><br />\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:<br /><br />\n";
+
+#######################################################
+# Ermitteln freier Engel
+# 
+# auslesen aller Engel und dazugehoerige Schichten
+#######################################################
+
+// $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtplan ON User.UID=Schichtbelegung.UID, Schichtplan.SID LEFT JOIN Schichtbelegung.SID WHERE User.UID = Schichtbelegung.UID AND Schichtplan.SID = Schichtbelegung.SID AND Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick";
+
+/* geht nicht ??? unter stabel !!
+$SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung.* ".
+  "FROM Schichtplan, User LEFT OUTER ".
+  "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ".
+  "WHERE Schichtplan.SID = Schichtbelegung.SID AND ".
+    "Schichtplan.Date < now() and ".
+    "Schichtplan.EndDate > now() ".
+  "ORDER BY Nick";
+  
+$SQL =  "SELECT Shifts.*, ShiftEntry.*, User.Nick ".
+  "FROM User ".
+  "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ".
+  "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );";    
+*/
+$SQL = "SELECT Shifts.*, ShiftEntry.* " .
+"FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID " .
+"WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND  ShiftEntry.UID>0);";
+
+//SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID, Schichtplan LEFT JOIN Schichtbelegung ON Schichtplan.SID = Schichtbelegung.SID WHERE Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick
+
+//echo "<pre>$SQL</pre>"; 
+
+$Erg = mysql_query($SQL, $con);
+$Zeilen = mysql_num_rows($Erg);
+
+// for ($i = 1; $i < mysql_num_fields($Erg); $i++)
+//  echo "|".mysql_field_name($Erg, $i);
+
+echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+echo "\t<tr class=\"contenttopic\">\n";
+echo "\t\t<td>Nick</td>\n";
+echo "\t\t<td>Schicht</td>\n";
+echo "\t\t<td>Ort</td>\n";
+echo "\t\t<td>Von</td>\n";
+echo "\t\t<td>Bis</td>\n";
+echo "\t</tr>\n";
+
+$inuse = "";
+for ($i = 0; $i < $Zeilen; $i++) {
+	echo "<tr class=\"content\">\n";
+	echo "<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=" . mysql_result($Erg, $i, "UID") . "\">" .
+	UID2Nick(mysql_result($Erg, $i, "UID")) . "</td></a>\n";
+	echo "<td></td>\n";
+	echo "<td>" . mysql_result($Erg, $i, "RID") . "</td>\n";
+	echo "<td>" . mysql_result($Erg, $i, "DateS") . "</td>\n";
+	echo "<td>" . mysql_result($Erg, $i, "DateE") . "</td>\n";
+	echo "</tr>\n";
+
+	if ($inuse != "")
+		$inuse .= " OR ";
+	$inuse .= "(Nick = \"" . UID2Nick(mysql_result($Erg, $i, "UID")) . "\")";
+}
+if ($inuse != "")
+	$inuse = " WHERE NOT (" .
+	$inuse . ")";
+echo "</table>\n";
+
+//##########################################################################################################
+
+echo "<br /><br />\n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:<br /><br />\n";
+echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\"\>\n";
+echo "\t<tr class=\"contenttopic\">\n\t\t<td>Nick</td>\n\t\t<td>DECT</td>\n\t</tr>\n";
+
+$SQL = "SELECT Nick, UID, DECT FROM User" . $inuse . ";";
+$Erg = mysql_query($SQL, $con);
+$Zeilen = mysql_num_rows($Erg);
+for ($i = 0; $i < $Zeilen; $i++) {
+	echo "\t<tr class=\"content\">\n";
+	echo "\t\t<td><a href=\"./userChangeNormal.php?Type=Normal&enterUID=" . mysql_result($Erg, $i, "UID") . "\">" .
+	mysql_result($Erg, $i, "Nick") . "</a></td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "DECT") . "</td>\n";
+	echo "\n</tr>\n";
+}
+echo "</table>\n";
+
+include ("includes/footer.php");
+?>
+
diff --git a/www-ssl_old/admin/free_DECT.php b/www-ssl_old/admin/free_DECT.php
new file mode 100644
index 00000000..4b4e3085
--- /dev/null
+++ b/www-ssl_old/admin/free_DECT.php
@@ -0,0 +1,65 @@
+<?php
+require_once ('../bootstrap.php');
+
+include ("config/config_db.php");
+include ("includes/funktion_db_list.php");
+include ("includes/funktion_user.php");
+
+#######################################################
+# Ermitteln freier Engel
+# 
+# auslesen aller Engel und dazugehoerige Schichten
+#######################################################
+
+$SQL = "SELECT Shifts.*, ShiftEntry.* " .
+"FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID " .
+"WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND  ShiftEntry.UID>0);";
+
+$Erg = mysql_query($SQL, $con);
+$Zeilen = mysql_num_rows($Erg);
+
+$inuse = "";
+for ($i = 0; $i < $Zeilen; $i++) {
+	if ($inuse != "")
+		$inuse .= " OR ";
+	$inuse .= "(UID = \"" . mysql_result($Erg, $i, "UID") . "\")";
+}
+if ($inuse != "") {
+	$inuse = " WHERE (NOT (" . $inuse . ")) AND (DECT!='')";
+} else {
+	$inuse = " WHERE (DECT!='')";
+}
+
+//##########################################################################################################
+
+$SQL = "SELECT * FROM User" . $inuse . ";";
+$Erg = mysql_query($SQL, $con);
+$Zeilen = mysql_num_rows($Erg);
+for ($i = 0; $i < $Zeilen; $i++) {
+	// get DECT number
+	echo mysql_result($Erg, $i, "DECT") . "\t";
+
+	// get all user rights
+	$SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=" . mysql_result($Erg, $i, "UID") . ";";
+	$Erg_RIGHT = mysql_query($SQL_RIGHT, $con);
+	$UserRights = mysql_fetch_array($Erg_RIGHT);
+
+	foreach ($UserRights as $Var => $Value) {
+		if ((strpos($Var, ".php") === false) AND (strpos($Var, "/") === false) AND (strpos($Var, "UID") === false) AND (is_numeric($Var) === false)) {
+			echo "\"" . $Var . "\"=" . $Value . "\t";
+		}
+	}
+
+	// get shift types
+	$SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=" . mysql_result($Erg, $i, "UID") . " GROUP BY TID;";
+	$Erg_TYPES = mysql_query($SQL_TYPES, $con);
+	$Zeilen_Typen = mysql_num_rows($Erg_TYPES);
+	for ($j = 0; $j < $Zeilen_Typen; $j++) {
+		echo "\"TID_" . TID2Type(mysql_result($Erg_TYPES, $j, "TID")) . "\"=Y\t";
+	}
+
+	echo "\n";
+	//  echo "<br />";
+}
+?>
+
diff --git a/www-ssl_old/admin/room.php b/www-ssl_old/admin/room.php
new file mode 100755
index 00000000..4854acb6
--- /dev/null
+++ b/www-ssl_old/admin/room.php
@@ -0,0 +1,199 @@
+<?php
+$title = "R&auml;ume";
+$header = "Verwaltung der R&auml;ume";
+include ("../../includes/header.php");
+include ("../../includes/funktion_schichtplan_array.php");
+
+$Sql = "SELECT * FROM `Room` ORDER BY `Number`, `Name`";
+$Erg = mysql_query($Sql, $con);
+
+if( !IsSet($_GET["action"]) )
+{
+	echo "Hallo ".$_SESSION['Nick'].
+		",<br>\nhier hast du die M&ouml;glichkeit, neue R&auml;ume f&uuml;r die Schichtpl&auml;ne einzutragen ".
+		"oder vorhandene abzu&auml;ndern:<br><br>\n";
+
+	echo "<a href=\"./room.php?action=new\">- Neuen Raum/Ort eintragen</a><br>\n";
+	
+	echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+	echo "<tr class=\"contenttopic\">\n";
+
+	for( $i = 1; $i < mysql_num_fields($Erg); $i++ )
+	{
+		if( substr( mysql_field_name($Erg, $i), 0, 12) == "DEFAULT_EID_")
+			echo "\t<td> Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $i), 12)]. "</td>";
+		else
+			echo "\t<td>". mysql_field_name($Erg, $i)."</td>";
+	}
+	echo "\t<td>&Auml;ndern</td>";
+	echo "</tr>";
+
+	for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) 
+	{	
+		echo "\t<tr class=\"content\">\n";
+		for ($j = 1; $j < mysql_num_fields($Erg); $j++) 
+		{
+  			echo "\t\t<td>".mysql_result($Erg, $t, $j)."</td>\n";
+		}
+		echo "\t\t<td><a href=\"./room.php?action=change&RID=".mysql_result($Erg, $t, "RID")."\">###</a></td>\n";
+		echo "\t</tr>\n";
+	} // ende Auflistung Raeume
+	echo "</table>";
+} 
+else 
+{
+
+UnSet($SQL);
+
+switch ($_GET["action"]) {
+
+case 'new':
+	echo "Neuen Raum einrichten: <br>";
+	echo "<form action=\"./room.php\" method=\"GET\">\n";
+	echo "<table>\n";
+	
+	for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ )
+	{
+		if( (mysql_field_name($Erg, $Uj) == "show") || (mysql_field_name($Erg, $Uj) == "FromPentabarf") )
+		{
+			echo "<tr><td>". mysql_field_name($Erg, $Uj). "</td>".
+			     "<td>".
+			     "<input type=\"radio\" name=\"". mysql_field_name($Erg, $Uj). "\" value=\"Y\">Yes".
+			     "<input type=\"radio\" name=\"". mysql_field_name($Erg, $Uj). "\" value=\"N\">No".
+			     "</td></tr>\n";
+		}
+		else
+		{
+			//sonderfall fuer Default Engel 
+			if( substr( mysql_field_name($Erg, $Uj), 0, 12) == "DEFAULT_EID_")
+				$FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $Uj), 12)];
+			else
+				$FeldName = mysql_field_name($Erg, $Uj);
+		
+			echo "<td>$FeldName</td>".
+		        	"<td><input type=\"text\" size=\"40\" name=\"".mysql_field_name($Erg, $Uj)."\">";
+			echo "</td></tr>\n";
+		}
+	}
+	echo "</table>\n";
+	echo "<input type=\"hidden\" name=\"action\" value=\"newsave\">\n";
+	echo "<input type=\"submit\" value=\"sichern...\">\n";
+	echo "</form>";
+	break;
+
+case 'newsave':
+	$vars = $_GET;
+	$count = count($vars) - 1;
+	$vars = array_splice($vars, 0, $count);
+	$Keys = "";
+	$Values = "";
+	foreach($vars as $key => $value)
+	{
+		$Keys   .= ", `$key`";
+		$Values .= ", '$value'";
+	}
+	$SQL  = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")";
+	SetHeaderGo2Back();
+	break;
+
+case 'change':
+	if (! IsSet($_GET["RID"])) 
+		echo "Fehlerhafter Aufruf!"; 
+	else
+	{
+		$SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'";
+		$ERG = mysql_query($SQL2, $con);
+		
+		if( mysql_num_rows( $ERG)>0)
+		{
+			echo "Raum ab&auml;ndern:\n";
+			echo "Hier kannst du eintragen, welche und wieviele Engel f&uuml;r den Raum zur Verf?gung stehen m&uuml;ssen.";	
+			echo "<form action=\"./room.php\" method=\"GET\">\n";
+			echo "<table>\n";
+		
+			for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++)
+			{
+				if( (mysql_field_name($ERG, $Uj) == "show") || (mysql_field_name($ERG, $Uj) == "FromPentabarf") )
+				{
+					echo "<tr><td>". mysql_field_name($Erg, $Uj). "</td>".
+					     "<td>".
+					     "<input type=\"radio\" name=\"e". mysql_field_name($ERG, $Uj). 
+					     	"\" value=\"Y\"". (mysql_result($ERG, 0, $Uj)=='Y'? " checked":""). ">Yes".
+					     "<input type=\"radio\" name=\"e". mysql_field_name($ERG, $Uj). 
+					     	"\" value=\"N\"". (mysql_result($ERG, 0, $Uj)=='N'? " checked":""). ">No".
+					     "</td></tr>\n";
+				}
+				else
+				{
+					if( substr( mysql_field_name($ERG, $Uj), 0, 12) == "DEFAULT_EID_")
+						//sonderfall fuer Default Engel 
+						$FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($ERG, $Uj), 12)];
+					else
+						$FeldName = mysql_field_name($ERG, $Uj);
+					echo "<tr><td>$FeldName</td>".
+					     "<td><input type=\"text\" size=\"40\" name=\"e".mysql_field_name($ERG, $Uj)."\" ".
+					     "value=\"".mysql_result($ERG, 0, $Uj)."\">".
+					     "</td></tr>\n";
+				}
+			}
+			echo "</table>\n";
+			echo "<input type=\"hidden\" name=\"eRID\" value=\"". $_GET["RID"]. "\">\n";
+			echo "<input type=\"hidden\" name=\"action\" value=\"changesave\">\n";
+			echo "<input type=\"submit\" value=\"sichern...\">\n";
+			echo "</form>";
+			echo "<form action=\"./room.php\" method=\"GET\">\n";
+			echo "<input type=\"hidden\" name=\"RID\" value=\"". $_GET["RID"]. "\">\n";
+			echo "<input type=\"hidden\" name=\"action\" value=\"delete\">\n";
+			echo "<input type=\"submit\" value=\"L&ouml;schen...\">";
+			echo "</form>";
+		}
+		else
+			echo "FEHLER: Room ID ". $_GET["RID"]. " nicht gefunden";
+	}
+	break;
+	
+case 'changesave':
+	$sql="";
+		$vars = $_GET;
+		$count = count($vars) - 2;
+		$vars = array_splice($vars, 0, $count);
+		foreach($vars as $key => $value)
+		{
+	 		$keys = substr($key,1);
+			$sql .= ", `".$keys."`='".$value."' ";
+		}
+	$SQL = "UPDATE `Room` SET ". substr($sql, 2). " WHERE `RID`='". $_GET["eRID"]. "'";
+	SetHeaderGo2Back();
+	break;
+
+case 'delete':
+	if (IsSet($_GET["RID"])) {
+		$SQL="DELETE FROM `Room` WHERE `RID`='". $_GET["RID"]. "'";		
+	} else {
+		echo "Fehlerhafter Aufruf";
+	}
+	SetHeaderGo2Back();
+	break;
+
+} //switch
+
+
+// Update ???
+
+if (IsSet($SQL)){ 
+//	echo $SQL; 
+	// hier muesste das SQL ausgefuehrt werden...
+	$Erg = db_query($SQL, "exec SQL");
+	if ($Erg == 1) 
+	     echo "&Auml;nderung wurde gesichert...<br>";
+	else
+	{
+	     echo "Fehler beim speichern... bitte noch ein mal probieren :)";
+	     echo "<br><br>".mysql_error( $con ). "<br>($SQL)<br>";
+	}
+} // Ende Update								
+
+} //IF IsSet($action)
+
+include ("../../includes/footer.php");
+?>
diff --git a/www-ssl_old/admin/schichtplan.1.php b/www-ssl_old/admin/schichtplan.1.php
new file mode 100644
index 00000000..fe8c0384
--- /dev/null
+++ b/www-ssl_old/admin/schichtplan.1.php
@@ -0,0 +1,5 @@
+<h4>Schichtplan</h4>
+<ul class="content">
+<li><a href="./schichtplan.php">Ein-/Austragen</a></li>
+<li><a href="./schichtplan_druck.php">Druckversion</a></li>
+</ul>
\ No newline at end of file
diff --git a/www-ssl_old/admin/schichtplan.php b/www-ssl_old/admin/schichtplan.php
new file mode 100644
index 00000000..70ef5a6a
--- /dev/null
+++ b/www-ssl_old/admin/schichtplan.php
@@ -0,0 +1,362 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Schichtplan";
+$header = "Neue Schichten erfassen";
+$submenus = 1;
+include ("includes/header.php");
+
+function executeSQL($SQL) {
+	global $debug, $con;
+
+	$Erg = mysql_query($SQL, $con);
+	if ($debug)
+		echo "DEBUG SQL: $SQL<br />\n";
+	if ($Erg == 1) {
+		echo "SQL war erfolgreich";
+	} else {
+		echo "SQL Fehler (" . mysql_error($con) . ")";
+	}
+}
+
+if (!IsSet ($_GET["action"])) {
+	echo "Hallo " . $_SESSION['Nick'] . ",<br />\n";
+	echo "hier kannst du Schichten anlegen, &auml;ndern oder l&ouml;schen.<br /><br />";
+	echo "<a href=\"./shiftadd.php\">Neue Schicht einplanen</a><br /><br />\n\n";
+
+	echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >\n";
+?>
+<table width="100%" class="border" cellpadding="2" cellspacing="1">
+  <tr class="contenttopic">
+    <td></td>
+    <td>Datum</td>
+    <td>Raum</td>
+    <td>Dauer</td>
+    <td>&Auml;ndern</td>
+  </tr>
+<?php
+
+
+	$sql = "SELECT `SID`, `DateS`, `RID`, `Len` FROM `Shifts` " .
+	"ORDER BY `RID`, `DateS` ";
+	$Erg = mysql_query($sql, $con);
+	$rowcount = mysql_num_rows($Erg);
+	for ($i = 0; $i < $rowcount; $i++) {
+		echo "\t<tr class=\"content\">\n";
+		echo "\t\t<td><input type=\"checkbox\" name=\"SID" . mysql_result($Erg, $i, "SID") . "\" " .
+		"value=\"" . mysql_result($Erg, $i, "SID") . "\"></td>\n";
+		echo "\t\t<td>" . mysql_result($Erg, $i, "DateS") . "</td>\n";
+
+		$sql2 = "SELECT `Name` FROM `Room` WHERE `RID`='" . mysql_result($Erg, $i, "RID") . "'";
+		$Erg2 = mysql_query($sql2, $con);
+		if (mysql_num_rows($Erg2) > 0)
+			echo "\t\t<td>" . mysql_result($Erg2, 0, "Name") . "</td>\n";
+		else
+			echo "\t\t<td>Unbenkannt (RID=" . mysql_result($Erg, $i, "RID") . ")</td>\n";
+		echo "\t\t<td>" . mysql_result($Erg, $i, "Len") . " Std. </td>\n";
+		echo "\t\t<td><a href=\"./schichtplan.php?action=change&SID=" .
+		mysql_result($Erg, $i, "SID") . "\">####</a></td>\n";
+		echo "\t</tr>\n";
+	}
+	echo "</table>\n";
+
+	echo "<input type=\"hidden\" name=\"action\" value=\"deleteShifs\">\n";
+	echo "<input type=\"submit\" value=\"L&ouml;schen...\">\n";
+	echo "</form>\n";
+
+} else {
+
+	// aus sicherheitzgr�nden wegen sp�terer genuzung
+	UnSet ($chSQL);
+
+	switch ($_GET["action"]) {
+
+		case 'change' :
+			if (!IsSet ($_GET["SID"])) {
+				echo "Fehlerhafter Aufruf!\n";
+			} else {
+
+				$sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )";
+				$Erg = mysql_query($sql, $con);
+
+				echo "Schicht ab&auml;ndern: <br />\n";
+
+				// Anzeige Allgemeiner schaischt daten
+				echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >";
+				echo "<table>\n";
+				echo "  <tr><td>Schichtbeginn</td>" .
+				"<td><input value=\"" . mysql_result($Erg, 0, "DateS") .
+				"\" type=\"text\" size=\"40\" name=\"eDate\"></td></tr>\n";
+				echo "  <tr><td>Raum</td><td>\n<select name=\"eRID\">\n";
+
+				$sql2 = "SELECT `RID`, `Name`, `FromPentabarf` FROM `Room`";
+				$Erg2 = mysql_query($sql2, $con);
+				$rowcount = mysql_num_rows($Erg2);
+				$FromPentabarf = "N";
+				for ($i = 0; $i < $rowcount; $i++) {
+					$RID = mysql_result($Erg2, $i, "RID");
+					echo "   <option value=\"" . $RID . "\"";
+					if ($RID == mysql_result($Erg, 0, "RID")) {
+						echo " selected";
+						$FromPentabarf = mysql_result($Erg2, $i, "FromPentabarf");
+					}
+					echo ">" . mysql_result($Erg2, $i, "Name") . "</option>\n";
+				}
+				echo "  </select>\n</td></tr>\n";
+
+				echo "  <tr><td>Dauer in h</td>" .
+				"<td><input value=\"" . mysql_result($Erg, 0, "Len") .
+				"\" type=\"text\" size=\"40\" name=\"eDauer\"></td></tr>\n";
+				echo "  <tr><td>Beschreibung</td>" .
+				"<td><input value=\"" . mysql_result($Erg, 0, "Man") .
+				"\" type=\"text\" size=\"40\" name=\"eName\"></td></tr>\n";
+				echo "  <tr><td>URL</td>" .
+				"<td><input value=\"" . mysql_result($Erg, 0, "URL") .
+				"\" type=\"text\" size=\"40\" name=\"eURL\"></td></tr>\n";
+				if ($FromPentabarf == "Y") {
+					echo "  <tr><td></td>" .
+					"<td><h1>!!! Imported from Pentabarf !!!</h1></td></tr>\n";
+				}
+				echo "</table>\n";
+
+				echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n";
+				echo "<input type=\"hidden\" name=\"action\" value=\"changesave\">\n";
+				echo "<input type=\"submit\" value=\"sichern...\">\n";
+				echo "</form>\n\n";
+
+				// L�schen
+				echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >\n";
+				echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n";
+				echo "<input type=\"hidden\" name=\"action\" value=\"delete\">\n";
+				echo "<input type=\"submit\" value=\"L&ouml;schen...\">\n";
+				echo "</form>\n\n";
+
+				echo "<b>ACHTUNG:</b><br />\n";
+				echo "Beim L&ouml;schen werden die bisher eingetragenen Engel f&uuml;r diese Schicht mitgel&ouml;scht.<br />\n";
+
+				echo "<br /><hr>\n\n\n\n";
+
+				//Freie Engelschichten
+				$sql3 = "SELECT `TID` FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND `UID`='0'";
+				$Erg3 = mysql_query($sql3, $con);
+				$rowcount = mysql_num_rows($Erg3);
+
+				echo "Folgende Engelschichten sind noch nicht vergeben.\n";
+				echo "Und koenen, wenn diese nSchicht nicht benoetigt wird geloet werden:<br />\n";
+				for ($j = 0; $j < $rowcount; $j++) {
+					$TID = mysql_result($Erg3, $j, 0);
+					echo "<a href=\"./schichtplan.php?action=engelshiftdel&SID=" . $_GET["SID"] . "&TID=$TID\">" .
+					"freie " . TID2Type($TID) . Get_Text("inc_schicht_Engel") . "schicht loeschen</a><br />\n";
+				}
+				echo "<br /><hr>\n\n\n\n";
+
+				//Ausgabe eingetragener schischten
+				$sql3 = "SELECT * FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND NOT `UID`='0'";
+				$Erg3 = mysql_query($sql3, $con);
+				$rowcount = mysql_num_rows($Erg3);
+
+				echo "Folgende Engel Sind fuer die Schicht eingetargen.\n";
+				echo "Und koennen, wenn diese nicht zu Schicht erschienen sind ausgetragen werden:<br />\n";
+				echo "<table border=\"1\">\n" .
+				"<tr class=\"contenttopic\">" .
+				"<th>nick</th>" .
+				"<th>type</th>" .
+				"<th>normal</th>" .
+				"<th>freeloader :-(</th>" .
+				"</tr>";
+
+				for ($j = 0; $j < $rowcount; $j++) {
+					$userUID = mysql_result($Erg3, $j, "UID");
+					echo "\t<tr>\n";
+					echo "\t\t<td>" . UID2Nick($userUID) . "</td>\n";
+					echo "\t\t<td>" . TID2Type(mysql_result($Erg3, $j, "TID")) . Get_Text("inc_schicht_Engel") . "</td>\n";
+					echo "\t\t<td><a href=\"./schichtplan.php?action=engeldel&SID=" . $_GET["SID"] . "&UIDs=$userUID&freeloader=0\">###-austragen-###</a></td>\n";
+					echo "\t\t<td><a href=\"./schichtplan.php?action=engeldel&SID=" . $_GET["SID"] . "&UIDs=$userUID&freeloader=1\">###-austragen-freeloader-###</a></td>\n";
+					echo "\t</tr>\n";
+				} // FOR
+
+				echo "</table><br /><hr>\n\n\n\n";
+
+				//Nachtragen von Engeln
+				echo "Hat ein anderer Engel die Schicht &uuml;bernommen, trage ihn bitte ein:";
+				echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >\n";
+				echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n";
+				echo "<input type=\"hidden\" name=\"action\" value=\"engeladd\">\n";
+
+				// Listet alle Nicks auf
+				echo "<select name=\"UIDs\">\n";
+				if ($FromPentabarf != "Y") {
+					echo "\t<option value=\"0\">--neu--</option>\n";
+				}
+
+				$usql = "SELECT * FROM `User` ORDER BY `Nick`";
+				$uErg = mysql_query($usql, $con);
+				$urowcount = mysql_num_rows($uErg);
+				for ($k = 0; $k < $urowcount; $k++) {
+					echo "\t<option value=\"" . mysql_result($uErg, $k, "UID") . "\">" .
+					mysql_result($uErg, $k, "Nick") .
+					"</option>\n";
+				}
+				echo "</select>\n";
+
+				echo " als \n";
+
+				// holt eine liste der ben�tigten Engel zu dieser Schischt
+				$sql3 = "SELECT Count(`TID`) AS `CTID`, `TID` FROM `ShiftEntry` ";
+				$sql3 .= "WHERE (`SID`='" . $_GET["SID"] . "' AND `UID`='0') ";
+				$sql3 .= "GROUP BY `SID`, `TID`, `UID` ";
+				$Erg3 = mysql_query($sql3, $con);
+				$i = -1;
+				while (++ $i < mysql_num_rows($Erg3)) {
+					$EngelNeed[mysql_result($Erg3, $i, "TID")] = mysql_result($Erg3, $i, "CTID");
+				}
+
+				// Gibt dei m�glich Engeltypen aus und zeigt w�efiel noch be�tigt werden
+				echo "<select name=\"TID\">\n";
+				$SQL2 = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`";
+				$Erg2 = mysql_query($SQL2, $con);
+				for ($l = 0; $l < mysql_num_rows($Erg2); $l++) {
+					$EngelTID = mysql_result($Erg2, $l, "TID");
+					echo "<option value=\"$EngelTID\">";
+					echo mysql_result($Erg2, $l, "Name") . Get_Text("inc_schicht_engel");
+					if (!isset ($EngelNeed[$EngelTID]))
+						echo " (0)";
+					else
+						echo " (" . $EngelNeed[$EngelTID] . ")";
+					echo "</option>\n";
+				}
+				echo "</select>\n";
+
+				echo "<input type=\"submit\" value=\"eintragen...\">\n";
+
+				echo "<br />\n<input value=\"1\" type=\"text\" size=\"5\" name=\"eAnzahlNew\"> Anzahl New\n";
+
+				echo "</form>";
+
+			} // IF ISSET(
+			break;
+
+		case 'engeladd' :
+			if ($_GET["UIDs"] > 0) {
+
+				$SQL = "SELECT * FROM `ShiftEntry` " .
+				"WHERE (`SID`='" . $_GET["SID"] . "' AND `TID`='" . $_GET["TID"] . "' AND `UID`='0')";
+				$ERG = mysql_query($SQL, $con);
+				if (mysql_num_rows($ERG) != 0) {
+					$chSQL = "UPDATE `ShiftEntry` SET " .
+					"`UID`='" . $_GET["UIDs"] . "', `Comment`='shift added by " . $_SESSION['Nick'] . "' " .
+					"WHERE (`SID`='" . $_GET["SID"] . "' AND " .
+					"`TID`='" . $_GET["TID"] . "' AND `UID`='0' ) LIMIT 1";
+				} else {
+					$chSQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (" .
+					"'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', " .
+					"'" . $_GET["UIDs"] . "', 'shift added by " . $_SESSION['Nick'] . "')";
+				}
+				echo "Es wird folgende Schicht zus&auml;tzlich eingetragen:<br />\n";
+				echo "Engel: " . UID2Nick($_GET["UIDs"]) . "<br />\n";
+				echo "Bemerkung: Schicht eingetragen durch Erzengel " . $_SESSION['Nick'] . "<br />\n<br />\n";
+			} else {
+				echo "Es wird folgende Schicht wurde " . $_GET["eAnzahlNew"] . "x zus&auml;tzlich eingetragen:<br />\n";
+				for ($i = 0; $i < $_GET["eAnzahlNew"]; $i++) {
+					echo "$i. <br />\n";
+					$SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (";
+					$SQL .= "'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', '0', NULL)";
+					$ERG = mysql_query($SQL, $con);
+					if ($debug)
+						echo "DEBUG SQL: $SQL<br />\n";
+					if ($ERG == 1) {
+						echo "&Auml;nderung wurde gesichert...<br />";
+					} else {
+						echo "Fehler beim speichern... bitte noch ein mal probieren :)<br />";
+						echo mysql_error($con);
+					}
+					echo "Es wird eine weitere Schicht eingetragen:<br /><br />\n";
+				}
+			}
+			break;
+
+		case 'engeldel' :
+			$chSQL = "UPDATE `ShiftEntry` SET `UID`='0', `Comment`= 'NULL' WHERE (`SID`='" . $_GET["SID"] .
+			"' AND `UID`='" . $_GET["UIDs"] . "') LIMIT 1";
+			if (isset ($_GET["freeloader"]) && $_GET["freeloader"] == 1) {
+				$sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )";
+				$Erg = mysql_query($sql, $con);
+				if (mysql_num_rows($Erg) == 1) {
+					$UID = $_GET["UIDs"];
+					$Length = mysql_result($Erg, 0, "Len");
+					$Comment = "Start: " . mysql_result($Erg, 0, "DateS") . "; " .
+					"Beschreibung: " . mysql_result($Erg, 0, "Man") . "; " .
+					"Removed by " . $_SESSION['Nick'];
+					$ch2SQL = "INSERT INTO `ShiftFreeloader` (`Remove_Time`, `UID`, `Length`, `Comment`) " .
+					"VALUES ( CURRENT_TIMESTAMP, '$UID', '$Length', '$Comment');";
+				}
+			}
+			break;
+
+		case 'engelshiftdel' :
+			$chSQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND `TID`='" .
+			$_GET["TID"] . "' AND `UID`='0' LIMIT 1";
+			break;
+
+		case 'changesave' :
+			$query = mysql_query("SELECT DATE_ADD('" . $_GET["eDate"] . "', INTERVAL '+0 " . $_GET["eDauer"] . "' DAY_HOUR)", $con);
+			$enddate = mysql_fetch_row($query);
+
+			$chSQL = "UPDATE `Shifts` SET " .
+			"`DateS`='" . $_GET["eDate"] . "', " .
+			"`DateE`='" . $enddate[0] . "', " .
+			"`RID`='" . $_GET["eRID"] . "', " .
+			"`Len`='" . $_GET["eDauer"] . "', " .
+			"`Man`='" . $_GET["eName"] . "', " .
+			"`URL`='" . $_GET["eURL"] . "' " .
+			"WHERE `SID`='" . $_GET["SID"] . "'";
+			SetHeaderGo2Back();
+			break;
+
+		case 'delete' :
+			$chSQL = "DELETE FROM `Shifts` WHERE `SID`='" . $_GET["SID"] . "' LIMIT 1";
+			$ch2SQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "'";
+			SetHeaderGo2Back();
+			break;
+
+		case 'deleteShifs' :
+			foreach ($_GET as $k => $v)
+				if (strpos(" " . $k, "SID") == 1) {
+					echo "Shifts $v wird gel�scht...";
+					executeSQL("DELETE FROM `Shifts` WHERE `SID`='$v' LIMIT 1");
+					echo "<br />\n";
+					echo "ShiftEntry $v wird gel�scht...";
+					executeSQL("DELETE FROM `ShiftEntry` WHERE `SID`='$v'");
+					echo "<br /><br />\n";
+				}
+			break;
+
+	} // end switch
+
+	if (IsSet ($chSQL)) {
+		//     echo $chSQL;
+		// hier muesste das SQL ausgefuehrt werden...
+		$Erg = mysql_query($chSQL, $con);
+		if ($debug)
+			echo "DEBUG SQL: $chSQL<br />\n";
+		if ($Erg == 1) {
+			echo "&Auml;nderung wurde gesichert...<br />";
+			if ($debug)
+				echo "DEBUG: ergebniss" . $Erg . "<br />\n";
+			if (IsSet ($ch2SQL)) {
+				$Erg = mysql_query($ch2SQL, $con);
+				if ($debug)
+					echo "DEBUG SQL: $ch2SQL<br />\n";
+				if ($debug)
+					echo "DEBUG: ergebniss" . $Erg . "<br />\n";
+			}
+		} else {
+			echo "Fehler beim speichern... bitte noch ein mal probieren :)<br />";
+			echo mysql_error($con);
+		}
+	} // Ende Update
+
+}
+
+include ("includes/footer.php");
+?>
diff --git a/www-ssl_old/admin/schichtplan_druck.1.php b/www-ssl_old/admin/schichtplan_druck.1.php
new file mode 100644
index 00000000..30761390
--- /dev/null
+++ b/www-ssl_old/admin/schichtplan_druck.1.php
@@ -0,0 +1,5 @@
+<h4 class="menu"> Schichtplan </h4>
+
+<li><a href="./schichtplan.php">Ein-/Austragen</a></li>
+<li><a href="./schichtplan_druck.php">Druckversion</a></li>
+
diff --git a/www-ssl_old/admin/schichtplan_druck.php b/www-ssl_old/admin/schichtplan_druck.php
new file mode 100644
index 00000000..3e856c5e
--- /dev/null
+++ b/www-ssl_old/admin/schichtplan_druck.php
@@ -0,0 +1,119 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "Schichtpl&auml;ne";
+$submenus = 1;
+
+if (!IsSet ($_GET["action"])) {
+	include ("includes/header.php");
+	include ("includes/funktionen.php");
+	include ("includes/funktion_schichtplan_aray.php");
+	include ("includes/funktion_schichtplan.php");
+
+	echo "Hallo " . $_SESSION['Nick'] . "<br />\n" .
+	"auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. W&auml;hle hierf&uuml;r ein Datum und den Raum:\n" .
+	"<br />\n";
+
+	foreach ($VeranstaltungsTage as $k => $v) {
+
+		$res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY `Name`;", $con);
+		for ($i = 0; $i < mysql_num_rows($res); $i++) {
+			$Tag = $VeranstaltungsTage[$k];
+			$RID = mysql_result($res, $i, "RID");
+			$Rname = mysql_result($res, $i, "Name");
+			echo "\t<a href=\"./schichtplan_druck.php?action=1&Raum=$RID&ausdatum=$Tag\" target=\"_blank\">$Tag $Rname</a><br />\n";
+		}
+		echo "<br />\n";
+	}
+	echo "<br /><br />";
+
+	include ("includes/footer.php");
+} else //#################################################################
+	{
+	if (IsSet ($_GET["Raum"]) AND IsSet ($_GET["ausdatum"])) {
+		$Raum = $_GET["Raum"];
+		$ausdatum = $_GET["ausdatum"];
+
+		include ("config/config_db.php");
+		include ("config/config.php");
+		include ("includes/secure.php");
+		//var wird nur gesetzt immer edit auszublenden, achtung sesion darf nicht gestart sein !!!
+		$_SESSION['CVS']["admin/schichtplan.php"] = "N";
+		include ("includes/funktion_lang.php");
+		include ("includes/funktion_schichtplan.php");
+		include ("includes/funktion_schichtplan_aray.php");
+		include ("includes/funktion_user.php");
+?>
+
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+<title>Schichtplan</title>
+<meta name="keywords" content="Engel, Himmelsverwaltung">
+<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
+<meta http-equiv="Content-Style-Type" content="text/css">
+<meta http-equiv="expires" content="0">
+<meta name="robots" content="index">
+<meta name="revisit-after" content="1 days">
+<meta http-equiv="content-language" content="de">
+</head>
+<body>
+
+<h1>Schichtplan</h1>
+
+<table>
+  <tr>
+    <td width="250" align="left">
+      <span style="font-weight:bold;font-size:100%">Datum:</span> 
+      <span style="font-weight:bold;font-size:200%"><?php echo $ausdatum; ?></span>
+    </td>
+    <td width="350" align="right">
+      <span style="font-weight:bold;font-size:100%">Raum:</span>
+      <span style="font-weight:bold;font-size:200%"><?php echo $RoomID[$Raum]; ?> </span>
+    </td>
+  </tr>
+</table>
+
+<table border="2" width="650" class="border" cellpadding="2" cellspacing="1">
+ 
+<!--Ausgabe Spalten �berschrift-->
+
+  <tr class="contenttopic">
+    <th bgcolor="#E0E0E0">Uhrzeit</th>
+    <th bgcolor="#E0E0E0">Schichtplanbelegung</th>
+  </tr>
+<?php
+
+
+		//Zeit Ausgeben
+		for ($i = 0; $i < 24; $i++)
+			for ($j = 0; $j < $GlobalZeileProStunde; $j++) {
+				$Spalten[$i * $GlobalZeileProStunde + $j] = "\t<tr class=\"content\">\n";
+				if ($j == 0) {
+					$Spalten[$i * $GlobalZeileProStunde + $j] .= "\t\t<td rowspan=\"$GlobalZeileProStunde\">";
+					if ($i < 10)
+						$Spalten[$i * $GlobalZeileProStunde + $j] .= "0";
+					$Spalten[$i * $GlobalZeileProStunde + $j] .= "$i:";
+					if ((($j * 60) / $GlobalZeileProStunde) < 10)
+						$Spalten[$i * $GlobalZeileProStunde + $j] .= "0";
+					$Spalten[$i * $GlobalZeileProStunde + $j] .= (($j * 60) / $GlobalZeileProStunde) . "</td>\n";
+
+				}
+			}
+
+		CreateRoomShifts($Raum);
+
+		// Ausgabe Zeilen
+		for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++)
+			echo $Spalten[$i];
+		// Ende
+		echo "</table>\n";
+
+		echo "Stand: " . gmdate("Y-m-d H:i") . "\n";
+		echo "</body>\n";
+		echo "</html>\n";
+
+	} //isset($Vars)
+} //isset($Action)
+?>
diff --git a/www-ssl_old/admin/shiftadd.php b/www-ssl_old/admin/shiftadd.php
new file mode 100644
index 00000000..d6b1f8ff
--- /dev/null
+++ b/www-ssl_old/admin/shiftadd.php
@@ -0,0 +1,350 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Schicht Hinzufügen";
+$header = "Neue Schichten erfassen";
+
+include ("includes/header.php");
+
+$Time = time() + 3600 + 3600;
+
+echo "Hallo " . $_SESSION['Nick'] . ",<br />\n";
+
+// erstellt ein Array der Reume
+$sql = "SELECT `RID`, `Name` FROM `Room` ORDER BY `Name`";
+$Erg = mysql_query($sql, $con);
+$rowcount = mysql_num_rows($Erg);
+
+for ($i = 0; $i < $rowcount; $i++) {
+	$Room[$i]["RID"] = mysql_result($Erg, $i, "RID");
+	$Room[$i]["Name"] = mysql_result($Erg, $i, "Name");
+}
+
+// erstellt ein Aray der Engeltypen
+$sql = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`";
+$Erg = mysql_query($sql, $con);
+$rowcount = mysql_num_rows($Erg);
+
+for ($i = 0; $i < $rowcount; $i++) {
+	$EngelType[$i]["TID"] = mysql_result($Erg, $i, "TID");
+	$EngelType[$i]["Name"] = mysql_result($Erg, $i, "Name") . Get_Text("inc_schicht_engel");
+}
+
+// sesion mit stanadrt werten bef�llen
+if (!isset ($_SESSION['shiftadd.php']['SchichtName'])) {
+	$_SESSION['shiftadd.php']['SchichtName'] = "--???--";
+	$_SESSION['shiftadd.php']['RID'] = "";
+	$_SESSION['shiftadd.php']['MonthJahr'] = gmdate("Y-m", $Time);
+	$_SESSION['shiftadd.php']['SDatum'] = gmdate("d", $Time);
+	$_SESSION['shiftadd.php']['STime'] = "10";
+	$_SESSION['shiftadd.php']['MoreThenOne'] = "ON";
+	$_SESSION['shiftadd.php']['EDatum'] = gmdate("d", $Time);
+	$_SESSION['shiftadd.php']['ETime'] = "12";
+	$_SESSION['shiftadd.php']['len'] = "2";
+	$_SESSION['shiftadd.php']['NachtON'] = "OFF";
+	$_SESSION['shiftadd.php']['len_night'] = "00-04-08-10-12-14-16-18-20-22-24";
+}
+// wenn werte �bergeben in sesion eintragen
+if (!isset ($_GET["NachtON"]))
+	$_GET["NachtON"] = "OFF";
+if (!isset ($_GET["MoreThenOne"]))
+	$_GET["MoreThenOne"] = "OFF";
+if (isset ($_GET["SchichtName"])) {
+	foreach ($_GET as $k => $v) {
+		$_SESSION['shiftadd.php'][$k] = $v;
+	}
+}
+
+if (!IsSet ($_GET["action"]))
+	$_GET["action"] = "new";
+
+switch ($_GET["action"]) {
+	case 'new' :
+?>
+Hier kannst du neue Schichten eintragen. Dazu musst du den Anfang und das Ende der Schichten eintragen.
+&Uuml;ber die L&auml;nge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch k&ouml;nnen gleich
+mehrere Schichten auf einmal erfasst werden:
+
+<form action="<?php echo $_SERVER['SCRIPT_NAME']; ?>" >
+  <table>
+  <tr>
+    <td align="right">Name:</td>
+    <td><input type="text" name="SchichtName" size="50" value="<?php echo $_SESSION["shiftadd.php"]["SchichtName"]; ?>"></td>
+  </tr>
+  <tr>
+    <td align="right">Ort:</td>
+    <td><select name="RID">
+<?php
+
+
+		foreach ($Room As $RTemp) {
+			echo "\t<option value=\"" . $RTemp["RID"] . "\"";
+			if ($RTemp["RID"] == $_SESSION["shiftadd.php"]["RID"])
+				echo " SELECTED";
+			echo ">" . $RTemp["Name"] . "</option>\n";
+		}
+?>
+    </select></td>
+  </tr>
+  
+  <tr><td><u>Zeit:</u></td></tr>
+  <tr>
+    <td align="right">Month.Jahr:</td>
+    <td><input type="ext" name="MonthJahr" size="7" value="<?php echo $_SESSION["shiftadd.php"]["MonthJahr"]; ?>"></td>
+  </tr>
+  <tr>
+    <td align="right">Beginn:</td>
+    <td>Date<input type="text" name="SDatum" size="5" value="<?php echo $_SESSION["shiftadd.php"]["SDatum"]; ?>">
+        Time<input type="text" name="STime" size="5" value="<?php echo $_SESSION["shiftadd.php"]["STime"]; ?>"></td>
+  </tr>
+  <tr>
+    <td align="right">More then One</td>
+    <td><input type="checkbox" name="MoreThenOne" value="ON" <?php
+
+
+		if ($_SESSION["shiftadd.php"]["MoreThenOne"] == "ON")
+			echo " CHECKED";
+?>></td>
+  </tr>
+  <tr>
+    <td align="right">End:</td>
+    <td>Date<input type="text" name="EDatum" size="5" value="<?php echo $_SESSION["shiftadd.php"]["EDatum"]; ?>">
+        Time<input type="text" name="ETime" size="5" value="<?php echo $_SESSION["shiftadd.php"]["ETime"]; ?>"></td>
+  </tr>
+  <tr>
+    <td align="right">L&auml;nge in h:</td>
+    <td><input type="text" name="len" size="5" value="<?php echo $_SESSION["shiftadd.php"]["len"]; ?>"></td>
+  </tr>
+  <tr>
+    <td align="right">Sonderschichten ein:</td>
+    <td><input type="checkbox" name="NachtON" value="ON" <?php
+
+
+		if ($_SESSION["shiftadd.php"]["NachtON"] == "ON")
+			echo " CHECKED";
+?>></td>
+  </tr>
+  <tr>
+    <td align="right">Sonder in h (Time;Time):</td>
+    <td><input type="text" name="len_night" size="50" value="<?php echo $_SESSION["shiftadd.php"]["len_night"]; ?>"></td>
+  </tr>
+  
+  <tr><td><u>Anzahl Engel je Type:</u></td></tr>
+<?php
+
+
+		foreach ($EngelType As $TTemp) {
+			echo "  <tr><td align=\"right\">" . $TTemp["Name"] . ":</td>\n";
+			echo "      <td><input type=\"text\" name=\"EngelType" . $TTemp["TID"] . "\" size=\"5\" value=\"";
+			if (isset ($_SESSION["shiftadd.php"]["EngelType" . $TTemp["TID"]]))
+				echo $_SESSION["shiftadd.php"]["EngelType" . $TTemp["TID"]];
+			else
+				echo "0";
+			echo "\"></td>\n";
+		}
+?>
+</table>
+ <br />
+<input type="hidden" name="OnlyShow" value="ON">
+<input type="hidden" name="action" value="newsave">
+<input type="submit" value="zeig mal Gabriel!">
+</form>
+
+<?php
+
+
+		break; // Ende new
+
+	case 'newsave' :
+		if (isset ($_GET["SDatum"]) && ($_GET["len"] > 0)) {
+			$lenOrg = $_GET["len"];
+			if ($_GET["NachtON"] == "ON") {
+				$lenArrayDummy = explode("-", $_GET["len_night"]);
+				foreach ($lenArrayDummy as $Temp) {
+					if (isset ($Temp2))
+						$lenArray[intval($Temp2)] = intval($Temp) - intval($Temp2);
+					$Temp2 = $Temp;
+				} //foreach
+			} //IF( $NachtON == "ON" )
+
+			echo "<table border=\"1\">\n";
+			echo "<tr>\n";
+			echo "\t<td valign=\"top\" align=\"center\">Start</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">End</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">len</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">RID</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">Beschreibung</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">Entry 'Shifts'</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">SID</td>\n";
+			echo "\t<td valign=\"top\" align=\"center\">Entrys</td>\n";
+			echo "</tr>\n";
+
+			$DateEnd = $_GET["SDatum"];
+			$TimeEnd = intval($_GET["STime"]);
+			$len = 0;
+			do {
+				// define Start time
+				$Date = $DateEnd;
+				$Time = $TimeEnd;
+				$_DateS = $_GET["MonthJahr"] . "-" . $Date . " " . $Time . ":00:00";
+
+				// define End time
+				if ($_GET["NachtON"] == "ON") {
+					if (!isset ($lenArray[$Time]))
+						die("Zeit $Time h nicht definiert.");
+					$_GET["len"] = $lenArray[$Time];
+					if ($_GET["len"] < 1)
+						die("len <1");
+				}
+				$TimeEnd = $Time + $_GET["len"];
+
+				//Tages�berschreitung
+				while ($TimeEnd >= 24) {
+					$TimeEnd -= 24;
+					$DateEnd += 1;
+				}
+				//ist schischt zu lang dan verk�rzen
+				if ($DateEnd > $_GET["EDatum"] || ($DateEnd == $_GET["EDatum"] && $TimeEnd >= $_GET["ETime"])) {
+					$_GET["len"] -= ($DateEnd - $_GET["EDatum"]) * 24;
+					$_GET["len"] -= ($TimeEnd - $_GET["ETime"]); // -(-) ->> +
+					$DateEnd = $_GET["EDatum"];
+					$TimeEnd = $_GET["ETime"];
+				}
+				$_DateE = $_GET["MonthJahr"] . "-" . $DateEnd . " " . $TimeEnd . ":00:00";
+
+				if ($_DateS != $_DateE)
+					CreateNewEntry();
+
+				if ($_GET["MoreThenOne"] != "ON")
+					break;
+				if ($DateEnd >= $_GET["EDatum"] && $TimeEnd >= intval($_GET["ETime"]))
+					break;
+			}
+			while (true);
+			echo "</table>";
+
+			if ($_GET["OnlyShow"] == "ON") {
+				echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\">";
+				echo "\n\t<Input type=\"hidden\" name=\"SchichtName\" value=\"" . $_GET["SchichtName"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"MonthJahr\" value=\"" . $_GET["MonthJahr"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"SDatum\" value=\"" . $_GET["SDatum"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"STime\" value=\"" . $_GET["STime"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"MoreThenOne\" value=\"" . $_GET["MoreThenOne"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"EDatum\" value=\"" . $_GET["EDatum"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"ETime\" value=\"" . $_GET["ETime"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"len\" value=\"" . $lenOrg . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"RID\" value=\"" . $_GET["RID"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"NachtON\" value=\"" . $_GET["NachtON"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"len_night\" value=\"" . $_GET["len_night"] . "\">";
+				echo "\n\t<input type=\"hidden\" name=\"OnlyShow\" value=\"OFF\">";
+				foreach ($EngelType As $TTemp) {
+					$Temp = "EngelType" . $TTemp["TID"];
+					echo "\n\t<input type=\"hidden\" name=\"" . $Temp . "\" value=\"" . $_GET[$Temp] . "\">";
+				}
+				echo "\n\t<input type=\"hidden\" name=\"action\" value=\"newsave\">";
+				echo "\n\t<input type=\"submit\" value=\"mach mal Gabriel!\">";
+				echo "\n</form>";
+			} //if
+		} //IF
+		break;
+
+	case 'engeldel' :
+		break;
+
+} // end switch
+
+function CreateNewEntry() {
+	global $con, $_DateS, $_DateE, $EngelType, $debug;
+	foreach ($EngelType As $TTemp) {
+		$Temp = "EngelType" . $TTemp["TID"];
+		global $$Temp;
+	}
+
+	echo "<tr>\n";
+
+	echo "\t<td>$_DateS</td>\n";
+	echo "\t<td>$_DateE</td>\n";
+	echo "\t<td>" . $_GET["len"] . "</td>\n";
+	echo "\t<td>" . $_GET["RID"] . "</td>\n";
+	echo "\t<td>" . $_GET["SchichtName"] . "</td>\n";
+
+	// Ist eintarg schon vorhanden?  
+	$SQL = "SELECT `SID` FROM `Shifts` ";
+	$SQL .= "WHERE (" .
+	"`DateS` = '" . $_DateS . "' AND " .
+	"`DateE` = '" . $_DateE . "' AND " .
+	"`RID` = '" . $_GET["RID"] . "');";
+	$Erg = mysql_query($SQL, $con);
+
+	if (mysql_num_rows($Erg) != 0)
+		echo "\t<td>exists</td>";
+	elseif ($_GET["OnlyShow"] == "OFF") {
+		// erstellt Eintrag in Shifts f�r die algemeine schicht
+		$SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( ";
+		$SQL .= "'" . $_DateS . "', '" . $_DateE . "', ";
+		$SQL .= "'" . $_GET["len"] . "', '" . $_GET["RID"] . "', ";
+		$SQL .= "'" . $_GET["SchichtName"] . "');";
+		$Erg = db_query($SQL, "create shift");
+
+		$SQLFail = "\n\t<br />[" . $SQL . "]";
+
+		if ($Erg == 1)
+			echo "\t<td>pass</td>\n";
+		else
+			echo "\t<td>fail <br />\n<u>" . mysql_error($con) . "</u>$SQLFail</td>\n";
+
+	} else
+		echo "\t<td>only show</td>\n";
+
+	// sucht SID von eingetragennen schiten
+	$SQL = "SELECT SID FROM `Shifts` ";
+	$SQL .= "WHERE (" .
+	"`DateS` = '" . $_DateS . "' AND " .
+	"`DateE` = '" . $_DateE . "' AND " .
+	"`Len` = '" . $_GET["len"] . "' AND " .
+	"`RID` = '" . $_GET["RID"] . "');";
+	$Erg = mysql_query($SQL, $con);
+	if (mysql_num_rows($Erg) == 0)
+		echo "\t<td>?</td>";
+	else {
+		$SID = mysql_result($Erg, 0, "SID");
+		echo "\t<td>" . $SID . "</td>";
+	}
+
+	// erstellt f�r jeden Engeltypen die eintrage in 'ShiftEntry'
+	echo "\t<td>";
+	foreach ($EngelType As $TTemp) {
+		$Temp = "EngelType" . $TTemp["TID"];
+
+		if ($_GET[$Temp] > 0) {
+			$i = 0;
+			echo $_GET[$Temp] . " " . $TTemp["Name"] . "<br />\t";
+			while ($i++ < $_GET[$Temp]) {
+				if ($_GET["OnlyShow"] == "OFF") {
+					$SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES (";
+					$SQL .= "'" . $SID . "', ";
+					$SQL .= "'" . $TTemp["TID"] . "');";
+
+					$Erg = mysql_query($SQL, $con);
+
+					if ($debug)
+						$SQLFail = "\n\t<br />[" . $SQL . "]";
+
+					if ($Erg == 1)
+						echo "'pass' ";
+					else
+						echo "'fail' <u>" . mysql_error($con) . "</u>$SQLFail</td>\n";
+
+				} else
+					echo "+";
+			}
+			echo "<br />";
+		} // IF $$TEMP
+	} // FOREACH
+	echo "</td>";
+
+	echo "</tr>\n";
+}
+
+include ("includes/footer.php");
+?>
diff --git a/www-ssl_old/admin/tshirt.php b/www-ssl_old/admin/tshirt.php
new file mode 100644
index 00000000..9a8e7010
--- /dev/null
+++ b/www-ssl_old/admin/tshirt.php
@@ -0,0 +1,62 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "T-Shirt-Ausgabe";
+$header = "T-Shirt-Ausgabe f&uuml;r aktiven Engel";
+include ("includes/header.php");
+include ("includes/funktion_db_list.php");
+
+If (IsSet ($_GET["aktiv"])) {
+
+	$SQL = "UPDATE `User` SET `Tshirt`='1' WHERE `UID`='" . $_GET["aktiv"] . "' limit 1";
+	$Erg = mysql_query($SQL, $con);
+	if ($Erg == 1) {
+	} else {
+		echo "Fehler beim speichern bei Engel " . UID2Nick($_GET["aktive"]) . "<br />";
+	}
+}
+?>
+
+&Uuml;ber die Suchen-Funktion des Browsers kann diese Liste schnell nach einem Nick abgesucht werden.<br />
+Hinter diesem erscheint ein Link, &uuml;ber den man eintragen kann, dass der Engel sein T-Shirt erhalten hat.<br /><br />
+
+Liste aller aktiven Engel:
+
+<?php
+
+
+$SQL = "SELECT * FROM `User` WHERE (`Aktiv`='1') ORDER BY `Nick` ASC";
+$Erg = mysql_query($SQL, $con);
+
+$rowcount = mysql_num_rows($Erg);
+?>
+<table width="100%" class="border" cellpadding="2" cellspacing="1">
+        <tr class="contenttopic">
+   <td>Nick</td>
+   <td>Aktiv?</td>
+   <td>Gr&ouml;sse</td>
+   <td>T-Shirt ausgeben:</td>
+  </td>
+<?php
+
+
+for ($i = 0; $i < $rowcount; $i++) {
+	echo "\t<tr class=\"content\">\n";
+	$eUID = mysql_result($Erg, $i, "UID");
+	echo "\t\t<td>" . UID2Nick($eUID) . "</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "Aktiv") . "</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "Size") . "</td>\n";
+
+	if (mysql_result($Erg, $i, "Tshirt") == "1") {
+		echo "\t\t<td>bereits erhalten</td>";
+	} else {
+		echo "\t\t<td><a href=\"./tshirt.php?aktiv=$eUID\">XXXXXXXX</a></td>";
+	}
+	echo "\t</tr>\n";
+}
+
+echo "</table>";
+
+include ("includes/footer.php");
+?>
+
diff --git a/www-ssl_old/admin/userArrived.php b/www-ssl_old/admin/userArrived.php
new file mode 100644
index 00000000..93857d2e
--- /dev/null
+++ b/www-ssl_old/admin/userArrived.php
@@ -0,0 +1,53 @@
+<?php
+require_once ('../bootstrap.php');
+
+$title = "Engel Arrived";
+$header = "Engel was arrived";
+include ("includes/header.php");
+include ("includes/funktion_db_list.php");
+
+If (IsSet ($_GET["arrived"])) {
+
+	$SQL = "UPDATE `User` SET `Gekommen`='1' WHERE `UID`='" . $_GET["arrived"] . "' limit 1";
+	$Erg = db_query($SQL, "Set User as Gekommen");
+	if ($Erg == 1) {
+		echo "<h2>" . Get_Text("pri_userArrived_WriteOK") . " \"" . UID2Nick($_GET["arrived"]) . "\"</h2>";
+	} else {
+		echo "<h1>" . Get_Text("pri_userArrived_WriteError") . " \"" . UID2Nick($_GET["arrived"]) . "\"</h1>";
+	}
+}
+
+echo Get_Text("pri_userArrived_Text1") . "<br />";
+echo Get_Text("pri_userArrived_Text2") . "<br /><br />";
+
+echo Get_Text("pri_userArrived_TableToppic");
+$SQL = "SELECT * FROM `User` ORDER BY `Nick` ASC";
+$Erg = mysql_query($SQL, $con);
+
+$rowcount = mysql_num_rows($Erg);
+
+echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+echo "\t<tr class=\"contenttopic\">\n";
+echo "\t\t<td>" . Get_Text("pri_userArrived_TableTD_Nick") . "</td>\n";
+echo "\t\t<td>" . Get_Text("pri_userArrived_TableTD_ArrivedShow") . "</td>\n";
+echo "\t\t<td>" . Get_Text("pri_userArrived_TableTD_ArrivedSet") . "</td>\n";
+echo "\t</td>\n";
+
+for ($i = 0; $i < $rowcount; $i++) {
+	echo "\t<tr class=\"content\">\n";
+	$eUID = mysql_result($Erg, $i, "UID");
+	echo "\t\t<td>" . UID2Nick($eUID) . "</td>\n";
+	echo "\t\t<td>" . mysql_result($Erg, $i, "Gekommen") . "</td>\n";
+
+	if (mysql_result($Erg, $i, "Gekommen") == "1") {
+		echo "\t\t<td>" . Get_Text("pri_userArrived_TableEntry_Arrived") . "</td>";
+	} else {
+		echo "\t\t<td><a href=\"./userArrived.php?arrived=$eUID\">" . Get_Text("pri_userArrived_TableEntry_Set") . "</a></td>";
+	}
+	echo "\t</tr>\n";
+}
+echo "</table>";
+
+include ("includes/footer.php");
+?>
+