From a537f4bf73101c467af3b01db32fcdb9fd0a91ce Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Wed, 1 Jun 2011 14:48:31 +0200
Subject: bootstrapping

---
 www-ssl/nonpublic/auth.php               |  59 ++--
 www-ssl/nonpublic/einstellungen.php      | 457 +++++++++++++++----------------
 www-ssl/nonpublic/engelbesprechung.php   |  40 +--
 www-ssl/nonpublic/faq.php                |  72 ++---
 www-ssl/nonpublic/messages.php           | 242 ++++++++--------
 www-ssl/nonpublic/myschichtplan.php      | 329 +++++++++++-----------
 www-ssl/nonpublic/myschichtplan_ical.php |  63 +++--
 www-ssl/nonpublic/news_comments.php      |  87 +++---
 www-ssl/nonpublic/schichtplan.1.php      |  27 +-
 www-ssl/nonpublic/schichtplan.2.php      |  28 +-
 www-ssl/nonpublic/schichtplan.php        | 360 ++++++++++++------------
 www-ssl/nonpublic/schichtplan_add.php    | 221 +++++++--------
 www-ssl/nonpublic/schichtplan_beamer.php |  56 ++--
 www-ssl/nonpublic/waeckliste.php         |  28 +-
 www-ssl/nonpublic/wecken.php             |  65 +++--
 15 files changed, 1071 insertions(+), 1063 deletions(-)

(limited to 'www-ssl/nonpublic')

diff --git a/www-ssl/nonpublic/auth.php b/www-ssl/nonpublic/auth.php
index 2bd6f86f..7d58988c 100644
--- a/www-ssl/nonpublic/auth.php
+++ b/www-ssl/nonpublic/auth.php
@@ -1,32 +1,43 @@
 <?php
-  header("Content-Type: application/json");
+require_once ('../bootstrap.php');
 
-  include "../../../camp2011/includes/config.php";
-  include "../../../camp2011/includes/config_db.php";
+header("Content-Type: application/json");
 
-  $User = $_POST['user'];
-  $Pass = $_POST['pw'];
-  $SourceOuth = $_POST['so'];
+include "includes/config.php";
+include "includes/config_db.php";
 
-  if(isset($CurrentExternAuthPass) && $SourceOuth == $CurrentExternAuthPass) {
-    $sql = "SELECT * FROM `User` WHERE `Nick`='" . $User . "'";
-    $Erg = mysql_query($sql, $con);
+$User = $_POST['user'];
+$Pass = $_POST['pw'];
+$SourceOuth = $_POST['so'];
 
-    if(mysql_num_rows($Erg) == 1) {
-      if(mysql_result($Erg, 0, "Passwort") == $Pass) {
-        $UID = mysql_result($Erg, 0, "UID");
+if (isset ($CurrentExternAuthPass) && $SourceOuth == $CurrentExternAuthPass) {
+	$sql = "SELECT * FROM `User` WHERE `Nick`='" . $User . "'";
+	$Erg = mysql_query($sql, $con);
 
-        // get CVS import Data
-        $SQL = "SELECT * FROM `UserCVS` WHERE `UID`='" . $UID . "'";
-        $Erg_CVS =  mysql_query($SQL, $con);
-        $CVS = mysql_fetch_array($Erg_CVS);
+	if (mysql_num_rows($Erg) == 1) {
+		if (mysql_result($Erg, 0, "Passwort") == $Pass) {
+			$UID = mysql_result($Erg, 0, "UID");
 
-        $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'));
+			// 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 6ddb093a..81dda869 100644
--- a/www-ssl/nonpublic/einstellungen.php
+++ b/www-ssl/nonpublic/einstellungen.php
@@ -1,12 +1,14 @@
 <?php
-  $title = "Himmel";
-  $header = "Deine pers&ouml;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);
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "Deine pers&ouml;nlichen Einstellungen";
+include "includes/header.php";
+include "includes/crypt.php";
+
+if (!isset ($_POST["action"])) {
+	echo Get_Text("Hallo") . $_SESSION['Nick'] . ",<br />\n\n";
+	Print_Text(13);
 ?>
 <hr width="100%">
 <?php Print_Text("pub_einstellungen_Text_UserData"); ?>
@@ -69,7 +71,9 @@
     </tr>
 
 <?php
-if($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
+
+
+	if ($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
 ?>
     <tr>
       <td><?php Print_Text("makeuser_T-Shirt"); ?></td>
@@ -83,7 +87,9 @@ if($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
       </select></td>
     </tr>
 <?php
-}
+
+
+	}
 ?>
   </table>
   <input type="submit" value="<?php Print_Text("save"); ?>">
@@ -147,7 +153,11 @@ if($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
       <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>  */ ?>
+<?php
+
+
+	/*       <option value="NL" <?php if($_SESSION['Sprache'] == 'NL') { echo "selected"; } ?>>Dutch</option>  */
+?>
       </select>
     </td></tr>
   </table>
@@ -155,224 +165,211 @@ if($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
 </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 "<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>&nbsp;&nbsp;\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 {
-    switch ($_POST["action"]) {
-      case 'set':
-        if($_POST["new1"] == $_POST["new2"]) {
-          Print_Text(25); 
-          $sql = "SELECT * FROM `User` WHERE `UID`='".$_SESSION['UID']. "'";
-          $Erg = mysql_query($sql, $con);
-
-          if(PassCrypt($_POST["old"]) == mysql_result($Erg, 0, "Passwort")) {
-            Print_Text(26);
-            Print_Text(27);
-            $usql = "UPDATE `User` SET `Passwort`='". PassCrypt($_POST["new1"]). "' WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
-           $Erg = mysql_query($usql, $con);
-
-           if ($Erg==1) {
-             Print_Text(28);
-           } else {
-             Print_Text(29);
-           }
-         } else {
-           Print_Text(30);
-         }
-       } else {
-         Print_Text(31);
-       }
-    break;
-
-    case 'colour':
-
-  $chsql="UPDATE `User` SET ".
-    "`color`= '". $_POST["colourid"]. "', ".
-    "`Menu`= '". $_POST["eMenu"]. "' ".
-    "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1";
-  $Erg = mysql_query($chsql, $con);
-  echo mysql_error($con);
-  $_SESSION['color']=$_POST["colourid"];
-  $_SESSION['Menu']=$_POST["eMenu"];
-  if ($Erg==1) {
-    Print_Text(32);
-  } else {
-    Print_Text(29);
-  }
-  break;
-
-case 'sprache':
-
-  $chsql="UPDATE `User` SET `Sprache` = '". $_POST["language"]. "' WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1";
-  $Erg = mysql_query($chsql, $con);
-  $_SESSION['Sprache']=$_POST["language"];
-  if ($Erg==1) {
-    Print_Text(33);
-  } else {
-    Print_Text(29);
-  }
-  break;
-
-case 'avatar':
-  $chsql="UPDATE `User` SET `Avatar`='". $_POST["eAvatar"]. "' WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1";
-        $Erg = mysql_query($chsql, $con);
-  $_SESSION['Avatar']=$_POST["eAvatar"];
-  if ($Erg==1)
-    Print_Text(34);
-        else
-    Print_Text(29);
-        break;
-
-case 'setUserData':
-  if( $_SESSION['CVS'][ "Change T_Shirt Size" ] == "Y" )
-  {
-    $chsql= "UPDATE `User` SET ".
-      "`Nick`='".     $_POST["eNick"].  "', `Name`='".   $_POST["eName"].  "', ".
-      "`Vorname`='".  $_POST["eVorname"].  "', `Alter`='".  $_POST["eAlter"]. "', ".
-      "`Telefon`='".  $_POST["eTelefon"].  "', `Handy`='".  $_POST["eHandy"]. "', ".
-      "`DECT`='".     $_POST["eDECT"].   "', `email`='".  $_POST["eemail"]. "', ".
-      "`ICQ`='".      $_POST["eICQ"].    "', `jabber`='". $_POST["ejabber"]."', ".
-      "`Hometown`='". $_POST["Hometown"].  "', `Size`='".   $_POST["Sizeid"]. "' ".
-      "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1;";
-  }
-  else
-  {
-    $chsql= "UPDATE `User` SET ".
-      "`Nick`='".     $_POST["eNick"].  "', `Name`='".   $_POST["eName"].  "', ".
-      "`Vorname`='".  $_POST["eVorname"].  "', `Alter`='".  $_POST["eAlter"]. "', ".
-      "`Telefon`='".  $_POST["eTelefon"].  "', `Handy`='".  $_POST["eHandy"]. "', ".
-      "`DECT`='".     $_POST["eDECT"].   "', `email`='".  $_POST["eemail"]. "', ".
-      "`ICQ`='".      $_POST["eICQ"].    "', `jabber`='". $_POST["ejabber"]."', ".
-      "`Hometown`='". $_POST["Hometown"].  "' ".
-      "WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1;";
-  }
-        $Erg = mysql_query($chsql, $con);
-
-  if ($Erg==1) 
-  {
-    $_SESSION['Nick'] = $_POST["eNick"];
-    $_SESSION['Name'] = $_POST["eName"];
-    $_SESSION['Vorname'] = $_POST["eVorname"];
-    $_SESSION['Alter'] = $_POST["eAlter"];
-    $_SESSION['Telefon'] = $_POST["eTelefon"];
-    $_SESSION['Handy'] = $_POST["eHandy"];
-    $_SESSION['DECT'] = $_POST["eDECT"];
-    $_SESSION['email'] = $_POST["eemail"];
-    $_SESSION['ICQ'] = $_POST["eICQ"];
-    $_SESSION['jabber'] = $_POST["ejabber"];
-    $_SESSION['Hometown'] = $_POST["Hometown"];
-    if( $_SESSION['CVS'][ "Change T_Shirt Size" ] == "Y" )
-    {
-      $_SESSION['Size']=$_POST["Sizeid"];    
-    }
-    else if( $_SESSION['Size'] != $_POST["Sizeid"]) 
-    {
-      array_push($error_messages, "einstellungen.php, change t-shirt size not allowed\n");
-    }
-
-  
-    Print_Text("pub_einstellungen_UserDateSaved");
-        } 
-  else
-  {
-    Print_Text(29);
-    echo mysql_error( $con);
-  }
-  break;
-
-case 'sendPicture':
-  if( $_FILES["file"]["size"] > 0)
-  {
-    if( ($_FILES["file"]["type"] == "image/jpeg") || 
-        ($_FILES["file"]["type"] == "image/png")  ||
-        ($_FILES["file"]["type"] == "image/gif")  )
-    {    
-    $data = addslashes(fread(fopen($_FILES["file"]["tmp_name"], "r"), filesize($_FILES["file"]["tmp_name"])));
-
-    if( GetPicturShow( $_SESSION['UID']) == "")
-      $SQL = "INSERT INTO `UserPicture` ".
-        "( `UID`,`Bild`, `ContentType`, `show`) ".
-        "VALUES ('". $_SESSION['UID']. "', '$data', '". $_FILES["file"]["type"]. "', 'N')";
-    else
-      $SQL = "UPDATE `UserPicture` SET ".
-        "`Bild`='$data', ".
-        "`ContentType`='". $_FILES["file"]["type"]. "', ".
-        "`show`='N' ".
-        "WHERE `UID`='". $_SESSION['UID']. "'";
-    
-    $res = mysql_query( $SQL, $con);
-    if( $res)
-      Print_Text("pub_einstellungen_send_OK");
-    else
-      Print_Text("pub_einstellungen_send_KO");
-  
-    echo "<h6>('" . $_FILES["file"]["name"] . "', MIME-Type: " . $_FILES["file"]["type"]. ", " . $_FILES["file"]["size"]. " Byte)</h6>";
-    }
-    else
-    Print_Text("pub_einstellungen_send_KO");  
-  }
-  else
-    Print_Text("pub_einstellungen_send_KO");  
-  break;
-
-case 'delPicture':
-  $chsql="DELETE FROM `UserPicture` WHERE `UID`='". $_SESSION['UID']. "' LIMIT 1";
-        $Erg = mysql_query($chsql, $con);
-  if ($Erg==1)
-    Print_Text("pub_einstellungen_del_OK");
-        else
-    Print_Text("pub_einstellungen_del_KO");
-  Break;
-}
+
+
+	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>&nbsp;&nbsp;\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 {
+	switch ($_POST["action"]) {
+		case 'set' :
+			if ($_POST["new1"] == $_POST["new2"]) {
+				Print_Text(25);
+				$sql = "SELECT * FROM `User` WHERE `UID`='" . $_SESSION['UID'] . "'";
+				$Erg = mysql_query($sql, $con);
+
+				if (PassCrypt($_POST["old"]) == mysql_result($Erg, 0, "Passwort")) {
+					Print_Text(26);
+					Print_Text(27);
+					$usql = "UPDATE `User` SET `Passwort`='" . PassCrypt($_POST["new1"]) . "' WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
+					$Erg = mysql_query($usql, $con);
+
+					if ($Erg == 1) {
+						Print_Text(28);
+					} else {
+						Print_Text(29);
+					}
+				} else {
+					Print_Text(30);
+				}
+			} else {
+				Print_Text(31);
+			}
+			break;
+
+		case 'colour' :
+
+			$chsql = "UPDATE `User` SET " .
+			"`color`= '" . $_POST["colourid"] . "', " .
+			"`Menu`= '" . $_POST["eMenu"] . "' " .
+			"WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
+			$Erg = mysql_query($chsql, $con);
+			echo mysql_error($con);
+			$_SESSION['color'] = $_POST["colourid"];
+			$_SESSION['Menu'] = $_POST["eMenu"];
+			if ($Erg == 1) {
+				Print_Text(32);
+			} else {
+				Print_Text(29);
+			}
+			break;
+
+		case 'sprache' :
+
+			$chsql = "UPDATE `User` SET `Sprache` = '" . $_POST["language"] . "' WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
+			$Erg = mysql_query($chsql, $con);
+			$_SESSION['Sprache'] = $_POST["language"];
+			if ($Erg == 1) {
+				Print_Text(33);
+			} else {
+				Print_Text(29);
+			}
+			break;
+
+		case 'avatar' :
+			$chsql = "UPDATE `User` SET `Avatar`='" . $_POST["eAvatar"] . "' WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
+			$Erg = mysql_query($chsql, $con);
+			$_SESSION['Avatar'] = $_POST["eAvatar"];
+			if ($Erg == 1)
+				Print_Text(34);
+			else
+				Print_Text(29);
+			break;
+
+		case 'setUserData' :
+			if ($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
+				$chsql = "UPDATE `User` SET " .
+				"`Nick`='" . $_POST["eNick"] . "', `Name`='" . $_POST["eName"] . "', " .
+				"`Vorname`='" . $_POST["eVorname"] . "', `Alter`='" . $_POST["eAlter"] . "', " .
+				"`Telefon`='" . $_POST["eTelefon"] . "', `Handy`='" . $_POST["eHandy"] . "', " .
+				"`DECT`='" . $_POST["eDECT"] . "', `email`='" . $_POST["eemail"] . "', " .
+				"`ICQ`='" . $_POST["eICQ"] . "', `jabber`='" . $_POST["ejabber"] . "', " .
+				"`Hometown`='" . $_POST["Hometown"] . "', `Size`='" . $_POST["Sizeid"] . "' " .
+				"WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1;";
+			} else {
+				$chsql = "UPDATE `User` SET " .
+				"`Nick`='" . $_POST["eNick"] . "', `Name`='" . $_POST["eName"] . "', " .
+				"`Vorname`='" . $_POST["eVorname"] . "', `Alter`='" . $_POST["eAlter"] . "', " .
+				"`Telefon`='" . $_POST["eTelefon"] . "', `Handy`='" . $_POST["eHandy"] . "', " .
+				"`DECT`='" . $_POST["eDECT"] . "', `email`='" . $_POST["eemail"] . "', " .
+				"`ICQ`='" . $_POST["eICQ"] . "', `jabber`='" . $_POST["ejabber"] . "', " .
+				"`Hometown`='" . $_POST["Hometown"] . "' " .
+				"WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1;";
+			}
+			$Erg = mysql_query($chsql, $con);
+
+			if ($Erg == 1) {
+				$_SESSION['Nick'] = $_POST["eNick"];
+				$_SESSION['Name'] = $_POST["eName"];
+				$_SESSION['Vorname'] = $_POST["eVorname"];
+				$_SESSION['Alter'] = $_POST["eAlter"];
+				$_SESSION['Telefon'] = $_POST["eTelefon"];
+				$_SESSION['Handy'] = $_POST["eHandy"];
+				$_SESSION['DECT'] = $_POST["eDECT"];
+				$_SESSION['email'] = $_POST["eemail"];
+				$_SESSION['ICQ'] = $_POST["eICQ"];
+				$_SESSION['jabber'] = $_POST["ejabber"];
+				$_SESSION['Hometown'] = $_POST["Hometown"];
+				if ($_SESSION['CVS']["Change T_Shirt Size"] == "Y") {
+					$_SESSION['Size'] = $_POST["Sizeid"];
+				} else
+					if ($_SESSION['Size'] != $_POST["Sizeid"]) {
+						array_push($error_messages, "einstellungen.php, change t-shirt size not allowed\n");
+					}
+
+				Print_Text("pub_einstellungen_UserDateSaved");
+			} else {
+				Print_Text(29);
+				echo mysql_error($con);
+			}
+			break;
+
+		case 'sendPicture' :
+			if ($_FILES["file"]["size"] > 0) {
+				if (($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/png") || ($_FILES["file"]["type"] == "image/gif")) {
+					$data = addslashes(fread(fopen($_FILES["file"]["tmp_name"], "r"), filesize($_FILES["file"]["tmp_name"])));
+
+					if (GetPicturShow($_SESSION['UID']) == "")
+						$SQL = "INSERT INTO `UserPicture` " .
+						"( `UID`,`Bild`, `ContentType`, `show`) " .
+						"VALUES ('" . $_SESSION['UID'] . "', '$data', '" . $_FILES["file"]["type"] . "', 'N')";
+					else
+						$SQL = "UPDATE `UserPicture` SET " .
+						"`Bild`='$data', " .
+						"`ContentType`='" . $_FILES["file"]["type"] . "', " .
+						"`show`='N' " .
+						"WHERE `UID`='" . $_SESSION['UID'] . "'";
+
+					$res = mysql_query($SQL, $con);
+					if ($res)
+						Print_Text("pub_einstellungen_send_OK");
+					else
+						Print_Text("pub_einstellungen_send_KO");
+
+					echo "<h6>('" . $_FILES["file"]["name"] . "', MIME-Type: " . $_FILES["file"]["type"] . ", " . $_FILES["file"]["size"] . " Byte)</h6>";
+				} else
+					Print_Text("pub_einstellungen_send_KO");
+			} else
+				Print_Text("pub_einstellungen_send_KO");
+			break;
+
+		case 'delPicture' :
+			$chsql = "DELETE FROM `UserPicture` WHERE `UID`='" . $_SESSION['UID'] . "' LIMIT 1";
+			$Erg = mysql_query($chsql, $con);
+			if ($Erg == 1)
+				Print_Text("pub_einstellungen_del_OK");
+			else
+				Print_Text("pub_einstellungen_del_KO");
+			Break;
+	}
 }
-include ("../../../camp2011/includes/footer.php");
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/engelbesprechung.php b/www-ssl/nonpublic/engelbesprechung.php
index 0f2892b7..7ff684d4 100644
--- a/www-ssl/nonpublic/engelbesprechung.php
+++ b/www-ssl/nonpublic/engelbesprechung.php
@@ -1,27 +1,29 @@
 <?php
-  $title = "Himmel";
-  $header = "Engelbesprechung";
-  include "../../../camp2011/includes/header.php";
+require_once ('../bootstrap.php');
 
-  $SQL = "SELECT * FROM `News` ORDER BY 'Datum' DESC";
-  $Erg = mysql_query($SQL, $con);
+$title = "Himmel";
+$header = "Engelbesprechung";
+include "includes/header.php";
 
-  // anzahl zeilen
-  $Zeilen  = mysql_num_rows($Erg);
+$SQL = "SELECT * FROM `News` ORDER BY 'Datum' DESC";
+$Erg = mysql_query($SQL, $con);
 
-  for ($n = 0 ; $n < $Zeilen ; $n++) {
-    if (mysql_result($Erg, $n, "Treffen") == "1") {
-      echo "<p class='question'><u>" . mysql_result($Erg, $n, "Betreff") . "</u>";
+// anzahl zeilen
+$Zeilen = mysql_num_rows($Erg);
 
-      // 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>";
+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 />&nbsp; &nbsp;<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";
-    }
-  }
+		// 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>";
 
-  include ("../../../camp2011/includes/footer.php");
+		echo "<br />&nbsp; &nbsp;<font size=1>" . mysql_result($Erg, $n, "Datum") . ", ";
+		echo UID2Nick(mysql_result($Erg, $n, "UID")) . "</font></p>\n";
+		echo "<p class='answetion'>" . nl2br(mysql_result($Erg, $n, "Text")) . "</p>\n";
+	}
+}
+
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/faq.php b/www-ssl/nonpublic/faq.php
index 7f768282..fcc17158 100644
--- a/www-ssl/nonpublic/faq.php
+++ b/www-ssl/nonpublic/faq.php
@@ -1,11 +1,13 @@
 <?php
-  $title = "Himmel";
-  $header = "FAQ / Fragen an die Erzengel";
-  include "../../../camp2011/includes/header.php";
+require_once ('../bootstrap.php');
 
-  // Erstaufruf, oder Frage bereits abgeschickt?
-  if(!isset($_POST["eUID"])) {
-    Print_Text(35);
+$title = "Himmel";
+$header = "FAQ / Fragen an die Erzengel";
+include "includes/header.php";
+
+// Erstaufruf, oder Frage bereits abgeschickt?
+if (!isset ($_POST["eUID"])) {
+	Print_Text(35);
 ?>
 <br /><br />
 <form action="./faq.php" method="POST">
@@ -14,56 +16,58 @@
   <input type="submit" value="<?php Print_Text("save"); ?>">
 </form>
 <?php
+
+
 } else {
-// Auswertung d. Formular-Daten:
+	// 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);
+	$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";
+$SQL = "SELECT * FROM `Questions` WHERE `UID` = " . $_SESSION['UID'] . " AND `AID`='0' ORDER BY 'QID' DESC";
 $Erg = mysql_query($SQL, $con);
 
 // anzahl zeilen
-$Zeilen  = mysql_num_rows($Erg);
+$Zeilen = mysql_num_rows($Erg);
 
-if ($Zeilen==0){
-  Print_Text(41);
+if ($Zeilen == 0) {
+	Print_Text(41);
 
 } else {
-  for ($n = 0 ; $n < $Zeilen ; $n++) {
-    echo "<p class='question'>".nl2br(mysql_result($Erg, $n, "Question"))."<br />\n";
-// Es gibt ja noch keine Antwort:
-//    echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer"))."</p>\n";
-    echo "\n<br />---<br />";
-  }
+	for ($n = 0; $n < $Zeilen; $n++) {
+		echo "<p class='question'>" . nl2br(mysql_result($Erg, $n, "Question")) . "<br />\n";
+		// Es gibt ja noch keine Antwort:
+		//    echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer"))."</p>\n";
+		echo "\n<br />---<br />";
+	}
 }
 
 echo "<hr width=\"99%\">\n";
-echo "<br /><b>".Get_Text(42)."</b><br />\n";
-$SQL = "SELECT * FROM `Questions` WHERE `UID`='".$_SESSION['UID']."' and `AID`<>'0' ORDER BY 'QID' DESC";
+echo "<br /><b>" . Get_Text(42) . "</b><br />\n";
+$SQL = "SELECT * FROM `Questions` WHERE `UID`='" . $_SESSION['UID'] . "' and `AID`<>'0' ORDER BY 'QID' DESC";
 $Erg = mysql_query($SQL, $con);
 
 // anzahl zeilen
-$Zeilen  = mysql_num_rows($Erg);
+$Zeilen = mysql_num_rows($Erg);
 
-if ($Zeilen==0){
-  Print_Text(41);
+if ($Zeilen == 0) {
+	Print_Text(41);
 } else {
-  for ($n = 0 ; $n < $Zeilen ; $n++) {
-    echo "<p class='question'>".nl2br(mysql_result($Erg, $n, "Question"))."<br />\n";
-    echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer")).
-      "@". UID2Nick(mysql_result($Erg, $n, "AID"))."\n";
-    echo "\n<br />---<br />";
-  }
+	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");
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/messages.php b/www-ssl/nonpublic/messages.php
index c85bf669..4868136d 100644
--- a/www-ssl/nonpublic/messages.php
+++ b/www-ssl/nonpublic/messages.php
@@ -1,122 +1,124 @@
 <?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";
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "";
+
+include "includes/header.php";
+
+if (!isset ($_GET["action"]))
+	$_GET["action"] = "start";
+
+switch ($_GET["action"]) {
+	case "start" :
+		echo Get_Text("Hello") . $_SESSION['Nick'] . ", <br />\n";
+		echo Get_Text("pub_messages_text1") . "<br /><br />\n";
+
+		//show exist Messages
+		$SQL = "SELECT * FROM `Messages` WHERE `SUID`='" . $_SESSION["UID"] . "' OR `RUID`='" . $_SESSION["UID"] . "'";
+		$erg = mysql_query($SQL, $con);
+
+		echo "<table border=\"0\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+		echo "<tr>\n";
+		echo "<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 "includes/footer.php";
 ?>
diff --git a/www-ssl/nonpublic/myschichtplan.php b/www-ssl/nonpublic/myschichtplan.php
index 6bbabbb6..5d7b5da3 100644
--- a/www-ssl/nonpublic/myschichtplan.php
+++ b/www-ssl/nonpublic/myschichtplan.php
@@ -1,58 +1,61 @@
 <?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"])) {
-    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 "</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);
-
-  ?>
+
+// Eigener Schichtplan
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "Mein Schichtplan";
+
+include ("includes/header.php");
+include ("includes/funktionen.php");
+include ("includes/funktion_schichtplan.php");
+include ("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 "</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>
@@ -65,119 +68,111 @@
     </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";
-}
 
-} 
-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";
-    }
-    elseif( $_GET["action"] == "edit" ) 
-    {
-      echo Get_Text("pub_myshift_Edit_Text1"). "\n";
-  
-  $sql = "SELECT * FROM `ShiftEntry` WHERE ";
-  $sql.= "(`SID`='". $_GET["SID"]. "' AND `UID`='". $_SESSION['UID']. "')";
-  $Erg = mysql_query($sql, $con);
-
-  echo "<form action=\"./myschichtplan.php\" method=\"GET\">\n";
-  echo "<textarea name='newtext' cols='50' rows='10'>". mysql_result( $Erg, 0, "Comment" ). "</textarea><br /><br />\n";
-  echo "<input type=\"submit\" value=\"save\">\n";
-  echo "<input type=\"hidden\" name=\"SID\" value=\"". $_GET["SID"]. "\">\n";
-  echo "<input type=\"hidden\" name=\"action\" value=\"editSave\">\n";
-  echo "</form>";
-    }
-    elseif( $_GET["action"] == "editSave" ) 
-    {
-      echo Get_Text("pub_myshift_EditSave_Text1"). "<br />\n";
-  $sql = "UPDATE `ShiftEntry` ".
-         "SET `Comment` = '". $_GET["newtext"]. "' ".
-         "WHERE `SID`='". $_GET["SID"]. "' AND `UID`='". $_SESSION['UID']. "' LIMIT 1;";
-  $Erg = mysql_query($sql, $con);
-  if ($Erg == 1)
-    echo " ...". Get_Text("pub_myshift_EditSave_OK"). "\n";
-  else
-    echo " ...". Get_Text("pub_myshift_EditSave_KO"). "\n";
-  SetHeaderGo2Back();  
-    }
+	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";
+	}
+
+} 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";
+	}
+	elseif ($_GET["action"] == "edit") {
+		echo Get_Text("pub_myshift_Edit_Text1") . "\n";
+
+		$sql = "SELECT * FROM `ShiftEntry` WHERE ";
+		$sql .= "(`SID`='" . $_GET["SID"] . "' AND `UID`='" . $_SESSION['UID'] . "')";
+		$Erg = mysql_query($sql, $con);
+
+		echo "<form action=\"./myschichtplan.php\" method=\"GET\">\n";
+		echo "<textarea name='newtext' cols='50' rows='10'>" . mysql_result($Erg, 0, "Comment") . "</textarea><br /><br />\n";
+		echo "<input type=\"submit\" value=\"save\">\n";
+		echo "<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n";
+		echo "<input type=\"hidden\" name=\"action\" value=\"editSave\">\n";
+		echo "</form>";
+	}
+	elseif ($_GET["action"] == "editSave") {
+		echo Get_Text("pub_myshift_EditSave_Text1") . "<br />\n";
+		$sql = "UPDATE `ShiftEntry` " .
+		"SET `Comment` = '" . $_GET["newtext"] . "' " .
+		"WHERE `SID`='" . $_GET["SID"] . "' AND `UID`='" . $_SESSION['UID'] . "' LIMIT 1;";
+		$Erg = mysql_query($sql, $con);
+		if ($Erg == 1)
+			echo " ..." . Get_Text("pub_myshift_EditSave_OK") . "\n";
+		else
+			echo " ..." . Get_Text("pub_myshift_EditSave_KO") . "\n";
+		SetHeaderGo2Back();
+	}
 }
-include ("../../../camp2011/includes/footer.php");
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/myschichtplan_ical.php b/www-ssl/nonpublic/myschichtplan_ical.php
index 928f0c86..ff74fef0 100644
--- a/www-ssl/nonpublic/myschichtplan_ical.php
+++ b/www-ssl/nonpublic/myschichtplan_ical.php
@@ -1,52 +1,51 @@
 <?php
-include ("../../../camp2011/includes/header_start.php");
+require_once ('../bootstrap.php');
 
-include ("../../../camp2011/includes/funktion_schichtplan_aray.php");
+include ("includes/header_start.php");
 
-$SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` ".
-       "INNER JOIN `ShiftEntry` ".
-       "ON `Shifts`.`SID`=`ShiftEntry`.`SID` ".
-       "WHERE `ShiftEntry`.`UID`='". $_SESSION['UID']. "' ".
-       "ORDER BY `DateS`";
-$erg = mysql_query($SQL, $con);
+include ("includes/funktion_schichtplan_aray.php");
 
+$SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` " .
+"INNER JOIN `ShiftEntry` " .
+"ON `Shifts`.`SID`=`ShiftEntry`.`SID` " .
+"WHERE `ShiftEntry`.`UID`='" . $_SESSION['UID'] . "' " .
+"ORDER BY `DateS`";
+$erg = mysql_query($SQL, $con);
 
 //HEADER
 header("Content-Type: text/x-vCalendar");
-header("Content-Disposition: attachment; filename=\"Schichtplan.ics\"" );
+header("Content-Disposition: attachment; filename=\"Schichtplan.ics\"");
 
 //DATA
 echo "BEGIN:VCALENDAR\n";
 echo "PRODID:-//Engelsystem//DE-EN\n";
 echo "VERSION:2.0\n";
-echo "PRODID:". md5('icalschichtplan:'.$_SESSION['UID']). "\n"; 
+echo "PRODID:" . md5('icalschichtplan:' . $_SESSION['UID']) . "\n";
 echo "METHOD:PUBLISH\n";
 echo "CALSCALE:GREGORIAN\n";
 echo "METHOD:PUBLISH\n";
-echo "X-WR-CALNAME;VALUE=TEXT:". "Himmel - Schichtplan\n";
-
-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 "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 "END:VCALENDAR\n";
 
-include( "../../../camp2011/includes/funktion_counter.php");
-
+include ("includes/funktion_counter.php");
 ?>
 
diff --git a/www-ssl/nonpublic/news_comments.php b/www-ssl/nonpublic/news_comments.php
index b90d5a82..db95ec8c 100644
--- a/www-ssl/nonpublic/news_comments.php
+++ b/www-ssl/nonpublic/news_comments.php
@@ -1,26 +1,28 @@
 <?php
+require_once ('../bootstrap.php');
+
 $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 ($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);
+include ("includes/header.php");
+
+if (isset ($_GET["nid"])) {
+	if (isset ($_GET["text"])) {
+		$ch_sql = "INSERT INTO `news_comments` (`Refid`, `Datum`, `Text`, `UID`) " .
+		"VALUES ('" . $_GET["nid"] . "', '" . date("Y-m-d H:i:s") . "', '" . $_GET["text"] . "', '" . $_SESSION["UID"] . "')";
+		$Erg = mysql_query($ch_sql, $con);
+
+		if ($Erg == 1) {
+			echo "Eintrag wurde gespeichert<br /><br />";
+			SetHeaderGo2Back();
+		}
+	}
+
+	$SQL = "SELECT * FROM `news_comments` WHERE `Refid`='" . $_GET["nid"] . "' ORDER BY 'ID'";
+	$Erg = mysql_query($SQL, $con);
+	echo mysql_error($con);
+
+	// anzahl zeilen
+	$news_rows = mysql_num_rows($Erg);
 ?>
 
 <table border="0" width="100%" class="border" cellpadding="2" cellspacing="1">
@@ -33,26 +35,27 @@ if(isset($_GET["nid"])) {
   </tr>
 
 <?php
-for ($n = 0 ; $n < $news_rows ; $n++) {
-  echo "\t<tr class=\"content\">";
-  echo "\t\t<td width=100>";
-    echo mysql_result($Erg, $n, "Datum");
-  echo "\t\t</td>";
-  echo "\t\t<td>";
-    echo UID2Nick(mysql_result($Erg, $n, "UID"));
-    // avatar anzeigen?
-    echo DisplayAvatar (mysql_result($Erg, $n, "UID"));
-  echo "\t\t</td>";
-  echo "</tr>";
-  echo "\t<tr class=\"content\">";
-  echo "\t\t<td colspan=\"2\">";
-    echo nl2br(mysql_result($Erg, $n, "Text"))."\n";
-  echo "\t\t</td>";
-  echo "</tr>";
-}
 
-echo "</table>";
 
+	for ($n = 0; $n < $news_rows; $n++) {
+		echo "\t<tr class=\"content\">";
+		echo "\t\t<td width=100>";
+		echo mysql_result($Erg, $n, "Datum");
+		echo "\t\t</td>";
+		echo "\t\t<td>";
+		echo UID2Nick(mysql_result($Erg, $n, "UID"));
+		// avatar anzeigen?
+		echo DisplayAvatar(mysql_result($Erg, $n, "UID"));
+		echo "\t\t</td>";
+		echo "</tr>";
+		echo "\t<tr class=\"content\">";
+		echo "\t\t<td colspan=\"2\">";
+		echo nl2br(mysql_result($Erg, $n, "Text")) . "\n";
+		echo "\t\t</td>";
+		echo "</tr>";
+	}
+
+	echo "</table>";
 ?>
 
 <br />
@@ -75,11 +78,9 @@ echo "</table>";
 <?php
 
 
-} 
-else 
-{
-  echo "Fehlerhafter Aufruf!";
+} else {
+	echo "Fehlerhafter Aufruf!";
 }
 
-include ("../../../camp2011/includes/footer.php");
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/schichtplan.1.php b/www-ssl/nonpublic/schichtplan.1.php
index 1ed4d32f..9c99c6ca 100644
--- a/www-ssl/nonpublic/schichtplan.1.php
+++ b/www-ssl/nonpublic/schichtplan.1.php
@@ -1,21 +1,20 @@
 <h4>&nbsp;Tage </h4>
 
 <?PHP
-include ("../../../camp2011/includes/funktion_schichtplan_aray.php");
+require_once ('../bootstrap.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";
-} //function Printlink(
-
-if( isset ($VeranstaltungsTage))
-  foreach( $VeranstaltungsTage as $k => $v)
-    Printlink( $v);
+include ("includes/funktion_schichtplan_aray.php");
 
+function Printlink($Datum) {
+	GLOBAL $raum;
+	echo "\t<li><a href='./schichtplan.php?ausdatum=$Datum";
+	// ist ein raum gesetzt?
+	if (IsSet ($raum))
+		echo "&raum=$raum";
+	echo "'>$Datum</a></li>\n";
+} //function Printlink(
 
+if (isset ($VeranstaltungsTage))
+	foreach ($VeranstaltungsTage as $k => $v)
+		Printlink($v);
 ?>
diff --git a/www-ssl/nonpublic/schichtplan.2.php b/www-ssl/nonpublic/schichtplan.2.php
index d0193178..92443e13 100644
--- a/www-ssl/nonpublic/schichtplan.2.php
+++ b/www-ssl/nonpublic/schichtplan.2.php
@@ -1,22 +1,22 @@
 <h4>&nbsp;Raum&uuml;bersicht</h4>
 <?php
+require_once ('../bootstrap.php');
 
-include ("../../../camp2011/includes/funktion_schichtplan_aray.php");
+include ("includes/funktion_schichtplan_aray.php");
 
-if( isset ($Room))
-    foreach( $Room as $RoomEntry  )
-    {
-  if(isset($ausdatum))
-    echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=". $RoomEntry["RID"]. "'>".
-         $RoomEntry["Name"]. "</a></li>\n";
-  else
-    echo "\t<li><a href='./schichtplan.php?raum=". $RoomEntry["RID"]. "'>".
-         $RoomEntry["Name"]. "</a></li>\n";
-    }
+if (isset ($Room))
+	foreach ($Room as $RoomEntry) {
+		if (isset ($ausdatum))
+			echo "\t<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=" . $RoomEntry["RID"] . "'>" .
+			$RoomEntry["Name"] . "</a></li>\n";
+		else
+			echo "\t<li><a href='./schichtplan.php?raum=" . $RoomEntry["RID"] . "'>" .
+			$RoomEntry["Name"] . "</a></li>\n";
+	}
 echo "<br />";
-if(isset($ausdatum))
-  echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>";
+if (isset ($ausdatum))
+	echo "<li><a href='./schichtplan.php?ausdatum=$ausdatum&raum=-1'>alle</a></li>";
 else
-  echo "<li><a href='./schichtplan.php?raum=-1'>alle</a></li>";
+	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 e8f8f02a..766d6996 100644
--- a/www-ssl/nonpublic/schichtplan.php
+++ b/www-ssl/nonpublic/schichtplan.php
@@ -1,200 +1,178 @@
 <?php
-  $title = "Himmel";
-  $header = "Schichtpl&auml;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>";
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "Schichtpl&auml;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 ("includes/header.php");
+include ("includes/funktionen.php");
+include ("includes/funktion_schichtplan.php");
+include ("includes/funktion_schichtplan_aray.php");
+
+echo Get_Text("Hello") . $_SESSION['Nick'] . ",<br />" .
+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);
+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);
 
 }
 
-
-
-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(); 
-} 
-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();
-
-}//if (isset($raum))
-
-echo "<a href=\"". $_SESSION["newurl"]. "&Icon=0\">@</a>";
-
-include ("../../../camp2011/includes/footer.php");
+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();
+} 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();
+
+} //if (isset($raum))
+
+echo "<a href=\"" . $_SESSION["newurl"] . "&Icon=0\">@</a>";
+
+include ("includes/footer.php");
 ?>
diff --git a/www-ssl/nonpublic/schichtplan_add.php b/www-ssl/nonpublic/schichtplan_add.php
index 621cd97e..1bbcdc4b 100644
--- a/www-ssl/nonpublic/schichtplan_add.php
+++ b/www-ssl/nonpublic/schichtplan_add.php
@@ -1,111 +1,114 @@
 <?php
-  $title = "Himmel";
-  $header = "Schichtpl&auml;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 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>&nbsp;</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";
+require_once ('../bootstrap.php');
+
+$title = "Himmel";
+$header = "Schichtpl&auml;ne";
+include "includes/header.php";
+include "includes/funktion_schichtplan.php";
+include "includes/funktion_schichtplan_aray.php";
+include "includes/funktionen.php";
+
+if (isset ($_POST["newtext"]) && isset ($_POST["SID"]) && isset ($_POST["TID"])) {
+	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 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>&nbsp;</td>\n" .
+		"<td><input type=\"submit\" value=\"" . Get_Text("pub_schichtplan_add_submit") . "\"> </td></tr>\n" .
+		"</table>\n" .
+		"<input type=\"hidden\" name=\"SID\" value=\"" . $_GET["SID"] . "\">\n" .
+		"<input type=\"hidden\" name=\"TID\" value=\"" . $_GET["TID"] . "\">\n" .
+		"</form>";
+	} else {
+		echo "<h1>:-(</h1>";
+		array_push($error_messages, "Hack atteck\n");
+	}
+}
+
+include "includes/footer.php";
 ?>
diff --git a/www-ssl/nonpublic/schichtplan_beamer.php b/www-ssl/nonpublic/schichtplan_beamer.php
index 2e4e78c2..269660e1 100644
--- a/www-ssl/nonpublic/schichtplan_beamer.php
+++ b/www-ssl/nonpublic/schichtplan_beamer.php
@@ -1,9 +1,11 @@
 <?php
-  include "../../../camp2011/includes/header_start.php";
-  include "../../../camp2011/includes/funktionen.php";
-  include "../../../camp2011/includes/funktion_schichtplan_beamer.php";
+require_once ('../bootstrap.php');
 
-  $Time = time() + 3600 + 3600;
+include "includes/header_start.php";
+include "includes/funktionen.php";
+include "includes/funktion_schichtplan_beamer.php";
+
+$Time = time() + 3600 + 3600;
 ?>
 
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
@@ -16,7 +18,9 @@
 <body>
 
 <?php
-  echo "<table border=\"1\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\" frame=\"void\">\n";
+
+
+echo "<table border=\"1\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\" frame=\"void\">\n";
 
 echo "<colgroup span=\"4\" valign=\"center\">
   <col width=\"30\">
@@ -25,27 +29,27 @@ echo "<colgroup span=\"4\" valign=\"center\">
   <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 "<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;
 }
 ?>
 
diff --git a/www-ssl/nonpublic/waeckliste.php b/www-ssl/nonpublic/waeckliste.php
index bb9a0668..d98dd455 100644
--- a/www-ssl/nonpublic/waeckliste.php
+++ b/www-ssl/nonpublic/waeckliste.php
@@ -1,8 +1,10 @@
 <?php
-  $title = "Himmel";
-  $header = "Weckdienst - Liste der zu weckenden Engel";
+require_once ('../bootstrap.php');
 
-  include "../../../camp2011/includes/header.php";
+$title = "Himmel";
+$header = "Weckdienst - Liste der zu weckenden Engel";
+
+include "includes/header.php";
 ?>
 
 <p><?php echo Get_Text("Hello") . $_SESSION['Nick'] . ",<br />\n" . Get_Text("pub_waeckliste_Text1"); ?></p>
@@ -15,12 +17,14 @@
   </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);
+
+$sql = "SELECT * FROM `Wecken` ORDER BY `Date` ASC";
+$Erg = mysql_query($sql, $con);
+$count = mysql_num_rows($Erg);
+
+for ($i = 0; $i < $count; $i++) {
+	$row = mysql_fetch_row($Erg);
 ?>
   <tr class="content">
     <td align="left"><?php echo UID2Nick(mysql_result($Erg, $i, "UID")); ?> </td>
@@ -29,10 +33,14 @@
     <td align="left"><?php echo mysql_result($Erg, $i, "Bemerkung"); ?> </td>
   </tr>
 <?php
-  }
+
+
+}
 ?>
 </table>
 
 <?php
-  include "../../../camp2011/includes/footer.php";
+
+
+include "includes/footer.php";
 ?>
diff --git a/www-ssl/nonpublic/wecken.php b/www-ssl/nonpublic/wecken.php
index 164a4bb0..0d44b48d 100644
--- a/www-ssl/nonpublic/wecken.php
+++ b/www-ssl/nonpublic/wecken.php
@@ -1,32 +1,34 @@
 <?php
-  $title = "Himmel";
-  $header = "Weckdienst";
+require_once ('../bootstrap.php');
 
-  include "../../../camp2011/includes/header.php";
+$title = "Himmel";
+$header = "Weckdienst";
 
-  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);
+include "includes/header.php";
 
-      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);
 
-  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 ($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");
+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");
 ?>
 
 <table border="0" width="100%" class="border" cellpadding="2" cellspacing="1">
@@ -38,12 +40,13 @@
         </tr>
 
 <?php
-  $sql = "SELECT * FROM `Wecken` WHERE `UID`='" . $_SESSION['UID'] . "' ORDER BY `Date` ASC";
-  $Erg = mysql_query($sql, $con);
-  $count = mysql_num_rows($Erg);
 
-  for ($i=0; $i < $count; $i++) {
-    $row = mysql_fetch_row($Erg);
+$sql = "SELECT * FROM `Wecken` WHERE `UID`='" . $_SESSION['UID'] . "' ORDER BY `Date` ASC";
+$Erg = mysql_query($sql, $con);
+$count = mysql_num_rows($Erg);
+
+for ($i = 0; $i < $count; $i++) {
+	$row = mysql_fetch_row($Erg);
 ?>
   <tr class="content">
     <td align="left"><?php echo mysql_result($Erg, $i, "Date"); ?> </td>
@@ -52,7 +55,8 @@
     <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 />
@@ -77,5 +81,6 @@
 <input type="submit" name="eintragen" value="<?php echo Get_Text("pub_wake_bouton"); ?>" />
 </form>
 <?php
-include ("../../../camp2011/includes/footer.php");
+
+include ("includes/footer.php");
 ?>
-- 
cgit v1.2.3-70-g09d2