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; }