diff options
| -rwxr-xr-x | DB/Himmel.sql | 3 | ||||
| -rwxr-xr-x | www-ssl/admin/menu.php | 2 | ||||
| -rwxr-xr-x | www-ssl/admin/userDefaultSetting.php | 53 |
3 files changed, 57 insertions, 1 deletions
diff --git a/DB/Himmel.sql b/DB/Himmel.sql index 84f0cac6..0347730a 100755 --- a/DB/Himmel.sql +++ b/DB/Himmel.sql @@ -597,6 +597,7 @@ CREATE TABLE IF NOT EXISTS `UserCVS` ( `admin/schichtplan.php` char(1) NOT NULL default 'N', `admin/shiftadd.php` char(1) NOT NULL default 'N', `admin/schichtplan_druck.php` char(1) NOT NULL default 'N', + `admin/userDefaultSetting.php` char(1) NOT NULL default 'N', `admin/user.php` char(1) NOT NULL default 'N', `admin/user2.php` char(1) NOT NULL default 'N', `admin/aktiv.php` char(1) NOT NULL default 'N', @@ -615,7 +616,7 @@ CREATE TABLE IF NOT EXISTS `UserCVS` ( -- Daten für Tabelle `UserCVS` -- -INSERT INTO `UserCVS` (`UID`, `index.php`, `logout.php`, `faq.php`, `lageplan.php`, `makeuser.php`, `nonpublic/index.php`, `nonpublic/news.php`, `nonpublic/newsAddMeting`, `nonpublic/news_comments.php`, `nonpublic/myschichtplan.php`, `nonpublic/engelbesprechung.php`, `admin/index.php`, `nonpublic/schichtplan.php`, `nonpublic/schichtplan_add.php`, `nonpublic/schichtplan_beamer.php`, `nonpublic/wecken.php`, `nonpublic/waeckliste.php`, `nonpublic/faq.php`, `nonpublic/einstellungen.php`, `admin/list.php`, `admin/dbUpdateFromXLS.php`, `admin/room.php`, `admin/EngelType.php`, `admin/schichtplan.php`, `admin/shiftadd.php`, `admin/schichtplan_druck.php`, `admin/user.php`, `admin/user2.php`, `admin/aktiv.php`, `admin/tshirt.php`, `admin/news.php`, `admin/faq.php`, `admin/free.php`, `admin/sprache.php`, `admin/dect.php`, `Netz`, `Kassen`) VALUES (-1, 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'), (1, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); +INSERT INTO `UserCVS` (`UID`, `index.php`, `logout.php`, `faq.php`, `lageplan.php`, `makeuser.php`, `nonpublic/index.php`, `nonpublic/news.php`, `nonpublic/newsAddMeting`, `nonpublic/news_comments.php`, `nonpublic/myschichtplan.php`, `nonpublic/engelbesprechung.php`, `admin/index.php`, `nonpublic/schichtplan.php`, `nonpublic/schichtplan_add.php`, `nonpublic/schichtplan_beamer.php`, `nonpublic/wecken.php`, `nonpublic/waeckliste.php`, `nonpublic/faq.php`, `nonpublic/einstellungen.php`, `admin/list.php`, `admin/dbUpdateFromXLS.php`, `admin/room.php`, `admin/EngelType.php`, `admin/schichtplan.php`, `admin/shiftadd.php`, `admin/schichtplan_druck.php`, `admin/userDefaultSetting.php`, `admin/user.php`, `admin/user2.php`, `admin/aktiv.php`, `admin/tshirt.php`, `admin/news.php`, `admin/faq.php`, `admin/free.php`, `admin/sprache.php`, `admin/dect.php`, `Netz`, `Kassen`) VALUES (-1, 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'), (1, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); -- -------------------------------------------------------- diff --git a/www-ssl/admin/menu.php b/www-ssl/admin/menu.php index a76bfdfd..2dc1ee5a 100755 --- a/www-ssl/admin/menu.php +++ b/www-ssl/admin/menu.php @@ -17,6 +17,8 @@ $Menu["Entry"][13]["Name"] = "Dect"; $Menu["Entry"][13]["Line"] = "<br>"; $Menu["Entry"][4]["File"] = "user.php"; $Menu["Entry"][4]["Name"] = "Engelliste"; +$Menu["Entry"][14]["File"] = "userDefaultSetting.php"; +$Menu["Entry"][14]["Name"] = "EngelDefaultSetting"; $Menu["Entry"][5]["File"] = "aktiv.php"; $Menu["Entry"][5]["Name"] = "Aktivliste"; $Menu["Entry"][6]["File"] = "tshirt.php"; diff --git a/www-ssl/admin/userDefaultSetting.php b/www-ssl/admin/userDefaultSetting.php new file mode 100755 index 00000000..2489ae4a --- /dev/null +++ b/www-ssl/admin/userDefaultSetting.php @@ -0,0 +1,53 @@ +<?PHP + +$title = "Debug-Liste"; +$header = "Datenbank-Auszug"; +include ("./inc/header.php"); +include ("./inc/funktion_db_list.php"); + + +/* +echo "<h1>Raeume</h1> <br>"; +funktion_db_list("Raeume"); + +echo "<h1>Schichtbelegung</h1> <br>"; +funktion_db_list("Schichtbelegung"); + +echo "<h1>Schichtplan</h1> <br>Hier findest du alle bisher eingetragenen Schichten:"; +funktion_db_list("Schichtplan"); + +echo "<h1>User</h1> <br>"; +funktion_db_list("User"); + +echo "<h1>News</h1> <br>"; +funktion_db_list("News"); + +echo "<h1>FAQ</h1> <br>"; +funktion_db_list("FAQ"); + +*/ + +echo "Deaktiviert<br>\n"; + +$erg = mysql_query("SHOW COLUMNS FROM `UserCVS`"); +echo mysql_error(); + +if (mysql_num_rows($erg) > 0) +{ +/* while ($row = mysql_fetch_assoc($erg)) + { + print_r($erg); + } +*/ +} +for( $i=1; $i<mysql_num_rows($erg); $i++) +{ + echo ""; + echo mysql_result( $erg, $i, "Field"); + echo mysql_result( $erg, $i, "Default"); + echo "<br>"; +} + +include ("./inc/footer.php"); +?> + |