\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"; 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 } //IF( $erg = mysql_query("SHOW COLUMNS FROM `UserCVS`"); echo mysql_error(); 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\t\n"; echo "\t\t\n"; echo "\t\n"; for ($i = 2; $i < mysql_num_rows($erg); $i++) { 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\t\n"; echo "\t\t\n"; echo "\t\n"; } 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\t\n"; echo "\t\t\n"; echo "\t\n"; echo "
PageShow
Group\n"; echo "\t\t\t
" . mysql_result($erg, $i, "Field") . "\n"; echo "\t\t\t\tallow\n"; echo "\t\t\t\tdenied\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\tallow\n"; echo "\t\t\t\tdenied\n"; echo "\t\t\t\tgroup-setting\n"; echo "\t\t\t
\n"; include ("includes/footer.php"); ?>