Difference between revisions of "Template:DataAircraftLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
(64 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
</css><div style="height:0px;">
 
</css><div style="height:0px;">
  
−
__NOTITLE____NOTOC__
+
__NOTITLE__
  
 
{{#rawquery: SELECT * FROM DataAircraft WHERE ID = '{{{1}}}'; | 1 | DataAircraft }}
 
{{#rawquery: SELECT * FROM DataAircraft WHERE ID = '{{{1}}}'; | 1 | DataAircraft }}
Line 27: Line 27:
  
 
</div>
 
</div>
−
<img src="http://baloogan.images.blu3wolf.com/aircraft_{{ #getdata: ID | DataAircraft }}.jpg" class="baloogan_small_image" id="baloogan_image"/>
+
<img src="http://11rdp.fr/dbimages/aircraft_{{ #getdata: ID | DataAircraft }}.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 | DataAircraft }} - {{ #getdata: Name | DataAircraft }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataAircraft }}-{{ #getdata: YearDecommissioned | DataAircraft }}, {{ #getdata: Comments | DataAircraft }}
 
<nowiki>#</nowiki>{{ #getdata: ID | DataAircraft }} - {{ #getdata: Name | DataAircraft }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataAircraft }}-{{ #getdata: YearDecommissioned | DataAircraft }}, {{ #getdata: Comments | DataAircraft }}
 
</div>
 
</div>
 +
{| style="width=100%;" |
 +
| style="vertical-align:top;" |
 +
__TOC__
 +
| style="vertical-align:top;width=100%;min-width:200px;" |
 +
{{Description:Aircraft_{{ #getdata: ID | DataAircraft }}}}
 +
 +
{{Description:Listing_Aircraft_{{ #getdata: ID | DataAircraft }}}}
 +
 +
[http://wiki.baloogancampaign.com/index.php/Description:Aircraft_{{ #getdata: ID | DataAircraft }}?action=edit Edit description]
 +
|}
 
====General Data====
 
====General Data====
 
{|class="wikitable"
 
{|class="wikitable"
 +
|'''Country:'''
 +
| '''[http://wiki.baloogancampaign.com/index.php/EnumOperatorCountry?CountryID={{ #getdata: ID | EnumOperatorCountry }} {{ #getdata: Description | EnumOperatorCountry }}]'''
 +
|'''Service:'''
 +
| [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}} {{#replace:{{#replace:{{ #getdata: Description | EnumOperatorService }}|[|(}}|]|)}}]]
 +
|-
 
|'''Category:'''
 
|'''Category:'''
 
|[[{{ #getdata: Description | EnumAircraftCategory }}]]
 
|[[{{ #getdata: Description | EnumAircraftCategory }}]]
Line 41: Line 56:
 
|[[{{ #getdata: Description | EnumAircraftType }}]]
 
|[[{{ #getdata: Description | EnumAircraftType }}]]
 
|'''Fighter Generation / Agility:'''
 
|'''Fighter Generation / Agility:'''
−
|{{ #getdata: Agility | DataAircraft }}
+
|{{#ifeq: {{ #getdata: Agility | DataAircraft }} | 0 | | {{ #getdata: Agility | DataAircraft }} gen}}  
 
|-
 
|-
 
|'''Length:'''
 
|'''Length:'''
−
|{{ #getdata: Length | DataAircraft }} m
+
|{{#ifeq: {{ #getdata: Length | DataAircraft }} | 0 | | {{ #getdata: Length | DataAircraft }} m }}
 
|'''Average Climb Rate:'''
 
|'''Average Climb Rate:'''
 
|{{ #getdata: ClimbRate | DataAircraft }} m/sec
 
|{{ #getdata: ClimbRate | DataAircraft }} m/sec
 
|-
 
|-
 
|'''Wingspan:'''
 
|'''Wingspan:'''
−
|{{ #getdata: Span | DataAircraft }} m
+
|{{#ifeq: {{ #getdata: Span | DataAircraft }} | 0 | | {{ #getdata: Span | DataAircraft }} m }}
 
|'''Instantaneous Climb Rate, S/L:'''
 
|'''Instantaneous Climb Rate, S/L:'''
 
|{{#expr:3*{{ #getdata: ClimbRate | DataAircraft }}}} m/sec
 
|{{#expr:3*{{ #getdata: ClimbRate | DataAircraft }}}} m/sec
 
|-
 
|-
 
|'''Height:'''
 
|'''Height:'''
−
|{{ #getdata: Height | DataAircraft }} m
+
|{{#ifeq: {{ #getdata: Height  | DataAircraft }} | 0 | | {{ #getdata: Height | DataAircraft }} m }}
 
|'''Take-off/Landing Distance:'''
 
|'''Take-off/Landing Distance:'''
 
|{{ #getdata: Description | EnumAircraftRunwayLength }}
 
|{{ #getdata: Description | EnumAircraftRunwayLength }}
 
|-
 
|-
 
|'''Crew:'''
 
|'''Crew:'''
−
|{{ #getdata: Crew | DataAircraft }}
+
|{{#ifeq: {{ #getdata: Crew | DataAircraft }} | 0 | | {{ #getdata: Crew | DataAircraft }} }}  
 
|-
 
|-
 
|'''Empty Weight:'''
 
|'''Empty Weight:'''
−
|{{ #getdata: WeightEmpty | DataAircraft }} kg
+
|{{#ifeq: {{ #getdata: WeightEmpty | DataAircraft }} | 0 | | {{ #getdata: WeightEmpty | DataAircraft }} kg }}
 
|-
 
|-
 
|'''Max Weight:'''
 
|'''Max Weight:'''
−
|{{ #getdata: WeightMax | DataAircraft }} kg
+
|{{#ifeq: {{ #getdata: WeightMax | DataAircraft }} | 0 | | {{ #getdata: WeightMax | DataAircraft }} kg }}
 
|-
 
|-
 
|'''Payload Weight:'''
 
|'''Payload Weight:'''
−
|{{ #getdata: WeightPayload | DataAircraft }} kg
+
|{{#ifeq: {{ #getdata: WeightPayload | DataAircraft }} | 0 | | {{ #getdata: WeightPayload | DataAircraft }} kg }}
 
|}
 
|}
  
Line 77: Line 92:
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: PropertyIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftCodesCount }}
 
| {{#getdata: COUNT(1) | DataAircraftCodesCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftCodes WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | {{#var:varname}} | DataAircraftCodes}}
+
{{#rawquery: SELECT * FROM DataAircraftCodes WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | {{#var:PropertyIndex}} | DataAircraftCodes}}
 
{{#rawquery: SELECT * FROM EnumAircraftCode WHERE ID = '{{ #getdata: CodeID | DataAircraftCodes }}'; | 1 | EnumAircraftCode }}
 
{{#rawquery: SELECT * FROM EnumAircraftCode WHERE ID = '{{ #getdata: CodeID | DataAircraftCodes }}'; | 1 | EnumAircraftCode }}
 
</div>
 
</div>
Line 91: Line 106:
 
====Sensors/EW====
 
====Sensors/EW====
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftSensorsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftSensorsCount }}
−
{|class="wikitable"
+
{|class="wikitable sortable"
 
|+Sensors
 
|+Sensors
 
!Name
 
!Name
 
!Type
 
!Type
 
!Role
 
!Role
−
!Max Range
+
!Max Range (nm)
−
!Arc
+
!Arc Search
 +
!Arc Engage
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: SensorIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftSensorsCount }}
 
| {{#getdata: COUNT(1) | DataAircraftSensorsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftSensors}}
+
{{#rawquery: SELECT * FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:SensorIndex}} | DataAircraftSensors}}
 
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataAircraftSensors }}'; | 1 | DataSensor }}
 
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataAircraftSensors }}'; | 1 | DataSensor }}
 
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
 
{{#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 * 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>
 
</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}}|[|(}}|]|)}}]]'''
−
{{!}}{{#getdata: RangeMax | DataSensor }} nm
+
{{{!}}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 mw-collapsible mw-collapsed" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;"  | }}
 +
{{!}}+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
{{!}}-
 +
{{
 +
#loop: SensorGroupIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:SensorGroupIndex}} | DataSensorSensorGroups}}
 +
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataSensorSensorGroups }}'; | 1 | DataSensor2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor2 }}'; | 1 | DataSensorCapabilitiesCount }}
 +
</div>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 +
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
 +
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole2}}|[|(}}|]|)}}]]'''
 +
{{{!}}class="wikitable sortable mw-collapsible mw-collapsed" {{#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 | DataAircraftSensors }}|{{#getdata: SB2 | DataAircraftSensors }}|{{#getdata: SMF1 | DataAircraftSensors }}|{{#getdata: SMF2 | DataAircraftSensors }}|{{#getdata: SMA1 | DataAircraftSensors }}|{{#getdata: SMA2 | DataAircraftSensors }}|{{#getdata: SS1 | DataAircraftSensors }}|{{#getdata: SS2 | DataAircraftSensors }}|{{#getdata: PB1 | DataAircraftSensors }}|{{#getdata: PB2 | DataAircraftSensors }}|{{#getdata: PMF1 | DataAircraftSensors }}|{{#getdata: PMF2 | DataAircraftSensors }}|{{#getdata: PMA1 | DataAircraftSensors }}|{{#getdata: PMA2 | DataAircraftSensors }}|{{#getdata: PS1 | DataAircraftSensors }}|{{#getdata: PS2 | DataAircraftSensors }}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataAircraftSensors }}|{{#getdata: SB2 | DataAircraftSensors }}|{{#getdata: SMF1 | DataAircraftSensors }}|{{#getdata: SMF2 | DataAircraftSensors }}|{{#getdata: SMA1 | DataAircraftSensors }}|{{#getdata: SMA2 | DataAircraftSensors }}|{{#getdata: SS1 | DataAircraftSensors }}|{{#getdata: SS2 | DataAircraftSensors }}|{{#getdata: PB1 | DataAircraftSensors }}|{{#getdata: PB2 | DataAircraftSensors }}|{{#getdata: PMF1 | DataAircraftSensors }}|{{#getdata: PMF2 | DataAircraftSensors }}|{{#getdata: PMA1 | DataAircraftSensors }}|{{#getdata: PMA2 | DataAircraftSensors }}|{{#getdata: PS1 | DataAircraftSensors }}|{{#getdata: PS2 | DataAircraftSensors }}}}
 +
{{!}}{{RenderArc|{{#getdata: SB1Max | DataAircraftSensors }}|{{#getdata: SB2Max | DataAircraftSensors }}|{{#getdata: SMF1Max | DataAircraftSensors }}|{{#getdata: SMF2Max | DataAircraftSensors }}|{{#getdata: SMA1Max | DataAircraftSensors }}|{{#getdata: SMA2Max | DataAircraftSensors }}|{{#getdata: SS1Max | DataAircraftSensors }}|{{#getdata: SS2Max | DataAircraftSensors }}|{{#getdata: PB1Max | DataAircraftSensors }}|{{#getdata: PB2Max | DataAircraftSensors }}|{{#getdata: PMF1Max | DataAircraftSensors }}|{{#getdata: PMF2Max | DataAircraftSensors }}|{{#getdata: PMA1Max | DataAircraftSensors }}|{{#getdata: PMA2Max | DataAircraftSensors }}|{{#getdata: PS1Max | DataAircraftSensors }}|{{#getdata: PS2Max | DataAircraftSensors }}}}
 
}}
 
}}
 
|}
 
|}
  
−
====Mounts/Stores/Weapons====
+
====Mounts====
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftMountsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftMountsCount }}
−
{|class="wikitable"
+
{|class="wikitable sortable"
 
|+ Mounts
 
|+ Mounts
 
!Mount
 
!Mount
 
!ROF
 
!ROF
 
!Capacity
 
!Capacity
−
!Weapons
+
!Weapons, Sensors and Magazine
 
!Arc
 
!Arc
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: MountIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftMountsCount }}
 
| {{#getdata: COUNT(1) | DataAircraftMountsCount }}
 
|<nowiki/><div style="display:none;">
 
|<nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | {{#var:varname}} | DataAircraftMounts}}
+
{{#rawquery: SELECT * FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | {{#var:MountIndex}} | DataAircraftMounts}}
 
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataAircraftMounts }}'; | 1 | DataMount }}
 
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataAircraftMounts }}'; | 1 | DataMount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountWeaponsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountWeaponsCount }}
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
−
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}
+
{{!}}'''{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}'''
 
{{!}}{{#getdata: ROF | DataMount}}
 
{{!}}{{#getdata: ROF | DataMount}}
 
{{!}}{{#getdata: Capacity | DataMount}}
 
{{!}}{{#getdata: Capacity | DataMount}}
 
{{!}}
 
{{!}}
−
{{{!}} class="wikitable"
+
{{{!}} class="wikitable sortable mw-collapsible mw-collapsed"
 +
{{!}}+Weapons
 
!Name
 
!Name
 
!Type
 
!Type
Line 149: Line 224:
 
!ROF
 
!ROF
 
!Range
 
!Range
 +
!Targets
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname2
+
#loop: MountWeaponIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataMountWeaponsCount }}
 
| {{#getdata: COUNT(1) | DataMountWeaponsCount }}
 
|<nowiki/><div style="display:none;">
 
|<nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | {{#var:varname2}} | DataMountWeapons}}
+
{{#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 DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMountWeapons }}'; | 1 | DataWeaponRecord }}
 
{{#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>
 +
{{!}}-
 +
{{!}} '''[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
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | 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 mw-collapsible mw-collapsed"  {{#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 mw-collapsible mw-collapsed" {{#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 mw-collapsible mw-collapsed" {{#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 mw-collapsible mw-collapsed"  {{#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>
 
</div>
 
{{!}}-
 
{{!}}-
Line 188: Line 405:
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | 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 193: Line 430:
 
{{!}}}
 
{{!}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataAircraftMounts }}|{{#getdata: SB2 | DataAircraftMounts }}|{{#getdata: SMF1 | DataAircraftMounts }}|{{#getdata: SMF2 | DataAircraftMounts }}|{{#getdata: SMA1 | DataAircraftMounts }}|{{#getdata: SMA2 | DataAircraftMounts }}|{{#getdata: SS1 | DataAircraftMounts }}|{{#getdata: SS2 | DataAircraftMounts }}|{{#getdata: PB1 | DataAircraftMounts }}|{{#getdata: PB2 | DataAircraftMounts }}|{{#getdata: PMF1 | DataAircraftMounts }}|{{#getdata: PMF2 | DataAircraftMounts }}|{{#getdata: PMA1 | DataAircraftMounts }}|{{#getdata: PMA2 | DataAircraftMounts }}|{{#getdata: PS1 | DataAircraftMounts }}|{{#getdata: PS2 | DataAircraftMounts }}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataAircraftMounts }}|{{#getdata: SB2 | DataAircraftMounts }}|{{#getdata: SMF1 | DataAircraftMounts }}|{{#getdata: SMF2 | DataAircraftMounts }}|{{#getdata: SMA1 | DataAircraftMounts }}|{{#getdata: SMA2 | DataAircraftMounts }}|{{#getdata: SS1 | DataAircraftMounts }}|{{#getdata: SS2 | DataAircraftMounts }}|{{#getdata: PB1 | DataAircraftMounts }}|{{#getdata: PB2 | DataAircraftMounts }}|{{#getdata: PMF1 | DataAircraftMounts }}|{{#getdata: PMF2 | DataAircraftMounts }}|{{#getdata: PMA1 | DataAircraftMounts }}|{{#getdata: PMA2 | DataAircraftMounts }}|{{#getdata: PS1 | DataAircraftMounts }}|{{#getdata: PS2 | DataAircraftMounts }}}}
 +
}}
 +
|}
 +
 +
====Loadouts====
 +
{{#rawquery: SELECT COUNT(1) FROM DataAircraftLoadouts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftLoadoutsCount }}
 +
{|class="wikitable sortable"
 +
!Name
 +
!ID
 +
!Role
 +
!Ready<br/>Time<br/>(minutes)
 +
!Combat<br/>Radius<br/>(nm)
 +
!Time On<br/>Station<br/>(minutes)
 +
!Time of Day
 +
!Weather
 +
!Weapons
 +
|-
 +
{{
 +
#loop: LoadoutIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataAircraftLoadoutsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataAircraftLoadouts WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:LoadoutIndex}} | DataAircraftLoadouts }}
 +
{{#rawquery: SELECT * FROM DataLoadout WHERE ID = '{{ #getdata: ComponentID | DataAircraftLoadouts }}'; | 1 | DataLoadout }}
 +
{{#rawquery: SELECT * FROM EnumLoadoutRole WHERE ID = '{{ #getdata: LoadoutRole | DataLoadout }}'; | 1 | EnumLoadoutRole }}
 +
{{#rawquery: SELECT * FROM EnumLoadoutTimeOfDay WHERE ID = '{{ #getdata: TimeofDay | DataLoadout }}'; | 1 | EnumLoadoutTimeOfDay }}
 +
{{#rawquery: SELECT * FROM EnumLoadoutWeather WHERE ID = '{{ #getdata: Weather | DataLoadout }}'; | 1 | EnumLoadoutWeather }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataLoadoutWeapons WHERE ID = '{{ #getdata: ID | DataLoadout }}'; | 1 | DataLoadoutWeaponsCount }}
 +
<!--{{#rawquery: SELECT * FROM EnumLoadoutMissionProfile WHERE ID = '{{ #getdata: DefaultMissionProfile | DataLoadout }}'; | 1 | EnumLoadoutMissionProfile }}-->
 +
</div>
 +
{{!}}-
 +
{{!}} '''{{#getdata: Name | DataLoadout }}'''
 +
{{!}} '''{{#getdata: ID | DataLoadout }}'''
 +
{{!}} [[{{#getdata: Description | EnumLoadoutRole }}]]
 +
{{!}} {{#getdata: ReadyTime | DataLoadout }}
 +
{{!}} {{#getdata: DefaultCombatRadius | DataLoadout }}
 +
{{!}} {{#getdata: DefaultTimeOnStation | DataLoadout }}
 +
{{!}} [[{{#getdata: Description | EnumLoadoutTimeOfDay }}]]
 +
{{!}} [[{{#getdata: Description | EnumLoadoutWeather }}]]
 +
{{!}}
 +
{{{!}}class="wikitable sortable mw-collapsible mw-collapsed"
 +
!Quantity
 +
!Name
 +
!Type
 +
!Range
 +
!Targets
 +
{{!}}-
 +
{{
 +
#loop: LoadoutWeaponIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataLoadoutWeaponsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataLoadoutWeapons WHERE ID = '{{ #getdata: ID | DataLoadout }}' ; | {{#var:LoadoutWeaponIndex}} | DataLoadoutWeapons }}
 +
{{#rawquery: SELECT * FROM DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataLoadoutWeapons }}'; | 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>
 +
{{!}}-
 +
{{!}} {{#getdata: DefaultLoad | DataWeaponRecord }}
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataWeapon?ID={{#getdata: ID | DataWeapon }} {{#replace:{{#replace:{{#getdata: Name | DataWeapon }}|[|(}}|]|)}}]'''
 +
{{!}} [[{{#getdata: Description | EnumWeaponType }}]]
 +
{{!}}
 +
{{{!}} 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
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | 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 DataAircraftSignatures WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftSignaturesCount }}
 +
{|class="wikitable sortable"
 +
!Signature Type
 +
!Front
 +
!Side
 +
!Rear
 +
!Top
 +
|-
 +
|
 +
|
 +
| nm for Visual/IR
 +
| dBsm for Radar
 +
| db for Sonar
 +
|-
 +
{{
 +
#loop: SignatureIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataAircraftSignaturesCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataAircraftSignatures WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:SignatureIndex}} | DataAircraftSignatures }}
 +
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataAircraftSignatures }}'; | 1 | EnumSignatureType }}
 +
</div>
 +
{{!}}-
 +
{{!}}[[{{#getdata: Description | EnumSignatureType}}]]
 +
{{!}} {{#getdata: Front | DataAircraftSignatures}}
 +
{{!}} {{#getdata: Side | DataAircraftSignatures}}
 +
{{!}} {{#getdata: Rear | DataAircraftSignatures}}
 +
{{!}} {{#getdata: Top | DataAircraftSignatures}}
 
}}
 
}}
 
|}
 
|}
Line 198: Line 574:
 
====Comms/Datalinks====
 
====Comms/Datalinks====
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftComms WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftCommsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftComms WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftCommsCount }}
−
{|class="wikitable"
+
{|class="wikitable sortable"
 
|+Comms
 
|+Comms
 
!Name
 
!Name
 
!Type
 
!Type
−
!Range
+
!Range (nm)
 
!Channels
 
!Channels
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: CommIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftCommsCount }}
 
| {{#getdata: COUNT(1) | DataAircraftCommsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftComms WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftComms}}
+
{{#rawquery: SELECT * FROM DataAircraftComms WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:CommIndex}} | DataAircraftComms}}
 
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataAircraftComms }}'; | 1 | DataComm }}
 
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataAircraftComms }}'; | 1 | DataComm }}
 
{{#rawquery: SELECT * FROM EnumCommType WHERE ID = '{{ #getdata: Type | DataComm }}'; | 1 | EnumCommType }}
 
{{#rawquery: SELECT * FROM EnumCommType WHERE ID = '{{ #getdata: Type | DataComm }}'; | 1 | EnumCommType }}
Line 217: Line 593:
 
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataComm}}|[|(}}|]|)}}
 
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataComm}}|[|(}}|]|)}}
 
{{!}}[[{{#getdata: Description | EnumCommType}}]]
 
{{!}}[[{{#getdata: Description | EnumCommType}}]]
−
{{!}}{{#getdata: MyRange | DataComm}} nm
+
{{!}}{{#getdata: MyRange | DataComm}}
 
{{!}}{{#getdata: Channels | DataComm }}
 
{{!}}{{#getdata: Channels | DataComm }}
 
}}
 
}}
−
|}
 
−
 
−
====Signatures====
 
−
{|class="wikitable"
 
−
!Signature Type
 
−
!Front
 
−
!Side
 
−
!Rear
 
 
|}
 
|}
 
====Propulsion====
 
====Propulsion====
−
{|class="wikitable"
+
{{#rawquery: SELECT COUNT(1) FROM DataAircraftPropulsion WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftPropulsionCount }}
 +
{|class="wikitable sortable"
 
!Engines
 
!Engines
 
!Type
 
!Type
−
!Max Speed
+
!Loiter Speed (kts)
 +
!Cruise Speed (kts)
 +
!Military Speed (kts)
 +
!Afterburner Speed (kts)
 +
|-
 +
{{
 +
#loop: PropulsionIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataAircraftPropulsionCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataAircraftPropulsion WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:PropulsionIndex}} | DataAircraftPropulsion}}
 +
{{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataAircraftPropulsion }}'; | 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====
 
====Fuel====
−
{|class="wikitable"
+
{{#rawquery: SELECT COUNT(1) FROM DataAircraftFuel WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftFuelCount }}
 +
{|class="wikitable sortable"
 
!Fuel Type
 
!Fuel Type
−
!Quantity
+
!Quantity (kg)
 +
|-
 +
{{
 +
#loop: FuelIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataAircraftFuelCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataAircraftFuel WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:FuelIndex}} | DataAircraftFuel }}
 +
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataAircraftFuel }}'; | 1 | DataFuel }}
 +
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}
 +
</div>
 +
{{!}}-
 +
{{!}}[[{{#getdata: Description | EnumFuelType}}]]
 +
{{!}}{{#getdata: Capacity | DataFuel}}
 +
}}
 
|}
 
|}

Latest revision as of 14:21, 20 November 2015












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

{{Description:Listing_Aircraft_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 (ID) 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)]] Aircraft size: DataInvoker Error: getData error: No such key in handle (Description)
Type: [[DataInvoker Error: getData error: No such key in handle (Description)]] Fighter Generation / Agility: DataInvoker Error: getData error: No such key in handle (Agility) gen
Length: DataInvoker Error: getData error: No such key in handle (Length) m Average Climb Rate: DataInvoker Error: getData error: No such key in handle (ClimbRate) m/sec
Wingspan: DataInvoker Error: getData error: No such key in handle (Span) m Instantaneous Climb Rate, S/L: Expression error: Unexpected < operator. m/sec
Height: DataInvoker Error: getData error: No such key in handle (Height) m Take-off/Landing Distance: DataInvoker Error: getData error: No such key in handle (Description)
Crew: DataInvoker Error: getData error: No such key in handle (Crew)
Empty Weight: DataInvoker Error: getData error: No such key in handle (WeightEmpty) kg
Max Weight: DataInvoker Error: getData error: No such key in handle (WeightMax) kg
Payload Weight: DataInvoker Error: getData error: No such key in handle (WeightPayload) kg

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

Loadouts

Name ID Role Ready
Time
(minutes) 		Combat
Radius
(nm) 		Time On
Station
(minutes) 		Time of Day Weather Weapons

Signatures

Signature Type Front Side Rear Top
nm for Visual/IR dBsm for Radar db for Sonar

Comms/Datalinks

Comms
Name Type Range (nm) Channels

Propulsion

Engines Type Loiter Speed (kts) Cruise Speed (kts) Military Speed (kts) Afterburner Speed (kts)

Fuel

Fuel Type Quantity (kg)
Retrieved from "https://wiki.baloogancampaign.com/index.php?title=Template:DataAircraftLong&oldid=5833"