diff options
author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-11-15 23:19:38 +0000 |
---|---|---|
committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-11-15 23:19:38 +0000 |
commit | 01b586b92a0f0c96398594c7a74d190b0c43d82c (patch) | |
tree | 780e354a2ffbb938e8847ef8b58e2d15f6d1b863 /www-ssl | |
parent | d49556b05b7223dc098939b9f04550a297ec04f4 (diff) |
minimale SID wegen pneterbarf entfernt
git-svn-id: svn://svn.cccv.de/engel-system@58 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl')
-rwxr-xr-x | www-ssl/admin/room.php | 13 | ||||
-rwxr-xr-x | www-ssl/admin/shiftadd.php | 12 |
2 files changed, 2 insertions, 23 deletions
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"]. "');"; |