create new page

git-svn-id: svn://svn.cccv.de/engel-system@45 29ba0400-6e00-0410-a75a-ca02368028f8

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");
+?>
+