View source for Template:DataSubmarineLong

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

__NOTITLE__

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

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

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

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

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

{{#rawquery: SELECT COUNT(1) FROM DataSubmarineSensors WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineSensorsCount }}

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

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

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

{{Description:Listing_Submarine_{{ #getdata: ID | DataSubmarine }}}}

[http://wiki.baloogancampaign.com/index.php/Description:Submarine_{{ #getdata: ID | DataSubmarine }}?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 | EnumSubmarineCategory }}]]
|'''Max Depth:'''
| {{ #getdata: MaxDepth | DataSubmarine }} m
|-
|'''Type:'''
|[[{{ #getdata: Description | EnumSubmarineType }}]]
|'''Pier / Dock / Davit Size:'''
|{{ #getdata: Description | EnumSubmarinePhysicalSize }}
|-
|'''Damage Points:'''
|{{ #getdata: DamagePoints | DataSubmarine }}
|'''ROV Operating Radius:'''
|{{ #getdata: ROVRadius | DataSubmarine }}
|-
|'''Length:'''
|{{ #getdata: Length | DataSubmarine }} m
|-
|'''Beam:'''
|{{ #getdata: Beam | DataSubmarine }} m
|-
|'''Draft:'''
|{{ #getdata: Draft | DataSubmarine }} m
|-
|'''Height:'''
|{{ #getdata: Height | DataSubmarine }} m
|-
|'''Empty Displacement:'''
|{{ #getdata: DisplacementEmpty | DataSubmarine }} tons
|-
|'''Standard Displacement:'''
|{{ #getdata: DisplacementStandard | DataSubmarine }} tons
|-
|'''Full Displacement:'''
|{{ #getdata: DisplacementFull | DataSubmarine }} tons
|-
|'''Crew:'''
|{{ #getdata: Crew | DataSubmarine }}
|}

====Properties====
{{#rawquery: SELECT COUNT(1) FROM DataSubmarineCodes WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineCodesCount }}
{|class="wikitable"
!Property
|-
{{
#loop: PropertyIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineCodesCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineCodes WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | {{#var:PropertyIndex}} | DataSubmarineCodes}}
{{#rawquery: SELECT * FROM EnumSubmarineCode WHERE ID = '{{ #getdata: CodeID | DataSubmarineCodes }}'; | 1 | EnumSubmarineCode }}
</div>
{{!}}-
{{!}}[[{{#replace:{{#replace:{{#getdata: Description| EnumSubmarineCode }}|[|(}}|]|)}}]]
}}
|}

====Sensors/EW====
{{#rawquery: SELECT COUNT(1) FROM DataSubmarineSensors WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineSensorsCount }}
{|class="wikitable sortable"
|+Sensors
!Name
!Type
!Role
!Max Range (nm)
!Arc Search
!Arc Engage
|-
{{
#loop: SensorIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineSensorsCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineSensors WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:SensorIndex}} | DataSubmarineSensors}}
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataSubmarineSensors }}'; | 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 | DataSubmarineSensors }}|{{#getdata: SB2 | DataSubmarineSensors }}|{{#getdata: SMF1 | DataSubmarineSensors }}|{{#getdata: SMF2 | DataSubmarineSensors }}|{{#getdata: SMA1 | DataSubmarineSensors }}|{{#getdata: SMA2 | DataSubmarineSensors }}|{{#getdata: SS1 | DataSubmarineSensors }}|{{#getdata: SS2 | DataSubmarineSensors }}|{{#getdata: PB1 | DataSubmarineSensors }}|{{#getdata: PB2 | DataSubmarineSensors }}|{{#getdata: PMF1 | DataSubmarineSensors }}|{{#getdata: PMF2 | DataSubmarineSensors }}|{{#getdata: PMA1 | DataSubmarineSensors }}|{{#getdata: PMA2 | DataSubmarineSensors }}|{{#getdata: PS1 | DataSubmarineSensors }}|{{#getdata: PS2 | DataSubmarineSensors }}}}
{{!}}{{RenderArc|{{#getdata: SB1Max | DataSubmarineSensors }}|{{#getdata: SB2Max | DataSubmarineSensors }}|{{#getdata: SMF1Max | DataSubmarineSensors }}|{{#getdata: SMF2Max | DataSubmarineSensors }}|{{#getdata: SMA1Max | DataSubmarineSensors }}|{{#getdata: SMA2Max | DataSubmarineSensors }}|{{#getdata: SS1Max | DataSubmarineSensors }}|{{#getdata: SS2Max | DataSubmarineSensors }}|{{#getdata: PB1Max | DataSubmarineSensors }}|{{#getdata: PB2Max | DataSubmarineSensors }}|{{#getdata: PMF1Max | DataSubmarineSensors }}|{{#getdata: PMF2Max | DataSubmarineSensors }}|{{#getdata: PMA1Max | DataSubmarineSensors }}|{{#getdata: PMA2Max | DataSubmarineSensors }}|{{#getdata: PS1Max | DataSubmarineSensors }}|{{#getdata: PS2Max | DataSubmarineSensors }}}}
}}
|}

====Mounts====
{{#rawquery: SELECT COUNT(1) FROM DataSubmarineMounts WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineMountsCount }}
{|class="wikitable sortable"
|+ Mounts
!Mount
!ROF
!Capacity
!Weapons, Sensors and Magazine
!Arc
|-
{{
#loop: MountIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineMountsCount }}
|<nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineMounts WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | {{#var:MountIndex}} | DataSubmarineMounts}}
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataSubmarineMounts }}'; | 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 | DataSubmarineMounts }}|{{#getdata: SB2 | DataSubmarineMounts }}|{{#getdata: SMF1 | DataSubmarineMounts }}|{{#getdata: SMF2 | DataSubmarineMounts }}|{{#getdata: SMA1 | DataSubmarineMounts }}|{{#getdata: SMA2 | DataSubmarineMounts }}|{{#getdata: SS1 | DataSubmarineMounts }}|{{#getdata: SS2 | DataSubmarineMounts }}|{{#getdata: PB1 | DataSubmarineMounts }}|{{#getdata: PB2 | DataSubmarineMounts }}|{{#getdata: PMF1 | DataSubmarineMounts }}|{{#getdata: PMF2 | DataSubmarineMounts }}|{{#getdata: PMA1 | DataSubmarineMounts }}|{{#getdata: PMA2 | DataSubmarineMounts }}|{{#getdata: PS1 | DataSubmarineMounts }}|{{#getdata: PS2 | DataSubmarineMounts }}}}
}}
|}

====Magazines====
{{#rawquery: SELECT COUNT(1) FROM DataSubmarineMagazines WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineMagazinesCount }}
{|class="wikitable sortable"
!Name
!Capacity
!Content
|-
{{
#loop: MagazineIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineMagazinesCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineMagazines WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:MagazineIndex}} | DataSubmarineMagazines }}
{{#rawquery: SELECT * FROM DataMagazine WHERE ID = '{{ #getdata: ComponentID | DataSubmarineMagazines }}'; | 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 DataSubmarineSignatures WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineSignaturesCount }}
{|class="wikitable sortable"
!Signature Type
!Front (nm)
!Side (nm)
!Rear (nm)
!Top (nm)
|-
|
|
| nm for Visual/Pac
| dBsm for Radar
| db for Sonar
|-
{{
#loop: SignatureIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineSignaturesCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineSignatures WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:SignatureIndex}} | DataSubmarineSignatures }}
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataSubmarineSignatures }}'; | 1 | EnumSignatureType }}
</div>
{{!}}-
{{!}}[[{{#getdata: Description | EnumSignatureType}}]]
{{!}} {{#getdata: Front | DataSubmarineSignatures}}
{{!}} {{#getdata: Side | DataSubmarineSignatures}}
{{!}} {{#getdata: Rear | DataSubmarineSignatures}}
{{!}} {{#getdata: Top | DataSubmarineSignatures}}
}}
|}

====Comms/Datalinks====
{{#rawquery: SELECT COUNT(1) FROM DataSubmarineComms WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineCommsCount }}
{|class="wikitable sortable"
|+Comms
!Name
!Type
!Range (nm)
!Channels
|-
{{
#loop: CommIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineCommsCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineComms WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:CommIndex}} | DataSubmarineComms}}
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataSubmarineComms }}'; | 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 DataSubmarinePropulsion WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarinePropulsionCount }}
{|class="wikitable sortable"
!Engines
!Type
!Creep Speed (kts)
!Cruise Speed (kts)
!Full Speed (kts)
!Flank Speed (kts)
|-
{{
#loop: PropulsionIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarinePropulsionCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarinePropulsion WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:PropulsionIndex}} | DataSubmarinePropulsion}}
{{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataSubmarinePropulsion }}'; | 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 DataSubmarineFuel WHERE ID = '{{ #getdata: ID | DataSubmarine }}'; | 1 | DataSubmarineFuelCount }}
{|class="wikitable sortable"
!Fuel Type
!Quantity (kg)
|-
{{
#loop: FuelIndex
| 1
| {{#getdata: COUNT(1) | DataSubmarineFuelCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSubmarineFuel WHERE ID = '{{ #getdata: ID | DataSubmarine }}' ; | {{#var:FuelIndex}} | DataSubmarineFuel }}
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataSubmarineFuel }}'; | 1 | DataFuel }}
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}
</div>
{{!}}-
{{!}}[[{{#getdata: Description | EnumFuelType}}]]
{{!}}{{#getdata: Capacity | DataFuel}}
}}
|}