Difference between revisions of "Template:DataShipLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
(46 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 DataShip WHERE ID = '{{{1}}}'; | 1 | DataShip }}
 
{{#rawquery: SELECT * FROM DataShip WHERE ID = '{{{1}}}'; | 1 | DataShip }}
Line 24: Line 24:
  
 
</div>
 
</div>
−
<img src="http://baloogan.images.blu3wolf.com/ship_{{ #getdata: ID | DataShip }}.jpg" class="baloogan_small_image" id="baloogan_image" />
+
<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 }}
 
|}
 
|}
Line 78: Line 93:
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: PropertyIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipCodesCount }}
 
| {{#getdata: COUNT(1) | DataShipCodesCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:varname}} | DataShipCodes}}
+
{{#rawquery: SELECT * FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:PropertyIndex}} | DataShipCodes}}
 
{{#rawquery: SELECT * FROM EnumShipCode WHERE ID = '{{ #getdata: CodeID | DataShipCodes }}'; | 1 | EnumShipCode }}
 
{{#rawquery: SELECT * FROM EnumShipCode WHERE ID = '{{ #getdata: CodeID | DataShipCodes }}'; | 1 | EnumShipCode }}
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
 
{{!}}[[{{#replace:{{#replace:{{#getdata: Description| EnumShipCode }}|[|(}}|]|)}}]]
 
{{!}}[[{{#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 }}]]}}
 
}}
 
}}
 
|}
 
|}
Line 98: Line 139:
 
!Role
 
!Role
 
!Max Range (nm)
 
!Max Range (nm)
−
!Arc
+
!Arc Search
 +
!Arc Engage
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: SensorIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipSensors}}
+
{{#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 DataSensor WHERE ID = '{{ #getdata: ComponentID | DataShipSensors }}'; | 1 | DataSensor }}
 
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
 
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
Line 111: Line 153:
 
{{#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>
 
{{!}}-
 
{{!}}-
−
{{!}}{{#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" style="display:{{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | none | inline }};"
+
{{{!}}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
 
{{!}}+Sensors
 
!Name
 
!Name
Line 124: Line 181:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname2
+
#loop: SensorGroupIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }}
 
| {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:varname2}} | DataSensorSensorGroups}}
+
{{#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 DataSensor WHERE ID = '{{ #getdata: ComponentID | DataSensorSensorGroups }}'; | 1 | DataSensor2 }}
 
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }}
 
{{#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 * 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>
 
</div>
 
{{!}}-
 
{{!}}-
−
{{!}}{{#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;" | }}
 +
{{!}}-
 +
{{
 +
#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 | DataSensor2 }}
 
}}
 
}}
Line 143: Line 215:
 
{{!}}{{#getdata: RangeMax | DataSensor }}
 
{{!}}{{#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: 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: 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}}
 
}}
 
}}
 
|}
 
|}

Latest revision as of 02: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

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 Side Rear Top
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:DataShipLong&oldid=4957"