View source for Template:DataShipLong

<css>
p {
line-height:18px;
}
</css><div style="height:0px;">

__NOTITLE__

{{#rawquery: SELECT * FROM DataShip WHERE ID = '{{{1}}}'; | 1 | DataShip }}

{{#rawquery: SELECT * FROM EnumOperatorCountry WHERE ID = '{{ #getdata: OperatorCountry | DataShip }}'; | 1 | EnumOperatorCountry }}

{{#rawquery: SELECT * FROM EnumOperatorService WHERE ID = '{{ #getdata: OperatorService | DataShip }}'; | 1 | EnumOperatorService }}

{{#rawquery: SELECT * FROM EnumShipType WHERE ID = '{{ #getdata: Type | DataShip }}'; | 1 | EnumShipType }}

{{#rawquery: SELECT * FROM EnumShipCategory WHERE ID = '{{ #getdata: Category | DataShip }}'; | 1 | EnumShipCategory}}

{{#rawquery: SELECT COUNT(1) FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipSensorsCount }}

{{#rawquery: SELECT * FROM EnumShipPhysicalSize WHERE ID = '{{ #getdata: PhysicalSizeCode | DataShip }}'; | 1 | EnumShipPhysicalSize }}

{{DISPLAYTITLE:{{ #getdata: Name | DataShip }}}}

</div>
<img src="http://baloogan.images.blu3wolf.com/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;">
<nowiki>#</nowiki>{{ #getdata: ID | DataShip }} - {{ #getdata: Name | DataShip  }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataShip }}-{{ #getdata: YearDecommissioned | DataShip }}, {{ #getdata: Comments | DataShip }}
</div>
{| style="width=100%;" |
| style="vertical-align:top;" |
__TOC__ 
| style="vertical-align:top;width=100%;min-width:200px;" |
{{Description:Ship_{{ #getdata: ID | DataShip }}}}

[http://wiki.baloogancampaign.com/index.php/Description:Ship_{{ #getdata: ID | DataShip }}?action=edit Edit description]
|}
====General Data====
{|class="wikitable"
|'''Country:'''
| [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}}]]
|'''Service:'''
| [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}} {{#replace:{{#replace:{{ #getdata: Description | EnumOperatorService }}|[|(}}|]|)}}]]
|-
|'''Category:'''
|[[{{ #getdata: Description | EnumShipCategory }}]]
|'''Max Sea State:'''
|{{ #getdata: MaxSeaState | DataShip }}
|-
|'''Type:'''
|[[{{ #getdata: Description | EnumShipType }}]]
|'''Troop Capacity:'''
|{{ #getdata: TroopCapacity | DataShip }}
|-
|'''Damage Points:'''
|{{ #getdata: DamagePoints | DataShip }}
|'''Cargo Capacity:'''
|{{ #getdata: CargoCapacity | DataShip }}
|-
|'''Length:'''
|{{ #getdata: Length | DataShip }} m
|'''Pier / Dock / Davit Size:'''
|{{ #getdata: Description | EnumShipPhysicalSize }}
|-
|'''Beam:'''
|{{ #getdata: Beam | DataShip }} m
|-
|'''Draft:'''
|{{ #getdata: Draft | DataShip }} m
|-
|'''Height:'''
|{{ #getdata: Height | DataShip }} m
|-
|'''Empty Displacement:'''
|{{ #getdata: DisplacementEmpty | DataShip }} tons
|-
|'''Standard Displacement:'''
|{{ #getdata: DisplacementStandard | DataShip }} tons
|-
|'''Full Displacement:'''
|{{ #getdata: DisplacementFull | DataShip }} tons
|-
|'''Crew:'''
|{{ #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====
{{#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}}]]
{{!}}'''{{#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}}]]
{{!}}{{#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}}]]
{{!}}{{#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: CommIndex
| 1
| {{#getdata: COUNT(1) | DataShipCommsCount }}
| <nowiki/><div style="display:none;">
{{#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}}
}}
|}