/**
* Views a naval formation
*/
protected function viewNavalFormation()
{
$sql = "SELECT userID\n \t\t\tFROM ugml_naval_formation_to_users\n \t\t\tWHERE formationID = " . $this->formationID;
$result = WCF::getDB()->sendQuery($sql);
$users = array();
while ($row = WCF::getDB()->fetchArray($result)) {
$users[$row['userID']] = true;
}
if (isset($users[WCF::getUser()->userID])) {
$ownFleet = true;
} else {
$ownFleet = false;
}
$className = $this->getClassName($ownFleet);
$shipStr = $this->getShipStr();
$transport = $this->getRessources('string');
$containerName = 'fleet' . $this->fleet_id . (!$this->fleet_mess ? 'a' : 'b');
if (!$this->fleet_mess) {
$fpage .= '<tr class="flight"><th><div id="' . $containerName . '" class="z"></div></th><th colspan="3">';
} else {
$fpage .= '<tr class="return"><th><div id="' . $containerName . '" class="z"></div></th><th colspan="3">';
}
$fpage .= '<script language="Javascript">var ' . $containerName . ' = new Time("' . $containerName . '", ' . ($this->time - TIME_NOW) . ', true);</script>';
/*if(!$this->fleet_mess) $fpage .= '<span class="flight '.$className.'">';
else $fpage .= '<span class="return '.$className.'">';
if($this->fleet_owner == WCF::getUser()->userID && RequestHandler::getActiveRequest()->page != 'PhalanxPage') $fpage .= 'Eine deiner ';
else if(RequestHandler::getActiveRequest()->page != 'PhalanxPage') $fpage .= 'Eine fremde ';
else $fpage .= 'Eine ';
if(!empty($shipStr)) $fpage .= '<a href="#" onmouseover="this.T_WIDTH=150;return escape(\''.$shipStr.'\');" class="'.$className.'">';
if($this->fleet_owner == WCF::getUser()->userID && RequestHandler::getActiveRequest()->page != 'PhalanxPage') $fpage .= 'Flotten';
else $fpage .= 'Flotte';
if(!empty($shipStr)) $fpage .= '</a> ';
$fpage .= ' vom '.$this->getStartPlanet();
if(!$this->fleet_mess && $this->fleet_mission != 8) $fpage .= ' erreicht den ';
else $fpage .= ' kehrt vom ';
$fpage .= $this->getEndPlanet();
if(!$this->fleet_mess) $fpage .= '. Ihr Auftrag lautet: ';
else $fpage .= ' zurück. Ihr Auftrag lautete: ';
if(!empty($transport)) $fpage .= '<a href="#" onmouseover="this.T_WIDTH=150; return escape(\'Transport: '.$transport.'\');" class="'.$className.'">';
$fpage .= LWCore::$missionTypes[$this->fleet_mission];
if(!empty($transport)) $fpage .= '</a>';
$fpage .= '</span>';*/
$sql = "SELECT *\n\t\t\t\tFROM ugml_naval_formation_to_fleets\n\t\t\t\tWHERE formationID = " . $this->formationID;
$result = WCF::getDB()->sendQuery($sql);
$viewedFleet = false;
while ($row = WCF::getDB()->fetchArray($result)) {
$fleet = new Fleet($row['fleetID']);
if (!$fleet->fleet_mess) {
$text = $fleet->viewFleet($ownFleet);
if (!empty($text)) {
if ($viewedFleet) {
$fpage .= '<br /><br />';
} else {
$viewedFleet = true;
}
$fpage .= $text;
}
}
}
$fpage .= '</th></tr>';
return $fpage;
}
