From 04973d1fa148381978b1251d10118e6bab86f435 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Mon, 13 Jun 2011 18:05:51 +0200 Subject: moved public files to public, old and yet untouched files to directories ending with _old --- www-ssl/admin/UserPicture.php | 132 ------------- www-ssl/admin/aktiv.php | 105 ---------- www-ssl/admin/dbUpdateFromXLS.php | 252 ----------------------- www-ssl/admin/dect.php | 69 ------- www-ssl/admin/free.php | 98 --------- www-ssl/admin/free_DECT.php | 65 ------ www-ssl/admin/room.php | 199 ------------------- www-ssl/admin/schichtplan.1.php | 5 - www-ssl/admin/schichtplan.php | 362 ---------------------------------- www-ssl/admin/schichtplan_druck.1.php | 5 - www-ssl/admin/schichtplan_druck.php | 119 ----------- www-ssl/admin/shiftadd.php | 350 -------------------------------- www-ssl/admin/tshirt.php | 62 ------ www-ssl/admin/userArrived.php | 53 ----- 14 files changed, 1876 deletions(-) delete mode 100644 www-ssl/admin/UserPicture.php delete mode 100644 www-ssl/admin/aktiv.php delete mode 100644 www-ssl/admin/dbUpdateFromXLS.php delete mode 100644 www-ssl/admin/dect.php delete mode 100644 www-ssl/admin/free.php delete mode 100644 www-ssl/admin/free_DECT.php delete mode 100755 www-ssl/admin/room.php delete mode 100644 www-ssl/admin/schichtplan.1.php delete mode 100644 www-ssl/admin/schichtplan.php delete mode 100644 www-ssl/admin/schichtplan_druck.1.php delete mode 100644 www-ssl/admin/schichtplan_druck.php delete mode 100644 www-ssl/admin/shiftadd.php delete mode 100644 www-ssl/admin/tshirt.php delete mode 100644 www-ssl/admin/userArrived.php (limited to 'www-ssl/admin') diff --git a/www-ssl/admin/UserPicture.php b/www-ssl/admin/UserPicture.php deleted file mode 100644 index 25f8b54b..00000000 --- a/www-ssl/admin/UserPicture.php +++ /dev/null @@ -1,132 +0,0 @@ -\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t(max " . get_cfg_var("post_max_size") . "Byte)
\n"; - echo "\t\n"; - echo "\n"; - break; - case 'sendPicture' : - if (($_FILES["file"]["size"] > 0) && (isset ($_POST["UID"]))) { - if (($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/png") || ($_FILES["file"]["type"] == "image/gif")) { - $data = addslashes(fread(fopen($_FILES["file"]["tmp_name"], "r"), filesize($_FILES["file"]["tmp_name"]))); - - if (GetPicturShow($_POST['UID']) == "") - $SQL = "INSERT INTO `UserPicture` " . - "( `UID`,`Bild`, `ContentType`, `show`) " . - "VALUES ('" . $_POST['UID'] . "', '$data', '" . $_FILES["file"]["type"] . "', 'N')"; - else - $SQL = "UPDATE `UserPicture` SET " . - "`Bild`='$data', " . - "`ContentType`='" . $_FILES["file"]["type"] . "' " . - "WHERE `UID`='" . $_POST['UID'] . "'"; - - echo "Upload Pictur:'" . $_FILES["file"]["name"] . "', " . - "MIME-Type: " . $_FILES["file"]["type"] . ", " . - $_FILES["file"]["size"] . " Byte " . - "for " . UID2Nick($_POST["UID"]); - } else - Print_Text("pub_einstellungen_send_KO"); - } else - Print_Text("pub_einstellungen_send_KO"); - break; - - case 'SetN' : - if (IsSet ($_GET["UID"])) { - echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gesperrt:
"; - $SQL = "UPDATE `UserPicture` SET `show`='N' WHERE `UID`='" . $_GET["UID"] . "'"; - } else - echo "Fehlerhafter Aufruf"; - break; - case 'SetY' : - if (IsSet ($_GET["UID"])) { - echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde Freigegeben:
"; - $SQL = "UPDATE `UserPicture` SET `show`='Y' WHERE `UID`='" . $_GET["UID"] . "'"; - } else - echo "Fehlerhafter Aufruf"; - break; - case 'del' : - echo "Wollen Sie das Bild von '" . UID2Nick($_GET["UID"]) . "' wirklich löschen? " . - "Yes"; - break; - case 'delYes' : - if (IsSet ($_GET["UID"])) { - echo "Bild von '" . UID2Nick($_GET["UID"]) . "' wurde gelöscht:
"; - $SQL = "DELETE FROM `UserPicture` WHERE `UID`='" . $_GET["UID"] . "' LIMIT 1"; - } else - echo "Fehlerhafter Aufruf"; - break; - default : - echo "Fehlerhafter Aufruf"; - - } //switch - - // Update ??? - if (IsSet ($SQL)) { - // hier muesste das SQL ausgefuehrt werden... - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - echo "Änderung wurde gesichert...
"; - else { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

" . mysql_error($con) . "
($SQL)
"; - } - } // Ende Update - echo "
\n
\n
\n\n"; -} //IF IsSet($action) - -//ausgabe der Liste -$Sql = "SELECT * FROM `UserPicture` WHERE `UID`>0;"; -$Erg = mysql_query($Sql, $con); - -echo "Hallo " . $_SESSION['Nick'] . ",
\nhier hast du die Möglichkeit, die Bilder der Engel freizugeben:

\n"; - -echo "\n"; -echo "\n"; -echo "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo ""; - -for ($t = 0; $t < mysql_num_rows($Erg); $t++) { - $UIDs = mysql_result($Erg, $t, "UID"); - echo "\t\n"; - - echo "\t\t\n"; - echo "\t\t\n"; - - if (GetPicturShow($UIDs) == "Y") - echo "\t\t\n"; - elseif (GetPicturShow($UIDs) == "N") echo "\t\t\n"; - else - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; -} // ende Auflistung Raeume -echo "
UserBildStatusLöschen
" . UID2Nick(mysql_result($Erg, $t, "UID")) . "" . displayPictur($UIDs, 0) . "sperrenfreigebenERROR: show='" . GetPicturShow($UIDs) . "'del
"; - -echo "
picture upload\n"; - -include ("includes/footer.php"); -?> diff --git a/www-ssl/admin/aktiv.php b/www-ssl/admin/aktiv.php deleted file mode 100644 index 8db62f98..00000000 --- a/www-ssl/admin/aktiv.php +++ /dev/null @@ -1,105 +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"; -echo "\t
\n"; -echo "
\n"; - -if (Isset ($_POST["ResetActive"])) { - $SQLreset = "UPDATE `User` SET `Aktiv`='0'"; - $ErgReset = db_query($SQLreset, "Reset Active"); - if ($ErgReset != 1) - echo "Fehler beim zuruecksetzen der Activ\n"; - else - echo "Active wurde erfolgreich zurueckgesetzt\n"; -} - -if (IsSet ($_POST["Anzahl"])) - echo "
\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 "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo "\t\n"; -echo "\n"; - -$SQL = " -SELECT d.UID, d.nr, d.len, d.lenWeight, f.nr AS nrFree, f.len AS lenFree, d.lenWeight - COALESCE(f.len, 0) as lenReal - FROM - (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d - LEFT JOIN - (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f - USING(UID) - ORDER BY lenReal DESC, nr DESC, UID"; - -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); -$rowcount = mysql_num_rows($Erg); - -$aktivecount = 0; -for ($i = 0; $i < $rowcount; $i++) { - echo "\n\n\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\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"; -} // ende Auflistung aktive Engel - -echo "
" . Get_Text("pub_aktive_Nick") . "" . Get_Text("pub_aktive_Anzahl") . "" . Get_Text("pub_aktive_Time") . "" . Get_Text("pub_aktive_Time") . " WeightFreeloader " . Get_Text("pub_aktive_Anzahl") . "Freeloader " . Get_Text("pub_aktive_Time") . "" . Get_Text("pub_aktive_Time") . " result" . Get_Text("pub_aktive_Active") . "
" . UID2Nick(mysql_result($Erg, $i, "UID")) . "" . mysql_result($Erg, $i, "nr") . "x" . mysql_result($Erg, $i, "len") . "h" . mysql_result($Erg, $i, "lenWeight") . "h" . mysql_result($Erg, $i, "nrFree") . "x" . mysql_result($Erg, $i, "lenFree") . "h" . mysql_result($Erg, $i, "lenReal") . "h"; - if (IsSet ($_POST["Anzahl"])) { - if ($_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal")) { - $aktivecount++; - if ($_POST["SendType"] == "Show..") - echo "show set"; - else { - $SQL2 = "UPDATE `User` SET `Aktiv`='1' WHERE `UID`='" . mysql_result($Erg, $i, "UID") . "' LIMIT 1"; - $Erg2 = db_query($SQL2, "update Active State"); - if ($Erg2 != 1) - echo "Fehler beim speichern bei Engel " . UID2Nick(mysql_result($Erg, $i, "UID")); - else - echo "write set"; - } - } - } - echo "
"; - -echo "
Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)

"; - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/dbUpdateFromXLS.php b/www-ssl/admin/dbUpdateFromXLS.php deleted file mode 100644 index 88879de7..00000000 --- a/www-ssl/admin/dbUpdateFromXLS.php +++ /dev/null @@ -1,252 +0,0 @@ -\n

XML File:

\n"; -if (isset ($_POST["PentabarfUser"]) && isset ($_POST["password"]) && isset ($_POST["PentabarfURL"])) { - echo "Update XCAL-File from Pentabarf.."; - if ($PentabarfGetWith == "fsockopen") { - - //backup error messeges and delate - $Backuperror_messages = $error_messages; - $fp = fsockopen("ssl://$PentabarfXMLhost", 443, $errno, $errstr, 30); - // $error_messages = $Backuperror_messages; - - if (!$fp) { - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!" . - "[$errstr ($errno)]

"; - } else { - if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { - $head = 'GET /' . $PentabarfXMLpath . $_POST["PentabarfURL"] . ' HTTP/1.1' . "\r\n" . - 'Host: ' . $PentabarfXMLhost . "\r\n" . - 'User-Agent: Engelsystem' . "\r\n" . - 'Authorization: Basic ' . - base64_encode($_POST["PentabarfUser"] . ':' . $_POST["password"]) . "\r\n" . - "\r\n"; - fputs($fp, $head); - $Zeilen = -1; - while (!feof($fp)) { - $Temp = fgets($fp, 1024); - - // ende des headers - if ($Temp == "f20\r\n") { - $Zeilen = 0; - $Temp = ""; - } - - //file ende? - if ($Temp == "0\r\n") - break; - - if (($Zeilen > -1) && ($Temp != "ffb\r\n")) { - //steuerzeichen ausfiltern - if (strpos("#$Temp", "\r\n") > 0) - $Temp = substr($Temp, 0, strlen($Temp) - 2); - if (strpos("#$Temp", "1005") > 0) - $Temp = ""; - if (strpos("#$Temp", "783") > 0) - $Temp = ""; - //schreiben in file - fputs($fileOut, $Temp); - $Zeilen++; - } - } - fclose($fileOut); - - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose($fp); - } - } - elseif ($PentabarfGetWith == "fopen") { - //user uns password in url einbauen - $FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" . - $PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"]; - - if (($fileIn = fopen($FileNameIn, "r")) != FALSE) { - if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { - $Zeilen = 0; - while (!feof($fileIn)) { - $Zeilen++; - fputs($fileOut, fgets($fileIn)); - } - fclose($fileOut); - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose($fileIn); - } else - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!

"; - } - elseif ($PentabarfGetWith == "wget") { - $Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " . - "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . - " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" . - " --no-check-certificate"; - echo system($Command, $Status); - if ($Status == 0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif ($PentabarfGetWith == "lynx") { - $Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " . - "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML"; - echo system($Command, $Status); - if ($Status == 0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif ($PentabarfGetWith == "fopen") { - //user uns password in url einbauen - $FileNameIn = "https://" . $_POST["PentabarfUser"] . ':' . $_POST["password"] . "@" . - $PentabarfXMLhost . "/" . $PentabarfXMLpath . $_POST["PentabarfURL"]; - - if (($fileIn = fopen($FileNameIn, "r")) != FALSE) { - if (($fileOut = fopen("$Tempdir/engelXML", "w")) != FALSE) { - $Zeilen = 0; - while (!feof($fileIn)) { - $Zeilen++; - fputs($fileOut, fgets($fileIn)); - } - fclose($fileOut); - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose($fileIn); - } else - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . "' not readable!

"; - } - elseif ($PentabarfGetWith == "wget") { - $Command = "wget --http-user=" . $_POST["PentabarfUser"] . " --http-passwd=" . $_POST["password"] . " " . - "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . - " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML" . - " --no-check-certificate"; - echo system($Command, $Status); - if ($Status == 0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif ($PentabarfGetWith == "lynx") { - $Command = "lynx -auth=" . $_POST["PentabarfUser"] . ":" . $_POST["password"] . " -dump " . - "https://$PentabarfXMLhost/$PentabarfXMLpath" . $_POST["PentabarfURL"] . " > $Tempdir/engelXML"; - echo system($Command, $Status); - if ($Status == 0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } else - echo "

The PentabarfGetWith='$PentabarfGetWith' not supported

"; -} else { - echo "
\n"; - echo "\n"; - echo "\t" . - "\n"; - echo "\t" . - "\n"; - echo "\t" . - "\n"; - echo "\t\n"; - echo "
XCAL-File: https://$PentabarfXMLhost/$PentabarfXMLpath
Username:
Password:
\n"; - echo "
\n"; -} - -//readXMLfile("xml.php.xml"); -if (readXMLfile("$Tempdir/engelXML") == 0) { - $XMLmain = getXMLsubPease($XMLmain, "VCALENDAR"); - - if ($ShowDataStrukture) { - echo "

";
-		echo $XMLmain->name;
-		echo "
";
-		print_r(array_values($XMLmain->sub));
-		echo "
"; - } - - /* - 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, "X-WR-CALDESC"); - echo "release: " . $XMLrelease->data . "
\n"; - //$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE"); - //echo "release date: ". $XMLreleaseDate->data. "
\n"; - echo "
\n"; - - /*############################################################################################## - V e r s i o n - ##############################################################################################*/ - if ($EnableRoomFunctions) - include ("includes/funktion_xml_room.php"); - - if ($EnableSchudleFunctions) - include ("includes/funktion_xml_schudle.php"); - - /*############################################################################################## - U P D A T E A L L - ##############################################################################################*/ - echo "\n\n
\n

Update ALL:

\n"; - - echo "
\n"; - echo "\t\n"; - echo "
\n"; - -} //if XMLopenOOK - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/dect.php b/www-ssl/admin/dect.php deleted file mode 100644 index 4e9f472a..00000000 --- a/www-ssl/admin/dect.php +++ /dev/null @@ -1,69 +0,0 @@ -\n"; -echo "\n"; - -echo "\n"; - -echo "\n"; - -echo "\n"; -echo "\n"; -echo ""; -echo "
Numberh:m
\n"; -// Listet alle Nicks auf -echo "\n"; - -echo "\n"; -echo ":"; -echo "
\n"; - -echo ""; - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php deleted file mode 100644 index b45fadcf..00000000 --- a/www-ssl/admin/free.php +++ /dev/null @@ -1,98 +0,0 @@ -\n"; - -echo "

\n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:

\n"; - -####################################################### -# Ermitteln freier Engel -# -# auslesen aller Engel und dazugehoerige Schichten -####################################################### - -// $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtplan ON User.UID=Schichtbelegung.UID, Schichtplan.SID LEFT JOIN Schichtbelegung.SID WHERE User.UID = Schichtbelegung.UID AND Schichtplan.SID = Schichtbelegung.SID AND Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick"; - -/* geht nicht ??? unter stabel !! -$SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung.* ". - "FROM Schichtplan, User LEFT OUTER ". - "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". - "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". - "Schichtplan.Date < now() and ". - "Schichtplan.EndDate > now() ". - "ORDER BY Nick"; - -$SQL = "SELECT Shifts.*, ShiftEntry.*, User.Nick ". - "FROM User ". - "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". - "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; -*/ -$SQL = "SELECT Shifts.*, ShiftEntry.* " . -"FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID " . -"WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; - -//SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID, Schichtplan LEFT JOIN Schichtbelegung ON Schichtplan.SID = Schichtbelegung.SID WHERE Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick - -//echo "
$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 "
NickSchichtOrtVonBis
" . - 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 "
NickDECT
" . - mysql_result($Erg, $i, "Nick") . "" . mysql_result($Erg, $i, "DECT") . "
\n"; - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/free_DECT.php b/www-ssl/admin/free_DECT.php deleted file mode 100644 index 4b4e3085..00000000 --- a/www-ssl/admin/free_DECT.php +++ /dev/null @@ -1,65 +0,0 @@ -=Now() AND ShiftEntry.UID>0);"; - -$Erg = mysql_query($SQL, $con); -$Zeilen = mysql_num_rows($Erg); - -$inuse = ""; -for ($i = 0; $i < $Zeilen; $i++) { - if ($inuse != "") - $inuse .= " OR "; - $inuse .= "(UID = \"" . mysql_result($Erg, $i, "UID") . "\")"; -} -if ($inuse != "") { - $inuse = " WHERE (NOT (" . $inuse . ")) AND (DECT!='')"; -} else { - $inuse = " WHERE (DECT!='')"; -} - -//########################################################################################################## - -$SQL = "SELECT * FROM User" . $inuse . ";"; -$Erg = mysql_query($SQL, $con); -$Zeilen = mysql_num_rows($Erg); -for ($i = 0; $i < $Zeilen; $i++) { - // get DECT number - echo mysql_result($Erg, $i, "DECT") . "\t"; - - // get all user rights - $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=" . mysql_result($Erg, $i, "UID") . ";"; - $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); - $UserRights = mysql_fetch_array($Erg_RIGHT); - - foreach ($UserRights as $Var => $Value) { - if ((strpos($Var, ".php") === false) AND (strpos($Var, "/") === false) AND (strpos($Var, "UID") === false) AND (is_numeric($Var) === false)) { - echo "\"" . $Var . "\"=" . $Value . "\t"; - } - } - - // get shift types - $SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=" . mysql_result($Erg, $i, "UID") . " GROUP BY TID;"; - $Erg_TYPES = mysql_query($SQL_TYPES, $con); - $Zeilen_Typen = mysql_num_rows($Erg_TYPES); - for ($j = 0; $j < $Zeilen_Typen; $j++) { - echo "\"TID_" . TID2Type(mysql_result($Erg_TYPES, $j, "TID")) . "\"=Y\t"; - } - - echo "\n"; - // echo "
"; -} -?> - diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php deleted file mode 100755 index 4854acb6..00000000 --- a/www-ssl/admin/room.php +++ /dev/null @@ -1,199 +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 "
\n"; - echo "\n"; - - for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) - { - if( (mysql_field_name($Erg, $Uj) == "show") || (mysql_field_name($Erg, $Uj) == "FromPentabarf") ) - { - echo "". - "\n"; - } - else - { - //sonderfall fuer Default Engel - if( substr( mysql_field_name($Erg, $Uj), 0, 12) == "DEFAULT_EID_") - $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $Uj), 12)]; - else - $FeldName = mysql_field_name($Erg, $Uj); - - echo "". - "\n"; - } - } - echo "
". mysql_field_name($Erg, $Uj). "". - "Yes". - "No". - "
$FeldName"; - echo "
\n"; - echo "\n"; - echo "\n"; - echo "
"; - break; - -case 'newsave': - $vars = $_GET; - $count = count($vars) - 1; - $vars = array_splice($vars, 0, $count); - $Keys = ""; - $Values = ""; - foreach($vars as $key => $value) - { - $Keys .= ", `$key`"; - $Values .= ", '$value'"; - } - $SQL = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")"; - SetHeaderGo2Back(); - break; - -case 'change': - if (! IsSet($_GET["RID"])) - echo "Fehlerhafter Aufruf!"; - else - { - $SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; - $ERG = mysql_query($SQL2, $con); - - if( mysql_num_rows( $ERG)>0) - { - echo "Raum abändern:\n"; - echo "Hier kannst du eintragen, welche und wieviele Engel für den Raum zur Verf?gung stehen müssen."; - echo "
\n"; - echo "\n"; - - for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) - { - if( (mysql_field_name($ERG, $Uj) == "show") || (mysql_field_name($ERG, $Uj) == "FromPentabarf") ) - { - echo "". - "\n"; - } - else - { - if( substr( mysql_field_name($ERG, $Uj), 0, 12) == "DEFAULT_EID_") - //sonderfall fuer Default Engel - $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($ERG, $Uj), 12)]; - else - $FeldName = mysql_field_name($ERG, $Uj); - echo "". - "\n"; - } - } - echo "
". mysql_field_name($Erg, $Uj). "". - "Yes". - "No". - "
$FeldName". - "
\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "
"; - echo "
\n"; - echo "\n"; - echo "\n"; - echo ""; - echo "
"; - } - else - echo "FEHLER: Room ID ". $_GET["RID"]. " nicht gefunden"; - } - break; - -case 'changesave': - $sql=""; - $vars = $_GET; - $count = count($vars) - 2; - $vars = array_splice($vars, 0, $count); - foreach($vars as $key => $value) - { - $keys = substr($key,1); - $sql .= ", `".$keys."`='".$value."' "; - } - $SQL = "UPDATE `Room` SET ". substr($sql, 2). " WHERE `RID`='". $_GET["eRID"]. "'"; - SetHeaderGo2Back(); - break; - -case 'delete': - if (IsSet($_GET["RID"])) { - $SQL="DELETE FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; - } else { - echo "Fehlerhafter Aufruf"; - } - SetHeaderGo2Back(); - break; - -} //switch - - -// Update ??? - -if (IsSet($SQL)){ -// echo $SQL; - // hier muesste das SQL ausgefuehrt werden... - $Erg = db_query($SQL, "exec SQL"); - if ($Erg == 1) - echo "Änderung wurde gesichert...
"; - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

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

Schichtplan

- \ No newline at end of file diff --git a/www-ssl/admin/schichtplan.php b/www-ssl/admin/schichtplan.php deleted file mode 100644 index 70ef5a6a..00000000 --- a/www-ssl/admin/schichtplan.php +++ /dev/null @@ -1,362 +0,0 @@ -\n"; - if ($Erg == 1) { - echo "SQL war erfolgreich"; - } else { - echo "SQL Fehler (" . mysql_error($con) . ")"; - } -} - -if (!IsSet ($_GET["action"])) { - echo "Hallo " . $_SESSION['Nick'] . ",
\n"; - echo "hier kannst du Schichten anlegen, ändern oder löschen.

"; - echo "Neue Schicht einplanen

\n\n"; - - echo "
\n"; -?> - - - - - - - - -\n"; - echo "\t\t\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 "
DatumRaumDauerÄndern
" . mysql_result($Erg, $i, "DateS") . "" . mysql_result($Erg2, 0, "Name") . "Unbenkannt (RID=" . mysql_result($Erg, $i, "RID") . ")" . mysql_result($Erg, $i, "Len") . " Std. ####
\n"; - - echo "\n"; - echo "\n"; - echo "
\n"; - -} else { - - // aus sicherheitzgr�nden wegen sp�terer genuzung - UnSet ($chSQL); - - switch ($_GET["action"]) { - - case 'change' : - if (!IsSet ($_GET["SID"])) { - echo "Fehlerhafter Aufruf!\n"; - } else { - - $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )"; - $Erg = mysql_query($sql, $con); - - echo "Schicht abändern:
\n"; - - // Anzeige Allgemeiner schaischt daten - echo "
"; - echo "\n"; - echo " " . - "\n"; - echo " \n"; - - echo " " . - "\n"; - echo " " . - "\n"; - echo " " . - "\n"; - if ($FromPentabarf == "Y") { - echo " " . - "\n"; - } - echo "
Schichtbeginn
Raum\n\n
Dauer in h
Beschreibung
URL

!!! Imported from Pentabarf !!!

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

\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 "
\n Anzahl New\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'] . "' " . - "WHERE (`SID`='" . $_GET["SID"] . "' AND " . - "`TID`='" . $_GET["TID"] . "' AND `UID`='0' ) LIMIT 1"; - } else { - $chSQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (" . - "'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', " . - "'" . $_GET["UIDs"] . "', 'shift added by " . $_SESSION['Nick'] . "')"; - } - echo "Es wird folgende Schicht zusätzlich eingetragen:
\n"; - echo "Engel: " . UID2Nick($_GET["UIDs"]) . "
\n"; - echo "Bemerkung: Schicht eingetragen durch Erzengel " . $_SESSION['Nick'] . "
\n
\n"; - } else { - echo "Es wird folgende Schicht wurde " . $_GET["eAnzahlNew"] . "x zusätzlich eingetragen:
\n"; - for ($i = 0; $i < $_GET["eAnzahlNew"]; $i++) { - echo "$i.
\n"; - $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES ("; - $SQL .= "'" . $_GET["SID"] . "', '" . $_GET["TID"] . "', '0', NULL)"; - $ERG = mysql_query($SQL, $con); - if ($debug) - echo "DEBUG SQL: $SQL
\n"; - if ($ERG == 1) { - echo "Änderung wurde gesichert...
"; - } else { - echo "Fehler beim speichern... bitte noch ein mal probieren :)
"; - echo mysql_error($con); - } - 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"; - if (isset ($_GET["freeloader"]) && $_GET["freeloader"] == 1) { - $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "' )"; - $Erg = mysql_query($sql, $con); - if (mysql_num_rows($Erg) == 1) { - $UID = $_GET["UIDs"]; - $Length = mysql_result($Erg, 0, "Len"); - $Comment = "Start: " . mysql_result($Erg, 0, "DateS") . "; " . - "Beschreibung: " . mysql_result($Erg, 0, "Man") . "; " . - "Removed by " . $_SESSION['Nick']; - $ch2SQL = "INSERT INTO `ShiftFreeloader` (`Remove_Time`, `UID`, `Length`, `Comment`) " . - "VALUES ( CURRENT_TIMESTAMP, '$UID', '$Length', '$Comment');"; - } - } - break; - - case 'engelshiftdel' : - $chSQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "' AND `TID`='" . - $_GET["TID"] . "' AND `UID`='0' LIMIT 1"; - break; - - case 'changesave' : - $query = mysql_query("SELECT DATE_ADD('" . $_GET["eDate"] . "', INTERVAL '+0 " . $_GET["eDauer"] . "' DAY_HOUR)", $con); - $enddate = mysql_fetch_row($query); - - $chSQL = "UPDATE `Shifts` SET " . - "`DateS`='" . $_GET["eDate"] . "', " . - "`DateE`='" . $enddate[0] . "', " . - "`RID`='" . $_GET["eRID"] . "', " . - "`Len`='" . $_GET["eDauer"] . "', " . - "`Man`='" . $_GET["eName"] . "', " . - "`URL`='" . $_GET["eURL"] . "' " . - "WHERE `SID`='" . $_GET["SID"] . "'"; - SetHeaderGo2Back(); - break; - - case 'delete' : - $chSQL = "DELETE FROM `Shifts` WHERE `SID`='" . $_GET["SID"] . "' LIMIT 1"; - $ch2SQL = "DELETE FROM `ShiftEntry` WHERE `SID`='" . $_GET["SID"] . "'"; - SetHeaderGo2Back(); - break; - - case 'deleteShifs' : - foreach ($_GET as $k => $v) - if (strpos(" " . $k, "SID") == 1) { - echo "Shifts $v wird gel�scht..."; - executeSQL("DELETE FROM `Shifts` WHERE `SID`='$v' LIMIT 1"); - echo "
\n"; - echo "ShiftEntry $v wird gel�scht..."; - executeSQL("DELETE FROM `ShiftEntry` WHERE `SID`='$v'"); - echo "

\n"; - } - break; - - } // end switch - - if (IsSet ($chSQL)) { - // echo $chSQL; - // hier muesste das SQL ausgefuehrt werden... - $Erg = mysql_query($chSQL, $con); - if ($debug) - echo "DEBUG SQL: $chSQL
\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 ("includes/footer.php"); -?> diff --git a/www-ssl/admin/schichtplan_druck.1.php b/www-ssl/admin/schichtplan_druck.1.php deleted file mode 100644 index 30761390..00000000 --- a/www-ssl/admin/schichtplan_druck.1.php +++ /dev/null @@ -1,5 +0,0 @@ -

Schichtplan

- -
  • Ein-/Austragen
    • -
  • Druckversion
    • - diff --git a/www-ssl/admin/schichtplan_druck.php b/www-ssl/admin/schichtplan_druck.php deleted file mode 100644 index 3e856c5e..00000000 --- a/www-ssl/admin/schichtplan_druck.php +++ /dev/null @@ -1,119 +0,0 @@ -\n" . - "auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. Wähle hierfür ein Datum und den Raum:\n" . - "
    \n"; - - foreach ($VeranstaltungsTage as $k => $v) { - - $res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY `Name`;", $con); - for ($i = 0; $i < mysql_num_rows($res); $i++) { - $Tag = $VeranstaltungsTage[$k]; - $RID = mysql_result($res, $i, "RID"); - $Rname = mysql_result($res, $i, "Name"); - echo "\t$Tag $Rname
    \n"; - } - echo "
    \n"; - } - echo "

    "; - - include ("includes/footer.php"); -} else //################################################################# - { - if (IsSet ($_GET["Raum"]) AND IsSet ($_GET["ausdatum"])) { - $Raum = $_GET["Raum"]; - $ausdatum = $_GET["ausdatum"]; - - include ("config/config_db.php"); - include ("config/config.php"); - include ("includes/secure.php"); - //var wird nur gesetzt immer edit auszublenden, achtung sesion darf nicht gestart sein !!! - $_SESSION['CVS']["admin/schichtplan.php"] = "N"; - include ("includes/funktion_lang.php"); - include ("includes/funktion_schichtplan.php"); - include ("includes/funktion_schichtplan_aray.php"); - include ("includes/funktion_user.php"); -?> - - - - -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 "
    UhrzeitSchichtplanbelegung
    "; - 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) . "
    \n"; - - echo "Stand: " . gmdate("Y-m-d H:i") . "\n"; - echo "\n"; - echo "\n"; - - } //isset($Vars) -} //isset($Action) -?> diff --git a/www-ssl/admin/shiftadd.php b/www-ssl/admin/shiftadd.php deleted file mode 100644 index d6b1f8ff..00000000 --- a/www-ssl/admin/shiftadd.php +++ /dev/null @@ -1,350 +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"); -} - -// sesion mit stanadrt werten bef�llen -if (!isset ($_SESSION['shiftadd.php']['SchichtName'])) { - $_SESSION['shiftadd.php']['SchichtName'] = "--???--"; - $_SESSION['shiftadd.php']['RID'] = ""; - $_SESSION['shiftadd.php']['MonthJahr'] = gmdate("Y-m", $Time); - $_SESSION['shiftadd.php']['SDatum'] = gmdate("d", $Time); - $_SESSION['shiftadd.php']['STime'] = "10"; - $_SESSION['shiftadd.php']['MoreThenOne'] = "ON"; - $_SESSION['shiftadd.php']['EDatum'] = gmdate("d", $Time); - $_SESSION['shiftadd.php']['ETime'] = "12"; - $_SESSION['shiftadd.php']['len'] = "2"; - $_SESSION['shiftadd.php']['NachtON'] = "OFF"; - $_SESSION['shiftadd.php']['len_night'] = "00-04-08-10-12-14-16-18-20-22-24"; -} -// wenn werte �bergeben in sesion eintragen -if (!isset ($_GET["NachtON"])) - $_GET["NachtON"] = "OFF"; -if (!isset ($_GET["MoreThenOne"])) - $_GET["MoreThenOne"] = "OFF"; -if (isset ($_GET["SchichtName"])) { - foreach ($_GET as $k => $v) { - $_SESSION['shiftadd.php'][$k] = $v; - } -} - -if (!IsSet ($_GET["action"])) - $_GET["action"] = "new"; - -switch ($_GET["action"]) { - case 'new' : -?> -Hier kannst du neue Schichten eintragen. Dazu musst du den Anfang und das Ende der Schichten eintragen. -Über die Länge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch können gleich -mehrere Schichten auf einmal erfasst werden: - -
    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\n"; - echo " \n"; - } -?> -
    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"] . ":
    -
    - - - -
    - - 0)) { - $lenOrg = $_GET["len"]; - if ($_GET["NachtON"] == "ON") { - $lenArrayDummy = explode("-", $_GET["len_night"]); - foreach ($lenArrayDummy as $Temp) { - if (isset ($Temp2)) - $lenArray[intval($Temp2)] = intval($Temp) - intval($Temp2); - $Temp2 = $Temp; - } //foreach - } //IF( $NachtON == "ON" ) - - echo "\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 = intval($_GET["STime"]); - $len = 0; - do { - // define Start time - $Date = $DateEnd; - $Time = $TimeEnd; - $_DateS = $_GET["MonthJahr"] . "-" . $Date . " " . $Time . ":00:00"; - - // define End time - if ($_GET["NachtON"] == "ON") { - if (!isset ($lenArray[$Time])) - die("Zeit $Time h nicht definiert."); - $_GET["len"] = $lenArray[$Time]; - if ($_GET["len"] < 1) - die("len <1"); - } - $TimeEnd = $Time + $_GET["len"]; - - //Tages�berschreitung - while ($TimeEnd >= 24) { - $TimeEnd -= 24; - $DateEnd += 1; - } - //ist schischt zu lang dan verk�rzen - if ($DateEnd > $_GET["EDatum"] || ($DateEnd == $_GET["EDatum"] && $TimeEnd >= $_GET["ETime"])) { - $_GET["len"] -= ($DateEnd - $_GET["EDatum"]) * 24; - $_GET["len"] -= ($TimeEnd - $_GET["ETime"]); // -(-) ->> + - $DateEnd = $_GET["EDatum"]; - $TimeEnd = $_GET["ETime"]; - } - $_DateE = $_GET["MonthJahr"] . "-" . $DateEnd . " " . $TimeEnd . ":00:00"; - - if ($_DateS != $_DateE) - CreateNewEntry(); - - if ($_GET["MoreThenOne"] != "ON") - break; - if ($DateEnd >= $_GET["EDatum"] && $TimeEnd >= intval($_GET["ETime"])) - break; - } - while (true); - echo "
    StartEndlenRIDBeschreibungEntry 'Shifts'SIDEntrys
    "; - - if ($_GET["OnlyShow"] == "ON") { - echo "
    "; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - foreach ($EngelType As $TTemp) { - $Temp = "EngelType" . $TTemp["TID"]; - echo "\n\t"; - } - echo "\n\t"; - echo "\n\t"; - echo "\n
    "; - } //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") { - // erstellt Eintrag in Shifts f�r die algemeine schicht - $SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( "; - $SQL .= "'" . $_DateS . "', '" . $_DateE . "', "; - $SQL .= "'" . $_GET["len"] . "', '" . $_GET["RID"] . "', "; - $SQL .= "'" . $_GET["SchichtName"] . "');"; - $Erg = db_query($SQL, "create shift"); - - $SQLFail = "\n\t
    [" . $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 ("includes/footer.php"); -?> diff --git a/www-ssl/admin/tshirt.php b/www-ssl/admin/tshirt.php deleted file mode 100644 index 9a8e7010..00000000 --- a/www-ssl/admin/tshirt.php +++ /dev/null @@ -1,62 +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 "
    NickAktiv?GrösseT-Shirt ausgeben:" . UID2Nick($eUID) . "" . mysql_result($Erg, $i, "Aktiv") . "" . mysql_result($Erg, $i, "Size") . "bereits erhaltenXXXXXXXX
    "; - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/userArrived.php b/www-ssl/admin/userArrived.php deleted file mode 100644 index 93857d2e..00000000 --- a/www-ssl/admin/userArrived.php +++ /dev/null @@ -1,53 +0,0 @@ -" . Get_Text("pri_userArrived_WriteOK") . " \"" . UID2Nick($_GET["arrived"]) . "\""; - } else { - echo "

    " . Get_Text("pri_userArrived_WriteError") . " \"" . UID2Nick($_GET["arrived"]) . "\"

    "; - } -} - -echo Get_Text("pri_userArrived_Text1") . "
    "; -echo Get_Text("pri_userArrived_Text2") . "

    "; - -echo Get_Text("pri_userArrived_TableToppic"); -$SQL = "SELECT * FROM `User` ORDER BY `Nick` ASC"; -$Erg = mysql_query($SQL, $con); - -$rowcount = mysql_num_rows($Erg); - -echo "\n"; -echo "\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\t\n"; -echo "\t\n"; - -for ($i = 0; $i < $rowcount; $i++) { - echo "\t\n"; - $eUID = mysql_result($Erg, $i, "UID"); - echo "\t\t\n"; - echo "\t\t\n"; - - if (mysql_result($Erg, $i, "Gekommen") == "1") { - echo "\t\t"; - } else { - echo "\t\t"; - } - echo "\t\n"; -} -echo "
    " . Get_Text("pri_userArrived_TableTD_Nick") . "" . Get_Text("pri_userArrived_TableTD_ArrivedShow") . "" . Get_Text("pri_userArrived_TableTD_ArrivedSet") . "
    " . UID2Nick($eUID) . "" . mysql_result($Erg, $i, "Gekommen") . "" . Get_Text("pri_userArrived_TableEntry_Arrived") . "" . Get_Text("pri_userArrived_TableEntry_Set") . "
    "; - -include ("includes/footer.php"); -?> - -- cgit v1.2.3-54-g00ecf