summaryrefslogtreecommitdiff
path: root/www-ssl
diff options
context:
space:
mode:
Diffstat (limited to 'www-ssl')
-rwxr-xr-xwww-ssl/admin/room.php13
-rwxr-xr-xwww-ssl/admin/shiftadd.php12
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"]. "');";