From 18060e60cc94c02df9680773bf5cafd35fe2aecf Mon Sep 17 00:00:00 2001
From: Angelo Cuccato <cuccato@web.de>
Date: Tue, 2 Feb 2010 23:00:15 +0100
Subject: add more logging functions

---
 www-ssl/admin/room.php               |  2 +-
 www-ssl/admin/shiftadd.php           |  2 +-
 www-ssl/admin/userDefaultSetting.php | 29 +++++++++++++++++++++++++----
 3 files changed, 27 insertions(+), 6 deletions(-)

(limited to 'www-ssl')

diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php
index 50171986..151d9bca 100755
--- a/www-ssl/admin/room.php
+++ b/www-ssl/admin/room.php
@@ -183,7 +183,7 @@ case 'delete':
 if (IsSet($SQL)){ 
 //	echo $SQL; 
 	// hier muesste das SQL ausgefuehrt werden...
-	$Erg = mysql_query($SQL, $con);
+	$Erg = db_query($SQL, "exec SQL");
 	if ($Erg == 1) 
 	     echo "&Auml;nderung wurde gesichert...<br>";
 	else
diff --git a/www-ssl/admin/shiftadd.php b/www-ssl/admin/shiftadd.php
index c0230748..70391041 100755
--- a/www-ssl/admin/shiftadd.php
+++ b/www-ssl/admin/shiftadd.php
@@ -291,7 +291,7 @@ function CreateNewEntry()
 		$SQL .= "'". $_DateS. "', '". $_DateE. "', ";
 		$SQL .= "'". $_GET["len"]. "', '". $_GET["RID"]. "', ";
 		$SQL .= "'". $_GET["SchichtName"]. "');";
-		$Erg = mysql_query($SQL, $con);
+		$Erg = db_query($SQL, "create shift");
 
 		$SQLFail = "\n\t<br>[".$SQL. "]";
 
diff --git a/www-ssl/admin/userDefaultSetting.php b/www-ssl/admin/userDefaultSetting.php
index 09c62a15..84d880ad 100755
--- a/www-ssl/admin/userDefaultSetting.php
+++ b/www-ssl/admin/userDefaultSetting.php
@@ -20,7 +20,7 @@ if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"]))
 		case "New":
  			$SQL = "ALTER TABLE `UserCVS` ADD `". $_GET["Field"]. "` ".
 				"CHAR( 1 ) DEFAULT '". $_GET["Default"]. "' NOT NULL";
-			$Erg = mysql_query( $SQL, $con);
+			$Erg = db_query( $SQL, "New user default setting");
 			if( $Erg == 1)
 				echo "<H2>Create ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull</h2>\n";
 			else
@@ -38,7 +38,7 @@ if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"]))
 			break;
 		case "Del sure":
 			$SQL = "ALTER TABLE `UserCVS` DROP `". $_GET["Field"]. "` ";
-			$Erg = mysql_query( $SQL, $con);
+			$Erg = db_query( $SQL, "del user default setting");
 			if( $Erg == 1)
 				echo "<H2>Delete ".$_GET["Field"]. " succesfull</h2>\n";
 			else
@@ -47,7 +47,7 @@ if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"]))
 			break;
 		case "SetForAllUser":
 			$SQL = "UPDATE `UserCVS` SET `". $_GET["Field"]. "`='". $_GET["Default"]. "' WHERE UID>0";
-			$Erg = mysql_query( $SQL, $con);
+			$Erg = db_query( $SQL, "Set new user default setting for all user");
 			if( $Erg == 1)
 				echo "<H2>UPDATE ".$_GET["Field"]. " = ". $_GET["Default"]. " for all Users succesfull</h2>\n";
 			else
@@ -56,7 +56,7 @@ if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"]))
 		case "Save":
 			$SQL = "ALTER TABLE `UserCVS` CHANGE `". $_GET["Field"]. "` ".
 				"`". $_GET["Field"]. "` CHAR( 1 ) NOT NULL DEFAULT '". $_GET["Default"]. "'";
-			$Erg = mysql_query( $SQL, $con);
+			$Erg = db_query( $SQL, "Save user default setting");
 			if( $Erg == 1)
 				echo "<H2>Write ".$_GET["Field"]. " = ". $_GET["Default"]. " succesfull</h2>\n";
 			else
@@ -69,6 +69,27 @@ if( isset( $_GET["Field"]) && isset( $_GET["Default"]) && isset( $_GET["Send"]))
 
 $erg = mysql_query("SHOW COLUMNS FROM `UserCVS`");
 echo mysql_error();
+echo "\t<tr class=\"content\">\n";
+echo "\t\t<form action=\"userDefaultSetting.php\">\n";
+echo "\t\t\t<input name=\"Field\" type=\"hidden\" value=\GroupID\">\n";
+echo "\t\t\t<td>Group</td>\n";
+echo "\t\t\t<td><select name=\"GroupID\">";
+
+$SQL_Group = "SELECT * FROM `UserGroups`";
+$Erg_Group =  mysql_query($SQL_Group, $con);
+for ($n = 0 ; $n < mysql_num_rows($Erg_Group) ; $n++)
+{
+		$UID =  mysql_result($Erg_Group, $n, "UID");
+		echo "\t<option value=\"$UID\"";
+		if( mysql_result( $erg, 1, "Default") == $UID)
+				echo " selected";
+		echo ">". mysql_result($Erg_Group, $n, "Name"). "</option>\n";
+}
+echo "</select></td>\n";
+echo "\t\t\t<td><input type=\"submit\" name=\"Send\" value=\"Save\">\n";
+echo "\t\t\t    <input type=\"submit\" name=\"Send\" value=\"SetForAllUser\"></td>\n";
+echo "\t\t</form>\n";
+echo "\t</tr>\n";
 
 for( $i=2; $i<mysql_num_rows($erg); $i++)
 {
-- 
cgit v1.2.3-54-g00ecf