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 --- www-ssl/nonpublic/einstellungen.php | 236 +++++++++++++++++++++++++++++++ www-ssl/nonpublic/engelbesprechung.php | 29 ++++ www-ssl/nonpublic/faq.php | 71 ++++++++++ www-ssl/nonpublic/inc | 1 + www-ssl/nonpublic/index.php | 103 ++++++++++++++ www-ssl/nonpublic/menu.php | 33 +++++ www-ssl/nonpublic/myschichtplan.php | 149 +++++++++++++++++++ www-ssl/nonpublic/news.php | 11 ++ www-ssl/nonpublic/news_comments.php | 87 ++++++++++++ www-ssl/nonpublic/news_output.php | 114 +++++++++++++++ www-ssl/nonpublic/passwort.php | 58 ++++++++ www-ssl/nonpublic/pic | 1 + www-ssl/nonpublic/schichtplan.1.php | 20 +++ www-ssl/nonpublic/schichtplan.2.php | 12 ++ www-ssl/nonpublic/schichtplan.php | 154 ++++++++++++++++++++ www-ssl/nonpublic/schichtplan_add.php | 98 +++++++++++++ www-ssl/nonpublic/schichtplan_beamer.php | 64 +++++++++ www-ssl/nonpublic/schichtplanneu.1.php | 17 +++ www-ssl/nonpublic/schichtplanneu.php | 106 ++++++++++++++ www-ssl/nonpublic/waeckliste.php | 43 ++++++ www-ssl/nonpublic/wecken.php | 82 +++++++++++ 21 files changed, 1489 insertions(+) create mode 100755 www-ssl/nonpublic/einstellungen.php create mode 100755 www-ssl/nonpublic/engelbesprechung.php create mode 100755 www-ssl/nonpublic/faq.php create mode 120000 www-ssl/nonpublic/inc create mode 100755 www-ssl/nonpublic/index.php create mode 100755 www-ssl/nonpublic/menu.php create mode 100755 www-ssl/nonpublic/myschichtplan.php create mode 100755 www-ssl/nonpublic/news.php create mode 100755 www-ssl/nonpublic/news_comments.php create mode 100755 www-ssl/nonpublic/news_output.php create mode 100755 www-ssl/nonpublic/passwort.php create mode 120000 www-ssl/nonpublic/pic create mode 100755 www-ssl/nonpublic/schichtplan.1.php create mode 100755 www-ssl/nonpublic/schichtplan.2.php create mode 100755 www-ssl/nonpublic/schichtplan.php create mode 100755 www-ssl/nonpublic/schichtplan_add.php create mode 100755 www-ssl/nonpublic/schichtplan_beamer.php create mode 100755 www-ssl/nonpublic/schichtplanneu.1.php create mode 100755 www-ssl/nonpublic/schichtplanneu.php create mode 100755 www-ssl/nonpublic/waeckliste.php create mode 100755 www-ssl/nonpublic/wecken.php (limited to 'www-ssl/nonpublic') diff --git a/www-ssl/nonpublic/einstellungen.php b/www-ssl/nonpublic/einstellungen.php new file mode 100755 index 00000000..214593ae --- /dev/null +++ b/www-ssl/nonpublic/einstellungen.php @@ -0,0 +1,236 @@ +\n\n"; + Print_Text(13); +?> +
+ +
+ + + + + + + + + + + + + + + + + + +
">
+ +
+
+ + +
+ +
+ + + + + +
+ +
+
+ + +
+
+ +
+ + + + +
+ +
+ +
+
+
+
+ +
+ + + + +
+ +
+ +
+
+
+
+ +
+ + + + + + + + +

+
+ + + + +    + +
+ +
+ + + diff --git a/www-ssl/nonpublic/engelbesprechung.php b/www-ssl/nonpublic/engelbesprechung.php new file mode 100755 index 00000000..436a5271 --- /dev/null +++ b/www-ssl/nonpublic/engelbesprechung.php @@ -0,0 +1,29 @@ + + +
+ +".mysql_result($Erg, $n, "Betreff")."
". + "   ".mysql_result($Erg, $n, "Datum").", "; + echo UID2Nick(mysql_result($Erg, $n, "UID"))."

\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Text"))."

\n"; + } +} + + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/faq.php b/www-ssl/nonpublic/faq.php new file mode 100755 index 00000000..6470ba4f --- /dev/null +++ b/www-ssl/nonpublic/faq.php @@ -0,0 +1,71 @@ + +

+
+ +

+ +
+".Get_Text(37)."

\n".nl2br($_POST["frage"])."

\n".Get_Text(38)."
\n"; + +$SQL = "INSERT into Questions VALUES (\"\", \"".$_SESSION['UID']."\", \"". $_POST["frage"]. "\", \"\", \"\")"; +$Erg = mysql_query($SQL, $con); + +} +// Bisherige Anfragen: +echo "
\n".Get_Text(39)."
\n"; +echo "
\n"; +echo "
".Get_Text(40)."
\n"; + +$SQL = "SELECT * from Questions where UID = ".$_SESSION['UID']." and AID=\"0\" ORDER BY 'QID' DESC"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$Zeilen = mysql_num_rows($Erg); + +if ($Zeilen==0){ + Print_Text(41); + +} else { + for ($n = 0 ; $n < $Zeilen ; $n++) { + echo "

".nl2br(mysql_result($Erg, $n, "Question"))."
\n"; +// Es gibt ja noch keine Antwort: +// echo "

".nl2br(mysql_result($Erg, $n, "Answer"))."

\n"; + echo "\n
---
"; + } +} + +echo "
\n"; +echo "
".Get_Text(42)."
\n"; +$SQL = "SELECT * from Questions where UID = ".$_SESSION['UID']." and AID<>\"0\" ORDER BY 'QID' DESC"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$Zeilen = mysql_num_rows($Erg); + +if ($Zeilen==0){ + Print_Text(41); +} else { + for ($n = 0 ; $n < $Zeilen ; $n++) { + echo "

".nl2br(mysql_result($Erg, $n, "Question"))."
\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Answer"))."\n"; + echo "\n
---
"; + } +} + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/inc b/www-ssl/nonpublic/inc new file mode 120000 index 00000000..22dc542a --- /dev/null +++ b/www-ssl/nonpublic/inc @@ -0,0 +1 @@ +../inc \ No newline at end of file diff --git a/www-ssl/nonpublic/index.php b/www-ssl/nonpublic/index.php new file mode 100755 index 00000000..d46b0a10 --- /dev/null +++ b/www-ssl/nonpublic/index.php @@ -0,0 +1,103 @@ + 1 --> keine Anmeldung + include ("./inc/header.php"); + if ($user_anz == 0) + { + echo Get_Text("pub_index_User_unset"); + } + else + { + echo Get_Text("pub_index_User_more_as_one"); + } + + include ("./inc/login_eingabefeld.php"); + } // Ende Check, ob User angemeldet wurde +} +else +{ // User ist bereits angemeldet... normaler Inhalt... + + include ("./inc/header.php"); + echo Get_Text(1).$_SESSION['Nick']; + echo nl2br(Get_Text(2)); + + include ("./news_output.php"); + +} // Ende Ueberpruefung, ob User bereits angemeldet... + + + +?> + + + + diff --git a/www-ssl/nonpublic/menu.php b/www-ssl/nonpublic/menu.php new file mode 100755 index 00000000..7dac48bb --- /dev/null +++ b/www-ssl/nonpublic/menu.php @@ -0,0 +1,33 @@ + diff --git a/www-ssl/nonpublic/myschichtplan.php b/www-ssl/nonpublic/myschichtplan.php new file mode 100755 index 00000000..dba8b6a9 --- /dev/null +++ b/www-ssl/nonpublic/myschichtplan.php @@ -0,0 +1,149 @@ +\n"; + echo Get_Text("pub_mywake_beschreibung1")."
\n"; + echo Get_Text("pub_mywake_beschreibung2")."

\n"; + echo Get_Text("pub_mywake_beschreibung3").($LETZTES_AUSTRAGEN). + Get_Text("pub_mywake_beschreibung4")."

\n"; + + $SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` ". + "INNER JOIN `ShiftEntry` ". + "ON `Shifts`.`SID`=`ShiftEntry`.`SID` ". + "WHERE `ShiftEntry`.`UID`='". $_SESSION['UID']. "' ". + "ORDER BY `DateS`"; + $erg = mysql_query($SQL, $con); + + ?> + + + + + + + + + + "; + + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + + // bis $LETZTES_AUSTRAGEN (aus dem config-file) soll es moeglich sein, seine Schichten + //// selber noch austragen zu koennen... + $schichtdate = mysql_result( $erg, $i, "DateS" ); + ereg( "^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})", $schichtdate, $res ); + $info["year"] = $res[1]; + $info["month"] = $res[2]; + $info["day"] = $res[3]; + $info["hour"] = $res[4]; + $info["min"] = $res[5]; + $info["sec"] = $res[6]; + $schichtdatum = (mktime($info["hour"],$info["min"],$info["sec"],$info["month"],$info["day"],$info["year"])); + $lastAustragen = $LETZTES_AUSTRAGEN*3600; + $nowdate = time(); + // wenn Schichtbeginn > jetziges Datum + $LETZTES_AUSTRAGEN - Stunden soll ein Austragen + // noch möglich sein + if( $schichtdatum > ($lastAustragen + $nowdate) ) + echo "\n"; + else + echo "\n"; + + echo "\n"; + } +echo "
". substr(mysql_result( $erg, $i, "DateS" ), 0, 10). "". substr(mysql_result( $erg, $i, "DateS" ), 11). "". mysql_result( $erg, $i, "Len" ). " h". $RoomID[mysql_result( $erg, $i, "RID" )]. "
\n". + "(". TID2Type(mysql_result( $erg, $i, "TID" )).Get_Text("inc_schicht_engel"). ")". + "
\n". 
+		     mysql_result( $erg, $i, "Comment" ). 
+		     "\n
\n"; + echo "
# vi #		 ". + Get_Text("pub_mywake_austragen")."". Get_Text("pub_mywake_austragen_n_c"). "
\n\n"; + +} +else +{ + If( $_GET["action"] == "austragen" ) + { + echo Get_Text("pub_mywake_delate1")."
\n"; + + $sql = "SELECT * FROM `Shifts` WHERE "; + $sql.= "(SID = \"". $_GET["SID"]. "\")"; + $Erg = mysql_query($sql, $con); + + $schichtdate = mysql_result( $Erg, 0, "DateS" ); + ereg( "^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})", $schichtdate, $res ); + $info["year"] = $res[1]; + $info["month"] = $res[2]; + $info["day"] = $res[3]; + $info["hour"] = $res[4]; + $info["min"] = $res[5]; + $info["sec"] = $res[6]; + $schichtdatum = (mktime($info["hour"],$info["min"],$info["sec"],$info["month"],$info["day"],$info["year"])); + $lastAustragen = $LETZTES_AUSTRAGEN*3600; + $nowdate = time(); + // wenn Schichtbeginn > jetziges Datum + $LETZTES_AUSTRAGEN - Stunden soll ein Austragen + // noch möglich sein + if( $schichtdatum > ($lastAustragen + $nowdate) ) + { + $sql2 = "UPDATE `ShiftEntry` ". + "SET `UID` = '0', `Comment` = NULL ". + "WHERE `SID` = '". $_GET["SID"]. "' AND `UID` = '". $_SESSION['UID']. "' LIMIT 1;"; + $Erg2 = mysql_query($sql2, $con); + if ($Erg2 == 1) + echo Get_Text("pub_mywake_add_ok"). "\n"; + else + echo Get_Text("pub_mywake_add_ko"). "\n"; + } + else + echo Get_Text("pub_mywake_after"). "\n"; + } + elseif( $_GET["action"] == "edit" ) + { + echo Get_Text("pub_myshift_Edit_Text1"). "\n"; + + $sql = "SELECT * FROM `ShiftEntry` WHERE "; + $sql.= "(SID=\"". $_GET["SID"]. "\" AND UID=\"". $_SESSION['UID']. "\" )"; + $Erg = mysql_query($sql, $con); + + echo "

\n"; + echo "

\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
"; + } + elseif( $_GET["action"] == "editSave" ) + { + echo Get_Text("pub_myshift_EditSave_Text1"). "
\n"; + $sql = "UPDATE `ShiftEntry` ". + "SET `Comment` = \"". $_GET["newtext"]. "\" ". + "WHERE `SID`='". $_GET["SID"]. "' AND `UID`='". $_SESSION['UID']. "' LIMIT 1;"; + $Erg = mysql_query($sql, $con); + if ($Erg == 1) + echo "\t ...". Get_Text("pub_myshift_EditSave_OK"). "\n"; + else + echo "\t ...". Get_Text("pub_myshift_EditSave_KO"). "\n"; + SetHeaderGo2Back(); + } +} +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/news.php b/www-ssl/nonpublic/news.php new file mode 100755 index 00000000..107f5913 --- /dev/null +++ b/www-ssl/nonpublic/news.php @@ -0,0 +1,11 @@ +".Get_Text(3).""; +include ("news_output.php"); + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/news_comments.php b/www-ssl/nonpublic/news_comments.php new file mode 100755 index 00000000..d2c450ea --- /dev/null +++ b/www-ssl/nonpublic/news_comments.php @@ -0,0 +1,87 @@ +
"; } +} + +$SQL = "SELECT * FROM news_comments where Refid = $nid ORDER BY 'ID'"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$news_rows = mysql_num_rows($Erg); + +?> + + + + + + + + + +"; + echo "\t\t"; + echo "\t\t"; + echo ""; + echo "\t"; + echo "\t\t"; + echo ""; +} + +echo "
DatumNick
Kommentar
"; + echo mysql_result($Erg, $n, "Datum"); + echo "\t\t"; + echo UID2Nick(mysql_result($Erg, $n, "UID")); + // avatar anzeigen? + echo DisplayAvatar (mysql_result($Erg, $n, "UID")); + echo "\t\t
"; + echo nl2br(mysql_result($Erg, $n, "Text"))."\n"; + echo "\t\t
"; + +?> + +
+
+

Neuer Kommentar:

+  + +
+"> + + + + + + +
Text:
+
+ +
+ + diff --git a/www-ssl/nonpublic/news_output.php b/www-ssl/nonpublic/news_output.php new file mode 100755 index 00000000..9648fc41 --- /dev/null +++ b/www-ssl/nonpublic/news_output.php @@ -0,0 +1,114 @@ += 0 ) { +// echo "

Die vorherigen $DISPLAY_NEWS News anzeigen...
"; +//} + +$SQL = "SELECT * FROM `News` ORDER BY 'ID' DESC LIMIT $news_begin,$DISPLAY_NEWS"; +$Erg = mysql_query($SQL, $con); + +// anzahl zeilen +$news_rows = mysql_num_rows($Erg); + +for ($n = 0 ; $n < $news_rows ; $n++) { + + if (mysql_result($Erg, $n, "Treffen") == 0) { + echo "

"; + } else { + echo "

"; + } + echo "".mysql_result($Erg, $n, "Betreff")."
\n"; + + + echo "   ".mysql_result($Erg, $n, "Datum").", "; + echo UID2Nick(mysql_result($Erg, $n, "UID")).""; + // avatar anzeigen? + echo DisplayAvatar (mysql_result($Erg, $n, "UID")); + echo "

\n"; + echo "

".nl2br(mysql_result($Erg, $n, "Text"))."

\n"; + $RefID=mysql_result($Erg, $n, "ID"); + $countSQL="SELECT COUNT(*) from news_comments where Refid = '$RefID'"; + $countErg = mysql_query($countSQL, $con); + $countcom = mysql_result($countErg, 0, "COUNT(*)"); + echo "

$countcom comments

\n\n"; + + +} +//echo "Die nächsten $DISPLAY_NEWS News anzeigen...

\n"; + +echo "
\n\n"; +$rowerg = mysql_query("select * from News", $con); +$rows = mysql_num_rows($rowerg); +$dis_rows = round (($rows / $DISPLAY_NEWS)+0.5); + +Print_Text(5); + +for ($i=1; $i <= $dis_rows; $i++) { + if (!((($i * $DISPLAY_NEWS) - $news_begin) == $DISPLAY_NEWS)) { + echo "$i  "; + } else { + echo "$i  "; + } +} +echo "
"; + +?> + +
+
+

+  + +
+ +"> + + + + + + + + + + + + + + + + +
+
+ +
diff --git a/www-ssl/nonpublic/passwort.php b/www-ssl/nonpublic/passwort.php new file mode 100755 index 00000000..37860946 --- /dev/null +++ b/www-ssl/nonpublic/passwort.php @@ -0,0 +1,58 @@ + + +Hier kannst du dein Kennwort für unsere Himmelsverwaltung ändern.

+ +
+ + + + + +
Altes Passwort:
Neues Passwort:
Passwortbestätigung:
+ +
+ ok.
"; + echo "Check, ob altes Passwort ok ist."; + $sql = "select * from User where UID=".$_SESSION['UID']; + $Erg = mysql_query($sql, $con); + if (md5($old)==mysql_result($Erg, $i, "Passwort")) { + echo "-> ok.
"; + echo "Setzen des neuen Kennwortes...: "; + $usql = "update User set Passwort='".md5($new1)."' where UID=".$_SESSION['UID']; + $Erg = mysql_query($usql, $con); + if ($Erg==1) { + echo "Neues Kennwort wurde gesetzt."; + } else { + echo "Ein Fehler ist trotzdem noch aufgetreten. Probiere es einfach nocheinmal :)"; + } + + + } else { + echo "-> nicht ok.
"; + echo "Altes Kennwort ist nicht ok. Bitte wiederholen.
"; + } + + } else { + echo "Kennwörter sind nicht gleich. Bitte wiederholen."; + } + + } else { + echo "Ungültiger Aufruf!\n"; + } +} + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/pic b/www-ssl/nonpublic/pic new file mode 120000 index 00000000..a21de85f --- /dev/null +++ b/www-ssl/nonpublic/pic @@ -0,0 +1 @@ +../pic \ No newline at end of file diff --git a/www-ssl/nonpublic/schichtplan.1.php b/www-ssl/nonpublic/schichtplan.1.php new file mode 100755 index 00000000..d284b66d --- /dev/null +++ b/www-ssl/nonpublic/schichtplan.1.php @@ -0,0 +1,20 @@ +

 Tage

+ +$Datum\n"; +} //function Printlink( + +foreach( $VeranstaltungsTage as $k => $v) +{ + Printlink( $v); +} + +?> diff --git a/www-ssl/nonpublic/schichtplan.2.php b/www-ssl/nonpublic/schichtplan.2.php new file mode 100755 index 00000000..8b477f41 --- /dev/null +++ b/www-ssl/nonpublic/schichtplan.2.php @@ -0,0 +1,12 @@ +

 Raum übersicht

+ +". + $RoomEntry["Name"]. "\n"; + +echo "
"; +echo "
  • alle
    • "; +?> + diff --git a/www-ssl/nonpublic/schichtplan.php b/www-ssl/nonpublic/schichtplan.php new file mode 100755 index 00000000..b784be0c --- /dev/null +++ b/www-ssl/nonpublic/schichtplan.php @@ -0,0 +1,154 @@ + + +". + Get_Text("pub_schicht_beschreibung");?> +

    +\n"; + + foreach( $VeranstaltungsTage as $k => $v) + if( $ausdatum == $v) + { + if( $k > 0) + echo "\t\t\t". + "". $VeranstaltungsTage[$k-1]. "\n"; + if( $k < $VeranstaltungsTageMax) + echo "\t\t\t". + "". $VeranstaltungsTage[$k+1]. "\n"; + } + echo "\n\n"; +} + +// wenn kein Datum gesetzt ist (die Seite zum ersten mal aufgerufen wird), +// das Datum auf den ersten Tag setzen... +if( !isset($ausdatum) ) +{ + $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '". gmdate("Y-m-d", time()+3600). "%' ORDER BY `DateS`"; +// $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '2004-12-29%' ORDER BY `DateS`"; + $Erg = mysql_query($sql, $con); + if( mysql_num_rows( $Erg ) == 0 ) + { + $sql = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` ASC LIMIT 0, 1"; + $Erg = mysql_query($sql, $con); + } + $ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10); + +} + + + +if ( !isset($raum) ) +{ + // Ausgabe wenn kein Raum Ausgewählt: + echo Get_Text("pub_schicht_auswahl_raeume"). "

    \n"; + + foreach( $Room as $RoomEntry ) + echo "\t
  • ". + $RoomEntry["Name"]. "
    • \n"; + + echo "

    "; + echo Get_Text("pub_schicht_alles_1"). " ". + Get_Text("pub_schicht_alles_2"). "".Get_Text("pub_schicht_alles_3"); + echo "\n

    \n\n"; + echo "
    \n\n"; + echo Get_Text("pub_schicht_EmptyShifts"). "\n"; + + + // zeit die naesten freien schichten + showEmptyShifts(); +} +else +{ // Wenn einraum Ausgewählt ist: + if( $raum == -1 ) + echo Get_Text("pub_schicht_Anzeige_1").$ausdatum.":

    "; + else + echo Get_Text("pub_schicht_Anzeige_1"). $ausdatum. + Get_Text("pub_schicht_Anzeige_2"). $RoomID[$raum]. "

    "; + + ShowSwitchDay(); + + echo "\n\n\n"; + echo "\t\n"; + echo "\t\t\n"; + + //Ausgabe Spalten überschrift + if( $raum == -1 ) + { + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t\n"; + } + else + echo "\t\t\n"; + echo "\t\n"; + + //Zeit Ausgeben + for( $i = 0; $i < 24; $i++ ) + for( $j = 0; $j < $GlobalZeileProStunde; $j++) + { + $Spalten[$i * $GlobalZeileProStunde + $j] = + "\t\n\t\t"; + if( $j==0) + { + $SpaltenTemp = "\n"; + $Spalten[$i * $GlobalZeileProStunde + $j].= $SpaltenTemp; + } + } + + if( $raum == -1 ) + { + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + CreateRoomShifts( $RoomEntry["RID"] ); + } + else + CreateRoomShifts( $raum ); + + //Ausageb Zeilen + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) + echo $Spalten[$i]."\t\n"; + + echo "
    start". $RoomEntry["Name"]. "". $RoomID[$raum]. "
    "; + if( ($i == gmdate("H", time()+3600)) && (gmdate("Y-m-d", time()+ 3600) == $ausdatum) ) + $SpaltenTemp.= "

    "; + + if( $i < 10 ) + $SpaltenTemp.= "0"; + $SpaltenTemp.= "$i:"; + if( ( ($j*60) / $GlobalZeileProStunde) < 10 ) + $SpaltenTemp.= "0"; + + $SpaltenTemp.= ( ($j*60) / $GlobalZeileProStunde); + if( ($i == gmdate("H", time()+3600)) && (gmdate("Y-m-d", time()+ 3600) == $ausdatum) ) + $SpaltenTemp.= "

    "; + + $SpaltenTemp.= "
    \n"; + + ShowSwitchDay(); + +}//if (isset($raum)) + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/schichtplan_add.php b/www-ssl/nonpublic/schichtplan_add.php new file mode 100755 index 00000000..21a0b508 --- /dev/null +++ b/www-ssl/nonpublic/schichtplan_add.php @@ -0,0 +1,98 @@ += '$beginSchicht') and ". + " (`Shifts`.`DateS` < '$endSchicht'))". + " OR ". + " ((`Shifts`.`DateE` > '$beginSchicht') and ". + " (`Shifts`.`DateE` <= '$endSchicht')) ". + ") and ". + "(`ShiftEntry`.`UID` = '". $_SESSION['UID']. "'));"; + $bErg = mysql_query($SSQL, $con); + + if( mysql_num_rows($bErg) != 0 ) + echo Get_Text("pub_schichtplan_add_AllreadyinShift"); + else + { + //ermitteln der noch gesuchten + $SQL3 = "SELECT * FROM `ShiftEntry`". + " WHERE ((`SID` = '". $_POST["SID"]. "') and (`TID` = '". $_POST["TID"]. "') and (`UID` = '0'));"; + $Erg3 = mysql_query($SQL3, $con); + + if( mysql_num_rows($Erg3) <= 0 ) + echo Get_Text("pub_schichtplan_add_ToManyYousers"); + else + { + //write shift + $SQL = "UPDATE `ShiftEntry` SET ". + "`UID` = '". $_SESSION['UID']. "', ". + "`Comment` = '". $_POST["newtext"]. "' ". + "WHERE ( (`SID` = '". $_POST["SID"]. "') and ". + "(`TID` = '". $_POST["TID"]. "') and ". + "(`UID` = '0')) LIMIT 1;"; + $Erg = mysql_query($SQL, $con); + + if ($Erg != 1) + echo Get_Text("pub_schichtplan_add_Error"); + else + echo Get_Text("pub_schichtplan_add_WriteOK"); + + }//TO Many USERS + }//Allready in Shift +} +elseif (isset($_GET["SID"]) && isset($_GET["TID"])) { + echo Get_Text("pub_schichtplan_add_Text1"). "

    \n\n". + "
    \n". + "\n"; + + $SQL = "SELECT * FROM `Shifts` WHERE "; + $SQL .="(SID = '". $_GET["SID"]. "')"; + $Erg = mysql_query($SQL, $con); + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n"; + + echo "\n \n"; + + echo "\n". + "\n". + "
    ". Get_Text("pub_schichtplan_add_Date"). ": ". + mysql_result($Erg, 0, "DateS"). "
    ". Get_Text("pub_schichtplan_add_Place"). ": ". + $RoomID[ mysql_result($Erg, 0, "RID") ]. "
    ". Get_Text("pub_schichtplan_add_Job"). ": ". + $EngelTypeID[$_GET["TID"]]. "
    ". Get_Text("pub_schichtplan_add_Len"). ": ". + mysql_result($Erg, 0, "Len"). "h
    ". Get_Text("pub_schichtplan_add_TextFor"). ": ". + mysql_result($Erg, 0, "Man"). "
    ". Get_Text("pub_schichtplan_add_Comment"). ":". + "
     
    \n". + "\n". + "\n". + "
    "; + +} + +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/schichtplan_beamer.php b/www-ssl/nonpublic/schichtplan_beamer.php new file mode 100755 index 00000000..bcaca64c --- /dev/null +++ b/www-ssl/nonpublic/schichtplan_beamer.php @@ -0,0 +1,64 @@ + + + + +Schichtpläne für Beamer + + + + +\n"; + +echo " + + + + + \n"; + +echo "\n". +// "\t \n". + "\t". gmdate("d.m.y", $Time). "\n". + "\t". gmdate("H", $Time-3600). ":00\n". + "\t". gmdate("H", $Time+0). ":00\n". + "\t". gmdate("H", $Time+3600). ":00\n". + "\n"; + +foreach( $Room as $RoomEntry ) +{ + + //var-init + $AnzahlEintraege = 0; + + $Out = ausgabe_Zeile( $RoomEntry["RID"], $Time-3600, $AnzahlEintraege); + $Out.= ausgabe_Zeile( $RoomEntry["RID"], $Time, $AnzahlEintraege); + $Out.= ausgabe_Zeile( $RoomEntry["RID"], $Time+3600, $AnzahlEintraege); + + + //entfernt leere zeilen + if( $AnzahlEintraege==0 ) + $Out = ""; + else + $Out = "\n\t_". $RoomEntry["Name"]. "_\n". $Out . "\n"; + + echo $Out; +} + +echo "\n"; + +?> + + diff --git a/www-ssl/nonpublic/schichtplanneu.1.php b/www-ssl/nonpublic/schichtplanneu.1.php new file mode 100755 index 00000000..e7a41f7f --- /dev/null +++ b/www-ssl/nonpublic/schichtplanneu.1.php @@ -0,0 +1,17 @@ +

     Tage

    + +$tmp"; + echo "\t
  • $tmp
    • \n"; +} + +?> diff --git a/www-ssl/nonpublic/schichtplanneu.php b/www-ssl/nonpublic/schichtplanneu.php new file mode 100755 index 00000000..2585f420 --- /dev/null +++ b/www-ssl/nonpublic/schichtplanneu.php @@ -0,0 +1,106 @@ + + +Hallo ,
    +hier kannst du dich für Schichten in der Aula eintragen. Dazu wähle einfach eine freie Schicht und klicke auf den Link.

    + + + + +\n"; +# $Spalten[$i].= "\t\t\n"; +# } +# } +# $rowcount = mysql_num_rows($res); + + + +for ($zeit = 0; $zeit < 24; $zeit++) + { + $zzeit = $zeit; + if ($zzeit < 10) + { + $zzeit = "0".$zzeit; + } + +$SSQL = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-27 $zzeit:00:00\" AND RID = 1"; +$SERG = mysql_query($SSQL, $con); +$SRES = mysql_fetch_row($SERG); + +$USQL = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES[0]."\""; +$UERG = mysql_query($USQL, $con); +$URES = mysql_fetch_row($UERG); + +$NSQL = "SELECT Nick FROM User WHERE UID = \"$URES[0]\""; +$NERG = mysql_query($NSQL, $con); +$NRES = mysql_fetch_row($NERG); + +echo "\t\n"; +echo "\t\t"; +echo "\t\t"; + +$SSQL2 = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-28 $zzeit:00:00\" AND RID = 1"; +$SERG2 = mysql_query($SSQL2, $con); +$SRES2 = mysql_fetch_row($SERG2); + +$USQL2 = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES2[0]."\""; +$UERG2 = mysql_query($USQL2, $con); +$URES2 = mysql_fetch_row($UERG2); + +$NSQL2 = "SELECT Nick FROM User WHERE UID = \"$URES2[0]\""; +$NERG2 = mysql_query($NSQL2, $con); +$NRES2 = mysql_fetch_row($NERG2); + +echo "\t\t"; + +$SSQL3 = "SELECT * FROM Schichtplan WHERE Date = \"2002-12-29 $zzeit:00:00\" AND RID = 1"; +$SERG3 = mysql_query($SSQL3, $con); +$SRES3 = mysql_fetch_row($SERG3); + +$USQL3 = "SELECT UID FROM Schichtbelegung WHERE SID = \"".$SRES3[0]."\""; +$UERG3 = mysql_query($USQL3, $con); +$URES3 = mysql_fetch_row($UERG3); + +$NSQL3 = "SELECT Nick FROM User WHERE UID = \"$URES3[0]\""; +$NERG3 = mysql_query($NSQL3, $con); +$NRES3 = mysql_fetch_row($NERG3); + +echo "\t\t"; +echo "\t"; + + + +} +echo "
    "; +# if($i < 10){ +# $Spalten[$i].= "0"; +# $Spalten[$i].= "$i:00"; +# $Spalten[$i].= "
    \n"; +echo $zzeit.":00"; +echo "\t\t\n"; +echo $NRES[0]; +echo "\t\t\n"; +echo $NRES2[0]; +echo "\t\t\n"; +echo $NRES3[0]; +echo "\t\t
    \n"; +include ("./inc/footer.php"); +?> diff --git a/www-ssl/nonpublic/waeckliste.php b/www-ssl/nonpublic/waeckliste.php new file mode 100755 index 00000000..198a741a --- /dev/null +++ b/www-ssl/nonpublic/waeckliste.php @@ -0,0 +1,43 @@ + + +\n". + Get_Text("pub_waeckliste_Text1")?> +

    + + + + + + + + + + + + + + + + +
    + diff --git a/www-ssl/nonpublic/wecken.php b/www-ssl/nonpublic/wecken.php new file mode 100755 index 00000000..f7145336 --- /dev/null +++ b/www-ssl/nonpublic/wecken.php @@ -0,0 +1,82 @@ + + +".Get_Text("pub_wake_beschreibung")?> +

    + +

    + + + + + + + + + + + + + + + + +
    ".Get_Text("pub_wake_del"); ?>
    +

    +

    + +
    + + + + + + + + + + + + + +
    :
    +"> +
    + -- cgit v1.2.3-54-g00ecf