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');