\n";
echo "\t| $_DateS | \n";
echo "\t$_DateE | \n";
echo "\t" . $_GET["len"] . " | \n";
echo "\t" . $_GET["RID"] . " | \n";
echo "\t" . $_GET["SchichtName"] . " | \n";
// Ist eintarg schon vorhanden?
$SQL = "SELECT `SID` FROM `Shifts` ";
$SQL .= "WHERE (" .
"`DateS` = '" . $_DateS . "' AND " .
"`DateE` = '" . $_DateE . "' AND " .
"`RID` = '" . $_GET["RID"] . "');";
$Erg = mysql_query($SQL, $con);
if (mysql_num_rows($Erg) != 0)
echo "\texists | ";
elseif ($_GET["OnlyShow"] == "OFF") {
// erstellt Eintrag in Shifts f�r die algemeine schicht
$SQL = "INSERT INTO `Shifts` ( `DateS`, `DateE`, `Len`, `RID`, `Man`) VALUES ( ";
$SQL .= "'" . $_DateS . "', '" . $_DateE . "', ";
$SQL .= "'" . $_GET["len"] . "', '" . $_GET["RID"] . "', ";
$SQL .= "'" . $_GET["SchichtName"] . "');";
$Erg = db_query($SQL, "create shift");
$SQLFail = "\n\t
[" . $SQL . "]";
if ($Erg == 1)
echo "\tpass | \n";
else
echo "\tfail
\n" . mysql_error($con) . "$SQLFail | \n";
} else
echo "\tonly show | \n";
// sucht SID von eingetragennen schiten
$SQL = "SELECT SID FROM `Shifts` ";
$SQL .= "WHERE (" .
"`DateS` = '" . $_DateS . "' AND " .
"`DateE` = '" . $_DateE . "' AND " .
"`Len` = '" . $_GET["len"] . "' AND " .
"`RID` = '" . $_GET["RID"] . "');";
$Erg = mysql_query($SQL, $con);
if (mysql_num_rows($Erg) == 0)
echo "\t? | ";
else {
$SID = mysql_result($Erg, 0, "SID");
echo "\t" . $SID . " | ";
}
// erstellt f�r jeden Engeltypen die eintrage in 'ShiftEntry'
echo "\t";
foreach ($EngelType As $TTemp) {
$Temp = "EngelType" . $TTemp["TID"];
if ($_GET[$Temp] > 0) {
$i = 0;
echo $_GET[$Temp] . " " . $TTemp["Name"] . "
\t";
while ($i++ < $_GET[$Temp]) {
if ($_GET["OnlyShow"] == "OFF") {
$SQL = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES (";
$SQL .= "'" . $SID . "', ";
$SQL .= "'" . $TTemp["TID"] . "');";
$Erg = mysql_query($SQL, $con);
if ($debug)
$SQLFail = "\n\t
[" . $SQL . "]";
if ($Erg == 1)
echo "'pass' ";
else
echo "'fail' " . mysql_error($con) . "$SQLFail | \n";
} else
echo "+";
}
echo "
";
} // IF $$TEMP
} // FOREACH
echo "";
echo "
\n";
}
include ("includes/footer.php");
?>