$_GET['attdatum'] = '';
}
if (!isset($_GET['attzeit'])) {
$_GET['attzeit'] = '';
}
if (!isset($_GET['attfor'])) {
$_GET['attfor'] = '';
}
if (!isset($_GET['freigabe'])) {
$_GET['freigabe'] = '';
}
if (!isset($_GET['info'])) {
$_GET['info'] = '';
}
if (!isset($_GET['flotte'])) {
$_GET['flotte'] = '';
}
if (!isset($_GET['attstatus'])) {
$_GET['attstatus'] = '';
}
if ($_GET['fkt'] == 'attfreigabe') {
$SQL = 'UPDATE gn4attplanung SET freigabe = 1 WHERE lfd =' . $_GET['lfd'] . ';';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
echo 'Att-Ziel freigegeben!' . $_GET['lfd'];
}
if ($_GET['fkt'] == 'attloeschung' && $_GET['lfd'] != '') {
$ret = del_attplanlfd($_GET['lfd']);
}
?>
echo '<TD bgcolor="#6490BB"><b>Information</TD>';
echo '<TD bgcolor="#6490BB"><b>Funktion</TD>';
echo '<TD bgcolor="#6490BB"><b>Verwaltung</TD></TR>';
for ($i = 0; $i < $SQL_Num; $i++) {
// prüfen, ob Attplung veraltet ist..
$lfd = mysql_result($SQL_Result, $i, "lfd");
$testdate = date("d") . '.' . date("m") . '.' . date("Y");
$yesterday = strftime("%d.%m.%Y", strtotime("-1 day"));
$timesep = explode(".", $yesterday);
$yesterday = mktime(0, 0, 0, $timesep[1], $timesep[0], $timesep[2]);
$attdate2 = ConvertDatumToText(mysql_result($SQL_Result, $i, "attdatum"));
$timesep = explode(".", $attdate2);
$ATTDate3 = mktime(0, 0, 0, $timesep[1], $timesep[0], $timesep[2]);
if ($yesterday > $ATTDate3) {
// veraltete Planung löschen
$ret = del_attplanlfd($lfd);
} else {
//planung anzeigen
$rg = mysql_result($SQL_Result, $i, 'galaxie');
$rp = mysql_result($SQL_Result, $i, 'planet');
$SQL2 = 'select * from `gn4scans` where rg=' . mysql_result($SQL_Result, $i, 'galaxie') . ' and rp=' . mysql_result($SQL_Result, $i, 'planet') . ' and type=0';
$SQL2_Result = tic_mysql_query($SQL2) or die(tic_mysql_error(__FILE__, __LINE__));
if (mysql_num_rows($SQL2_Result) != 0) {
$szeit = mysql_result($SQL2_Result, 0, 'zeit');
$sgen = mysql_result($SQL2_Result, 0, 'gen');
$pts = mysql_result($SQL2_Result, 0, 'pts');
$me = mysql_result($SQL2_Result, 0, 'me');
$ke = mysql_result($SQL2_Result, 0, 'ke');
$s = mysql_result($SQL2_Result, 0, 's');
$d = mysql_result($SQL2_Result, 0, 'd');
$a = mysql_result($SQL2_Result, 0, 'a');
