echo '<TD bgcolor="#6490BB"><b>Freigabe:</TD></TR>';
echo '<TR><TD bgcolor="#0000FF">';
echo '<form name="attadd" method="post" action="./main.php">';
echo '<INPUT TYPE="hidden" NAME="id" VALUE="' . $Benutzer['id'] . '">';
echo '<INPUT TYPE="hidden" NAME="fkt" VALUE="attadd">';
echo '<INPUT TYPE="hidden" NAME="action" VALUE="attplaneradmin">';
echo '<INPUT TYPE="hidden" NAME="modul" VALUE="attplanerlist">';
// Werte
$freigabesel = "";
if ($fkt == "attumplanung") {
$SQL = "SELECT * FROM gn4attplanung WHERE lfd=" . $lfd . ";";
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
if (mysql_num_rows($SQL_Result) != 0) {
$galaxie = mysql_result($SQL_Result, 0, 'galaxie');
$planet = mysql_result($SQL_Result, 0, 'planet');
$attdatum = ConvertDatumToText(mysql_result($SQL_Result, 0, 'attdatum'));
$attzeit = substr(mysql_result($SQL_Result, 0, 'attzeit'), 0, 5);
if (mysql_result($SQL_Result, 0, 'forallianz') != 0) {
$ForAllianz = " selected ";
} else {
$ForAllianz = "";
}
if (mysql_result($SQL_Result, 0, 'formeta') != 0) {
$ForMeta = " selected ";
} else {
$ForMeta = "";
}
if (mysql_result($SQL_Result, 0, 'forall') != 0) {
$ForAll = " selected ";
} else {
$ForAll = "";
$SQL_Num = mysql_num_rows($SQL_Result);
echo '<br><center> <table border="1" cellspacing="0" cellpadding="0"><TR>';
echo '<TD bgcolor="#6490BB"><b>Zieldaten</TD>';
echo '<TD bgcolor="#6490BB"><b>Planung</TD>';
echo '<TD bgcolor="#6490BB"><b>Eingecheckte Flotten:</TD>';
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');
