function Get_FlottenNr($id, $help, $flnr)
{
global $SQL_DBConn;
$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) {
return '???';
} else {
$v_gala = mysql_result($SQL_Result, 0, 'galaxie');
$v_plan = mysql_result($SQL_Result, 0, 'planet');
$output = OnMouseFlotte($v_gala, $v_plan, $flnr * -1, "");
$refa = '<a href="./main.php?modul=showgalascans&xgala=' . $v_gala . '&xplanet=' . $v_plan . '" ';
$output = $refa . InfoText($output) . ">FL#" . $flnr . "</a>";
return $output;
}
}
}
$AttStatus = mysql_result($SQL_Result, $i, "attstatus");
$freigabe = mysql_result($SQL_Result, $i, "freigabe");
if ($freigabe == 0) {
$attcolor = "DDDDDD";
} else {
if ($testdate >= $attdate2 or $AttStatus != 0) {
$attcolor = $ATTSTATUSHTML[$AttStatus];
} else {
$attcolor = "DDDDDD";
}
}
$output = OnMouseFlotte($rg, $rp, $Benutzer['punkte'], "");
echo '<TR>';
echo '<TD bgcolor="#' . $attcolor . '"><b>';
$output2 = InfoText("Ziel wurde erfasst durch Spieler:<br><b>" . GetUserInfos(mysql_result($SQL_Result, $i, "id")) . " von " . GetAllianzName(mysql_result($SQL_Result, $i, "id")));
echo '<a href="./main.php?modul=showgalascans&xgala=' . $rg . '&xplanet=' . $rp . '" ' . $output2 . '>';
echo $rg . ":" . $rp . " " . gnuser($rg, $rp);
echo '</a>';
echo " <font color=#0000FF>";
echo "<a href=\"./main.php?modul=showgalascans&xgala=" . $rg . "&xplanet=" . $rp . "\"" . ($Benutzer['help'] ? " onmouseover=\"return overlib('" . $output . "');\" onmouseout=\"return nd();\"" : "") . ">";
echo GetScans2($SQL_DBConn, $rg, $rp) . "</a></B></font><br>";
echo 'Exxen M: ' . $me . "<br>Exxen K: " . $ke . "<br>";
echo 'Pkt: ' . ZahlZuText(intval($pts / 1000)) . "K<br>";
echo 'Def: ' . $d . '<br>Ships: ' . $s . "<br>";
echo '</TD>';
// Planung
echo '<TD bgcolor="#' . $attcolor . '">';
echo '<b><center>';
echo $attdate2;
echo "<br>" . substr(mysql_result($SQL_Result, $i, "attzeit"), 0, 5) . "<BR>";