From 75448045cfe70054c8f4bae1bcfaf9bb0f70d330 Mon Sep 17 00:00:00 2001 From: Moritz helios Rudert Date: Wed, 1 Jun 2011 12:13:39 +0200 Subject: fixes --- www-ssl/admin/EngelType.php | 290 ++++++++-------- www-ssl/admin/Recentchanges.php | 14 +- www-ssl/admin/UserPicture.php | 226 ++++++------- www-ssl/admin/aktiv.php | 106 +++--- www-ssl/admin/dbUpdateFromXLS.php | 406 +++++++++++----------- www-ssl/admin/debug.php | 42 +-- www-ssl/admin/dect.php | 86 ++--- www-ssl/admin/dect_call.php | 2 +- www-ssl/admin/faq.1.php | 2 +- www-ssl/admin/faq.php | 362 ++++++++++---------- www-ssl/admin/free.php | 68 ++-- www-ssl/admin/free_DECT.php | 68 ++-- www-ssl/admin/group.php | 70 ++-- www-ssl/admin/index.php | 8 +- www-ssl/admin/news.php | 188 +++++------ www-ssl/admin/room.php | 320 +++++++++--------- www-ssl/admin/schichtplan.1.php | 0 www-ssl/admin/schichtplan.php | 620 +++++++++++++++++----------------- www-ssl/admin/schichtplan_druck.1.php | 0 www-ssl/admin/schichtplan_druck.php | 148 ++++---- www-ssl/admin/shiftadd.php | 518 ++++++++++++++-------------- www-ssl/admin/sprache.php | 198 +++++------ www-ssl/admin/tshirt.php | 30 +- www-ssl/admin/user.php | 240 ++++++------- www-ssl/admin/userArrived.php | 38 +-- www-ssl/admin/userChangeNormal.php | 226 ++++++------- www-ssl/admin/userChangeSecure.php | 178 +++++----- www-ssl/admin/userDefaultSetting.php | 164 ++++----- www-ssl/admin/userSaveNormal.php | 210 ++++++------ www-ssl/admin/userSaveSecure.php | 298 ++++++++-------- 30 files changed, 2563 insertions(+), 2563 deletions(-) mode change 100755 => 100644 www-ssl/admin/EngelType.php mode change 100755 => 100644 www-ssl/admin/Recentchanges.php mode change 100755 => 100644 www-ssl/admin/UserPicture.php mode change 100755 => 100644 www-ssl/admin/aktiv.php mode change 100755 => 100644 www-ssl/admin/dbUpdateFromXLS.php mode change 100755 => 100644 www-ssl/admin/debug.php mode change 100755 => 100644 www-ssl/admin/dect.php mode change 100755 => 100644 www-ssl/admin/dect_call.php mode change 100755 => 100644 www-ssl/admin/faq.1.php mode change 100755 => 100644 www-ssl/admin/faq.php mode change 100755 => 100644 www-ssl/admin/free.php mode change 100755 => 100644 www-ssl/admin/free_DECT.php mode change 100755 => 100644 www-ssl/admin/group.php mode change 100755 => 100644 www-ssl/admin/index.php mode change 100755 => 100644 www-ssl/admin/news.php mode change 100755 => 100644 www-ssl/admin/room.php mode change 100755 => 100644 www-ssl/admin/schichtplan.1.php mode change 100755 => 100644 www-ssl/admin/schichtplan.php mode change 100755 => 100644 www-ssl/admin/schichtplan_druck.1.php mode change 100755 => 100644 www-ssl/admin/schichtplan_druck.php mode change 100755 => 100644 www-ssl/admin/shiftadd.php mode change 100755 => 100644 www-ssl/admin/sprache.php mode change 100755 => 100644 www-ssl/admin/tshirt.php mode change 100755 => 100644 www-ssl/admin/user.php mode change 100755 => 100644 www-ssl/admin/userArrived.php mode change 100755 => 100644 www-ssl/admin/userChangeNormal.php mode change 100755 => 100644 www-ssl/admin/userChangeSecure.php mode change 100755 => 100644 www-ssl/admin/userDefaultSetting.php mode change 100755 => 100644 www-ssl/admin/userSaveNormal.php mode change 100755 => 100644 www-ssl/admin/userSaveSecure.php (limited to 'www-ssl/admin') diff --git a/www-ssl/admin/EngelType.php b/www-ssl/admin/EngelType.php old mode 100755 new mode 100644 index 6d640ae4..1aec80dc --- a/www-ssl/admin/EngelType.php +++ b/www-ssl/admin/EngelType.php @@ -6,42 +6,42 @@ include("../../../camp2011/includes/funktion_db.php"); function runSQL( $SQL) { - global $con; - // hier muesste das SQL ausgefuehrt werden... - $Erg = mysql_query($SQL, $con); - if ($Erg) - { - echo "Änderung wurde gesichert...
"; - echo "[$SQL]
"; - return 1; - } - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

".mysql_error( $con ). "
"; - echo "[$SQL]
"; - return 0; - } + global $con; + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($SQL, $con); + if ($Erg) + { + echo "Änderung wurde gesichert...
"; + echo "[$SQL]
"; + return 1; + } + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

".mysql_error( $con ). "
"; + echo "[$SQL]
"; + return 0; + } } function runSQL_log( $SQL, $commed) { - global $con; - // hier muesste das SQL ausgefuehrt werden... - $Erg = db_query($SQL, $commed); - if ($Erg) - { - echo "Änderung wurde gesichert...
"; - echo "[$SQL]
"; - return 1; - } - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

".mysql_error( $con ). "
"; - echo "[$SQL]
"; - return 0; - } + global $con; + // hier muesste das SQL ausgefuehrt werden... + $Erg = db_query($SQL, $commed); + if ($Erg) + { + echo "Änderung wurde gesichert...
"; + echo "[$SQL]
"; + return 1; + } + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

".mysql_error( $con ). "
"; + echo "[$SQL]
"; + return 0; + } } @@ -51,33 +51,33 @@ $Erg = mysql_query($Sql, $con); if( !IsSet($_GET["action"]) ) { - echo "Hallo ".$_SESSION['Nick']. - ",
\nhier hast du die Möglichkeit, neue Engeltypen für die Schichtpläne einzutragen ". - "oder vorhandene abzuändern:

\n"; - - echo "- Neuen EngelType eintragen
\n"; - - echo "\n"; - echo "\n"; - - for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) - { - echo "\t"; - } - echo "\t"; - echo ""; - - for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) - { - echo "\t\n"; - for ($j = 1; $j < mysql_num_fields($Erg); $j++) - { - echo "\t\t\n"; - } - echo "\t\t\n"; - echo "\t\n"; - } // ende Auflistung Raeume - echo "
". mysql_field_name($Erg, $i). "Ändern
".mysql_result($Erg, $t, $j)."###
"; + echo "Hallo ".$_SESSION['Nick']. + ",
\nhier hast du die Möglichkeit, neue Engeltypen für die Schichtpläne einzutragen ". + "oder vorhandene abzuändern:

\n"; + + echo "- Neuen EngelType eintragen
\n"; + + echo "\n"; + echo "\n"; + + for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) + { + echo "\t"; + } + echo "\t"; + echo ""; + + for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) + { + echo "\t\n"; + for ($j = 1; $j < mysql_num_fields($Erg); $j++) + { + echo "\t\t\n"; + } + echo "\t\t\n"; + echo "\t\n"; + } // ende Auflistung Raeume + echo "
". mysql_field_name($Erg, $i). "Ändern
".mysql_result($Erg, $t, $j)."###
"; } else { @@ -85,105 +85,105 @@ else switch ($_GET["action"]) { case 'new': - echo "Neuen EngelType einrichten:
"; - echo "
\n"; - echo "\n"; - - for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) - { - echo "". - "\n"; - } - echo "
".mysql_field_name($Erg, $Uj)."
\n"; - echo "\n"; - echo "\n"; - echo "
"; - break; + echo "Neuen EngelType einrichten:
"; + echo "
\n"; + echo "\n"; + + for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) + { + echo "". + "\n"; + } + echo "
".mysql_field_name($Erg, $Uj)."
\n"; + echo "\n"; + echo "\n"; + echo "
"; + break; case 'newsave': - $vars = $_GET; - $count = count($vars) - 1; - $vars = array_splice($vars, 0, $count); - $Keys=""; - $Values=""; - foreach($vars as $key => $value){ - $Keys .= ", `$key`"; - $Values .= ", '$value'"; - } - - if( runSQL_log( "INSERT INTO `EngelType` (". substr($Keys, 2). ") VALUES (". substr($Values, 2). ")", - "save new EngelType") ) - { - SetHeaderGo2Back(); - - $SQL2 = "SELECT * FROM `EngelType` WHERE `Name`='". $_GET["Name"]. "'"; - $ERG = mysql_query($SQL2, $con); - - if( mysql_num_rows($ERG) == 1) - runSQL_log( "ALTER TABLE `Room` ADD `DEFAULT_EID_". mysql_result( $ERG, 0, 0). - "` INT DEFAULT '0' NOT NULL;", - "add new EngelType in Romm Table"); - } - break; + $vars = $_GET; + $count = count($vars) - 1; + $vars = array_splice($vars, 0, $count); + $Keys=""; + $Values=""; + foreach($vars as $key => $value){ + $Keys .= ", `$key`"; + $Values .= ", '$value'"; + } + + if( runSQL_log( "INSERT INTO `EngelType` (". substr($Keys, 2). ") VALUES (". substr($Values, 2). ")", + "save new EngelType") ) + { + SetHeaderGo2Back(); + + $SQL2 = "SELECT * FROM `EngelType` WHERE `Name`='". $_GET["Name"]. "'"; + $ERG = mysql_query($SQL2, $con); + + if( mysql_num_rows($ERG) == 1) + runSQL_log( "ALTER TABLE `Room` ADD `DEFAULT_EID_". mysql_result( $ERG, 0, 0). + "` INT DEFAULT '0' NOT NULL;", + "add new EngelType in Romm Table"); + } + break; case 'change': - if (! IsSet($_GET["TID"])) - echo "Fehlerhafter Aufruf!"; - else - { - echo "Raum abändern:\n"; - echo "Hier kannst du eintragen, den EngelType ändern."; - echo "
\n"; - echo "\n"; - - $SQL2 = "SELECT * FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'"; - $ERG = mysql_query($SQL2, $con); + if (! IsSet($_GET["TID"])) + echo "Fehlerhafter Aufruf!"; + else + { + echo "Raum abändern:\n"; + echo "Hier kannst du eintragen, den EngelType ändern."; + echo "\n"; + echo "
\n"; + + $SQL2 = "SELECT * FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'"; + $ERG = mysql_query($SQL2, $con); - for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) - echo "". - "\n"; - - echo "
". mysql_field_name($ERG, $Uj). "
\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "
"; - echo "
\n"; - echo "\n"; - echo "\n"; - echo ""; - echo "
"; - } - break; - + for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) + echo "". mysql_field_name($ERG, $Uj). "". + "\n"; + + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo ""; + echo "
\n"; + echo "\n"; + echo "\n"; + echo ""; + echo "
"; + } + break; + case 'changesave': $vars = $_GET; $count = count($vars) - 2; $vars = array_splice($vars, 0, $count); - $keys=""; - $sql=""; + $keys=""; + $sql=""; foreach($vars as $key => $value) - { - $keys = substr( $key, 1); - $sql .= ", `". $keys. "`='". $value. "'"; + { + $keys = substr( $key, 1); + $sql .= ", `". $keys. "`='". $value. "'"; } - runSQL_log( "UPDATE `EngelType` SET ". substr($sql, 2). " WHERE `TID`='". $_GET["eTID"]. "'", - "Save Change EngelType"); - SetHeaderGo2Back(); - break; + runSQL_log( "UPDATE `EngelType` SET ". substr($sql, 2). " WHERE `TID`='". $_GET["eTID"]. "'", + "Save Change EngelType"); + SetHeaderGo2Back(); + break; case 'delete': - if (IsSet($_GET["TID"])) - { - if( runSQL_log( "DELETE FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'", "delete EngelType")) - runSQL_log( "ALTER TABLE `Room` DROP `DEFAULT_EID_". $_GET["TID"]. "`;", - "delete EngelType in Room Table"); - } - else - echo "Fehlerhafter Aufruf"; - SetHeaderGo2Back(); - break; + if (IsSet($_GET["TID"])) + { + if( runSQL_log( "DELETE FROM `EngelType` WHERE `TID`='". $_GET["TID"]. "'", "delete EngelType")) + runSQL_log( "ALTER TABLE `Room` DROP `DEFAULT_EID_". $_GET["TID"]. "`;", + "delete EngelType in Room Table"); + } + else + echo "Fehlerhafter Aufruf"; + SetHeaderGo2Back(); + break; } } diff --git a/www-ssl/admin/Recentchanges.php b/www-ssl/admin/Recentchanges.php old mode 100755 new mode 100644 index 38c659dd..6bb8f59d --- a/www-ssl/admin/Recentchanges.php +++ b/www-ssl/admin/Recentchanges.php @@ -1,4 +1,4 @@ -\n\tTime\n\tUser\n\tCommend\n\tSQL Comm for ($n = 0 ; $n < mysql_num_rows($Erg) ; $n++) { - echo "\n"; - echo "\t". mysql_result( $Erg, $n, "Time"). "\n"; - echo "\t". UID2Nick(mysql_result( $Erg, $n, "UID")). displayavatar(mysql_result( $Erg, $n, "UID")). "\n"; - echo "\t". mysql_result( $Erg, $n, "Commend"). "\n"; - echo "\t". mysql_result( $Erg, $n, "SQLCommad"). "\n"; - echo "\n"; + echo "\n"; + echo "\t". mysql_result( $Erg, $n, "Time"). "\n"; + echo "\t". UID2Nick(mysql_result( $Erg, $n, "UID")). displayavatar(mysql_result( $Erg, $n, "UID")). "\n"; + echo "\t". mysql_result( $Erg, $n, "Commend"). "\n"; + echo "\t". mysql_result( $Erg, $n, "SQLCommad"). "\n"; + echo "\n"; } echo "\n"; diff --git a/www-ssl/admin/UserPicture.php b/www-ssl/admin/UserPicture.php old mode 100755 new mode 100644 index 93e75bf1..00716329 --- a/www-ssl/admin/UserPicture.php +++ b/www-ssl/admin/UserPicture.php @@ -7,114 +7,114 @@ include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); if( IsSet($_GET["action"]) ) { - UnSet($SQL); + UnSet($SQL); - switch ($_GET["action"]) - { - case 'FormUpload': - echo "Hier kannst Du ein Foto hochladen för:"; - echo "
\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t(max ". get_cfg_var("post_max_size"). "Byte)
\n"; - echo "\t\n"; - echo "
\n"; - break; - case 'sendPicture': - if( ($_FILES["file"]["size"] > 0) && (isset( $_POST["UID"])) ) - { - 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"]))); + switch ($_GET["action"]) + { + case 'FormUpload': + echo "Hier kannst Du ein Foto hochladen för:"; + echo "
\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t(max ". get_cfg_var("post_max_size"). "Byte)
\n"; + echo "\t\n"; + echo "
\n"; + break; + case 'sendPicture': + if( ($_FILES["file"]["size"] > 0) && (isset( $_POST["UID"])) ) + { + 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( $_POST['UID']) == "") - $SQL = "INSERT INTO `UserPicture` ". - "( `UID`,`Bild`, `ContentType`, `show`) ". - "VALUES ('". $_POST['UID']. "', '$data', '". $_FILES["file"]["type"]. "', 'N')"; - else - $SQL = "UPDATE `UserPicture` SET ". - "`Bild`='$data', ". - "`ContentType`='". $_FILES["file"]["type"]. "' ". - "WHERE `UID`='". $_POST['UID']. "'"; + if( GetPicturShow( $_POST['UID']) == "") + $SQL = "INSERT INTO `UserPicture` ". + "( `UID`,`Bild`, `ContentType`, `show`) ". + "VALUES ('". $_POST['UID']. "', '$data', '". $_FILES["file"]["type"]. "', 'N')"; + else + $SQL = "UPDATE `UserPicture` SET ". + "`Bild`='$data', ". + "`ContentType`='". $_FILES["file"]["type"]. "' ". + "WHERE `UID`='". $_POST['UID']. "'"; - echo "Upload Pictur:'" . $_FILES["file"]["name"] . "', ". - "MIME-Type: " . $_FILES["file"]["type"]. ", ". - $_FILES["file"]["size"]. " Byte ". - "for ". UID2Nick( $_POST["UID"]); - } - else - Print_Text("pub_einstellungen_send_KO"); - } - else - Print_Text("pub_einstellungen_send_KO"); - break; + echo "Upload Pictur:'" . $_FILES["file"]["name"] . "', ". + "MIME-Type: " . $_FILES["file"]["type"]. ", ". + $_FILES["file"]["size"]. " Byte ". + "for ". UID2Nick( $_POST["UID"]); + } + else + Print_Text("pub_einstellungen_send_KO"); + } + else + Print_Text("pub_einstellungen_send_KO"); + break; - case 'SetN': - if (IsSet($_GET["UID"])) - { - echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde gesperrt:
"; - $SQL = "UPDATE `UserPicture` SET `show`='N' WHERE `UID`='". $_GET["UID"]. "'"; - } - else - echo "Fehlerhafter Aufruf"; - break; - case 'SetY': - if (IsSet($_GET["UID"])) - { - echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde Freigegeben:
"; - $SQL = "UPDATE `UserPicture` SET `show`='Y' WHERE `UID`='". $_GET["UID"]. "'"; - } - else - echo "Fehlerhafter Aufruf"; - break; - case 'del': - echo "Wollen Sie das Bild von '". UID2Nick( $_GET["UID"]). "' wirklich löschen? ". - "Yes"; - break; - case 'delYes': - if (IsSet($_GET["UID"])) - { - echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde gelöscht:
"; - $SQL = "DELETE FROM `UserPicture` WHERE `UID`='". $_GET["UID"]. "' LIMIT 1"; - } - else - echo "Fehlerhafter Aufruf"; - break; - default: - echo "Fehlerhafter Aufruf"; - - } //switch + case 'SetN': + if (IsSet($_GET["UID"])) + { + echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde gesperrt:
"; + $SQL = "UPDATE `UserPicture` SET `show`='N' WHERE `UID`='". $_GET["UID"]. "'"; + } + else + echo "Fehlerhafter Aufruf"; + break; + case 'SetY': + if (IsSet($_GET["UID"])) + { + echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde Freigegeben:
"; + $SQL = "UPDATE `UserPicture` SET `show`='Y' WHERE `UID`='". $_GET["UID"]. "'"; + } + else + echo "Fehlerhafter Aufruf"; + break; + case 'del': + echo "Wollen Sie das Bild von '". UID2Nick( $_GET["UID"]). "' wirklich löschen? ". + "Yes"; + break; + case 'delYes': + if (IsSet($_GET["UID"])) + { + echo "Bild von '". UID2Nick( $_GET["UID"]). "' wurde gelöscht:
"; + $SQL = "DELETE FROM `UserPicture` WHERE `UID`='". $_GET["UID"]. "' LIMIT 1"; + } + else + echo "Fehlerhafter Aufruf"; + break; + default: + echo "Fehlerhafter Aufruf"; + + } //switch - // Update ??? - if (IsSet($SQL)) - { - // hier muesste das SQL ausgefuehrt werden... - $Erg = mysql_query($SQL, $con); - if ($Erg == 1) - echo "Änderung wurde gesichert...
"; - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

".mysql_error( $con ). "
($SQL)
"; - } - } // Ende Update - echo "
\n
\n
\n\n"; + // Update ??? + if (IsSet($SQL)) + { + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($SQL, $con); + if ($Erg == 1) + echo "Änderung wurde gesichert...
"; + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

".mysql_error( $con ). "
($SQL)
"; + } + } // Ende Update + echo "
\n
\n
\n\n"; } //IF IsSet($action) //ausgabe der Liste $Sql = "SELECT * FROM `UserPicture` WHERE `UID`>0;"; $Erg = mysql_query($Sql, $con); - -echo "Hallo ". $_SESSION['Nick']. ",
\nhier hast du die Möglichkeit, die Bilder der Engel freizugeben:

\n"; + +echo "Hallo ". $_SESSION['Nick']. ",
\nhier hast du die Möglichkeit, die Bilder der Engel freizugeben:

\n"; echo "\n"; echo "\n"; @@ -125,25 +125,25 @@ echo "\t\n"; echo ""; for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) -{ - $UIDs = mysql_result($Erg, $t, "UID"); - echo "\t\n"; - - echo "\t\t\n"; - echo "\t\t\n"; - - if( GetPicturShow( $UIDs) == "Y") - echo "\t\t\n"; - elseif( GetPicturShow( $UIDs) == "N") - echo "\t\t\n"; - else - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; +{ + $UIDs = mysql_result($Erg, $t, "UID"); + echo "\t\n"; + + echo "\t\t\n"; + echo "\t\t\n"; + + if( GetPicturShow( $UIDs) == "Y") + echo "\t\t\n"; + elseif( GetPicturShow( $UIDs) == "N") + echo "\t\t\n"; + else + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; } // ende Auflistung Raeume echo "
Löschen
". UID2Nick(mysql_result($Erg, $t, "UID")). "". displayPictur( $UIDs, 0). "sperrenfreigebenERROR: show='". GetPicturShow( $UIDs). "'del
". UID2Nick(mysql_result($Erg, $t, "UID")). "". displayPictur( $UIDs, 0). "sperrenfreigebenERROR: show='". GetPicturShow( $UIDs). "'del
"; -echo "
picture upload\n"; +echo "
picture upload\n"; include ("../../../camp2011/includes/footer.php"); ?> diff --git a/www-ssl/admin/aktiv.php b/www-ssl/admin/aktiv.php old mode 100755 new mode 100644 index f5e8c9c3..68199cfa --- a/www-ssl/admin/aktiv.php +++ b/www-ssl/admin/aktiv.php @@ -1,4 +1,4 @@ -"; -echo Get_Text("pub_aktive_Text1")."
\n"; -echo Get_Text("pub_aktive_Text2")."

\n"; - +echo Get_Text("pub_aktive_Text1")."
\n"; +echo Get_Text("pub_aktive_Text2")."

\n"; + // auswahlbox echo Get_Text("pub_aktive_Text31")."\n"; echo ""; -echo Get_Text("pub_aktive_Text32")."

\n"; +echo Get_Text("pub_aktive_Text32")."

\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; - echo "\t
\n"; + echo "\t
\n"; echo "
\n"; if( Isset($_POST["ResetActive"]) ) { - $SQLreset = "UPDATE `User` SET `Aktiv`='0'"; - $ErgReset = db_query($SQLreset, "Reset Active"); - if ($ErgReset != 1) - echo "Fehler beim zuruecksetzen der Activ\n"; - else - echo "Active wurde erfolgreich zurueckgesetzt\n"; + $SQLreset = "UPDATE `User` SET `Aktiv`='0'"; + $ErgReset = db_query($SQLreset, "Reset Active"); + if ($ErgReset != 1) + echo "Fehler beim zuruecksetzen der Activ\n"; + else + echo "Active wurde erfolgreich zurueckgesetzt\n"; } if( IsSet($_POST["Anzahl"]) ) - echo "
\n\n".Get_Text("pub_aktive_Text5_1"). $_POST["Anzahl"]. Get_Text("pub_aktive_Text5_2"). ":"; + echo "
\n\n".Get_Text("pub_aktive_Text5_1"). $_POST["Anzahl"]. Get_Text("pub_aktive_Text5_2"). ":"; -echo "

\n\n"; +echo "

\n\n"; //ausgabe tabelle echo "\n"; @@ -51,15 +51,15 @@ echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; - + $SQL = " SELECT d.UID, d.nr, d.len, d.lenWeight, f.nr AS nrFree, f.len AS lenFree, d.lenWeight - COALESCE(f.len, 0) as lenReal - FROM - (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d - LEFT JOIN - (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f - USING(UID) - ORDER BY lenReal DESC, nr DESC, UID"; + FROM + (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d + LEFT JOIN + (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f + USING(UID) + ORDER BY lenReal DESC, nr DESC, UID"; $Erg = mysql_query($SQL, $con); echo mysql_error($con); @@ -68,42 +68,42 @@ $rowcount = mysql_num_rows($Erg); $aktivecount=0; for ($i=0; $i<$rowcount; $i++) { - echo "\n\n\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; + echo "\n\n\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; - - echo "\t\t\n"; - echo "\t\n"; + + echo "\t\t\n"; + echo "\t\n"; } // ende Auflistung aktive Engel echo "
Freeloader ". Get_Text("pub_aktive_Time"). "". Get_Text("pub_aktive_Time"). " result". Get_Text("pub_aktive_Active"). "
". UID2Nick(mysql_result($Erg, $i, "UID")). "". mysql_result($Erg, $i, "nr"). "x". mysql_result($Erg, $i, "len"). "h". mysql_result($Erg, $i, "lenWeight"). "h". mysql_result($Erg, $i, "nrFree"). "x". mysql_result($Erg, $i, "lenFree"). "h". mysql_result($Erg, $i, "lenReal"). "h
". UID2Nick(mysql_result($Erg, $i, "UID")). "". mysql_result($Erg, $i, "nr"). "x". mysql_result($Erg, $i, "len"). "h". mysql_result($Erg, $i, "lenWeight"). "h". mysql_result($Erg, $i, "nrFree"). "x". mysql_result($Erg, $i, "lenFree"). "h". mysql_result($Erg, $i, "lenReal"). "h"; - if (IsSet($_POST["Anzahl"])) - { - if( $_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal") ) - { - $aktivecount++; - if( $_POST["SendType"]=="Show..") - echo "show set"; - else - { - $SQL2="UPDATE `User` SET `Aktiv`='1' WHERE `UID`='". mysql_result($Erg, $i, "UID"). "' LIMIT 1"; - $Erg2 = db_query($SQL2, "update Active State"); - if ($Erg2 != 1) - echo "Fehler beim speichern bei Engel ".UID2Nick(mysql_result($Erg, $i, "UID")); - else - echo "write set"; - } - } - } - echo "
"; + if (IsSet($_POST["Anzahl"])) + { + if( $_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal") ) + { + $aktivecount++; + if( $_POST["SendType"]=="Show..") + echo "show set"; + else + { + $SQL2="UPDATE `User` SET `Aktiv`='1' WHERE `UID`='". mysql_result($Erg, $i, "UID"). "' LIMIT 1"; + $Erg2 = db_query($SQL2, "update Active State"); + if ($Erg2 != 1) + echo "Fehler beim speichern bei Engel ".UID2Nick(mysql_result($Erg, $i, "UID")); + else + echo "write set"; + } + } + } + echo "
"; -echo "
Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)

"; +echo "
Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)

"; include ("../../../camp2011/includes/footer.php"); ?> diff --git a/www-ssl/admin/dbUpdateFromXLS.php b/www-ssl/admin/dbUpdateFromXLS.php old mode 100755 new mode 100644 index 37612d7f..9a329355 --- a/www-ssl/admin/dbUpdateFromXLS.php +++ b/www-ssl/admin/dbUpdateFromXLS.php @@ -1,4 +1,4 @@ -\n

XML File:

\n"; +echo "\n\n
\n

XML File:

\n"; if( isset($_POST["PentabarfUser"]) && isset($_POST["password"]) && isset($_POST["PentabarfURL"])) { - echo "Update XCAL-File from Pentabarf.."; - if($PentabarfGetWith=="fsockopen") - { + echo "Update XCAL-File from Pentabarf.."; + if($PentabarfGetWith=="fsockopen") + { - //backup error messeges and delate - $Backuperror_messages = $error_messages; - $fp = fsockopen( "ssl://$PentabarfXMLhost", 443, $errno, $errstr, 30); -// $error_messages = $Backuperror_messages; - - if( !$fp) - { - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!". - "[$errstr ($errno)]

"; - } - else - { - if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) - { - $head = 'GET /'. $PentabarfXMLpath. $_POST["PentabarfURL"]. ' HTTP/1.1'."\r\n". - 'Host: '. $PentabarfXMLhost. "\r\n". - 'User-Agent: Engelsystem'. "\r\n". - 'Authorization: Basic '. - base64_encode($_POST["PentabarfUser"]. ':'. $_POST["password"])."\r\n". - "\r\n"; - fputs( $fp, $head); - $Zeilen = -1; - while (!feof($fp)) - { - $Temp= fgets($fp,1024); - - // ende des headers - if( $Temp== "f20\r\n" ) - { - $Zeilen = 0; - $Temp=""; - } - - //file ende? - if( $Temp=="0\r\n") - break; + //backup error messeges and delate + $Backuperror_messages = $error_messages; + $fp = fsockopen( "ssl://$PentabarfXMLhost", 443, $errno, $errstr, 30); +// $error_messages = $Backuperror_messages; + + if( !$fp) + { + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!". + "[$errstr ($errno)]

"; + } + else + { + if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) + { + $head = 'GET /'. $PentabarfXMLpath. $_POST["PentabarfURL"]. ' HTTP/1.1'."\r\n". + 'Host: '. $PentabarfXMLhost. "\r\n". + 'User-Agent: Engelsystem'. "\r\n". + 'Authorization: Basic '. + base64_encode($_POST["PentabarfUser"]. ':'. $_POST["password"])."\r\n". + "\r\n"; + fputs( $fp, $head); + $Zeilen = -1; + while (!feof($fp)) + { + $Temp= fgets($fp,1024); + + // ende des headers + if( $Temp== "f20\r\n" ) + { + $Zeilen = 0; + $Temp=""; + } + + //file ende? + if( $Temp=="0\r\n") + break; - if( ($Zeilen>-1) && ($Temp!="ffb\r\n") ) - { - //steuerzeichen ausfiltern - if( strpos( "#$Temp", "\r\n") > 0) - $Temp = substr($Temp, 0, strlen($Temp)-2); - if( strpos( "#$Temp", "1005") > 0) - $Temp = ""; - if( strpos( "#$Temp", "783") > 0) - $Temp = ""; - //schreiben in file - fputs( $fileOut, $Temp); - $Zeilen++; - } - } - fclose( $fileOut); - - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } - else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose($fp); - } - } - elseif($PentabarfGetWith=="fopen") - { - //user uns password in url einbauen - $FileNameIn = "https://". $_POST["PentabarfUser"]. ':'. $_POST["password"]. "@". - $PentabarfXMLhost. "/". $PentabarfXMLpath. $_POST["PentabarfURL"]; + if( ($Zeilen>-1) && ($Temp!="ffb\r\n") ) + { + //steuerzeichen ausfiltern + if( strpos( "#$Temp", "\r\n") > 0) + $Temp = substr($Temp, 0, strlen($Temp)-2); + if( strpos( "#$Temp", "1005") > 0) + $Temp = ""; + if( strpos( "#$Temp", "783") > 0) + $Temp = ""; + //schreiben in file + fputs( $fileOut, $Temp); + $Zeilen++; + } + } + fclose( $fileOut); + + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } + else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose($fp); + } + } + elseif($PentabarfGetWith=="fopen") + { + //user uns password in url einbauen + $FileNameIn = "https://". $_POST["PentabarfUser"]. ':'. $_POST["password"]. "@". + $PentabarfXMLhost. "/". $PentabarfXMLpath. $_POST["PentabarfURL"]; - if( ($fileIn = fopen( $FileNameIn, "r")) != FALSE) - { - if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) - { - $Zeilen = 0; - while (!feof($fileIn)) - { - $Zeilen++; - fputs( $fileOut, fgets( $fileIn)); - } - fclose( $fileOut); - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } - else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose( $fileIn); - } - else - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!

"; - } - elseif( $PentabarfGetWith=="wget") - { - $Command = "wget --http-user=". $_POST["PentabarfUser"]. " --http-passwd=".$_POST["password"]. " ". - "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. - " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML". - " --no-check-certificate"; - echo system( $Command, $Status); - if( $Status==0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif( $PentabarfGetWith=="lynx") - { - $Command = "lynx -auth=". $_POST["PentabarfUser"]. ":".$_POST["password"]. " -dump ". - "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. " > $Tempdir/engelXML"; - echo system( $Command, $Status); - if( $Status==0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif($PentabarfGetWith=="fopen") - { - //user uns password in url einbauen - $FileNameIn = "https://". $_POST["PentabarfUser"]. ':'. $_POST["password"]. "@". - $PentabarfXMLhost. "/". $PentabarfXMLpath. $_POST["PentabarfURL"]; + if( ($fileIn = fopen( $FileNameIn, "r")) != FALSE) + { + if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) + { + $Zeilen = 0; + while (!feof($fileIn)) + { + $Zeilen++; + fputs( $fileOut, fgets( $fileIn)); + } + fclose( $fileOut); + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } + else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose( $fileIn); + } + else + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!

"; + } + elseif( $PentabarfGetWith=="wget") + { + $Command = "wget --http-user=". $_POST["PentabarfUser"]. " --http-passwd=".$_POST["password"]. " ". + "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. + " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML". + " --no-check-certificate"; + echo system( $Command, $Status); + if( $Status==0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif( $PentabarfGetWith=="lynx") + { + $Command = "lynx -auth=". $_POST["PentabarfUser"]. ":".$_POST["password"]. " -dump ". + "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. " > $Tempdir/engelXML"; + echo system( $Command, $Status); + if( $Status==0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif($PentabarfGetWith=="fopen") + { + //user uns password in url einbauen + $FileNameIn = "https://". $_POST["PentabarfUser"]. ':'. $_POST["password"]. "@". + $PentabarfXMLhost. "/". $PentabarfXMLpath. $_POST["PentabarfURL"]; - if( ($fileIn = fopen( $FileNameIn, "r")) != FALSE) - { - if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) - { - $Zeilen = 0; - while (!feof($fileIn)) - { - $Zeilen++; - fputs( $fileOut, fgets( $fileIn)); - } - fclose( $fileOut); - echo "
Es wurden $Zeilen Zeilen eingelesen
"; - } - else - echo "

fail: File '$Tempdir/engelXML' not writeable!

"; - fclose( $fileIn); - } - else - echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!

"; - } - elseif( $PentabarfGetWith=="wget") - { - $Command = "wget --http-user=". $_POST["PentabarfUser"]. " --http-passwd=".$_POST["password"]. " ". - "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. - " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML". - " --no-check-certificate"; - echo system( $Command, $Status); - if( $Status==0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - elseif( $PentabarfGetWith=="lynx") - { - $Command = "lynx -auth=". $_POST["PentabarfUser"]. ":".$_POST["password"]. " -dump ". - "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. " > $Tempdir/engelXML"; - echo system( $Command, $Status); - if( $Status==0) - echo "OK.
"; - else - echo "fail ($Status)($Command).
"; - } - else - echo "

The PentabarfGetWith='$PentabarfGetWith' not supported

"; + if( ($fileIn = fopen( $FileNameIn, "r")) != FALSE) + { + if( ($fileOut = fopen( "$Tempdir/engelXML", "w")) != FALSE) + { + $Zeilen = 0; + while (!feof($fileIn)) + { + $Zeilen++; + fputs( $fileOut, fgets( $fileIn)); + } + fclose( $fileOut); + echo "
Es wurden $Zeilen Zeilen eingelesen
"; + } + else + echo "

fail: File '$Tempdir/engelXML' not writeable!

"; + fclose( $fileIn); + } + else + echo "

fail: File 'https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. "' not readable!

"; + } + elseif( $PentabarfGetWith=="wget") + { + $Command = "wget --http-user=". $_POST["PentabarfUser"]. " --http-passwd=".$_POST["password"]. " ". + "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. + " --output-file=$Tempdir/engelXMLwgetLog --output-document=$Tempdir/engelXML". + " --no-check-certificate"; + echo system( $Command, $Status); + if( $Status==0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + elseif( $PentabarfGetWith=="lynx") + { + $Command = "lynx -auth=". $_POST["PentabarfUser"]. ":".$_POST["password"]. " -dump ". + "https://$PentabarfXMLhost/$PentabarfXMLpath". $_POST["PentabarfURL"]. " > $Tempdir/engelXML"; + echo system( $Command, $Status); + if( $Status==0) + echo "OK.
"; + else + echo "fail ($Status)($Command).
"; + } + else + echo "

The PentabarfGetWith='$PentabarfGetWith' not supported

"; } else { - echo "
\n"; - echo "\n"; - echo "\t". - "\n"; - echo "\t". - "\n"; - echo "\t". - "\n"; - echo "\t\n"; - echo "
XCAL-File: https://$PentabarfXMLhost/$PentabarfXMLpath
Username:
Password:
\n"; - echo "
\n"; + echo "
\n"; + echo "\n"; + echo "\t". + "\n"; + echo "\t". + "\n"; + echo "\t". + "\n"; + echo "\t\n"; + echo "
XCAL-File: https://$PentabarfXMLhost/$PentabarfXMLpath
Username:
Password:
\n"; + echo "
\n"; } @@ -235,52 +235,52 @@ $XMLmain = getXMLsubPease( $XMLmain, "VCALENDAR"); if( $ShowDataStrukture) { - echo "

";
-	echo $XMLmain->name;
-	echo "
";
-	print_r(array_values ($XMLmain->sub));
-	echo "
"; + echo "

";
+  echo $XMLmain->name;
+  echo "
";
+  print_r(array_values ($XMLmain->sub));
+  echo "
"; } /* -echo "
"; +echo "
"; $Feld=7; -echo "$Feld#". $XMLmain->sub[$Feld]->name. "
"; +echo "$Feld#". $XMLmain->sub[$Feld]->name. "
"; echo "$Feld#". $XMLmain->sub[$Feld]->sub; //print_r(array_values ($XMLmain->sub[$Feld]->sub)); while(list($key, $value) = each($XMLmain->sub[$Feld]->sub)) - echo "?ID".$value->sub[1]->data. "=". $value->sub[2]->data. "\n"; + echo "?ID".$value->sub[1]->data. "=". $value->sub[2]->data. "\n"; echo ""; */ /*############################################################################################## - V e r s i o n + V e r s i o n ##############################################################################################*/ echo "
\n"; $XMLrelease = getXMLsubPease( $XMLmain, "X-WR-CALDESC"); -echo "release: ". $XMLrelease->data. "
\n"; +echo "release: ". $XMLrelease->data. "
\n"; //$XMLreleaseDate = getXMLsubPease( $XMLmain, "RELEASE-DATE"); -//echo "release date: ". $XMLreleaseDate->data. "
\n"; +//echo "release date: ". $XMLreleaseDate->data. "
\n"; echo "
\n"; /*############################################################################################## - V e r s i o n + V e r s i o n ##############################################################################################*/ if( $EnableRoomFunctions) - include("../../../camp2011/includes/funktion_xml_room.php"); + include("../../../camp2011/includes/funktion_xml_room.php"); if( $EnableSchudleFunctions) - include("../../../camp2011/includes/funktion_xml_schudle.php"); + include("../../../camp2011/includes/funktion_xml_schudle.php"); /*############################################################################################## - U P D A T E A L L + U P D A T E A L L ##############################################################################################*/ -echo "\n\n
\n

Update ALL:

\n"; +echo "\n\n
\n

Update ALL:

\n"; echo "
\n"; echo "\t\n"; diff --git a/www-ssl/admin/debug.php b/www-ssl/admin/debug.php old mode 100755 new mode 100644 index b01a8a6c..b2c6357f --- a/www-ssl/admin/debug.php +++ b/www-ssl/admin/debug.php @@ -1,4 +1,4 @@ -Web Counter"; funktion_db_list("Counter"); /* -echo "

Raeume


"; +echo "

Raeume


"; funktion_db_list("Raeume"); -echo "

Schichtbelegung


"; +echo "

Schichtbelegung


"; funktion_db_list("Schichtbelegung"); -echo "

Schichtplan


Hier findest du alle bisher eingetragenen Schichten:"; +echo "

Schichtplan


Hier findest du alle bisher eingetragenen Schichten:"; funktion_db_list("Schichtplan"); -echo "

User


"; +echo "

User


"; funktion_db_list("User"); -echo "

News


"; +echo "

News


"; funktion_db_list("News"); -echo "

FAQ


"; +echo "

FAQ


"; funktion_db_list("FAQ"); echo "Deaktiviert"; @@ -32,34 +32,34 @@ echo "Deaktiviert"; echo "
\n"; funktion_db_element_list_2row( "Tshirt-Size aller engel", - "SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); -echo "
\n"; + "SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); +echo "
\n"; funktion_db_element_list_2row( "Tshirt ausgegeben", - "SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); -echo "
\n"; + "SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); +echo "
\n"; funktion_db_element_list_2row( "Tshirt nicht ausgegeben (Gekommen=1)", - "SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"); + "SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"); echo "
\n"; funktion_db_element_list_2row( "Hometown", - "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); -echo "
\n"; + "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); +echo "
\n"; funktion_db_element_list_2row( "Engeltypen", - "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); + "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); echo "
\n"; funktion_db_element_list_2row( "Gesamte Arbeit", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID)"); -echo "
\n"; + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID)"); +echo "
\n"; funktion_db_element_list_2row( "Geleisteter Arbeit", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0)"); + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0)"); echo "
\n"; funktion_db_element_list_2row( "Gesamte Arbeit (Ohne Raum aufabau (RID=7)", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (Shifts.RID!=7)"); -echo "
\n"; + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (Shifts.RID!=7)"); +echo "
\n"; funktion_db_element_list_2row( "Geleisteter Arbeit (Ohne Raum aufabau (RID=7)", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0) AND (Shifts.RID!=7)"); + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0) AND (Shifts.RID!=7)"); diff --git a/www-ssl/admin/dect.php b/www-ssl/admin/dect.php old mode 100755 new mode 100644 index e6096d27..76409cc6 --- a/www-ssl/admin/dect.php +++ b/www-ssl/admin/dect.php @@ -1,4 +1,4 @@ -\n"; - echo "\n"; + echo "\n"; + echo "
\n"; - echo "\n"; + echo "\n"; - echo "\n"; + $usql="SELECT * FROM `User` WHERE NOT `DECT`='' ORDER BY `Nick`"; + $uErg = mysql_query($usql, $con); + $urowcount = mysql_num_rows($uErg); + for ($k=0; $k<$urowcount; $k++) + { + echo "\t\n"; + } + echo "\n"; + + echo "\n"; + echo "\n"; - echo "\n"; - echo "\n"; - echo ""; - echo "
Numberh:m
Numberh:m
\n"; - // Listet alle Nicks auf - echo "
\n"; + // Listet alle Nicks auf + echo "\n"; - - echo "\n"; - echo ":"; - echo "
\n"; - - echo "
"; + echo ":"; + echo "\n"; + echo "\n"; + echo ""; + echo "\n"; + + echo ""; include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/dect_call.php b/www-ssl/admin/dect_call.php old mode 100755 new mode 100644 index c69efa17..58c7cfe1 --- a/www-ssl/admin/dect_call.php +++ b/www-ssl/admin/dect_call.php @@ -1,4 +1,4 @@ - Anfragen und FAQ
  • Alle Anfragen
    • -
  • Offene Anfragen ()
    • +
  • Offene Anfragen ()
  • FAQ-Liste editiern
    • diff --git a/www-ssl/admin/faq.php b/www-ssl/admin/faq.php old mode 100755 new mode 100644 index 645c08cd..217e9188 --- a/www-ssl/admin/faq.php +++ b/www-ssl/admin/faq.php @@ -22,119 +22,119 @@ switch ($_GET["quest"]) // *--------------------------------------------------------------------------- case "all": - $SQL="SELECT * FROM `Questions` ORDER BY QID DESC"; + $SQL="SELECT * FROM `Questions` ORDER BY QID DESC"; ?> - Alle Anfragen:
    + Alle Anfragen:
    - - + + - + -\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "\n"; - } - else - { - echo "Nein\n"; - echo "\n"; - echo "\n"; - } - echo ""; - echo "\n"; - } - echo "
    FrageAnfragenderFrageAnfragender Beantwortet? Antwort Antwort vonchangechange
    ".mysql_result($Erg, $n, "Question")."".UID2Nick(mysql_result($Erg, $n, "UID")).""; - if (mysql_result($Erg, $n, "AID")>0) - { - echo "Ja".mysql_result($Erg, $n, "Answer")."".UID2Nick(mysql_result($Erg, $n, "AID"))."  xxx
    \n"; - break; - + echo "\n"; + echo "".mysql_result($Erg, $n, "Question")."\n"; + echo "".UID2Nick(mysql_result($Erg, $n, "UID"))."\n"; + echo ""; + if (mysql_result($Erg, $n, "AID")>0) + { + echo "Ja\n"; + echo "".mysql_result($Erg, $n, "Answer")."\n"; + echo "".UID2Nick(mysql_result($Erg, $n, "AID"))."\n"; + } + else + { + echo "Nein\n"; + echo " \n"; + echo " \n"; + } + echo "xxx"; + echo "\n"; + } + echo "\n"; + break; + case "open": - $SQL="SELECT * FROM `Questions` WHERE `AID`='0' ORDER BY `QID` DESC"; - $quest_bearb=1; // Fragenliste anzeigen - echo "\t\tOffene Anfragen:
    \n"; - break; - + $SQL="SELECT * FROM `Questions` WHERE `AID`='0' ORDER BY `QID` DESC"; + $quest_bearb=1; // Fragenliste anzeigen + echo "\t\tOffene Anfragen:
    \n"; + break; + case "edit": - if (!IsSet($_GET["QID"])) - echo "\t\tFehlerhafter Aufruf...
    Bitte die Bearbeitung nochmals beginnen :)\n"; - else - { - $SQL = "SELECT * FROM `Questions` WHERE `QID`='". $_GET["QID"]. "'"; - $Erg = mysql_query($SQL, $con); - echo "\t\t
    \n"; - echo "\t\tAnfrage von ". UID2NICK(mysql_result($Erg, 0, "UID")). ":
    \n"; - echo "\t\t\n"; - echo "

    Antwort der Erzengel:
    \n"; - if (mysql_result($Erg, 0, "Answer")=="") - echo "\t\t
    \n"; - else - echo "\t\t\n
    \n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t
    \n"; - if (mysql_result($Erg, 0, "AID")<>"0") - { - echo "\tDu kannst diese Anfrage so wie sie ist, als Engel-FAQ eintrag übernehmen.
    \n"; - echo "Als FAQ-Eintrag sichern...\n"; - } - } // Abfrage der QID - break; + if (!IsSet($_GET["QID"])) + echo "\t\tFehlerhafter Aufruf...
    Bitte die Bearbeitung nochmals beginnen :)\n"; + else + { + $SQL = "SELECT * FROM `Questions` WHERE `QID`='". $_GET["QID"]. "'"; + $Erg = mysql_query($SQL, $con); + echo "\t\t
    \n"; + echo "\t\tAnfrage von ". UID2NICK(mysql_result($Erg, 0, "UID")). ":
    \n"; + echo "\t\t\n"; + echo "

    Antwort der Erzengel:
    \n"; + if (mysql_result($Erg, 0, "Answer")=="") + echo "\t\t
    \n"; + else + echo "\t\t\n
    \n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t
    \n"; + if (mysql_result($Erg, 0, "AID")<>"0") + { + echo "\tDu kannst diese Anfrage so wie sie ist, als Engel-FAQ eintrag übernehmen.
    \n"; + echo "Als FAQ-Eintrag sichern...\n"; + } + } // Abfrage der QID + break; case "save": - if (!IsSet($_GET["QID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten..."; + if (!IsSet($_GET["QID"])) + echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten..."; else - { - $SQL = "UPDATE `Questions` SET `Question`='". $_GET["Question"]. - "', `AID`='". $_SESSION['UID']. "' , `Answer`='". $_GET["Answer"]. "' ". - "WHERE `QID`='". $_GET["QID"]. "' LIMIT 1"; - $Erg = db_query($SQL, "save Question"); - if ($Erg == 1) - { - echo "\tDer Eintrag wurde geändert
    \n"; - SetHeaderGo2Back(); - } - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; + { + $SQL = "UPDATE `Questions` SET `Question`='". $_GET["Question"]. + "', `AID`='". $_SESSION['UID']. "' , `Answer`='". $_GET["Answer"]. "' ". + "WHERE `QID`='". $_GET["QID"]. "' LIMIT 1"; + $Erg = db_query($SQL, "save Question"); + if ($Erg == 1) + { + echo "\tDer Eintrag wurde geändert
    \n"; + SetHeaderGo2Back(); + } + else + echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; } - break; + break; case "transfer": - if (!IsSet($_GET["QID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; - else - { - $SQL1="SELECT * FROM `Questions` WHERE `QID`='". $_GET["QID"]. "'"; - $Erg = mysql_query($SQL1, $con); - $SQL2="INSERT INTO `FAQ` Values ('', '". - mysql_result($Erg, 0, "Question")."', '".mysql_result($Erg, 0, "Answer")."')"; - $Erg = db_query($SQL2, "trasfert to request to the FAQ"); - if ($Erg == 1) - echo "\tDer Eintrag wurde übertragen.
    \n"; - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; - } - - break; + if (!IsSet($_GET["QID"])) + echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; + else + { + $SQL1="SELECT * FROM `Questions` WHERE `QID`='". $_GET["QID"]. "'"; + $Erg = mysql_query($SQL1, $con); + $SQL2="INSERT INTO `FAQ` Values ('', '". + mysql_result($Erg, 0, "Question")."', '".mysql_result($Erg, 0, "Answer")."')"; + $Erg = db_query($SQL2, "trasfert to request to the FAQ"); + if ($Erg == 1) + echo "\tDer Eintrag wurde übertragen.
    \n"; + else + echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; + } + + break; // *--------------------------------------------------------------------------- // * FAQ - Bearbeitung @@ -143,105 +143,105 @@ case "transfer": // * geaendert oder geloscht werden... // *--------------------------------------------------------------------------- case "faq": - $quest_bearb=0; // keine Fragenliste anzeigen, FAQ editieren... - echo "\tFAQ-Liste:
    "; - echo "Neuen Eintrag"; - - $SQL = "SELECT * FROM `FAQ`"; - $Erg = mysql_query($SQL, $con); + $quest_bearb=0; // keine Fragenliste anzeigen, FAQ editieren... + echo "\tFAQ-Liste:
    "; + echo "Neuen Eintrag"; + + $SQL = "SELECT * FROM `FAQ`"; + $Erg = mysql_query($SQL, $con); - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); - for ($n = 0 ; $n < $Zeilen ; $n++) - if (mysql_result($Erg, $n, "Antwort")!="") - { - echo "\t

    ". mysql_result($Erg, $n, "Frage"). "

    \n"; - echo "\t

    ". mysql_result($Erg, $n, "Antwort")."

    \n"; - echo "\tBearbeiten\n
    ---
    \n"; - } - break; + for ($n = 0 ; $n < $Zeilen ; $n++) + if (mysql_result($Erg, $n, "Antwort")!="") + { + echo "\t

    ". mysql_result($Erg, $n, "Frage"). "

    \n"; + echo "\t

    ". mysql_result($Erg, $n, "Antwort")."

    \n"; + echo "\tBearbeiten\n
    ---
    \n"; + } + break; case "faqedit": if (!IsSet($_GET["FAQID"])) - echo "\tFehlerhafter Aufruf...
    Bitte die Bearbeitung nochmals beginnen :)\n"; - else - { - $SQL = "SELECT * FROM `FAQ` WHERE `FID`='". $_GET["FAQID"]. "'"; - $Erg = mysql_query($SQL, $con); + echo "\tFehlerhafter Aufruf...
    Bitte die Bearbeitung nochmals beginnen :)\n"; + else + { + $SQL = "SELECT * FROM `FAQ` WHERE `FID`='". $_GET["FAQID"]. "'"; + $Erg = mysql_query($SQL, $con); - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); ?> -
    - Frage:
    - -

    - Antwort:
    -
    - "> - - -
    -
    - "> + + Frage:
    + +

    + Antwort:
    +
    + "> + + +
    +
    + "> -
    + \n"; - else - echo "\tEin Fehler ist aufgetreten. Ist der Eintag bereits gelöscht gewesen?\n"; - } - break; + if (!IsSet($_GET["FAQID"])) + echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; + else + { + $SQL = "DELETE FROM `FAQ` WHERE `FID`='". $_GET["FAQID"]. "' LIMIT 1"; + $Erg = db_query($SQL, "delate faq item"); + if ($Erg == 1) + echo "\tDer Eintrag wurde gelöscht
    \n"; + else + echo "\tEin Fehler ist aufgetreten. Ist der Eintag bereits gelöscht gewesen?\n"; + } + break; case "faqsave"; if (!IsSet($_GET["FAQID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; + echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; else - { - $SQL = "UPDATE `FAQ` SET `Frage`='". $_GET["Frage"]. "', `Antwort`='". $_GET["Antwort"]. - "' WHERE `FID`='". $_GET["FAQID"]. "' LIMIT 1"; - $Erg = db_query($SQL, $con); - if ($Erg == 1) - echo "\tDer Eintrag wurde geändert
    \n"; - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; + { + $SQL = "UPDATE `FAQ` SET `Frage`='". $_GET["Frage"]. "', `Antwort`='". $_GET["Antwort"]. + "' WHERE `FID`='". $_GET["FAQID"]. "' LIMIT 1"; + $Erg = db_query($SQL, $con); + if ($Erg == 1) + echo "\tDer Eintrag wurde geändert
    \n"; + else + echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; } - break; + break; case "faqnew": ?> -
    - Frage:
    -

    - Antwort:
    -
    + + Frage:
    +

    + Antwort:
    +
    \n"; + echo "\tDer Eintrag wurde erfasst.
    \n"; else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; + echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; break; } //switch ($_GET["quest"]) @@ -251,32 +251,32 @@ case "faqnewsave"; // Fragenliste anzeigen??? if ($quest_bearb==1) { - $Erg = mysql_query($SQL, $con); - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); + $Erg = mysql_query($SQL, $con); + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); - if ($Zeilen==0) - echo "\tkeine vorhanden...\n"; - else - for ($n = 0 ; $n < $Zeilen ; $n++) - { - echo "\t

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


    \n"; - echo "\tBearbeiten\n"; - echo "
    ---
    \n"; - } - + if ($Zeilen==0) + echo "\tkeine vorhanden...\n"; + else + for ($n = 0 ; $n < $Zeilen ; $n++) + { + echo "\t

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


    \n"; + echo "\tBearbeiten\n"; + echo "
    ---
    \n"; + } + } } //if (IsSet($_GET["quest"])) else { - echo "Bitte wähle aus, ob du:\n"; - echo "\n"; + echo "Bitte wähle aus, ob du:\n"; + echo "\n"; } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/free.php b/www-ssl/admin/free.php old mode 100755 new mode 100644 index 5ceaebb6..577ef7be --- a/www-ssl/admin/free.php +++ b/www-ssl/admin/free.php @@ -1,4 +1,4 @@ -\n"; +echo "Hallo ".$_SESSION['Nick'].",
    \n"; -echo "

    \n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:

    \n"; +echo "

    \n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht verplant sind:

    \n"; ####################################################### @@ -21,21 +21,21 @@ echo "

    \n\nHier findest du alle Engel, welche zur Zeit in keiner Schicht /* geht nicht ??? unter stabel !! $SQL= "SELECT User.Nick, Schichtplan.*, Schichtbelegung.* ". - "FROM Schichtplan, User LEFT OUTER ". - "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". - "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". - "Schichtplan.Date < now() and ". - "Schichtplan.EndDate > now() ". - "ORDER BY Nick"; - + "FROM Schichtplan, User LEFT OUTER ". + "JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID ". + "WHERE Schichtplan.SID = Schichtbelegung.SID AND ". + "Schichtplan.Date < now() and ". + "Schichtplan.EndDate > now() ". + "ORDER BY Nick"; + $SQL = "SELECT Shifts.*, ShiftEntry.*, User.Nick ". - "FROM User ". - "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". - "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; + "FROM User ". + "INNER JOIN (Shifts INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID) ON User.UID = ShiftEntry.UID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() );"; */ $SQL = "SELECT Shifts.*, ShiftEntry.* ". - "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". - "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; + "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; //SELECT User.Nick, Schichtplan.*, Schichtbelegung. * FROM User LEFT JOIN Schichtbelegung ON User.UID=Schichtbelegung.UID, Schichtplan LEFT JOIN Schichtbelegung ON Schichtplan.SID = Schichtbelegung.SID WHERE Schichtplan.Date < now() and Schichtplan.EndDate > now() ORDER BY Nick @@ -62,27 +62,27 @@ echo "\t\n"; $inuse=""; for ($i=0; $i < $Zeilen; $i++) { - echo "\n"; - echo "". - UID2Nick(mysql_result($Erg, $i, "UID")). "\n"; - echo "\n"; - echo "". mysql_result($Erg, $i, "RID"). "\n"; - echo "". mysql_result($Erg, $i, "DateS"). "\n"; - echo "". mysql_result($Erg, $i, "DateE"). "\n"; - echo "\n"; - - if ($inuse!="") - $inuse.= " OR "; - $inuse.= "(Nick = \"". UID2Nick(mysql_result($Erg, $i, "UID")). "\")"; + echo "\n"; + echo "". + UID2Nick(mysql_result($Erg, $i, "UID")). "\n"; + echo "\n"; + echo "". mysql_result($Erg, $i, "RID"). "\n"; + echo "". mysql_result($Erg, $i, "DateS"). "\n"; + echo "". mysql_result($Erg, $i, "DateE"). "\n"; + echo "\n"; + + if ($inuse!="") + $inuse.= " OR "; + $inuse.= "(Nick = \"". UID2Nick(mysql_result($Erg, $i, "UID")). "\")"; } if ($inuse!="") - $inuse=" WHERE NOT (".$inuse.")"; + $inuse=" WHERE NOT (".$inuse.")"; echo "\n"; //########################################################################################################## -echo "

    \n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:

    \n"; +echo "

    \n\nhier findest du alle Engel, welche zur Zeit in keiner Schichten verplant sind:

    \n"; echo "\n"; echo "\t\n\t\t\n\t\t\n\t\n"; @@ -91,11 +91,11 @@ $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); for ($i=0; $i < $Zeilen; $i++) { - echo "\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\n\n"; + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\n\n"; } echo "
    NickDECT
    ". - mysql_result($Erg, $i, "Nick"). "". mysql_result($Erg, $i, "DECT"). "
    ". + mysql_result($Erg, $i, "Nick"). "". mysql_result($Erg, $i, "DECT"). "
    \n"; diff --git a/www-ssl/admin/free_DECT.php b/www-ssl/admin/free_DECT.php old mode 100755 new mode 100644 index c28c78af..83a4123f --- a/www-ssl/admin/free_DECT.php +++ b/www-ssl/admin/free_DECT.php @@ -1,4 +1,4 @@ -=Now() AND ShiftEntry.UID>0);"; + "FROM `Shifts` INNER JOIN ShiftEntry ON Shifts.SID = ShiftEntry.SID ". + "WHERE (Shifts.DateS<=Now() AND Shifts.DateE>=Now() AND ShiftEntry.UID>0);"; $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); @@ -21,17 +21,17 @@ $Zeilen = mysql_num_rows($Erg); $inuse=""; for ($i=0; $i < $Zeilen; $i++) { - if ($inuse!="") - $inuse.= " OR "; - $inuse.= "(UID = \"". mysql_result($Erg, $i, "UID"). "\")"; + if ($inuse!="") + $inuse.= " OR "; + $inuse.= "(UID = \"". mysql_result($Erg, $i, "UID"). "\")"; } if ($inuse!="") { - $inuse=" WHERE (NOT (".$inuse.")) AND (DECT!='')"; + $inuse=" WHERE (NOT (".$inuse.")) AND (DECT!='')"; } else { - $inuse=" WHERE (DECT!='')"; + $inuse=" WHERE (DECT!='')"; } @@ -42,36 +42,36 @@ $Erg = mysql_query($SQL, $con); $Zeilen = mysql_num_rows($Erg); for ($i=0; $i < $Zeilen; $i++) { - // get DECT number - echo mysql_result($Erg, $i, "DECT"). "\t"; + // get DECT number + echo mysql_result($Erg, $i, "DECT"). "\t"; - // get all user rights - $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=". mysql_result($Erg, $i, "UID"). ";"; - $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); - $UserRights = mysql_fetch_array($Erg_RIGHT); + // get all user rights + $SQL_RIGHT = "SELECT * FROM UserCVS WHERE UID=". mysql_result($Erg, $i, "UID"). ";"; + $Erg_RIGHT = mysql_query($SQL_RIGHT, $con); + $UserRights = mysql_fetch_array($Erg_RIGHT); - foreach( $UserRights as $Var => $Value) - { - if( (strpos( $Var, ".php") === false) AND - (strpos( $Var, "/") === false) AND - (strpos( $Var, "UID") === false) AND - (is_numeric($Var) === false) ) - { - echo "\"".$Var. "\"=". $Value. "\t"; - } - } + foreach( $UserRights as $Var => $Value) + { + if( (strpos( $Var, ".php") === false) AND + (strpos( $Var, "/") === false) AND + (strpos( $Var, "UID") === false) AND + (is_numeric($Var) === false) ) + { + echo "\"".$Var. "\"=". $Value. "\t"; + } + } - // get shift types - $SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=". mysql_result($Erg, $i, "UID"). " GROUP BY TID;"; - $Erg_TYPES = mysql_query($SQL_TYPES, $con); - $Zeilen_Typen = mysql_num_rows($Erg_TYPES); - for ($j=0; $j < $Zeilen_Typen; $j++) - { - echo "\"TID_". TID2Type( mysql_result($Erg_TYPES, $j, "TID")). "\"=Y\t"; - } + // get shift types + $SQL_TYPES = "SELECT TID FROM `ShiftEntry` WHERE UID=". mysql_result($Erg, $i, "UID"). " GROUP BY TID;"; + $Erg_TYPES = mysql_query($SQL_TYPES, $con); + $Zeilen_Typen = mysql_num_rows($Erg_TYPES); + for ($j=0; $j < $Zeilen_Typen; $j++) + { + echo "\"TID_". TID2Type( mysql_result($Erg_TYPES, $j, "TID")). "\"=Y\t"; + } - echo "\n"; -// echo "
    "; + echo "\n"; +// echo "
    "; } ?> diff --git a/www-ssl/admin/group.php b/www-ssl/admin/group.php old mode 100755 new mode 100644 index 57945d0d..f42fea97 --- a/www-ssl/admin/group.php +++ b/www-ssl/admin/group.php @@ -1,4 +1,4 @@ -\n"; - echo "\n"; - echo "\tGroupname\n"; - echo "\tLink\n"; - echo "\n"; - - for ($n = 0 ; $n < $Zeilen ; $n++) { - echo "\n"; - echo "\t".mysql_result($Erg, $n, "Name")."\n"; - - echo "change\n"; - echo "\n"; - } - - // new form - echo "\n"; - echo "\t
    \n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t
    \n"; - echo "\n"; - - echo "\t\n"; - // Ende Userliste + // Userliste, keine UID uebergeben... + + $SQL = "SELECT * FROM `UserGroups` ORDER BY `Name` ASC"; + $Erg = mysql_query($SQL, $con); + echo mysql_error($con); + + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); + + echo "\n"; + echo "\n"; + echo "\t\n"; + echo "\t\n"; + echo "\n"; + + for ($n = 0 ; $n < $Zeilen ; $n++) { + echo "\n"; + echo "\t\n"; + + echo "\n"; + echo "\n"; + } + + // new form + echo "\n"; + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; + echo "\n"; + + echo "\t
    GroupnameLink
    ".mysql_result($Erg, $n, "Name")."change
    \n"; + // Ende Userliste } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/index.php b/www-ssl/admin/index.php old mode 100755 new mode 100644 index b89bdb93..e7be285c --- a/www-ssl/admin/index.php +++ b/www-ssl/admin/index.php @@ -1,19 +1,19 @@ -\n"; +echo "Hallo Erzengel ".$_SESSION['Nick'].",
    \n"; ?> -du bist jetzt im Erzengel-Bereich. Hier kannst du die Engel-Verwaltung vornehmen.

    +du bist jetzt im Erzengel-Bereich. Hier kannst du die Engel-Verwaltung vornehmen.

    Bitte melde dich hier nach getaner Arbeit immer ab, damit kein anderer hier Änderungen vornehmen kann. - diff --git a/www-ssl/admin/news.php b/www-ssl/admin/news.php old mode 100755 new mode 100644 index 78f49ee2..f25eab93 --- a/www-ssl/admin/news.php +++ b/www-ssl/admin/news.php @@ -1,4 +1,4 @@ - -Hallo ,
    + $rowcount = mysql_num_rows($Erg); + ?> +Hallo ,
    hier kannst du die News säubern... falls jemand auf die Idee kommt, -hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)

    +hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)

    @@ -24,97 +24,97 @@ hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)
    - - -\n"; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t "; - echo "\t\n"; - } - echo "
    Text Erfasser EngeltreffÄnd.
    ".mysql_result($Erg, $i, "Datum")."".mysql_result($Erg, $i, "Betreff")."".mysql_result($Erg, $i, "Text")."".UID2Nick(mysql_result($Erg, $i, "UID"))."".mysql_result($Erg, $i, "Treffen")."XXX
    "; + Änd. + +\n"; + echo "\t ".mysql_result($Erg, $i, "Datum").""; + echo "\t ".mysql_result($Erg, $i, "Betreff").""; + echo "\t ".mysql_result($Erg, $i, "Text").""; + echo "\t ".UID2Nick(mysql_result($Erg, $i, "UID")).""; + echo "\t ".mysql_result($Erg, $i, "Treffen").""; + echo "\t XXX"; + echo "\t\n"; + } + echo ""; } else { - unSet($chsql); - - switch ($_GET["action"]) - { - case 'change': - if (isset($_GET["date"])) - { - $SQL = "SELECT * FROM `News` WHERE (`Datum`='". $_GET["date"]. "')"; - $Erg = mysql_query($SQL, $con); - - if( mysql_num_rows( $Erg)>0) - { - echo "
    \n"; - - echo "\n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo "
    Datum
    Betreff
    Text
    Engel
    Treffen
    "; - - echo "\n"; - echo "\n"; - echo "\n"; - echo "
    "; - - echo "
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; - } - else - echo "FEHLER: Eintrag \"". $_GET["date"]. "\" nicht gefunden"; - } - else - echo "Fehler: \"date\" nicht übergeben"; - break; - - case 'change_save': - if( isset($_GET["date"]) && isset($_GET["eBetreff"]) && isset($_GET["eText"]) ) - $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"; - break; - - case 'delete': - if (isset($_POST["date"])) - $chsql="DELETE FROM `News` WHERE `Datum`='". $_POST["date"]. "' LIMIT 1"; - else - echo "Fehler: \"date\" nicht übergeben"; - break; - } //SWITCH - - if (IsSet($chsql)) - { - // SQL-Statement ausführen... - $Erg = mysql_query($chsql, $con); - If ($Erg == 1) - echo "Änderung erfolgreich gesichert..."; - else - echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)

    \n". - mysql_error($con). "

    \n[$chsql]"; - SetHeaderGo2Back(); - } + unSet($chsql); + + switch ($_GET["action"]) + { + case 'change': + if (isset($_GET["date"])) + { + $SQL = "SELECT * FROM `News` WHERE (`Datum`='". $_GET["date"]. "')"; + $Erg = mysql_query($SQL, $con); + + if( mysql_num_rows( $Erg)>0) + { + echo "
    \n"; + + echo "\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo "
    Datum
    Betreff
    Text
    Engel
    Treffen
    "; + + echo "\n"; + echo "\n"; + echo "\n"; + echo "
    "; + + echo "
    \n"; + echo "\n"; + echo "\n"; + echo "
    "; + } + else + echo "FEHLER: Eintrag \"". $_GET["date"]. "\" nicht gefunden"; + } + else + echo "Fehler: \"date\" nicht übergeben"; + break; + + case 'change_save': + if( isset($_GET["date"]) && isset($_GET["eBetreff"]) && isset($_GET["eText"]) ) + $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"; + break; + + case 'delete': + if (isset($_POST["date"])) + $chsql="DELETE FROM `News` WHERE `Datum`='". $_POST["date"]. "' LIMIT 1"; + else + echo "Fehler: \"date\" nicht übergeben"; + break; + } //SWITCH + + if (IsSet($chsql)) + { + // SQL-Statement ausführen... + $Erg = mysql_query($chsql, $con); + If ($Erg == 1) + echo "Änderung erfolgreich gesichert..."; + else + echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)

    \n". + mysql_error($con). "

    \n[$chsql]"; + SetHeaderGo2Back(); + } }// IF-ELSE include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php old mode 100755 new mode 100644 index ebbe1e36..09006675 --- a/www-ssl/admin/room.php +++ b/www-ssl/admin/room.php @@ -9,36 +9,36 @@ $Erg = mysql_query($Sql, $con); if( !IsSet($_GET["action"]) ) { - echo "Hallo ".$_SESSION['Nick']. - ",
    \nhier hast du die Möglichkeit, neue Räume für die Schichtpläne einzutragen ". - "oder vorhandene abzuändern:

    \n"; - - echo "- Neuen Raum/Ort eintragen
    \n"; - - echo "\n"; - echo "\n"; - - for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) - { - if( substr( mysql_field_name($Erg, $i), 0, 12) == "DEFAULT_EID_") - echo "\t"; - else - echo "\t"; - } - echo "\t"; - echo ""; - - for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) - { - echo "\t\n"; - for ($j = 1; $j < mysql_num_fields($Erg); $j++) - { - echo "\t\t\n"; - } - echo "\t\t\n"; - echo "\t\n"; - } // ende Auflistung Raeume - echo "
    Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $i), 12)]. "". mysql_field_name($Erg, $i)."Ändern
    ".mysql_result($Erg, $t, $j)."###
    "; + echo "Hallo ".$_SESSION['Nick']. + ",
    \nhier hast du die Möglichkeit, neue Räume für die Schichtpläne einzutragen ". + "oder vorhandene abzuändern:

    \n"; + + echo "- Neuen Raum/Ort eintragen
    \n"; + + echo "\n"; + echo "\n"; + + for( $i = 1; $i < mysql_num_fields($Erg); $i++ ) + { + if( substr( mysql_field_name($Erg, $i), 0, 12) == "DEFAULT_EID_") + echo "\t"; + else + echo "\t"; + } + echo "\t"; + echo ""; + + for( $t = 0; $t < mysql_num_rows($Erg); $t++ ) + { + echo "\t\n"; + for ($j = 1; $j < mysql_num_fields($Erg); $j++) + { + echo "\t\t\n"; + } + echo "\t\t\n"; + echo "\t\n"; + } // ende Auflistung Raeume + echo "
    Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $i), 12)]. "". mysql_field_name($Erg, $i)."Ändern
    ".mysql_result($Erg, $t, $j)."###
    "; } else { @@ -48,132 +48,132 @@ UnSet($SQL); switch ($_GET["action"]) { case 'new': - echo "Neuen Raum einrichten:
    "; - echo "
    \n"; - echo "\n"; - - for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) - { - if( (mysql_field_name($Erg, $Uj) == "show") || (mysql_field_name($Erg, $Uj) == "FromPentabarf") ) - { - echo "". - "\n"; - } - else - { - //sonderfall fuer Default Engel - if( substr( mysql_field_name($Erg, $Uj), 0, 12) == "DEFAULT_EID_") - $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $Uj), 12)]; - else - $FeldName = mysql_field_name($Erg, $Uj); - - echo "". - "\n"; - } - } - echo "
    ". mysql_field_name($Erg, $Uj). "". - "Yes". - "No". - "
    $FeldName"; - echo "
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; - break; + echo "Neuen Raum einrichten:
    "; + echo "
    \n"; + echo "\n"; + + for( $Uj = 1; $Uj < mysql_num_fields($Erg); $Uj++ ) + { + if( (mysql_field_name($Erg, $Uj) == "show") || (mysql_field_name($Erg, $Uj) == "FromPentabarf") ) + { + echo "". + "\n"; + } + else + { + //sonderfall fuer Default Engel + if( substr( mysql_field_name($Erg, $Uj), 0, 12) == "DEFAULT_EID_") + $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($Erg, $Uj), 12)]; + else + $FeldName = mysql_field_name($Erg, $Uj); + + echo "". + "\n"; + } + } + echo "
    ". mysql_field_name($Erg, $Uj). "". + "Yes". + "No". + "
    $FeldName"; + echo "
    \n"; + echo "\n"; + echo "\n"; + echo "
    "; + break; case 'newsave': - $vars = $_GET; - $count = count($vars) - 1; - $vars = array_splice($vars, 0, $count); - $Keys = ""; - $Values = ""; - foreach($vars as $key => $value) - { - $Keys .= ", `$key`"; - $Values .= ", '$value'"; - } - $SQL = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")"; - SetHeaderGo2Back(); - break; + $vars = $_GET; + $count = count($vars) - 1; + $vars = array_splice($vars, 0, $count); + $Keys = ""; + $Values = ""; + foreach($vars as $key => $value) + { + $Keys .= ", `$key`"; + $Values .= ", '$value'"; + } + $SQL = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")"; + SetHeaderGo2Back(); + break; case 'change': - if (! IsSet($_GET["RID"])) - echo "Fehlerhafter Aufruf!"; - else - { - $SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; - $ERG = mysql_query($SQL2, $con); - - if( mysql_num_rows( $ERG)>0) - { - echo "Raum abändern:\n"; - echo "Hier kannst du eintragen, welche und wieviele Engel für den Raum zur Verf?gung stehen müssen."; - echo "
    \n"; - echo "\n"; - - for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) - { - if( (mysql_field_name($ERG, $Uj) == "show") || (mysql_field_name($ERG, $Uj) == "FromPentabarf") ) - { - echo "". - "\n"; - } - else - { - if( substr( mysql_field_name($ERG, $Uj), 0, 12) == "DEFAULT_EID_") - //sonderfall fuer Default Engel - $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($ERG, $Uj), 12)]; - else - $FeldName = mysql_field_name($ERG, $Uj); - echo "". - "\n"; - } - } - echo "
    ". mysql_field_name($Erg, $Uj). "". - "Yes". - "No". - "
    $FeldName". - "
    \n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "
    "; - echo "
    \n"; - echo "\n"; - echo "\n"; - echo ""; - echo "
    "; - } - else - echo "FEHLER: Room ID ". $_GET["RID"]. " nicht gefunden"; - } - break; - + if (! IsSet($_GET["RID"])) + echo "Fehlerhafter Aufruf!"; + else + { + $SQL2 = "SELECT * FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; + $ERG = mysql_query($SQL2, $con); + + if( mysql_num_rows( $ERG)>0) + { + echo "Raum abändern:\n"; + echo "Hier kannst du eintragen, welche und wieviele Engel für den Raum zur Verf?gung stehen müssen."; + echo "
    \n"; + echo "\n"; + + for ($Uj = 1; $Uj < mysql_num_fields($ERG); $Uj++) + { + if( (mysql_field_name($ERG, $Uj) == "show") || (mysql_field_name($ERG, $Uj) == "FromPentabarf") ) + { + echo "". + "\n"; + } + else + { + if( substr( mysql_field_name($ERG, $Uj), 0, 12) == "DEFAULT_EID_") + //sonderfall fuer Default Engel + $FeldName = "Anzahl ". $EngelTypeID[substr( mysql_field_name($ERG, $Uj), 12)]; + else + $FeldName = mysql_field_name($ERG, $Uj); + echo "". + "\n"; + } + } + echo "
    ". mysql_field_name($Erg, $Uj). "". + "Yes". + "No". + "
    $FeldName". + "
    \n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
    "; + echo "
    \n"; + echo "\n"; + echo "\n"; + echo ""; + echo "
    "; + } + else + echo "FEHLER: Room ID ". $_GET["RID"]. " nicht gefunden"; + } + break; + case 'changesave': - $sql=""; - $vars = $_GET; - $count = count($vars) - 2; - $vars = array_splice($vars, 0, $count); - foreach($vars as $key => $value) - { - $keys = substr($key,1); - $sql .= ", `".$keys."`='".$value."' "; - } - $SQL = "UPDATE `Room` SET ". substr($sql, 2). " WHERE `RID`='". $_GET["eRID"]. "'"; - SetHeaderGo2Back(); - break; + $sql=""; + $vars = $_GET; + $count = count($vars) - 2; + $vars = array_splice($vars, 0, $count); + foreach($vars as $key => $value) + { + $keys = substr($key,1); + $sql .= ", `".$keys."`='".$value."' "; + } + $SQL = "UPDATE `Room` SET ". substr($sql, 2). " WHERE `RID`='". $_GET["eRID"]. "'"; + SetHeaderGo2Back(); + break; case 'delete': - if (IsSet($_GET["RID"])) { - $SQL="DELETE FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; - } else { - echo "Fehlerhafter Aufruf"; - } - SetHeaderGo2Back(); - break; + if (IsSet($_GET["RID"])) { + $SQL="DELETE FROM `Room` WHERE `RID`='". $_GET["RID"]. "'"; + } else { + echo "Fehlerhafter Aufruf"; + } + SetHeaderGo2Back(); + break; } //switch @@ -181,17 +181,17 @@ case 'delete': // Update ??? if (IsSet($SQL)){ -// echo $SQL; - // hier muesste das SQL ausgefuehrt werden... - $Erg = db_query($SQL, "exec SQL"); - if ($Erg == 1) - echo "Änderung wurde gesichert...
    "; - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)"; - echo "

    ".mysql_error( $con ). "
    ($SQL)
    "; - } -} // Ende Update +// echo $SQL; + // hier muesste das SQL ausgefuehrt werden... + $Erg = db_query($SQL, "exec SQL"); + if ($Erg == 1) + echo "Änderung wurde gesichert...
    "; + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)"; + echo "

    ".mysql_error( $con ). "
    ($SQL)
    "; + } +} // Ende Update } //IF IsSet($action) diff --git a/www-ssl/admin/schichtplan.1.php b/www-ssl/admin/schichtplan.1.php old mode 100755 new mode 100644 diff --git a/www-ssl/admin/schichtplan.php b/www-ssl/admin/schichtplan.php old mode 100755 new mode 100644 index ba2f8d66..af3cd7d4 --- a/www-ssl/admin/schichtplan.php +++ b/www-ssl/admin/schichtplan.php @@ -6,59 +6,59 @@ include ("../../../camp2011/includes/header.php"); function executeSQL( $SQL) { - global $DEBUG, $con; - - $Erg = mysql_query($SQL, $con); - if( $DEBUG ) - echo "DEBUG SQL: $SQL
    \n"; - if ($Erg == 1) - { - echo "SQL war erfolgreich"; - } - else - { - echo "SQL Fehler (". mysql_error($con).")" ; - } + global $debug, $con; + + $Erg = mysql_query($SQL, $con); + if( $debug ) + echo "DEBUG SQL: $SQL
    \n"; + if ($Erg == 1) + { + echo "SQL war erfolgreich"; + } + else + { + echo "SQL Fehler (". mysql_error($con).")" ; + } } if (!IsSet($_GET["action"])) { -echo "Hallo ".$_SESSION['Nick'].",
    \n"; -echo "hier kannst du Schichten anlegen, ändern oder löschen.

    "; -echo "Neue Schicht einplanen

    \n\n"; +echo "Hallo ".$_SESSION['Nick'].",
    \n"; +echo "hier kannst du Schichten anlegen, ändern oder löschen.

    "; +echo "Neue Schicht einplanen

    \n\n"; echo "
    \n"; ?> - - - - - - - - + + + + + + +\n"; - echo "\t\t\n"; - echo "\t\t\n"; + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; - $sql2= "SELECT `Name` FROM `Room` WHERE `RID`='".mysql_result($Erg, $i, "RID")."'"; - $Erg2 = mysql_query($sql2, $con); - if( mysql_num_rows($Erg2) > 0) - echo "\t\t\n"; - else - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; + $sql2= "SELECT `Name` FROM `Room` WHERE `RID`='".mysql_result($Erg, $i, "RID")."'"; + $Erg2 = mysql_query($sql2, $con); + if( mysql_num_rows($Erg2) > 0) + echo "\t\t\n"; + else + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; } echo "
    DatumRaumDauerÄndern
    DatumRaumDauerÄndern
    ".mysql_result($Erg, $i, "DateS")."
    ".mysql_result($Erg, $i, "DateS")."".mysql_result($Erg2, 0, "Name")."Unbenkannt (RID=". mysql_result($Erg, $i, "RID"). ")".mysql_result($Erg, $i, "Len")." Std. ####
    ".mysql_result($Erg2, 0, "Name")."Unbenkannt (RID=". mysql_result($Erg, $i, "RID"). ")".mysql_result($Erg, $i, "Len")." Std. ####
    \n"; @@ -75,317 +75,317 @@ UnSet($chSQL); switch ($_GET["action"]){ case 'change': - if ( !IsSet($_GET["SID"]) ) - { - echo "Fehlerhafter Aufruf!\n"; - } - else - { - - $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '". $_GET["SID"]. "' )"; - $Erg = mysql_query($sql, $con); + if ( !IsSet($_GET["SID"]) ) + { + echo "Fehlerhafter Aufruf!\n"; + } + else + { + + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '". $_GET["SID"]. "' )"; + $Erg = mysql_query($sql, $con); - echo "Schicht abändern:
    \n"; + echo "Schicht abändern:
    \n"; - // Anzeige Allgemeiner schaischt daten + // Anzeige Allgemeiner schaischt daten echo ""; echo "\n"; echo " ". - "\n"; - echo " \n"; + echo " \n"; - - echo " ". - "\n"; - echo " ". - "\n"; - echo " ". - "\n"; - if( $FromPentabarf == "Y") - { - echo " ". - "\n"; - } + $rowcount = mysql_num_rows($Erg2); + $FromPentabarf = "N"; + for( $i = 0; $i < $rowcount; $i++ ) + { + $RID=mysql_result($Erg2, $i, "RID"); + echo " \n"; + } + echo " \n\n"; + + echo " ". + "\n"; + echo " ". + "\n"; + echo " ". + "\n"; + if( $FromPentabarf == "Y") + { + echo " ". + "\n"; + } echo "
    Schichtbeginn
    Raum\n
    Raum\n\n
    Dauer in h
    Beschreibung
    URL

    !!! Imported from Pentabarf !!!

    Dauer in h
    Beschreibung
    URL

    !!! Imported from Pentabarf !!!

    \n"; - + echo "\n"; echo "\n"; echo "\n"; echo "
    \n\n"; - // Löschen - echo "
    \n"; + // Löschen + echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
    \n\n"; - - echo "ACHTUNG:
    \n"; - echo "Beim Löschen werden die bisher eingetragenen Engel für diese Schicht mitgelöscht.
    \n"; + + echo "ACHTUNG:
    \n"; + echo "Beim Löschen werden die bisher eingetragenen Engel für diese Schicht mitgelöscht.
    \n"; - echo "
    \n\n\n\n"; - - //Freie Engelschichten - $sql3 = "SELECT `TID` FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND `UID`='0'"; - $Erg3 = mysql_query($sql3, $con); - $rowcount = mysql_num_rows($Erg3); - - echo "Folgende Engelschichten sind noch nicht vergeben.\n"; - echo "Und koenen, wenn diese nSchicht nicht benoetigt wird geloet werden:
    \n"; - for ($j=0; $j < $rowcount; $j++) - { - $TID = mysql_result($Erg3, $j, 0); - echo "". - "freie ". TID2Type($TID). Get_Text("inc_schicht_Engel"). "schicht loeschen
    \n"; - } - echo "
    \n\n\n\n"; + echo "
    \n\n\n\n"; + + //Freie Engelschichten + $sql3 = "SELECT `TID` FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND `UID`='0'"; + $Erg3 = mysql_query($sql3, $con); + $rowcount = mysql_num_rows($Erg3); + + echo "Folgende Engelschichten sind noch nicht vergeben.\n"; + echo "Und koenen, wenn diese nSchicht nicht benoetigt wird geloet werden:
    \n"; + for ($j=0; $j < $rowcount; $j++) + { + $TID = mysql_result($Erg3, $j, 0); + echo "". + "freie ". TID2Type($TID). Get_Text("inc_schicht_Engel"). "schicht loeschen
    \n"; + } + echo "
    \n\n\n\n"; - //Ausgabe eingetragener schischten - $sql3 = "SELECT * FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND NOT `UID`='0'"; - $Erg3 = mysql_query($sql3, $con); - $rowcount = mysql_num_rows($Erg3); - - echo "Folgende Engel Sind fuer die Schicht eingetargen.\n"; - echo "Und koennen, wenn diese nicht zu Schicht erschienen sind ausgetragen werden:
    \n"; - echo "\n". - "". - "". - "". - "". - "". - ""; - - for ($j=0; $j < $rowcount; $j++) - { - $userUID=mysql_result($Erg3, $j, "UID"); - echo "\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; - } // FOR + //Ausgabe eingetragener schischten + $sql3 = "SELECT * FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND NOT `UID`='0'"; + $Erg3 = mysql_query($sql3, $con); + $rowcount = mysql_num_rows($Erg3); + + echo "Folgende Engel Sind fuer die Schicht eingetargen.\n"; + echo "Und koennen, wenn diese nicht zu Schicht erschienen sind ausgetragen werden:
    \n"; + echo "
    nicktypenormalfreeloader :-(
    ". UID2Nick($userUID). "". TID2Type(mysql_result($Erg3, $j, "TID")). Get_Text("inc_schicht_Engel"). "###-austragen-######-austragen-freeloader-###
    \n". + "". + "". + "". + "". + "". + ""; + + for ($j=0; $j < $rowcount; $j++) + { + $userUID=mysql_result($Erg3, $j, "UID"); + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; + } // FOR - echo "
    nicktypenormalfreeloader :-(
    ". UID2Nick($userUID). "". TID2Type(mysql_result($Erg3, $j, "TID")). Get_Text("inc_schicht_Engel"). "###-austragen-######-austragen-freeloader-###

    \n\n\n\n"; + echo "
    \n\n\n\n"; - //Nachtragen von Engeln - echo "Hat ein anderer Engel die Schicht übernommen, trage ihn bitte ein:"; - echo "
    \n"; - echo "\n"; + //Nachtragen von Engeln + echo "Hat ein anderer Engel die Schicht übernommen, trage ihn bitte ein:"; + echo "\n"; + echo "\n"; echo "\n"; - - // Listet alle Nicks auf - echo "\n"; - - echo " als \n"; - - // holt eine liste der benötigten Engel zu dieser Schischt - $sql3 = "SELECT Count(`TID`) AS `CTID`, `TID` FROM `ShiftEntry` "; - $sql3.= "WHERE (`SID`='". $_GET["SID"]. "' AND `UID`='0') "; - $sql3.= "GROUP BY `SID`, `TID`, `UID` "; - $Erg3 = mysql_query($sql3, $con); - $i=-1; - while( ++$i < mysql_num_rows($Erg3)) - { - $EngelNeed[mysql_result($Erg3, $i, "TID")] = mysql_result($Erg3, $i, "CTID"); - } - - // Gibt dei möglich Engeltypen aus und zeigt wíefiel noch beötigt werden - echo "\n"; + if( $FromPentabarf != "Y") + { + echo "\t\n"; + } + + $usql="SELECT * FROM `User` ORDER BY `Nick`"; + $uErg = mysql_query($usql, $con); + $urowcount = mysql_num_rows($uErg); + for ($k=0; $k<$urowcount; $k++) + { + echo "\t\n"; + } + echo "\n"; + + echo " als \n"; + + // holt eine liste der benötigten Engel zu dieser Schischt + $sql3 = "SELECT Count(`TID`) AS `CTID`, `TID` FROM `ShiftEntry` "; + $sql3.= "WHERE (`SID`='". $_GET["SID"]. "' AND `UID`='0') "; + $sql3.= "GROUP BY `SID`, `TID`, `UID` "; + $Erg3 = mysql_query($sql3, $con); + $i=-1; + while( ++$i < mysql_num_rows($Erg3)) + { + $EngelNeed[mysql_result($Erg3, $i, "TID")] = mysql_result($Erg3, $i, "CTID"); + } + + // Gibt dei möglich Engeltypen aus und zeigt wíefiel noch beötigt werden + echo "\n"; - - echo "\n"; - - echo "
    \n Anzahl New\n"; - - echo "
    "; + echo "\n"; + + echo "\n"; + + echo "
    \n Anzahl New\n"; + + echo ""; - } // IF ISSET( - break; + } // IF ISSET( + break; case 'engeladd': - if( $_GET["UIDs"]>0) - { - - $SQL = "SELECT * FROM `ShiftEntry` ". - "WHERE (`SID`='". $_GET["SID"]. "' AND `TID`='". $_GET["TID"]. "' AND `UID`='0')"; - $ERG = mysql_query($SQL, $con); - if( mysql_num_rows($ERG) != 0 ) - { - $chSQL = "UPDATE `ShiftEntry` SET ". - "`UID`='". $_GET["UIDs"]. "', `Comment`='shift added by ".$_SESSION['Nick']."' ". - "WHERE (`SID`='". $_GET["SID"]. "' AND ". - "`TID`='". $_GET["TID"]. "' AND `UID`='0' ) LIMIT 1"; - } - else - { - $chSQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (". - "'". $_GET["SID"]. "', '". $_GET["TID"]. "', ". - "'". $_GET["UIDs"]. "', 'shift added by ".$_SESSION['Nick']."')"; - } - echo "Es wird folgende Schicht zusätzlich eingetragen:
    \n"; - echo "Engel: ".UID2Nick($_GET["UIDs"])."
    \n"; - echo "Bemerkung: Schicht eingetragen durch Erzengel ".$_SESSION['Nick']."
    \n
    \n"; - } - else - { - echo "Es wird folgende Schicht wurde ". $_GET["eAnzahlNew"]. "x zusätzlich eingetragen:
    \n"; - for( $i=0; $i<$_GET["eAnzahlNew"]; $i++) - { - echo "$i.
    \n"; - $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES ("; - $SQL .= "'". $_GET["SID"]. "', '". $_GET["TID"]. "', '0', NULL)"; - $ERG = mysql_query($SQL, $con); - if( $DEBUG ) - echo "DEBUG SQL: $SQL
    \n"; - if ($ERG == 1) - { - echo "Änderung wurde gesichert...
    "; - } - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)
    "; - echo mysql_error($con); - } - echo "Es wird eine weitere Schicht eingetragen:

    \n"; - } - } - break; + if( $_GET["UIDs"]>0) + { + + $SQL = "SELECT * FROM `ShiftEntry` ". + "WHERE (`SID`='". $_GET["SID"]. "' AND `TID`='". $_GET["TID"]. "' AND `UID`='0')"; + $ERG = mysql_query($SQL, $con); + if( mysql_num_rows($ERG) != 0 ) + { + $chSQL = "UPDATE `ShiftEntry` SET ". + "`UID`='". $_GET["UIDs"]. "', `Comment`='shift added by ".$_SESSION['Nick']."' ". + "WHERE (`SID`='". $_GET["SID"]. "' AND ". + "`TID`='". $_GET["TID"]. "' AND `UID`='0' ) LIMIT 1"; + } + else + { + $chSQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES (". + "'". $_GET["SID"]. "', '". $_GET["TID"]. "', ". + "'". $_GET["UIDs"]. "', 'shift added by ".$_SESSION['Nick']."')"; + } + echo "Es wird folgende Schicht zusätzlich eingetragen:
    \n"; + echo "Engel: ".UID2Nick($_GET["UIDs"])."
    \n"; + echo "Bemerkung: Schicht eingetragen durch Erzengel ".$_SESSION['Nick']."
    \n
    \n"; + } + else + { + echo "Es wird folgende Schicht wurde ". $_GET["eAnzahlNew"]. "x zusätzlich eingetragen:
    \n"; + for( $i=0; $i<$_GET["eAnzahlNew"]; $i++) + { + echo "$i.
    \n"; + $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`, `UID`, `Comment`) VALUES ("; + $SQL .= "'". $_GET["SID"]. "', '". $_GET["TID"]. "', '0', NULL)"; + $ERG = mysql_query($SQL, $con); + if( $debug ) + echo "DEBUG SQL: $SQL
    \n"; + if ($ERG == 1) + { + echo "Änderung wurde gesichert...
    "; + } + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)
    "; + echo mysql_error($con); + } + echo "Es wird eine weitere Schicht eingetragen:

    \n"; + } + } + break; case 'engeldel': - $chSQL = "UPDATE `ShiftEntry` SET `UID`='0', `Comment`= 'NULL' WHERE (`SID`='". $_GET["SID"]. - "' AND `UID`='". $_GET["UIDs"]. "') LIMIT 1"; - if( isset($_GET["freeloader"]) && $_GET["freeloader"]==1) - { - $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '". $_GET["SID"]. "' )"; - $Erg = mysql_query($sql, $con); - if( mysql_num_rows( $Erg) == 1) - { - $UID = $_GET["UIDs"]; - $Length = mysql_result($Erg, 0, "Len"); - $Comment = "Start: ". mysql_result($Erg, 0, "DateS"). "; ". - "Beschreibung: ". mysql_result($Erg, 0, "Man"). "; ". - "Removed by ". $_SESSION['Nick']; - $ch2SQL = - "INSERT INTO `ShiftFreeloader` (`Remove_Time`, `UID`, `Length`, `Comment`) ". - "VALUES ( CURRENT_TIMESTAMP, '$UID', '$Length', '$Comment');"; - } - } - break; + $chSQL = "UPDATE `ShiftEntry` SET `UID`='0', `Comment`= 'NULL' WHERE (`SID`='". $_GET["SID"]. + "' AND `UID`='". $_GET["UIDs"]. "') LIMIT 1"; + if( isset($_GET["freeloader"]) && $_GET["freeloader"]==1) + { + $sql = "SELECT * FROM `Shifts` WHERE (`SID` = '". $_GET["SID"]. "' )"; + $Erg = mysql_query($sql, $con); + if( mysql_num_rows( $Erg) == 1) + { + $UID = $_GET["UIDs"]; + $Length = mysql_result($Erg, 0, "Len"); + $Comment = "Start: ". mysql_result($Erg, 0, "DateS"). "; ". + "Beschreibung: ". mysql_result($Erg, 0, "Man"). "; ". + "Removed by ". $_SESSION['Nick']; + $ch2SQL = + "INSERT INTO `ShiftFreeloader` (`Remove_Time`, `UID`, `Length`, `Comment`) ". + "VALUES ( CURRENT_TIMESTAMP, '$UID', '$Length', '$Comment');"; + } + } + break; case 'engelshiftdel': - $chSQL = "DELETE FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND `TID`='". - $_GET["TID"]. "' AND `UID`='0' LIMIT 1"; - break; + $chSQL = "DELETE FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "' AND `TID`='". + $_GET["TID"]. "' AND `UID`='0' LIMIT 1"; + break; case 'changesave': - $query = mysql_query("SELECT DATE_ADD('". $_GET["eDate"]. "', INTERVAL '+0 ". $_GET["eDauer"]. "' DAY_HOUR)", $con); - $enddate = mysql_fetch_row($query); - - $chSQL = "UPDATE `Shifts` SET ". - "`DateS`='". $_GET["eDate"]. "', ". - "`DateE`='".$enddate[0]. "', ". - "`RID`='". $_GET["eRID"]. "', ". - "`Len`='". $_GET["eDauer"]. "', ". - "`Man`='". $_GET["eName"]. "', ". - "`URL`='". $_GET["eURL"]. "' ". - "WHERE `SID`='". $_GET["SID"]. "'"; - SetHeaderGo2Back(); - break; - + $query = mysql_query("SELECT DATE_ADD('". $_GET["eDate"]. "', INTERVAL '+0 ". $_GET["eDauer"]. "' DAY_HOUR)", $con); + $enddate = mysql_fetch_row($query); + + $chSQL = "UPDATE `Shifts` SET ". + "`DateS`='". $_GET["eDate"]. "', ". + "`DateE`='".$enddate[0]. "', ". + "`RID`='". $_GET["eRID"]. "', ". + "`Len`='". $_GET["eDauer"]. "', ". + "`Man`='". $_GET["eName"]. "', ". + "`URL`='". $_GET["eURL"]. "' ". + "WHERE `SID`='". $_GET["SID"]. "'"; + SetHeaderGo2Back(); + break; + case 'delete': - $chSQL = "DELETE FROM `Shifts` WHERE `SID`='". $_GET["SID"]. "' LIMIT 1"; - $ch2SQL = "DELETE FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "'"; - SetHeaderGo2Back(); - break; + $chSQL = "DELETE FROM `Shifts` WHERE `SID`='". $_GET["SID"]. "' LIMIT 1"; + $ch2SQL = "DELETE FROM `ShiftEntry` WHERE `SID`='". $_GET["SID"]. "'"; + SetHeaderGo2Back(); + break; case 'deleteShifs': - foreach ($_GET as $k => $v) - if( strpos( " ".$k, "SID") == 1) - { - echo "Shifts $v wird gelöscht..."; - executeSQL( "DELETE FROM `Shifts` WHERE `SID`='$v' LIMIT 1"); - echo "
    \n"; - echo "ShiftEntry $v wird gelöscht..."; - executeSQL( "DELETE FROM `ShiftEntry` WHERE `SID`='$v'"); - echo "

    \n"; - } - break; + foreach ($_GET as $k => $v) + if( strpos( " ".$k, "SID") == 1) + { + echo "Shifts $v wird gelöscht..."; + executeSQL( "DELETE FROM `Shifts` WHERE `SID`='$v' LIMIT 1"); + echo "
    \n"; + echo "ShiftEntry $v wird gelöscht..."; + executeSQL( "DELETE FROM `ShiftEntry` WHERE `SID`='$v'"); + echo "

    \n"; + } + break; } // end switch if (IsSet($chSQL)){ // echo $chSQL; - // hier muesste das SQL ausgefuehrt werden... - $Erg = mysql_query($chSQL, $con); - if( $DEBUG ) - echo "DEBUG SQL: $chSQL
    \n"; - if ($Erg == 1) - { - echo "Änderung wurde gesichert...
    "; - if( $DEBUG ) - echo "DEBUG: ergebniss". $Erg. "
    \n"; - if (IsSet($ch2SQL)) - { - $Erg = mysql_query($ch2SQL, $con); - if( $DEBUG ) - echo "DEBUG SQL: $ch2SQL
    \n"; - if( $DEBUG ) echo "DEBUG: ergebniss". $Erg. "
    \n"; - } - } - else - { - echo "Fehler beim speichern... bitte noch ein mal probieren :)
    "; - echo mysql_error($con); - } + // hier muesste das SQL ausgefuehrt werden... + $Erg = mysql_query($chSQL, $con); + if( $debug ) + echo "DEBUG SQL: $chSQL
    \n"; + if ($Erg == 1) + { + echo "Änderung wurde gesichert...
    "; + if( $debug ) + echo "DEBUG: ergebniss". $Erg. "
    \n"; + if (IsSet($ch2SQL)) + { + $Erg = mysql_query($ch2SQL, $con); + if( $debug ) + echo "DEBUG SQL: $ch2SQL
    \n"; + if( $debug ) echo "DEBUG: ergebniss". $Erg. "
    \n"; + } + } + else + { + echo "Fehler beim speichern... bitte noch ein mal probieren :)
    "; + echo mysql_error($con); + } } // Ende Update } diff --git a/www-ssl/admin/schichtplan_druck.1.php b/www-ssl/admin/schichtplan_druck.1.php old mode 100755 new mode 100644 diff --git a/www-ssl/admin/schichtplan_druck.php b/www-ssl/admin/schichtplan_druck.php old mode 100755 new mode 100644 index 23e65166..ef097043 --- a/www-ssl/admin/schichtplan_druck.php +++ b/www-ssl/admin/schichtplan_druck.php @@ -6,49 +6,49 @@ $submenus = 1; if (!IsSet($_GET["action"])) { - include ("../../../camp2011/includes/header.php"); - include ("../../../camp2011/includes/funktionen.php"); - include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); - include ("../../../camp2011/includes/funktion_schichtplan.php"); - - echo "Hallo ". $_SESSION['Nick']. "
    \n". - "auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. Wähle hierfür ein Datum und den Raum:\n". - "
    \n"; - - foreach( $VeranstaltungsTage as $k => $v) - { - - $res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY `Name`;",$con); - for ($i = 0; $i < mysql_num_rows($res); $i++) - { - $Tag = $VeranstaltungsTage[$k]; - $RID = mysql_result($res,$i,"RID"); - $Rname = mysql_result($res, $i, "Name"); - echo "\t$Tag $Rname
    \n"; - } - echo "
    \n"; - } - echo "

    "; - - include ("../../../camp2011/includes/footer.php"); + include ("../../../camp2011/includes/header.php"); + include ("../../../camp2011/includes/funktionen.php"); + include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); + include ("../../../camp2011/includes/funktion_schichtplan.php"); + + echo "Hallo ". $_SESSION['Nick']. "
    \n". + "auf dieser Seite kannst du dir den Schichtplan in einer Druckansicht generieren lassen. Wähle hierfür ein Datum und den Raum:\n". + "
    \n"; + + foreach( $VeranstaltungsTage as $k => $v) + { + + $res = mysql_query("SELECT Name, RID FROM `Room` WHERE `show`!='N' ORDER BY `Name`;",$con); + for ($i = 0; $i < mysql_num_rows($res); $i++) + { + $Tag = $VeranstaltungsTage[$k]; + $RID = mysql_result($res,$i,"RID"); + $Rname = mysql_result($res, $i, "Name"); + echo "\t$Tag $Rname
    \n"; + } + echo "
    \n"; + } + echo "

    "; + + include ("../../../camp2011/includes/footer.php"); } -else //################################################################# +else //################################################################# { if (IsSet($_GET["Raum"]) AND IsSet($_GET["ausdatum"])) - { - $Raum = $_GET["Raum"]; - $ausdatum = $_GET["ausdatum"]; - - include ("../../../camp2011/includes/config_db.php"); - include ("../../../camp2011/includes/config.php"); - include ("../../../camp2011/includes/secure.php"); - //var wird nur gesetzt immer edit auszublenden, achtung sesion darf nicht gestart sein !!! - $_SESSION['CVS'][ "admin/schichtplan.php" ] = "N"; - include ("../../../camp2011/includes/funktion_lang.php"); - include ("../../../camp2011/includes/funktion_schichtplan.php"); - include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); - include ("../../../camp2011/includes/funktion_user.php"); - ?> + { + $Raum = $_GET["Raum"]; + $ausdatum = $_GET["ausdatum"]; + + include ("../../../camp2011/includes/config_db.php"); + include ("../../../camp2011/includes/config.php"); + include ("../../../camp2011/includes/secure.php"); + //var wird nur gesetzt immer edit auszublenden, achtung sesion darf nicht gestart sein !!! + $_SESSION['CVS'][ "admin/schichtplan.php" ] = "N"; + include ("../../../camp2011/includes/funktion_lang.php"); + include ("../../../camp2011/includes/funktion_schichtplan.php"); + include ("../../../camp2011/includes/funktion_schichtplan_aray.php"); + include ("../../../camp2011/includes/funktion_user.php"); + ?> @@ -67,55 +67,55 @@ else //#################################################################

    Schichtplan

    - - - - + + + +
    - Datum: - - - Raum: - -
    + Datum: + + + Raum: + +
    - - - - - + + + +\n"; - if( $j==0) - { - $Spalten[$i * $GlobalZeileProStunde + $j].= - "\t\t\n"; - - } - } + for( $j = 0; $j < $GlobalZeileProStunde; $j++) + { + $Spalten[$i * $GlobalZeileProStunde + $j] = + "\t\n"; + if( $j==0) + { + $Spalten[$i * $GlobalZeileProStunde + $j].= + "\t\t\n"; + + } + } CreateRoomShifts( $Raum ); // Ausgabe Zeilen - for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) echo $Spalten[$i]; + for ($i = 0; $i < (24 * $GlobalZeileProStunde); $i++) echo $Spalten[$i]; // Ende echo "
    UhrzeitSchichtplanbelegung
    UhrzeitSchichtplanbelegung
    "; - if( $i < 10 ) - $Spalten[$i * $GlobalZeileProStunde + $j].= "0"; - $Spalten[$i * $GlobalZeileProStunde + $j].= "$i:"; - if( ( ($j*60) / $GlobalZeileProStunde) < 10 ) - $Spalten[$i * $GlobalZeileProStunde + $j].= "0"; - $Spalten[$i * $GlobalZeileProStunde + $j].= - ( ($j*60) / $GlobalZeileProStunde). "
    "; + if( $i < 10 ) + $Spalten[$i * $GlobalZeileProStunde + $j].= "0"; + $Spalten[$i * $GlobalZeileProStunde + $j].= "$i:"; + if( ( ($j*60) / $GlobalZeileProStunde) < 10 ) + $Spalten[$i * $GlobalZeileProStunde + $j].= "0"; + $Spalten[$i * $GlobalZeileProStunde + $j].= + ( ($j*60) / $GlobalZeileProStunde). "
    \n"; diff --git a/www-ssl/admin/shiftadd.php b/www-ssl/admin/shiftadd.php old mode 100755 new mode 100644 index 7c64543f..34c248fa --- a/www-ssl/admin/shiftadd.php +++ b/www-ssl/admin/shiftadd.php @@ -6,61 +6,61 @@ include ("../../../camp2011/includes/header.php"); $Time = time()+3600+3600; -echo "Hallo ".$_SESSION['Nick'].",
    \n"; +echo "Hallo ".$_SESSION['Nick'].",
    \n"; // erstellt ein Array der Reume - $sql = "SELECT `RID`, `Name` FROM `Room` ORDER BY `Name`"; - $Erg = mysql_query($sql, $con); - $rowcount = mysql_num_rows($Erg); + $sql = "SELECT `RID`, `Name` FROM `Room` ORDER BY `Name`"; + $Erg = mysql_query($sql, $con); + $rowcount = mysql_num_rows($Erg); - for ($i=0; $i<$rowcount; $i++) - { - $Room[$i]["RID"] = mysql_result($Erg, $i, "RID"); - $Room[$i]["Name"] = mysql_result($Erg, $i, "Name"); - } + for ($i=0; $i<$rowcount; $i++) + { + $Room[$i]["RID"] = mysql_result($Erg, $i, "RID"); + $Room[$i]["Name"] = mysql_result($Erg, $i, "Name"); + } // erstellt ein Aray der Engeltypen - $sql = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`"; - $Erg = mysql_query($sql, $con); - $rowcount = mysql_num_rows($Erg); + $sql = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`"; + $Erg = mysql_query($sql, $con); + $rowcount = mysql_num_rows($Erg); - for ($i=0; $i<$rowcount; $i++) - { - $EngelType[$i]["TID"] = mysql_result($Erg, $i, "TID"); - $EngelType[$i]["Name"] = mysql_result($Erg, $i, "Name").Get_Text("inc_schicht_engel"); - } + for ($i=0; $i<$rowcount; $i++) + { + $EngelType[$i]["TID"] = mysql_result($Erg, $i, "TID"); + $EngelType[$i]["Name"] = mysql_result($Erg, $i, "Name").Get_Text("inc_schicht_engel"); + } // sesion mit stanadrt werten befüllen if( !isset( $_SESSION['shiftadd.php']['SchichtName'])) { - $_SESSION['shiftadd.php']['SchichtName'] = "--???--"; - $_SESSION['shiftadd.php']['RID'] = ""; - $_SESSION['shiftadd.php']['MonthJahr'] = gmdate("Y-m", $Time); - $_SESSION['shiftadd.php']['SDatum'] = gmdate("d", $Time); - $_SESSION['shiftadd.php']['STime'] = "10"; - $_SESSION['shiftadd.php']['MoreThenOne'] = "ON"; - $_SESSION['shiftadd.php']['EDatum'] = gmdate("d", $Time); - $_SESSION['shiftadd.php']['ETime'] = "12"; - $_SESSION['shiftadd.php']['len'] = "2"; - $_SESSION['shiftadd.php']['NachtON'] = "OFF"; - $_SESSION['shiftadd.php']['len_night'] = "00-04-08-10-12-14-16-18-20-22-24"; + $_SESSION['shiftadd.php']['SchichtName'] = "--???--"; + $_SESSION['shiftadd.php']['RID'] = ""; + $_SESSION['shiftadd.php']['MonthJahr'] = gmdate("Y-m", $Time); + $_SESSION['shiftadd.php']['SDatum'] = gmdate("d", $Time); + $_SESSION['shiftadd.php']['STime'] = "10"; + $_SESSION['shiftadd.php']['MoreThenOne'] = "ON"; + $_SESSION['shiftadd.php']['EDatum'] = gmdate("d", $Time); + $_SESSION['shiftadd.php']['ETime'] = "12"; + $_SESSION['shiftadd.php']['len'] = "2"; + $_SESSION['shiftadd.php']['NachtON'] = "OFF"; + $_SESSION['shiftadd.php']['len_night'] = "00-04-08-10-12-14-16-18-20-22-24"; } // wenn werte übergeben in sesion eintragen if( !isset($_GET["NachtON"])) - $_GET["NachtON"] = "OFF"; + $_GET["NachtON"] = "OFF"; if( !isset($_GET["MoreThenOne"])) - $_GET["MoreThenOne"] = "OFF"; + $_GET["MoreThenOne"] = "OFF"; if( isset( $_GET["SchichtName"])) { - foreach ($_GET as $k => $v) - { - $_SESSION['shiftadd.php'][$k] = $v; - } + foreach ($_GET as $k => $v) + { + $_SESSION['shiftadd.php'][$k] = $v; + } } if (!IsSet($_GET["action"])) - $_GET["action"] = "new"; + $_GET["action"] = "new"; switch( $_GET["action"]) { @@ -70,187 +70,187 @@ Hier kannst du neue Schichten eintragen. Dazu musst du den Anfang und das Ende d Über die Länge der Schichten errechnet sich dadurch die Anzahl dieser. Dadurch können gleich mehrere Schichten auf einmal erfasst werden: -
    + - + - + - + - + - + - + - + - + -\n"; - echo " \n"; - } +\n"; + echo " \n"; + } ?>
    Name:">">
    Ort:
    Zeit:
    Month.Jahr:">">
    Beginn:Date"> - Time">Date"> + Time">
    More then One>>
    End:Date"> - Time">Date"> + Time">
    Länge in h:">">
    Sonderschichten ein:>>
    Sonder in h (Time;Time):">">
    Anzahl Engel je Type:
    ". $TTemp["Name"]. ":". $TTemp["Name"]. ":
    -
    +
    - 0)) { - $lenOrg = $_GET["len"]; - if( $_GET["NachtON"] == "ON" ) - { - $lenArrayDummy = explode( "-", $_GET["len_night"]); + $lenOrg = $_GET["len"]; + if( $_GET["NachtON"] == "ON" ) + { + $lenArrayDummy = explode( "-", $_GET["len_night"]); foreach ( $lenArrayDummy as $Temp ) { - if( isset($Temp2) ) - $lenArray[intval($Temp2)] = intval($Temp)-intval($Temp2); - $Temp2 = $Temp; - }//foreach - }//IF( $NachtON == "ON" ) - - echo "\n"; - echo "\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\n"; - - $DateEnd = $_GET["SDatum"]; - $TimeEnd = intval($_GET["STime"]); - $len=0; - do - { - // define Start time - $Date = $DateEnd; - $Time = $TimeEnd; - $_DateS = $_GET["MonthJahr"]. "-". $Date. " ". $Time. ":00:00"; - - // define End time - if( $_GET["NachtON"] == "ON" ) - { - if( !isset($lenArray[$Time])) die("Zeit $Time h nicht definiert."); - $_GET["len"] = $lenArray[$Time]; - if( $_GET["len"]<1) die("len <1"); - } - $TimeEnd = $Time+ $_GET["len"]; - - //Tagesüberschreitung - while( $TimeEnd >= 24 ) - { - $TimeEnd -= 24; - $DateEnd += 1; - } - //ist schischt zu lang dan verkürzen - if( $DateEnd > $_GET["EDatum"] || ($DateEnd == $_GET["EDatum"] && $TimeEnd >= $_GET["ETime"]) ) - { - $_GET["len"] -= ($DateEnd- $_GET["EDatum"])*24; - $_GET["len"] -= ($TimeEnd- $_GET["ETime"]); // -(-) ->> + - $DateEnd = $_GET["EDatum"]; - $TimeEnd = $_GET["ETime"]; - } - $_DateE = $_GET["MonthJahr"]. "-". $DateEnd. " ". $TimeEnd. ":00:00"; - - if( $_DateS != $_DateE ) - CreateNewEntry(); - - if( $_GET["MoreThenOne"]!="ON" ) break; - if( $DateEnd >= $_GET["EDatum"] && $TimeEnd >= intval($_GET["ETime"]) ) break; - } while( true ); - echo "
    StartEndlenRIDBeschreibungEntry 'Shifts'SIDEntrys
    "; - - if( $_GET["OnlyShow"]=="ON" ) - { - echo "
    "; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - echo "\n\t"; - foreach ($EngelType As $TTemp) - { - $Temp = "EngelType".$TTemp["TID"]; - echo "\n\t"; - } - echo "\n\t"; - echo "\n\t"; - echo "\n
    "; - } //if + if( isset($Temp2) ) + $lenArray[intval($Temp2)] = intval($Temp)-intval($Temp2); + $Temp2 = $Temp; + }//foreach + }//IF( $NachtON == "ON" ) + + echo "\n"; + echo "\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\n"; + + $DateEnd = $_GET["SDatum"]; + $TimeEnd = intval($_GET["STime"]); + $len=0; + do + { + // define Start time + $Date = $DateEnd; + $Time = $TimeEnd; + $_DateS = $_GET["MonthJahr"]. "-". $Date. " ". $Time. ":00:00"; + + // define End time + if( $_GET["NachtON"] == "ON" ) + { + if( !isset($lenArray[$Time])) die("Zeit $Time h nicht definiert."); + $_GET["len"] = $lenArray[$Time]; + if( $_GET["len"]<1) die("len <1"); + } + $TimeEnd = $Time+ $_GET["len"]; + + //Tagesüberschreitung + while( $TimeEnd >= 24 ) + { + $TimeEnd -= 24; + $DateEnd += 1; + } + //ist schischt zu lang dan verkürzen + if( $DateEnd > $_GET["EDatum"] || ($DateEnd == $_GET["EDatum"] && $TimeEnd >= $_GET["ETime"]) ) + { + $_GET["len"] -= ($DateEnd- $_GET["EDatum"])*24; + $_GET["len"] -= ($TimeEnd- $_GET["ETime"]); // -(-) ->> + + $DateEnd = $_GET["EDatum"]; + $TimeEnd = $_GET["ETime"]; + } + $_DateE = $_GET["MonthJahr"]. "-". $DateEnd. " ". $TimeEnd. ":00:00"; + + if( $_DateS != $_DateE ) + CreateNewEntry(); + + if( $_GET["MoreThenOne"]!="ON" ) break; + if( $DateEnd >= $_GET["EDatum"] && $TimeEnd >= intval($_GET["ETime"]) ) break; + } while( true ); + echo "
    StartEndlenRIDBeschreibungEntry 'Shifts'SIDEntrys
    "; + + if( $_GET["OnlyShow"]=="ON" ) + { + echo "
    "; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + echo "\n\t"; + foreach ($EngelType As $TTemp) + { + $Temp = "EngelType".$TTemp["TID"]; + echo "\n\t"; + } + echo "\n\t"; + echo "\n\t"; + echo "\n
    "; + } //if } //IF break; case 'engeldel': - break; + break; } // end switch @@ -258,100 +258,100 @@ case 'engeldel': function CreateNewEntry() { - global $con, $_DateS, $_DateE, $EngelType, $DEBUG; - foreach ($EngelType As $TTemp) - { - $Temp = "EngelType".$TTemp["TID"]; - global $$Temp; - } - - echo "\n"; - - echo "\t$_DateS\n"; - echo "\t$_DateE\n"; - echo "\t". $_GET["len"]. "\n"; - echo "\t". $_GET["RID"]. "\n"; - echo "\t". $_GET["SchichtName"]. "\n"; - - - // Ist eintarg schon vorhanden? - $SQL = "SELECT `SID` FROM `Shifts` "; - $SQL .= "WHERE (". - "`DateS` = '". $_DateS. "' AND ". - "`DateE` = '". $_DateE. "' AND ". - "`RID` = '". $_GET["RID"]. "');"; - $Erg = mysql_query($SQL, $con); - - if( mysql_num_rows($Erg) != 0 ) - echo "\texists"; - elseif( $_GET["OnlyShow"] == "OFF" ) - { - // erstellt Eintrag in Shifts für die algemeine schicht - $SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( "; - $SQL .= "'". $_DateS. "', '". $_DateE. "', "; - $SQL .= "'". $_GET["len"]. "', '". $_GET["RID"]. "', "; - $SQL .= "'". $_GET["SchichtName"]. "');"; - $Erg = db_query($SQL, "create shift"); - - $SQLFail = "\n\t
    [".$SQL. "]"; - - if ($Erg == 1) echo "\tpass\n"; - else echo "\tfail
    \n". mysql_error($con). "$SQLFail\n"; - - } else - echo "\tonly show\n"; - - // sucht SID von eingetragennen schiten - $SQL = "SELECT SID FROM `Shifts` "; - $SQL .= "WHERE (". - "`DateS` = '". $_DateS. "' AND ". - "`DateE` = '". $_DateE. "' AND ". - "`Len` = '". $_GET["len"]. "' AND ". - "`RID` = '". $_GET["RID"]. "');"; - $Erg = mysql_query($SQL, $con); - if( mysql_num_rows($Erg) == 0 ) - echo "\t?"; - else - { - $SID = mysql_result($Erg, 0, "SID"); - echo "\t". $SID. ""; - } - - // erstellt für jeden Engeltypen die eintrage in 'ShiftEntry' - echo "\t"; - foreach ($EngelType As $TTemp) - { - $Temp = "EngelType".$TTemp["TID"]; - - if( $_GET[$Temp] > 0 ) - { - $i = 0; - echo $_GET[$Temp]. " ".$TTemp["Name"]. "
    \t"; - while( $i++ < $_GET[$Temp] ) - { - if( $_GET["OnlyShow"] == "OFF" ) - { - $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES ("; - $SQL .= "'". $SID. "', "; - $SQL .= "'". $TTemp["TID"]. "');"; - - $Erg = mysql_query($SQL, $con); - - if( $DEBUG ) $SQLFail = "\n\t
    [".$SQL. "]"; - - if ($Erg == 1) echo "'pass' "; - else echo "'fail' ". mysql_error($con). "$SQLFail\n"; - - } - else - echo "+"; - } - echo "
    "; - } // IF $$TEMP - } // FOREACH - echo ""; - - echo "\n"; + global $con, $_DateS, $_DateE, $EngelType, $debug; + foreach ($EngelType As $TTemp) + { + $Temp = "EngelType".$TTemp["TID"]; + global $$Temp; + } + + echo "\n"; + + echo "\t$_DateS\n"; + echo "\t$_DateE\n"; + echo "\t". $_GET["len"]. "\n"; + echo "\t". $_GET["RID"]. "\n"; + echo "\t". $_GET["SchichtName"]. "\n"; + + + // Ist eintarg schon vorhanden? + $SQL = "SELECT `SID` FROM `Shifts` "; + $SQL .= "WHERE (". + "`DateS` = '". $_DateS. "' AND ". + "`DateE` = '". $_DateE. "' AND ". + "`RID` = '". $_GET["RID"]. "');"; + $Erg = mysql_query($SQL, $con); + + if( mysql_num_rows($Erg) != 0 ) + echo "\texists"; + elseif( $_GET["OnlyShow"] == "OFF" ) + { + // erstellt Eintrag in Shifts für die algemeine schicht + $SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( "; + $SQL .= "'". $_DateS. "', '". $_DateE. "', "; + $SQL .= "'". $_GET["len"]. "', '". $_GET["RID"]. "', "; + $SQL .= "'". $_GET["SchichtName"]. "');"; + $Erg = db_query($SQL, "create shift"); + + $SQLFail = "\n\t
    [".$SQL. "]"; + + if ($Erg == 1) echo "\tpass\n"; + else echo "\tfail
    \n". mysql_error($con). "$SQLFail\n"; + + } else + echo "\tonly show\n"; + + // sucht SID von eingetragennen schiten + $SQL = "SELECT SID FROM `Shifts` "; + $SQL .= "WHERE (". + "`DateS` = '". $_DateS. "' AND ". + "`DateE` = '". $_DateE. "' AND ". + "`Len` = '". $_GET["len"]. "' AND ". + "`RID` = '". $_GET["RID"]. "');"; + $Erg = mysql_query($SQL, $con); + if( mysql_num_rows($Erg) == 0 ) + echo "\t?"; + else + { + $SID = mysql_result($Erg, 0, "SID"); + echo "\t". $SID. ""; + } + + // erstellt für jeden Engeltypen die eintrage in 'ShiftEntry' + echo "\t"; + foreach ($EngelType As $TTemp) + { + $Temp = "EngelType".$TTemp["TID"]; + + if( $_GET[$Temp] > 0 ) + { + $i = 0; + echo $_GET[$Temp]. " ".$TTemp["Name"]. "
    \t"; + while( $i++ < $_GET[$Temp] ) + { + if( $_GET["OnlyShow"] == "OFF" ) + { + $SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES ("; + $SQL .= "'". $SID. "', "; + $SQL .= "'". $TTemp["TID"]. "');"; + + $Erg = mysql_query($SQL, $con); + + if( $debug ) $SQLFail = "\n\t
    [".$SQL. "]"; + + if ($Erg == 1) echo "'pass' "; + else echo "'fail' ". mysql_error($con). "$SQLFail\n"; + + } + else + echo "+"; + } + echo "
    "; + } // IF $$TEMP + } // FOREACH + echo ""; + + echo "\n"; } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/sprache.php b/www-ssl/admin/sprache.php old mode 100755 new mode 100644 index 050b0736..ebf1db32 --- a/www-ssl/admin/sprache.php +++ b/www-ssl/admin/sprache.php @@ -1,4 +1,4 @@ -\n"; - echo Get_Text("pub_sprache_text1")."

    \n"; + echo Get_Text("Hello").$_SESSION['Nick'].",
    \n"; + echo Get_Text("pub_sprache_text1")."

    \n"; - echo "". Get_Text("pub_sprache_ShowEntry"). ""; - // ausgabe Tabellenueberschift - $SQL_Sprachen = "SELECT `Sprache` FROM `Sprache` GROUP BY `Sprache`;"; - $erg_Sprachen = mysql_query($SQL_Sprachen, $con); - echo mysql_error($con); - - for( $i=0; $i". Get_Text("pub_sprache_ShowEntry"). ""; + // ausgabe Tabellenueberschift + $SQL_Sprachen = "SELECT `Sprache` FROM `Sprache` GROUP BY `Sprache`;"; + $erg_Sprachen = mysql_query($SQL_Sprachen, $con); + echo mysql_error($con); + + for( $i=0; $i\n\t\t"; - echo "\t\t". Get_Text("pub_sprache_TextID"). ""; - foreach( $Sprachen as $Name => $Value ) - echo "". - Get_Text("pub_sprache_Sprache"). " ". $Name. - ""; - echo "\t\t". Get_Text("pub_sprache_Edit"). ""; - echo "\t\t"; + echo "\t\n\t\t"; + echo "\t\t"; + foreach( $Sprachen as $Name => $Value ) + echo ""; + echo "\t\t"; + echo "\t\t"; - if( isset($_GET["ShowEntry"])) - { - // ausgabe eintraege - $SQL = "SELECT * FROM `Sprache` ORDER BY `TextID`;"; - $erg = mysql_query($SQL, $con); - echo mysql_error($con); + if( isset($_GET["ShowEntry"])) + { + // ausgabe eintraege + $SQL = "SELECT * FROM `Sprache` ORDER BY `TextID`;"; + $erg = mysql_query($SQL, $con); + echo mysql_error($con); - $TextID_Old = mysql_result( $erg, 0, "TextID" ); - for( $i=0; $i"; - echo "\n"; - echo "\t\t\n"; - - foreach( $Sprachen as $Name => $Value ) - { - $Value = html_entity_decode( $Value, ENT_QUOTES); - echo "\t\t\n"; - $Sprachen[ $Name ] = ""; - } - - echo "\t\t\n"; - echo ""; - echo "\n"; - $TextID_Old = $TextID_New; - } - $Sprachen[ mysql_result( $erg, $i, "Sprache" ) ] = mysql_result( $erg, $i, "Text" ); - } /*FOR*/ - } - - //fuer neu eintraege - echo ""; - echo "\n"; - echo "\t\t\n"; - - foreach( $Sprachen as $Name => $Value ) - echo "\t\t\n"; + $TextID_Old = mysql_result( $erg, 0, "TextID" ); + for( $i=0; $i"; + echo "\n"; + echo "\t\t\n"; + + foreach( $Sprachen as $Name => $Value ) + { + $Value = html_entity_decode( $Value, ENT_QUOTES); + echo "\t\t\n"; + $Sprachen[ $Name ] = ""; + } + + echo "\t\t\n"; + echo ""; + echo "\n"; + $TextID_Old = $TextID_New; + } + $Sprachen[ mysql_result( $erg, $i, "Sprache" ) ] = mysql_result( $erg, $i, "Text" ); + } /*FOR*/ + } + + //fuer neu eintraege + echo ""; + echo "\n"; + echo "\t\t\n"; + + foreach( $Sprachen as $Name => $Value ) + echo "\t\t\n"; - echo "\t\t\n"; - echo ""; - echo "\n"; - - - echo "
    ". Get_Text("pub_sprache_TextID"). "". + Get_Text("pub_sprache_Sprache"). " ". $Name. + "". Get_Text("pub_sprache_Edit"). "
    $TextID_Old ". - "
    $TextID_Old ". + "
    \n"; + echo "\t\t\n"; + echo ""; + echo "\n"; + + + echo "\n"; } /*if( !isset( $TextID ) )*/ else { - echo "edit: ". $_GET["TextID"]. "

    "; - foreach ($_GET as $k => $v) { - if( $k != "TextID" ) - { - $sql_test = "SELECT * FROM `Sprache` ". - "WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k'"; - $erg_test = mysql_query($sql_test, $con); + echo "edit: ". $_GET["TextID"]. "

    "; + foreach ($_GET as $k => $v) { + if( $k != "TextID" ) + { + $sql_test = "SELECT * FROM `Sprache` ". + "WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k'"; + $erg_test = mysql_query($sql_test, $con); - if( mysql_num_rows($erg_test)==0 ) - { - $sql_save = "INSERT INTO `Sprache` (`TextID`, `Sprache`, `Text`) ". - "VALUES ('". $_GET["TextID"]. "', '$k', '$v')"; - echo $sql_save."
    "; - $Erg = mysql_query($sql_save, $con); - if ($Erg == 1) - echo "\t $k Save: OK
    \n"; - else - echo "\t $k Save: KO
    \n"; - } - else if( mysql_result($erg_test, 0, "Text")!=$v ) - { - $sql_save = "UPDATE `Sprache` SET `Text`='$v' ". - "WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k' "; - echo $sql_save."
    "; - $Erg = mysql_query($sql_save, $con); - if ($Erg == 1) - echo "\t $k Update: OK
    \n"; - else - echo "\t $k Update: KO
    \n"; - } - else - echo "\t $k no changes
    \n"; - } - } - + if( mysql_num_rows($erg_test)==0 ) + { + $sql_save = "INSERT INTO `Sprache` (`TextID`, `Sprache`, `Text`) ". + "VALUES ('". $_GET["TextID"]. "', '$k', '$v')"; + echo $sql_save."
    "; + $Erg = mysql_query($sql_save, $con); + if ($Erg == 1) + echo "\t $k Save: OK
    \n"; + else + echo "\t $k Save: KO
    \n"; + } + else if( mysql_result($erg_test, 0, "Text")!=$v ) + { + $sql_save = "UPDATE `Sprache` SET `Text`='$v' ". + "WHERE `TextID`='". $_GET["TextID"]. "' AND `Sprache`='$k' "; + echo $sql_save."
    "; + $Erg = mysql_query($sql_save, $con); + if ($Erg == 1) + echo "\t $k Update: OK
    \n"; + else + echo "\t $k Update: KO
    \n"; + } + else + echo "\t $k no changes
    \n"; + } + } + } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/tshirt.php b/www-ssl/admin/tshirt.php old mode 100755 new mode 100644 index df33494d..6fc3551e --- a/www-ssl/admin/tshirt.php +++ b/www-ssl/admin/tshirt.php @@ -1,4 +1,4 @@ -"; + echo "Fehler beim speichern bei Engel ". UID2Nick($_GET["aktive"]). "
    "; } } ?> -Über die Suchen-Funktion des Browsers kann diese Liste schnell nach einem Nick abgesucht werden.
    -Hinter diesem erscheint ein Link, über den man eintragen kann, dass der Engel sein T-Shirt erhalten hat.

    +Über die Suchen-Funktion des Browsers kann diese Liste schnell nach einem Nick abgesucht werden.
    +Hinter diesem erscheint ein Link, über den man eintragen kann, dass der Engel sein T-Shirt erhalten hat.

    Liste aller aktiven Engel: - - - - - - -Nick + + + + +\n"; $eUID=mysql_result($Erg, $i, "UID"); @@ -45,9 +45,9 @@ for ($i=0; $i<$rowcount; $i++){ echo "\t\t\n"; if (mysql_result($Erg, $i, "Tshirt") =="1") { - echo "\t\t"; + echo "\t\t"; } else { - echo "\t\t"; + echo "\t\t"; } echo "\t\n"; } diff --git a/www-ssl/admin/user.php b/www-ssl/admin/user.php old mode 100755 new mode 100644 index b86c2382..7d7c3a62 --- a/www-ssl/admin/user.php +++ b/www-ssl/admin/user.php @@ -1,4 +1,4 @@ -Neuen Engel eintragen

    \n"; - - if( !isset($_GET["OrderBy"]) ) $_GET["OrderBy"] = "Nick"; - $SQL = "SELECT User.*, UserGroups.Name AS 'Group' FROM `User` ". - "LEFT JOIN `UserCVS` ON User.UID = UserCVS.UID ". - "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID ". - "ORDER BY `". $_GET["OrderBy"]. "` ASC"; - $Erg = mysql_query($SQL, $con); - echo mysql_error($con); - - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); - - echo "Anzahl Engel: $Zeilen

    \n"; - - ?>
    NickAktiv?GrösseT-Shirt ausgeben:Aktiv?GrösseT-Shirt ausgeben:".mysql_result($Erg, $i, "Size")."bereits erhaltenbereits erhaltenXXXXXXXXXXXXXXXX
    - - - - - - - - - - - - - - - - \n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - $Gekommen += mysql_result($Erg, $n, "Gekommen"); - echo "\t\n"; - $Active += mysql_result($Erg, $n, "Aktiv"); - echo "\t\n"; - $Tshirt += mysql_result($Erg, $n, "Tshirt"); - echo "\t\n"; - echo "\t\n"; - echo "\t\n"; - echo "\n"; - } - echo "". - "". - "\n"; - echo "\t
    - ?OrderBy=Nick">Nick | - ?OrderBy=CreateDate">CreateDate - ?OrderBy=Name">Name?OrderBy=Vorname">Vorname?OrderBy=Alter">Alter - ?OrderBy=email">@ | - ?OrderBy=DECT">DECT | - ?OrderBy=Hometown">Hometown | - ?OrderBy=lastLogIn">lastLogIn | - ?OrderBy=Art">Type | - ?OrderBy=ICQ">ICQ | - ?OrderBy=jabber">jabber | - ?OrderBy=Group">Group - ?OrderBy=Size">Größe?OrderBy=Gekommen">G?OrderBy=Aktiv">A?OrderBy=Tshirt">TÄnd.Secure
    ".mysql_result($Erg, $n, "Nick"). "
    (Create: ". mysql_result($Erg, $n, "CreateDate"). ")    		".mysql_result($Erg, $n, "Name")."".mysql_result($Erg, $n, "Vorname")."".mysql_result($Erg, $n, "Alter").""; - if( strlen( mysql_result($Erg, $n, "Telefon"))>0) - echo "\n\t\tTel: ". mysql_result($Erg, $n, "Telefon"). "
    "; - if( strlen( mysql_result($Erg, $n, "Handy"))>0) - echo "\n\t\tHandy: ". mysql_result($Erg, $n, "Handy"). "
    "; - if( strlen( mysql_result($Erg, $n, "DECT"))>0) - echo "\n\t\tDECT: ". - mysql_result($Erg, $n, "DECT"). "
    "; - if( strlen( mysql_result($Erg, $n, "email"))>0) - echo "\n\t\temail: ". - mysql_result($Erg, $n, "email")."
    "; - if( strlen( mysql_result($Erg, $n, "Hometown"))>0) - echo "\n\t\tHometown: ". mysql_result($Erg, $n, "Hometown"). "
    "; - if( strlen( mysql_result($Erg, $n, "lastLogIn"))>0) - echo "\n\t\tlastLogIn: ". mysql_result($Erg, $n, "lastLogIn"). "
    "; - if( strlen( mysql_result($Erg, $n, "Art"))>0) - echo "\n\t\tType: ". mysql_result($Erg, $n, "Art"). "
    "; - if( strlen( mysql_result($Erg, $n, "ICQ"))>0) - echo "\n\t\tICQ: ". mysql_result($Erg, $n, "ICQ"). "
    "; - if( strlen( mysql_result($Erg, $n, "jabber"))>0) - echo "\n\t\tjabber: ". mysql_result($Erg, $n, "jabber"). "
    "; - echo "\n\t\tGroup: ". mysql_result($Erg, $n, "Group"). "
    "; - echo "    		".mysql_result($Erg, $n, "Size")."".mysql_result($Erg, $n, "Gekommen")."".mysql_result($Erg, $n, "Aktiv")."".mysql_result($Erg, $n, "Tshirt")."". funktion_isLinkAllowed_addLink_OrEmpty( - "admin/userChangeNormal.php?enterUID=". - mysql_result($Erg, $n, "UID")."&Type=Normal", - "Änd."). - "". funktion_isLinkAllowed_addLink_OrEmpty( - "admin/userChangeSecure.php?enterUID=". - mysql_result($Erg, $n, "UID")."&Type=Secure", - "Secure"). - "
    $Gekommen$Active$Tshirt
    \n"; - // Ende Userliste - - echo "

    Statistics

    "; - funktion_db_element_list_2row( "Hometown", - "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); - - echo "
    \n"; - - funktion_db_element_list_2row( "Engeltypen", + // Userliste, keine UID uebergeben... + + echo "Neuen Engel eintragen

    \n"; + + if( !isset($_GET["OrderBy"]) ) $_GET["OrderBy"] = "Nick"; + $SQL = "SELECT User.*, UserGroups.Name AS 'Group' FROM `User` ". + "LEFT JOIN `UserCVS` ON User.UID = UserCVS.UID ". + "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID ". + "ORDER BY `". $_GET["OrderBy"]. "` ASC"; + $Erg = mysql_query($SQL, $con); + echo mysql_error($con); + + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); + + echo "Anzahl Engel: $Zeilen

    \n"; + + ?> + + + + + + + + + + + + + + + + \n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + $Gekommen += mysql_result($Erg, $n, "Gekommen"); + echo "\t\n"; + $Active += mysql_result($Erg, $n, "Aktiv"); + echo "\t\n"; + $Tshirt += mysql_result($Erg, $n, "Tshirt"); + echo "\t\n"; + echo "\t\n"; + echo "\t\n"; + echo "\n"; + } + echo "". + "". + "\n"; + echo "\t
    + ?OrderBy=Nick">Nick | + ?OrderBy=CreateDate">CreateDate + ?OrderBy=Name">Name?OrderBy=Vorname">Vorname?OrderBy=Alter">Alter + ?OrderBy=email">@ | + ?OrderBy=DECT">DECT | + ?OrderBy=Hometown">Hometown | + ?OrderBy=lastLogIn">lastLogIn | + ?OrderBy=Art">Type | + ?OrderBy=ICQ">ICQ | + ?OrderBy=jabber">jabber | + ?OrderBy=Group">Group + ?OrderBy=Size">Größe?OrderBy=Gekommen">G?OrderBy=Aktiv">A?OrderBy=Tshirt">TÄnd.Secure
    ".mysql_result($Erg, $n, "Nick"). "
    (Create: ". mysql_result($Erg, $n, "CreateDate"). ")    		".mysql_result($Erg, $n, "Name")."".mysql_result($Erg, $n, "Vorname")."".mysql_result($Erg, $n, "Alter").""; + if( strlen( mysql_result($Erg, $n, "Telefon"))>0) + echo "\n\t\tTel: ". mysql_result($Erg, $n, "Telefon"). "
    "; + if( strlen( mysql_result($Erg, $n, "Handy"))>0) + echo "\n\t\tHandy: ". mysql_result($Erg, $n, "Handy"). "
    "; + if( strlen( mysql_result($Erg, $n, "DECT"))>0) + echo "\n\t\tDECT: ". + mysql_result($Erg, $n, "DECT"). "
    "; + if( strlen( mysql_result($Erg, $n, "email"))>0) + echo "\n\t\temail: ". + mysql_result($Erg, $n, "email")."
    "; + if( strlen( mysql_result($Erg, $n, "Hometown"))>0) + echo "\n\t\tHometown: ". mysql_result($Erg, $n, "Hometown"). "
    "; + if( strlen( mysql_result($Erg, $n, "lastLogIn"))>0) + echo "\n\t\tlastLogIn: ". mysql_result($Erg, $n, "lastLogIn"). "
    "; + if( strlen( mysql_result($Erg, $n, "Art"))>0) + echo "\n\t\tType: ". mysql_result($Erg, $n, "Art"). "
    "; + if( strlen( mysql_result($Erg, $n, "ICQ"))>0) + echo "\n\t\tICQ: ". mysql_result($Erg, $n, "ICQ"). "
    "; + if( strlen( mysql_result($Erg, $n, "jabber"))>0) + echo "\n\t\tjabber: ". mysql_result($Erg, $n, "jabber"). "
    "; + echo "\n\t\tGroup: ". mysql_result($Erg, $n, "Group"). "
    "; + echo "    		".mysql_result($Erg, $n, "Size")."".mysql_result($Erg, $n, "Gekommen")."".mysql_result($Erg, $n, "Aktiv")."".mysql_result($Erg, $n, "Tshirt")."". funktion_isLinkAllowed_addLink_OrEmpty( + "admin/userChangeNormal.php?enterUID=". + mysql_result($Erg, $n, "UID")."&Type=Normal", + "Änd."). + "". funktion_isLinkAllowed_addLink_OrEmpty( + "admin/userChangeSecure.php?enterUID=". + mysql_result($Erg, $n, "UID")."&Type=Secure", + "Secure"). + "
    $Gekommen$Active$Tshirt
    \n"; + // Ende Userliste + + echo "

    Statistics

    "; + funktion_db_element_list_2row( "Hometown", + "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); + + echo "
    \n"; + + funktion_db_element_list_2row( "Engeltypen", "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); - echo "
    \n"; + echo "
    \n"; - funktion_db_element_list_2row( "Used Groups", - "SELECT UserGroups.Name AS 'GroupName', COUNT(UserGroups.Name) AS Count FROM `UserCVS` ". - "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID ". - "WHERE (UserCVS.GroupID!='NULL') ". - "GROUP BY `GroupName` ". - ""); + funktion_db_element_list_2row( "Used Groups", + "SELECT UserGroups.Name AS 'GroupName', COUNT(UserGroups.Name) AS Count FROM `UserCVS` ". + "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID ". + "WHERE (UserCVS.GroupID!='NULL') ". + "GROUP BY `GroupName` ". + ""); } else { - echo "error"; + echo "error"; } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/userArrived.php b/www-ssl/admin/userArrived.php old mode 100755 new mode 100644 index da68a5da..a8fdb71e --- a/www-ssl/admin/userArrived.php +++ b/www-ssl/admin/userArrived.php @@ -1,4 +1,4 @@ -". Get_Text("pri_userArrived_WriteOK"). " \"". UID2Nick($_GET["arrived"]). "\""; + echo "

    ". Get_Text("pri_userArrived_WriteOK"). " \"". UID2Nick($_GET["arrived"]). "\"

    "; } else { - echo "

    ". Get_Text("pri_userArrived_WriteError"). " \"". UID2Nick($_GET["arrived"]). "\"

    "; + echo "

    ". Get_Text("pri_userArrived_WriteError"). " \"". UID2Nick($_GET["arrived"]). "\"

    "; } } -echo Get_Text("pri_userArrived_Text1"). "
    "; -echo Get_Text("pri_userArrived_Text2"). "

    "; +echo Get_Text("pri_userArrived_Text1"). "
    "; +echo Get_Text("pri_userArrived_Text2"). "

    "; echo Get_Text("pri_userArrived_TableToppic"); $SQL = "SELECT * FROM `User` ORDER BY `Nick` ASC"; @@ -34,18 +34,18 @@ echo "\t\t". Get_Text("pri_userArrived_TableTD_ArrivedSet"). "\n"; echo "\t\n"; for ($i=0; $i<$rowcount; $i++){ - echo "\t\n"; - $eUID=mysql_result($Erg, $i, "UID"); - echo "\t\t".UID2Nick($eUID)."\n"; - echo "\t\t".mysql_result($Erg, $i, "Gekommen")."\n"; - - if (mysql_result($Erg, $i, "Gekommen") =="1") - { - echo "\t\t". Get_Text("pri_userArrived_TableEntry_Arrived"). ""; - } else { - echo "\t\t". Get_Text("pri_userArrived_TableEntry_Set"). ""; - } - echo "\t\n"; + echo "\t\n"; + $eUID=mysql_result($Erg, $i, "UID"); + echo "\t\t".UID2Nick($eUID)."\n"; + echo "\t\t".mysql_result($Erg, $i, "Gekommen")."\n"; + + if (mysql_result($Erg, $i, "Gekommen") =="1") + { + echo "\t\t". Get_Text("pri_userArrived_TableEntry_Arrived"). ""; + } else { + echo "\t\t". Get_Text("pri_userArrived_TableEntry_Set"). ""; + } + echo "\t\n"; } echo ""; diff --git a/www-ssl/admin/userChangeNormal.php b/www-ssl/admin/userChangeNormal.php old mode 100755 new mode 100644 index 51c49944..6785a030 --- a/www-ssl/admin/userChangeNormal.php +++ b/www-ssl/admin/userChangeNormal.php @@ -1,4 +1,4 @@ - Aendern... + // UserID wurde mit uebergeben --> Aendern... - echo "Hallo,
    ". - "hier kannst du den Eintrag ändern. Unter dem Punkt 'Gekommen' ". - "wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ". - "dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ". - "Wenn T-Shirt ein 'Ja' enthält, bedeutet dies, dass der Engel ". - "bereits sein T-Shirt erhalten hat.

    \n"; + echo "Hallo,
    ". + "hier kannst du den Eintrag ändern. Unter dem Punkt 'Gekommen' ". + "wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ". + "dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ". + "Wenn T-Shirt ein 'Ja' enthält, bedeutet dies, dass der Engel ". + "bereits sein T-Shirt erhalten hat.

    \n"; - echo "
    \n"; - echo "\n"; - echo "\n"; + echo "\n"; + echo "
    \n"; + echo "\n"; - $SQL = "SELECT * FROM `User` WHERE `UID`='". $_GET["enterUID"]. "'"; - $Erg = mysql_query($SQL, $con); - - if (mysql_num_rows($Erg) != 1) - echo ""; - else - { - echo ""; + } - echo "\n"; - echo "
    Sorry, der Engel (UID=". $_GET["enterUID"]. - ") wurde in der Liste nicht gefunden.
    \n"; - echo "\n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; - echo " \n"; + $SQL = "SELECT * FROM `User` WHERE `UID`='". $_GET["enterUID"]. "'"; + $Erg = mysql_query($SQL, $con); + + if (mysql_num_rows($Erg) != 1) + echo ""; + else + { + echo ""; - } + echo " \n"; + + echo "
    Nick". - "
    lastLogIn". - "
    Name". - "
    Vorname". - "
    Alter". - "
    Telefon". - "
    Handy". - "
    DECT". - "
    email". - "
    ICQ". - "
    jabber". - "
    Size". - "
    Passwort". - "neues Kennwort setzen
    Sorry, der Engel (UID=". $_GET["enterUID"]. + ") wurde in der Liste nicht gefunden.
    \n"; + echo "\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; - // Gekommen? - echo " \n"; + // Gekommen? + echo " \n"; - // Aktiv? - echo " \n"; + // Aktiv? + echo " \n"; - // T-Shirt bekommen? - echo " \n"; + // T-Shirt bekommen? + echo " \n"; - echo " \n"; - - echo "
    Nick". + "
    lastLogIn". + "
    Name". + "
    Vorname". + "
    Alter". + "
    Telefon". + "
    Handy". + "
    DECT". + "
    email". + "
    ICQ". + "
    jabber". + "
    Size". + "
    Passwort". + "neues Kennwort setzen
    Gekommen\n"; - echo " No \n"; - echo " Yes \n"; - echo "
    Gekommen\n"; + echo " No \n"; + echo " Yes \n"; + echo "
    Aktiv\n"; - echo " No \n"; - echo " Yes \n"; - echo "
    Aktiv\n"; + echo " No \n"; + echo " Yes \n"; + echo "
    T-Shirt\n"; - echo " No \n"; - echo " Yes \n"; - echo "
    T-Shirt\n"; + echo " No \n"; + echo " Yes \n"; + echo "
    Hometown". - "
    \n    		". displayavatar($_GET["enterUID"], FALSE). "
    Hometown". + "
    \n    		". displayavatar($_GET["enterUID"], FALSE). "
    \n
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; + echo "\n"; + echo "\n
    \n"; + echo "\n"; + echo "\n"; + echo ""; - echo "
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; + echo "
    \n"; + echo "\n"; + echo "\n"; + echo "
    "; - - echo "
    "; - funktion_db_element_list_2row( - "Freeloader Shifts", - "SELECT `Remove_Time`, `Length`, `Comment` FROM `ShiftFreeloader` WHERE UID=". $_GET["enterUID"]); + + echo "
    "; + funktion_db_element_list_2row( + "Freeloader Shifts", + "SELECT `Remove_Time`, `Length`, `Comment` FROM `ShiftFreeloader` WHERE UID=". $_GET["enterUID"]); } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/userChangeSecure.php b/www-ssl/admin/userChangeSecure.php old mode 100755 new mode 100644 index c1799fb8..2eb84b85 --- a/www-ssl/admin/userChangeSecure.php +++ b/www-ssl/admin/userChangeSecure.php @@ -1,4 +1,4 @@ - Aendern... + // UserID wurde mit uebergeben --> Aendern... - echo "Hallo,
    ". - "hier kannst du den Eintrag ändern. Unter dem Punkt 'Gekommen' ". - "wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ". - "dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ". - "Wenn T-Shirt ein 'Ja' enthält, bedeutet dies, dass der Engel ". - "bereits sein T-Shirt erhalten hat.

    \n"; + echo "Hallo,
    ". + "hier kannst du den Eintrag ändern. Unter dem Punkt 'Gekommen' ". + "wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ". + "dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ". + "Wenn T-Shirt ein 'Ja' enthält, bedeutet dies, dass der Engel ". + "bereits sein T-Shirt erhalten hat.

    \n"; - $SQL_CVS = "SELECT * FROM `UserCVS` WHERE `UID`='". $_GET["enterUID"]. "'"; - $Erg_CVS = mysql_query($SQL_CVS, $con); - - if( mysql_num_rows($Erg_CVS) != 1) - echo "Sorry, der Engel (UID=". $_GET["enterUID"]. ") wurde in der Liste nicht gefunden."; - else - { - // Rename if is an group - if( $_GET["enterUID"] < 0 ) { - $SQLname = "SELECT `Name` FROM `UserGroups` WHERE `UID`='". $_GET["enterUID"]. "'"; - $ErgName = mysql_query($SQLname, $con); - echo mysql_error($con); + $SQL_CVS = "SELECT * FROM `UserCVS` WHERE `UID`='". $_GET["enterUID"]. "'"; + $Erg_CVS = mysql_query($SQL_CVS, $con); + + if( mysql_num_rows($Erg_CVS) != 1) + echo "Sorry, der Engel (UID=". $_GET["enterUID"]. ") wurde in der Liste nicht gefunden."; + else + { + // Rename if is an group + if( $_GET["enterUID"] < 0 ) { + $SQLname = "SELECT `Name` FROM `UserGroups` WHERE `UID`='". $_GET["enterUID"]. "'"; + $ErgName = mysql_query($SQLname, $con); + echo mysql_error($con); - echo "
    \n"; - echo "\n"; - echo "\n"; - echo "\n"; - echo "
    "; - } + echo "
    \n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "
    "; + } - echo "
    \n"; - echo "\n"; - echo "\n"; - echo " \n"; + echo "\n"; + echo "

    Rights of \"". UID2Nick($_GET["enterUID"]). "\":
    \n"; + echo "\n"; + echo " \n"; - $CVS_Data = mysql_fetch_array($Erg_CVS); - $CVS_Data_i = 1; - foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) - { - $CVS_Data_i++; - //nur jeder zweiter sonst wird für jeden text noch die position (Zahl) ausgegeben - if( $CVS_Data_i%2 && $CVS_Data_Name!="UID") - { - if($CVS_Data_Name=="GroupID") { - if( $_GET["enterUID"] > 0 ) - { - echo "\n". - "\n". + ""; - } - } else { - echo "\n"; - } - } - } //IF - } //Foreach - echo "\n"; - - // Ende Formular - echo "\n"; - echo "

    Rights of \"". UID2Nick($_GET["enterUID"]). "\":
    Group
    Group
    $CVS_Data_Name"; - echo "allow \n"; - echo "denied \n"; - if( $_GET["enterUID"] > 0 ) - { - echo "group-setting \n"; - echo "
    \n
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; + $SQL_Group = "SELECT * FROM `UserGroups`"; + $Erg_Group = mysql_query($SQL_Group, $con); + for ($n = 0 ; $n < mysql_num_rows($Erg_Group) ; $n++) + { + $UID = mysql_result($Erg_Group, $n, "UID"); + echo "\t\n"; + } + echo ""; + } + } else { + echo "$CVS_Data_Name\n"; + echo "allow \n"; + echo "denied \n"; + if( $_GET["enterUID"] > 0 ) + { + echo "group-setting \n"; + echo ""; + } + } + } //IF + } //Foreach + echo "\n"; + + // Ende Formular + echo "\n"; + echo "\n
    \n"; + echo "\n"; + echo "\n"; + echo ""; - echo "
    \n"; - echo "\n"; - echo "\n"; - echo "
    "; - } + echo "
    \n"; + echo "\n"; + echo "\n"; + echo "
    "; + } } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/userDefaultSetting.php b/www-ssl/admin/userDefaultSetting.php old mode 100755 new mode 100644 index d3564400..d4a230de --- a/www-ssl/admin/userDefaultSetting.php +++ b/www-ssl/admin/userDefaultSetting.php @@ -1,4 +1,4 @@ -\nhier hast du die Möglichkeit, die Defaulteinstellungen für neue User einzustellen:

    \n"; - + ",
    \nhier hast du die Möglichkeit, die Defaulteinstellungen für neue User einzustellen:

    \n"; + echo "\n"; echo "\t\n"; echo "\t\t\n\t\t\n\t\t\n"; @@ -15,55 +15,55 @@ echo "\t\n"; if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"])) { - switch( $_GET["Send"]) - { - case "New": - $SQL = "ALTER TABLE `UserCVS` ADD `". $_GET["Field"]. "` ". - "CHAR( 1 ) DEFAULT '". $_GET["Default"]. "' NOT NULL"; - $Erg = db_query( $SQL, "New user default setting"); - if( $Erg == 1) - echo "

    Create ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull

    \n"; - else - echo "

    Create ".$_GET["Field"]. " = ". $_GET["Default"]. " error...

    \n". - "[". mysql_error(). "]

    "; - break; - case "Del": - echo "\t\n"; - echo "\t\t\n"; - echo "\t\t\t\n"; - echo "\t\t\t\n"; - echo "\t\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; - break; - case "Del sure": - $SQL = "ALTER TABLE `UserCVS` DROP `". $_GET["Field"]. "` "; - $Erg = db_query( $SQL, "del user default setting"); - if( $Erg == 1) - echo "

    Delete ".$_GET["Field"]. " succesfull

    \n"; - else - echo "

    Delete ".$_GET["Field"]. " error...

    \n". - "[". mysql_error(). "]

    "; - break; - case "SetForAllUser": - $SQL = "UPDATE `UserCVS` SET `". $_GET["Field"]. "`='". $_GET["Default"]. "' WHERE UID>0"; - $Erg = db_query( $SQL, "Set new user default setting for all user"); - if( $Erg == 1) - echo "

    UPDATE ".$_GET["Field"]. " = ". $_GET["Default"]. " for all Users succesfull

    \n"; - else - echo "

    UPDATE ".$_GET["Field"]. " = ". $_GET["Default"]. " for all Users error...

    \n". - "[". mysql_error(). "]

    "; - case "Save": - $SQL = "ALTER TABLE `UserCVS` CHANGE `". $_GET["Field"]. "` ". - "`". $_GET["Field"]. "` CHAR( 1 ) NOT NULL DEFAULT '". $_GET["Default"]. "'"; - $Erg = db_query( $SQL, "Save user default setting"); - if( $Erg == 1) - echo "

    Write ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull

    \n"; - else - echo "

    Write ".$_GET["Field"]. " = ". $_GET["Default"]. " error...

    \n". - "[". mysql_error(). "]

    "; - break; - } //SWITCH + switch( $_GET["Send"]) + { + case "New": + $SQL = "ALTER TABLE `UserCVS` ADD `". $_GET["Field"]. "` ". + "CHAR( 1 ) DEFAULT '". $_GET["Default"]. "' NOT NULL"; + $Erg = db_query( $SQL, "New user default setting"); + if( $Erg == 1) + echo "

    Create ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull

    \n"; + else + echo "

    Create ".$_GET["Field"]. " = ". $_GET["Default"]. " error...

    \n". + "[". mysql_error(). "]

    "; + break; + case "Del": + echo "\t\n"; + echo "\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; + break; + case "Del sure": + $SQL = "ALTER TABLE `UserCVS` DROP `". $_GET["Field"]. "` "; + $Erg = db_query( $SQL, "del user default setting"); + if( $Erg == 1) + echo "

    Delete ".$_GET["Field"]. " succesfull

    \n"; + else + echo "

    Delete ".$_GET["Field"]. " error...

    \n". + "[". mysql_error(). "]

    "; + break; + case "SetForAllUser": + $SQL = "UPDATE `UserCVS` SET `". $_GET["Field"]. "`='". $_GET["Default"]. "' WHERE UID>0"; + $Erg = db_query( $SQL, "Set new user default setting for all user"); + if( $Erg == 1) + echo "

    UPDATE ".$_GET["Field"]. " = ". $_GET["Default"]. " for all Users succesfull

    \n"; + else + echo "

    UPDATE ".$_GET["Field"]. " = ". $_GET["Default"]. " for all Users error...

    \n". + "[". mysql_error(). "]

    "; + case "Save": + $SQL = "ALTER TABLE `UserCVS` CHANGE `". $_GET["Field"]. "` ". + "`". $_GET["Field"]. "` CHAR( 1 ) NOT NULL DEFAULT '". $_GET["Default"]. "'"; + $Erg = db_query( $SQL, "Save user default setting"); + if( $Erg == 1) + echo "

    Write ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull

    \n"; + else + echo "

    Write ".$_GET["Field"]. " = ". $_GET["Default"]. " error...

    \n". + "[". mysql_error(). "]

    "; + break; + } //SWITCH } //IF( @@ -79,11 +79,11 @@ $SQL_Group = "SELECT * FROM `UserGroups`"; $Erg_Group = mysql_query($SQL_Group, $con); for ($n = 0 ; $n < mysql_num_rows($Erg_Group) ; $n++) { - $UID = mysql_result($Erg_Group, $n, "UID"); - echo "\t\n"; + $UID = mysql_result($Erg_Group, $n, "UID"); + echo "\t\n"; } echo "\n"; echo "\t\t\t\n"; for( $i=2; $i\n"; - echo "\t\t
    \n"; - echo "\t\t\t\n"; - echo "\t\t\t    \n"; - echo "\t\t\t\n"; + echo "\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\t\n"; - echo "\t\t\t\n"; - echo "\t\t\n"; - echo "\t\n"; + echo "\t\t\t\n"; + echo "\t\t\t\n"; + echo "\t\t\n"; + echo "\t\n"; } - + echo "\t\n"; echo "\t\t\n"; echo "\t\t\t\n"; diff --git a/www-ssl/admin/userSaveNormal.php b/www-ssl/admin/userSaveNormal.php old mode 100755 new mode 100644 index 4a7f7126..b1b42f96 --- a/www-ssl/admin/userSaveNormal.php +++ b/www-ssl/admin/userSaveNormal.php @@ -1,4 +1,4 @@ -"; + SetHeaderGo2Back(); + echo "Gesendeter Befehl: ". $_GET["action"]. "
    "; - switch ($_GET["action"]) - { - case "change": - if (IsSet($_POST["enterUID"])) - { - if ($_POST["Type"] == "Normal") - { - $SQL = "UPDATE `User` SET "; - $SQL.= " `Nick` = '". $_POST["eNick"]. "', `Name` = '". $_POST["eName"]. "', ". - "`Vorname` = '". $_POST["eVorname"]. "', ". - "`Telefon` = '". $_POST["eTelefon"]. "', ". - "`Handy` = '". $_POST["eHandy"]. "', ". - "`DECT` = '". $_POST["eDECT"]. "', ". - "`email` = '". $_POST["eemail"]. "', ". - "`ICQ` = '". $_POST["eICQ"]. "', ". - "`jabber` = '". $_POST["ejabber"]. "', ". - "`Size` = '". $_POST["eSize"]. "', ". - "`Gekommen`= '". $_POST["eGekommen"]. "', ". - "`Aktiv`= '". $_POST["eAktiv"]. "', ". - "`Tshirt` = '". $_POST["eTshirt"]. "', ". - "`Hometown` = '". $_POST["Hometown"]. "' ". - "WHERE `UID` = '". $_POST["enterUID"]. - "' LIMIT 1;"; - echo "User-"; - $Erg = db_query($SQL, "change user details"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } - else - echo "

    Fehler: Unbekanter Type (". $_POST["Type"]. ") übergeben\n

    \n"; - } - else - echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; - break; + switch ($_GET["action"]) + { + case "change": + if (IsSet($_POST["enterUID"])) + { + if ($_POST["Type"] == "Normal") + { + $SQL = "UPDATE `User` SET "; + $SQL.= " `Nick` = '". $_POST["eNick"]. "', `Name` = '". $_POST["eName"]. "', ". + "`Vorname` = '". $_POST["eVorname"]. "', ". + "`Telefon` = '". $_POST["eTelefon"]. "', ". + "`Handy` = '". $_POST["eHandy"]. "', ". + "`DECT` = '". $_POST["eDECT"]. "', ". + "`email` = '". $_POST["eemail"]. "', ". + "`ICQ` = '". $_POST["eICQ"]. "', ". + "`jabber` = '". $_POST["ejabber"]. "', ". + "`Size` = '". $_POST["eSize"]. "', ". + "`Gekommen`= '". $_POST["eGekommen"]. "', ". + "`Aktiv`= '". $_POST["eAktiv"]. "', ". + "`Tshirt` = '". $_POST["eTshirt"]. "', ". + "`Hometown` = '". $_POST["Hometown"]. "' ". + "WHERE `UID` = '". $_POST["enterUID"]. + "' LIMIT 1;"; + echo "User-"; + $Erg = db_query($SQL, "change user details"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } + else + echo "

    Fehler: Unbekanter Type (". $_POST["Type"]. ") übergeben\n

    \n"; + } + else + echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; + break; - case "delete": - if (IsSet($_POST["enterUID"])) - { - echo "delate User..."; - $SQL="DELETE FROM `User` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL, "User delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - echo "
    \ndelate UserCVS..."; - $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL2, "User CVS delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - echo "
    \ndelate UserEntry..."; - $SQL3="UPDATE `ShiftEntry` SET `UID`='0', `Comment`=NULL ". - "WHERE `UID`='". $_POST["enterUID"]. "';"; - $Erg = db_query($SQL3, "delate UserEntry"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } - break; + case "delete": + if (IsSet($_POST["enterUID"])) + { + echo "delate User..."; + $SQL="DELETE FROM `User` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL, "User delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + echo "
    \ndelate UserCVS..."; + $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL2, "User CVS delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + echo "
    \ndelate UserEntry..."; + $SQL3="UPDATE `ShiftEntry` SET `UID`='0', `Comment`=NULL ". + "WHERE `UID`='". $_POST["enterUID"]. "';"; + $Erg = db_query($SQL3, "delate UserEntry"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } + break; - case "newpw": - echo "Bitte neues Kennwort für "; - // Get Nick - $USQL = "SELECT * FROM `User` WHERE `UID`='". $_GET["eUID"]. "'"; - $Erg = mysql_query($USQL, $con); - echo mysql_result($Erg, 0, "Nick"); - echo " eingeben:
    "; - echo "\n"; - echo ""; - echo ""; - echo ""; - echo "\n"; - echo ""; - break; + case "newpw": + echo "Bitte neues Kennwort für "; + // Get Nick + $USQL = "SELECT * FROM `User` WHERE `UID`='". $_GET["eUID"]. "'"; + $Erg = mysql_query($USQL, $con); + echo mysql_result($Erg, 0, "Nick"); + echo " eingeben:
    "; + echo "\n"; + echo ""; + echo ""; + echo ""; + echo "\n"; + echo ""; + break; - case "newpwsave": - if ($_POST["ePasswort"] == $_POST["ePasswort2"]) - { // beide Passwoerter passen... - $_POST["ePasswort"] = PassCrypt($_POST["ePasswort"]); - $SQL = "UPDATE `User` SET `Passwort`='". $_POST["ePasswort"]. "' ". - "WHERE `UID`='". $_POST["eUID"]. "'"; - $Erg = db_query($SQL, "User new passwort"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } - else - echo "Das Passwort wurde nicht übereinstimmend eingegeben!"; - break; - } // end switch + case "newpwsave": + if ($_POST["ePasswort"] == $_POST["ePasswort2"]) + { // beide Passwoerter passen... + $_POST["ePasswort"] = PassCrypt($_POST["ePasswort"]); + $SQL = "UPDATE `User` SET `Passwort`='". $_POST["ePasswort"]. "' ". + "WHERE `UID`='". $_POST["eUID"]. "'"; + $Erg = db_query($SQL, "User new passwort"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } + else + echo "Das Passwort wurde nicht übereinstimmend eingegeben!"; + break; + } // end switch // ende - Action ist gesetzt } else { - // kein Action gesetzt -> abbruch - echo "Unzulässiger Aufruf.
    Bitte neu editieren..."; + // kein Action gesetzt -> abbruch + echo "Unzulässiger Aufruf.
    Bitte neu editieren..."; } include ("../../../camp2011/includes/footer.php"); diff --git a/www-ssl/admin/userSaveSecure.php b/www-ssl/admin/userSaveSecure.php old mode 100755 new mode 100644 index 277c7127..e9ad6135 --- a/www-ssl/admin/userSaveSecure.php +++ b/www-ssl/admin/userSaveSecure.php @@ -1,4 +1,4 @@ - 0 ) { - $Right = $_SESSION['CVS'][ "admin/user.php"]; + $Right = $_SESSION['CVS'][ "admin/user.php"]; } else { - $Right = $_SESSION['CVS'][ "admin/group.php"]; + $Right = $_SESSION['CVS'][ "admin/group.php"]; } if ( ($Right=="Y") && IsSet($_GET["action"])) { - SetHeaderGo2Back(); - echo "Gesendeter Befehl: ". $_GET["action"]. "
    "; - - switch ($_GET["action"]) - { - case "change": - if (IsSet($_POST["enterUID"])) - { - if ($_POST["Type"] == "Secure") - { - $SQL2 = "UPDATE `UserCVS` SET "; - $SQL_CVS = "SELECT * FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "'"; - $Erg_CVS = mysql_query($SQL_CVS, $con); - $CVS_Data = mysql_fetch_array($Erg_CVS); - $CVS_Data_i = 1; - foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) - { - if( ($CVS_Data_i+1)%2 && $CVS_Data_Name!="UID") { - if( $CVS_Data_Name == "GroupID") - { - if( $_POST["enterUID"] > 0 ) - $SQL2.= "`$CVS_Data_Name` = '". $_POST["GroupID"]."', "; - else - $SQL2.= "`$CVS_Data_Name` = NULL, "; - } else { - $SQL2.= "`$CVS_Data_Name` = '". $_POST[$CVS_Data_i]."', "; - } - } - $CVS_Data_i++; - } - $SQL2 = substr( $SQL2, 0, strlen($SQL2)-2 ); - $SQL2.= " WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - echo "
    Secure-"; - $Erg = db_query($SQL2, "change user CVS"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } - else - echo "

    Fehler: Unbekanter Type (". $_POST["Type"]. ") übergeben\n

    \n"; - } - else - echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; - break; + SetHeaderGo2Back(); + echo "Gesendeter Befehl: ". $_GET["action"]. "
    "; + + switch ($_GET["action"]) + { + case "change": + if (IsSet($_POST["enterUID"])) + { + if ($_POST["Type"] == "Secure") + { + $SQL2 = "UPDATE `UserCVS` SET "; + $SQL_CVS = "SELECT * FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "'"; + $Erg_CVS = mysql_query($SQL_CVS, $con); + $CVS_Data = mysql_fetch_array($Erg_CVS); + $CVS_Data_i = 1; + foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) + { + if( ($CVS_Data_i+1)%2 && $CVS_Data_Name!="UID") { + if( $CVS_Data_Name == "GroupID") + { + if( $_POST["enterUID"] > 0 ) + $SQL2.= "`$CVS_Data_Name` = '". $_POST["GroupID"]."', "; + else + $SQL2.= "`$CVS_Data_Name` = NULL, "; + } else { + $SQL2.= "`$CVS_Data_Name` = '". $_POST[$CVS_Data_i]."', "; + } + } + $CVS_Data_i++; + } + $SQL2 = substr( $SQL2, 0, strlen($SQL2)-2 ); + $SQL2.= " WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + echo "
    Secure-"; + $Erg = db_query($SQL2, "change user CVS"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } + else + echo "

    Fehler: Unbekanter Type (". $_POST["Type"]. ") übergeben\n

    \n"; + } + else + echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; + break; - case "changeGroupName": - if (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]<0) ) - { - $SQL = "UPDATE `UserGroups` SET `Name`='". $_POST["GroupName"]. "' WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1 ;"; - $Erg = db_query($SQL, "Update Group Name"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } - else - echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; - break; + case "changeGroupName": + if (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]<0) ) + { + $SQL = "UPDATE `UserGroups` SET `Name`='". $_POST["GroupName"]. "' WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1 ;"; + $Erg = db_query($SQL, "Update Group Name"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } + else + echo "

    Fehler: UserID (enterUID) wurde nicht per POST übergeben

    \n"; + break; - case "delete": - if (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]>0) ) - { - echo "delate User..."; - $SQL="DELETE FROM `User` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL, "User delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - echo "
    \ndelate UserCVS..."; - $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL2, "User CVS delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - echo "
    \ndelate UserEntry..."; - $SQL3="UPDATE `ShiftEntry` SET `UID`='0', `Comment`=NULL ". - "WHERE `UID`='". $_POST["enterUID"]. "';"; - $Erg = db_query($SQL3, "delate UserEntry"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - } elseif (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]<0) ) { - echo "delate Group..."; - $SQL="DELETE FROM `UserGroups` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL, "Group delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - echo "
    \ndelate UserCVS..."; - $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; - $Erg = db_query($SQL2, "User CVS delete"); - if ($Erg == 1) { - echo "Änderung wurde gesichert...\n"; - } else { - echo "Fehler beim speichern...\n(". mysql_error($con). ")"; - } - - } - break; - } // end switch + case "delete": + if (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]>0) ) + { + echo "delate User..."; + $SQL="DELETE FROM `User` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL, "User delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + echo "
    \ndelate UserCVS..."; + $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL2, "User CVS delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + echo "
    \ndelate UserEntry..."; + $SQL3="UPDATE `ShiftEntry` SET `UID`='0', `Comment`=NULL ". + "WHERE `UID`='". $_POST["enterUID"]. "';"; + $Erg = db_query($SQL3, "delate UserEntry"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + } elseif (IsSet($_POST["enterUID"]) && ($_POST["enterUID"]<0) ) { + echo "delate Group..."; + $SQL="DELETE FROM `UserGroups` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL, "Group delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + echo "
    \ndelate UserCVS..."; + $SQL2="DELETE FROM `UserCVS` WHERE `UID`='". $_POST["enterUID"]. "' LIMIT 1;"; + $Erg = db_query($SQL2, "User CVS delete"); + if ($Erg == 1) { + echo "Änderung wurde gesichert...\n"; + } else { + echo "Fehler beim speichern...\n(". mysql_error($con). ")"; + } + + } + break; + } // end switch // ende - Action ist gesetzt } elseif ( IsSet($_GET["new"]) && ($_SESSION['CVS']["admin/group.php"]=="Y") ) { - echo "Gesendeter Befehl: ". $_GET["new"]. "
    "; - - switch ($_GET["new"]) - { - case "newGroup": - echo "\tGenerate new Group ID...\n"; - $SQLid="SELECT MIN(`UID`) FROM `UserCVS`;"; - $Erg = mysql_query( $SQLid); - - if( mysql_num_rows($Erg) == 1) { - $NewId = mysql_result( $Erg, 0, 0)-1; - $SQLnew1 = "INSERT INTO `UserGroups` (`UID`, `Name`) VALUES ('$NewId', '". $_POST["GroupName"]. "' );"; - $SQLnew2 = "INSERT INTO `UserCVS` (`UID`, `GroupID`) VALUES ('$NewId', NULL );"; - echo "\t
    Generate new UserGroup ...\n"; - $ErgNew1 = db_query($SQLnew1, "create UserGroups Entry"); - if ($ErgNew1 == 1) - { - echo "\t
    Generate new User rights...\n"; - $ErgNew2 = db_query($SQLnew2, "UserCVS Entry"); - if ($ErgNew1 == 1) { - echo "\t
    New group was created.\n"; - } else { - echo "Error on creation\n(". mysql_error($con). ")"; - } - } else { - echo "Error on creation\n(". mysql_error($con). ")"; - } + echo "Gesendeter Befehl: ". $_GET["new"]. "
    "; + + switch ($_GET["new"]) + { + case "newGroup": + echo "\tGenerate new Group ID...\n"; + $SQLid="SELECT MIN(`UID`) FROM `UserCVS`;"; + $Erg = mysql_query( $SQLid); + + if( mysql_num_rows($Erg) == 1) { + $NewId = mysql_result( $Erg, 0, 0)-1; + $SQLnew1 = "INSERT INTO `UserGroups` (`UID`, `Name`) VALUES ('$NewId', '". $_POST["GroupName"]. "' );"; + $SQLnew2 = "INSERT INTO `UserCVS` (`UID`, `GroupID`) VALUES ('$NewId', NULL );"; + echo "\t
    Generate new UserGroup ...\n"; + $ErgNew1 = db_query($SQLnew1, "create UserGroups Entry"); + if ($ErgNew1 == 1) + { + echo "\t
    Generate new User rights...\n"; + $ErgNew2 = db_query($SQLnew2, "UserCVS Entry"); + if ($ErgNew1 == 1) { + echo "\t
    New group was created.\n"; + } else { + echo "Error on creation\n(". mysql_error($con). ")"; + } + } else { + echo "Error on creation\n(". mysql_error($con). ")"; + } - } + } - - break; - } + + break; + } } else { - // kein Action gesetzt -> abbruch - echo "Unzulässiger Aufruf.
    Bitte neu editieren..."; + // kein Action gesetzt -> abbruch + echo "Unzulässiger Aufruf.
    Bitte neu editieren..."; } include ("../../../camp2011/includes/footer.php"); -- cgit v1.2.3-54-g00ecf
    PageShow
    \n"; @@ -93,35 +93,35 @@ echo "\t
    ". mysql_result( $erg, $i, "Field"). "\n"; - - echo "\t\t\t\tallow\n"; + echo "\t
    ". mysql_result( $erg, $i, "Field"). "\n"; + + echo "\t\t\t\tallow\n"; - echo "\t\t\t\tdenied\n"; + echo "\t\t\t\tdenied\n"; - echo "\t\t\t\tgroup-setting\n"; + echo "\t\t\t\tgroup-setting\n"; - echo "\t\t\t\n"; - echo "\t\t\t \n"; - echo "\t\t\t
    \n"; + echo "\t\t\t \n"; + echo "\t\t\t