From 866c47ec603595e8fe67da5f0e5d162a70b1f7b4 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Sun, 6 Nov 2005 17:14:25 +0000
Subject: move files

git-svn-id: svn://svn.cccv.de/engel-system@20 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/admin/EngelType.php           | 166 +++++++++++++
 www-ssl/admin/aktiv.php               |  96 ++++++++
 www-ssl/admin/dbUpdateFromXLS.php     | 448 ++++++++++++++++++++++++++++++++++
 www-ssl/admin/dect.php                |  68 ++++++
 www-ssl/admin/dect_clear.php          |  25 ++
 www-ssl/admin/dect_cron.php           |  69 ++++++
 www-ssl/admin/faq.1.php               |   6 +
 www-ssl/admin/faq.php                 | 340 ++++++++++++++++++++++++++
 www-ssl/admin/free.php                | 108 ++++++++
 www-ssl/admin/inc                     |   1 +
 www-ssl/admin/index.php               |  19 ++
 www-ssl/admin/list.php                |  34 +++
 www-ssl/admin/menu.php                |  46 ++++
 www-ssl/admin/news.php                | 109 +++++++++
 www-ssl/admin/pic                     |   1 +
 www-ssl/admin/room.php                | 184 ++++++++++++++
 www-ssl/admin/schichtplan.1.php       |   5 +
 www-ssl/admin/schichtplan.php         | 291 ++++++++++++++++++++++
 www-ssl/admin/schichtplan_druck.1.php |   5 +
 www-ssl/admin/schichtplan_druck.php   | 169 +++++++++++++
 www-ssl/admin/shiftadd.php            | 329 +++++++++++++++++++++++++
 www-ssl/admin/sprache.php             | 116 +++++++++
 www-ssl/admin/tshirt.php              |  60 +++++
 www-ssl/admin/user.php                | 249 +++++++++++++++++++
 www-ssl/admin/user2.php               | 128 ++++++++++
 25 files changed, 3072 insertions(+)
 create mode 100755 www-ssl/admin/EngelType.php
 create mode 100755 www-ssl/admin/aktiv.php
 create mode 100755 www-ssl/admin/dbUpdateFromXLS.php
 create mode 100755 www-ssl/admin/dect.php
 create mode 100755 www-ssl/admin/dect_clear.php
 create mode 100755 www-ssl/admin/dect_cron.php
 create mode 100755 www-ssl/admin/faq.1.php
 create mode 100755 www-ssl/admin/faq.php
 create mode 100755 www-ssl/admin/free.php
 create mode 120000 www-ssl/admin/inc
 create mode 100755 www-ssl/admin/index.php
 create mode 100755 www-ssl/admin/list.php
 create mode 100755 www-ssl/admin/menu.php
 create mode 100755 www-ssl/admin/news.php
 create mode 120000 www-ssl/admin/pic
 create mode 100755 www-ssl/admin/room.php
 create mode 100755 www-ssl/admin/schichtplan.1.php
 create mode 100755 www-ssl/admin/schichtplan.php
 create mode 100755 www-ssl/admin/schichtplan_druck.1.php
 create mode 100755 www-ssl/admin/schichtplan_druck.php
 create mode 100755 www-ssl/admin/shiftadd.php
 create mode 100755 www-ssl/admin/sprache.php
 create mode 100755 www-ssl/admin/tshirt.php
 create mode 100755 www-ssl/admin/user.php
 create mode 100755 www-ssl/admin/user2.php

(limited to 'www-ssl/admin')

diff --git a/www-ssl/admin/EngelType.php b/www-ssl/admin/EngelType.php
new file mode 100755
index 00000000..964d861b
--- /dev/null
+++ b/www-ssl/admin/EngelType.php
@@ -0,0 +1,166 @@
+<?php
+$title = "R&auml;ume";
+$header = "Verwaltung der R&auml;ume";
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+
+function runSQL( $SQL)
+{
+	include( "./inc/db.php");
+	// hier muesste das SQL ausgefuehrt werden...
+	$Erg = mysql_query($SQL, $con);
+	if ($Erg == 1) {
+		echo "&Auml;nderung wurde gesichert...<br>";
+		echo "[$SQL]<br>"; 
+		return 1;
+	} else {
+		echo "Fehler beim speichern... bitte noch ein mal probieren :)";
+		echo "<br><br>".mysql_error( $con ). "<br>";
+		echo "[$SQL]<br>"; 
+		return 0;
+	}
+}
+
+
+$Sql = "SELECT * FROM `EngelType`";
+$Erg = mysql_query($Sql, $con);
+
+if( !IsSet($_GET["action"]) )
+{
+	echo "Hallo ".$_SESSION['Nick'].
+		",<br>\nhier hast du die M&ouml;glichkeit, neue Engeltypen f&uuml;r die Schichtpl&auml;ne einzutragen ".
+		"oder vorhandene abzu&auml;ndern:<br><br>\n";
+
+	echo "<a href=\"./EngelType.php?action=new\">- Neuen EngelType 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++ )
+	{
+		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=\"./EngelType.php?action=change&TID=".mysql_result($Erg, $t, "TID")."\">###</a></td>\n";
+		echo "\t</tr>\n";
+	} // ende Auflistung Raeume
+	echo "</table>";
+} 
+else 
+{
+
+switch ($_GET["action"]) {
+
+case 'new':
+	echo "Neuen EngelType einrichten: <br>";
+	echo "<form action=\"./EngelType.php\" method=\"GET\">\n";
+	echo "<table>\n";
+	
+	for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ )
+	{
+	    echo "<td>".mysql_field_name($Erg, $Uj)."</td>".
+	         "<td><input type=\"text\" size=\"40\" name=\"".mysql_field_name($Erg, $Uj)."\"></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 = $HTTP_GET_VARS;
+	$count = count($vars) - 1;
+	$vars = array_splice($vars, 0, $count);
+	$Keys="";
+	$Values="";
+	foreach($vars as $key => $value){
+		$Keys   .= ", `$key`";
+		$Values .= ", '$value'";
+	}
+	
+	if( runSQL( "INSERT INTO `EngelType` (". substr($Keys, 2). ") VALUES (". substr($Values, 2). ")") )
+	{
+		SetHeaderGo2Back();
+		
+		$SQL2 = "SELECT * FROM `EngelType` WHERE `Name`='". $_GET["Name"]. "'";
+		$ERG = mysql_query($SQL2, $con);
+	
+		if( mysql_num_rows($ERG) == 1)
+			runSQL( "ALTER TABLE `Room` ADD `DEFAULT_EID_". 
+				mysql_result( $ERG, 0, 0). 
+				"` INT DEFAULT '0' NOT NULL;");
+	}
+	break;
+
+case 'change':
+	if (! IsSet($_GET["TID"])) {
+		echo "Fehlerhafter Aufruf!"; 
+	} else {
+
+	echo "Raum ab&auml;ndern:\n";
+
+	echo "Hier kannst du eintragen, den EngelType &auml;ndern.";
+	
+	echo "<form action=\"./EngelType.php\" method=\"GET\">\n";
+	echo "<table>\n";
+	
+	$SQL2 = "SELECT * FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'";
+	$ERG = mysql_query($SQL2, $con);
+        
+        for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++)
+	{
+		echo "<tr><td>". mysql_field_name($ERG, $Uj). "</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=\"eTID\" value=\"". $_GET["TID"]. "\">\n";
+	echo "<input type=\"hidden\" name=\"action\" value=\"changesave\">\n";
+	echo "<input type=\"submit\" value=\"sichern...\">\n";
+	echo "</form>";
+        echo "<form action=\"./EngelType.php\" method=\"GET\">\n";
+        echo "<input type=\"hidden\" name=\"TID\" value=\"". $_GET["TID"]. "\">\n";
+        echo "<input type=\"hidden\" name=\"action\" value=\"delete\">\n";
+        echo "<input type=\"submit\" value=\"L&ouml;schen...\">";
+        echo "</form>";
+	}
+	break;
+	
+case 'changesave':
+        $vars = $HTTP_GET_VARS;
+        $count = count($vars) - 2;
+        $vars = array_splice($vars, 0, $count);
+	$keys="";
+	$sql="";
+        foreach($vars as $key => $value){
+  	      $keys = substr($key,1);
+	      $sql .= ", `".$keys."`='".$value."'";
+        }
+	runSQL( "UPDATE `EngelType` SET ". substr($sql, 2). " WHERE `TID`='". $_GET["eTID"]. "'");
+	SetHeaderGo2Back();
+	break;
+
+case 'delete':
+	if (IsSet($_GET["TID"])) 
+	{
+		runSQL( "DELETE FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'");		
+		runSQL( "ALTER TABLE `Room` DROP `DEFAULT_EID_". $_GET["TID"]. "`;");
+	} else {
+		echo "Fehlerhafter Aufruf";
+	}
+	SetHeaderGo2Back();
+	break;
+}
+}
+
+include ("./inc/footer.php");
+?>
diff --git a/www-ssl/admin/aktiv.php b/www-ssl/admin/aktiv.php
new file mode 100755
index 00000000..e0ddf3a4
--- /dev/null
+++ b/www-ssl/admin/aktiv.php
@@ -0,0 +1,96 @@
+<?PHP
+
+$title = "akive Engel";
+$header = "Liste der aktiven Engel";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.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 = mysql_query($SQLreset, $con);
+	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_Active"). "</td>\n";
+echo "</tr>\n";
+	
+$SQL = "SELECT ShiftEntry.UID, COUNT(ShiftEntry.UID) AS NR, SUM(Shifts.Len) as LEN ".
+	"FROM `ShiftEntry` ".
+	"LEFT JOIN `Shifts` ON ShiftEntry.SID=Shifts.SID ".
+	"WHERE NOT UID=0 ".
+	"GROUP BY UID ".
+	"ORDER BY LEN DESC, NR DESC, UID ";
+$Erg = mysql_query($SQL, $con);
+echo mysql_error($con);
+$rowcount = mysql_num_rows($Erg);
+
+echo "Anzahl eintraege: $rowcount<br><br>";
+
+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"). "</td>\n";
+	echo "\t\t<td>". mysql_result($Erg, $i, "LEN"). "h</td>\n";
+	echo "\t\t<td>";
+	if (IsSet($_POST["Anzahl"]))
+	{	
+		if( $_POST["Anzahl"] < mysql_result($Erg, $i, "LEN") )
+		{
+			if( $_POST["SendType"]=="Show..")
+				echo "show set";
+			else
+			{
+				$SQL2="UPDATE User SET Aktiv=1 WHERE UID=". mysql_result($Erg, $i, "UID"). " LIMIT 1";
+				$Erg2 = mysql_query($SQL2, $con);
+				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>";
+
+include ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/dbUpdateFromXLS.php b/www-ssl/admin/dbUpdateFromXLS.php
new file mode 100755
index 00000000..88f7a0f5
--- /dev/null
+++ b/www-ssl/admin/dbUpdateFromXLS.php
@@ -0,0 +1,448 @@
+<?PHP
+
+$title = "DB Update from XML";
+$header = "DB Update from XML";
+$Page["Public"] = "N";
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+include ("./inc/funktion_xml.php");
+
+///////////
+// DEBUG //
+///////////
+$EnableRooms = true;
+$EnableRoomsDB = true;
+$EnableSchudle = true;
+$EnableSchudleDB = true;
+//$EnableRooms = false;
+//$EnableRoomsDB = false;
+//$EnableSchudle = false;
+//$EnableSchudleDB = false;
+
+/*##############################################################################################
+				           F I L E
+  ##############################################################################################*/
+echo "\n\n<br>\n<h1>XML File:</h1>\n";
+if( isset($_POST["PentabarfUser"]) && isset($_POST["PentabarfPasswd"]) && isset($_POST["PentabarfURL"]))
+{
+	echo "Update XML-File from Pentabarf..";
+/*	$Command = "wget --http-user=". $_POST["PentabarfUser"]. " --http-passwd=".$_POST["PentabarfPasswd"]. " ".
+			$_POST["PentabarfURL"].
+			" --output-file=/tmp/engelXMLwgetLog --output-document=/tmp/engelXML";
+*/	
+	$Command = "lynx -auth=". $_POST["PentabarfUser"]. ":".$_POST["PentabarfPasswd"]. " -dump ".
+			$_POST["PentabarfURL"].	" > /tmp/engelXML";
+	echo system( $Command, $Status);
+
+	if( $Status==0)
+		echo "OK.<br>";
+	else
+		echo "fail ($Status)($Command).<br>";
+}
+else
+{
+	echo "<form action=\"dbUpdateFromXLS.php\" method=\"post\">\n";
+	echo "<table border=\"0\">\n";
+	echo "\t<tr><td>XML-File:</td>".
+		"<td><input name=\"PentabarfURL\" type=\"text\" size=\"100\" maxlength=\"1000\" ".
+		"value=\"https://pentabarf.cccv.de/pentabarf/xml/fahrplan/conference/1\"></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=\"PentabarfPasswd\" 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("/tmp/engelXML") == 0)
+{
+/*
+echo "<pre><br>";
+echo $XMLmain->name;
+echo "<br>";
+//print_r(array_values ($XMLmain->sub));
+
+
+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, "RELEASE");
+echo "release: ". $XMLrelease->data. "<br>\n";
+$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE");
+echo "release date: ". $XMLreleaseDate->data. "<br>\n";
+echo "<hr>\n";
+
+
+
+/*##############################################################################################
+				           R o o m
+  ##############################################################################################*/
+echo "\n\n<br>\n<h1>Rooms:</h1>\n";
+
+function saveRoomData()
+{
+	include ("./inc/db.php");
+	if( isset($_GET["RID"]) && isset($_GET["NumberXML"]) && isset($_GET["NameXML"]))
+	{
+		$SQL1 = "SELECT `RID` FROM `Room` ".
+			"WHERE `RID` = '". $_GET["RID"]. "';";
+		$Erg1 = mysql_query($SQL1, $con);
+		
+		if( mysql_num_rows($Erg1)==1 )
+			$SQL= "UPDATE `Room` SET `Name` = '". mysql_escape_string($_GET["NameXML"]). 
+				"', `FromPentabarf`='Y', `Number`='". $_GET["NumberXML"]. "' ".
+				"WHERE `RID` = '". $_GET["RID"]. "' LIMIT 1;";
+		else
+			$SQL= "INSERT INTO `Room` ( `RID` , `Name`, `FromPentabarf`, `Number` ) ".
+				"VALUES ('". $_GET["RID"]. "', '". mysql_escape_string($_GET["NameXML"]). 
+					  "', 'Y', ". $_GET["NumberXML"]. ");";
+		$Erg = mysql_query($SQL, $con);
+		if( $Erg )
+			echo "Aenderung, an Raum ". $_GET["NameXML"]. ", war erfogreich<br>";
+		else
+			echo "Aenderung, an Raum ". $_GET["NameXML"]. ", war <u>nicht</u> erfogreich.(".
+				mysql_error($con). ")<br>[$SQL]<br>";
+	}
+	else 
+		echo "Fehler in den Parametern!<br>";
+} /*function saveRoomData*/
+
+function getDBRoomName( $RID)
+{
+	include ("./inc/db.php");
+	$SQL = "SELECT Name FROM `Room` WHERE RID=$RID";
+	$Erg = mysql_query($SQL, $con);
+	if(mysql_num_rows($Erg)>0)
+		return mysql_result($Erg, 0, 0);
+	else
+		return "";
+} /*function getDBRoomName*/
+
+function getDBRoomNumber( $RID)
+{
+	include ("./inc/db.php");
+	$SQL = "SELECT Number FROM `Room` WHERE RID=$RID";
+	$Erg = mysql_query($SQL, $con);
+	if(mysql_num_rows($Erg)>0)
+		return mysql_result($Erg, 0, 0);
+	else
+		return "";
+} /*function getDBRoomNumber*/
+
+
+
+if( isset($_GET["RoomUpdate"]))
+	saveRoomData();
+
+//INIT Status counter
+$DS_OK = 0;
+$DS_KO = 0;
+$Where = "";
+
+//Ausgabe
+echo "<table border=\"0\">\n";
+echo "<tr><th>RID</th><th>NumberXML</th><th>NumberDB</th><th>NameXML</th><th>NameDB</th><th>state</th></tr>\n";
+$XMLroom = getXMLsubPease( $XMLmain, "ROOMS");
+while( (list($key, $value) = each($XMLroom->sub)) && $EnableRooms)
+{
+	$XMLRID  = getXMLsubPease( $value, "ID");
+	$RID     = $XMLRID->data;
+	$XMLNumber = getXMLsubPease( $value, "NUMBER");
+	$NumberXML = trim($XMLNumber->data);
+	$XMLName = getXMLsubPease( $value, "NAME");
+	$NameXML = trim($XMLName->data);
+	
+	if( isset($_GET["UpdateALL"]))
+	{
+		$_GET["NameXML"] = $NameXML;
+		$_GET["NumberXML"] = $NumberXML;
+		$_GET["RID"] = $RID;
+		saveRoomData();
+	}
+	
+	$NameDB    = convertValues(getDBRoomName($RID));
+	$NumberDB  = convertValues(getDBRoomNumber($RID));
+	
+	echo "<form action=\"dbUpdateFromXLS.php\">\n";
+	echo "\t<tr>\n";
+	echo "\t<td><input name=\"RID\" type=\"text\" value=\"$RID\" size=\"1\" eadonly></td>\n";
+	echo "\t<td><input name=\"NumberXML\" type=\"text\" value=\"$NumberXML\" size=\"1\" readonly></td>\n";
+	echo "\t<td><input name=\"NumberDB\" type=\"text\" value=\"$NumberDB\" size=\"1\"readonly></td>\n";
+	echo "\t<td><input name=\"NameXML\" type=\"text\" value=\"$NameXML\" readonly></td>\n";
+	echo "\t<td><input name=\"NameDB\" type=\"text\" value=\"$NameDB\" readonly></td>\n";
+	if( !(	$NameXML==$NameDB && $NumberXML==$NumberDB) )
+	{
+		echo "\t<td><input type=\"submit\" name=\"RoomUpdate\" value=\"update\"></td>\n";
+		$DS_KO++;
+	}
+	else
+	{
+		echo "\t<td>OK</td>\n";
+		$DS_OK++;
+	}
+	echo "\t</tr>\n";
+	echo "</form>\n";
+	$Where.= " OR RID=$RID";
+}
+echo "<tr><td colspan=\"6\">status: $DS_KO/$DS_OK nicht Aktuel.</td></tr>\n";
+
+//Anzeige von nicht im XML File vorkommende entraege
+$SQL2 = "SELECT * FROM `Room` WHERE NOT (".substr( $Where, 4). ") AND FromPentabarf =  'Y';";
+$Erg2 = mysql_query($SQL2, $con);
+if( mysql_num_rows($Erg2)>0 && $EnableRoomsDB )
+	for( $i=0; $i<mysql_num_rows( $Erg2); $i++)
+	{
+		$RID      = mysql_result( $Erg2, $i, "RID");
+		$NumberDB = mysql_result( $Erg2, $i, "Number");
+		$NameDB   = mysql_result( $Erg2, $i, "Name");
+		echo "\t<tr>\n";
+		echo "\t<td><input name=\"RID\" type=\"text\" value=\"$RID\" size=\"1\" eadonly></td>\n";
+		echo "\t<td><input name=\"NumberXML\" type=\"text\" value=\"\" size=\"1\" readonly></td>\n";
+		echo "\t<td><input name=\"NumberDB\" type=\"text\" value=\"$NumberDB\" size=\"1\"readonly></td>\n";
+		echo "\t<td><input name=\"NameXML\" type=\"text\" value=\"\" readonly></td>\n";
+		echo "\t<td><input name=\"NameDB\" type=\"text\" value=\"$NameDB\" readonly></td>\n";
+		echo "\t<td><a href=\"./room.php?action=change&RID=$RID\">edit</a></td>\n";
+		echo "\t<tr>\n";
+	}
+
+echo "</table>\n";
+
+
+
+
+/*##############################################################################################
+				        S c h e d u l e 
+  ##############################################################################################*/
+echo "\n\n<h1>Schudle:</h1>\n";
+
+// erstellt ein Array der Reume
+        $sql = "SELECT * FROM `Room` ".
+               "ORDER BY `Number`, `Name`;";
+	$Erg = mysql_query($sql, $con);
+	for( $i=0; $i<mysql_num_rows($Erg); $i++)
+		for( $j=0; $j<mysql_num_fields( $Erg); $j++)
+			$RoomID[ mysql_result($Erg, $i, "RID")]
+			       [ mysql_field_name($Erg, $j)] = mysql_result($Erg, $i, $j);
+																
+
+function SaveSchedule()
+{
+	global  $RoomID;
+
+	include ("./inc/db.php");
+	if( isset($_GET["SIDXML"]) && 
+	    isset($_GET["DateXML"]) &&
+	    isset($_GET["RIDXML"]) &&
+	    isset($_GET["LenXML"]) &&
+	    isset($_GET["ManXML"])  )
+	{
+		//erzeuge von `DateE`
+		$TimeStart = substr( $_GET["DateXML"], 11, 2) + (substr($_GET["DateXML"], 14, 2)/60);
+		$TimeEnd  = ($_GET["LenXML"] + $TimeStart) * 60;
+		$TimeM = $TimeEnd % 60;
+		$TimeH = ($TimeEnd - $TimeM)/60;
+		if( $TimeH>=24 )
+		{
+			$TimeH -= 24;
+			$DateEnd = substr($_GET["DateXML"], 0, 8). 
+				   (substr($_GET["DateXML"], 8, 2)+1). " ";
+		}
+		else
+			$DateEnd = substr($_GET["DateXML"], 0, 11);
+		$DateEnd .= "$TimeH:$TimeM:00";
+		
+		//Update OR insert ?
+		$SQL1 = "Select `SID` FROM `Shifts` WHERE `SID`='". $_GET["SIDXML"]. "';";
+		$Erg1 =  mysql_query($SQL1, $con);
+		
+		if( mysql_num_rows($Erg1)==0)
+			$SQL= "INSERT INTO `Shifts` (`SID`, `DateS`, `DateE`, `Len`, `RID`, `Man`, `FromPentabarf`) ".
+				"VALUES ('". $_GET["SIDXML"]. "', '". $_GET["DateXML"]. "', '". 
+					     $DateEnd. "', '". $_GET["LenXML"]. "', '". 
+					     $_GET["RIDXML"]. "', '". mysql_escape_string($_GET["ManXML"]). "', 'Y');";
+		else
+			$SQL= "UPDATE `Shifts` SET ".
+				"`DateS` = '". $_GET["DateXML"]. "', ".
+				"`DateE` = '". $DateEnd. "', ".
+				"`Len` = '". $_GET["LenXML"]. "', ".
+				"`RID` = '". $_GET["RIDXML"]. "', ".
+				"`Man` = '". mysql_escape_string($_GET["ManXML"]). "', ".
+				"`FromPentabarf`= 'Y' ".
+				"WHERE `SID` = '". $_GET["SIDXML"]. "' LIMIT 1;";
+		$Erg = mysql_query($SQL, $con);
+		if( $Erg )
+		{
+			echo "Aenderung, am Schedule '". $_GET["SIDXML"]. "', war erfogreich<br>\n";
+			if( mysql_num_rows($Erg1)==0)
+			{
+				echo "-->Create Shifts:<br>\n";
+				foreach ($RoomID[ $_GET["RIDXML"]] as $Key => $Value)
+					if( substr( $Key, 0, 12)=="DEFAULT_EID_" && $Value > 0 )
+					{
+						echo "---->Create engeltype: ". substr( $Key, 12). " ". $Value. "x<br>\n";
+						$i=0;
+						while( $i++ < $Value )
+						{
+							$SQL3  = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES (".
+								 "'". $_GET["SIDXML"]. "', '". substr( $Key, 12). "');";
+
+							$Erg = mysql_query($SQL3, $con);
+
+							if ($Erg == 1) 
+								echo "------>pass<br>\n";
+							else
+								echo "------>fail <u>". mysql_error($con). 
+								"</u>($SQL3)<br>\n";
+						}
+						
+					}
+				echo "<br>\n";
+			}
+		}
+		else
+			echo "Aenderung, am Schedule '". $_GET["SIDXML"]. "', war <u>nicht</u> erfogreich.(". 
+				mysql_error($con). ")<br>[$SQL]<br>\n";
+	}
+	else 
+		echo "Fehler in den Parametern!<br>";
+} /*SaveSchedule*/
+
+if( isset($_GET["ScheduleUpdate"]))
+	SaveSchedule();
+
+//INIT Status counter
+$DS_OK = 0;
+$DS_KO = 0;
+$Where = "";
+
+//ausgabe
+echo "<table border=\"0\">\n";
+echo "<tr><th>SID</th><th>Date</th>".
+	"<th>Room</th><th>Len</th><th>Name</th><th>state</th></tr>\n";
+echo "<tr align=\"center\"><td>XML - DB</td><td>XML - DB</td>".
+	"<td>XML - DB</td><td>XML - DB</td><td>XML - DB</td><td></td></tr>\n";
+$XMLevents = getXMLsubPease( $XMLmain, "EVENTS");
+while( (list($EventKey, $Event) = each($XMLevents->sub)) && $EnableSchudle)
+{	
+	echo "<form action=\"dbUpdateFromXLS.php\">\n";
+	echo "\t<tr>\n";
+	
+	$DateXML = substr($Event->attributes["START"], 0, 10). " ".
+		   substr($Event->attributes["START"], 11). ":00";
+	$LenXML  = $Event->attributes["DURATION"];
+		$LenXML  = substr( $LenXML, 0, 2) + (substr($LenXML, 3, 2)/60);
+	$XMLeventID = getXMLsubPease( $Event, "ID");
+		$SIDXML  = $XMLeventID->data;
+	$RIDXML  = $Event->attributes["ROOM-ID"];
+	$XMLTitle = getXMLsubPease( $Event, "TITLE");
+		$ManXML  = $XMLTitle->data;
+			
+	if( isset($_GET["UpdateALL"]))
+	{
+		$_GET["SIDXML"]  = $SIDXML;
+		$_GET["DateXML"] = "$DateXML $TimeXML";
+		$_GET["LenXML"]  = $LenXML;
+		$_GET["RIDXML"]  = $RIDXML;
+		$_GET["ManXML"]  = $ManXML;
+		SaveSchedule();
+	}
+			
+	$SQL = "SELECT * FROM `Shifts` WHERE SID=$SIDXML";
+	$Erg = mysql_query($SQL, $con);
+	if(mysql_num_rows($Erg)>0)
+	{
+		$SIDDB  = mysql_result($Erg, 0, "SID");
+		$TimeDB = mysql_result($Erg, 0, "DateS");
+		$LenDB  = mysql_result($Erg, 0, "Len");
+		$RIDDB  = mysql_result($Erg, 0, "RID");
+		$ManDB  = mysql_result($Erg, 0, "Man");
+	}
+	else
+		$SIDDB  = $TimeDB = $LenDB  = $RIDDB  = $ManDB= "";
+	echo "\t<td><input name=\"SIDXML\" type=\"text\" value=\"$SIDXML\" size=\"2\" eadonly></td>\n";
+	echo "\t<td><input name=\"DateXML\" type=\"text\" value=\"$DateXML\" size=\"17\" readonly>\n\t\t".
+		   "<input name=\"DateDB\" type=\"text\" value=\"$TimeDB\" size=\"17\" readonly></td>\n";
+	echo "\t<td><input name=\"RIDXML\" type=\"text\" value=\"$RIDXML\" size=\"1\" readonly>\n\t\t".
+		   "<input name=\"RIDDB\" type=\"text\" value=\"$RIDDB\" size=\"1\" readonly></td>\n";
+	echo "\t<td><input name=\"LenXML\" type=\"text\" value=\"$LenXML\" size=\"1\"readonly>\n\t\t".
+		   "<input name=\"LenDB\" type=\"text\" value=\"$LenDB\" size=\"1\"readonly></td>\n";
+	echo "\t<td><input name=\"ManXML\" type=\"text\" value=\"$ManXML\" size=\"40\"readonly>\n\t\t".
+		   "<input name=\"ManDB\" type=\"text\" value=\"$ManDB\" size=\"40\"readonly></td>\n";
+	if( !(	$SIDXML==$SIDDB && 
+		$DateXML==$TimeDB && 
+		$RIDXML==$RIDDB && 
+		$LenXML==$LenDB &&
+		$ManXML==$ManDB) )
+	{
+		echo "\t<td><input type=\"submit\" name=\"ScheduleUpdate\" value=\"update\"></td>\n";
+		$DS_KO++;
+	}
+	else
+	{
+		echo "\t<td>OK</td>\n";
+		$DS_OK++;
+	}
+	echo "\t</tr>\n";
+	echo "</form>\n";
+	$Where.= " OR SID=$SIDXML";		
+}
+echo "<tr><td colspan=\"6\">status: $DS_KO/$DS_OK nicht Aktuel.</td></tr>\n";
+
+//Anzeige von nicht im XML File vorkommende entraege
+$SQL2 = "SELECT * FROM `Shifts` WHERE NOT (".substr( $Where, 4). ") AND FromPentabarf =  'Y';";
+$Erg2 = mysql_query($SQL2, $con);
+if(mysql_num_rows($Erg2)>0 && $EnableSchudleDB )
+	for( $i=0; $i<mysql_num_rows( $Erg2); $i++)
+	{
+		echo "\t<tr>\n";
+		$SID  = mysql_result($Erg2, $i, "SID");
+		$Time = mysql_result($Erg2, $i, "DateS");
+		$Len  = mysql_result($Erg2, $i, "Len");
+		$RID  = mysql_result($Erg2, $i, "RID");
+		$Man  = mysql_result($Erg2, $i, "Man");
+		echo "\t<td><input name=\"SIDXML\" type=\"text\" value=\"$SID\" size=\"2\" eadonly></td>\n";
+		echo "\t<td><input name=\"DateXML\" type=\"text\" value=\"\" size=\"17\" readonly>\n\t\t".
+			   "<input name=\"DateDB\" type=\"text\" value=\"$Time\" size=\"17\" readonly></td>\n";
+		echo "\t<td><input name=\"RIDXML\" type=\"text\" value=\"\" size=\"1\" readonly>\n\t\t".
+			   "<input name=\"RIDDB\" type=\"text\" value=\"$RID\" size=\"1\" readonly></td>\n";
+		echo "\t<td><input name=\"LenXML\" type=\"text\" value=\"\" size=\"1\"readonly>\n\t\t".
+			   "<input name=\"LenDB\" type=\"text\" value=\"$Len\" size=\"1\"readonly></td>\n";
+		echo "\t<td><input name=\"ManXML\" type=\"text\" value=\"\" size=\"40\"readonly>\n\t\t".
+			   "<input name=\"ManDB\" type=\"text\" value=\"$Man\" size=\"40\"readonly></td>\n";
+		echo "\t<td><a href=\"./schichtplan.php?action=change&SID=$SID\">edit</a></td>\n";
+		echo "\t<tr>\n";
+	}
+echo "</table>";
+
+
+
+/*##############################################################################################
+				         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 ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/dect.php b/www-ssl/admin/dect.php
new file mode 100755
index 00000000..99a58028
--- /dev/null
+++ b/www-ssl/admin/dect.php
@@ -0,0 +1,68 @@
+<?PHP
+
+$title = "Engelsystem - DECT";
+$header = "DECT send call";
+$Page["Public"] = "N";
+include ("./inc/header.php");
+
+include ("./inc/funktion_modem.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"]);
+
+	$_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 ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/dect_clear.php b/www-ssl/admin/dect_clear.php
new file mode 100755
index 00000000..2b20d6c5
--- /dev/null
+++ b/www-ssl/admin/dect_clear.php
@@ -0,0 +1,25 @@
+<?PHP
+
+
+include ("./inc/db.php");
+include ("./inc/config.php");
+include ("./inc/funktion_modem.php");
+
+
+$SQL =  "SELECT DECT FROM `User`;";
+
+$Erg = mysql_query($SQL, $con);
+
+echo mysql_error($con);
+
+for( $i=0; $i<mysql_num_rows($Erg); $i++)
+{ 
+ 	$Number = "#10". mysql_result($Erg, $i, "DECT");
+	if( strlen($Number)==7)
+		DialNumber(  $Number);
+}
+
+return 0;
+
+?>
+
diff --git a/www-ssl/admin/dect_cron.php b/www-ssl/admin/dect_cron.php
new file mode 100755
index 00000000..00119567
--- /dev/null
+++ b/www-ssl/admin/dect_cron.php
@@ -0,0 +1,69 @@
+<?PHP
+
+
+include ("./inc/db.php");
+include ("./inc/config.php");
+include ("./inc/funktion_modem.php");
+
+//ausfuerungs Ruetmuss (in s)
+$StartTimeBeforEvent = (60/4)*60; 
+
+
+
+
+function UID2DECT($UID) 
+{
+	include ("./inc/db.php");
+
+	$SQL = "SELECT DECT FROM `User` WHERE UID='$UID'";
+	$Erg = mysql_query($SQL, $con);
+
+	return mysql_result($Erg, 0);
+}
+
+
+$SQL =  "SELECT Shifts.DateS, ShiftEntry.UID ".
+	"FROM `Shifts` INNER JOIN `ShiftEntry` ON `Shifts`.`SID` = `ShiftEntry`.`SID` ".
+	"WHERE ((`Shifts`.`DateS`>'". gmdate("Y-m-d H:i:s", time()+3600+120). "') AND ".
+	       "(`Shifts`.`DateS`<='". gmdate("Y-m-d H:i:s", time()+3600+120+$StartTimeBeforEvent). "') );";
+//	"WHERE (Shifts.DateS>'2004-12-27 10:45:00' AND ".
+//	       "Shifts.DateS<='2004-12-27 11:00:00');";
+
+$Erg = mysql_query($SQL, $con);
+
+echo mysql_error($con);
+
+for( $i=0; $i<mysql_num_rows($Erg); $i++)
+{  
+//   echo mysql_result($Erg, $i, "UID");
+   if( mysql_result($Erg, $i, "UID")>0)
+   {
+	$SQL2 = "SELECT DECT FROM `User` WHERE ( `UID`='". mysql_result($Erg, $i, "UID"). "');";
+	$Erg2 = mysql_query($SQL2, $con);
+
+	$Number = mysql_result($Erg2, 0, "DECT");
+	if( $Number!="")
+	{
+		$TimeH = substr( mysql_result($Erg, $i, "DateS"), 11, 2);
+		$TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2);
+		$TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2) - 5;
+		if( $TimeM < 0 )
+		{
+			$TimeM += 60;
+			$TimeH -= 1;
+		}
+		if( $TimeH < 0 )
+			$TimeH += 24;
+		
+		if( strlen( $TimeH) == 1)
+			$TimeH = "0".$TimeH;
+			
+		SetWackeup( $Number, $TimeH, $TimeM);
+	}
+  }
+}
+
+return 0;
+
+?>
+
diff --git a/www-ssl/admin/faq.1.php b/www-ssl/admin/faq.1.php
new file mode 100755
index 00000000..ee2bbb53
--- /dev/null
+++ b/www-ssl/admin/faq.1.php
@@ -0,0 +1,6 @@
+<h4 class="menu"> Anfragen und FAQ </h4>
+
+<li><a href="faq.php?quest=all">Alle Anfragen</a></li>
+<li><a href="faq.php?quest=open">Offene Anfragen (<? noAnswer(); ?>)</a></li>
+<li><a href="faq.php?quest=faq">FAQ-Liste editiern</a></li>
+
diff --git a/www-ssl/admin/faq.php b/www-ssl/admin/faq.php
new file mode 100755
index 00000000..e4123841
--- /dev/null
+++ b/www-ssl/admin/faq.php
@@ -0,0 +1,340 @@
+<?php
+$title = "Himmel";
+$header = "FAQ / Fragen an die Erzengel";
+$submenus = 1;
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+
+//var init
+$quest_bearb=0;
+
+if (IsSet($_GET["quest"])) {
+
+switch ($_GET["quest"]) 
+{
+
+// *---------------------------------------------------------------------------
+// * Anfragen - Bearbeitung
+// *---------------------------------------------------------------------------
+// * je nach Übergabeoption ($quest) koennen Anfragen beantwortet werden oder
+// * als FAQ uebergeben werden 
+// *---------------------------------------------------------------------------
+
+case "all":
+	$SQL="Select * from Questions ORDER BY QID DESC";
+?>
+	Alle Anfragen:<br>
+        <table  width="100%" class="border" cellpadding="2" cellspacing="1">
+                <tr class="contenttopic">
+			<th>Frage</th>
+			<th>Anfragender</th>
+                        <th>Beantwortet?</th>
+                        <th>Antwort</th>
+                        <th>Antwort von</th>
+			<th>change</th>
+                </tr>
+
+<?
+
+        $Erg = mysql_query($SQL, $con);
+        // anzahl zeilen
+        $Zeilen  = mysql_num_rows($Erg);
+        for ($n = 0 ; $n < $Zeilen ; $n++) {
+		echo "<tr class=\"content\">\n";
+		echo "<td>".mysql_result($Erg, $n, "Question")."</td>\n";
+		echo "<td>".UID2Nick(mysql_result($Erg, $n, "UID"))."</td>\n";
+		echo "<td>";
+		if (mysql_result($Erg, $n, "AID")>0) { 
+			echo "Ja</td>\n";
+			echo "<td>".mysql_result($Erg, $n, "Answer")."</td>\n";
+			echo "<td>".UID2Nick(mysql_result($Erg, $n, "AID"))."</td>\n";
+		} else {
+			echo "Nein</td>\n";
+			echo "<td>&nbsp;</td>\n";
+			echo "<td>&nbsp;</td>\n";
+		}
+				echo "<td><a href=\"faq.php?quest=edit&QID=".mysql_result($Erg, $n, "QID")."\">xxx</a></td>";
+		echo "</tr>\n";
+	}
+	echo "</table>\n";
+	break;
+case "open":
+	$SQL="Select * from Questions where AID = \"0\" ORDER BY QID DESC";
+	$quest_bearb=1; // Fragenliste anzeigen
+?>
+		Offene Anfragen:<br>
+<?php
+	break;
+case "edit":
+	$quest_bearb=0; // keine Fragenliste anzeigen, Frage editieren...
+	if (!IsSet($_GET["QID"])){
+?>
+		Fehlerhafter Aufruf...<br>Bitte die Bearbeitung nochmals beginnen :)
+<?php
+	} else {
+	$SQL = "SELECT * FROM Questions where QID=". $_GET["QID"];
+	$Erg = mysql_query($SQL, $con);
+?>
+	<form action="./faq.php" method="GET">
+		Anfrage von <b><?php echo UID2NICK(mysql_result($Erg, 0, "UID")); ?></b>:<br>
+		<textarea name="Question" rows="3" cols="80"><?php echo mysql_result($Erg, 0, "Question"); ?></textarea>
+		<br><br>
+		Antwort der Erzengel:<br>
+<?php
+	if (mysql_result($Erg, 0, "Answer")=="") {
+?>
+		<textarea name="Answer" rows="5" cols="80">Bitte hier die Antwort eintragen...</textarea>
+		<br>
+<?php 
+	} else {
+?>
+		<textarea name="Answer" rows="5" cols="80"><?php echo mysql_result($Erg, 0, "Answer"); ?></textarea>
+		<br>
+<?php
+	}
+?>
+		<input type="hidden" name="QID" value="<? echo $_GET["QID"]; ?>">
+		<input type="hidden" name="quest" value="save">
+		<input type="submit" value="Sichern...">
+	</form>
+	Wenn diese Anfrage bereits beantwortet wurde, kannst du diese so wie sie ist als Engel-FAQ eintrag &uuml;bernehmen.<br>
+	In diesem Falle erscheint hier der Link: 
+<?php
+	if (mysql_result($Erg, 0, "AID")<>"0") {
+?>
+	<a href="./faq.php?quest=transfer&QID=<?php echo $QID; ?>">Als FAQ-Eintrag sichern...</a>
+<?php
+	}
+	
+	} // Abfrage der QID
+	break;
+
+case "save":
+	if (!IsSet($_GET["QID"])){
+?>
+	  Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...
+<?php
+        } else {
+	  $SQL = "UPDATE Questions SET Question=\"". $_GET["Question"]. 
+	  	 "\", AID=\"". $_SESSION['UID']. "\" , Answer=\"". $_GET["Answer"]. "\" ".
+		 "where QID = \"". $_GET["QID"]. "\" LIMIT 1";
+          $Erg = mysql_query($SQL, $con);
+          if ($Erg == 1) {
+?>
+		Der Eintrag wurde ge&auml;ndert<br>
+<?php
+          } else {
+?>
+		Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)
+<?php
+	  }
+        }
+	break;
+
+case "transfer":
+	if (!IsSet($_GET["QID"])){
+?>
+	  Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...
+<?php
+        } else {
+	
+		$SQL1="Select * from Questions where QID=". $_GET["QID"];
+		$Erg = mysql_query($SQL1, $con);
+		$SQL2="Insert into FAQ Values (\"\", \"".
+			mysql_result($Erg, 0, "Question")."\", \"".mysql_result($Erg, 0, "Answer")."\")";
+		$Erg = mysql_query($SQL2, $con);
+		if ($Erg == 1) {
+?>
+			Der Eintrag wurde &uuml;bertragen.<br>
+<?php
+	        } else {
+?>
+			Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)
+<?php
+	        }
+	}
+	
+	break;
+
+// *---------------------------------------------------------------------------
+// * FAQ - Bearbeitung
+// *---------------------------------------------------------------------------
+// * je nach Übergabeoption ($quest) koennen FAQ's erfasst werden,
+// * geaendert oder geloscht werden...
+// *---------------------------------------------------------------------------
+
+
+case "faq":
+	$quest_bearb=0; // keine Fragenliste anzeigen, FAQ editieren...
+?>
+	FAQ-Liste:<br>
+	<a href="./faq.php?quest=faqnew">Neuen Eintrag</a>
+<?php
+	$SQL = "SELECT * FROM `FAQ`";
+	$Erg = mysql_query($SQL, $con);
+
+	// anzahl zeilen
+	$Zeilen  = mysql_num_rows($Erg);
+
+	for ($n = 0 ; $n < $Zeilen ; $n++) {
+	  if (mysql_result($Erg, $n, "Antwort")!="") {
+?>
+	      <p class='question'><?php echo mysql_result($Erg, $n, "Frage"); ?></p>
+	      <p class='answetion'><?php echo mysql_result($Erg, $n, "Antwort"); ?></p>
+              <a href="./faq.php?quest=faqedit&FAQID=<?php echo mysql_result($Erg, $n, "FID"); ?>">Bearbeiten</a>
+              <br>---<br>
+<?php 
+}
+	}
+	break;
+
+case "faqedit":
+       if (!IsSet($_GET["FAQID"]))
+       {
+?>
+	 Fehlerhafter Aufruf...<br>Bitte die Bearbeitung nochmals beginnen :)
+<?php
+	} else {
+
+	$SQL = "SELECT * FROM FAQ where FID=". $_GET["FAQID"];
+	$Erg = mysql_query($SQL, $con);
+
+	// anzahl zeilen
+	$Zeilen  = mysql_num_rows($Erg);
+?>
+	<form action="./faq.php" method="GET">
+		Frage:<br>
+	<textarea name="Frage" rows="3" cols="80"><?php echo mysql_result($Erg, 0, "Frage"); ?></textarea>
+	<br><br>
+	Antwort:<br>
+	<textarea name="Antwort" rows="5" cols="80"><?php echo mysql_result($Erg, 0, "Antwort"); ?></textarea><br>
+	<input type="hidden" name="FAQID" value="<? echo $_GET["FAQID"]; ?>">
+	<input type="hidden" name="quest" value="faqsave">
+	<input type="submit" value="Sichern...">
+	</form>
+	<form action="./faq.php">	
+        <input type="hidden" name="FAQID" value="<? echo $_GET["FAQID"]; ?>">
+        <input type="hidden" name="quest" value="faqdelete">
+        <input type="submit" value="L&ouml;schen...">
+	</form>
+<?php 
+	}
+	break;
+
+case "faqdelete";
+	if (!IsSet($_GET["FAQID"]))
+	{
+?>
+		Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...
+<?php 
+	} else {
+		$SQL = "delete from FAQ where FID = \"". $_GET["FAQID"]. "\" LIMIT 1";
+		$Erg = mysql_query($SQL, $con);
+		if ($Erg == 1) {
+?>
+			Der Eintrag wurde gel&ouml;scht<br>
+<?php
+		} else {
+?>
+			Ein Fehler ist aufgetreten. Ist der Eintag bereits gel&ouml;scht gewesen?
+<?php
+		}
+	}
+	break;
+
+case "faqsave";
+        if (!IsSet($_GET["FAQID"]))
+	{
+?>
+	  Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...
+<?php
+        } else {
+          $SQL = "UPDATE FAQ SET Frage=\"". $_GET["Frage"]. "\", Antwort=\"". $_GET["Antwort"]. 
+	  	 "\" where FID = \"". $_GET["FAQID"]. "\" LIMIT 1";
+          $Erg = mysql_query($SQL, $con);
+          if ($Erg == 1) {
+?>
+		Der Eintrag wurde ge&auml;ndert<br>
+<?php
+          } else {
+?>
+		Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)
+<?php
+	  }
+        }
+	break;
+
+case "faqnew":
+?>
+	<form action="./faq.php" method="GET">
+        Frage:<br>
+        <textarea name="Frage" rows="3" cols="80">Frage...</textarea><br><br>
+        Antwort:<br>
+	<textarea name="Antwort" rows="5" cols="80">Antwort</textarea><br>
+        <input type="hidden" name="quest" value="faqnewsave">
+        <input type="submit" value="Sichern...">
+        </form>
+<?php
+	break;
+case "faqnewsave";
+        $SQL = "INSERT INTO FAQ VALUES (\"\", \"". $_GET["Frage"]. "\", \"". $_GET["Antwort"]. "\")";
+        $Erg = mysql_query($SQL, $con);
+        if ($Erg == 1) {
+?>
+		Der Eintrag wurde erfasst.<br>
+<?php
+        } else {
+?>
+		Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)
+<?php
+	}
+        break;
+
+}
+
+// Hilfsroutine für die Anfragen:
+// Fragenliste anzeigen???
+
+if ($quest_bearb==1) {
+
+	$Erg = mysql_query($SQL, $con);
+	// anzahl zeilen
+	$Zeilen  = mysql_num_rows($Erg);
+
+	if ($Zeilen==0){
+?>
+		keine vorhanden...
+<?php 
+	} else {
+		for ($n = 0 ; $n < $Zeilen ; $n++) {
+?>
+<p>
+<?php echo nl2br(mysql_result($Erg, $n, "Question"))."\n"; ?>
+</p>
+			<br>
+			<a href="./faq.php?quest=edit&QID=<?php echo mysql_result($Erg, $n, "QID"); ?>">Bearbeiten</a>
+			<br>---<br>
+<?php
+		}
+	}
+
+	
+}
+
+} else {
+
+?>
+Bitte w&auml;hle aus, ob du:
+
+<ul>
+	<li><a href="./faq.php?quest=all">Alle Anfragen anzeigen/bearbeiten m&ouml;chtest</a></li>
+	<li><a href="./faq.php?quest=open">Alle offenen Anfragen anzeigen/bearbeiten m&ouml;chtest</a></li>
+	<li><a href="./faq.php?quest=faq">Die FAQ's anzeigen/bearbeiten</a></li>
+</ul>
+
+<?php
+
+}
+
+include ("./inc/footer.php");
+?>
diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php
new file mode 100755
index 00000000..1e7bd259
--- /dev/null
+++ b/www-ssl/admin/free.php
@@ -0,0 +1,108 @@
+<?PHP
+
+$title = "Erzengel";
+$header = "Freie Engel";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.php");
+
+
+echo "Hallo ".$_SESSION['Nick'].",<br>\n";
+
+?>
+hier findest du alle Engel, welche zur Zeit in Schichten verplant sind:
+<br><br>
+
+
+<?
+#######################################################
+# 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() );";		
+
+//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=\"./user.php?Type=Normal&enterUID=". mysql_result($Erg, $i, "UID"). "\">". 
+		mysql_result($Erg, $i, "Nick"). "</td></a>\n";
+	echo "<td>". UID2Nick(mysql_result($Erg, $i, "UID")). "</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=\"./user.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 ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/inc b/www-ssl/admin/inc
new file mode 120000
index 00000000..22dc542a
--- /dev/null
+++ b/www-ssl/admin/inc
@@ -0,0 +1 @@
+../inc
\ No newline at end of file
diff --git a/www-ssl/admin/index.php b/www-ssl/admin/index.php
new file mode 100755
index 00000000..c7ae3a14
--- /dev/null
+++ b/www-ssl/admin/index.php
@@ -0,0 +1,19 @@
+<?PHP
+
+$title = "Erzengel";
+$header = "Index";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+
+echo "Hallo Erzengel ".$_SESSION['Nick'].",<br>\n";
+
+?>
+
+du bist jetzt im Erzengel-Bereich. Hier kannst du die Engel-Verwaltung vornehmen.<br><br>
+
+Bitte melde dich <a href="../logout.php">hier</a> nach getaner Arbeit immer ab, damit kein anderer hier &Auml;nderungen vornehmen kann.
+
+<?
+include ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/list.php b/www-ssl/admin/list.php
new file mode 100755
index 00000000..6ae8a336
--- /dev/null
+++ b/www-ssl/admin/list.php
@@ -0,0 +1,34 @@
+<?PHP
+
+$title = "Debug-Liste";
+$header = "Datenbank-Auszug";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+
+
+/*
+echo "<h1>Raeume</h1> <br>";
+funktion_db_list("Raeume");
+
+echo "<h1>Schichtbelegung</h1> <br>";
+funktion_db_list("Schichtbelegung");
+
+echo "<h1>Schichtplan</h1> <br>Hier findest du alle bisher eingetragenen Schichten:";
+funktion_db_list("Schichtplan");
+
+echo "<h1>User</h1> <br>";
+funktion_db_list("User");
+
+echo "<h1>News</h1> <br>";
+funktion_db_list("News");
+
+echo "<h1>FAQ</h1> <br>";
+funktion_db_list("FAQ");
+
+*/
+
+echo "Deaktiviert";
+
+include ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/menu.php b/www-ssl/admin/menu.php
new file mode 100755
index 00000000..bd0761ed
--- /dev/null
+++ b/www-ssl/admin/menu.php
@@ -0,0 +1,46 @@
+<?PHP
+include ("./inc/funktion_faq.php");
+
+$Menu["Path"] = "admin/";
+$Menu["Name"] = "Kategorie";
+$Menu["Entry"][1]["File"] = "room.php";
+$Menu["Entry"][1]["Name"] = "R&auml;ume";
+$Menu["Entry"][12]["File"] = "EngelType.php";
+$Menu["Entry"][12]["Name"] = "Engeltypen";
+$Menu["Entry"][2]["File"] = "schichtplan.php";
+$Menu["Entry"][2]["Name"] = "Schichtplan";
+$Menu["Entry"][2]["Line"] = "<br>";
+$Menu["Entry"][3]["File"] = "dbUpdateFromXLS.php";
+$Menu["Entry"][3]["Name"] = "UpdateDB";
+$Menu["Entry"][13]["File"] = "dect.php";
+$Menu["Entry"][13]["Name"] = "Dect";
+$Menu["Entry"][13]["Line"] = "<br>";
+$Menu["Entry"][4]["File"] = "user.php";
+$Menu["Entry"][4]["Name"] = "Engelliste";
+$Menu["Entry"][5]["File"] = "aktiv.php";
+$Menu["Entry"][5]["Name"] = "Aktivliste";
+$Menu["Entry"][6]["File"] = "tshirt.php";
+$Menu["Entry"][6]["Name"] = "T-Shirtausgabe";
+$Menu["Entry"][6]["Line"] = "<br><br>";
+$Menu["Entry"][7]["File"] = "news.php";
+$Menu["Entry"][7]["Name"] = "News-Verwaltung";
+$Menu["Entry"][8]["File"] = "faq.php";
+$Menu["Entry"][8]["Name"] = "FAQ (". noAnswer(). ")";
+$Menu["Entry"][9]["File"] = "free.php";
+$Menu["Entry"][9]["Name"] = "Freie Engel";
+$Menu["Entry"][9]["Line"] = "<br><br>";
+$Menu["Entry"][11]["File"] = "sprache.php";
+$Menu["Entry"][11]["Name"] = "Language";
+$Menu["Entry"][11]["Line"] = "<br><br>";
+$Menu["Entry"][10]["File"] = "list.php";
+$Menu["Entry"][10]["Name"] = "Debug";
+
+if ($_SESSION['CVS']["MenueShowAdminSection"] == "Y") {
+        $MenuAdmin["Name"] = "Erzengel";
+        $MenuAdmin["Entry"][0]["File"] = "../nonpublic/index.php";
+        $MenuAdmin["Entry"][0]["Name"] = "Engel-Men&uuml;";
+} // MenueShowAdminSection
+			
+
+
+?>
diff --git a/www-ssl/admin/news.php b/www-ssl/admin/news.php
new file mode 100755
index 00000000..7c501751
--- /dev/null
+++ b/www-ssl/admin/news.php
@@ -0,0 +1,109 @@
+<?PHP
+
+$title = "Newsverwaltung";
+$header = "Verwaltung der News";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.php");
+
+
+if (!IsSet($_GET["action"])) {
+
+$SQL = "SELECT * from News order by Datum DESC";
+$Erg = mysql_query($SQL, $con);
+
+$rowcount = mysql_num_rows($Erg);
+?>
+Hallo <? echo $_SESSION['Nick'] ?>, <br>
+hier kannst du die News s&auml;bern... falls jemand auf die Idee kommt, 
+hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)<br><br>
+
+<table width="100%" class="border" cellpadding="2" cellspacing="1">
+        <tr class="contenttopic">
+         <td>Datum</td>
+         <td>Betreff</td>
+         <td>Text</td>
+         <td>Erfasser</td>
+         <td>Engeltreff</td>
+	 <td>&Auml;nd.</td>
+	</tr>
+<?				  
+
+for ($i=0; $i < $rowcount; $i++) {
+	echo "\t<tr class=\"content\">\n";
+	echo "\t <td>".mysql_result($Erg, $i, "Datum")."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Betreff")."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Text")."</td>";
+	echo "\t <td>".UID2Nick(mysql_result($Erg, $i, "UID"))."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Treffen")."</td>";
+	echo "\t <td><a href=\"./news.php?action=change&date=".mysql_result($Erg, $i, "Datum")."\">XXX</a></td>";
+	echo "\t</tr>\n";
+}
+echo "</table>";
+
+
+} else {
+
+switch ($_GET["action"]) 
+{
+
+case 'change':
+	$SQL = "SELECT * from News where (Datum='". $_GET["date"]. "')";
+	$Erg = mysql_query($SQL, $con);
+
+	echo "<form action=\"./news.php\" method=\"GET\">\n";
+
+	echo "<table>\n";
+	echo "  <tr><td>Datum</td><td><input type=\"text\" size=\"40\" name=\"date\" value=\"".
+		mysql_result($Erg, 0, "Datum")."\" disabled></td></tr>\n";
+	echo "  <tr><td>Betreff</td><td><input type=\"text\" size=\"40\" name=\"eBetreff\" value=\"".
+		mysql_result($Erg, 0, "Betreff")."\"></td></tr>\n";
+	echo "  <tr><td>Text</td><td><textarea rows=\"10\" cols=\"80\" name=\"eText\">".
+		mysql_result($Erg, 0, "Text")."</textarea></td></tr>\n";
+	echo "  <tr><td>Engel</td><td><input type=\"text\" size=\"40\" name=\"eUser\" value=\"".
+		UID2Nick(mysql_result($Erg, 0, "UID"))."\" disabled></td></tr>\n";
+	echo "  <tr><td>Treffen</td><td><input type=\"text\" size=\"40\" name=\"eTreffen\" value=\"".
+		mysql_result($Erg, 0, "Treffen")."\"></td></tr>\n";
+	echo "</table>";
+
+        echo "<input type=\"hidden\" name=\"date\" value=\"". $_GET["date"]. "\">\n";
+	echo "<input type=\"hidden\" name=\"action\" value=\"change_save\">\n";
+	echo "<input type=\"submit\" value=\"Abschicken...\">\n";
+	echo "</form>";
+
+	echo "<form action=\"./news.php?action=delete\" method=\"POST\">\n";
+	echo "<input type=\"hidden\" name=\"date\" value=\"". $_GET["date"]. "\">\n";
+	echo "<input type=\"submit\" value=\"l&ouml;schen...\">\n";
+	echo "</form>";
+
+	break;
+
+case 'change_save':
+	$chsql="UPDATE News set Betreff = \"". $_GET["eBetreff"]. "\", Text = \"". $_GET["eText"]. 
+		"\", Treffen=". $_GET["eTreffen"]. " where (Datum = '". $_GET["date"]. "') limit 1";
+	break;
+
+case 'delete':
+        $chsql="DELETE from News where Datum = '". $_POST["date"]. "' limit 1";
+	break;
+}
+
+if (IsSet($chsql)) {
+// SQL-Statement ausführen...
+	$Erg = mysql_query($chsql, $con);
+	If ($Erg == 1)
+	{
+		echo "&Auml;nderung erfolgreich gesichert...";
+	} 
+	else 
+	{
+		echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)<br><br>\n";
+		echo mysql_error($con);
+		echo "<br><br>\n[$chsql]";
+	}
+}
+
+}
+include ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/pic b/www-ssl/admin/pic
new file mode 120000
index 00000000..a21de85f
--- /dev/null
+++ b/www-ssl/admin/pic
@@ -0,0 +1 @@
+../pic
\ No newline at end of file
diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php
new file mode 100755
index 00000000..3b8cb63c
--- /dev/null
+++ b/www-ssl/admin/room.php
@@ -0,0 +1,184 @@
+<?php
+$title = "R&auml;ume";
+$header = "Verwaltung der R&auml;ume";
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+include ("./inc/funktion_schichtplan.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++ )
+	{
+		//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 = $HTTP_GET_VARS;
+	$count = count($vars) - 1;
+	$vars = array_splice($vars, 0, $count);
+	$Keys = "";
+	$Values = "";
+	foreach($vars as $key => $value)
+	{
+		$Keys   .= ", `$key`";
+		$Values .= ", '$value'";
+	}
+	
+	//ermitteln des letzten eintrages
+	$SQLin = "SELECT `RID` FROM `Room` ".
+		 "WHERE NOT (`FromPentabarf` = 'Y') ".
+		 "ORDER BY `RID` DESC";
+	$Ergin = mysql_query($SQLin, $con);
+	if( mysql_num_rows( $Ergin) > 0)
+		$RID = mysql_result( $Ergin, 0, 0)+1;
+	else
+		$RID = 10000;
+	
+	$SQL  = "INSERT INTO `Room` (`RID`$Keys) VALUES ( '$RID'$Values)";
+	SetHeaderGo2Back();
+	break;
+
+case 'change':
+	if (! IsSet($_GET["RID"])) {
+		echo "Fehlerhafter Aufruf!"; 
+	} else {
+
+	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";
+	
+	$SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'";
+	$ERG = mysql_query($SQL2, $con);
+        
+        for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++)
+	{
+		//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 "<tr><td>$FeldName</td>".
+		     "<td><input type=\"text\" size=\"40\" name=\"e".mysql_field_name($ERG, $Uj)."\" ".
+		     "value=\"".mysql_result($ERG, 0, $Uj)."\">";
+		echo"</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>";
+	}
+	break;
+	
+case 'changesave':
+	$sql="";
+        $vars = $HTTP_GET_VARS;
+        $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 = 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								
+
+} //IF IsSet($action)
+
+include ("./inc/footer.php");
+?>
diff --git a/www-ssl/admin/schichtplan.1.php b/www-ssl/admin/schichtplan.1.php
new file mode 100755
index 00000000..30761390
--- /dev/null
+++ b/www-ssl/admin/schichtplan.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/admin/schichtplan.php b/www-ssl/admin/schichtplan.php
new file mode 100755
index 00000000..9e7ec81b
--- /dev/null
+++ b/www-ssl/admin/schichtplan.php
@@ -0,0 +1,291 @@
+<?php
+$title = "Schichtplan";
+$header = "Neue Schichten erfassen";
+$submenus = 1;
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+
+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";
+
+?>
+<table width="100%" class="border" cellpadding="2" cellspacing="1">
+	<tr class="contenttopic">
+		<td>Datum</td>
+		<td>Raum</td>
+		<td>Dauer</td>
+		<td>&Auml;ndern</td>
+	</tr>
+<?
+
+$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>".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>";
+
+
+} 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` FROM `Room`";
+        $Erg2 = mysql_query($sql2, $con);
+	$rowcount = mysql_num_rows($Erg2);
+	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";
+		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 "</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";
+	for ($j=0; $j < $rowcount; $j++)
+	{
+		$userUID=mysql_result($Erg3, $j, "UID");
+		echo "<a href=\"./schichtplan.php?action=engeldel&SID=". $_GET["SID"]. "&UIDs=$userUID\">". 
+			UID2Nick($userUID).
+			" (". TID2Type(mysql_result($Erg3, $j, "TID")). Get_Text("inc_schicht_Engel").
+			") austragen</a><br>\n";
+	} // FOR
+
+	echo "<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";
+	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 "</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']."' ";
+			$chSQL .= "WHERE (`SID`='". $_GET["SID"]. "' AND ".
+				  "`TID`='". $_GET["TID"]. "' AND `UID`='0' ) LIMIT 1";
+		}
+		else
+		{
+			$chSQL  = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (";
+			$chSQL .= "'". $_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
+	{
+		$chSQL  = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (";
+		$chSQL .= "'". $_GET["SID"]. "', '". $_GET["TID"]. "', '0', NULL)";
+		echo "Es wird eine weitere Schicht eingetragen:<br>\n";
+	}
+	break;
+
+case 'engeldel':
+	$chSQL = "UPDATE `ShiftEntry` SET `UID`='0', `Comment`= 'NULL' WHERE (`SID`='". $_GET["SID"]. 
+		 "' AND `UID`='". $_GET["UIDs"]. "') LIMIT 1"; 
+	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"]. "' 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;
+
+} // 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 ("./inc/footer.php");
+?>
diff --git a/www-ssl/admin/schichtplan_druck.1.php b/www-ssl/admin/schichtplan_druck.1.php
new file mode 100755
index 00000000..30761390
--- /dev/null
+++ b/www-ssl/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/admin/schichtplan_druck.php b/www-ssl/admin/schichtplan_druck.php
new file mode 100755
index 00000000..a6ec2dbd
--- /dev/null
+++ b/www-ssl/admin/schichtplan_druck.php
@@ -0,0 +1,169 @@
+<?php
+$title = "Himmel";
+$header = "Schichtpl&auml;ne";
+$submenus = 1;
+
+
+if (!IsSet($action)) {
+include ("./inc/header.php");
+include ("./inc/funktionen.php");
+
+include ("./inc/funktion_schichtplan.php");
+include ("./inc/funktion_user.php");
+
+
+?>
+
+Hallo <? echo $_SESSION['Nick']?>,<br>
+auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. W&auml;hle hierf&uuml;r ein Datum und den Raum:
+<br><br>
+<form action="./schichtplan_druck.php" method="post" target="_print">
+<input type="hidden" name="action" value="1">
+
+
+<table>
+	<tr>
+		<td align="right">Datum:</td>
+		<td align="left">
+			<select name="ausdatum">
+<?
+$SQL = "SELECT DateS FROM `Shifts` ORDER BY 'DateS'";
+$Erg = mysql_query($SQL, $con);
+if (!isset($ausdatum)) 
+	$ausdatum = substr(mysql_result($Erg, $i , 0), 0,10);
+
+for ($i = 0 ; $i < mysql_fetch_row($Erg) ; $i++) 
+{
+	if ($tmp != substr(mysql_result($Erg, $i , 0), 0,10)) 
+	{
+		$tmp =  substr(mysql_result($Erg, $i , 0), 0,10);
+		echo "\t\t\t\t<option value=\"$tmp\">$tmp</option>\n";
+	}
+} 
+
+?>
+			</select>
+		</td>
+	</tr>
+	<tr>
+		<td align="right">Raum:</td>
+		<td align="left">
+			<select name="Raum">
+<?php 
+
+$res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY Name;",$con);
+
+for ($i = 0; $i < mysql_num_rows($res); $i++) 
+{
+	$rid=mysql_result($res,$i,"RID");
+	$raum_name=mysql_result($res, $i, "Name");
+	echo "\t\t\t\t<option value=\"$rid\">$raum_name</option>\n";
+}
+
+
+?>
+			</select>
+		</td>
+	</tr>
+	
+</table>
+<br>
+<input type="submit" value="generieren...">
+</form>
+
+<br><br>
+<?
+
+include ("./inc/footer.php");
+
+} 
+else 
+{
+
+
+if (IsSet($Raum) AND IsSet($ausdatum)) 
+{
+include ("./inc/db.php");
+include ("./inc/config.php");
+include ("./inc/funktion_lang.php");
+include ("./inc/funktion_schichtplan.php");
+include ("./inc/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%"><? echo $date; ?></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%"><? 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>
+<?
+
+//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/admin/shiftadd.php b/www-ssl/admin/shiftadd.php
new file mode 100755
index 00000000..8b2f6451
--- /dev/null
+++ b/www-ssl/admin/shiftadd.php
@@ -0,0 +1,329 @@
+<?php
+$title = "Schicht Hinzufügen";
+$header = "Neue Schichten erfassen";
+
+include ("./inc/header.php");
+include ("./inc/funktion_user.php");
+
+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");
+	}
+
+
+if (!IsSet($_GET["action"])) 
+	$_GET["action"] = "new";
+
+$Time = time()+3600+3600;
+
+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="<? echo $_SERVER['SCRIPT_NAME']; ?>" >
+  <table>
+  <tr>
+    <td align="right">Name:</td>
+    <td><input type="text" name="SchichtName" size="50" value="--???--"></td>
+  </tr>
+  <tr>
+    <td align="right">Ort:</td>
+    <td><select name="RID">
+	<?
+	foreach ($Room As $RTemp) 
+		echo "\t<option value=\"". $RTemp["RID"]. "\">". $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="<?echo gmdate("Y-m", $Time)?>"></td>
+  </tr>
+  <tr>
+    <td align="right">Beginn:</td>
+    <td>Date<input type="text" name="SDatum" size="5" value="<?echo gmdate("d", $Time)?>">
+        Time<input type="text" name="STime" size="5" value="10"></td>
+  </tr>
+  <tr>
+    <td align="right">More then One</td>
+    <td><input type="checkbox" name="MoreThenOne" value="ON" checked></td>
+  </tr>
+  <tr>
+    <td align="right">End:</td>
+    <td>Date<input type="text" name="EDatum" size="5" value="<?echo gmdate("d", $Time)?>">
+        Time<input type="text" name="ETime" size="5" value="12"></td>
+  </tr>
+  <tr>
+    <td align="right">L&auml;nge in h:</td>
+    <td><input type="text" name="len" size="5" value="2"></td>
+  </tr>
+  <tr>
+    <td align="right">Sonderschichten ein:</td>
+    <td><input type="checkbox" name="NachtON" value="ON"></td>
+  </tr>
+  <tr>
+    <td align="right">Sonder in h (Time;Time):</td>
+    <td><input type="text" name="len_night" size="50" value="0;4;8;10;12;14;16;18;20;22;24"></td>
+  </tr>
+  
+  <tr><td><u>Anzahl Engel je Type:</u></td></tr>
+<?
+	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=\"0\"></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>
+
+<?
+	break; // Ende new
+
+case 'newsave':
+    if (isset($_GET["SDatum"]) && ($_GET["len"] > 0))
+    {
+	$lenOrg = $_GET["len"];
+	if( !isset($_GET["NachtON"])) 
+		$_GET["NachtON"] = "OFF";
+	if( $_GET["NachtON"] == "ON" )
+	{	
+		$lenArrayDummy = explode( ";", $_GET["len_night"]);
+                foreach ( $lenArrayDummy as $Temp )
+                {
+			if( isset($Temp2) )
+			{
+				$lenArray[$Temp2] = $Temp-$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 = $_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" )
+		{
+			$_GET["len"] = $lenArray[$Time];
+		}
+		$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 >= $_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" )   
+	{
+		//Suchet nach letzter SID
+		$SQLin = "SELECT `SID` FROM `Shifts` ".
+			 "WHERE NOT (`FromPentabarf` = 'Y') ".
+			 "ORDER BY `SID` DESC";
+		$Ergin = mysql_query($SQLin, $con);
+		if( mysql_num_rows( $Ergin) > 0)
+			$newSID = mysql_result( $Ergin, 0, 0)+1;
+		else
+			$newSID = 10000;
+		
+		// erstellt Eintrag in Shifts für die algemeine schicht
+		$SQL  = "INSERT INTO `Shifts` (`SID`, `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ('$newSID', ";
+		$SQL .= "'". $_DateS. "', '". $_DateE. "', ";
+		$SQL .= "'". $_GET["len"]. "', '". $_GET["RID"]. "', ";
+		$SQL .= "'". $_GET["SchichtName"]. "');";
+		$Erg = mysql_query($SQL, $con);
+
+		$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 ("./inc/footer.php");
+?>
diff --git a/www-ssl/admin/sprache.php b/www-ssl/admin/sprache.php
new file mode 100755
index 00000000..af5db2ba
--- /dev/null
+++ b/www-ssl/admin/sprache.php
@@ -0,0 +1,116 @@
+<?PHP
+
+$title = "Sprache";
+$header = "Liste der existierenden Sprcheintr&auml;ge";
+include ("./inc/header.php");
+
+
+if( !isset( $_GET["TextID"] )  )
+{
+	echo Get_Text("Hello").$_SESSION['Nick'].", <br>\n";
+	echo Get_Text("pub_sprache_text1")."<br><br>\n";
+	
+	// ausgabe Tabellenueberschift
+	$SQL_Sprachen = "SELECT `Sprache` FROM `Sprache` GROUP BY `Sprache`;";
+	$erg_Sprachen = mysql_query($SQL_Sprachen, $con);
+	echo mysql_error($con);
+	
+	for( $i=0; $i<mysql_num_rows( $erg_Sprachen ); $i++ )
+		$Sprachen[mysql_result( $erg_Sprachen, $i, "Sprache" )] = $i;
+
+	echo "\t<table border=\"0\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n\t\t<tr>";
+	echo "\t\t<td class=\"contenttopic\"><b>". Get_Text("pub_sprache_TextID"). "</b></td>";
+	foreach( $Sprachen as $Name => $Value )
+		echo "<td class=\"contenttopic\"><b>". 
+			Get_Text("pub_sprache_Sprache"). " ". $Name.
+			"</b></td>";
+	echo "\t\t<td class=\"contenttopic\"><b>". Get_Text("pub_sprache_Edit"). "</b></td>";
+	echo "\t\t</tr>";
+
+
+	// ausgabe eintraege
+	$SQL = "SELECT * FROM `Sprache` ORDER BY `TextID`;";
+	$erg = mysql_query($SQL, $con);
+	echo mysql_error($con);
+
+	$TextID_Old = mysql_result( $erg, 0, "TextID" );
+	for( $i=0; $i<mysql_num_rows( $erg ); $i++ )
+	{
+		$TextID_New = mysql_result( $erg, $i, "TextID" );
+		if( $TextID_Old != $TextID_New )
+		{
+			echo "<form action=\"sprache.php\">";
+			echo "<tr class=\"content\">\n";
+			echo "\t\t<td>$TextID_Old ".
+			     "<input name=\"TextID\" type=\"hidden\" value=\"$TextID_Old\"> </td>\n";
+		
+			foreach( $Sprachen as $Name => $Value )
+			{
+				echo "\t\t<td><textarea name=\"$Name\" cols=\"22\" rows=\"8\">$Value</textarea></td>\n";
+				$Sprachen[ $Name ] = "";
+			}
+			
+			echo "\t\t<td><input type=\"submit\" value=\"Save\"></td>\n";
+			echo "</tr>";
+			echo "</form>\n";
+			$TextID_Old = $TextID_New;
+		}
+		$Sprachen[ mysql_result( $erg, $i, "Sprache" ) ] = mysql_result( $erg, $i, "Text" );
+	} /*FOR*/
+	
+	//fuer neu eintraege
+	echo "<form action=\"sprache.php\">";
+	echo "<tr class=\"content\">\n";
+	echo "\t\t<td><input name=\"TextID\" type=\"text\" value=\"new\"> </td>\n";
+		
+	foreach( $Sprachen as $Name => $Value )
+		echo "\t\t<td><textarea name=\"$Name\" cols=\"22\" rows=\"8\">$Name Text</textarea></td>\n";
+
+	echo "\t\t<td><input type=\"submit\" value=\"Save\"></td>\n";
+	echo "</tr>";
+	echo "</form>\n";
+	
+	
+	echo "</table>\n";
+} /*if( !isset( $TextID )  )*/
+else
+{
+	echo "edit: ". $_GET["TextID"]. "<br><br>";
+	foreach ($_GET as $k => $v) {
+		if( $k != "TextID" ) 
+		{
+			$sql_test = "SELECT * FROM `Sprache` ".
+				"WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k'";
+			$erg_test = mysql_query($sql_test, $con);
+
+			if( mysql_num_rows($erg_test)==0 )
+			{
+				$sql_save = "INSERT INTO `Sprache` (`TextID`, `Sprache`, `Text`) ".
+					"VALUES ('". $_GET["TextID"]. "', '$k', '$v')";
+		        	$Erg = mysql_query($sql_save, $con);
+			        if ($Erg == 1)
+			                echo "\t $k Save: OK<br>\n";
+			        else
+		        	        echo "\t $k Save: KO<br>\n";
+			}
+			else if( mysql_result($erg_test, 0, "Text")!=$v )
+			{
+				$sql_save = "UPDATE `Sprache` SET `Text`='$v' ".
+					"WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k' ";
+				  echo $sql_save."<br>";
+		        	$Erg = mysql_query($sql_save, $con);
+			        if ($Erg == 1)
+			                echo "\t $k Update: OK<br>\n";
+			        else
+		        	        echo "\t $k Update: KO<br>\n";
+			}
+			else
+				echo "\t $k no changes<br>\n";
+		}
+	}
+	   
+}
+
+include ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/tshirt.php b/www-ssl/admin/tshirt.php
new file mode 100755
index 00000000..2a3ea500
--- /dev/null
+++ b/www-ssl/admin/tshirt.php
@@ -0,0 +1,60 @@
+<?PHP
+
+$title = "T-Shirt-Ausgabe";
+$header = "T-Shirt-Ausgabe f&uuml;r aktiven Engel";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.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:
+
+<?
+$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>
+<?
+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 ("./inc/footer.php");
+?>
+
diff --git a/www-ssl/admin/user.php b/www-ssl/admin/user.php
new file mode 100755
index 00000000..a1c2aa4b
--- /dev/null
+++ b/www-ssl/admin/user.php
@@ -0,0 +1,249 @@
+<?PHP
+
+$title = "User-Liste";
+$header = "Editieren der Engelliste";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+
+if (!IsSet($_GET["enterUID"]))
+{
+	// Userliste, keine UID uebergeben...
+
+	echo "<a href=\"../makeuser.php\">Neuen Engel eintragen</a><br><br>\n";
+
+	if( !isset($_GET["OrderBy"]) ) $_GET["OrderBy"] = "Nick";
+	$SQL = "SELECT * FROM User ORDER BY ". $_GET["OrderBy"]. " ASC";
+	$Erg = mysql_query($SQL, $con);
+	echo mysql_error($con);
+
+	// anzahl zeilen
+	$Zeilen  = mysql_num_rows($Erg);
+
+	echo "Anzahl Engel: $Zeilen<br><br>\n";
+
+	?><table width="100%" class="border" cellpadding="2" cellspacing="1"> 
+	<tr class="contenttopic">
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Nick">Nick</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Name">Name</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Vorname">Vorname</a></td>
+		<td>Alter</td>
+		<td>Telefon <a href="<? echo $PHP_SELF; ?>?OrderBy=email">@</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Size">Gr&ouml;&szlig;e</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Gekommen">G</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Aktiv">A</a></td>
+		<td><a href="<? echo $PHP_SELF; ?>?OrderBy=Tshirt">T</a></td>
+		<td>&Auml;nd.</td>
+		<td>Secure</td>
+	</tr>
+
+
+	<?
+	$Gekommen = 0;
+	$Active = 0;
+	$Tshirt = 0;
+	
+	for ($n = 0 ; $n < $Zeilen ; $n++) {
+		echo "<tr class=\"content\">\n";
+		echo "\t<td>".mysql_result($Erg, $n, "Nick"). "</td>\n";
+		echo "\t<td>".mysql_result($Erg, $n, "Name")."</td>\n";
+		echo "\t<td>".mysql_result($Erg, $n, "Vorname")."</td>\n";
+		echo "\t<td>".mysql_result($Erg, $n, "Alter")."</td>\n";
+		echo "\t<td>";
+			if( strlen( mysql_result($Erg, $n, "Telefon"))>0)
+				echo "\n\t\tTel: ". mysql_result($Erg, $n, "Telefon"). "<br>";
+			if( strlen( mysql_result($Erg, $n, "Handy"))>0)
+				echo "\n\t\tHandy: ". mysql_result($Erg, $n, "Handy"). "<br>";
+			if( strlen( mysql_result($Erg, $n, "DECT"))>0)
+				echo "\n\t\tDECT: <a href=\"./dect.php?custum=". mysql_result($Erg, $n, "DECT"). "\">".
+					mysql_result($Erg, $n, "DECT"). "</a><br>";
+			if( strlen( mysql_result($Erg, $n, "email"))>0)
+				echo "\n\t\temail: <a href=\"mailto:".mysql_result($Erg, $n, "email")."\">".
+					mysql_result($Erg, $n, "email")."</a>";
+			echo "</td>\n";
+		echo "\t<td>".mysql_result($Erg, $n, "Size")."</td>\n";
+		$Gekommen += mysql_result($Erg, $n, "Gekommen");
+		echo "\t<td>".mysql_result($Erg, $n, "Gekommen")."</td>\n";
+		$Active += mysql_result($Erg, $n, "Aktiv");
+		echo "\t<td>".mysql_result($Erg, $n, "Aktiv")."</td>\n";
+		$Tshirt += mysql_result($Erg, $n, "Tshirt");
+		echo "\t<td>".mysql_result($Erg, $n, "Tshirt")."</td>\n";
+		echo "\t<td><a href=\"./user.php?enterUID=".
+			mysql_result($Erg, $n, "UID")."&Type=Normal\">&Auml;nd.</a></td>\n";
+		echo "\t<td>";
+		
+		//check userCVS=OK
+		$SQL2 = "SELECT UID FROM UserCVS WHERE (UID=". mysql_result($Erg, $n, "UID"). ")";
+		$Erg2 = mysql_query($SQL2, $con);
+		echo mysql_error($con);
+		if( mysql_num_rows($Erg2)==0)
+		{
+			$SQL3 = "INSERT INTO `UserCVS` ( `UID`) VALUES ( '". mysql_result($Erg, $n, "UID"). "');";
+			$Erg3 = mysql_query($SQL3, $con);
+			if( $Erg3 )
+				echo "was create<br>\n";
+			else
+				echo mysql_error($con);
+		}
+		echo "<a href=\"./user.php?enterUID=".
+			mysql_result($Erg, $n, "UID")."&Type=Secure\">Secure</a></td>\n";
+		echo "</tr>\n";
+	}
+	echo "<tr>".
+		"<td></td><td></td><td></td><td></td><td></td><td></td>".
+		"<td>$Gekommen</td><td>$Active</td><td>$Tshirt</td><td></td></tr>\n";
+	echo "\t</table>\n";
+	// Ende Userliste
+} 
+else 
+{ 
+	// UserID wurde mit uebergeben --> Aendern...
+
+	$SQL = "SELECT * FROM User where UID=". $_GET["enterUID"];
+	$Erg = mysql_query($SQL, $con);
+
+	$anzahl  = mysql_num_rows($Erg);
+
+	if ($anzahl != 1) 
+		echo "Sorry, der Engel (UID=". $_GET["enterUID"]. ") wurde in der Liste nicht gefunden.";
+	else
+	{
+		echo "Hallo,<br>".
+		 	"hier kannst du den Eintrag &auml;ndern. Unter dem Punkt 'Gekommen' ".
+			"wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ".
+			"dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ".
+			"Wenn T-Shirt ein 'Ja' enth&auml;lt, bedeutet dies, dass der Engel ".
+			"bereits sein T-Shirt erhalten hat.<br><br>\n";
+
+		echo "<form action=\"./user2.php?action=change\" method=\"POST\">\n";
+		echo "<table>\n";
+		echo "<input type=\"hidden\" name=\"Type\" value=\"". $_GET["Type"]. "\">\n";
+
+		if( $_GET["Type"] == "Normal" )
+		{
+			echo "  <tr><td>Nick</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eNick\" value=\"".
+				mysql_result($Erg, 0, "Nick")."\"></td></tr>\n";
+			echo "  <tr><td>lastLogIn</td><td>".
+				"<input type=\"text\" size=\"20\" name=\"elastLogIn\" value=\"".
+				mysql_result($Erg, 0, "lastLogIn"). "\" disabled></td></tr>\n";
+			echo "  <tr><td>Name</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eName\" value=\"".
+				mysql_result($Erg, 0, "Name")."\"></td></tr>\n";
+			echo "  <tr><td>Vorname</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eVorname\" value=\"".
+				mysql_result($Erg, 0, "Vorname")."\"></td></tr>\n";
+			echo "  <tr><td>Alter</td><td>".
+				"<input type=\"text\" size=\"5\" name=\"eAlter\" value=\"".
+				mysql_result($Erg, 0, "Alter")."\"></td></tr>\n";
+			echo "  <tr><td>Telefon</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eTelefon\" value=\"".
+				mysql_result($Erg, 0, "Telefon")."\"></td></tr>\n";
+			echo "  <tr><td>Handy</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eHandy\" value=\"".
+				mysql_result($Erg, 0, "Handy")."\"></td></tr>\n";
+			echo "  <tr><td>DECT</td><td>".
+				"<input type=\"text\" size=\"4\" name=\"eDECT\" value=\"".
+				mysql_result($Erg, 0, "DECT")."\"></td></tr>\n";
+			echo "  <tr><td>email</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"eemail\" value=\"".
+				mysql_result($Erg, 0, "email")."\"></td></tr>\n";
+			echo "  <tr><td>Size</td><td>".
+				"<input type=\"text\" size=\"5\" name=\"eSize\" value=\"".
+				mysql_result($Erg, 0, "Size")."\"></td></tr>\n";
+			echo "  <tr><td>Passwort</td><td>".
+				"<input type=\"text\" size=\"40\" name=\"ePasswort\" value=\"".
+				mysql_result($Erg, 0, "Passwort")."\" disabled> ".
+				"<a href=\"./user2.php?action=newpw&eUID="
+				.mysql_result($Erg, 0, "UID")."\">neues Kennwort setzen</a></td></tr>\n";
+  
+			// Gekommen? 
+			echo "  <tr><td>Gekommen</td><td>\n";
+			echo "      <input type=\"radio\" name=\"eGekommen\" value=\"0\"";
+			if (mysql_result($Erg, 0, "Gekommen")=='0') 
+				echo " checked"; 
+			echo ">No \n";
+			echo "      <input type=\"radio\" name=\"eGekommen\" value=\"1\"";
+			if (mysql_result($Erg, 0, "Gekommen")=='1') 
+				echo " checked";
+			echo ">Yes \n";
+			echo "</td></tr>\n";
+
+			// Aktiv?
+			echo "  <tr><td>Aktiv</td><td>\n";
+			echo "      <input type=\"radio\" name=\"eAktiv\" value=\"0\"";
+			if (mysql_result($Erg, 0, "Aktiv")=='0') 
+				echo " checked";
+			echo ">No \n";
+			echo "      <input type=\"radio\" name=\"eAktiv\" value=\"1\"";
+			if (mysql_result($Erg, 0, "Aktiv")=='1') 
+				echo " checked"; 
+			echo ">Yes \n";
+			echo "</td></tr>\n";
+
+			// T-Shirt bekommen? 
+			echo "  <tr><td>T-Shirt</td><td>\n";
+			echo "      <input type=\"radio\" name=\"eTshirt\" value=\"0\"";
+			if (mysql_result($Erg, 0, "Tshirt")=='0')
+				echo " checked";
+			echo ">No \n";
+			echo "      <input type=\"radio\" name=\"eTshirt\" value=\"1\"";
+			if (mysql_result($Erg, 0, "Tshirt")=='1') 
+				echo " checked";
+			echo ">Yes \n";
+			echo "</td></tr>\n";
+		} //IF TYPE
+
+		if( $_GET["Type"] == "Secure" )
+		{
+			// CVS-Rechte
+			echo "  <tr><td><br><u>Rights of \"". mysql_result($Erg, 0, "Nick"). "\":</u></td></tr>\n";
+
+			$SQL_CVS = "SELECT * FROM `UserCVS` WHERE UID=". $_GET["enterUID"];
+			$Erg_CVS =  mysql_query($SQL_CVS, $con);
+			$CVS_Data = mysql_fetch_array($Erg_CVS);
+			$CVS_Data_i = 1;
+			foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) 
+			{
+		  		$CVS_Data_i++;
+				//nur jeder zweiter sonst wird für jeden text noch die position (Zahl) ausgegeben
+				if( $CVS_Data_i%2 && $CVS_Data_Name!="UID") 
+				{
+				    echo "<tr><td>$CVS_Data_Name</td>\n<td>";
+				    echo "<input type=\"radio\" name=\"".($CVS_Data_i-1)."\" value=\"Y\" ";
+				    if( $CVS_Data_Value == "Y" )	
+				    	echo " checked";
+				    echo ">allow \n";
+				    echo "<input type=\"radio\" name=\"".($CVS_Data_i-1)."\" value=\"N\" ";
+				    if( $CVS_Data_Value == "N" )
+				    	echo " checked";
+				    echo ">denied \n";
+				    echo "</td></tr>";
+				} //IF
+			} //Foreach	    
+			echo "</td></tr>\n";
+		} // IF TYPE
+
+
+		// Ende Formular
+		echo "</td></tr>\n";
+		echo "</table>\n";
+		echo "<input type=\"hidden\" name=\"enterUID\" value=\"". $_GET["enterUID"]. "\">\n";
+		echo "<input type=\"submit\" value=\"sichern...\">\n";
+		echo "</form>";
+
+		if( $_GET["Type"] == "Normal" )
+		{
+			echo "<form action=\"./user2.php?action=delete\" method=\"POST\">\n";
+			echo "<input type=\"hidden\" name=\"enterUID\" value=\"". $_GET["enterUID"]. "\">\n";
+			echo "<input type=\"submit\" value=\"l&ouml;schen...\">\n";
+			echo "</form>";
+		}
+
+	} 
+
+}
+
+include ("./inc/footer.php");
+?>
+
+
diff --git a/www-ssl/admin/user2.php b/www-ssl/admin/user2.php
new file mode 100755
index 00000000..5f94c093
--- /dev/null
+++ b/www-ssl/admin/user2.php
@@ -0,0 +1,128 @@
+<?PHP
+
+$title = "User-Liste";
+$header = "Index";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/crypt.php");
+
+if (IsSet($_GET["action"])) 
+{
+	
+	function SQLExec( $SQL )
+	{ 
+		global $con;
+	
+		$Erg = mysql_query($SQL, $con);
+		if ($Erg == 1) {
+			echo "&Auml;nderung wurde gesichert...\n";
+		} else {
+			echo "Fehler beim speichern...\n";
+		}
+
+	}
+
+	SetHeaderGo2Back();
+	echo "Gesendeter Befehl: ". $_GET["action"]. "<br>";
+
+	switch ($_GET["action"]) 
+	{
+	case "change":
+		if (IsSet($_POST["enterUID"]))
+		{
+			if ($_POST["Type"] == "Normal")
+			{
+				$SQL = "UPDATE `User` SET ";
+				$SQL.= " `Nick` = '". $_POST["eNick"]. "', `Name` = '". $_POST["eName"]. "', ".
+					"`Vorname` = '". $_POST["eVorname"]. "', ".
+					"`Telefon` = '". $_POST["eTelefon"]. "', ".
+					"`Handy` = '". $_POST["eHandy"]. "', ".
+					"`DECT` = '". $_POST["eDECT"]. "', ".
+					"`email` = '". $_POST["eemail"]. "', ".
+					"`Size` = '". $_POST["eSize"]. "', ".
+					"`Gekommen`= '". $_POST["eGekommen"]. "', ".
+					"`Aktiv`= '". $_POST["eAktiv"]. "', ".
+					"`Tshirt` = '". $_POST["eTshirt"]. "' ".
+					"WHERE `UID` = '". $_POST["enterUID"]. 
+					"' LIMIT 1;";
+				echo "User-";
+				SQLExec( $SQL );
+			}
+			if ($_POST["Type"] == "Secure")
+			{
+				$SQL2 = "UPDATE `UserCVS` SET ";
+			  	$SQL_CVS = "SELECT * FROM `UserCVS` WHERE UID=". $_POST["enterUID"];
+				$Erg_CVS =  mysql_query($SQL_CVS, $con);
+				$CVS_Data = mysql_fetch_array($Erg_CVS);
+				$CVS_Data_i = 1;
+				foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) 
+				{
+					if( ($CVS_Data_i+1)%2 && $CVS_Data_Name!="UID")
+						$SQL2.= "`$CVS_Data_Name` = '". $_POST[$CVS_Data_i]."', ";
+			    		$CVS_Data_i++;
+					}
+				$SQL2 = substr( $SQL2, 0, strlen($SQL2)-2 );
+				$SQL2.= "  WHERE `UID` = '". $_POST["enterUID"]. "' LIMIT 1;";
+				echo "<br>Secure-";
+				SQLExec( $SQL2 );
+			}
+		}
+		break;
+
+	case "delete":
+		if (IsSet($_POST["enterUID"]))
+		{
+			echo "delate User...";
+			$SQL="delete from `User` WHERE `UID` = '". $_POST["enterUID"]. "' LIMIT 1;";
+			SQLExec( $SQL );
+			echo "<br>\ndelate UserCVS...";
+			$SQL2="delete from `UserCVS` WHERE `UID` = '". $_POST["enterUID"]. "' LIMIT 1;";
+			SQLExec( $SQL2 );
+			echo "<br>\ndelate UserEntry...";
+			$SQL3="UPDATE `ShiftEntry` SET `UID` = '0', `Comment` = NULL ".
+				"WHERE `UID` = '". $_POST["enterUID"]. "' LIMIT 1;";
+			SQLExec( $SQL3 );
+		}
+		break;
+
+
+	case "newpw":
+		echo "Bitte neues Kennwort f&uuml;r <b>";
+		// Get Nick
+		$USQL = "SELECT * FROM User where UID=". $_POST["eUID"];
+		$Erg = mysql_query($USQL, $con);
+		echo mysql_result($Erg, 0, "Nick");
+		echo "</b> eingeben:<br>";
+		echo "<form action=\"./user2.php\" method=\"POST\">\n";	
+		echo "<input type=\"Password\" name=\"ePasswort\">";
+		echo "<input type=\"Password\" name=\"ePasswort2\">";
+		echo "<input type=\"hidden\" name=\"eUID\" value=\"". $_POST["eUID"]. "\">";
+		echo "<input type=\"hidden\" name=\"action\" value=\"newpwsave\">\n";
+	        echo "<input type=\"submit\" value=\"sichern...\">\n";
+	        echo "</form>";
+		break;
+
+	case "newpwsave":
+		if ($_POST["ePasswort"] == $_POST["ePasswort2"]) 
+		{	// beide Passwoerter passen... 
+			$_POST["ePasswort"] = PassCrypt($_POST["ePasswort"]);
+			$SQL =	"UPDATE `User` SET `Passwort`='". $_POST["ePasswort"]. "' ".
+				"where `UID` = '". $_POST["eUID"]. "'";
+			SQLExec( $SQL );
+		} 
+		else 
+			echo "Das Passwort wurde nicht &uuml;bereinstimmend eingegeben!";
+		break;
+	} // end switch
+
+// ende - Action ist gesetzt 
+} 
+else 
+{
+	// kein Action gesetzt -> abbruch
+	echo "Unzul&auml;ssiger Aufruf.<br>Bitte neu editieren...";
+}
+
+include ("./inc/footer.php");
+?>
+
-- 
cgit v1.2.3-70-g09d2