summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-06-01 14:48:31 +0200
committerPhilip Häusler <msquare@notrademark.de>2011-06-01 14:48:31 +0200
commita537f4bf73101c467af3b01db32fcdb9fd0a91ce (patch)
tree0bf673d0e206866b470cf137d00a158f5fa76441
parent6ebee2c46ba11ce42e85b830189346b13514d497 (diff)
bootstrapping
-rw-r--r--www-ssl/admin/news.php15
-rw-r--r--www-ssl/css/base.css2
-rw-r--r--www-ssl/makeuser.php391
-rw-r--r--www-ssl/nonpublic/auth.php59
-rw-r--r--www-ssl/nonpublic/einstellungen.php457
-rw-r--r--www-ssl/nonpublic/engelbesprechung.php40
-rw-r--r--www-ssl/nonpublic/faq.php72
-rw-r--r--www-ssl/nonpublic/messages.php242
-rw-r--r--www-ssl/nonpublic/myschichtplan.php329
-rw-r--r--www-ssl/nonpublic/myschichtplan_ical.php63
-rw-r--r--www-ssl/nonpublic/news_comments.php87
-rw-r--r--www-ssl/nonpublic/schichtplan.1.php27
-rw-r--r--www-ssl/nonpublic/schichtplan.2.php28
-rw-r--r--www-ssl/nonpublic/schichtplan.php360
-rw-r--r--www-ssl/nonpublic/schichtplan_add.php221
-rw-r--r--www-ssl/nonpublic/schichtplan_beamer.php56
-rw-r--r--www-ssl/nonpublic/waeckliste.php28
-rw-r--r--www-ssl/nonpublic/wecken.php65
18 files changed, 1292 insertions, 1250 deletions
diff --git a/www-ssl/admin/news.php b/www-ssl/admin/news.php
index f25eab93..b6d9dc69 100644
--- a/www-ssl/admin/news.php
+++ b/www-ssl/admin/news.php
@@ -1,9 +1,10 @@
<?php
+require_once('../bootstrap.php');
$title = "Newsverwaltung";
$header = "Verwaltung der News";
-include ("../../../camp2011/includes/header.php");
-include ("../../../camp2011/includes/funktion_db_list.php");
+include ("includes/header.php");
+include ("includes/funktion_db_list.php");
if (!IsSet($_GET["action"]))
@@ -85,7 +86,7 @@ else
echo "FEHLER: Eintrag \"". $_GET["date"]. "\" nicht gefunden";
}
else
- echo "Fehler: \"date\" nicht übergeben";
+ echo "Fehler: \"date\" nicht �bergeben";
break;
case 'change_save':
@@ -93,20 +94,20 @@ else
$chsql="UPDATE `News` SET `Betreff`='". $_GET["eBetreff"]. "', `Text`='". $_GET["eText"].
"', `Treffen`='". $_GET["eTreffen"]. "' WHERE (`Datum`='". $_GET["date"]. "') limit 1";
else
- echo "Fehler: nicht genügend parameter übergeben";
+ echo "Fehler: nicht gen�gend parameter �bergeben";
break;
case 'delete':
if (isset($_POST["date"]))
$chsql="DELETE FROM `News` WHERE `Datum`='". $_POST["date"]. "' LIMIT 1";
else
- echo "Fehler: \"date\" nicht übergeben";
+ echo "Fehler: \"date\" nicht �bergeben";
break;
} //SWITCH
if (IsSet($chsql))
{
- // SQL-Statement ausführen...
+ // SQL-Statement ausf�hren...
$Erg = mysql_query($chsql, $con);
If ($Erg == 1)
echo "&Auml;nderung erfolgreich gesichert...";
@@ -117,6 +118,6 @@ else
}
}// IF-ELSE
-include ("../../../camp2011/includes/footer.php");
+include ("includes/footer.php");
?>
diff --git a/www-ssl/css/base.css b/www-ssl/css/base.css
index b6017ad2..0fe3e5a9 100644
--- a/www-ssl/css/base.css
+++ b/www-ssl/css/base.css
@@ -33,7 +33,7 @@ footer p {
margin: 0 5%;
}
-td {
+td, dt, dd {
padding: 4px;
}
diff --git a/www-ssl/makeuser.php b/www-ssl/makeuser.php
index 785de1e8..a67f4bd5 100644
--- a/www-ssl/makeuser.php
+++ b/www-ssl/makeuser.php
@@ -1,181 +1,214 @@
<?php
- $title = "Anmeldung zum Chaos-Engel";
- $header = "";
- $success = "none";
-
- include "../config/config.php";
- include "../includes/header.php";
- include "../config/config_db.php";
- include "../includes/crypt.php";
-
- if(isset($_POST["send"])) {
- $eNick = trim($_POST["Nick"]);
-
- if($_POST["Alter"] == "")
- $_POST["Alter"] = 0;
-
- // user vorhanden?
- $SQLans = "SELECT UID FROM `User` WHERE `Nick`='" . $_POST["Nick"] . "'";
- $Ergans = mysql_query($SQLans, $con);
-
- if(strlen($_POST["Nick"]) < 2)
- $error = Get_Text("makeuser_error_nick1") . $_POST["Nick"] . Get_Text("makeuser_error_nick2");
- elseif(mysql_num_rows( $Ergans) > 0)
- $error = Get_Text("makeuser_error_nick1") . $_POST["Nick"] . Get_Text("makeuser_error_nick3");
- elseif(strlen($_POST["email"]) <= 6 && strstr($_POST["email"], "@") == FALSE && strstr($_POST["email"], ".") == false)
- $error = Get_Text("makeuser_error_mail");
- elseif(!is_numeric($_POST["Alter"]))
- $error = Get_Text("makeuser_error_Alter");
- elseif($_POST["Passwort"] != $_POST["Passwort2"])
- $error = Get_Text("makeuser_error_password1");
- elseif(strlen($_POST["Passwort"]) < 6)
- $error = Get_Text("makeuser_error_password2");
- else {
- $_POST["Passwort"] = PassCrypt($_POST["Passwort"]);
- unset($_POST["Passwort2"]);
-
- $SQL = "INSERT INTO `User` (".
- "`Nick` , ". "`Name` , ".
- "`Vorname`, ". "`Alter` , ".
- "`Telefon`, ". "`DECT`, ".
- "`Handy`, ". "`email`, ".
- "`ICQ`, ". "`jabber`, ".
- "`Size`, ". "`Passwort`, ".
- "`Art` , ". "`kommentar`, ".
- "`Hometown`,". "`CreateDate` ) ".
- "VALUES ( ".
- "'". $_POST["Nick"]. "', ". "'". $_POST["Name"]. "', ".
- "'". $_POST["Vorname"]. "', ". "'". $_POST["Alter"]. "', ".
- "'". $_POST["Telefon"]. "', ". "'". $_POST["DECT"]. "', ".
- "'". $_POST["Handy"]. "', ". "'". $_POST["email"]. "', ".
- "'". $_POST["ICQ"]. "', ". "'". $_POST["jabber"]. "', ".
- "'". $_POST["Size"]. "', ". "'". $_POST["Passwort"]. "', ".
- "'". $_POST["Art"]. "', ". "'". $_POST["kommentar"]. "', ".
- "'". $_POST["Hometown"]. "',". "NOW());";
- $Erg = mysql_query($SQL, $con);
-
- if ($Erg != 1) {
- echo Get_Text("makeuser_error_write1") . "<br />\n";
- $error = mysql_error($con);
- } else {
- echo "<p class=\"important\">" . Get_Text("makeuser_writeOK") . "\n";
-
- $SQL2 = "SELECT `UID` FROM `User` WHERE `Nick`='" . $_POST["Nick"] . "';";
- $Erg2 = mysql_query($SQL2, $con);
- $Data = mysql_fetch_array($Erg2);
-
- $SQL3 = "INSERT INTO `UserCVS` (`UID`) VALUES ('" . $Data["UID"] . "');";
- $Erg3 = mysql_query($SQL3, $con);
-
- if ($Erg3 != 1) {
- echo "<h1>". Get_Text("makeuser_error_write2"). "<br />\n";
- $error = mysql_error($con);
- } else {
- echo Get_Text("makeuser_writeOK2") . "<br />\n";
- echo "<h1>" . Get_Text("makeuser_writeOK3") . "</h1>\n";
- }
-
- echo Get_Text("makeuser_writeOK4") . "</p><p></p>\n<br /><br />\n";
- $success = "any";
-
- if (isset($SubscribeMailinglist)) {
- if ($_POST["subscribe-mailinglist"] == "") {
- $headers = "From: " . $_POST["email"] . "\r\n" .
- "X-Mailer: PHP/" . phpversion();
- mail($SubscribeMailinglist, "subject", "message", $headers);
- }
- }
- }
- }
-
- if(isset($error))
- echo "<p class=\"warning\">\n" . $error . "\n</p>\n\n";
- } else {
- // init vars
- $_POST["Nick"] = "";
- $_POST["Name"] = "";
- $_POST["Vorname"] = "";
- $_POST["Alter"] = "";
- $_POST["Telefon"] = "";
- $_POST["DECT"] = "";
- $_POST["Handy"] = "";
- $_POST["email"] = "";
- $_POST["subscribe-mailinglist"] = "";
- $_POST["ICQ"] = "";
- $_POST["jabber"] = "";
- $_POST["Size"] = "L";
- $_POST["Art"] = "";
- $_POST["kommentar"] = "";
- $_POST["Hometown"] = "";
- }
-
- if($success == "none") {
- echo "<h1>" . Get_Text("makeuser_text0") . "</h1>\n";
- echo "<h2>" . Get_Text("makeuser_text1") . "</h2>\n";
- echo "<form action=\"\" method=\"post\">\n";
- echo "<table>\n";
- echo "<tr><td>" . Get_Text("makeuser_Nickname") . "*</td><td><input type=\"text\" size=\"40\" name=\"Nick\" value=\"" . $_POST["Nick"] . "\" /></td></tr>\n";
- echo "<tr><td>" . Get_Text("makeuser_Nachname") . "</td><td><input type=\"text\" size=\"40\" name=\"Name\" value=\"" . $_POST["Name"] . "\" /></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Vorname") . "</td><td><input type=\"text\" size=\"40\" name=\"Vorname\" value=\"" . $_POST["Vorname"] . "\" /></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Alter") . "</td><td><input type=\"text\" size=\"40\" name=\"Alter\" value=\"". $_POST["Alter"]. "\"></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Telefon"). "</td><td><input type=\"text\" size=\"40\" name=\"Telefon\" value=\"". $_POST["Telefon"]. "\"></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_DECT"). "</td><td><input type=\"text\" size=\"40\" name=\"DECT\" value=\"". $_POST["DECT"]. "\"></td><td>\n";
- echo "<!--a href=\"https://21c3.ccc.de/wiki/index.php/POC\"><img src=\"./pic/external.png\" alt=\"external: \">DECT</a--></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Handy"). "</td><td><input type=\"text\" size=\"40\" name=\"Handy\" value=\"". $_POST["Handy"]. "\"></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_E-Mail"). "*</td><td><input type=\"text\" size=\"40\" name=\"email\" value=\"". $_POST["email"]. "\"></td></tr>\n";
-
- if(isset($SubscribeMailinglist))
- echo "<tr><td>". Get_Text("makeuser_subscribe-mailinglist"). "</td><td><input type=\"checkbox\" name=\"subscribe-mailinglist\" value=\"". $_POST["subscribe-mailinglist"]. "\">($SubscribeMailinglist)</td></tr>\n";
-
- echo "<tr><td>ICQ</td><td><input type=\"text\" size=\"40\" name=\"ICQ\" value=\"". $_POST["ICQ"]. "\"></td></tr>\n";
- echo "<tr><td>jabber</td><td><input type=\"text\" size=\"40\" name=\"jabber\" value=\"". $_POST["jabber"]. "\"></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_T-Shirt"). " Gr&ouml;sse*</td><td align=\"left\">\n";
- echo "<select name=\"Size\">\n";
- echo "<option value=\"S\""; if ($_POST["Size"]=="S") echo " selected"; echo ">S</option>\n";
- echo "<option value=\"M\""; if ($_POST["Size"]=="M") echo " selected"; echo ">M</option>\n";
- echo "<option value=\"L\""; if ($_POST["Size"]=="L") echo " selected"; echo ">L</option>\n";
- echo "<option value=\"XL\""; if ($_POST["Size"]=="XL") echo " selected"; echo ">XL</option>\n";
- echo "<option value=\"2XL\""; if ($_POST["Size"]=="2XL") echo " selected"; echo ">2XL</option>\n";
- echo "<option value=\"3XL\""; if ($_POST["Size"]=="3XL") echo " selected"; echo ">3XL</option>\n";
- echo "<option value=\"4XL\""; if ($_POST["Size"]=="4XL") echo " selected"; echo ">4XL</option>\n";
- echo "<option value=\"5XL\""; if ($_POST["Size"]=="5XL") echo " selected"; echo ">5XL</option>\n";
- echo "<option value=\"S-G\""; if ($_POST["Size"]=="S-G") echo " selected"; echo ">S Girl</option>\n";
- echo "<option value=\"M-G\""; if ($_POST["Size"]=="M-G") echo " selected"; echo ">M Girl</option>\n";
- echo "<option value=\"L-G\""; if ($_POST["Size"]=="L-G") echo " selected"; echo ">L Girl</option>\n";
- echo "<option value=\"XL-G\""; if ($_POST["Size"]=="XL-G") echo " selected"; echo ">XL Girl</option>\n";
- echo "</select>\n";
- echo "</td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Engelart"). "</td><td align=\"left\">\n";
- echo "<select name=\"Art\">\n";
-
- $Sql = "SELECT * FROM `EngelType` ORDER BY `NAME`";
- $Erg = mysql_query($Sql, $con);
-
- for($t = 0; $t < mysql_num_rows($Erg); $t++) {
- $Name = mysql_result($Erg, $t, "Name"). Get_Text("inc_schicht_engel");
- echo "<option value=\"" . $Name . "\"";
-
- if($_POST["Art"]==$Name)
- echo " selected";
-
- echo ">$Name</option>\n";
- }
-
- echo "</select>\n";
- echo "</td>\n";
- echo "</tr>\n";
- echo "<tr>\n";
- echo "<td>". Get_Text("makeuser_text2"). "</td>\n";
- echo "<td><textarea rows=\"5\" cols=\"40\" name=\"kommentar\">". $_POST["kommentar"]. "</textarea></td>\n";
- echo "</tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Hometown"). "</td><td><input type=\"text\" size=\"40\" name=\"Hometown\" value=\"". $_POST["Hometown"]. "\"></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Passwort"). "*</td><td><input type=\"password\" size=\"40\" name=\"Passwort\"/></td></tr>\n";
- echo "<tr><td>". Get_Text("makeuser_Passwort2"). "*</td><td><input type=\"password\" size=\"40\" name=\"Passwort2\"/></td></tr>\n";
- echo "<tr><td>&nbsp;</td><td><input type=\"submit\" name=\"send\" value=\"". Get_Text("makeuser_Anmelden"). "\"/></td></tr>\n";
- echo "</table>\n";
- echo "</form>\n";
- Print_Text("makeuser_text3");
- }
-
- include "../includes/footer.php";
+require_once ('bootstrap.php');
+
+$title = "Anmeldung zum Chaos-Engel";
+$header = "";
+$success = "none";
+
+include "config/config.php";
+include "includes/header.php";
+include "config/config_db.php";
+include "includes/crypt.php";
+
+if (isset ($_POST["send"])) {
+ $eNick = trim($_POST["Nick"]);
+
+ if ($_POST["Alter"] == "")
+ $_POST["Alter"] = 0;
+
+ // user vorhanden?
+ $SQLans = "SELECT UID FROM `User` WHERE `Nick`='" . $_POST["Nick"] . "'";
+ $Ergans = mysql_query($SQLans, $con);
+
+ if (strlen($_POST["Nick"]) < 2)
+ $error = Get_Text("makeuser_error_nick1") . $_POST["Nick"] . Get_Text("makeuser_error_nick2");
+ elseif (mysql_num_rows($Ergans) > 0) $error = Get_Text("makeuser_error_nick1") . $_POST["Nick"] . Get_Text("makeuser_error_nick3");
+ elseif (strlen($_POST["email"]) <= 6 && strstr($_POST["email"], "@") == FALSE && strstr($_POST["email"], ".") == false) $error = Get_Text("makeuser_error_mail");
+ elseif (!is_numeric($_POST["Alter"])) $error = Get_Text("makeuser_error_Alter");
+ elseif ($_POST["Passwort"] != $_POST["Passwort2"]) $error = Get_Text("makeuser_error_password1");
+ elseif (strlen($_POST["Passwort"]) < 6) $error = Get_Text("makeuser_error_password2");
+ else {
+ $_POST["Passwort"] = PassCrypt($_POST["Passwort"]);
+ unset ($_POST["Passwort2"]);
+
+ $SQL = "INSERT INTO `User` (" .
+ "`Nick` , " . "`Name` , " .
+ "`Vorname`, " . "`Alter` , " .
+ "`Telefon`, " . "`DECT`, " .
+ "`Handy`, " . "`email`, " .
+ "`ICQ`, " . "`jabber`, " .
+ "`Size`, " . "`Passwort`, " .
+ "`Art` , " . "`kommentar`, " .
+ "`Hometown`," . "`CreateDate` ) " .
+ "VALUES ( " .
+ "'" . $_POST["Nick"] . "', " . "'" . $_POST["Name"] . "', " .
+ "'" . $_POST["Vorname"] . "', " . "'" . $_POST["Alter"] . "', " .
+ "'" . $_POST["Telefon"] . "', " . "'" . $_POST["DECT"] . "', " .
+ "'" . $_POST["Handy"] . "', " . "'" . $_POST["email"] . "', " .
+ "'" . $_POST["ICQ"] . "', " . "'" . $_POST["jabber"] . "', " .
+ "'" . $_POST["Size"] . "', " . "'" . $_POST["Passwort"] . "', " .
+ "'" . $_POST["Art"] . "', " . "'" . $_POST["kommentar"] . "', " .
+ "'" . $_POST["Hometown"] . "'," . "NOW());";
+ $Erg = mysql_query($SQL, $con);
+
+ if ($Erg != 1) {
+ echo Get_Text("makeuser_error_write1") . "<br />\n";
+ $error = mysql_error($con);
+ } else {
+ echo "<p class=\"important\">" . Get_Text("makeuser_writeOK") . "\n";
+
+ $SQL2 = "SELECT `UID` FROM `User` WHERE `Nick`='" . $_POST["Nick"] . "';";
+ $Erg2 = mysql_query($SQL2, $con);
+ $Data = mysql_fetch_array($Erg2);
+
+ $SQL3 = "INSERT INTO `UserCVS` (`UID`) VALUES ('" . $Data["UID"] . "');";
+ $Erg3 = mysql_query($SQL3, $con);
+
+ if ($Erg3 != 1) {
+ echo "<h1>" . Get_Text("makeuser_error_write2") . "<br />\n";
+ $error = mysql_error($con);
+ } else {
+ echo Get_Text("makeuser_writeOK2") . "<br />\n";
+ echo "<h1>" . Get_Text("makeuser_writeOK3") . "</h1>\n";
+ }
+
+ echo Get_Text("makeuser_writeOK4") . "</p><p></p>\n<br /><br />\n";
+ $success = "any";
+
+ if (isset ($SubscribeMailinglist)) {
+ if ($_POST["subscribe-mailinglist"] == "") {
+ $headers = "From: " . $_POST["email"] . "\r\n" .
+ "X-Mailer: PHP/" . phpversion();
+ mail($SubscribeMailinglist, "subject", "message", $headers);
+ }
+ }
+ }
+ }
+
+ if (isset ($error))
+ echo "<p class=\"warning\">\n" . $error . "\n</p>\n\n";
+} else {
+ // init vars
+ $_POST["Nick"] = "";
+ $_POST["Name"] = "";
+ $_POST["Vorname"] = "";
+ $_POST["Alter"] = "";
+ $_POST["Telefon"] = "";
+ $_POST["DECT"] = "";
+ $_POST["Handy"] = "";
+ $_POST["email"] = "";
+ $_POST["subscribe-mailinglist"] = "";
+ $_POST["ICQ"] = "";
+ $_POST["jabber"] = "";
+ $_POST["Size"] = "L";
+ $_POST["Art"] = "";
+ $_POST["kommentar"] = "";
+ $_POST["Hometown"] = "";
+}
+
+if ($success == "none") {
+ echo "<h1>" . Get_Text("makeuser_text0") . "</h1>\n";
+ echo "<h2>" . Get_Text("makeuser_text1") . "</h2>\n";
+ echo "<form action=\"\" method=\"post\">\n";
+ echo "<table>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Nickname") . "*</td><td><input type=\"text\" size=\"40\" name=\"Nick\" value=\"" . $_POST["Nick"] . "\" /></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Nachname") . "</td><td><input type=\"text\" size=\"40\" name=\"Name\" value=\"" . $_POST["Name"] . "\" /></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Vorname") . "</td><td><input type=\"text\" size=\"40\" name=\"Vorname\" value=\"" . $_POST["Vorname"] . "\" /></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Alter") . "</td><td><input type=\"text\" size=\"40\" name=\"Alter\" value=\"" . $_POST["Alter"] . "\"></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Telefon") . "</td><td><input type=\"text\" size=\"40\" name=\"Telefon\" value=\"" . $_POST["Telefon"] . "\"></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_DECT") . "</td><td><input type=\"text\" size=\"40\" name=\"DECT\" value=\"" . $_POST["DECT"] . "\"></td><td>\n";
+ echo "<!--a href=\"https://21c3.ccc.de/wiki/index.php/POC\"><img src=\"./pic/external.png\" alt=\"external: \">DECT</a--></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Handy") . "</td><td><input type=\"text\" size=\"40\" name=\"Handy\" value=\"" . $_POST["Handy"] . "\"></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_E-Mail") . "*</td><td><input type=\"text\" size=\"40\" name=\"email\" value=\"" . $_POST["email"] . "\"></td></tr>\n";
+
+ if (isset ($SubscribeMailinglist))
+ echo "<tr><td>" . Get_Text("makeuser_subscribe-mailinglist") . "</td><td><input type=\"checkbox\" name=\"subscribe-mailinglist\" value=\"" . $_POST["subscribe-mailinglist"] . "\">($SubscribeMailinglist)</td></tr>\n";
+
+ echo "<tr><td>ICQ</td><td><input type=\"text\" size=\"40\" name=\"ICQ\" value=\"" . $_POST["ICQ"] . "\"></td></tr>\n";
+ echo "<tr><td>jabber</td><td><input type=\"text\" size=\"40\" name=\"jabber\" value=\"" . $_POST["jabber"] . "\"></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_T-Shirt") . " Gr&ouml;sse*</td><td align=\"left\">\n";
+ echo "<select name=\"Size\">\n";
+ echo "<option value=\"S\"";
+ if ($_POST["Size"] == "S")
+ echo " selected";
+ echo ">S</option>\n";
+ echo "<option value=\"M\"";
+ if ($_POST["Size"] == "M")
+ echo " selected";
+ echo ">M</option>\n";
+ echo "<option value=\"L\"";
+ if ($_POST["Size"] == "L")
+ echo " selected";
+ echo ">L</option>\n";
+ echo "<option value=\"XL\"";
+ if ($_POST["Size"] == "XL")
+ echo " selected";
+ echo ">XL</option>\n";
+ echo "<option value=\"2XL\"";
+ if ($_POST["Size"] == "2XL")
+ echo " selected";
+ echo ">2XL</option>\n";
+ echo "<option value=\"3XL\"";
+ if ($_POST["Size"] == "3XL")
+ echo " selected";
+ echo ">3XL</option>\n";
+ echo "<option value=\"4XL\"";
+ if ($_POST["Size"] == "4XL")
+ echo " selected";
+ echo ">4XL</option>\n";
+ echo "<option value=\"5XL\"";
+ if ($_POST["Size"] == "5XL")
+ echo " selected";
+ echo ">5XL</option>\n";
+ echo "<option value=\"S-G\"";
+ if ($_POST["Size"] == "S-G")
+ echo " selected";
+ echo ">S Girl</option>\n";
+ echo "<option value=\"M-G\"";
+ if ($_POST["Size"] == "M-G")
+ echo " selected";
+ echo ">M Girl</option>\n";
+ echo "<option value=\"L-G\"";
+ if ($_POST["Size"] == "L-G")
+ echo " selected";
+ echo ">L Girl</option>\n";
+ echo "<option value=\"XL-G\"";
+ if ($_POST["Size"] == "XL-G")
+ echo " selected";
+ echo ">XL Girl</option>\n";
+ echo "</select>\n";
+ echo "</td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Engelart") . "</td><td align=\"left\">\n";
+ echo "<select name=\"Art\">\n";
+
+ $Sql = "SELECT * FROM `EngelType` ORDER BY `NAME`";
+ $Erg = mysql_query($Sql, $con);
+
+ for ($t = 0; $t < mysql_num_rows($Erg); $t++) {
+ $Name = mysql_result($Erg, $t, "Name") . Get_Text("inc_schicht_engel");
+ echo "<option value=\"" . $Name . "\"";
+
+ if ($_POST["Art"] == $Name)
+ echo " selected";
+
+ echo ">$Name</option>\n";
+ }
+
+ echo "</select>\n";
+ echo "</td>\n";
+ echo "</tr>\n";
+ echo "<tr>\n";
+ echo "<td>" . Get_Text("makeuser_text2") . "</td>\n";
+ echo "<td><textarea rows=\"5\" cols=\"40\" name=\"kommentar\">" . $_POST["kommentar"] . "</textarea></td>\n";
+ echo "</tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Hometown") . "</td><td><input type=\"text\" size=\"40\" name=\"Hometown\" value=\"" . $_POST["Hometown"] . "\"></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Passwort") . "*</td><td><input type=\"password\" size=\"40\" name=\"Passwort\"/></td></tr>\n";
+ echo "<tr><td>" . Get_Text("makeuser_Passwort2") . "*</td><td><input type=\"password\" size=\"40\" name=\"Passwort2\"/></td></tr>\n";
+ echo "<tr><td>&nbsp;</td><td><input type=\"submit\" name=\"send\" value=\"" . Get_Text("makeuser_Anmelden") . "\"/></td></tr>\n";
+ echo "</table>\n";
+ echo "</form>\n";
+ Print_Text("makeuser_text3");
+}
+
+include "includes/footer.php";
?>
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");
?>