From 01b586b92a0f0c96398594c7a74d190b0c43d82c Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Tue, 15 Nov 2005 23:19:38 +0000
Subject: minimale SID wegen pneterbarf entfernt

git-svn-id: svn://svn.cccv.de/engel-system@58 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/admin/room.php     | 13 +------------
 www-ssl/admin/shiftadd.php | 12 +-----------
 2 files changed, 2 insertions(+), 23 deletions(-)

(limited to 'www-ssl/admin')

diff --git a/www-ssl/admin/room.php b/www-ssl/admin/room.php
index 3b8cb63c..c2f556f2 100755
--- a/www-ssl/admin/room.php
+++ b/www-ssl/admin/room.php
@@ -82,18 +82,7 @@ case 'newsave':
 		$Keys   .= ", `$key`";
 		$Values .= ", '$value'";
 	}
-	
-	//ermitteln des letzten eintrages
-	$SQLin = "SELECT `RID` FROM `Room` ".
-		 "WHERE NOT (`FromPentabarf` = 'Y') ".
-		 "ORDER BY `RID` DESC";
-	$Ergin = mysql_query($SQLin, $con);
-	if( mysql_num_rows( $Ergin) > 0)
-		$RID = mysql_result( $Ergin, 0, 0)+1;
-	else
-		$RID = 10000;
-	
-	$SQL  = "INSERT INTO `Room` (`RID`$Keys) VALUES ( '$RID'$Values)";
+	$SQL  = "INSERT INTO `Room` (". substr( $Keys, 2). ") VALUES (". substr( $Values, 2). ")";
 	SetHeaderGo2Back();
 	break;
 
diff --git a/www-ssl/admin/shiftadd.php b/www-ssl/admin/shiftadd.php
index 8295483c..e13f882e 100755
--- a/www-ssl/admin/shiftadd.php
+++ b/www-ssl/admin/shiftadd.php
@@ -288,18 +288,8 @@ function CreateNewEntry()
 		echo "\t<td>exists</td>";
 	elseif( $_GET["OnlyShow"] == "OFF" )   
 	{
-		//Suchet nach letzter SID
-		$SQLin = "SELECT `SID` FROM `Shifts` ".
-			 "WHERE NOT (`FromPentabarf` = 'Y') ".
-			 "ORDER BY `SID` DESC";
-		$Ergin = mysql_query($SQLin, $con);
-		if( mysql_num_rows( $Ergin) > 0)
-			$newSID = mysql_result( $Ergin, 0, 0)+1;
-		else
-			$newSID = 10000;
-		
 		// erstellt Eintrag in Shifts für die algemeine schicht
-		$SQL  = "INSERT INTO `Shifts` (`SID`, `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ('$newSID', ";
+		$SQL  = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( ";
 		$SQL .= "'". $_DateS. "', '". $_DateE. "', ";
 		$SQL .= "'". $_GET["len"]. "', '". $_GET["RID"]. "', ";
 		$SQL .= "'". $_GET["SchichtName"]. "');";
-- 
cgit v1.2.3-54-g00ecf