From fac68e78579f8737c418539621b63220bc5d5c23 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Thu, 2 Jun 2011 17:17:30 +0200 Subject: rooms done --- www-ssl/admin/room.php | 180 ------------------------------------------------- 1 file changed, 180 deletions(-) delete mode 100644 www-ssl/admin/room.php (limited to 'www-ssl/admin') diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php deleted file mode 100644 index e3defb23..00000000 --- a/www-ssl/admin/room.php +++ /dev/null @@ -1,180 +0,0 @@ -\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 { - - 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; - - 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; - - 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; - - 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; - - case 'delete' : - if (IsSet ($_GET["RID"])) { - $SQL = "DELETE FROM `Room` WHERE `RID`='" . $_GET["RID"] . "'"; - } else { - echo "Fehlerhafter Aufruf"; - } - SetHeaderGo2Back(); - break; - - } //switch - - // 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 - -} //IF IsSet($action) - -include ("includes/footer.php"); -?> -- cgit v1.2.3-54-g00ecf