Difference between revisions of "Template:DataShipLong"
(52 intermediate revisions by the same user not shown) | |||
Line 5: | Line 5: | ||
</css><div style="height:0px;"> | </css><div style="height:0px;"> | ||
− | + | __NOTITLE__ | |
{{#rawquery: SELECT * FROM DataShip WHERE ID = '{{{1}}}'; | 1 | DataShip }} | {{#rawquery: SELECT * FROM DataShip WHERE ID = '{{{1}}}'; | 1 | DataShip }} | ||
Line 24: | Line 24: | ||
</div> | </div> | ||
− | <img src="http:// | + | <img src="http://11rdp.fr/dbimages/ship_{{ #getdata: ID | DataShip }}.jpg" class="baloogan_small_image" id="baloogan_image" /> |
<div style="min-height:40px;COLOR: #000066; FONT-WEIGHT: bold; FONT-SIZE: 14pt; BACKGROUND: #eee; FONT-FAMILY: Arial, Helvetica, sans-serif;BORDER: #ccc 1px solid;"> | <div style="min-height:40px;COLOR: #000066; FONT-WEIGHT: bold; FONT-SIZE: 14pt; BACKGROUND: #eee; FONT-FAMILY: Arial, Helvetica, sans-serif;BORDER: #ccc 1px solid;"> | ||
<nowiki>#</nowiki>{{ #getdata: ID | DataShip }} - {{ #getdata: Name | DataShip }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataShip }}-{{ #getdata: YearDecommissioned | DataShip }}, {{ #getdata: Comments | DataShip }} | <nowiki>#</nowiki>{{ #getdata: ID | DataShip }} - {{ #getdata: Name | DataShip }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataShip }}-{{ #getdata: YearDecommissioned | DataShip }}, {{ #getdata: Comments | DataShip }} | ||
</div> | </div> | ||
+ | {| style="width=100%;" | | ||
+ | | style="vertical-align:top;" | | ||
+ | __TOC__ | ||
+ | | style="vertical-align:top;width=100%;min-width:200px;" | | ||
+ | {{Description:Ship_{{ #getdata: ID | DataShip }}}} | ||
+ | |||
+ | {{Description:Listing_Ship_{{ #getdata: ID | DataShip }}}} | ||
+ | |||
+ | [http://wiki.baloogancampaign.com/index.php/Description:Ship_{{ #getdata: ID | DataShip }}?action=edit Edit description] | ||
+ | |} | ||
====General Data==== | ====General Data==== | ||
{|class="wikitable" | {|class="wikitable" | ||
− | |Category: | + | |'''Country:''' |
+ | | [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}}]] | ||
+ | |'''Service:''' | ||
+ | | [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}} {{#replace:{{#replace:{{ #getdata: Description | EnumOperatorService }}|[|(}}|]|)}}]] | ||
+ | |- | ||
+ | |'''Category:''' | ||
|[[{{ #getdata: Description | EnumShipCategory }}]] | |[[{{ #getdata: Description | EnumShipCategory }}]] | ||
− | |Max Sea State: | + | |'''Max Sea State:''' |
|{{ #getdata: MaxSeaState | DataShip }} | |{{ #getdata: MaxSeaState | DataShip }} | ||
|- | |- | ||
− | |Type: | + | |'''Type:''' |
|[[{{ #getdata: Description | EnumShipType }}]] | |[[{{ #getdata: Description | EnumShipType }}]] | ||
− | |Troop Capacity: | + | |'''Troop Capacity:''' |
|{{ #getdata: TroopCapacity | DataShip }} | |{{ #getdata: TroopCapacity | DataShip }} | ||
|- | |- | ||
− | |Damage Points: | + | |'''Damage Points:''' |
|{{ #getdata: DamagePoints | DataShip }} | |{{ #getdata: DamagePoints | DataShip }} | ||
− | |Cargo Capacity: | + | |'''Cargo Capacity:''' |
|{{ #getdata: CargoCapacity | DataShip }} | |{{ #getdata: CargoCapacity | DataShip }} | ||
|- | |- | ||
− | |Length: | + | |'''Length:''' |
|{{ #getdata: Length | DataShip }} m | |{{ #getdata: Length | DataShip }} m | ||
− | |Pier / Dock / Davit Size: | + | |'''Pier / Dock / Davit Size:''' |
|{{ #getdata: Description | EnumShipPhysicalSize }} | |{{ #getdata: Description | EnumShipPhysicalSize }} | ||
|- | |- | ||
− | |Beam: | + | |'''Beam:''' |
|{{ #getdata: Beam | DataShip }} m | |{{ #getdata: Beam | DataShip }} m | ||
|- | |- | ||
− | |Draft: | + | |'''Draft:''' |
|{{ #getdata: Draft | DataShip }} m | |{{ #getdata: Draft | DataShip }} m | ||
|- | |- | ||
− | |Height: | + | |'''Height:''' |
|{{ #getdata: Height | DataShip }} m | |{{ #getdata: Height | DataShip }} m | ||
|- | |- | ||
− | |Empty Displacement: | + | |'''Empty Displacement:''' |
|{{ #getdata: DisplacementEmpty | DataShip }} tons | |{{ #getdata: DisplacementEmpty | DataShip }} tons | ||
|- | |- | ||
− | |Standard Displacement: | + | |'''Standard Displacement:''' |
|{{ #getdata: DisplacementStandard | DataShip }} tons | |{{ #getdata: DisplacementStandard | DataShip }} tons | ||
|- | |- | ||
− | |Full Displacement: | + | |'''Full Displacement:''' |
|{{ #getdata: DisplacementFull | DataShip }} tons | |{{ #getdata: DisplacementFull | DataShip }} tons | ||
|- | |- | ||
− | |Crew: | + | |'''Crew:''' |
|{{ #getdata: Crew | DataShip }} | |{{ #getdata: Crew | DataShip }} | ||
+ | |} | ||
+ | |||
+ | ====Properties==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipCodesCount }} | ||
+ | {|class="wikitable" | ||
+ | !Property | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: PropertyIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipCodesCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:PropertyIndex}} | DataShipCodes}} | ||
+ | {{#rawquery: SELECT * FROM EnumShipCode WHERE ID = '{{ #getdata: CodeID | DataShipCodes }}'; | 1 | EnumShipCode }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}[[{{#replace:{{#replace:{{#getdata: Description| EnumShipCode }}|[|(}}|]|)}}]] | ||
+ | }} | ||
+ | |} | ||
+ | ====Air Facilities==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipAircraftFacilities WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipAircraftFacilitiesCount }} | ||
+ | {|class="wikitable" | ||
+ | !Facility Type | ||
+ | !Physical Size | ||
+ | !Capacity | ||
+ | !Runway Length | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: DataShipAircraftFacilityIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipAircraftFacilitiesCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipAircraftFacilities WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:DataShipAircraftFacilityIndex}} | DataShipAircraftFacilities }} | ||
+ | {{#rawquery: SELECT * FROM DataAircraftFacility WHERE ID = '{{ #getdata: ComponentID | DataShipAircraftFacilities }}'; | 1 | DataAircraftFacility }} | ||
+ | {{#rawquery: SELECT * FROM EnumAircraftFacilityType WHERE ID = '{{ #getdata: Type | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityType }} | ||
+ | {{#rawquery: SELECT * FROM EnumAircraftFacilityPhysicalSize WHERE ID = '{{ #getdata: PhysicalSize | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityPhysicalSize }} | ||
+ | {{#rawquery: SELECT * FROM EnumAircraftFacilityRunwayLength WHERE ID = '{{ #getdata: RunwayLength | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityRunwayLength }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description| EnumAircraftFacilityType }}]] | ||
+ | {{!}} [[{{#getdata: Description| EnumAircraftFacilityPhysicalSize }}]] | ||
+ | {{!}} {{#getdata: Capacity| DataAircraftFacility }} | ||
+ | {{!}} {{#ifeq: {{#getdata: Description| EnumAircraftFacilityRunwayLength }} | None | | [[{{#getdata: Description| EnumAircraftFacilityRunwayLength }}]]}} | ||
+ | }} | ||
|} | |} | ||
====Sensors/EW==== | ====Sensors/EW==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipSensorsCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | |+Sensors | ||
+ | !Name | ||
+ | !Type | ||
+ | !Role | ||
+ | !Max Range (nm) | ||
+ | !Arc Search | ||
+ | !Arc Engage | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: SensorIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipSensorsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:SensorIndex}} | DataShipSensors}} | ||
+ | {{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataShipSensors }}'; | 1 | DataSensor }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorSensorGroupsCount }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]''' | ||
+ | {{!}}[[{{#getdata: Description | EnumSensorType}}]] | ||
+ | {{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole}}|[|(}}|]|)}}]]''' | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: SensorCapabilityIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:SensorCapabilityIndex}} | DataSensorCapabilities }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorCapability WHERE ID = '{{ #getdata: CodeID | DataSensorCapabilities }}'; | 1 | EnumSensorCapability }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumSensorCapability }}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}+Sensors | ||
+ | !Name | ||
+ | !Type | ||
+ | !Role | ||
+ | !Max Range (nm) | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: SensorGroupIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:SensorGroupIndex}} | DataSensorSensorGroups}} | ||
+ | {{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataSensorSensorGroups }}'; | 1 | DataSensor2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor2 }}'; | 1 | DataSensorCapabilitiesCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]''' | ||
+ | {{!}}[[{{#getdata: Description | EnumSensorType2}}]] | ||
+ | {{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole2}}|[|(}}|]|)}}]]''' | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: SensorCapabilityIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor2 }}' ; | {{#var:SensorCapabilityIndex}} | DataSensorCapabilities }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorCapability WHERE ID = '{{ #getdata: CodeID | DataSensorCapabilities }}'; | 1 | EnumSensorCapability }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumSensorCapability }}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}}{{#getdata: RangeMax | DataSensor2 }} | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}}{{#getdata: RangeMax | DataSensor }} | ||
+ | {{!}}{{RenderArc|{{#getdata: SB1 | DataShipSensors }}|{{#getdata: SB2 | DataShipSensors }}|{{#getdata: SMF1 | DataShipSensors }}|{{#getdata: SMF2 | DataShipSensors }}|{{#getdata: SMA1 | DataShipSensors }}|{{#getdata: SMA2 | DataShipSensors }}|{{#getdata: SS1 | DataShipSensors }}|{{#getdata: SS2 | DataShipSensors }}|{{#getdata: PB1 | DataShipSensors }}|{{#getdata: PB2 | DataShipSensors }}|{{#getdata: PMF1 | DataShipSensors }}|{{#getdata: PMF2 | DataShipSensors }}|{{#getdata: PMA1 | DataShipSensors }}|{{#getdata: PMA2 | DataShipSensors }}|{{#getdata: PS1 | DataShipSensors }}|{{#getdata: PS2 | DataShipSensors }}}} | ||
+ | {{!}}{{RenderArc|{{#getdata: SB1Max | DataShipSensors }}|{{#getdata: SB2Max | DataShipSensors }}|{{#getdata: SMF1Max | DataShipSensors }}|{{#getdata: SMF2Max | DataShipSensors }}|{{#getdata: SMA1Max | DataShipSensors }}|{{#getdata: SMA2Max | DataShipSensors }}|{{#getdata: SS1Max | DataShipSensors }}|{{#getdata: SS2Max | DataShipSensors }}|{{#getdata: PB1Max | DataShipSensors }}|{{#getdata: PB2Max | DataShipSensors }}|{{#getdata: PMF1Max | DataShipSensors }}|{{#getdata: PMF2Max | DataShipSensors }}|{{#getdata: PMA1Max | DataShipSensors }}|{{#getdata: PMA2Max | DataShipSensors }}|{{#getdata: PS1Max | DataShipSensors }}|{{#getdata: PS2Max | DataShipSensors }}}} | ||
+ | }} | ||
+ | |} | ||
+ | |||
+ | ====Mounts==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipMounts WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipMountsCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | |+ Mounts | ||
+ | !Mount | ||
+ | !ROF | ||
+ | !Capacity | ||
+ | !Weapons, Sensors and Magazine | ||
+ | !Arc | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: MountIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipMountsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipMounts WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:MountIndex}} | DataShipMounts}} | ||
+ | {{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataShipMounts }}'; | 1 | DataMount }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountWeaponsCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}'''{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}''' | ||
+ | {{!}}{{#getdata: ROF | DataMount}} | ||
+ | {{!}}{{#getdata: Capacity | DataMount}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable sortable" | ||
+ | {{!}}+Weapons | ||
+ | !Name | ||
+ | !Type | ||
+ | !DefaultLoad | ||
+ | !MaxLoad | ||
+ | !ROF | ||
+ | !Range | ||
+ | !Targets | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: MountWeaponIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataMountWeaponsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | {{#var:MountWeaponIndex}} | DataMountWeapons}} | ||
+ | {{#rawquery: SELECT * FROM DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMountWeapons }}'; | 1 | DataWeaponRecord }} | ||
+ | {{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponTargetsCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataWeapon?ID={{#getdata: ID | DataWeapon}} {{#replace:{{#replace:{{#getdata: Name | DataWeapon}}|[|(}}|]|)}}]''' | ||
+ | {{!}}[[{{#getdata: Description | EnumWeaponType}}]] | ||
+ | {{!}}{{#getdata: DefaultLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: MaxLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: ROF | DataWeaponRecord}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | ! | ||
+ | !Min | ||
+ | !Max | ||
+ | {{!}}- | ||
+ | {{#ifeq: {{#getdata: AirRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Air''' | ||
+ | {{!}}{{#getdata: AirRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: AirRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Surface''' | ||
+ | {{!}}{{#getdata: SurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SurfaceRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SubsurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Subsurface''' | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: WeaponTargetIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataWeaponTargetsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | {{#var:WeaponTargetIndex}} | DataWeaponTargets }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponTarget WHERE ID = '{{ #getdata: CodeID | DataWeaponTargets }}'; | 1 | EnumWeaponTarget }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumWeaponTarget}}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | }} | ||
+ | {{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountSensorsCount }} | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataMountSensorsCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}+Sensors | ||
+ | !Name | ||
+ | !Type | ||
+ | !Role | ||
+ | !Max Range (nm) | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: MountSensorIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataMountSensorsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}' ; | {{#var:MountSensorIndex}} | DataMountSensors}} | ||
+ | {{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataMountSensors }}'; | 1 | DataSensor }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorSensorGroupsCount }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]''' | ||
+ | {{!}}[[{{#getdata: Description | EnumSensorType}}]] | ||
+ | {{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole}}|[|(}}|]|)}}]]''' | ||
+ | |||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: SensorCapabilityIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:SensorCapabilityIndex}} | DataSensorCapabilities }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorCapability WHERE ID = '{{ #getdata: CodeID | DataSensorCapabilities }}'; | 1 | EnumSensorCapability }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumSensorCapability }}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;" | }} | ||
+ | {{!}}+Sensors | ||
+ | !Name | ||
+ | !Type | ||
+ | !Role | ||
+ | !Max Range (nm) | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: MountSensorGroupIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:MountSensorGroupIndex}} | DataSensorSensorGroups}} | ||
+ | {{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataSensorSensorGroups }}'; | 1 | DataSensor2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }} | ||
+ | {{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]''' | ||
+ | {{!}} [[{{#getdata: Description | EnumSensorType2}}]] | ||
+ | {{!}} {{#getdata: Description | EnumSensorRole2}} | ||
+ | {{!}} {{#getdata: RangeMax | DataSensor2 }} | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} {{#getdata: RangeMax | DataSensor }} | ||
+ | }} | ||
+ | {{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountMagazineWeaponsCount }} | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }} | 0 | style="display:none;" | inline }} | ||
+ | {{!}}+Magazine | ||
+ | !Name | ||
+ | !Type | ||
+ | !DefaultLoad | ||
+ | !MaxLoad | ||
+ | !ROF | ||
+ | !Range | ||
+ | !Targets | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: MountMagazineIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataMountMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMount }}' ; | {{#var:MountMagazineIndex}} | DataMountMagazineWeapons}} | ||
+ | {{#rawquery: SELECT * FROM DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMountMagazineWeapons }}'; | 1 | DataWeaponRecord }} | ||
+ | {{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponTargetsCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}{{#replace:{{#replace:{{#getdata: Name | DataWeapon}}|[|(}}|]|)}} | ||
+ | {{!}}[[{{#getdata: Description | EnumWeaponType}}]] | ||
+ | {{!}}{{#getdata: DefaultLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: MaxLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: ROF | DataWeaponRecord}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | ! | ||
+ | !Min | ||
+ | !Max | ||
+ | {{!}}- | ||
+ | {{#ifeq: {{#getdata: AirRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Air''' | ||
+ | {{!}}{{#getdata: AirRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: AirRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Surface''' | ||
+ | {{!}}{{#getdata: SurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SurfaceRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SubsurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Subsurface''' | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: WeaponTargetIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataWeaponTargetsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | {{#var:WeaponTargetIndex}} | DataWeaponTargets }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponTarget WHERE ID = '{{ #getdata: CodeID | DataWeaponTargets }}'; | 1 | EnumWeaponTarget }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumWeaponTarget}}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}}{{RenderArc|{{#getdata: SB1 | DataShipMounts }}|{{#getdata: SB2 | DataShipMounts }}|{{#getdata: SMF1 | DataShipMounts }}|{{#getdata: SMF2 | DataShipMounts }}|{{#getdata: SMA1 | DataShipMounts }}|{{#getdata: SMA2 | DataShipMounts }}|{{#getdata: SS1 | DataShipMounts }}|{{#getdata: SS2 | DataShipMounts }}|{{#getdata: PB1 | DataShipMounts }}|{{#getdata: PB2 | DataShipMounts }}|{{#getdata: PMF1 | DataShipMounts }}|{{#getdata: PMF2 | DataShipMounts }}|{{#getdata: PMA1 | DataShipMounts }}|{{#getdata: PMA2 | DataShipMounts }}|{{#getdata: PS1 | DataShipMounts }}|{{#getdata: PS2 | DataShipMounts }}}} | ||
+ | }} | ||
+ | |} | ||
+ | |||
+ | ====Magazines==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipMagazines WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipMagazinesCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | !Name | ||
+ | !Capacity | ||
+ | !Content | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: MagazineIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipMagazinesCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipMagazines WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:MagazineIndex}} | DataShipMagazines }} | ||
+ | {{#rawquery: SELECT * FROM DataMagazine WHERE ID = '{{ #getdata: ComponentID | DataShipMagazines }}'; | 1 | DataMagazine }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMagazine }}'; | 1 | DataMagazineWeaponsCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} {{#getdata: Name | DataMagazine}} | ||
+ | {{!}} {{#getdata: Capacity | DataMagazine}} | ||
+ | {{!}} | ||
+ | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataMagazineWeaponsCount }} | 0 | style="display:none;" | }} | ||
+ | !Name | ||
+ | !Type | ||
+ | !DefaultLoad | ||
+ | !MaxLoad | ||
+ | !ROF | ||
+ | !Range | ||
+ | !Targets | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: MagazineWeaponIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataMagazineWeaponsCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMagazine }}' ; | {{#var:MagazineWeaponIndex}} | DataMagazineWeapons}} | ||
+ | {{#rawquery: SELECT * FROM DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMagazineWeapons }}'; | 1 | DataWeaponRecord }} | ||
+ | {{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponTargetsCount }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} '''[http://wiki.baloogancampaign.com/index.php/DataWeapon?ID={{#getdata: ID | DataWeapon}} {{#replace:{{#replace:{{#getdata: Name | DataWeapon}}|[|(}}|]|)}}]''' | ||
+ | {{!}}[[{{#getdata: Description | EnumWeaponType}}]] | ||
+ | {{!}}{{#getdata: DefaultLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: MaxLoad | DataWeaponRecord}} | ||
+ | {{!}}{{#getdata: ROF | DataWeaponRecord}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | ! | ||
+ | !Min | ||
+ | !Max | ||
+ | {{!}}- | ||
+ | {{#ifeq: {{#getdata: AirRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Air''' | ||
+ | {{!}}{{#getdata: AirRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: AirRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Surface''' | ||
+ | {{!}}{{#getdata: SurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SurfaceRangeMax | DataWeapon}} nm | ||
+ | {{!}}- | ||
+ | }} | ||
+ | {{#ifeq: {{#getdata: SubsurfaceRangeMax | DataWeapon}} | 0 || | ||
+ | {{!}} '''Subsurface''' | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | ||
+ | {{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: WeaponTargetIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataWeaponTargetsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | {{#var:WeaponTargetIndex}} | DataWeaponTargets }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponTarget WHERE ID = '{{ #getdata: CodeID | DataWeaponTargets }}'; | 1 | EnumWeaponTarget }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumWeaponTarget}}]] | ||
+ | }} | ||
+ | {{!}}} | ||
+ | }} | ||
+ | {{!}}} | ||
+ | }} | ||
+ | |} | ||
+ | |||
+ | ====Signatures==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipSignatures WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipSignaturesCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | !Signature Type | ||
+ | !Front | ||
+ | !Side | ||
+ | !Rear | ||
+ | !Top | ||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | nm for Visual/Pac | ||
+ | | dBsm for Radar | ||
+ | | db for Sonar | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: SignatureIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipSignaturesCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipSignatures WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:SignatureIndex}} | DataShipSignatures }} | ||
+ | {{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataShipSignatures }}'; | 1 | EnumSignatureType }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}[[{{#getdata: Description | EnumSignatureType}}]] | ||
+ | {{!}} {{#getdata: Front | DataShipSignatures}} | ||
+ | {{!}} {{#getdata: Side | DataShipSignatures}} | ||
+ | {{!}} {{#getdata: Rear | DataShipSignatures}} | ||
+ | {{!}} {{#getdata: Top | DataShipSignatures}} | ||
+ | }} | ||
+ | |} | ||
+ | ====Comms/Datalinks==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipComms WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipCommsCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | |+Comms | ||
+ | !Name | ||
+ | !Type | ||
+ | !Range (nm) | ||
+ | !Channels | ||
+ | |- | ||
{{ | {{ | ||
− | #loop: | + | #loop: CommIndex |
| 1 | | 1 | ||
− | | {{#getdata: COUNT(1) | | + | | {{#getdata: COUNT(1) | DataShipCommsCount }} |
− | | <nowiki/>{{#rawquery: SELECT * FROM | + | | <nowiki/><div style="display:none;"> |
− | {{#rawquery: SELECT * FROM | + | {{#rawquery: SELECT * FROM DataShipComms WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:CommIndex}} | DataShipComms}} |
− | {{# | + | {{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataShipComms }}'; | 1 | DataComm }} |
− | + | {{#rawquery: SELECT * FROM EnumCommType WHERE ID = '{{ #getdata: Type | DataComm }}'; | 1 | EnumCommType }} | |
− | + | </div> | |
− | + | {{!}}- | |
− | + | {{!}}{{#replace:{{#replace:{{#getdata: Name | DataComm}}|[|(}}|]|)}} | |
− | + | {{!}}[[{{#getdata: Description | EnumCommType}}]] | |
− | + | {{!}}{{#getdata: MyRange | DataComm}} | |
− | + | {{!}}{{#getdata: Channels | DataComm }} | |
− | + | }} | |
− | * | + | |} |
− | * | + | ====Propulsion==== |
− | * | + | {{#rawquery: SELECT COUNT(1) FROM DataShipPropulsion WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipPropulsionCount }} |
− | + | {|class="wikitable sortable" | |
− | |}} | + | !Engines |
+ | !Type | ||
+ | !Creep Speed (kts) | ||
+ | !Cruise Speed (kts) | ||
+ | !Full Speed (kts) | ||
+ | !Flank Speed (kts) | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: PropulsionIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipPropulsionCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipPropulsion WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:PropulsionIndex}} | DataShipPropulsion}} | ||
+ | {{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataShipPropulsion }}'; | 1 | DataPropulsion }} | ||
+ | {{#rawquery: SELECT * FROM EnumPropulsionType WHERE ID = '{{ #getdata: Type | DataPropulsion }}'; | 1 | EnumPropulsionType }} | ||
+ | {{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='1'; | 1 | DataPropulsionPerformance1 }} | ||
+ | {{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='2'; | 1 | DataPropulsionPerformance2 }} | ||
+ | {{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='3'; | 1 | DataPropulsionPerformance3 }} | ||
+ | {{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='4'; | 1 | DataPropulsionPerformance4 }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}{{#replace:{{#replace:{{#getdata: Name | DataPropulsion}}|[|(}}|]|)}} | ||
+ | {{!}}[[{{#getdata: Description | EnumPropulsionType}}]] | ||
+ | {{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance1 | true }} | ||
+ | {{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance2 | true }} | ||
+ | {{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance3 | true }} | ||
+ | {{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance4 | true }} | ||
+ | }} | ||
+ | |} | ||
+ | |||
+ | ====Fuel==== | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataShipFuel WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipFuelCount }} | ||
+ | {|class="wikitable sortable" | ||
+ | !Fuel Type | ||
+ | !Quantity (kg) | ||
+ | |- | ||
+ | {{ | ||
+ | #loop: FuelIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataShipFuelCount }} | ||
+ | | <nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataShipFuel WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:FuelIndex}} | DataShipFuel }} | ||
+ | {{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataShipFuel }}'; | 1 | DataFuel }} | ||
+ | {{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}}[[{{#getdata: Description | EnumFuelType}}]] | ||
+ | {{!}}{{#getdata: Capacity | DataFuel}} | ||
}} | }} | ||
+ | |} |
Latest revision as of 01:48, 20 December 2014
<img src="http://11rdp.fr/dbimages/ship_DataInvoker Error: getData error: No such key in handle (ID).jpg" class="baloogan_small_image" id="baloogan_image" />
#DataInvoker Error: getData error: No such key in handle (ID) - DataInvoker Error: getData error: No such key in handle (Name) -- DataInvoker Error: getData error: No such key in handle (Description) (DataInvoker Error: getData error: No such key in handle (Description)), DataInvoker Error: getData error: No such key in handle (YearCommissioned)-DataInvoker Error: getData error: No such key in handle (YearDecommissioned), DataInvoker Error: getData error: No such key in handle (Comments)
{{Description:Ship_DataInvoker Error: getData error: No such key in handle (ID)}} {{Description:Listing_Ship_DataInvoker Error: getData error: No such key in handle (ID)}} DataInvoker Error: getData error: No such key in handle (ID)?action=edit Edit description |
General Data
Country: | [[DataInvoker Error: getData error: No such key in handle (Description)]] | Service: | [[DataInvoker Error: getData error: No such key in handle (Description) DataInvoker Error: getData error: No such key in handle (Description)]] |
Category: | [[DataInvoker Error: getData error: No such key in handle (Description)]] | Max Sea State: | DataInvoker Error: getData error: No such key in handle (MaxSeaState) |
Type: | [[DataInvoker Error: getData error: No such key in handle (Description)]] | Troop Capacity: | DataInvoker Error: getData error: No such key in handle (TroopCapacity) |
Damage Points: | DataInvoker Error: getData error: No such key in handle (DamagePoints) | Cargo Capacity: | DataInvoker Error: getData error: No such key in handle (CargoCapacity) |
Length: | DataInvoker Error: getData error: No such key in handle (Length) m | Pier / Dock / Davit Size: | DataInvoker Error: getData error: No such key in handle (Description) |
Beam: | DataInvoker Error: getData error: No such key in handle (Beam) m | ||
Draft: | DataInvoker Error: getData error: No such key in handle (Draft) m | ||
Height: | DataInvoker Error: getData error: No such key in handle (Height) m | ||
Empty Displacement: | DataInvoker Error: getData error: No such key in handle (DisplacementEmpty) tons | ||
Standard Displacement: | DataInvoker Error: getData error: No such key in handle (DisplacementStandard) tons | ||
Full Displacement: | DataInvoker Error: getData error: No such key in handle (DisplacementFull) tons | ||
Crew: | DataInvoker Error: getData error: No such key in handle (Crew) |
Properties
Property |
---|
Air Facilities
Facility Type | Physical Size | Capacity | Runway Length |
---|
Sensors/EW
Name | Type | Role | Max Range (nm) | Arc Search | Arc Engage |
---|
Mounts
Mount | ROF | Capacity | Weapons, Sensors and Magazine | Arc |
---|
Magazines
Name | Capacity | Content |
---|
Signatures
Signature Type | Front | Side | Rear | Top |
---|---|---|---|---|
nm for Visual/Pac | dBsm for Radar | db for Sonar |
Comms/Datalinks
Name | Type | Range (nm) | Channels |
---|
Propulsion
Engines | Type | Creep Speed (kts) | Cruise Speed (kts) | Full Speed (kts) | Flank Speed (kts) |
---|
Fuel
Fuel Type | Quantity (kg) |
---|