diff options
Diffstat (limited to 'www-ssl/nonpublic')
18 files changed, 1234 insertions, 1304 deletions
diff --git a/www-ssl/nonpublic/auth.php b/www-ssl/nonpublic/auth.php index 3356a81c..2bd6f86f 100755..100644 --- a/www-ssl/nonpublic/auth.php +++ b/www-ssl/nonpublic/auth.php @@ -1,66 +1,32 @@ -<?PHP -header('Content-Type: application/json'); - -include ("../../../camp2011/includes/config.php"); -include ("../../../camp2011/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')); -} - - +<?php + header("Content-Type: application/json"); + + include "../../../camp2011/includes/config.php"; + include "../../../camp2011/includes/config_db.php"; + + $User = $_POST['user']; + $Pass = $_POST['pw']; + $SourceOuth = $_POST['so']; + + if(isset($CurrentExternAuthPass) && $SourceOuth == $CurrentExternAuthPass) { + $sql = "SELECT * FROM `User` WHERE `Nick`='" . $User . "'"; + $Erg = mysql_query($sql, $con); + + if(mysql_num_rows($Erg) == 1) { + if(mysql_result($Erg, 0, "Passwort") == $Pass) { + $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 index 5bbd63ce..6ddb093a 100755..100644 --- a/www-ssl/nonpublic/einstellungen.php +++ b/www-ssl/nonpublic/einstellungen.php @@ -1,360 +1,377 @@ -<?PHP -/* Todo: -add if-construct with configvar for user-shirt-settings - * - * - */ -$title = "Himmel"; -$header = "Deine persönlichen Einstellungen"; -include ("../../../camp2011/includes/header.php"); -include ("../../../camp2011/includes/crypt.php"); - -if (!IsSet($_POST["action"])) -{ - echo Get_Text("Hallo").$_SESSION['Nick'].",<br>\n\n"; - Print_Text(13); +<?php + $title = "Himmel"; + $header = "Deine persönlichen Einstellungen"; + include "../../../camp2011/includes/header.php"; + include "../../../camp2011/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");?> +<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> + <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_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_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_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_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_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_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><?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>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>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("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 + <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"); ?>"> + </table> + <input type="submit" value="<?php Print_Text("save"); ?>"> </form> -<br> - +<br /> -<hr width=\"100%\"> -<?PHP Print_Text(14);?> +<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"); ?>"> + <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> - +<br /> <hr width="100%"> -<br> -<?PHP Print_Text(18); ?> +<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"); ?>"> + <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> +<br /> <hr width="100%"> -<br> -<?PHP Print_Text(20); ?> +<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"); ?>"> + <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); - } + +<?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 "<input type=\"hidden\" name=\"action\" value=\"sendPicture\">\n"; + echo "<input name=\"file\" type=\"file\" size=\"50\" maxlength=\"". get_cfg_var("post_max_size"). "\">\n"; + echo "(max ". get_cfg_var("post_max_size"). "Byte)<br />\n"; + echo "<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 "<input type=\"hidden\" name=\"action\" value=\"delPicture\">\n"; + echo "<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 "<input type=\"hidden\" name=\"action\" value=\"delPicture\">\n"; + echo "<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 "<input type=\"hidden\" name=\"action\" value=\"avatar\">\n"; + echo "<table>\n"; + echo "<tr>\n<td>". Get_Text(23). "<br /></td>\n</tr>\n"; + echo "<tr>\n"; + echo "<td>\n"; + echo "<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 "<option value=\"" . $i . "\"" . ($_SESSION['Avatar'] == $i ? " selected" : "") . ">avatar" . $i . "</option>\n"; + + echo "</select> \n"; + echo "<img src=\"" . $url . $ENGEL_ROOT . "pic/avatar/avatar" . $_SESSION['Avatar'] . ".gif\" name=\"avatar\" border=\"0\" align=\"top\">\n"; + echo "</td>\n</tr>\n"; + echo "</table>\n"; + echo "<input type=\"submit\" value=\"" . Get_Text("save") . "\">\n"; + echo "</form>\n"; + break; + } //CASE + } else { - Print_Text(31); + 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 '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; + 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; + $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"; + $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); + $_SESSION['Avatar']=$_POST["eAvatar"]; + if ($Erg==1) + Print_Text(34); else - Print_Text(29); + 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;"; - } + 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"); + 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; + 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; + 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"; + $chsql="DELETE FROM `UserPicture` WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1"; $Erg = mysql_query($chsql, $con); - if ($Erg==1) - Print_Text("pub_einstellungen_del_OK"); + if ($Erg==1) + Print_Text("pub_einstellungen_del_OK"); else - Print_Text("pub_einstellungen_del_KO"); - Break; + Print_Text("pub_einstellungen_del_KO"); + Break; } } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/nonpublic/engelbesprechung.php b/www-ssl/nonpublic/engelbesprechung.php index ea5c6e3c..0f2892b7 100755..100644 --- a/www-ssl/nonpublic/engelbesprechung.php +++ b/www-ssl/nonpublic/engelbesprechung.php @@ -1,37 +1,27 @@ <?php -$title = "Himmel"; -$header = "Engelbesprechung"; -include ("../../../camp2011/includes/header.php"); -?> - -<br> - -<?php + $title = "Himmel"; + $header = "Engelbesprechung"; + include "../../../camp2011/includes/header.php"; -$SQL = "SELECT * FROM `News` ORDER BY 'Datum' DESC"; -$Erg = mysql_query($SQL, $con); + $SQL = "SELECT * FROM `News` ORDER BY 'Datum' DESC"; + $Erg = mysql_query($SQL, $con); -// anzahl zeilen -$Zeilen = mysql_num_rows($Erg); + // 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>"; + for ($n = 0 ; $n < $Zeilen ; $n++) { + if (mysql_result($Erg, $n, "Treffen") == "1") { + echo "<p class='question'><u>" . mysql_result($Erg, $n, "Betreff") . "</u>"; - echo "<br> <font size=1>".mysql_result($Erg, $n, "Datum").", "; - echo UID2Nick(mysql_result($Erg, $n, "UID"))."</font></p>\n"; + // Show 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 "<p class='answetion'>".nl2br(mysql_result($Erg, $n, "Text"))."</p>\n"; + 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 ("../../../camp2011/includes/footer.php"); + include ("../../../camp2011/includes/footer.php"); ?> diff --git a/www-ssl/nonpublic/faq.php b/www-ssl/nonpublic/faq.php index 79044c2c..7f768282 100755..100644 --- a/www-ssl/nonpublic/faq.php +++ b/www-ssl/nonpublic/faq.php @@ -1,35 +1,32 @@ <?php -$title = "Himmel"; -$header = "FAQ / Fragen an die Erzengel"; -include ("../../../camp2011/includes/header.php"); + $title = "Himmel"; + $header = "FAQ / Fragen an die Erzengel"; + include "../../../camp2011/includes/header.php"; - -// Erstaufruf, oder Frage bereits abgeschickt? -if (!IsSet($_POST["eUID"])) -{ - Print_Text(35); + // Erstaufruf, oder Frage bereits abgeschickt? + if(!isset($_POST["eUID"])) { + Print_Text(35); ?> -<br><br> +<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"); ?>"> + <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 - +<?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"; +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 "<br />\n<b>".Get_Text(39)."</b><br />\n"; echo "<hr width=\"99%\">\n"; -echo "<br><b>".Get_Text(40)."</b><br>\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); @@ -38,19 +35,19 @@ $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); if ($Zeilen==0){ - Print_Text(41); + Print_Text(41); } else { - for ($n = 0 ; $n < $Zeilen ; $n++) { - echo "<p class='question'>".nl2br(mysql_result($Erg, $n, "Question"))."<br>\n"; + 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 "<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"; +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); @@ -58,14 +55,14 @@ $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); if ($Zeilen==0){ - Print_Text(41); + 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>"; - } + 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 ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/nonpublic/index.php b/www-ssl/nonpublic/index.php index 1072e2d6..a4b2e975 100755..100644 --- a/www-ssl/nonpublic/index.php +++ b/www-ssl/nonpublic/index.php @@ -9,73 +9,73 @@ session_start(); // alte Session - falls vorhanden - wiederherstellen... function LoginOK() { - include ("../../../camp2011/includes/config.php"); - header("HTTP/1.1 302 Moved Temporarily"); - header("Location: ". $url. $ENGEL_ROOT. "nonpublic/news.php"); + include ("../../../camp2011/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(); + LoginOK(); } else { // User ist noch nicht angemeldet - $sql = "SELECT * FROM `User` WHERE `Nick`='". $_POST["user"]. "'"; - $userstring = mysql_query($sql, $con); + $sql = "SELECT * FROM `User` WHERE `Nick`='". $_POST["user"]. "'"; + $userstring = mysql_query($sql, $con); - // anzahl zeilen - $user_anz = mysql_num_rows($userstring); + // 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 + 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 ("../../../camp2011/includes/header.php"); if( isset($ErrorText)) - echo "<h2>". Get_Text($ErrorText). "</h2><br>\n"; + echo "<h2>". Get_Text($ErrorText). "</h2><br />\n"; include ("../../../camp2011/includes/login_eingabefeld.php"); include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/nonpublic/messages.php b/www-ssl/nonpublic/messages.php index 2ba852d4..c85bf669 100755..100644 --- a/www-ssl/nonpublic/messages.php +++ b/www-ssl/nonpublic/messages.php @@ -1,127 +1,122 @@ <?php -$title = "Himmel"; -$header = ""; - -include ("../../../camp2011/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 ("../../../camp2011/includes/footer.php"); + $title = "Himmel"; + $header = ""; + + include "../../../camp2011/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 "<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Datum"). "</b></td>\n"; + echo "<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Von"). "</b></td>\n"; + echo "<td class=\"contenttopic\"><b>". Get_Text("pub_messages_An"). "</b></td>\n"; + echo "<td class=\"contenttopic\"><b>". Get_Text("pub_messages_Text"). "</b></td>\n"; + echo "<td class=\"contenttopic\"></td>\n"; + echo "</tr>\n"; + + for($i = 0; $i < mysql_num_rows($erg); $i++) { + echo "<tr class=\"content\">\n"; + echo "<td>" . mysql_result($erg, $i, "Datum") . "</td>\n"; + echo "<td>" . UID2Nick(mysql_result($erg, $i, "SUID")) . "</td>\n"; + echo "<td>" . UID2Nick(mysql_result($erg, $i, "RUID")) . "</td>\n"; + echo "<td>" . mysql_result($erg, $i, "Text") . "</td>\n"; + echo "<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 "<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 "<td></td>\n"; + echo "<td></td>\n"; + + // Listet alle Nicks auf + echo "<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 "<option value=\"" . mysql_result($uErg, $k, "UID") . "\">" . mysql_result($uErg, $k, "Nick") . "</option>\n"; + } + + echo "</select></td>\n"; + echo "<td><textarea name=\"Text\" cols=\"30\" rows=\"10\"></textarea></td>\n"; + echo "<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 "../../../camp2011/includes/footer.php"; ?> diff --git a/www-ssl/nonpublic/myschichtplan.php b/www-ssl/nonpublic/myschichtplan.php index e11453c4..6bbabbb6 100755..100644 --- a/www-ssl/nonpublic/myschichtplan.php +++ b/www-ssl/nonpublic/myschichtplan.php @@ -1,118 +1,116 @@ <?php -$title = "Himmel"; -$header = "Mein Schichtplan"; - -include ("../../../camp2011/includes/header.php"); -include ("../../../camp2011/includes/funktionen.php"); -include ("../../../camp2011/includes/funktion_schichtplan.php"); -include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); - - -If( !IsSet($_GET["action"]) ) -{ + $title = "Himmel"; + $header = "Mein Schichtplan"; + + include ("../../../camp2011/includes/header.php"); + include ("../../../camp2011/includes/funktionen.php"); + include ("../../../camp2011/includes/funktion_schichtplan.php"); + include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); + + 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"]) ) + $_GET["UIDs"] = $_SESSION['UID']; + else + $USER_ID = $_GET["UIDs"]; + + echo "<form action=\"".$_SERVER['SCRIPT_NAME']."\" method=\"GET\" >"; + + echo "Liste von <select name=\"UIDs\">\n"; + + $usql="SELECT * FROM `User` ORDER BY `Nick`"; + $uErg = mysql_query($usql, $con); + $urowcount = mysql_num_rows($uErg); + + for ($k=0; $k<$urowcount; $k++) { + echo "<option value=\"".mysql_result($uErg, $k, "UID")."\" ". + ( ($_GET["UIDs"]==mysql_result($uErg, $k, "UID")) ? " selected":""). ">". + mysql_result($uErg, $k, "Nick"). + "</option>\n"; + } - 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"]) ) - $_GET["UIDs"] = $_SESSION['UID']; - else - $USER_ID = $_GET["UIDs"]; - - echo "<form action=\"".$_SERVER['SCRIPT_NAME']."\" method=\"GET\" >"; - - echo "Liste von <select name=\"UIDs\">\n"; - $usql="SELECT * FROM `User` ORDER BY `Nick`"; - $uErg = mysql_query($usql, $con); - $urowcount = mysql_num_rows($uErg); - for ($k=0; $k<$urowcount; $k++) - { - echo "\t<option value=\"".mysql_result($uErg, $k, "UID")."\" ". - ( ($_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++ ) - { - 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"; - - // 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 "<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 "</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++ ) + { + 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"; + + // 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 "<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"; if( $_SESSION['CVS'][ "nonpublic/myschichtplan_ical.php" ] == "Y" ) { - echo "<br><a href=\"./myschichtplan_ical.php\">". Get_Text("pub_myschichtplan_ical"). "</a>\n"; + echo "<br /><a href=\"./myschichtplan_ical.php\">". Get_Text("pub_myschichtplan_ical"). "</a>\n"; } } @@ -120,65 +118,65 @@ 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"; - else - echo Get_Text("pub_mywake_add_ko"). "\n"; - } - else - echo Get_Text("pub_mywake_after"). "\n"; + 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"; + 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>"; + 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(); + 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_myshift_EditSave_KO"). "\n"; + SetHeaderGo2Back(); } } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/nonpublic/myschichtplan_ical.php b/www-ssl/nonpublic/myschichtplan_ical.php index bcb9eb6f..928f0c86 100755..100644 --- a/www-ssl/nonpublic/myschichtplan_ical.php +++ b/www-ssl/nonpublic/myschichtplan_ical.php @@ -27,22 +27,22 @@ echo "X-WR-CALNAME;VALUE=TEXT:". "Himmel - Schichtplan\n"; 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 "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 "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 "BEGIN:VALARM\n"; - echo "TRIGGER;VALUE=DURATION:-PT5M\n"; - echo "DESCRIPTION:". str_replace( ',', '\\,',mysql_result( $erg, $i, "Man" ) ). "\n"; - echo "ACTION:DISPLAY\n"; - echo "END:VALARM\n"; - echo "END:VEVENT\n"; + echo "BEGIN:VEVENT\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 "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 "BEGIN:VALARM\n"; + echo "TRIGGER;VALUE=DURATION:-PT5M\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"; diff --git a/www-ssl/nonpublic/news.php b/www-ssl/nonpublic/news.php index b1513716..7cc9a193 100755..100644 --- a/www-ssl/nonpublic/news.php +++ b/www-ssl/nonpublic/news.php @@ -1,11 +1,10 @@ <?php -$title = "Himmel"; -$header = "News"; -include ("../../../camp2011/includes/header.php"); + $title = "Himmel"; + $header = "News"; + include "../../../camp2011/includes/header.php"; + echo "<a href=\"#Neu\">" . Get_Text(3) . "</a>"; + include "news_output.php"; -echo "<a href=\"#Neu\">".Get_Text(3)."</a>"; -include ("news_output.php"); - -include ("../../../camp2011/includes/footer.php"); + include "../../../camp2011/includes/footer.php"; ?> diff --git a/www-ssl/nonpublic/news_comments.php b/www-ssl/nonpublic/news_comments.php index 826733c1..b90d5a82 100755..100644 --- a/www-ssl/nonpublic/news_comments.php +++ b/www-ssl/nonpublic/news_comments.php @@ -3,54 +3,50 @@ $title = "Kommentare zu den News"; $header = "Kommentar"; include ("../../../camp2011/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( 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(); - } -} + 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); + $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> + <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 +<?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 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 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 nl2br(mysql_result($Erg, $n, "Text"))."\n"; echo "\t\t</td>"; echo "</tr>"; } @@ -59,24 +55,24 @@ echo "</table>"; ?> -<br> +<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"]; ?>"> +<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> +<br /> <input type="submit" value="sichern..."> </form> -<?PHP +<?php } diff --git a/www-ssl/nonpublic/news_output.php b/www-ssl/nonpublic/news_output.php index e1afc067..77bbad87 100755..100644 --- a/www-ssl/nonpublic/news_output.php +++ b/www-ssl/nonpublic/news_output.php @@ -3,20 +3,20 @@ if( isset( $_POST["text"]) && isset( $_POST["betreff"]) && IsSet( $_POST["date"]) ) { if( !isset( $_POST["treffen"])) - $_POST["treffen"] = 0; + $_POST["treffen"] = 0; $SQL = "INSERT INTO `News` (`Datum`, `Betreff`, `Text`, `UID`, `Treffen`) ". - "VALUES ('". $_POST["date"]. "', '". $_POST["betreff"]. "', '". $_POST["text"]. "', '".$_SESSION['UID']. - "', '". $_POST["treffen"]. "');"; + "VALUES ('". $_POST["date"]. "', '". $_POST["betreff"]. "', '". $_POST["text"]. "', '".$_SESSION['UID']. + "', '". $_POST["treffen"]. "');"; $Erg = mysql_query($SQL, $con); if ($Erg == 1) - Print_Text(4); + Print_Text(4); } if( !IsSet( $_GET["news_begin"])) - $_GET["news_begin"]=0; - + $_GET["news_begin"]=0; + if( !IsSet( $_GET["DISPLAY_NEWS"])) - $_GET["DISPLAY_NEWS"] = 5; + $_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); @@ -28,17 +28,17 @@ for ($n = 0 ; $n < $news_rows ; $n++) { if (mysql_result($Erg, $n, "Treffen") == 0) - echo "<p class='question'>"; + echo "<p class='question'>"; else - echo "<p class='engeltreffen'>"; + 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 " <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 "<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")); @@ -59,17 +59,17 @@ $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 "; - } + 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> +<br /> <hr> <h4><?PHP Print_Text(6); ?></h4> <a name="Neu"> </a> @@ -101,6 +101,6 @@ if ($_SESSION['CVS']["nonpublic/newsAddMeting"] == "Y") { } ?> </table> -<br> +<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 490167a0..1ed4d32f 100755..100644 --- a/www-ssl/nonpublic/schichtplan.1.php +++ b/www-ssl/nonpublic/schichtplan.1.php @@ -5,17 +5,17 @@ include ("../../../camp2011/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)) - echo "&raum=$raum"; - echo "'>$Datum</a></li>\n"; + GLOBAL $raum; + echo "\t<li><a href='./schichtplan.php?ausdatum=$Datum"; + // ist ein raum gesetzt? + if (IsSet($raum)) + echo "&raum=$raum"; + echo "'>$Datum</a></li>\n"; } //function Printlink( if( isset ($VeranstaltungsTage)) - foreach( $VeranstaltungsTage as $k => $v) - Printlink( $v); + foreach( $VeranstaltungsTage as $k => $v) + Printlink( $v); ?> diff --git a/www-ssl/nonpublic/schichtplan.2.php b/www-ssl/nonpublic/schichtplan.2.php index 59e58852..d0193178 100755..100644 --- a/www-ssl/nonpublic/schichtplan.2.php +++ b/www-ssl/nonpublic/schichtplan.2.php @@ -6,17 +6,17 @@ include ("../../../camp2011/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"; + 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>"; +echo "<br />"; if(isset($ausdatum)) - echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>"; + 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>"; + 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 65907863..e8f8f02a 100755..100644 --- a/www-ssl/nonpublic/schichtplan.php +++ b/www-ssl/nonpublic/schichtplan.php @@ -1,73 +1,68 @@ <?php -$title = "Himmel"; -$header = "Schichtpläne"; -$submenus = 2; - -if( isset($_GET["ausdatum"])) - $ausdatum = $_GET["ausdatum"]; -if( isset($_GET["raum"])) -{ - $raum = $_GET["raum"]; - if( $raum==-1 && isset($_GET["show"])) - { - $raum = ""; - foreach ($_GET as $k => $v) - { - if( substr($k, 0, 5) == "raum_") - { - $raum = $raum. ";". $v; - } - } - } -} - -include ("../../../camp2011/includes/header.php"); -include ("../../../camp2011/includes/funktionen.php"); -include ("../../../camp2011/includes/funktion_schichtplan.php"); -include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); -?> - -<?PHP echo Get_Text("Hello").$_SESSION['Nick'].",<br>". - Get_Text("pub_schicht_beschreibung"). "<br><br>"; - -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"; - } - echo "\n\n</table>"; + $title = "Himmel"; + $header = "Schichtpläne"; + $submenus = 2; + + if(isset($_GET["ausdatum"])) + $ausdatum = $_GET["ausdatum"]; + if(isset($_GET["raum"])) { + $raum = $_GET["raum"]; + + if($raum==-1 && isset($_GET["show"])) { + $raum = ""; + foreach ($_GET as $k => $v) { + if(substr($k, 0, 5) == "raum_") { + $raum = $raum. ";". $v; + } + } + } + } + + include ("../../../camp2011/includes/header.php"); + include ("../../../camp2011/includes/funktionen.php"); + include ("../../../camp2011/includes/funktion_schichtplan.php"); + include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); + + echo Get_Text("Hello").$_SESSION['Nick'].",<br />". + Get_Text("pub_schicht_beschreibung"). "<br /><br />"; + + 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"; + } + 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`"; - $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); - else - $ausdatum = gmdate("Y-m-d", time()+$gmdateOffset); + $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 ) + $ausdatum = substr(mysql_result($Erg,0,"DateS"),0,10); + else + $ausdatum = gmdate("Y-m-d", time()+$gmdateOffset); } @@ -75,127 +70,127 @@ if( !isset($ausdatum) ) if ( !isset($raum) ) { - // Ausgabe wenn kein Raum Ausgewählt: - echo Get_Text("pub_schicht_auswahl_raeume"). "<br><br>\n"; - - if( isset($Room)) - { - 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>"; - echo "</input></li>\n"; - } - echo "<input type=\"hidden\" name=\"ausdatum\" value=\"$ausdatum\">"; - echo "<input type=\"hidden\" name=\"raum\" value=\"-1\">"; - echo "<input type=\"submit\" name=\"show\" value=\"show\">\n"; - 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 "<hr>\n\n"; - echo Get_Text("pub_schicht_EmptyShifts"). "\n"; - - - // zeit die naesten freien schichten - showEmptyShifts(); + // Ausgabe wenn kein Raum Ausgewählt: + echo Get_Text("pub_schicht_auswahl_raeume"). "<br /><br />\n"; + + if( isset($Room)) + { + 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>"; + echo "</input></li>\n"; + } + echo "<input type=\"hidden\" name=\"ausdatum\" value=\"$ausdatum\">"; + echo "<input type=\"hidden\" name=\"raum\" value=\"-1\">"; + echo "<input type=\"submit\" name=\"show\" value=\"show\">\n"; + 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 "<hr>\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.":<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>"; - - ShowSwitchDay(); - - echo "\n\n<table border=\"0\" width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; - echo "\t<tr class=\"contenttopic\">\n"; - echo "\t\t<td>start</td>\n"; - - //Ausgabe Spalten überschrift - if( $raum == -1 ) - { - if( isset($Room)) - foreach( $Room as $RoomEntry ) - if (SummRoomShifts($RoomEntry["RID"]) > 0) - echo "\t\t<th>". $RoomEntry["Name"]. "</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"; - - //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"; - - //Stunde: - $SpaltenTemp=""; - $SpaltenTemp.= ($i<10)? "0$i:": "$i:"; - - //Minute - $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) ) - $SpaltenTemp = "<h1>$SpaltenTemp</h1>"; - - $SpaltenTemp = "<td>$SpaltenTemp</td>\n"; - $Spalten[$i * $GlobalZeileProStunde + $j].= $SpaltenTemp; - } - - 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 ); - } - } - } - else - CreateRoomShifts( $raum ); - - //Ausageb Zeilen - for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) - { - echo $Spalten[$i]."\t</tr>\n"; - } - - echo "</table>\n"; - - ShowSwitchDay(); +{ // 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 />"; + + ShowSwitchDay(); + + echo "\n\n<table border=\"0\" width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; + echo "\t<tr class=\"contenttopic\">\n"; + echo "\t\t<td>start</td>\n"; + + //Ausgabe Spalten überschrift + if( $raum == -1 ) + { + if( isset($Room)) + foreach( $Room as $RoomEntry ) + if (SummRoomShifts($RoomEntry["RID"]) > 0) + echo "\t\t<th>". $RoomEntry["Name"]. "</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"; + + //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"; + + //Stunde: + $SpaltenTemp=""; + $SpaltenTemp.= ($i<10)? "0$i:": "$i:"; + + //Minute + $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) ) + $SpaltenTemp = "<h1>$SpaltenTemp</h1>"; + + $SpaltenTemp = "<td>$SpaltenTemp</td>\n"; + $Spalten[$i * $GlobalZeileProStunde + $j].= $SpaltenTemp; + } + + 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 ); + } + } + } + else + CreateRoomShifts( $raum ); + + //Ausageb Zeilen + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) + { + echo $Spalten[$i]."\t</tr>\n"; + } + + echo "</table>\n"; + + ShowSwitchDay(); }//if (isset($raum)) diff --git a/www-ssl/nonpublic/schichtplan_add.php b/www-ssl/nonpublic/schichtplan_add.php index 359425bf..621cd97e 100755..100644 --- a/www-ssl/nonpublic/schichtplan_add.php +++ b/www-ssl/nonpublic/schichtplan_add.php @@ -1,126 +1,111 @@ <?php -$title = "Himmel"; -$header = "Schichtpläne"; -include ("../../../camp2011/includes/header.php"); -include ("../../../camp2011/includes/funktion_schichtplan.php"); -include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); -include ("../../../camp2011/includes/funktionen.php"); - -if (isset($_POST["newtext"]) && isset($_POST["SID"]) && isset($_POST["TID"])) { - SetHeaderGo2Back(); + $title = "Himmel"; + $header = "Schichtpläne"; + include "../../../camp2011/includes/header.php"; + include "../../../camp2011/includes/funktion_schichtplan.php"; + include "../../../camp2011/includes/funktion_schichtplan_aray.php"; + include "../../../camp2011/includes/funktionen.php"; + + 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); - $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 - { - 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"; - - - - 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"; - - $SQL = "SELECT * FROM `Shifts` WHERE "; - $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 "<h1>:-(</h1>"; - array_push($error_messages, "Hack atteck\n"); - } - -} - -include ("../../../camp2011/includes/footer.php"); + // 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 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 keine Rechte definiert sind + if( !isset($_SESSION['CVS'][ $TID2Name[$_GET["TID"]] ])) + $_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"; + + $SQL = "SELECT * FROM `Shifts` WHERE "; + $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 "<h1>:-(</h1>"; + array_push($error_messages, "Hack atteck\n"); + } + } + + include "../../../camp2011/includes/footer.php"; ?> diff --git a/www-ssl/nonpublic/schichtplan_beamer.php b/www-ssl/nonpublic/schichtplan_beamer.php index cc2a48e7..2e4e78c2 100755..100644 --- a/www-ssl/nonpublic/schichtplan_beamer.php +++ b/www-ssl/nonpublic/schichtplan_beamer.php @@ -1,61 +1,55 @@ <?php -include ("../../../camp2011/includes/header_start.php"); + include "../../../camp2011/includes/header_start.php"; + include "../../../camp2011/includes/funktionen.php"; + include "../../../camp2011/includes/funktion_schichtplan_beamer.php"; -include ("../../../camp2011/includes/funktionen.php"); -include ("../../../camp2011/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> -echo "<table border=\"1\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\" frame=\"void\">\n"; +<?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 - $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 = "<tr>\n\t<td>_". $RoomEntry["Name"]. "_</td>\n". $Out . "</tr>\n"; - - echo $Out; + <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); + + if($AnzahlEintraege == 0) + $Out = ""; + else + $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 index c14505ab..bb9a0668 100755..100644 --- a/www-ssl/nonpublic/waeckliste.php +++ b/www-ssl/nonpublic/waeckliste.php @@ -1,40 +1,38 @@ <?php -$title = "Himmel"; -$header = "Weckdienst - Liste der zu weckenden Engel"; - -include ("../../../camp2011/includes/header.php"); + $title = "Himmel"; + $header = "Weckdienst - Liste der zu weckenden Engel"; + include "../../../camp2011/includes/header.php"; ?> -<?PHP echo Get_Text("Hello"). $_SESSION['Nick'].",<br>\n". - Get_Text("pub_waeckliste_Text1")?> -<br><br> +<p><?php echo Get_Text("Hello") . $_SESSION['Nick'] . ",<br />\n" . Get_Text("pub_waeckliste_Text1"); ?></p> <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 + <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); + 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 + <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 ("../../../camp2011/includes/footer.php"); + +<?php + include "../../../camp2011/includes/footer.php"; ?> diff --git a/www-ssl/nonpublic/wecken.php b/www-ssl/nonpublic/wecken.php index 67e32e28..164a4bb0 100755..100644 --- a/www-ssl/nonpublic/wecken.php +++ b/www-ssl/nonpublic/wecken.php @@ -1,81 +1,81 @@ <?php -$title = "Himmel"; -$header = "Weckdienst"; + $title = "Himmel"; + $header = "Weckdienst"; -include ("../../../camp2011/includes/header.php"); + include "../../../camp2011/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); - } + 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); -echo Get_Text("Hello").$_SESSION['Nick'].",<br>".Get_Text("pub_wake_beschreibung"). "<br><br>\n\n"; + 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 "<p>" . Get_Text("Hello") . $_SESSION['Nick'] . ",<br />" . Get_Text("pub_wake_beschreibung") . "</p>\n\n"; + echo Get_Text("pub_wake_beschreibung2"); +?> -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 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"; + +<?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); + $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 + <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> +<br /><br /> -<?PHP echo Get_Text("pub_wake_Text2"); ?><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> + <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> + <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> + <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"); ?>"> +<input type="submit" name="eintragen" value="<?php echo Get_Text("pub_wake_bouton"); ?>" /> </form> -<?PHP +<?php include ("../../../camp2011/includes/footer.php"); ?> |