"; 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; } } $Sql = "SELECT * FROM `EngelType` ORDER BY `NAME`"; $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) . "	###

"; } 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; 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; 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); 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; case 'changesave' : $vars = $_GET; $count = count($vars) - 2; $vars = array_splice($vars, 0, $count); $keys = ""; $sql = ""; foreach ($vars as $key => $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; 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; } } include ("includes/footer.php"); ?>