Difference between revisions of "Template:DataSubmarineLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
 
(16 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
</css><div style="height:0px;">
 
</css><div style="height:0px;">
  
−
__NOTITLE____NOTOC__
+
__NOTITLE__
  
 
{{#rawquery: SELECT * FROM DataSubmarine WHERE ID = '{{{1}}}'; | 1 | DataSubmarine }}
 
{{#rawquery: SELECT * FROM DataSubmarine WHERE ID = '{{{1}}}'; | 1 | DataSubmarine }}
Line 24: Line 24:
  
 
</div>
 
</div>
−
<img src="http://baloogan.images.blu3wolf.com/submarine_{{ #getdata: ID | DataSubmarine }}.jpg" class="baloogan_small_image" id="baloogan_image" />
+
<img src="http://11rdp.fr/dbimages/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;">
 
<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 }}
 
<nowiki>#</nowiki>{{ #getdata: ID | DataSubmarine }} - {{ #getdata: Name | DataSubmarine  }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataSubmarine }}-{{ #getdata: YearDecommissioned | DataSubmarine }}, {{ #getdata: Comments | DataSubmarine }}
 
</div>
 
</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====
 
====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 | EnumSubmarineCategory }}]]
 
|[[{{ #getdata: Description | EnumSubmarineCategory }}]]
−
|Max Depth:
+
|'''Max Depth:'''
−
|{{ #getdata: MaxDepth | DataSubmarine }}
+
| {{ #getdata: MaxDepth | DataSubmarine }} m
 
|-
 
|-
−
|Type:
+
|'''Type:'''
 
|[[{{ #getdata: Description | EnumSubmarineType }}]]
 
|[[{{ #getdata: Description | EnumSubmarineType }}]]
−
|Pier / Dock / Davit Size:
+
|'''Pier / Dock / Davit Size:'''
 
|{{ #getdata: Description | EnumSubmarinePhysicalSize }}
 
|{{ #getdata: Description | EnumSubmarinePhysicalSize }}
 
|-
 
|-
−
|Damage Points:
+
|'''Damage Points:'''
 
|{{ #getdata: DamagePoints | DataSubmarine }}
 
|{{ #getdata: DamagePoints | DataSubmarine }}
−
|ROV Operating Radius:
+
|'''ROV Operating Radius:'''
 
|{{ #getdata: ROVRadius | DataSubmarine }}
 
|{{ #getdata: ROVRadius | DataSubmarine }}
 
|-
 
|-
−
|Length:
+
|'''Length:'''
 
|{{ #getdata: Length | DataSubmarine }} m
 
|{{ #getdata: Length | DataSubmarine }} m
 
|-
 
|-
−
|Beam:
+
|'''Beam:'''
 
|{{ #getdata: Beam | DataSubmarine }} m
 
|{{ #getdata: Beam | DataSubmarine }} m
 
|-
 
|-
−
|Draft:
+
|'''Draft:'''
 
|{{ #getdata: Draft | DataSubmarine }} m
 
|{{ #getdata: Draft | DataSubmarine }} m
 
|-
 
|-
−
|Height:
+
|'''Height:'''
 
|{{ #getdata: Height | DataSubmarine }} m
 
|{{ #getdata: Height | DataSubmarine }} m
 
|-
 
|-
−
|Empty Displacement:
+
|'''Empty Displacement:'''
 
|{{ #getdata: DisplacementEmpty | DataSubmarine }} tons
 
|{{ #getdata: DisplacementEmpty | DataSubmarine }} tons
 
|-
 
|-
−
|Standard Displacement:
+
|'''Standard Displacement:'''
 
|{{ #getdata: DisplacementStandard | DataSubmarine }} tons
 
|{{ #getdata: DisplacementStandard | DataSubmarine }} tons
 
|-
 
|-
−
|Full Displacement:
+
|'''Full Displacement:'''
 
|{{ #getdata: DisplacementFull | DataSubmarine }} tons
 
|{{ #getdata: DisplacementFull | DataSubmarine }} tons
 
|-
 
|-
−
|Crew:
+
|'''Crew:'''
 
|{{ #getdata: Crew | DataSubmarine }}
 
|{{ #getdata: Crew | DataSubmarine }}
 
|}
 
|}
Line 96: Line 111:
 
!Role
 
!Role
 
!Max Range (nm)
 
!Max Range (nm)
−
!Arc
+
!Arc Search
 +
!Arc Engage
 
|-
 
|-
 
{{
 
{{
Line 114: Line 130:
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
−
{{!}}'''{{#getdata: Description | EnumSensorRole}}'''
+
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole}}|[|(}}|]|)}}]]'''
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" |  }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" |  }}
 
{{!}}-
 
{{!}}-
Line 151: Line 167:
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
−
{{!}}{{#getdata: Description | EnumSensorRole2}}
+
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole2}}|[|(}}|]|)}}]]'''
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }}
 
{{!}}-
 
{{!}}-
Line 171: Line 187:
 
{{!}}{{#getdata: RangeMax | DataSensor }}
 
{{!}}{{#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: 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 }}}}
 
}}
 
}}
 
|}
 
|}
Line 194: Line 211:
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
−
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}
+
{{!}}'''{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}'''
 
{{!}}{{#getdata: ROF | DataMount}}
 
{{!}}{{#getdata: ROF | DataMount}}
 
{{!}}{{#getdata: Capacity | DataMount}}
 
{{!}}{{#getdata: Capacity | DataMount}}
Line 206: Line 223:
 
!ROF
 
!ROF
 
!Range
 
!Range
 +
!Targets
 
{{!}}-
 
{{!}}-
 
{{
 
{{
Line 216: Line 234:
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 
{{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }}
 
{{#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>
 
</div>
 
{{!}}-
 
{{!}}-
Line 245: Line 264:
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | 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}}]]
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 267: Line 301:
 
{{#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 DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorSensorGroupsCount }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }}
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
−
{{!}}{{#getdata: Description | EnumSensorRole}}
+
{{!}}'''[[{{#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;" | }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;" | }}
 
{{!}}+Sensors
 
{{!}}+Sensors
Line 308: Line 358:
 
!ROF
 
!ROF
 
!Range
 
!Range
 +
!Targets
 
{{!}}-
 
{{!}}-
 
{{
 
{{
Line 318: Line 369:
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 
{{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }}
 
{{#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>
 
</div>
 
{{!}}-
 
{{!}}-
Line 347: Line 399:
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | 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}}]]
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 352: Line 419:
 
{{!}}}
 
{{!}}}
 
{{!}}{{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 }}}}
 
{{!}}{{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}}]]
 +
}}
 +
{{!}}}
 +
}}
 +
{{!}}}
 
}}
 
}}
 
|}
 
|}
Line 363: Line 520:
 
!Rear (nm)
 
!Rear (nm)
 
!Top (nm)
 
!Top (nm)
 +
|-
 +
|
 +
|
 +
| nm for Visual/Pac
 +
| dBsm for Radar
 +
| db for Sonar
 
|-
 
|-
 
{{
 
{{

Latest revision as of 01:48, 20 December 2014










<img src="http://11rdp.fr/dbimages/submarine_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:Submarine_DataInvoker Error: getData error: No such key in handle (ID)}}

{{Description:Listing_Submarine_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 Depth: DataInvoker Error: getData error: No such key in handle (MaxDepth) m
Type: [[DataInvoker Error: getData error: No such key in handle (Description)]] Pier / Dock / Davit Size: DataInvoker Error: getData error: No such key in handle (Description)
Damage Points: DataInvoker Error: getData error: No such key in handle (DamagePoints) ROV Operating Radius: DataInvoker Error: getData error: No such key in handle (ROVRadius)
Length: DataInvoker Error: getData error: No such key in handle (Length) m
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

Sensors/EW

Sensors
Name Type Role Max Range (nm) Arc Search Arc Engage

Mounts

Mounts
Mount ROF Capacity Weapons, Sensors and Magazine Arc

Magazines

Name Capacity Content

Signatures

Signature Type Front (nm) Side (nm) Rear (nm) Top (nm)
nm for Visual/Pac dBsm for Radar db for Sonar

Comms/Datalinks

Comms
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)
Retrieved from "https://wiki.baloogancampaign.com/index.php?title=Template:DataSubmarineLong&oldid=4958"