diff options
Diffstat (limited to 'www-ssl/nonpublic')
| -rwxr-xr-x | www-ssl/nonpublic/auth.php | 66 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/einstellungen.php | 361 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/engelbesprechung.php | 37 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/faq.php | 72 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/index.php | 84 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/messages.php | 127 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/myschichtplan.php | 287 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/myschichtplan_ical.php | 43 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/news.php | 11 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/news_comments.php | 89 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/news_output.php | 106 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/schichtplan.1.php | 17 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/schichtplan.2.php | 26 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/schichtplan.php | 229 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/schichtplan_add.php | 200 | ||||
| -rw-r--r--[-rwxr-xr-x] | www-ssl/nonpublic/schichtplan_beamer.php | 88 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/waeckliste.php | 40 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/wecken.php | 81 |
18 files changed, 441 insertions, 1523 deletions
diff --git a/www-ssl/nonpublic/auth.php b/www-ssl/nonpublic/auth.php deleted file mode 100755 index 99b153e5..00000000 --- a/www-ssl/nonpublic/auth.php +++ /dev/null @@ -1,66 +0,0 @@ -<?PHP -header('Content-Type: application/json'); - -include ("../../includes/config.php"); -include ("../../includes/config_db.php"); - -$User = $_POST['user']; -$Pass = $_POST['pw']; -$SourceOuth = $_POST['so']; - -/* -$User = $_GET['user']; -$Pass = $_GET['pw']; -$SourceOuth = $_GET['so']; -*/ - -/* -$User = "admin"; -$Pass = "21232f297a57a5a743894a0e4a801fc3"; // "admin"; -$SourceOuth = 23; -*/ - -if ( isset($CurrentExternAuthPass) && - ($SourceOuth == $CurrentExternAuthPass) ) -{ // User ist noch nicht angemeldet - $sql = "SELECT * FROM `User` WHERE `Nick`='". $User. "'"; - $Erg = mysql_query( $sql, $con); - - if ( mysql_num_rows( $Erg) == 1) - { // Check, ob User angemeldet wird... - if (mysql_result( $Erg, 0, "Passwort") == $Pass) - { // Passwort ok... - // Session wird eingeleitet und Session-Variablen gesetzt.. - $UID = mysql_result( $Erg, 0, "UID"); - - // get CVS import Data - $SQL = "SELECT * FROM `UserCVS` WHERE `UID`='". $UID. "'"; - $Erg_CVS = mysql_query($SQL, $con); - $CVS = mysql_fetch_array($Erg_CVS); - - $msg = array( - 'status' => 'success', - 'rights' => $CVS - ); - echo json_encode($msg); - - } - else - { - echo json_encode(array('status' => 'failed')); - } - } - else - { - echo json_encode(array('status' => 'failed')); - } -} -else -{ - echo json_encode(array('status' => 'failed')); -} - - -?> - - diff --git a/www-ssl/nonpublic/einstellungen.php b/www-ssl/nonpublic/einstellungen.php deleted file mode 100755 index aabcb830..00000000 --- a/www-ssl/nonpublic/einstellungen.php +++ /dev/null @@ -1,361 +0,0 @@ -<?PHP -/* Todo: -add if-construct with configvar for user-shirt-settings - * - * - */ -$title = "Himmel"; -$header = "Deine persönlichen Einstellungen"; -include ("../../includes/header.php"); -include ("../../includes/crypt.php"); - -if (!IsSet($_POST["action"])) -{ - echo Get_Text("Hallo").$_SESSION['Nick'].",<br>\n\n"; - Print_Text(13); -?> -<hr width=\"100%\"> -<?PHP Print_Text("pub_einstellungen_Text_UserData");?> -<form action="./einstellungen.php" method="post"> - <input type="hidden" name="action" value="setUserData"> - <table> - <tr> <td><?PHP Print_Text("pub_einstellungen_Nick"); ?></td> - <td><input type="text" name="eNick" size="23" value="<?PHP echo $_SESSION["Nick"]; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Name"); ?></td> - <td><input type="text" name="eName" size="23" value="<?PHP echo $_SESSION['Name']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Vorname"); ?></td> - <td><input type="text" name="eVorname" size="23" value="<?PHP echo $_SESSION['Vorname']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Alter"); ?></td> - <td><input type="text" name="eAlter" size="3" value="<?PHP echo $_SESSION['Alter']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Telefon"); ?></td> - <td><input type="text" name="eTelefon" size="40" value="<?PHP echo $_SESSION['Telefon']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Handy"); ?></td> - <td><input type="text" name="eHandy" size="40" value="<?PHP echo $_SESSION['Handy']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_DECT"); ?></td> - <td><input type="text" name="eDECT" size="4" value="<?PHP echo $_SESSION['DECT']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_email"); ?></td> - <td><input type="text" name="eemail" size="40" value="<?PHP echo $_SESSION['email']; ?>"></td></tr> - - <tr> <td>ICQ</td> - <td><input type="text" name="eICQ" size="40" value="<?PHP echo $_SESSION['ICQ']; ?>"></td></tr> - - <tr> <td>jabber</td> - <td><input type="text" name="ejabber" size="40" value="<?PHP echo $_SESSION['jabber']; ?>"></td></tr> - - <tr> <td><?PHP Print_Text("pub_einstellungen_Hometown"); ?></td> - <td><input type="text" name="Hometown" size="40" value="<?PHP echo $_SESSION['Hometown']; ?>"></td></tr> -<?PHP -if( $_SESSION['CVS'][ "Change T_Shirt Size" ] == "Y" ) -{ -?> - <tr> <td><?PHP Print_Text("makeuser_T-Shirt"); ?></td> - <td><select name="Sizeid"> - <option <?php if($_SESSION['Size'] == 'S') { echo "selected"; } ?> value="S">S</option> - <option <?php if($_SESSION['Size'] == 'M') { echo "selected"; } ?> value="M">M</option> - <option <?php if($_SESSION['Size'] == 'L') { echo "selected"; } ?> value="L">L</option> - <option <?php if($_SESSION['Size'] == 'XL') { echo "selected"; } ?> value="XL">XL</option> - <option <?php if($_SESSION['Size'] == 'XXL') { echo "selected"; } ?> value="XXL">XXL</option> - <option <?php if($_SESSION['Size'] == 'XXXL') { echo "selected"; } ?> value="XXXL">XXXL</option> - </select></td></tr> -<?PHP -} -?> - </table> - <input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> -<br> - - -<hr width=\"100%\"> -<?PHP Print_Text(14);?> -<form action="./einstellungen.php" method="post"> - <input type="hidden" name="action" value="set"> - <table> - <tr><td><?PHP Print_Text(15); ?></td><td><input type="password" name="old" size="20"></td></tr> - <tr><td><?PHP Print_Text(16); ?></td><td><input type="password" name="new1" size="20"></td></tr> - <tr><td><?PHP Print_Text(17); ?></td><td><input type="password" name="new2" size="20"></td></tr> - </table> - <input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> -<br> - - -<hr width="100%"> -<br> -<?PHP Print_Text(18); ?> -<form action="./einstellungen.php" method="post"> - <input type="hidden" name="action" value="colour"> - <table> - <tr><td><?PHP Print_Text(19); ?></td> - <td> - <select name="colourid"> - <option <?php if($_SESSION['color'] == 1) { echo "selected"; } ?> value="1">Standard-Style</option> - <option <?php if($_SESSION['color'] == 2) { echo "selected"; } ?> value="2">Rot/Gelber Style</option> - <option <?php if($_SESSION['color'] == 3) { echo "selected"; } ?> value="3">Club-Mate Style</option> - <option <?php if($_SESSION['color'] == 5) { echo "selected"; } ?> value="5">Debian Style</option> - <option <?php if($_SESSION['color'] == 6) { echo "selected"; } ?> value="6">c-base Style</option> - <option <?php if($_SESSION['color'] == 7) { echo "selected"; } ?> value="7">Blau/Gelber Style </option> - <option <?php if($_SESSION['color'] == 8) { echo "selected"; } ?> value="8">Pastel Style</option> - <option <?php if($_SESSION['color'] == 4) { echo "selected"; } ?> value="4">Test Style</option> - <option <?php if($_SESSION['color'] == 9) { echo "selected"; } ?> value="9">Test Style 21c3 </option> - </select> - </td></tr> - <tr><td>Menu</td> - <td><input type="radio" name="eMenu" value="L"<?PHP - if ($_SESSION['Menu']=='L') echo " checked"; ?>>L - <input type="radio" name="eMenu" value="R"<?PHP - if ($_SESSION['Menu']=='R') echo " checked"; ?>>R - </td></tr> - </table> - <input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> -<br> -<hr width="100%"> -<br> -<?PHP Print_Text(20); ?> -<form action="./einstellungen.php" method="post"> - <input type="hidden" name="action" value="sprache"> - <table> - <tr><td><?PHP Print_Text(21); ?></td> - <td> - <select name="language"> - <option value="DE" <?php if($_SESSION['Sprache'] == 'DE') { echo "selected"; } ?>>Deutsch</option> - <option value="EN" <?php if($_SESSION['Sprache'] == 'EN') { echo "selected"; } ?>>English</option> -<?PHP /* <option value="NL" <?php if($_SESSION['Sprache'] == 'NL') { echo "selected"; } ?>>Dutch</option> */?> - </select> - </td></tr> - </table> - <input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> -<?PHP - - - if( get_cfg_var("file_uploads")) - { - echo "<br>\n<hr width=\"100%\">\n<br>\n\n"; - echo Get_Text('pub_einstellungen_PictureUpload')."<br>"; - echo "<form action=\"./einstellungen.php\" method=\"post\" enctype=\"multipart/form-data\">\n"; - echo "\t<input type=\"hidden\" name=\"action\" value=\"sendPicture\">\n"; - echo "\t<input name=\"file\" type=\"file\" size=\"50\" maxlength=\"". get_cfg_var("post_max_size"). "\">\n"; - echo "\t(max ". get_cfg_var("post_max_size"). "Byte)<br>\n"; - echo "\t<input type=\"submit\" value=\"". Get_Text("upload"),"\">\n"; - echo "</form>\n"; - } - - switch( GetPicturShow( $_SESSION['UID'])) - { - case 'Y': - echo Get_Text('pub_einstellungen_PictureShow'). "<br>"; - echo displayPictur($_SESSION['UID'], 0); - echo "<form action=\"./einstellungen.php\" method=\"post\">\n"; - echo "\t<input type=\"hidden\" name=\"action\" value=\"delPicture\">\n"; - echo "\t<input type=\"submit\" value=\"". Get_Text("delete"),"\">\n"; - echo "</form>\n"; - break; - case 'N': - echo Get_Text('pub_einstellungen_PictureNoShow'). "<br>"; - echo displayPictur($_SESSION['UID'], 0); - echo "<form action=\"./einstellungen.php\" method=\"post\">\n"; - echo "\t<input type=\"hidden\" name=\"action\" value=\"delPicture\">\n"; - echo "\t<input type=\"submit\" value=\"". Get_Text("delete"),"\">\n"; - echo "</form>\n"; - echo "<br>\n<hr width=\"100%\">\n<br>\n\n"; - case '': - echo "<br>\n<hr width=\"100%\">\n<br>\n\n"; - echo Get_Text(22). "<br>"; - echo "\n<form action=\"./einstellungen.php\" method=\"post\">\n"; - echo "\t<input type=\"hidden\" name=\"action\" value=\"avatar\">\n"; - echo "\t<table>\n"; - echo "\t\t<tr>\n\t\t\t<td>". Get_Text(23). "<br></td>\n\t\t</tr>\n"; - echo "\t\t<tr>\n"; - echo "\t\t\t<td>\n"; - echo "\t\t\t\t<select name=\"eAvatar\" onChange=\"document.avatar.src = '". $url. $ENGEL_ROOT. "pic/avatar/avatar' + this.value + '.gif'\"". - "onKeyup=\"document.avatar.src = '". $url. $ENGEL_ROOT. "pic/avatar/avatar' + this.value + '.gif'\">\n"; - for ($i=1; file_exists("". "../pic/avatar/avatar$i.gif"); $i++ ) - echo "\t\t\t\t\t<option value=\"$i\"". ($_SESSION['Avatar'] == $i ? " selected":""). ">avatar$i</option>\n"; - echo "\t\t\t\t</select> \n"; - echo "\t\t\t\t<img src=\"". $url. $ENGEL_ROOT. "pic/avatar/avatar". $_SESSION['Avatar']. ".gif\" name=\"avatar\" border=\"0\" align=\"top\">\n"; - echo "\t\t\t</td>\n\t\t</tr>\n"; - echo "\t</table>\n"; - echo "\t<input type=\"submit\" value=\"". Get_Text("save"),"\">\n"; - echo "</form>\n"; - break; - } //CASE - -} else { - -switch ($_POST["action"]) { - -case 'set': - if ($_POST["new1"]==$_POST["new2"]){ - Print_Text(25); - $sql = "SELECT * FROM `User` WHERE `UID`='".$_SESSION['UID']. "'"; - $Erg = mysql_query($sql, $con); - if (PassCrypt($_POST["old"])==mysql_result($Erg, 0, "Passwort")) { - Print_Text(26); - Print_Text(27); - $usql = "UPDATE `User` SET `Passwort`='". PassCrypt($_POST["new1"]). "' ". - " WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; - $Erg = mysql_query($usql, $con); - if ($Erg==1) { - Print_Text(28); - } else { - Print_Text(29); - } - } else { - Print_Text(30); - } - } else { - Print_Text(31); - } - break; - -case 'colour': - - $chsql="UPDATE `User` SET ". - "`color`= '". $_POST["colourid"]. "', ". - "`Menu`= '". $_POST["eMenu"]. "' ". - "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; - $Erg = mysql_query($chsql, $con); - echo mysql_error($con); - $_SESSION['color']=$_POST["colourid"]; - $_SESSION['Menu']=$_POST["eMenu"]; - if ($Erg==1) { - Print_Text(32); - } else { - Print_Text(29); - } - break; - -case 'sprache': - - $chsql="UPDATE `User` SET `Sprache` = '". $_POST["language"]. "' WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; - $Erg = mysql_query($chsql, $con); - $_SESSION['Sprache']=$_POST["language"]; - if ($Erg==1) { - Print_Text(33); - } else { - Print_Text(29); - } - break; - -case 'avatar': - $chsql="UPDATE `User` SET `Avatar`='". $_POST["eAvatar"]. "' WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; - $Erg = mysql_query($chsql, $con); - $_SESSION['Avatar']=$_POST["eAvatar"]; - if ($Erg==1) - Print_Text(34); - else - Print_Text(29); - break; - -case 'setUserData': - if( $_SESSION['CVS'][ "Change T_Shirt Size" ] == "Y" ) - { - $chsql= "UPDATE `User` SET ". - "`Nick`='". $_POST["eNick"]. "', `Name`='". $_POST["eName"]. "', ". - "`Vorname`='". $_POST["eVorname"]. "', `Alter`='". $_POST["eAlter"]. "', ". - "`Telefon`='". $_POST["eTelefon"]. "', `Handy`='". $_POST["eHandy"]. "', ". - "`DECT`='". $_POST["eDECT"]. "', `email`='". $_POST["eemail"]. "', ". - "`ICQ`='". $_POST["eICQ"]. "', `jabber`='". $_POST["ejabber"]."', ". - "`Hometown`='". $_POST["Hometown"]. "', `Size`='". $_POST["Sizeid"]. "' ". - "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1;"; - } - else - { - $chsql= "UPDATE `User` SET ". - "`Nick`='". $_POST["eNick"]. "', `Name`='". $_POST["eName"]. "', ". - "`Vorname`='". $_POST["eVorname"]. "', `Alter`='". $_POST["eAlter"]. "', ". - "`Telefon`='". $_POST["eTelefon"]. "', `Handy`='". $_POST["eHandy"]. "', ". - "`DECT`='". $_POST["eDECT"]. "', `email`='". $_POST["eemail"]. "', ". - "`ICQ`='". $_POST["eICQ"]. "', `jabber`='". $_POST["ejabber"]."', ". - "`Hometown`='". $_POST["Hometown"]. "' ". - "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1;"; - } - $Erg = mysql_query($chsql, $con); - - if ($Erg==1) - { - $_SESSION['Nick'] = $_POST["eNick"]; - $_SESSION['Name'] = $_POST["eName"]; - $_SESSION['Vorname'] = $_POST["eVorname"]; - $_SESSION['Alter'] = $_POST["eAlter"]; - $_SESSION['Telefon'] = $_POST["eTelefon"]; - $_SESSION['Handy'] = $_POST["eHandy"]; - $_SESSION['DECT'] = $_POST["eDECT"]; - $_SESSION['email'] = $_POST["eemail"]; - $_SESSION['ICQ'] = $_POST["eICQ"]; - $_SESSION['jabber'] = $_POST["ejabber"]; - $_SESSION['Hometown'] = $_POST["Hometown"]; - if( $_SESSION['CVS'][ "Change T_Shirt Size" ] == "Y" ) - { - $_SESSION['Size']=$_POST["Sizeid"]; - } - else if( $_SESSION['Size'] != $_POST["Sizeid"]) - { - array_push($error_messages, "einstellungen.php, change t-shirt size not allowed\n"); - } - - - Print_Text("pub_einstellungen_UserDateSaved"); - } - else - { - Print_Text(29); - echo mysql_error( $con); - } - break; - -case 'sendPicture': - if( $_FILES["file"]["size"] > 0) - { - 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( $_SESSION['UID']) == "") - $SQL = "INSERT INTO `UserPicture` ". - "( `UID`,`Bild`, `ContentType`, `show`) ". - "VALUES ('". $_SESSION['UID']. "', '$data', '". $_FILES["file"]["type"]. "', 'N')"; - else - $SQL = "UPDATE `UserPicture` SET ". - "`Bild`='$data', ". - "`ContentType`='". $_FILES["file"]["type"]. "', ". - "`show`='N' ". - "WHERE `UID`='". $_SESSION['UID']. "'"; - - $res = mysql_query( $SQL, $con); - if( $res) - Print_Text("pub_einstellungen_send_OK"); - else - Print_Text("pub_einstellungen_send_KO"); - - echo "<h6>('" . $_FILES["file"]["name"] . "', MIME-Type: " . $_FILES["file"]["type"]. ", " . $_FILES["file"]["size"]. " Byte)</h6>"; - } - else - Print_Text("pub_einstellungen_send_KO"); - } - else - Print_Text("pub_einstellungen_send_KO"); - break; - -case 'delPicture': - $chsql="DELETE FROM `UserPicture` WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; - $Erg = mysql_query($chsql, $con); - if ($Erg==1) - Print_Text("pub_einstellungen_del_OK"); - else - Print_Text("pub_einstellungen_del_KO"); - Break; -} -} -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/engelbesprechung.php b/www-ssl/nonpublic/engelbesprechung.php deleted file mode 100755 index add50240..00000000 --- a/www-ssl/nonpublic/engelbesprechung.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php -$title = "Himmel"; -$header = "Engelbesprechung"; -include ("../../includes/header.php"); -?> - -<br> - -<?php - -$SQL = "SELECT * FROM `News` ORDER BY 'Datum' DESC"; -$Erg = mysql_query($SQL, $con); - -// anzahl zeilen -$Zeilen = mysql_num_rows($Erg); - -for ($n = 0 ; $n < $Zeilen ; $n++) -{ - if (mysql_result($Erg, $n, "Treffen")=="1") - { - echo "<p class='question'><u>".mysql_result($Erg, $n, "Betreff")."</u>"; - - // Schow Admin Page - if( $_SESSION['CVS'][ "admin/news.php" ] == "Y" ) - echo " <a href=\"./../admin/news.php?action=change&date=". mysql_result($Erg, $n, "Datum"). "\">[edit]</a>"; - - echo "<br> <font size=1>".mysql_result($Erg, $n, "Datum").", "; - echo UID2Nick(mysql_result($Erg, $n, "UID"))."</font></p>\n"; - - - echo "<p class='answetion'>".nl2br(mysql_result($Erg, $n, "Text"))."</p>\n"; - } -} - - -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/faq.php b/www-ssl/nonpublic/faq.php deleted file mode 100755 index 5adfb67c..00000000 --- a/www-ssl/nonpublic/faq.php +++ /dev/null @@ -1,72 +0,0 @@ -<?php -$title = "Himmel"; -$header = "FAQ / Fragen an die Erzengel"; -include ("../../includes/header.php"); - - -// Erstaufruf, oder Frage bereits abgeschickt? -if (!IsSet($_POST["eUID"])) -{ - Print_Text(35); -?> -<br><br> -<form action="./faq.php" method="POST"> - <input type="hidden" name="eUID" value="<?PHP echo $_SESSION['UID'] ?>"> - <textarea name="frage" cols="40" rows="10"><?PHP Print_Text(36); ?></textarea><br><br> - <input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> -<?PHP - -} else { -// Auswertung d. Formular-Daten: - -echo "<b>".Get_Text(37)."</b><br><br>\n".nl2br($_POST["frage"])."<br><br>\n".Get_Text(38)."<br>\n"; - -$SQL = "INSERT INTO `Questions` VALUES ('', '".$_SESSION['UID']."', '". $_POST["frage"]. "', '', '')"; -$Erg = mysql_query($SQL, $con); - -} -// Bisherige Anfragen: -echo "<br>\n<b>".Get_Text(39)."</b><br>\n"; -echo "<hr width=\"99%\">\n"; -echo "<br><b>".Get_Text(40)."</b><br>\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 "<p class='question'>".nl2br(mysql_result($Erg, $n, "Question"))."<br>\n"; -// Es gibt ja noch keine Antwort: -// echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer"))."</p>\n"; - echo "\n<br>---<br>"; - } -} - -echo "<hr width=\"99%\">\n"; -echo "<br><b>".Get_Text(42)."</b><br>\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 "<p class='question'>".nl2br(mysql_result($Erg, $n, "Question"))."<br>\n"; - echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer")). - "@". UID2Nick(mysql_result($Erg, $n, "AID"))."\n"; - echo "\n<br>---<br>"; - } -} - -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/index.php b/www-ssl/nonpublic/index.php deleted file mode 100755 index affb571e..00000000 --- a/www-ssl/nonpublic/index.php +++ /dev/null @@ -1,84 +0,0 @@ -<?PHP -$title = "Index"; -$header = "Index"; - -include ("../../includes/config_db.php"); -include ("../../includes/crypt.php"); - -session_start(); // alte Session - falls vorhanden - wiederherstellen... - -function LoginOK() -{ - include ("../../includes/config.php"); - header("HTTP/1.1 302 Moved Temporarily"); - header("Location: ". $url. $ENGEL_ROOT. "nonpublic/news.php"); -} - -if ( !IsSet($_POST["user"])) -{ // User ist bereits angemeldet... normaler Inhalt... - LoginOK(); -} -else -{ // User ist noch nicht angemeldet - $sql = "SELECT * FROM `User` WHERE `Nick`='". $_POST["user"]. "'"; - $userstring = mysql_query($sql, $con); - - // anzahl zeilen - $user_anz = mysql_num_rows($userstring); - - if ($user_anz == 1) { // Check, ob User angemeldet wird... - if (mysql_result($userstring, 0, "Passwort") == PassCrypt($_POST["password"])) { // Passwort ok... - // Session wird eingeleitet und Session-Variablen gesetzt.. - // session_start(); - session_name("Himmel"); - $_SESSION['UID'] = mysql_result($userstring, 0, "UID"); - $_SESSION['Nick'] = mysql_result($userstring, 0, "Nick"); - $_SESSION['Name'] = mysql_result($userstring, 0, "Name"); - $_SESSION['Vorname'] = mysql_result($userstring, 0, "Vorname"); - $_SESSION['Alter'] = mysql_result($userstring, 0, "Alter"); - $_SESSION['Telefon'] = mysql_result($userstring, 0, "Telefon"); - $_SESSION['Handy'] = mysql_result($userstring, 0, "Handy"); - $_SESSION['DECT'] = mysql_result($userstring, 0, "DECT"); - $_SESSION['email'] = mysql_result($userstring, 0, "email"); - $_SESSION['ICQ'] = mysql_result($userstring, 0, "ICQ"); - $_SESSION['jabber'] = mysql_result($userstring, 0, "jabber"); - $_SESSION['Size'] = mysql_result($userstring, 0, "Size"); - $_SESSION['Gekommen'] = mysql_result($userstring, 0, "Gekommen"); - $_SESSION['Aktiv'] = mysql_result($userstring, 0, "Aktiv"); - $_SESSION['Tshirt'] = mysql_result($userstring, 0, "Tshirt"); - $_SESSION['Menu'] = mysql_result($userstring, 0, "Menu"); - $_SESSION['color'] = mysql_result($userstring, 0, "color"); - $_SESSION['Avatar'] = mysql_result($userstring, 0, "Avatar"); - $_SESSION['Sprache'] = mysql_result($userstring, 0, "Sprache"); - $_SESSION['Hometown'] = mysql_result($userstring, 0, "Hometown"); - $_SESSION['IP'] = $_SERVER['REMOTE_ADDR']; - - // CVS import Data - $SQL = "SELECT * FROM `UserCVS` WHERE `UID`='".$_SESSION['UID']."'"; - $Erg_CVS = mysql_query($SQL, $con); - $_SESSION['CVS'] = mysql_fetch_array($Erg_CVS); - - LoginOK(); - } - else - { // Passwort nicht ok... - $ErrorText = "pub_index_pass_no_ok"; - } // Ende Passwort-Check - } - else - { // Anzahl der User in User-Tabelle <> 1 --> keine Anmeldung - if ($user_anz == 0) - $ErrorText = "pub_index_User_unset"; - else - $ErrorText = "pub_index_User_more_as_one"; - } // Ende Check, ob User angemeldet wurde -} -include ("../../includes/header.php"); -if( isset($ErrorText)) - echo "<h2>". Get_Text($ErrorText). "</h2><br>\n"; -include ("../../includes/login_eingabefeld.php"); -include ("../../includes/footer.php"); - -?> - - diff --git a/www-ssl/nonpublic/messages.php b/www-ssl/nonpublic/messages.php deleted file mode 100755 index 7d3bb7fb..00000000 --- a/www-ssl/nonpublic/messages.php +++ /dev/null @@ -1,127 +0,0 @@ -<?php -$title = "Himmel"; -$header = ""; - -include ("../../includes/header.php"); - -If( !isset($_GET["action"]) ) - $_GET["action"] = "start"; - -switch( $_GET["action"]) -{ - case "start": - echo Get_Text("Hello"). $_SESSION['Nick']. ", <br>\n"; - echo Get_Text("pub_messages_text1"). "<br><br>\n"; - - //##################### - //show exist Messages - //##################### - $SQL = "SELECT * FROM `Messages` WHERE `SUID`='". $_SESSION["UID"]. "' OR `RUID`='". $_SESSION["UID"]. "'"; - $erg = mysql_query($SQL, $con); - - echo "<table border=\"0\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; - echo "<tr>\n"; - echo "\t<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Datum"). "</b></td>\n"; - echo "\t<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Von"). "</b></td>\n"; - echo "\t<td class=\"contenttopic\"><b>". Get_Text("pub_messages_An"). "</b></td>\n"; - echo "\t<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Text"). "</b></td>\n"; - echo "\t<td class=\"contenttopic\"></td>\n"; - echo "</tr>\n"; - - for( $i=0; $i<mysql_num_rows( $erg ); $i++ ) - { - echo "<tr class=\"content\">\n"; - echo "\t<td>". mysql_result( $erg, $i, "Datum" ). "</td>\n"; - echo "\t<td>". UID2Nick( mysql_result( $erg, $i, "SUID" )). "</td>\n"; - echo "\t<td>". UID2Nick( mysql_result( $erg, $i, "RUID" )). "</td>\n"; - echo "\t<td>". mysql_result( $erg, $i, "Text" ). "</td>\n"; - echo "\t<td>"; - - if( mysql_result( $erg, $i, "RUID")==$_SESSION["UID"]) - { - echo "<a href=\"?action=DelMsg&Datum=". mysql_result( $erg, $i, "Datum" ). - "\">". Get_Text("pub_messages_DelMsg"). "</a>"; - if( mysql_result( $erg, $i, "isRead")=="N") - echo "<br><br><a href=\"?action=MarkRead&Datum=". mysql_result( $erg, $i, "Datum" ). - "\">". Get_Text("pub_messages_MarkRead"). "</a>"; - } - else - { - if( mysql_result( $erg, $i, "isRead")=="N") - echo Get_Text("pub_messages_NotRead"); - } - - echo "</td>\n"; - echo "</tr>\n"; - } - - //##################### - //send Messeges - //##################### - echo "<form action=\"". $_SERVER['SCRIPT_NAME']. "?action=SendMsg\" method=\"POST\" >"; - echo "<tr class=\"content\">\n"; - echo "\t<td></td>\n"; - echo "\t<td></td>\n"; - // Listet alle Nicks auf - echo "\t<td><select name=\"RUID\">\n"; - $usql="SELECT * FROM `User` WHERE (`UID`!='". $_SESSION["UID"] ."') ORDER BY `Nick`"; - $uErg = mysql_query($usql, $con); - $urowcount = mysql_num_rows($uErg); - for ($k=0; $k<$urowcount; $k++) - { - echo "\t\t\t<option value=\"".mysql_result($uErg, $k, "UID")."\">". - mysql_result($uErg, $k, "Nick"). "</option>\n"; - } - echo "</select></td>\n"; - echo "\t<td><textarea name=\"Text\" cols=\"30\" rows=\"10\"></textarea></td>\n"; - echo "\t<td><input type=\"submit\" value=\"". Get_Text("save"). "\"></td>\n"; - echo "</tr>\n"; - echo "</form>"; - - echo "</table>\n"; - break; - - case "SendMsg": - echo Get_Text("pub_messages_Send1"). "...<br>\n"; - - $SQL = "INSERT INTO `Messages` ( `Datum` , `SUID` , `RUID` , `Text` ) VALUES (". - "'". gmdate("Y-m-j H:i:s", time()). "', ". - "'". $_SESSION["UID"]. "', ". - "'". $_POST["RUID"]."', ". - "'". $_POST["Text"]. "');"; - - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - echo Get_Text("pub_messages_Send_OK"). "\n"; - else - echo Get_Text("pub_messages_Send_Error"). "...\n(". mysql_error($con). ")"; - break; - - case "MarkRead": - $SQL = "UPDATE `Messages` SET `isRead` = 'Y' ". - "WHERE `Datum` = '". $_GET["Datum"]. "' AND `RUID`='". $_SESSION["UID"]. "' ". - "LIMIT 1 ;"; - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - echo Get_Text("pub_messages_MarkRead_OK"). "\n"; - else - echo Get_Text("pub_messages_MarkRead_KO"). "...\n(". mysql_error($con). ")"; - break; - - case "DelMsg": - $SQL = "DELETE FROM `Messages` ". - "WHERE `Datum` = '". $_GET["Datum"]. "' AND `RUID` ='". $_SESSION["UID"]. "' ". - "LIMIT 1;"; - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - echo Get_Text("pub_messages_DelMsg_OK"). "\n"; - else - echo Get_Text("pub_messages_DelMsg_KO"). "...\n(". mysql_error($con). ")"; - break; - - default: - echo Get_Text("pub_messages_NoCommand"); -} - -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/myschichtplan.php b/www-ssl/nonpublic/myschichtplan.php index d5e02dcd..5d7b5da3 100755..100644 --- a/www-ssl/nonpublic/myschichtplan.php +++ b/www-ssl/nonpublic/myschichtplan.php @@ -1,185 +1,178 @@ <?php -$title = "Himmel"; -$header = "Mein Schichtplan"; -include ("../../includes/header.php"); -include ("../../includes/funktionen.php"); -include ("../../includes/funktion_schichtplan.php"); -include ("../../includes/funktion_schichtplan_array.php"); +// Eigener Schichtplan +require_once ('../bootstrap.php'); +$title = "Himmel"; +$header = "Mein Schichtplan"; -If( !IsSet($_GET["action"]) ) -{ +include ("includes/header.php"); +include ("includes/funktionen.php"); +include ("includes/funktion_schichtplan.php"); +include ("includes/funktion_schichtplan_aray.php"); - echo Get_Text("Hello").$_SESSION['Nick'].", <br>\n"; - echo Get_Text("pub_mywake_beschreibung1")."<br>\n"; - echo Get_Text("pub_mywake_beschreibung2")."<br><br>\n"; - echo Get_Text("pub_mywake_beschreibung3").($LETZTES_AUSTRAGEN). - Get_Text("pub_mywake_beschreibung4")."<br><br>\n"; +if (!isset ($_GET["action"])) { + echo Get_Text("Hello") . $_SESSION['Nick'] . ", <br />\n"; + echo Get_Text("pub_mywake_beschreibung1") . "<br />\n"; + echo Get_Text("pub_mywake_beschreibung2") . "<br /><br />\n"; + echo Get_Text("pub_mywake_beschreibung3") . ($LETZTES_AUSTRAGEN) . + Get_Text("pub_mywake_beschreibung4") . "<br /><br />\n"; $USER_ID = $_SESSION['UID']; - if( $_SESSION['CVS'][ "admin/schichtplan.php" ] == "Y" ) - { - if( !isset( $_GET["UIDs"]) ) + + if ($_SESSION['CVS']["admin/schichtplan.php"] == "Y") { + if (!isset ($_GET["UIDs"])) $_GET["UIDs"] = $_SESSION['UID']; else $USER_ID = $_GET["UIDs"]; - - echo "<form action=\"".$_SERVER['SCRIPT_NAME']."\" method=\"GET\" >"; + + echo "<form action=\"" . $_SERVER['SCRIPT_NAME'] . "\" method=\"GET\" >"; echo "Liste von <select name=\"UIDs\">\n"; - $usql="SELECT * FROM `User` ORDER BY `Nick`"; + + $usql = "SELECT * FROM `User` ORDER BY `Nick`"; $uErg = mysql_query($usql, $con); $urowcount = mysql_num_rows($uErg); - for ($k=0; $k<$urowcount; $k++) - { - echo "\t<option value=\"".mysql_result($uErg, $k, "UID")."\" ". - ( ($_GET["UIDs"]==mysql_result($uErg, $k, "UID")) ? " selected":""). ">". - mysql_result($uErg, $k, "Nick"). - "</option>\n"; + + for ($k = 0; $k < $urowcount; $k++) { + echo "<option value=\"" . mysql_result($uErg, $k, "UID") . "\" " . + (($_GET["UIDs"] == mysql_result($uErg, $k, "UID")) ? " selected" : "") . ">" . + mysql_result($uErg, $k, "Nick") . + "</option>\n"; } + echo "</select> anzeigen.\n"; echo mysql_error($con); - + echo "<input type=\"submit\" value=\"zeigen\">\n"; echo "</form>"; - } - - $SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` ". - "INNER JOIN `ShiftEntry` ". - "ON `Shifts`.`SID`=`ShiftEntry`.`SID` ". - "WHERE `ShiftEntry`.`UID`='$USER_ID' ". - "ORDER BY `DateS`"; - $erg = mysql_query($SQL, $con); - ?> - <table border="0" class="border" cellpadding="2" cellspacing="1"> - <tr> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Datum");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Uhrzeit");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Len");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Name");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Ort");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Bemerkung");?></b></td> - <td class="contenttopic"><b><?PHP echo Get_Text("pub_mywake_Austragen");?></b></td> - </tr> - <?PHP - - for( $i=0; $i<mysql_num_rows( $erg ); $i++ ) - { + $SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` " . + "INNER JOIN `ShiftEntry` " . + "ON `Shifts`.`SID`=`ShiftEntry`.`SID` " . + "WHERE `ShiftEntry`.`UID`='$USER_ID' " . + "ORDER BY `DateS`"; + $erg = mysql_query($SQL, $con); +?> + <table border="0" class="border" cellpadding="2" cellspacing="1"> + <tr> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Datum");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Uhrzeit");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Len");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Name");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Ort");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Bemerkung");?></b></td> + <td class="contenttopic"><b><?php echo Get_Text("pub_mywake_Austragen");?></b></td> + </tr> + <?php + + + for ($i = 0; $i < mysql_num_rows($erg); $i++) { echo "<tr class=\"content\">"; - echo "<td>". substr(mysql_result( $erg, $i, "DateS" ), 0, 10). "</td>\n"; - echo "<td>". substr(mysql_result( $erg, $i, "DateS" ), 11). "</td>\n"; - echo "<td>". mysql_result( $erg, $i, "Len" ). " h</td>\n"; - echo "<td>". mysql_result( $erg, $i, "Man" ). "</td>\n"; - echo "<td>". $RoomID[mysql_result( $erg, $i, "RID" )]. "<br>\n". - "(". TID2Type(mysql_result( $erg, $i, "TID" )).Get_Text("inc_schicht_engel"). ")". - "</td>\n"; - echo "<td><pre style=\"font-family:Fixedsys,Courier; padding:12x;\">\n". - mysql_result( $erg, $i, "Comment" ). - "\n</pre>\n"; - echo "<br><a href=\"./myschichtplan.php?action=edit&SID=\n". - mysql_result( $erg, $i, "SID" )."\"># vi #</a></td>\n"; - + echo "<td>" . substr(mysql_result($erg, $i, "DateS"), 0, 10) . "</td>\n"; + echo "<td>" . substr(mysql_result($erg, $i, "DateS"), 11) . "</td>\n"; + echo "<td>" . mysql_result($erg, $i, "Len") . " h</td>\n"; + echo "<td>" . mysql_result($erg, $i, "Man") . "</td>\n"; + echo "<td>" . $RoomID[mysql_result($erg, $i, "RID")] . "<br />\n" . + "(" . TID2Type(mysql_result($erg, $i, "TID")) . Get_Text("inc_schicht_engel") . ")" . + "</td>\n"; + echo "<td><pre style=\"font-family:Fixedsys,Courier; padding:12x;\">\n" . + mysql_result($erg, $i, "Comment") . + "\n</pre>\n"; + echo "<br /><a href=\"./myschichtplan.php?action=edit&SID=\n" . + mysql_result($erg, $i, "SID") . "\"># vi #</a></td>\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]; + $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; + $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 "<td> <a href=\"./myschichtplan.php?action=austragen&SID=". - mysql_result( $erg, $i, "SID" )."\">". - Get_Text("pub_mywake_austragen")."</a></td>\n"; - else - echo "<td>". Get_Text("pub_mywake_austragen_n_c"). "</td>\n"; - + if ($schichtdatum > ($lastAustragen + $nowdate)) + echo "<td> <a href=\"./myschichtplan.php?action=austragen&SID=" . + mysql_result($erg, $i, "SID") . "\">" . + Get_Text("pub_mywake_austragen") . "</a></td>\n"; + else + echo "<td>" . Get_Text("pub_mywake_austragen_n_c") . "</td>\n"; + echo "</tr>\n"; } -echo "</table>\n\n"; + echo "</table>\n\n"; -if( $_SESSION['CVS'][ "nonpublic/myschichtplan_ical.php" ] == "Y" ) -{ - echo "<br><a href=\"./myschichtplan_ical.php\">". Get_Text("pub_myschichtplan_ical"). "</a>\n"; -} + if ($_SESSION['CVS']["nonpublic/myschichtplan_ical.php"] == "Y") { + echo "<br /><a href=\"./myschichtplan_ical.php\">" . Get_Text("pub_myschichtplan_ical") . "</a>\n"; + } + +} else { + If ($_GET["action"] == "austragen") { + echo Get_Text("pub_mywake_delate1") . "<br />\n"; + + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '" . $_GET["SID"] . "')"; + $Erg = mysql_query($sql, $con); -} -else -{ - If( $_GET["action"] == "austragen" ) - { - echo Get_Text("pub_mywake_delate1")."<br>\n"; - - $sql = "SELECT * FROM `Shifts` WHERE (`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"; + $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 "<form action=\"./myschichtplan.php\" method=\"GET\">\n"; + echo "<textarea name='newtext' cols='50' rows='10'>" . mysql_result($Erg, 0, "Comment") . "</textarea><br /><br />\n"; + echo "<input type=\"submit\" value=\"save\">\n"; + echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n"; + echo "<input type=\"hidden\" name=\"action\" value=\"editSave\">\n"; + echo "</form>"; + } + elseif ($_GET["action"] == "editSave") { + echo Get_Text("pub_myshift_EditSave_Text1") . "<br />\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 " ..." . Get_Text("pub_myshift_EditSave_OK") . "\n"; else - echo Get_Text("pub_mywake_add_ko"). "\n"; + echo " ..." . Get_Text("pub_myshift_EditSave_KO") . "\n"; + SetHeaderGo2Back(); } - 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 "<form action=\"./myschichtplan.php\" method=\"GET\">\n"; - echo "<textarea name='newtext' cols='50' rows='10'>". mysql_result( $Erg, 0, "Comment" ). "</textarea><br><br>\n"; - echo "<input type=\"submit\" value=\"save\">\n"; - echo "<input type=\"hidden\" name=\"SID\" value=\"". $_GET["SID"]. "\">\n"; - echo "<input type=\"hidden\" name=\"action\" value=\"editSave\">\n"; - echo "</form>"; - } - elseif( $_GET["action"] == "editSave" ) - { - echo Get_Text("pub_myshift_EditSave_Text1"). "<br>\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 ("../../includes/footer.php"); +include ("includes/footer.php"); ?> diff --git a/www-ssl/nonpublic/myschichtplan_ical.php b/www-ssl/nonpublic/myschichtplan_ical.php index 5d572520..ff74fef0 100755..100644 --- a/www-ssl/nonpublic/myschichtplan_ical.php +++ b/www-ssl/nonpublic/myschichtplan_ical.php @@ -1,52 +1,51 @@ <?php -include ("../../includes/header_start.php"); +require_once ('../bootstrap.php'); -include ("../../includes/funktion_schichtplan_array.php"); +include ("includes/header_start.php"); -$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); +include ("includes/funktion_schichtplan_aray.php"); +$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); //HEADER header("Content-Type: text/x-vCalendar"); -header("Content-Disposition: attachment; filename=\"Schichtplan.ics\"" ); +header("Content-Disposition: attachment; filename=\"Schichtplan.ics\""); //DATA echo "BEGIN:VCALENDAR\n"; echo "PRODID:-//Engelsystem//DE-EN\n"; echo "VERSION:2.0\n"; -echo "PRODID:". md5('icalschichtplan:'.$_SESSION['UID']). "\n"; +echo "PRODID:" . md5('icalschichtplan:' . $_SESSION['UID']) . "\n"; echo "METHOD:PUBLISH\n"; echo "CALSCALE:GREGORIAN\n"; echo "METHOD:PUBLISH\n"; -echo "X-WR-CALNAME;VALUE=TEXT:". "Himmel - Schichtplan\n"; +echo "X-WR-CALNAME;VALUE=TEXT:" . "Himmel - Schichtplan\n"; -for( $i=0; $i<mysql_num_rows( $erg ); $i++ ) -{ +for ($i = 0; $i < mysql_num_rows($erg); $i++) { echo "BEGIN:VEVENT\n"; - echo "UID:". md5(mysql_result( $erg, $i, "Man" ). mysql_result( $erg, $i, "DateS" ))."\n"; + echo "UID:" . md5(mysql_result($erg, $i, "Man") . mysql_result($erg, $i, "DateS")) . "\n"; echo "METHOD:PUBLISH\n"; - echo "DTSTART;TZID=Europe/Berlin:". date( 'Ymd\THis', strtotime( mysql_result( $erg, $i, "DateS" ) ) ). "\n"; - echo "DTEND;TZID=Europe/Berlin:". date( 'Ymd\THis', strtotime( mysql_result( $erg, $i, "DateE" ) ) ). "\n"; - echo "SUMMARY:". str_replace( ',', '\\,',mysql_result( $erg, $i, "Man" ) ). "\n"; + echo "DTSTART;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateS"))) . "\n"; + echo "DTEND;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateE"))) . "\n"; + echo "SUMMARY:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; echo "CLASS:PUBLIC\n"; echo "STATUS:CONFIRMED\n"; - echo "URL:". $url. $ENGEL_ROOT. "nonpublic/myschichtplan.php\n"; - echo "LOCATION:". $RoomID[mysql_result( $erg, $i, "RID" )]. "\n"; + echo "URL:" . $url . $ENGEL_ROOT . "nonpublic/myschichtplan.php\n"; + echo "LOCATION:" . $RoomID[mysql_result($erg, $i, "RID")] . "\n"; echo "BEGIN:VALARM\n"; echo "TRIGGER;VALUE=DURATION:-PT5M\n"; - echo "DESCRIPTION:". str_replace( ',', '\\,',mysql_result( $erg, $i, "Man" ) ). "\n"; + echo "DESCRIPTION:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; echo "ACTION:DISPLAY\n"; echo "END:VALARM\n"; echo "END:VEVENT\n"; } echo "END:VCALENDAR\n"; -include( "../../includes/funktion_counter.php"); - +include ("includes/funktion_counter.php"); ?> diff --git a/www-ssl/nonpublic/news.php b/www-ssl/nonpublic/news.php deleted file mode 100755 index 2f04d22c..00000000 --- a/www-ssl/nonpublic/news.php +++ /dev/null @@ -1,11 +0,0 @@ -<?php -$title = "Himmel"; -$header = "News"; -include ("../../includes/header.php"); - - -echo "<a href=\"#Neu\">".Get_Text(3)."</a>"; -include ("news_output.php"); - -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/news_comments.php b/www-ssl/nonpublic/news_comments.php deleted file mode 100755 index 710d33dc..00000000 --- a/www-ssl/nonpublic/news_comments.php +++ /dev/null @@ -1,89 +0,0 @@ -<?php -$title = "Kommentare zu den News"; -$header = "Kommentar"; -include ("../../includes/header.php"); - - -if( IsSet( $_GET["nid"])) -{ - - -if( IsSet( $_GET["text"])) -{ - $ch_sql="INSERT INTO `news_comments` (`Refid`, `Datum`, `Text`, `UID`) ". - "VALUES ('". $_GET["nid"]. "', '". date("Y-m-d H:i:s"). "', '". $_GET["text"]. "', '". $_SESSION["UID"]. "')"; - $Erg = mysql_query($ch_sql, $con); - if ($Erg == 1) - { - echo "Eintrag wurde gespeichert<br><br>"; - SetHeaderGo2Back(); - } -} - -$SQL = "SELECT * FROM `news_comments` WHERE `Refid`='". $_GET["nid"]. "' ORDER BY 'ID'"; -$Erg = mysql_query($SQL, $con); -echo mysql_error( $con); -// anzahl zeilen -$news_rows = mysql_num_rows($Erg); - -?> -<table border="0" width="100%" class="border" cellpadding="2" cellspacing="1"> - <tr class="contenttopic"> - <th width=100 align="left">Datum</th> - <th align="left">Nick</th> - </tr> - <tr class="contenttopic"> - <th align="left" colspan=2>Kommentar</th> - </tr> - -<?PHP -for ($n = 0 ; $n < $news_rows ; $n++) { - echo "\t<tr class=\"content\">"; - echo "\t\t<td width=100>"; - echo mysql_result($Erg, $n, "Datum"); - echo "\t\t</td>"; - echo "\t\t<td>"; - echo UID2Nick(mysql_result($Erg, $n, "UID")); - // avatar anzeigen? - echo DisplayAvatar (mysql_result($Erg, $n, "UID")); - echo "\t\t</td>"; - echo "</tr>"; - echo "\t<tr class=\"content\">"; - echo "\t\t<td colspan=\"2\">"; - echo nl2br(mysql_result($Erg, $n, "Text"))."\n"; - echo "\t\t</td>"; - echo "</tr>"; -} - -echo "</table>"; - -?> - -<br> -<hr> -<h4>Neuer Kommentar:</h4> -<a name="Neu"> </a> - -<form action="./news_comments.php" method="GET"> -<input type="hidden" name="nid" value="<?PHP echo $_GET["nid"]; ?>"> -<table> - <tr> - <td align="right" valign="top">Text:</td> - <td><textarea name="text" cols="50" rows="10"></textarea></td> - </tr> -</table> -<br> -<input type="submit" value="sichern..."> -</form> - -<?PHP - - -} -else -{ - echo "Fehlerhafter Aufruf!"; -} - -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/news_output.php b/www-ssl/nonpublic/news_output.php deleted file mode 100755 index e1afc067..00000000 --- a/www-ssl/nonpublic/news_output.php +++ /dev/null @@ -1,106 +0,0 @@ -<?php - -if( isset( $_POST["text"]) && isset( $_POST["betreff"]) && IsSet( $_POST["date"]) ) -{ - if( !isset( $_POST["treffen"])) - $_POST["treffen"] = 0; - $SQL = "INSERT INTO `News` (`Datum`, `Betreff`, `Text`, `UID`, `Treffen`) ". - "VALUES ('". $_POST["date"]. "', '". $_POST["betreff"]. "', '". $_POST["text"]. "', '".$_SESSION['UID']. - "', '". $_POST["treffen"]. "');"; - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - Print_Text(4); -} - -if( !IsSet( $_GET["news_begin"])) - $_GET["news_begin"]=0; - -if( !IsSet( $_GET["DISPLAY_NEWS"])) - $_GET["DISPLAY_NEWS"] = 5; - -$SQL = "SELECT * FROM `News` ORDER BY `ID` DESC LIMIT ". intval($_GET["news_begin"]). ", ". intval($_GET["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 "<p class='question'>"; - else - echo "<p class='engeltreffen'>"; - - echo "<u>". ReplaceSmilies(mysql_result($Erg, $n, "Betreff")) ."</u>\n"; - - // Schow Admin Page - if( $_SESSION['CVS'][ "admin/news.php" ] == "Y" ) - echo " <a href=\"./../admin/news.php?action=change&date=". mysql_result($Erg, $n, "Datum"). "\">[edit]</a><br>\n\t\t"; - - echo "<br> <font size=1>".mysql_result($Erg, $n, "Datum").", "; - echo UID2Nick(mysql_result($Erg, $n, "UID"))."</font>"; - // avatar anzeigen? - echo DisplayAvatar (mysql_result($Erg, $n, "UID")); - echo "</p>\n"; - echo "<p class='answer'>". ReplaceSmilies(nl2br(mysql_result($Erg, $n, "Text"))) ."</p>\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 "<p class='comment' align='right'><a href=\"./news_comments.php?nid=$RefID\">$countcom comments</a></p>\n\n"; -} - -echo "<div align=\"center\">\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) - $_GET["news_begin"]) == $DISPLAY_NEWS)) { - echo "<a href=\"./news.php?news_begin=".(($i*$DISPLAY_NEWS) - $DISPLAY_NEWS - 1)."\">$i</a> "; - } else { - echo "$i "; - } -} -echo "</div>"; - -?> - -<br> -<hr> -<h4><?PHP Print_Text(6); ?></h4> -<a name="Neu"> </a> - -<form action="<?PHP echo $ENGEL_ROOT ?>nonpublic/news.php" method="post"> -<?PHP -// Datum mit uebergeben, um doppelte Eintraege zu verhindern -// (Reload nach dem Eintragen!) -?> -<input type="hidden" name="date" value="<?PHP echo date("Y-m-d H:i:s"); ?>"> -<table> - <tr> - <td align="right"><?PHP Print_Text(7); ?></td> - <td><input type="text" name="betreff" size="60"></td> - </tr> - <tr> - <td align="right"><?PHP Print_Text(8); ?></td> - <td><textarea name="text" cols="50" rows="10"></textarea></td> - </tr> - -<?PHP -if ($_SESSION['CVS']["nonpublic/newsAddMeting"] == "Y") { -?> - <tr> - <td align="right"><?PHP Print_Text(9); ?></td> - <td><input type="checkbox" name="treffen" size="1" value="1"></td> - </tr> -<?PHP -} -?> -</table> -<br> -<input type="submit" value="<?PHP Print_Text("save"); ?>"> -</form> diff --git a/www-ssl/nonpublic/schichtplan.1.php b/www-ssl/nonpublic/schichtplan.1.php index 5637d2d6..9c99c6ca 100755..100644 --- a/www-ssl/nonpublic/schichtplan.1.php +++ b/www-ssl/nonpublic/schichtplan.1.php @@ -1,21 +1,20 @@ <h4> Tage </h4> <?PHP -include ("../../includes/funktion_schichtplan_array.php"); +require_once ('../bootstrap.php'); -function Printlink( $Datum) -{ +include ("includes/funktion_schichtplan_aray.php"); + +function Printlink($Datum) { GLOBAL $raum; echo "\t<li><a href='./schichtplan.php?ausdatum=$Datum"; // ist ein raum gesetzt? - if (IsSet($raum)) + if (IsSet ($raum)) echo "&raum=$raum"; echo "'>$Datum</a></li>\n"; } //function Printlink( -if( isset ($VeranstaltungsTage)) - foreach( $VeranstaltungsTage as $k => $v) - Printlink( $v); - - +if (isset ($VeranstaltungsTage)) + foreach ($VeranstaltungsTage as $k => $v) + Printlink($v); ?> diff --git a/www-ssl/nonpublic/schichtplan.2.php b/www-ssl/nonpublic/schichtplan.2.php index 1b1b2d08..92443e13 100755..100644 --- a/www-ssl/nonpublic/schichtplan.2.php +++ b/www-ssl/nonpublic/schichtplan.2.php @@ -1,20 +1,20 @@ <h4> Raumübersicht</h4> <?php +require_once ('../bootstrap.php'); -include ("../../includes/funktion_schichtplan_array.php"); +include ("includes/funktion_schichtplan_aray.php"); -if( isset ($Room)) - foreach( $Room as $RoomEntry ) - { - if(isset($ausdatum)) - echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>". - $RoomEntry["Name"]. "</a></li>\n"; - else - echo "\t<li><a href='./schichtplan.php?raum=". $RoomEntry["RID"]. "'>". - $RoomEntry["Name"]. "</a></li>\n"; - } -echo "<br>"; -if(isset($ausdatum)) +if (isset ($Room)) + foreach ($Room as $RoomEntry) { + if (isset ($ausdatum)) + echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=" . $RoomEntry["RID"] . "'>" . + $RoomEntry["Name"] . "</a></li>\n"; + else + echo "\t<li><a href='./schichtplan.php?raum=" . $RoomEntry["RID"] . "'>" . + $RoomEntry["Name"] . "</a></li>\n"; + } +echo "<br />"; +if (isset ($ausdatum)) echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>"; else echo "<li><a href='./schichtplan.php?raum=-1'>alle</a></li>"; diff --git a/www-ssl/nonpublic/schichtplan.php b/www-ssl/nonpublic/schichtplan.php index aff33abd..2b9038a3 100755..100644 --- a/www-ssl/nonpublic/schichtplan.php +++ b/www-ssl/nonpublic/schichtplan.php @@ -1,77 +1,83 @@ <?php +require_once ('../bootstrap.php'); + $title = "Himmel"; $header = "Schichtpläne"; $submenus = 2; -if( isset($_GET["ausdatum"])) +if (isset ($_GET["ausdatum"])) $ausdatum = $_GET["ausdatum"]; -if( isset($_GET["raum"])) -{ +if (isset ($_GET["raum"])) { $raum = $_GET["raum"]; - if( $raum==-1 && isset($_GET["show"])) - { + + if ($raum == -1 && isset ($_GET["show"])) { $raum = ""; - foreach ($_GET as $k => $v) - { - if( substr($k, 0, 5) == "raum_") - { - $raum = $raum. ";". $v; + foreach ($_GET as $k => $v) { + if (substr($k, 0, 5) == "raum_") { + $raum = $raum . ";" . $v; } } } } +<<<<<<< HEAD include ("../../includes/header.php"); include ("../../includes/funktionen.php"); include ("../../includes/funktion_schichtplan.php"); include ("../../includes/funktion_schichtplan_array.php"); ?> +======= +include ("includes/header.php"); +include ("includes/funktionen.php"); +include ("includes/funktion_schichtplan.php"); +include ("includes/funktion_schichtplan_aray.php"); +>>>>>>> spezial_includes_camp -<?PHP echo Get_Text("Hello").$_SESSION['Nick'].",<br>". - Get_Text("pub_schicht_beschreibung"). "<br><br>"; +echo Get_Text("Hello") . $_SESSION['Nick'] . ",<br />" . +Get_Text("pub_schicht_beschreibung") . "<br /><br />"; + +function ShowSwitchDay() { + global $VeranstaltungsTage, $VeranstaltungsTageMax, $ausdatum, $raum; -function ShowSwitchDay() -{ - GLOBAL $VeranstaltungsTage, $VeranstaltungsTageMax, $ausdatum, $raum; - echo "\n\n<table border=\"0\" width=\"100%\"><tr>\n"; - - if( isset($VeranstaltungsTage)) - foreach( $VeranstaltungsTage as $k => $v) - if( $ausdatum == $v) - { - if( $k > 0) - echo "\t\t\t<td align=\"left\">". - "<a href='./schichtplan.php?ausdatum=". $VeranstaltungsTage[$k-1]. - "&raum=$raum'>". $VeranstaltungsTage[$k-1]. "</a></td>\n"; - if( $k < $VeranstaltungsTageMax) - echo "\t\t\t<td align=\"right\">". - "<a href='./schichtplan.php?ausdatum=". $VeranstaltungsTage[$k+1]. - "&raum=$raum'>". $VeranstaltungsTage[$k+1]. "</a></td>\n"; - } + + if (isset ($VeranstaltungsTage)) + foreach ($VeranstaltungsTage as $k => $v) + if ($ausdatum == $v) { + if ($k > 0) + echo "\t\t\t<td align=\"left\">" . + "<a href='./schichtplan.php?ausdatum=" . $VeranstaltungsTage[$k -1] . + "&raum=$raum'>" . $VeranstaltungsTage[$k -1] . "</a></td>\n"; + if ($k < $VeranstaltungsTageMax) + echo "\t\t\t<td align=\"right\">" . + "<a href='./schichtplan.php?ausdatum=" . $VeranstaltungsTage[$k +1] . + "&raum=$raum'>" . $VeranstaltungsTage[$k +1] . "</a></td>\n"; + } echo "\n\n</table>"; } // 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()+$gmdateOffset). "%' ORDER BY `DateS`"; -// $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '2004-12-29%' ORDER BY `DateS`"; +if (!isset ($ausdatum)) { + $sql = "SELECT `DateS` FROM `Shifts` WHERE `DateS` like '" . gmdate("Y-m-d", time() + $gmdateOffset) . "%' 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); + if (mysql_num_rows($Erg) == 0) { + $sql = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` ASC LIMIT 0, 1"; + $Erg = mysql_query($sql, $con); } - if( mysql_num_rows( $Erg ) > 0 ) - $ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10); + if (mysql_num_rows($Erg) > 0) + $ausdatum = substr(mysql_result($Erg, 0, "DateS"), 0, 10); else - $ausdatum = gmdate("Y-m-d", time()+$gmdateOffset); + $ausdatum = gmdate("Y-m-d", time() + $gmdateOffset); } +if (!isset ($raum)) { + // Ausgabe wenn kein Raum Ausgew�hlt: + echo Get_Text("pub_schicht_auswahl_raeume") . "<br /><br />\n"; +<<<<<<< HEAD if ( !isset($raum) ) { @@ -80,11 +86,13 @@ if ( !isset($raum) ) if( isset($Room)) { +======= + if (isset ($Room)) { +>>>>>>> spezial_includes_camp echo "<form action=\"./schichtplan.php\" method=\"GET\">\n"; - foreach( $Room as $RoomEntry ) - { - echo "\t<li><input type=\"checkbox\" name=\"raum_". $RoomEntry["RID"]. "\" value=\"". $RoomEntry["RID"]." \">"; - echo "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>". $RoomEntry["Name"]. "</a>"; + foreach ($Room as $RoomEntry) { + echo "\t<li><input type=\"checkbox\" name=\"raum_" . $RoomEntry["RID"] . "\" value=\"" . $RoomEntry["RID"] . " \">"; + echo "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=" . $RoomEntry["RID"] . "'>" . $RoomEntry["Name"] . "</a>"; echo "</input></li>\n"; } echo "<input type=\"hidden\" name=\"ausdatum\" value=\"$ausdatum\">"; @@ -93,15 +101,15 @@ if ( !isset($raum) ) echo "</form>\n"; } - echo "<br><br>"; - echo Get_Text("pub_schicht_alles_1"). "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'> <u>". - Get_Text("pub_schicht_alles_2"). "</u> </a>".Get_Text("pub_schicht_alles_3"); - echo "\n<br><br>\n\n"; + echo "<br /><br />"; + echo Get_Text("pub_schicht_alles_1") . "<a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'> <u>" . + Get_Text("pub_schicht_alles_2") . "</u> </a>" . Get_Text("pub_schicht_alles_3"); + echo "\n<br /><br />\n\n"; echo "<hr>\n\n"; - echo Get_Text("pub_schicht_EmptyShifts"). "\n"; - - + echo Get_Text("pub_schicht_EmptyShifts") . "\n"; + // zeit die naesten freien schichten +<<<<<<< HEAD showEmptyShifts(); } else @@ -113,6 +121,16 @@ else else echo Get_Text("pub_schicht_Anzeige_1"). $ausdatum. Get_Text("pub_schicht_Anzeige_2"). $RoomID[$raum]. "<br><br>"; +======= + showEmptyShifts(); +} else { // Wenn einraum Ausgew�hlt ist: + if ($raum == -1) + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":<br /><br />"; + elseif (substr($raum, 0, 1) == ";") echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . ":<br /><br />"; + else + echo Get_Text("pub_schicht_Anzeige_1") . $ausdatum . + Get_Text("pub_schicht_Anzeige_2") . $RoomID[$raum] . "<br /><br />"; +>>>>>>> spezial_includes_camp ShowSwitchDay(); @@ -121,85 +139,82 @@ else echo "\t\t<td>start</td>\n"; //Ausgabe Spalten �berschrift +<<<<<<< HEAD if( $raum == -1 ) { if( isset($Room)) foreach( $Room as $RoomEntry ) if (SummRoomShifts($RoomEntry["RID"]) > 0) echo "\t\t<th>". $RoomEntry["Name"]. "</th>\n"; +======= + if ($raum == -1) { + if (isset ($Room)) + foreach ($Room as $RoomEntry) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t<th>" . $RoomEntry["Name"] . "</th>\n"; +>>>>>>> spezial_includes_camp } - elseif( substr( $raum, 0, 1) == ";" ) - { - $words = preg_split("/;/", $raum); - foreach ($words as $word) - { - if( strlen(trim($word)) > 0) - echo "\t\t<th>". $RoomID[trim($word)]. "</th>\n"; + elseif (substr($raum, 0, 1) == ";") { + $words = preg_split("/;/", $raum); + foreach ($words as $word) { + if (strlen(trim($word)) > 0) + echo "\t\t<th>" . $RoomID[trim($word)] . "</th>\n"; } - } - else - echo "\t\t<th>". $RoomID[$raum]. "</th>\n"; - echo "\t</tr>\n"; - + } else + echo "\t\t<th>" . $RoomID[$raum] . "</th>\n"; + echo "\t</tr>\n"; + //Zeit Ausgeben - for( $i = 0; $i < 24; $i++ ) - for( $j = 0; $j < $GlobalZeileProStunde; $j++) - { - $Spalten[$i * $GlobalZeileProStunde + $j] = - "\t<tr class=\"content\">\n\t\t"; + for ($i = 0; $i < 24; $i++) + for ($j = 0; $j < $GlobalZeileProStunde; $j++) { + $Spalten[$i * $GlobalZeileProStunde + $j] = "\t<tr class=\"content\">\n\t\t"; //Stunde: - $SpaltenTemp=""; - $SpaltenTemp.= ($i<10)? "0$i:": "$i:"; + $SpaltenTemp = ""; + $SpaltenTemp .= ($i < 10) ? "0$i:" : "$i:"; //Minute - $TempMinuten = (($j*60) / $GlobalZeileProStunde); - $SpaltenTemp.= ($TempMinuten<10)? "0$TempMinuten": "$TempMinuten"; - + $TempMinuten = (($j * 60) / $GlobalZeileProStunde); + $SpaltenTemp .= ($TempMinuten < 10) ? "0$TempMinuten" : "$TempMinuten"; + //aktuelle stunde markieren - if( ($j==0) && ($i == gmdate("H", time()+$gmdateOffset)) && (gmdate("Y-m-d", time()+ $gmdateOffset) == $ausdatum) ) + if (($j == 0) && ($i == gmdate("H", time() + $gmdateOffset)) && (gmdate("Y-m-d", time() + $gmdateOffset) == $ausdatum)) $SpaltenTemp = "<h1>$SpaltenTemp</h1>"; - + $SpaltenTemp = "<td>$SpaltenTemp</td>\n"; - $Spalten[$i * $GlobalZeileProStunde + $j].= $SpaltenTemp; + $Spalten[$i * $GlobalZeileProStunde + $j] .= $SpaltenTemp; } - - if( $raum == -1 ) - { - if( isset($Room)) - foreach( $Room as $RoomEntry ) - if (SummRoomShifts($RoomEntry["RID"]) > 0) - CreateRoomShifts( $RoomEntry["RID"] ); + + if ($raum == -1) { + if (isset ($Room)) + foreach ($Room as $RoomEntry) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + CreateRoomShifts($RoomEntry["RID"]); } - elseif( substr( $raum, 0, 1) == ";" ) - { - if( isset($Room)) - { - $words = preg_split("/;/", $raum); - foreach ($words as $word) - { - if( strlen(trim($word)) > 0) - if (SummRoomShifts($word) > 0) - CreateRoomShifts( $word ); - } + elseif (substr($raum, 0, 1) == ";") { + if (isset ($Room)) { + $words = preg_split("/;/", $raum); + foreach ($words as $word) { + if (strlen(trim($word)) > 0) + if (SummRoomShifts($word) > 0) + CreateRoomShifts($word); + } } - } - else - CreateRoomShifts( $raum ); - + } else + CreateRoomShifts($raum); + //Ausageb Zeilen - for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) - { - echo $Spalten[$i]."\t</tr>\n"; + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) { + echo $Spalten[$i] . "\t</tr>\n"; } - echo "</table>\n"; - + echo "</table>\n"; + ShowSwitchDay(); -}//if (isset($raum)) +} //if (isset($raum)) -echo "<a href=\"". $_SESSION["newurl"]. "&Icon=0\">@</a>"; +echo "<a href=\"" . $_SESSION["newurl"] . "&Icon=0\">@</a>"; -include ("../../includes/footer.php"); +include ("includes/footer.php"); ?> diff --git a/www-ssl/nonpublic/schichtplan_add.php b/www-ssl/nonpublic/schichtplan_add.php index 50caf5c7..1bbcdc4b 100755..100644 --- a/www-ssl/nonpublic/schichtplan_add.php +++ b/www-ssl/nonpublic/schichtplan_add.php @@ -1,126 +1,114 @@ <?php +require_once ('../bootstrap.php'); + $title = "Himmel"; $header = "Schichtpläne"; -include ("../../includes/header.php"); -include ("../../includes/funktion_schichtplan.php"); -include ("../../includes/funktion_schichtplan_array.php"); -include ("../../includes/funktionen.php"); +include "includes/header.php"; +include "includes/funktion_schichtplan.php"; +include "includes/funktion_schichtplan_aray.php"; +include "includes/funktionen.php"; -if (isset($_POST["newtext"]) && isset($_POST["SID"]) && isset($_POST["TID"])) { +if (isset ($_POST["newtext"]) && isset ($_POST["SID"]) && isset ($_POST["TID"])) { SetHeaderGo2Back(); - - // datum der einzutragenden schicht heraussuhen... - $ShiftSQL = "SELECT `DateS`, `DateE` FROM `Shifts` WHERE `SID`='". $_POST["SID"]. ".'"; - $ShiftErg = mysql_query ($ShiftSQL, $con); + + // datum der einzutragenden Schicht heraussuhen... + $ShiftSQL = "SELECT `DateS`, `DateE` FROM `Shifts` WHERE `SID`='" . $_POST["SID"] . ".'"; + $ShiftErg = mysql_query($ShiftSQL, $con); $beginSchicht = mysql_result($ShiftErg, 0, "DateS"); - $endSchicht = mysql_result($ShiftErg, 0, "DateE"); - - //wenn keien rechte definiert sind - if( !isset($_SESSION['CVS'][ $TID2Name[$_POST["TID"]] ])) - $_SESSION['CVS'][ $TID2Name[$_POST["TID"]] ] = "Y"; - - if( $_SESSION['CVS'][ $TID2Name[$_POST["TID"]] ] == "Y") - { - // Ueberpruefung, ob der Engel bereits f�r eine Schicht zu dieser Zeit eingetragen ist - $SSQL="SELECT * FROM `Shifts`". - " INNER JOIN `ShiftEntry` ON `ShiftEntry`.`SID` = `Shifts`.`SID`". - " WHERE ((". - " ((`Shifts`.`DateS` >= '$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 - } - else - { + $endSchicht = mysql_result($ShiftErg, 0, "DateE"); + + // wenn keien rechte definiert sind + if (!isset ($_SESSION['CVS'][$TID2Name[$_POST["TID"]]])) + $_SESSION['CVS'][$TID2Name[$_POST["TID"]]] = "Y"; + + if ($_SESSION['CVS'][$TID2Name[$_POST["TID"]]] == "Y") { + // Ueberpruefung, ob der Engel bereits fuer eine Schicht zu dieser Zeit eingetragen ist + $SSQL = "SELECT * FROM `Shifts`" . + " INNER JOIN `ShiftEntry` ON `ShiftEntry`.`SID` = `Shifts`.`SID`" . + " WHERE ((" . + " ((`Shifts`.`DateS` >= '$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"); + } + } + } else { echo "<h1>:-(</h1>"; array_push($error_messages, "Hack atteck\n"); } } -elseif (isset($_GET["SID"]) && isset($_GET["TID"])) -{ - //wenn keien rechte definiert sind - if( !isset($_SESSION['CVS'][ $TID2Name[$_GET["TID"]] ])) - $_SESSION['CVS'][ $TID2Name[$_GET["TID"]] ] = "Y"; - - +elseif (isset ($_GET["SID"]) && isset ($_GET["TID"])) { + //wenn keine Rechte definiert sind + if (!isset ($_SESSION['CVS'][$TID2Name[$_GET["TID"]]])) + $_SESSION['CVS'][$TID2Name[$_GET["TID"]]] = "Y"; - if( $_SESSION['CVS'][ $TID2Name[$_GET["TID"]] ] == "Y") - { + if ($_SESSION['CVS'][$TID2Name[$_GET["TID"]]] == "Y") { + echo Get_Text("pub_schichtplan_add_Text1") . "<br /><br />\n\n" . + "<form action=\"./schichtplan_add.php\" method=\"post\">\n" . + "<table border=\"0\">\n"; - echo Get_Text("pub_schichtplan_add_Text1"). "<br><br>\n\n". - "<form action=\"./schichtplan_add.php\" method=\"post\">\n". - "<table border=\"0\">\n"; - $SQL = "SELECT * FROM `Shifts` WHERE "; - $SQL .="(`SID` = '". $_GET["SID"]. "')"; + $SQL .= "(`SID` = '" . $_GET["SID"] . "')"; $Erg = mysql_query($SQL, $con); - - echo "<tr><td>". Get_Text("pub_schichtplan_add_Date"). ":</td> <td>". - mysql_result($Erg, 0, "DateS"). "</td></tr>\n"; - - echo "<tr><td>". Get_Text("pub_schichtplan_add_Place"). ":</td> <td>". - $RoomID[ mysql_result($Erg, 0, "RID") ]. "</td></tr>\n"; - - echo "<tr><td>". Get_Text("pub_schichtplan_add_Job"). ":</td> <td>". - $EngelTypeID[$_GET["TID"]]. "</td></tr>\n"; - - echo "<tr><td>". Get_Text("pub_schichtplan_add_Len"). ":</td> <td>". - mysql_result($Erg, 0, "Len"). "h</td></tr>\n"; - - echo "<tr><td>". Get_Text("pub_schichtplan_add_TextFor"). ":</td> <td>". - mysql_result($Erg, 0, "Man"). "</td></tr>\n"; - - echo "<tr><td valign='top'>". Get_Text("pub_schichtplan_add_Comment"). ":</td>\n <td>". - "<textarea name='newtext' cols='50' rows='10'></textarea> </td></tr>\n"; - - echo "<tr><td> </td>\n". - "<td><input type=\"submit\" value=\"". Get_Text("pub_schichtplan_add_submit"). "\"> </td></tr>\n". - "</table>\n". - "<input type=\"hidden\" name=\"SID\" value=\"". $_GET["SID"]. "\">\n". - "<input type=\"hidden\" name=\"TID\" value=\"". $_GET["TID"]. "\">\n". - "</form>"; - } - else - { + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Date") . ":</td> <td>" . + mysql_result($Erg, 0, "DateS") . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Place") . ":</td> <td>" . + $RoomID[mysql_result($Erg, 0, "RID")] . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Job") . ":</td> <td>" . + $EngelTypeID[$_GET["TID"]] . "</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_Len") . ":</td> <td>" . + mysql_result($Erg, 0, "Len") . "h</td></tr>\n"; + + echo "<tr><td>" . Get_Text("pub_schichtplan_add_TextFor") . ":</td> <td>" . + mysql_result($Erg, 0, "Man") . "</td></tr>\n"; + + echo "<tr><td valign='top'>" . Get_Text("pub_schichtplan_add_Comment") . ":</td>\n <td>" . + "<textarea name='newtext' cols='50' rows='10'></textarea> </td></tr>\n"; + + echo "<tr><td> </td>\n" . + "<td><input type=\"submit\" value=\"" . Get_Text("pub_schichtplan_add_submit") . "\"> </td></tr>\n" . + "</table>\n" . + "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n" . + "<input type=\"hidden\" name=\"TID\" value=\"" . $_GET["TID"] . "\">\n" . + "</form>"; + } else { echo "<h1>:-(</h1>"; array_push($error_messages, "Hack atteck\n"); } - } -include ("../../includes/footer.php"); +include "includes/footer.php"; ?> diff --git a/www-ssl/nonpublic/schichtplan_beamer.php b/www-ssl/nonpublic/schichtplan_beamer.php index cd410fc2..269660e1 100755..100644 --- a/www-ssl/nonpublic/schichtplan_beamer.php +++ b/www-ssl/nonpublic/schichtplan_beamer.php @@ -1,61 +1,59 @@ <?php -include ("../../includes/header_start.php"); +require_once ('../bootstrap.php'); -include ("../../includes/funktionen.php"); -include ("../../includes/funktion_schichtplan_beamer.php"); +include "includes/header_start.php"; +include "includes/funktionen.php"; +include "includes/funktion_schichtplan_beamer.php"; -$Time = time()+3600+3600; -//$Time = 1104241344; +$Time = time() + 3600 + 3600; ?> + <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> -<HTML> -<HEAD> -<TITLE>Schichtpläne für Beamer</TITLE> -<!--<link rel=stylesheet type="text/css" href="/css/style1.css">--> -<meta http-equiv="refresh" content="30; URL=<?PHP echo $url. $_SERVER['PHP_SELF']?>"> -</HEAD> -<BODY> -<?PHP +<html> +<head> +<title>Schichtpläne für Beamer</title> +<meta http-equiv="refresh" content="30; URL=<?php echo $url . $_SERVER['PHP_SELF']; ?>" /> +</head> + +<body> + +<?php + echo "<table border=\"1\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\" frame=\"void\">\n"; echo "<colgroup span=\"4\" valign=\"center\"> - <col width=\"30\"> - <col width=\"3*\"> - <col width=\"3*\"> - <col width=\"3*\"> - </colgroup>\n"; - -echo "<tr align=\"center\">\n". -// "\t<td> </td>\n". - "\t<td>". gmdate("d.m.y", $Time). "</td>\n". - "\t<td>". gmdate("H", $Time-3600). ":00</td>\n". - "\t<td>". gmdate("H", $Time+0). ":00</td>\n". - "\t<td>". gmdate("H", $Time+3600). ":00</td>\n". - "</tr>\n"; - -foreach( $Room as $RoomEntry ) -{ - - //var-init + <col width=\"30\"> + <col width=\"3*\"> + <col width=\"3*\"> + <col width=\"3*\"> + </colgroup>\n"; + +echo "<tr align=\"center\">\n" . +"<td>" . gmdate("d.m.y", $Time) . "</td>\n" . +"<td>" . gmdate("H", $Time -3600) . ":00</td>\n" . +"<td>" . gmdate("H", $Time +0) . ":00</td>\n" . +"<td>" . gmdate("H", $Time +3600) . ":00</td>\n" . +"</tr>\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 = ausgabe_Zeile($RoomEntry["RID"], $Time -3600, $AnzahlEintraege); + $Out .= ausgabe_Zeile($RoomEntry["RID"], $Time, $AnzahlEintraege); + $Out .= ausgabe_Zeile($RoomEntry["RID"], $Time +3600, $AnzahlEintraege); + + if ($AnzahlEintraege == 0) $Out = ""; else - $Out = "<tr>\n\t<td>_". $RoomEntry["Name"]. "_</td>\n". $Out . "</tr>\n"; - + $Out = "<tr>\n<td>_" . $RoomEntry["Name"] . "_</td>\n" . $Out . "</tr>\n"; + echo $Out; } +?> -echo "</table>\n"; +</table> -?> -</BODY> -</HTML> +</body> +</html> diff --git a/www-ssl/nonpublic/waeckliste.php b/www-ssl/nonpublic/waeckliste.php deleted file mode 100755 index 7ca7460e..00000000 --- a/www-ssl/nonpublic/waeckliste.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php -$title = "Himmel"; -$header = "Weckdienst - Liste der zu weckenden Engel"; - -include ("../../includes/header.php"); - -?> - -<?PHP echo Get_Text("Hello"). $_SESSION['Nick'].",<br>\n". - Get_Text("pub_waeckliste_Text1")?> -<br><br> -<table border="0" width="100%" class="border" cellpadding="2" cellspacing="1"> - <tr class="contenttopic"> - <th align="left"><?PHP echo Get_Text("pub_waeckliste_Nick");?></th> - <th align="left"><?PHP echo Get_Text("pub_waeckliste_Datum");?></th> - <th align="left"><?PHP echo Get_Text("pub_waeckliste_Ort");?></th> - <th align="left"><?PHP echo Get_Text("pub_waeckliste_Comment");?></th> - </tr> - -<?PHP - $sql = "SELECT * FROM `Wecken` ORDER BY `Date` ASC"; - $Erg = mysql_query($sql, $con); - $count = mysql_num_rows($Erg); - - for ($i=0; $i < $count; $i++) { - $row=mysql_fetch_row($Erg); -?> - <tr class="content"> - <td align="left"><?PHP echo UID2Nick(mysql_result($Erg, $i, "UID")); ?> </td> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Date"); ?> </td> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Ort"); ?> </td> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Bemerkung"); ?> </td> - </tr> -<?PHP - } -?> -</table> -<?PHP -include ("../../includes/footer.php"); -?> diff --git a/www-ssl/nonpublic/wecken.php b/www-ssl/nonpublic/wecken.php deleted file mode 100755 index 30ef689b..00000000 --- a/www-ssl/nonpublic/wecken.php +++ /dev/null @@ -1,81 +0,0 @@ -<?php -$title = "Himmel"; -$header = "Weckdienst"; - -include ("../../includes/header.php"); - -if( isset($_POST["eintragen"])) - if( $_POST["eintragen"] == Get_Text("pub_wake_bouton") ) - { - $SQL = "INSERT INTO `Wecken` (`UID`, `Date`, `Ort`, `Bemerkung`) ". - "VALUES ('". $_SESSION['UID']. "', '". $_POST["Date"]. "', '". $_POST["Ort"]. "', ". - "'". $_POST["Bemerkung"]. "')"; - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - Print_Text(4); - } -if( isset($_GET["eintragen"])) - if ($_GET["eintragen"] == "loeschen") - { - $SQL = "DELETE FROM `Wecken` WHERE `UID`='". $_SESSION['UID']. "' AND `ID`='". $_GET["weckID"]."' LIMIT 1"; - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - Print_Text(4); - } - -echo Get_Text("Hello").$_SESSION['Nick'].",<br>".Get_Text("pub_wake_beschreibung"). "<br><br>\n\n"; - - -echo Get_Text("pub_wake_beschreibung2"); ?> -<br><br> -<table border="0" width="100%" class="border" cellpadding="2" cellspacing="1"> - <tr class="contenttopic"> - <th align="left"><?PHP echo Get_Text("pub_wake_Datum"); ?></th> - <th align="left"><?PHP echo Get_Text("pub_wake_Ort"); ?></th> - <th align="left"><?PHP echo Get_Text("pub_wake_Bemerkung"); ?></th> - <th align="left"><?PHP echo Get_Text("pub_wake_change"); ?></th> - </tr> - -<?PHP - $sql = "SELECT * FROM `Wecken` WHERE `UID`='". $_SESSION['UID']. "' ORDER BY `Date` ASC"; - $Erg = mysql_query($sql, $con); - $count = mysql_num_rows($Erg); - - for ($i=0; $i < $count; $i++) { - $row=mysql_fetch_row($Erg); -?> - <tr class="content"> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Date"); ?> </td> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Ort"); ?> </td> - <td align="left"><?PHP echo mysql_result($Erg, $i, "Bemerkung"); ?> </td> - <td align="left"><a href="./wecken.php?eintragen=loeschen&weckID=<?PHP - echo mysql_result($Erg, $i, "ID")."\">".Get_Text("pub_wake_del"); ?></a></td> - </tr> -<?PHP - } -?> -</table> -<br><br> - -<?PHP echo Get_Text("pub_wake_Text2"); ?><br><br> - -<form action="wecken.php" method="post"> -<table> - <tr> - <td align="right"><?PHP echo Get_Text("pub_wake_Datum"); ?>:</td> - <td align="left"><input type="text" name="Date" value="2003-08-05 08:00:00"></td> - </tr> - <tr> - <td align="right"><?PHP echo Get_Text("pub_wake_Ort"); ?></td> - <td align="left"><input type="text" name="Ort" value="Tent 23"></td> - </tr> - <tr> - <td align="right"><?PHP echo Get_Text("pub_wake_Bemerkung"); ?></td> - <td align="left"><textarea name="Bemerkung" rows="5" cols="40">knock knock leo, follow the white rabbit to the blue tent</textarea></td> - </tr> -</table> -<input type="submit" name="eintragen" value="<?PHP echo Get_Text("pub_wake_bouton"); ?>"> -</form> -<?PHP -include ("../../includes/footer.php"); -?> |