From 866c47ec603595e8fe67da5f0e5d162a70b1f7b4 Mon Sep 17 00:00:00 2001 From: cookie 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 --- admin/EngelType.php | 166 ---------------- admin/aktiv.php | 96 --------- admin/dbUpdateFromXLS.php | 448 ------------------------------------------ admin/dect.php | 68 ------- admin/dect_clear.php | 25 --- admin/dect_cron.php | 69 ------- admin/faq.1.php | 6 - admin/faq.php | 340 -------------------------------- admin/free.php | 108 ---------- admin/inc | 1 - admin/index.php | 19 -- admin/list.php | 34 ---- admin/menu.php | 46 ----- admin/news.php | 109 ---------- admin/pic | 1 - admin/room.php | 184 ----------------- admin/schichtplan.1.php | 5 - admin/schichtplan.php | 291 --------------------------- admin/schichtplan_druck.1.php | 5 - admin/schichtplan_druck.php | 169 ---------------- admin/shiftadd.php | 329 ------------------------------- admin/sprache.php | 116 ----------- admin/tshirt.php | 60 ------ admin/user.php | 249 ----------------------- admin/user2.php | 128 ------------ 25 files changed, 3072 deletions(-) delete mode 100755 admin/EngelType.php delete mode 100755 admin/aktiv.php delete mode 100755 admin/dbUpdateFromXLS.php delete mode 100755 admin/dect.php delete mode 100755 admin/dect_clear.php delete mode 100755 admin/dect_cron.php delete mode 100755 admin/faq.1.php delete mode 100755 admin/faq.php delete mode 100755 admin/free.php delete mode 120000 admin/inc delete mode 100755 admin/index.php delete mode 100755 admin/list.php delete mode 100755 admin/menu.php delete mode 100755 admin/news.php delete mode 120000 admin/pic delete mode 100755 admin/room.php delete mode 100755 admin/schichtplan.1.php delete mode 100755 admin/schichtplan.php delete mode 100755 admin/schichtplan_druck.1.php delete mode 100755 admin/schichtplan_druck.php delete mode 100755 admin/shiftadd.php delete mode 100755 admin/sprache.php delete mode 100755 admin/tshirt.php delete mode 100755 admin/user.php delete mode 100755 admin/user2.php (limited to 'admin') diff --git a/admin/EngelType.php b/admin/EngelType.php deleted file mode 100755 index 964d861b..00000000 --- a/admin/EngelType.php +++ /dev/null @@ -1,166 +0,0 @@ -"; - echo "[$SQL]
"; - return 1; - } else { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

".mysql_error( $con ). "
"; - echo "[$SQL]
"; - return 0; - } -} - - -$Sql = "SELECT * FROM `EngelType`"; -$Erg = mysql_query($Sql, $con); - -if( !IsSet($_GET["action"]) ) -{ - echo "Hallo ".$_SESSION['Nick']. - ",
\nhier hast du die Möglichkeit, neue Engeltypen für die Schichtpläne einzutragen ". - "oder vorhandene abzuändern:

\n"; - - echo "- Neuen EngelType eintragen
\n"; - - echo "\n"; - echo "\n"; - - for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) - { - echo "\t"; - } - echo "\t"; - echo ""; - - for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) - { - echo "\t\n"; - for ($j = 1; $j < mysql_num_fields($Erg); $j++) - { - echo "\t\t\n"; - } - echo "\t\t\n"; - echo "\t\n"; - } // ende Auflistung Raeume - echo "

". mysql_field_name($Erg, $i). "	Ändern
".mysql_result($Erg, $t, $j)."	###

"; -} -else -{ - -switch ($_GET["action"]) { - -case 'new': - echo "Neuen EngelType einrichten:
"; - echo ""; - 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ändern:\n"; - - echo "Hier kannst du eintragen, den EngelType ändern."; - - echo ""; - echo ""; - } - 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/admin/aktiv.php b/admin/aktiv.php deleted file mode 100755 index e0ddf3a4..00000000 --- a/admin/aktiv.php +++ /dev/null @@ -1,96 +0,0 @@ -"; -echo Get_Text("pub_aktive_Text1")."
\n"; -echo Get_Text("pub_aktive_Text2")."

\n"; - -// auswahlbox -echo Get_Text("pub_aktive_Text31")."\n"; -echo ""; -echo Get_Text("pub_aktive_Text32")."

\n"; -echo "\n"; -echo "\n"; -echo "\n"; - -echo "\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 "
\n\n".Get_Text("pub_aktive_Text5_1"). $_POST["Anzahl"]. Get_Text("pub_aktive_Text5_2"). ":"; - -echo "

\n\n"; - -//ausgabe tabelle -echo "\n"; -echo "\n"; -echo "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo "\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

"; - -for ($i=0; $i<$rowcount; $i++) -{ - echo "\n\n\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; -} // ende Auflistung aktive Engel - -echo "

". Get_Text("pub_aktive_Nick"). "	". Get_Text("pub_aktive_Anzahl"). "	". Get_Text("pub_aktive_Time"). "	". Get_Text("pub_aktive_Active"). "
". UID2Nick(mysql_result($Erg, $i, "UID")). "	". mysql_result($Erg, $i, "NR"). "	". mysql_result($Erg, $i, "LEN"). "h	"; - 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 "

"; - -include ("./inc/footer.php"); -?> - diff --git a/admin/dbUpdateFromXLS.php b/admin/dbUpdateFromXLS.php deleted file mode 100755 index 88f7a0f5..00000000 --- a/admin/dbUpdateFromXLS.php +++ /dev/null @@ -1,448 +0,0 @@ -\n

XML File:

\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.
"; - else - echo "fail ($Status)($Command).
"; -} -else -{ - echo "\n"; -} - - - -//readXMLfile("xml.php.xml"); -if( readXMLfile("/tmp/engelXML") == 0) -{ -/* -echo "


";
-echo $XMLmain->name;
-echo "
";
-//print_r(array_values ($XMLmain->sub));
-
-
-echo "
";
-$Feld=7;
-echo "$Feld#". $XMLmain->sub[$Feld]->name. "
";
-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 "

"; -*/ - -/*############################################################################################## - V e r s i o n - ##############################################################################################*/ -echo "

\n"; -$XMLrelease = getXMLsubPease( $XMLmain, "RELEASE"); -echo "release: ". $XMLrelease->data. "
\n"; -$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE"); -echo "release date: ". $XMLreleaseDate->data. "
\n"; -echo "

\n"; - - - -/*############################################################################################## - R o o m - ##############################################################################################*/ -echo "\n\n
\n

Rooms:

\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
"; - else - echo "Aenderung, an Raum ". $_GET["NameXML"]. ", war nicht erfogreich.(". - mysql_error($con). ")
[$SQL]
"; - } - else - echo "Fehler in den Parametern!
"; -} /*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 "\n"; -echo "\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 "\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - if( !( $NameXML==$NameDB && $NumberXML==$NumberDB) ) - { - echo "\t\n"; - $DS_KO++; - } - else - { - echo "\t\n"; - $DS_OK++; - } - echo "\t\n"; - echo "\n"; - $Where.= " OR RID=$RID"; -} -echo "\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\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - } - -echo "

RID	state
		OK
status: $DS_KO/$DS_OK nicht Aktuel.
	edit

\n"; - - - - -/*############################################################################################## - S c h e d u l e - ##############################################################################################*/ -echo "\n\n

Schudle:

\n"; - -// erstellt ein Array der Reume - $sql = "SELECT * FROM `Room` ". - "ORDER BY `Number`, `Name`;"; - $Erg = mysql_query($sql, $con); - for( $i=0; $i=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
\n"; - if( mysql_num_rows($Erg1)==0) - { - echo "-->Create Shifts:
\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
\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
\n"; - else - echo "------>fail ". mysql_error($con). - "($SQL3)
\n"; - } - - } - echo "
\n"; - } - } - else - echo "Aenderung, am Schedule '". $_GET["SIDXML"]. "', war nicht erfogreich.(". - mysql_error($con). ")
[$SQL]
\n"; - } - else - echo "Fehler in den Parametern!
"; -} /*SaveSchedule*/ - -if( isset($_GET["ScheduleUpdate"])) - SaveSchedule(); - -//INIT Status counter -$DS_OK = 0; -$DS_KO = 0; -$Where = ""; - -//ausgabe -echo "\n"; -echo "". - "\n"; -echo "". - "\n"; -$XMLevents = getXMLsubPease( $XMLmain, "EVENTS"); -while( (list($EventKey, $Event) = each($XMLevents->sub)) && $EnableSchudle) -{ - echo "\n"; - echo "\t\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\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - if( !( $SIDXML==$SIDDB && - $DateXML==$TimeDB && - $RIDXML==$RIDDB && - $LenXML==$LenDB && - $ManXML==$ManDB) ) - { - echo "\t\n"; - $DS_KO++; - } - else - { - echo "\t\n"; - $DS_OK++; - } - echo "\t\n"; - echo "\n"; - $Where.= " OR SID=$SIDXML"; -} -echo "\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\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\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - } -echo "

SID	Date	Room	Len	Name	state
XML - DB	XML - DB	XML - DB	XML - DB	XML - DB
	\n\t\t". - "	\n\t\t". - "	\n\t\t". - "	\n\t\t". - "		OK
status: $DS_KO/$DS_OK nicht Aktuel.
	\n\t\t". - "	\n\t\t". - "	\n\t\t". - "	\n\t\t". - "	edit

"; - - - -/*############################################################################################## - U P D A T E A L L - ##############################################################################################*/ -echo "\n\n
\n

Update ALL:

\n"; - -echo "\n"; - -} //if XMLopenOOK - -include ("./inc/footer.php"); -?> - diff --git a/admin/dect.php b/admin/dect.php deleted file mode 100755 index 99a58028..00000000 --- a/admin/dect.php +++ /dev/null @@ -1,68 +0,0 @@ -\n"; - echo "\n"; - - echo "\n"; - - echo "\n"; - - echo "\n"; - echo "\n"; - echo ""; - echo "

Number	h:m
\n"; - // Listet alle Nicks auf - echo "\n"; - - echo "\n"; - echo "	:"; - echo "

\n"; - - echo ""; - - -include ("./inc/footer.php"); -?> - diff --git a/admin/dect_clear.php b/admin/dect_clear.php deleted file mode 100755 index 2b20d6c5..00000000 --- a/admin/dect_clear.php +++ /dev/null @@ -1,25 +0,0 @@ - - diff --git a/admin/dect_cron.php b/admin/dect_cron.php deleted file mode 100755 index 00119567..00000000 --- a/admin/dect_cron.php +++ /dev/null @@ -1,69 +0,0 @@ -'". 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; $i0) - { - $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/admin/faq.1.php b/admin/faq.1.php deleted file mode 100755 index ee2bbb53..00000000 --- a/admin/faq.1.php +++ /dev/null @@ -1,6 +0,0 @@ - - -

Alle Anfragen

Offene Anfragen ()

FAQ-Liste editiern

- diff --git a/admin/faq.php b/admin/faq.php deleted file mode 100755 index e4123841..00000000 --- a/admin/faq.php +++ /dev/null @@ -1,340 +0,0 @@ - - Alle Anfragen:
- - - - - - - - - - -\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - } else { - echo "Nein\n"; - echo "\n"; - echo "\n"; - } - echo ""; - echo "\n"; - } - echo "

Frage	Anfragender	Beantwortet?	Antwort	Antwort von	change
".mysql_result($Erg, $n, "Question")."	".UID2Nick(mysql_result($Erg, $n, "UID"))."	"; - if (mysql_result($Erg, $n, "AID")>0) { - echo "Ja	".mysql_result($Erg, $n, "Answer")."	".UID2Nick(mysql_result($Erg, $n, "AID"))."			xxx

\n"; - break; -case "open": - $SQL="Select * from Questions where AID = \"0\" ORDER BY QID DESC"; - $quest_bearb=1; // Fragenliste anzeigen -?> - Offene Anfragen:
- - Fehlerhafter Aufruf...
Bitte die Bearbeitung nochmals beginnen :) - - - Wenn diese Anfrage bereits beantwortet wurde, kannst du diese so wie sie ist als Engel-FAQ eintrag übernehmen.
- In diesem Falle erscheint hier der Link: -"0") { -?> - Als FAQ-Eintrag sichern... - - Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten... - - Der Eintrag wurde geändert
- - Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :) - - Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten... - - Der Eintrag wurde übertragen.
- - Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :) - - FAQ-Liste:
- Neuen Eintrag - -

- ">Bearbeiten -
---
- - Fehlerhafter Aufruf...
Bitte die Bearbeitung nochmals beginnen :) - - - - - Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten... - - Der Eintrag wurde gelöscht
- - Ein Fehler ist aufgetreten. Ist der Eintag bereits gelöscht gewesen? - - Fehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten... - - Der Eintrag wurde geändert
- - Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :) - - - - Der Eintrag wurde erfasst.
- - Ein Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :) - - keine vorhanden... - -

- -

-
- ">Bearbeiten -
---
- -Bitte wähle aus, ob du: - -

- - diff --git a/admin/free.php b/admin/free.php deleted file mode 100755 index 1e7bd259..00000000 --- a/admin/free.php +++ /dev/null @@ -1,108 +0,0 @@ -\n"; - -?> -hier findest du alle Engel, welche zur Zeit in Schichten verplant sind: -

- - - 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 "

$SQL

"; - -$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 "\n"; -echo "\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\n"; - - -$inuse=""; -for ($i=0; $i < $Zeilen; $i++) -{ - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - - if ($inuse!="") - $inuse.= " OR "; - $inuse.= "(Nick = \"". UID2Nick(mysql_result($Erg, $i, "UID")). "\")"; -} -if ($inuse!="") - $inuse=" WHERE NOT (".$inuse.")"; -echo "

Nick	Schicht	Ort	Von	Bis
". - mysql_result($Erg, $i, "Nick"). "	". UID2Nick(mysql_result($Erg, $i, "UID")). "	". mysql_result($Erg, $i, "RID"). "	". mysql_result($Erg, $i, "DateS"). "	". mysql_result($Erg, $i, "DateE"). "

\n"; - - -//########################################################################################################## - -echo "

\n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:

\n"; -echo "\n"; -echo "\t\n\t\t\n\t\t\n\t\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\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\n\n"; -} -echo "

Nick	DECT
". - mysql_result($Erg, $i, "Nick"). "	". mysql_result($Erg, $i, "DECT"). "

\n"; - -include ("./inc/footer.php"); -?> - diff --git a/admin/inc b/admin/inc deleted file mode 120000 index 22dc542a..00000000 --- a/admin/inc +++ /dev/null @@ -1 +0,0 @@ -../inc \ No newline at end of file diff --git a/admin/index.php b/admin/index.php deleted file mode 100755 index c7ae3a14..00000000 --- a/admin/index.php +++ /dev/null @@ -1,19 +0,0 @@ -\n"; - -?> - -du bist jetzt im Erzengel-Bereich. Hier kannst du die Engel-Verwaltung vornehmen.

- -Bitte melde dich hier nach getaner Arbeit immer ab, damit kein anderer hier Änderungen vornehmen kann. - - - diff --git a/admin/list.php b/admin/list.php deleted file mode 100755 index 6ae8a336..00000000 --- a/admin/list.php +++ /dev/null @@ -1,34 +0,0 @@ -Raeume
"; -funktion_db_list("Raeume"); - -echo "

Schichtbelegung

"; -funktion_db_list("Schichtbelegung"); - -echo "

Schichtplan

Hier findest du alle bisher eingetragenen Schichten:"; -funktion_db_list("Schichtplan"); - -echo "

User

"; -funktion_db_list("User"); - -echo "

News

"; -funktion_db_list("News"); - -echo "

FAQ

"; -funktion_db_list("FAQ"); - -*/ - -echo "Deaktiviert"; - -include ("./inc/footer.php"); -?> - diff --git a/admin/menu.php b/admin/menu.php deleted file mode 100755 index bd0761ed..00000000 --- a/admin/menu.php +++ /dev/null @@ -1,46 +0,0 @@ -"; -$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"] = "
"; -$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"] = "

"; -$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"] = "

"; -$Menu["Entry"][11]["File"] = "sprache.php"; -$Menu["Entry"][11]["Name"] = "Language"; -$Menu["Entry"][11]["Line"] = "

"; -$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ü"; -} // MenueShowAdminSection - - - -?> diff --git a/admin/news.php b/admin/news.php deleted file mode 100755 index 7c501751..00000000 --- a/admin/news.php +++ /dev/null @@ -1,109 +0,0 @@ - -Hallo ,
-hier kannst du die News säbern... falls jemand auf die Idee kommt, -hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)

- - - - - - - - - - -\n"; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t\n"; -} -echo "

Datum	Betreff	Text	Erfasser	Engeltreff	Änd.
".mysql_result($Erg, $i, "Datum")."	".mysql_result($Erg, $i, "Betreff")."	".mysql_result($Erg, $i, "Text")."	".UID2Nick(mysql_result($Erg, $i, "UID"))."	".mysql_result($Erg, $i, "Treffen")."	XXX

"; - - -} else { - -switch ($_GET["action"]) -{ - -case 'change': - $SQL = "SELECT * from News where (Datum='". $_GET["date"]. "')"; - $Erg = mysql_query($SQL, $con); - - echo ""; - - echo ""; - - 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 "Änderung erfolgreich gesichert..."; - } - else - { - echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)

\n"; - echo mysql_error($con); - echo "

\n[$chsql]"; - } -} - -} -include ("./inc/footer.php"); -?> - diff --git a/admin/pic b/admin/pic deleted file mode 120000 index a21de85f..00000000 --- a/admin/pic +++ /dev/null @@ -1 +0,0 @@ -../pic \ No newline at end of file diff --git a/admin/room.php b/admin/room.php deleted file mode 100755 index 3b8cb63c..00000000 --- a/admin/room.php +++ /dev/null @@ -1,184 +0,0 @@ -\nhier hast du die Möglichkeit, neue Räume für die Schichtpläne einzutragen ". - "oder vorhandene abzuändern:

\n"; - - echo "- Neuen Raum/Ort eintragen
\n"; - - echo "\n"; - echo "\n"; - - for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) - { - if( substr( mysql_field_name($Erg, $i), 0, 12) == "DEFAULT_EID_") - echo "\t"; - else - echo "\t"; - } - echo "\t"; - echo ""; - - for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) - { - echo "\t\n"; - for ($j = 1; $j < mysql_num_fields($Erg); $j++) - { - echo "\t\t\n"; - } - echo "\t\t\n"; - echo "\t\n"; - } // ende Auflistung Raeume - echo "

Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $i), 12)]. "	". mysql_field_name($Erg, $i)."	Ändern
".mysql_result($Erg, $t, $j)."	###

"; -} -else -{ - -UnSet($SQL); - -switch ($_GET["action"]) { - -case 'new': - echo "Neuen Raum einrichten:
"; - echo ""; - 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ändern:\n"; - - echo "Hier kannst du eintragen, welche und wieviele Engel für den Raum zur Verf�gung stehen müssen."; - - echo ""; - echo ""; - } - 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 "Änderung wurde gesichert...
"; - } else { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

".mysql_error( $con ). "
($SQL)
"; - } -} // Ende Update - -} //IF IsSet($action) - -include ("./inc/footer.php"); -?> diff --git a/admin/schichtplan.1.php b/admin/schichtplan.1.php deleted file mode 100755 index 30761390..00000000 --- a/admin/schichtplan.1.php +++ /dev/null @@ -1,5 +0,0 @@ - - -

Ein-/Austragen

Druckversion

- diff --git a/admin/schichtplan.php b/admin/schichtplan.php deleted file mode 100755 index 9e7ec81b..00000000 --- a/admin/schichtplan.php +++ /dev/null @@ -1,291 +0,0 @@ -\n"; -echo "hier kannst du Schichten anlegen, ändern oder löschen.

"; -echo "Neue Schicht einplanen

\n\n"; - -?> - - - - - - - -\n"; - echo "\t\t\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\n"; - else - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; -} -echo "

Datum	Raum	Dauer	Ändern
".mysql_result($Erg, $i, "DateS")."	".mysql_result($Erg2, 0, "Name")."	Unbenkannt (RID=". mysql_result($Erg, $i, "RID"). ")	".mysql_result($Erg, $i, "Len")." Std.	####

"; - - -} 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ändern:
\n"; - - // Anzeige Allgemeiner schaischt daten - echo "\n\n"; - - // L�schen - echo "\n\n"; - - echo "ACHTUNG:
\n"; - echo "Beim Löschen werden die bisher eingetragenen Engel für diese Schicht mitgelöscht.
\n"; - - echo "

\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:
\n"; - for ($j=0; $j < $rowcount; $j++) - { - $TID = mysql_result($Erg3, $j, 0); - echo "". - "freie ". TID2Type($TID). Get_Text("inc_schicht_Engel"). "schicht loeschen
\n"; - } - echo "

\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:
\n"; - for ($j=0; $j < $rowcount; $j++) - { - $userUID=mysql_result($Erg3, $j, "UID"); - echo "". - UID2Nick($userUID). - " (". TID2Type(mysql_result($Erg3, $j, "TID")). Get_Text("inc_schicht_Engel"). - ") austragen
\n"; - } // FOR - - echo "

\n\n\n\n"; - - //Nachtragen von Engeln - echo "Hat ein anderer Engel die Schicht übernommen, trage ihn bitte ein:"; - echo "

\n"; - echo "\n"; - echo "\n"; - - // Listet alle Nicks auf - echo "\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 "\n"; - - echo "\n"; - echo "

"; - - } // 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ätzlich eingetragen:
\n"; - echo "Engel: ".UID2Nick($_GET["UIDs"])."
\n"; - echo "Bemerkung: Schicht eingetragen durch Erzengel ".$_SESSION['Nick']."
\n
\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:
\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
\n"; - if ($Erg == 1) - { - echo "Änderung wurde gesichert...
"; - if( $DEBUG ) - echo "DEBUG: ergebniss". $Erg. "
\n"; - if (IsSet($ch2SQL)) - { - $Erg = mysql_query($ch2SQL, $con); - if( $DEBUG ) - echo "DEBUG SQL: $ch2SQL
\n"; - if( $DEBUG ) echo "DEBUG: ergebniss". $Erg. "
\n"; - } - } - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)
"; - echo mysql_error($con); - } -} // Ende Update - -} - - -include ("./inc/footer.php"); -?> diff --git a/admin/schichtplan_druck.1.php b/admin/schichtplan_druck.1.php deleted file mode 100755 index 30761390..00000000 --- a/admin/schichtplan_druck.1.php +++ /dev/null @@ -1,5 +0,0 @@ - - -

Ein-/Austragen

Druckversion

- diff --git a/admin/schichtplan_druck.php b/admin/schichtplan_druck.php deleted file mode 100755 index a6ec2dbd..00000000 --- a/admin/schichtplan_druck.php +++ /dev/null @@ -1,169 +0,0 @@ - - -Hallo ,
-auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. Wähle hierfür ein Datum und den Raum: -

- - -

- - - - - -Schichtplan - - - - - - - - - - -

Schichtplan

- - - - - - -

- Datum: - -

- Raum: - -

- - - - - - - -\n"; - if( $j==0) - { - $Spalten[$i * $GlobalZeileProStunde + $j].= - "\t\t\n"; - - } - } - - -CreateRoomShifts( $Raum ); - - -// Ausgabe Zeilen - for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) echo $Spalten[$i]; -// Ende -echo "

Uhrzeit	Schichtplanbelegung
"; - if( $i < 10 ) - $Spalten[$i * $GlobalZeileProStunde + $j].= "0"; - $Spalten[$i * $GlobalZeileProStunde + $j].= "$i:"; - if( ( ($j60) / $GlobalZeileProStunde) < 10 ) - $Spalten[$i $GlobalZeileProStunde + $j].= "0"; - $Spalten[$i * $GlobalZeileProStunde + $j].= - ( ($j*60) / $GlobalZeileProStunde). "

\n"; - -echo "Stand: ". gmdate("Y-m-d H:i"). "\n"; -echo "\n"; -echo "\n"; - -} //isset($Vars) -} //isset($Action) - -?> diff --git a/admin/shiftadd.php b/admin/shiftadd.php deleted file mode 100755 index 8b2f6451..00000000 --- a/admin/shiftadd.php +++ /dev/null @@ -1,329 +0,0 @@ -\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. -Über die Länge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch können gleich -mehrere Schichten auf einmal erfasst werden: - - - - 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 "\n"; - echo "\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\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 "

Start

End

len

RID

Beschreibung

Entry 'Shifts'

SID

Entrys

"; - - if( $_GET["OnlyShow"]=="ON" ) - { - echo ""; - } //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 "\n"; - - echo "\t$_DateS\n"; - echo "\t$_DateE\n"; - echo "\t". $_GET["len"]. "\n"; - echo "\t". $_GET["RID"]. "\n"; - echo "\t". $_GET["SchichtName"]. "\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 "\texists"; - 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
[".$SQL. "]"; - - if ($Erg == 1) echo "\tpass\n"; - else echo "\tfail
\n". mysql_error($con). "$SQLFail\n"; - - } else - echo "\tonly show\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?"; - else - { - $SID = mysql_result($Erg, 0, "SID"); - echo "\t". $SID. ""; - } - - // erstellt f�r jeden Engeltypen die eintrage in 'ShiftEntry' - echo "\t"; - foreach ($EngelType As $TTemp) - { - $Temp = "EngelType".$TTemp["TID"]; - - if( $_GET[$Temp] > 0 ) - { - $i = 0; - echo $_GET[$Temp]. " ".$TTemp["Name"]. "
\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
[".$SQL. "]"; - - if ($Erg == 1) echo "'pass' "; - else echo "'fail' ". mysql_error($con). "$SQLFail\n"; - - } - else - echo "+"; - } - echo "
"; - } // IF $$TEMP - } // FOREACH - echo ""; - - echo "\n"; -} - -include ("./inc/footer.php"); -?> diff --git a/admin/sprache.php b/admin/sprache.php deleted file mode 100755 index af5db2ba..00000000 --- a/admin/sprache.php +++ /dev/null @@ -1,116 +0,0 @@ -\n"; - echo Get_Text("pub_sprache_text1")."

\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\n\t\t"; - echo "\t\t". Get_Text("pub_sprache_TextID"). ""; - foreach( $Sprachen as $Name => $Value ) - echo "". - Get_Text("pub_sprache_Sprache"). " ". $Name. - ""; - echo "\t\t". Get_Text("pub_sprache_Edit"). ""; - echo "\t\t"; - - - // 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"; - echo "\n"; - echo "\t\t$TextID_Old ". - " \n"; - - foreach( $Sprachen as $Name => $Value ) - { - echo "\t\t\n"; - $Sprachen[ $Name ] = ""; - } - - echo "\t\t\n"; - echo ""; - echo "\n"; - $TextID_Old = $TextID_New; - } - $Sprachen[ mysql_result( $erg, $i, "Sprache" ) ] = mysql_result( $erg, $i, "Text" ); - } /*FOR*/ - - //fuer neu eintraege - echo "\n"; - - - echo "\n"; -} /*if( !isset( $TextID ) )*/ -else -{ - echo "edit: ". $_GET["TextID"]. "

"; - 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
\n"; - else - echo "\t $k Save: KO
\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."
"; - $Erg = mysql_query($sql_save, $con); - if ($Erg == 1) - echo "\t $k Update: OK
\n"; - else - echo "\t $k Update: KO
\n"; - } - else - echo "\t $k no changes
\n"; - } - } - -} - -include ("./inc/footer.php"); -?> - diff --git a/admin/tshirt.php b/admin/tshirt.php deleted file mode 100755 index 2a3ea500..00000000 --- a/admin/tshirt.php +++ /dev/null @@ -1,60 +0,0 @@ -"; - } -} - -?> - -Über die Suchen-Funktion des Browsers kann diese Liste schnell nach einem Nick abgesucht werden.
-Hinter diesem erscheint ein Link, über den man eintragen kann, dass der Engel sein T-Shirt erhalten hat.

- -Liste aller aktiven Engel: - - - - - - - - - -\n"; - $eUID=mysql_result($Erg, $i, "UID"); - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - - if (mysql_result($Erg, $i, "Tshirt") =="1") { - echo "\t\t"; - } else { - echo "\t\t"; - } - echo "\t\n"; -} - -echo "

Nick

Aktiv?

Grösse

T-Shirt ausgeben:

".UID2Nick($eUID)."

".mysql_result($Erg, $i, "Aktiv")."

".mysql_result($Erg, $i, "Size")."

bereits erhalten

XXXXXXXX

"; - -include ("./inc/footer.php"); -?> - diff --git a/admin/user.php b/admin/user.php deleted file mode 100755 index a1c2aa4b..00000000 --- a/admin/user.php +++ /dev/null @@ -1,249 +0,0 @@ -Neuen Engel eintragen

\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

\n"; - - ?> - - - - - - - - - - - - - - - - \n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - $Gekommen += mysql_result($Erg, $n, "Gekommen"); - echo "\t\n"; - $Active += mysql_result($Erg, $n, "Aktiv"); - echo "\t\n"; - $Tshirt += mysql_result($Erg, $n, "Tshirt"); - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\n"; - } - echo "". - "". - "\n"; - echo "\t

Nick	Name	Vorname	Alter	Telefon @	Größe	G	A	T	Änd.	Secure
".mysql_result($Erg, $n, "Nick"). "	".mysql_result($Erg, $n, "Name")."	".mysql_result($Erg, $n, "Vorname")."	".mysql_result($Erg, $n, "Alter")."	"; - if( strlen( mysql_result($Erg, $n, "Telefon"))>0) - echo "\n\t\tTel: ". mysql_result($Erg, $n, "Telefon"). " "; - if( strlen( mysql_result($Erg, $n, "Handy"))>0) - echo "\n\t\tHandy: ". mysql_result($Erg, $n, "Handy"). " "; - if( strlen( mysql_result($Erg, $n, "DECT"))>0) - echo "\n\t\tDECT: ". - mysql_result($Erg, $n, "DECT"). " "; - if( strlen( mysql_result($Erg, $n, "email"))>0) - echo "\n\t\temail: ". - mysql_result($Erg, $n, "email").""; - echo "	".mysql_result($Erg, $n, "Size")."	".mysql_result($Erg, $n, "Gekommen")."	".mysql_result($Erg, $n, "Aktiv")."	".mysql_result($Erg, $n, "Tshirt")."	Änd.	"; - - //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 \n"; - else - echo mysql_error($con); - } - echo "Secure
						$Gekommen	$Active	$Tshirt

\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,
". - "hier kannst du den Eintrag ä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ält, bedeutet dies, dass der Engel ". - "bereits sein T-Shirt erhalten hat.

\n"; - - echo "

\n"; - echo "\n"; - echo "\n"; - - if( $_GET["Type"] == "Normal" ) - { - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - - // Gekommen? - echo " \n"; - - // Aktiv? - echo " \n"; - - // T-Shirt bekommen? - echo " \n"; - } //IF TYPE - - if( $_GET["Type"] == "Secure" ) - { - // CVS-Rechte - echo " \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 "\n"; - } //IF - } //Foreach - echo "\n"; - } // IF TYPE - - - // Ende Formular - echo "\n"; - echo "

Nick	". - "
lastLogIn	". - "
Name	". - "
Vorname	". - "
Alter	". - "
Telefon	". - "
Handy	". - "
DECT	". - "
email	". - "
Size	". - "
Passwort	". - " ". - "neues Kennwort setzen
Gekommen	\n"; - echo " No \n"; - echo " Yes \n"; - echo "
Aktiv	\n"; - echo " No \n"; - echo " Yes \n"; - echo "
T-Shirt	\n"; - echo " No \n"; - echo " Yes \n"; - echo "
Rights of \"". mysql_result($Erg, 0, "Nick"). "\":
$CVS_Data_Name	"; - echo "allow \n"; - echo "denied \n"; - echo "

\n"; - echo "\n"; - echo "\n"; - echo "

"; - - if( $_GET["Type"] == "Normal" ) - { - echo ""; - } - - } - -} - -include ("./inc/footer.php"); -?> - - diff --git a/admin/user2.php b/admin/user2.php deleted file mode 100755 index 5f94c093..00000000 --- a/admin/user2.php +++ /dev/null @@ -1,128 +0,0 @@ -"; - - 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 "
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 "
\ndelate UserCVS..."; - $SQL2="delete from `UserCVS` WHERE `UID` = '". $_POST["enterUID"]. "' LIMIT 1;"; - SQLExec( $SQL2 ); - echo "
\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ür "; - // Get Nick - $USQL = "SELECT * FROM User where UID=". $_POST["eUID"]; - $Erg = mysql_query($USQL, $con); - echo mysql_result($Erg, 0, "Nick"); - echo " eingeben:
"; - echo ""; - 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 übereinstimmend eingegeben!"; - break; - } // end switch - -// ende - Action ist gesetzt -} -else -{ - // kein Action gesetzt -> abbruch - echo "Unzulässiger Aufruf.
Bitte neu editieren..."; -} - -include ("./inc/footer.php"); -?> - -- cgit v1.3.1

Name:
Ort:
Zeit:
Month.Jahr:	">
Beginn:	Date"> - Time
More then One
End:	Date"> - Time
Länge in h:
Sonderschichten ein:
Sonder in h (Time;Time):
Anzahl Engel je Type:
". $TTemp["Name"]. ":

XML-File:
Username:
Password:

XML File:

Rooms:

Schudle:

Update ALL:

Anfragen und FAQ

Schichtbelegung

Schichtplan

User

News

FAQ

Schichtplan

Schichtplan

Schichtplan