diff options
Diffstat (limited to 'www-ssl/admin')
-rw-r--r-- | www-ssl/admin/userChangeNormal.php | 133 | ||||
-rw-r--r-- | www-ssl/admin/userDefaultSetting.php | 138 | ||||
-rw-r--r-- | www-ssl/admin/userSaveNormal.php | 119 |
3 files changed, 0 insertions, 390 deletions
diff --git a/www-ssl/admin/userChangeNormal.php b/www-ssl/admin/userChangeNormal.php deleted file mode 100644 index 36eb4b6d..00000000 --- a/www-ssl/admin/userChangeNormal.php +++ /dev/null @@ -1,133 +0,0 @@ -<?php -require_once ('../bootstrap.php'); - -$title = "User-Liste"; -$header = "Editieren der Engelliste"; -include ("includes/header.php"); -include ("includes/funktion_db_list.php"); - -if (IsSet ($_GET["enterUID"])) { - // UserID wurde mit uebergeben --> Aendern... - - echo "Hallo,<br />" . - "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.<br /><br />\n"; - - echo "<form action=\"./userSaveNormal.php?action=change\" method=\"POST\">\n"; - echo "<table border=\"0\">\n"; - echo "<input type=\"hidden\" name=\"Type\" value=\"Normal\">\n"; - - $SQL = "SELECT * FROM `User` WHERE `UID`='" . $_GET["enterUID"] . "'"; - $Erg = mysql_query($SQL, $con); - - if (mysql_num_rows($Erg) != 1) - echo "<tr><td>Sorry, der Engel (UID=" . $_GET["enterUID"] . - ") wurde in der Liste nicht gefunden.</td></tr>"; - else { - echo "<tr><td>\n"; - echo "<table>\n"; - echo " <tr><td>Nick</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eNick\" value=\"" . - mysql_result($Erg, 0, "Nick") . "\"></td></tr>\n"; - echo " <tr><td>lastLogIn</td><td>" . - "<input type=\"text\" size=\"20\" name=\"elastLogIn\" value=\"" . - mysql_result($Erg, 0, "lastLogIn") . "\" disabled></td></tr>\n"; - echo " <tr><td>Name</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eName\" value=\"" . - mysql_result($Erg, 0, "Name") . "\"></td></tr>\n"; - echo " <tr><td>Vorname</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eVorname\" value=\"" . - mysql_result($Erg, 0, "Vorname") . "\"></td></tr>\n"; - echo " <tr><td>Alter</td><td>" . - "<input type=\"text\" size=\"5\" name=\"eAlter\" value=\"" . - mysql_result($Erg, 0, "Alter") . "\"></td></tr>\n"; - echo " <tr><td>Telefon</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eTelefon\" value=\"" . - mysql_result($Erg, 0, "Telefon") . "\"></td></tr>\n"; - echo " <tr><td>Handy</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eHandy\" value=\"" . - mysql_result($Erg, 0, "Handy") . "\"></td></tr>\n"; - echo " <tr><td>DECT</td><td>" . - "<input type=\"text\" size=\"4\" name=\"eDECT\" value=\"" . - mysql_result($Erg, 0, "DECT") . "\"></td></tr>\n"; - echo " <tr><td>email</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eemail\" value=\"" . - mysql_result($Erg, 0, "email") . "\"></td></tr>\n"; - echo " <tr><td>ICQ</td><td>" . - "<input type=\"text\" size=\"40\" name=\"eICQ\" value=\"" . - mysql_result($Erg, 0, "ICQ") . "\"></td></tr>\n"; - echo " <tr><td>jabber</td><td>" . - "<input type=\"text\" size=\"40\" name=\"ejabber\" value=\"" . - mysql_result($Erg, 0, "jabber") . "\"></td></tr>\n"; - echo " <tr><td>Size</td><td>" . - "<input type=\"text\" size=\"5\" name=\"eSize\" value=\"" . - mysql_result($Erg, 0, "Size") . "\"></td></tr>\n"; - echo " <tr><td>Passwort</td><td>" . - "<a href=\"./userSaveNormal.php?action=newpw&eUID=" . - mysql_result($Erg, 0, "UID") . "\">neues Kennwort setzen</a></td></tr>\n"; - - // Gekommen? - echo " <tr><td>Gekommen</td><td>\n"; - echo " <input type=\"radio\" name=\"eGekommen\" value=\"0\""; - if (mysql_result($Erg, 0, "Gekommen") == '0') - echo " checked"; - echo ">No \n"; - echo " <input type=\"radio\" name=\"eGekommen\" value=\"1\""; - if (mysql_result($Erg, 0, "Gekommen") == '1') - echo " checked"; - echo ">Yes \n"; - echo "</td></tr>\n"; - - // Aktiv? - echo " <tr><td>Aktiv</td><td>\n"; - echo " <input type=\"radio\" name=\"eAktiv\" value=\"0\""; - if (mysql_result($Erg, 0, "Aktiv") == '0') - echo " checked"; - echo ">No \n"; - echo " <input type=\"radio\" name=\"eAktiv\" value=\"1\""; - if (mysql_result($Erg, 0, "Aktiv") == '1') - echo " checked"; - echo ">Yes \n"; - echo "</td></tr>\n"; - - // T-Shirt bekommen? - echo " <tr><td>T-Shirt</td><td>\n"; - echo " <input type=\"radio\" name=\"eTshirt\" value=\"0\""; - if (mysql_result($Erg, 0, "Tshirt") == '0') - echo " checked"; - echo ">No \n"; - echo " <input type=\"radio\" name=\"eTshirt\" value=\"1\""; - if (mysql_result($Erg, 0, "Tshirt") == '1') - echo " checked"; - echo ">Yes \n"; - echo "</td></tr>\n"; - - echo " <tr><td>Hometown</td><td>" . - "<input type=\"text\" size=\"40\" name=\"Hometown\" value=\"" . - mysql_result($Erg, 0, "Hometown") . "\"></td></tr>\n"; - - echo "</table>\n</td><td valign=\"top\">" . displayavatar($_GET["enterUID"], FALSE) . "</td></tr>"; - } - - echo "</td></tr>\n"; - echo "</table>\n<br />\n"; - echo "<input type=\"hidden\" name=\"enterUID\" value=\"" . $_GET["enterUID"] . "\">\n"; - echo "<input type=\"submit\" value=\"sichern...\">\n"; - echo "</form>"; - - echo "<form action=\"./userSaveNormal.php?action=delete\" method=\"POST\">\n"; - echo "<input type=\"hidden\" name=\"enterUID\" value=\"" . $_GET["enterUID"] . "\">\n"; - echo "<input type=\"submit\" value=\"löschen...\">\n"; - echo "</form>"; - - echo "<hr>"; - funktion_db_element_list_2row("Freeloader Shifts", "SELECT `Remove_Time`, `Length`, `Comment` FROM `ShiftFreeloader` WHERE UID=" . $_GET["enterUID"]); -} - -include ("includes/footer.php"); -?> - - diff --git a/www-ssl/admin/userDefaultSetting.php b/www-ssl/admin/userDefaultSetting.php deleted file mode 100644 index e7a69925..00000000 --- a/www-ssl/admin/userDefaultSetting.php +++ /dev/null @@ -1,138 +0,0 @@ -<?php -require_once ('../bootstrap.php'); - -$title = "Defalut User Setting"; -$header = "Defalut User Setting"; -include ("includes/header.php"); -include ("includes/funktion_db_list.php"); - -echo "Hallo " . $_SESSION['Nick'] . -",<br />\nhier hast du die Möglichkeit, die Defaulteinstellungen für neue User einzustellen:<br /><br />\n"; - -echo "<table border=\"0\" class=\"border\">\n"; -echo "\t<tr class=\"contenttopic\">\n"; -echo "\t\t<th>Page</th>\n\t\t<th>Show</th>\n\t\t<th></th>\n"; -echo "\t</tr>\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 "<H2>Create " . $_GET["Field"] . " = " . $_GET["Default"] . " succesfull</h2>\n"; - else - echo "<H2>Create " . $_GET["Field"] . " = " . $_GET["Default"] . " error...</h2>\n" . - "[" . mysql_error() . "]<br /><br />"; - break; - case "Del" : - echo "\t<tr class=\"content\">\n"; - echo "\t\t<form action=\"userDefaultSetting.php\">\n"; - echo "\t\t\t<td><input name=\"Field\" type=\"text\" value=\"" . $_GET["Field"] . "\" readonly></td>\n"; - echo "\t\t\t<td><input name=\"Default\" type=\"text\" value=\"" . $_GET["Default"] . "\" readonly></td>\n"; - echo "\t\t\t<td><input type=\"submit\" name=\"Send\" value=\"Del sure\"></td>\n"; - echo "\t\t</form>\n"; - echo "\t</tr>\n"; - break; - case "Del sure" : - $SQL = "ALTER TABLE `UserCVS` DROP `" . $_GET["Field"] . "` "; - $Erg = db_query($SQL, "del user default setting"); - if ($Erg == 1) - echo "<H2>Delete " . $_GET["Field"] . " succesfull</h2>\n"; - else - echo "<H2>Delete " . $_GET["Field"] . " error...</h2>\n" . - "[" . mysql_error() . "]<br /><br />"; - 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 "<H2>UPDATE " . $_GET["Field"] . " = " . $_GET["Default"] . " for all Users succesfull</h2>\n"; - else - echo "<H2>UPDATE " . $_GET["Field"] . " = " . $_GET["Default"] . " for all Users error...</h2>\n" . - "[" . mysql_error() . "]<br /><br />"; - 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 "<H2>Write " . $_GET["Field"] . " = " . $_GET["Default"] . " succesfull</h2>\n"; - else - echo "<H2>Write " . $_GET["Field"] . " = " . $_GET["Default"] . " error...</h2>\n" . - "[" . mysql_error() . "]<br /><br />"; - break; - } //SWITCH -} //IF( - -$erg = mysql_query("SHOW COLUMNS FROM `UserCVS`"); -echo mysql_error(); -echo "\t<tr class=\"content\">\n"; -echo "\t\t<form action=\"userDefaultSetting.php\">\n"; -echo "\t\t\t<input name=\"Field\" type=\"hidden\" value=\GroupID\">\n"; -echo "\t\t\t<td>Group</td>\n"; -echo "\t\t\t<td><select name=\"GroupID\">"; - -$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<option value=\"$UID\""; - if (mysql_result($erg, 1, "Default") == $UID) - echo " selected"; - echo ">" . mysql_result($Erg_Group, $n, "Name") . "</option>\n"; -} -echo "</select></td>\n"; -echo "\t\t\t<td><input type=\"submit\" name=\"Send\" value=\"Save\">\n"; -echo "\t\t\t <input type=\"submit\" name=\"Send\" value=\"SetForAllUser\"></td>\n"; -echo "\t\t</form>\n"; -echo "\t</tr>\n"; - -for ($i = 2; $i < mysql_num_rows($erg); $i++) { - echo "\t<tr class=\"content\">\n"; - echo "\t\t<form action=\"userDefaultSetting.php\">\n"; - echo "\t\t\t<input name=\"Field\" type=\"hidden\" value=\"" . mysql_result($erg, $i, "Field") . "\">\n"; - echo "\t\t\t<td>" . mysql_result($erg, $i, "Field") . "</td>\n"; - echo "\t\t\t<td>\n"; - - echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"Y\""; - if (mysql_result($erg, $i, "Default") == "Y") - echo " checked"; - echo ">allow\n"; - - echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"N\""; - if (mysql_result($erg, $i, "Default") == "N") - echo " checked"; - echo ">denied\n"; - - echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"G\""; - if (mysql_result($erg, $i, "Default") == "G") - echo " checked"; - echo ">group-setting\n"; - - echo "\t\t\t</td>\n"; - echo "\t\t\t<td><input type=\"submit\" name=\"Send\" value=\"Save\">\n"; - echo "\t\t\t <input type=\"submit\" name=\"Send\" value=\"Del\">\n"; - echo "\t\t\t <input type=\"submit\" name=\"Send\" value=\"SetForAllUser\"></td>\n"; - echo "\t\t</form>\n"; - echo "\t</tr>\n"; -} - -echo "\t<tr class=\"content\">\n"; -echo "\t\t<form action=\"userDefaultSetting.php\">\n"; -echo "\t\t\t<input name=\"New\" type=\"hidden\" value=\"New\">\n"; -echo "\t\t\t<td><input name=\"Field\" type=\"text\" value=\"new\"></td>\n"; -echo "\t\t\t<td>\n"; -echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"Y\">allow\n"; -echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"N\">denied\n"; -echo "\t\t\t\t<input type=\"radio\" name=\"Default\" value=\"G\" checked>group-setting\n"; -echo "\t\t\t</td>\n"; -echo "\t\t\t<td><input type=\"submit\" name=\"Send\" value=\"New\"></td>\n"; -echo "\t\t</form>\n"; -echo "\t</tr>\n"; - -echo "</table>\n"; - -include ("includes/footer.php"); -?> - diff --git a/www-ssl/admin/userSaveNormal.php b/www-ssl/admin/userSaveNormal.php deleted file mode 100644 index deaf96d9..00000000 --- a/www-ssl/admin/userSaveNormal.php +++ /dev/null @@ -1,119 +0,0 @@ -<?php -require_once ('../bootstrap.php'); - -$title = "User-Liste"; -$header = "Index"; -include ("includes/header.php"); -include ("includes/funktion_db_list.php"); -include ("includes/crypt.php"); -include ("includes/funktion_db.php"); - -if (IsSet ($_GET["action"])) { - SetHeaderGo2Back(); - echo "Gesendeter Befehl: " . $_GET["action"] . "<br />"; - - 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 "<h1>Fehler: Unbekanter Type (" . $_POST["Type"] . ") �bergeben\n</h1>\n"; - } else - echo "<h1>Fehler: UserID (enterUID) wurde nicht per POST �bergeben</h1>\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 "<br />\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 "<br />\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 <b>"; - // Get Nick - $USQL = "SELECT * FROM `User` WHERE `UID`='" . $_GET["eUID"] . "'"; - $Erg = mysql_query($USQL, $con); - echo mysql_result($Erg, 0, "Nick"); - echo "</b> eingeben:<br />"; - echo "<form action=\"./userSaveNormal.php?action=newpwsave\" method=\"POST\">\n"; - echo "<input type=\"Password\" name=\"ePasswort\">"; - echo "<input type=\"Password\" name=\"ePasswort2\">"; - echo "<input type=\"hidden\" name=\"eUID\" value=\"" . $_GET["eUID"] . "\">"; - echo "<input type=\"submit\" value=\"sichern...\">\n"; - echo "</form>"; - 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 - - // ende - Action ist gesetzt -} else { - // kein Action gesetzt -> abbruch - echo "Unzulässiger Aufruf.<br />Bitte neu editieren..."; -} - -include ("includes/footer.php"); -?> - |