public static function GetFleetsForAlliance($allianceId)
{
if (!is_int($allianceId)) {
throw new Exception("allianceId was not an int.");
}
$conn = DataManager::GetInstance()->GetConnection();
$stmt = $conn->prepare('SELECT id, allianceid, name, added FROM fleet WHERE added > ? AND allianceid = ?');
$stmt->bind_param('si', DataManager::FormatTimestampForSql(LastDowntimeMidpoint()), $allianceId);
$stmt->execute();
$stmt->bind_result($id, $allianceId, $name, $added);
$fleets = array();
while ($stmt->fetch()) {
$f = new Fleet();
Fleet::fill($f, $id, $allianceId, $name, $added);
$fleets[] = $f;
}
$stmt->close();
return $fleets;
}
