</TR>
<TR>
<TD> <font size="-1">
<?php
$SQL_Result = tic_mysql_query('SELECT * FROM `gn4flottenbewegungen` WHERE ( modus="0" or modus="3" or modus="4" ) AND angreifer_galaxie="' . $zeig_galaxie . '" AND angreifer_planet="' . $zeig_planet . '" ORDER BY eta;', $SQL_DBConn) or $error_code = 4;
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num == 0) {
echo '<P CLASS="hell">Es befindet sich keine Flotte auf dem Rückflug.</P>';
} else {
echo '<CENTER><P CLASS="hell">';
echo ' Folgende Flotten sind auf dem Rückflug:';
echo ' <TABLE>';
for ($n = 0; $n < $SQL_Num; $n++) {
echo '<TR><TD><font size="-1">Name: <B>' . mysql_result($SQL_Result, $n, 'verteidiger_galaxie') . ':' . mysql_result($SQL_Result, $n, 'verteidiger_planet') . '</B></font></TD>';
$disptime = mysql_result($SQL_Result, $n, 'eta') * $Ticks['lange'] - $tick_abzug;
$disptime = getime4display($disptime);
echo '<TD><font size="-1">ETA: <B>' . $disptime . '</B></font></TD>';
echo '<TD><font size="-1">Flotte: ' . $flottennr[mysql_result($SQL_Result, $n, 'flottennr')] . '</font></TD>';
echo '<TD>';
// if ($Benutzer['rang'] > $Rang_GC || !($Benutzer['rang'] <= $Rang_GC && $Benutzer['galaxie'] != $zeig_galaxie)) echo '<A HREF="./main.php?modul=anzeigen&id='.$id.'&action=flotteloeschen&flottenid='.mysql_result($SQL_Result, $n, 'id').'">Löschen</A>, <A HREF="./main.php?modul=flotteaendern&id='.$id.'&flottenid='.mysql_result($SQL_Result, $n, 'id').'">Ändern</A></TD>';
echo '<FORM ACTION="./main.php" METHOD="POST">';
echo '<INPUT TYPE="hidden" NAME="modul" VALUE="anzeigen">';
echo '<INPUT TYPE="hidden" NAME="id" VALUE="' . $id . '">';
echo '<INPUT TYPE="hidden" NAME="action" VALUE="flotteloeschen">';
echo '<INPUT TYPE="hidden" NAME="flottenid" VALUE="' . mysql_result($SQL_Result, $n, 'id') . '">';
echo '<INPUT TYPE="submit" VALUE="Löschen"> </form></td><td>';
echo '<FORM ACTION="./main.php" METHOD="POST">';
echo '<INPUT TYPE="hidden" NAME="modul" VALUE="flotteaendern">';
echo '<INPUT TYPE="hidden" NAME="id" VALUE="' . $id . '">';
echo '<INPUT TYPE="hidden" NAME="flottenid" VALUE="' . mysql_result($SQL_Result, $n, 'id') . '">';
echo '<INPUT TYPE="submit" VALUE="Ändern"> </form>';
}
echo '</SELECT>';
echo 'Flotte: <SELECT NAME="lst_Flotte" SIZE=1>';
echo ' <OPTION VALUE="0">Unbekannt</OPTION>';
echo ' <OPTION VALUE="1">1. Flotte</OPTION>';
echo ' <OPTION VALUE="2">2. Flotte</OPTION>';
echo '</SELECT> ';
echo '<A HREF="javascript:document.frmFlottenbewegung.submit()">Hinzufügen</A>';
} elseif ($_POST['selected'] == 'rueckflug') {
echo '<INPUT TYPE="hidden" NAME="modus" VALUE="rueckflug">';
echo '<INPUT TYPE="hidden" NAME="txt_Angreifer_Galaxie" VALUE="' . $zeig_galaxie . '">';
echo '<INPUT TYPE="hidden" NAME="txt_Angreifer_Planet" VALUE="' . $zeig_planet . '">';
echo '<INPUT TYPE="hidden" NAME="lst_Flugzeit" VALUE="0">';
echo 'Flotte befindet sich auf dem Rückflug von <INPUT TYPE="text" NAME="txt_Verteidiger_Galaxie" SIZE="4" MAXLENGTH=4> : <INPUT TYPE="text" NAME="txt_Verteidiger_Planet" SIZE="2" MAXLENGTH=2> . ETA: <SELECT NAME="lst_ETA" SIZE="1">';
for ($n = $Ticks['angriffsflug']; $n >= 0; $n--) {
echo '<OPTION VALUE="' . $n . '">' . getime4display($n * $Ticks['lange'] - $tick_abzug) . '</OPTION>';
}
echo '</SELECT> ';
echo 'Flotte: <SELECT NAME="lst_Flotte" SIZE=1>';
echo ' <OPTION VALUE="0">Unbekannt</OPTION>';
echo ' <OPTION VALUE="1">1. Flotte</OPTION>';
echo ' <OPTION VALUE="2">2. Flotte</OPTION>';
echo '</SELECT> ';
echo '<A HREF="javascript:document.frmFlottenbewegung.submit()">Hinzufügen</A>';
}
?>
</font>
</FORM>
</TD>
</TR>
</TABLE>
$f3_liste_namen = $f3_liste_namen . " <a href=\"./main.php?modul=flotteaendern&id=" . mysql_result($SQL_Result_user, $n, 'id') . "&flottenid=" . $fbid . "\" onmouseover=\"return overlib('Eingetragen von " . mysql_result($SQL_Result_fleets, $x, 'erfasser') . " um " . mysql_result($SQL_Result_fleets, $x, 'erfasst_am') . " ');\" onmouseout=\"return nd();\">" . gnuser($a_gala, $a_plan) . "</a> ";
$f3_liste_namen = $f3_liste_namen . $lnk . " " . $scan . "<br>\n";
$f3_liste_eta = $f3_liste_eta . "\t\t\t\t<a href=\"" . $scripturl . "&action=savechange&fbid=" . $fbid . "&incsave=" . $incunsave . "\"" . ($Benutzer['help'] ? " onmouseover=\"return overlib('Koords rot = Unsave<br>Koords schwarz = Save<br>Klick hier um zu ändern');\" onmouseout=\"return nd();\"" : "") . ">" . getime4display(eta($time1) * $Ticks['lange'] - $tick_abzug) . "</a><br>\n";
$display_line = 1;
$incsunsafe += $incunsave;
}
// Verteidigen <-
if ($f_mode == 2 && $v_gala == $koord_g && $v_plan == $koord_p) {
// $scan = "<a href=\"./main.php?modul=showgalascans&xgala=".$a_gala."&xplanet=".$a_plan."\">".GetScans2($SQL_DBConn, $a_gala, $a_plan)."</a>";
$scan = Get_Scan3($SQL_DBConn, $a_gala, $a_plan, $Benutzer['help'], 0);
$flonr = mysql_result($SQL_Result_fleets, $x, 'flottennr');
$fbid = mysql_result($SQL_Result_fleets, $x, 'id');
$lnk = "<a href=\"" . $scripturl . "&action=flonrchange&fbid=" . $fbid . "&flonr=" . $flonr . "\"" . ($Benutzer['help'] ? " onmouseover=\"return overlib('Hier kannst du die Flott Nr. ändern. ');\" onmouseout=\"return nd();\"" : "") . ">#" . ($flonr == 0 ? "?" : $flonr) . "</a>";
$f4_liste_namen = $f4_liste_namen . "\t\t\t\t" . $a_gala . ":" . $a_plan . " <a href=\"./main.php?modul=flotteaendern&id=" . mysql_result($SQL_Result_user, $n, 'id') . "&flottenid=" . $fbid . "\" onmouseover=\"return overlib('Eingetragen von " . mysql_result($SQL_Result_fleets, $x, 'erfasser') . " um " . mysql_result($SQL_Result_fleets, $x, 'erfasst_am') . " ');\" onmouseout=\"return nd();\">" . gnuser($a_gala, $a_plan) . "</a> ";
$f4_liste_namen = $f4_liste_namen . $lnk . " " . $scan . "<br>\n";
$f4_liste_eta = $f4_liste_eta . "\t\t\t\t" . getime4display(eta($time1) * $Ticks['lange'] - $tick_abzug) . "<br>\n";
$display_line = 1;
}
}
// ------------------
mysql_free_result($SQL_Result_fleets);
$dsp .= "\t\t\t<td bgcolor=\"" . $htmlstyle['hell' . $farb_zusatz] . "\"><font size=\"-2\">\n";
$dsp .= $f1_liste_namen;
$dsp .= "\t\t\t</font></td>\n";
$dsp .= "\t\t\t<td bgcolor=\"" . $htmlstyle['dunkel' . $farb_zusatz] . "\" align=\"right\"><font size=\"-2\">\n";
$dsp .= $f1_liste_eta;
$dsp .= "\t\t\t</font></td>\n";
$dsp .= "\t\t\t<td bgcolor=\"" . $htmlstyle['hell' . $farb_zusatz] . "\"><font size=\"-2\">\n";
$dsp .= $f2_liste_namen;
$dsp .= "\t\t\t</font></td>\n";
$dsp .= "\t\t\t<td bgcolor=\"" . $htmlstyle['dunkel' . $farb_zusatz] . "\" align=\"right\"><font size=\"-2\">\n";
function check_attflottenstatus($id, $flnr, $rg, $rp, $AttStatus, $lfd)
{
// 0 Vorbereitung gelb
// 1 abgeflogen / gestartert gruen
// 2 rueckflug / Abbruch rot
global $ATTETA;
global $tick_abzug;
$ret = 0;
$SQL = 'SELECT * FROM `gn4accounts` WHERE id ="' . $id . '";';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num != 0) {
$ug = mysql_result($SQL_Result, 0, 'galaxie');
$up = mysql_result($SQL_Result, 0, 'planet');
$SQL = 'SELECT * FROM gn4flottenbewegungen WHERE angreifer_galaxie=' . $ug . ' AND angreifer_planet=' . $up . ' AND verteidiger_galaxie=' . $rg . ' AND verteidiger_planet=' . $rp . ' and (flottennr = ' . $flnr . ' or flottennr =0);';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
$SQL_Num = mysql_num_rows($SQL_Result);
if ($SQL_Num != 0) {
// 1 angriff
// 2 deff rueckflug
// 3 rueckflug att
// 4 rueckflug deff
$modus = mysql_result($SQL_Result, 0, 'modus');
$flottennr = mysql_result($SQL_Result, 0, 'flottennr');
if ($modus == 1) {
// Eta ermitteln
$time1 = mysql_result($SQL_Result, 0, 'ankunft');
$time2 = mysql_result($SQL_Result, 0, 'flugzeit_ende');
$time3 = mysql_result($SQL_Result, 0, 'ruckflug_ende');
$ATTETA = getime4display(eta($time1) * $Ticks['lange'] - $tick_abzug);
$ret = 1;
if ($AttStatus < 2) {
// eine flotte ist gestaret .. Status wird geaendert
$SQL = 'UPDATE gn4attplanung set attstatus = 2 where lfd=' . $lfd . ';';
$SQL_Result = tic_mysql_query($SQL) or die(tic_mysql_error(__FILE__, __LINE__));
}
} else {
if ($modus == 3) {
$ret = 2;
}
}
}
}
return $ret;
}
$tooltip_fleet .= "<span class=" . getScanAge($scan["scan_einheiten_time"], $f_eta) . ">";
$tooltip_fleet .= $scan["scan_einheiten_jaeger"] ? $scan["scan_einheiten_jaeger"] . " Jäger<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_bomber"] ? $scan["scan_einheiten_bomber"] . " Bomber<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_fregatten"] ? $scan["scan_einheiten_fregatten"] . " Fregatten<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_zerstoerer"] ? $scan["scan_einheiten_zerstoerer"] . " Zerstörer<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_kreuzer"] ? $scan["scan_einheiten_kreuzer"] . " Kreuzer<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_schlachter"] ? $scan["scan_einheiten_schlachter"] . " Schlachtschiffe<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_traeger"] ? $scan["scan_einheiten_traeger"] . " Träger<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_kleptoren"] ? $scan["scan_einheiten_kleptoren"] . " Kleptoren<br />" : "";
$tooltip_fleet .= $scan["scan_einheiten_schildschiffe"] ? $scan["scan_einheiten_schildschiffe"] . " Schildschiffe<br />" : "";
$tooltip_fleet .= "<i>(" . $scan["scan_einheiten_prozent"] . "% Einheitenscan vom " . date("d.M H:i", $scan["scan_einheiten_time"]) . ")</i><br />";
$tooltip_fleet .= "</span>";
}
$link_fleet = "<a href=\"" . $scripturl . "&action=flonrchange&fbid=" . $f_id . "&flonr=" . $f_nummer . "\" onmouseover=\"return overlib('" . $tooltip_fleet . "');\" onmouseout=\"return nd();\">#" . ($f_nummer == 0 ? "?" : $f_nummer) . "</a>";
$f3_liste_namen = $f3_liste_namen . "\t\t\t" . $link_scan . "<span class=\"texttaktik\">" . $start_g . ":" . $start_p . " " . trimname($start_n) . " <img src=\"./bilder/scans/" . getScanAge($scan["scan_militaer_time"], $f_eta) . ".gif\" width=\"15\" height=\"15\" border=\"0\" align=\"middle\"></span></a> " . $link_fleet . "<br />\n";
$f3_liste_eta = $f3_liste_eta . "\t\t\t" . ($f_eta < $time_now ? "-" : "") . getime4display(eta($f_eta >= $time_now ? $f_eta : $f_eta_ab) * $Ticks['lange'] - $tick_abzug) . "<br />\n";
$display_line = 1;
}
}
mysql_free_result($SQL_Result_fleets);
$dsp .= "\t\t\t<td class=\"field" . $farb_zusatz . "light\" align=\"left\">\n";
$dsp .= $f1_liste_namen;
$dsp .= "\t\t\t</td>\n";
$dsp .= "\t\t\t<td class=\"field" . $farb_zusatz . "dark\" align=\"right\">\n";
$dsp .= $f1_liste_eta;
$dsp .= "\t\t\t</td>\n";
if ($f2_liste_namen == "") {
$dsp .= "\t\t\t<td class=\"field" . $farb_zusatz . "light\" align=\"left\">\n";
$dsp .= "\t\t\t</td>\n";
$dsp .= "\t\t\t<td class=\"field" . $farb_zusatz . "dark\" align=\"right\">\n";
$dsp .= "\t\t\t</td>\n";
