Difference between revisions of "Template:DataAircraftLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
(47 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 97: Line 112:
 
!Role
 
!Role
 
!Max Range (nm)
 
!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}}|[|(}}|]|)}}]]'''
 +
{{{!}}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 }}
 
{{!}}{{#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 sortable"
 
{|class="wikitable sortable"
Line 125: Line 199:
 
!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 sortable"
+
{{{!}} 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 195: Line 432:
 
}}
 
}}
 
|}
 
|}
 +
 
====Loadouts====
 
====Loadouts====
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftLoadouts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftLoadoutsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataAircraftLoadouts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftLoadoutsCount }}
 
{|class="wikitable sortable"
 
{|class="wikitable sortable"
 
!Name
 
!Name
 +
!ID
 
!Role
 
!Role
 
!Ready<br/>Time<br/>(minutes)
 
!Ready<br/>Time<br/>(minutes)
Line 208: Line 447:
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: LoadoutIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftLoadoutsCount }}
 
| {{#getdata: COUNT(1) | DataAircraftLoadoutsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftLoadouts WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftLoadouts }}
+
{{#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 DataLoadout WHERE ID = '{{ #getdata: ComponentID | DataAircraftLoadouts }}'; | 1 | DataLoadout }}
 
{{#rawquery: SELECT * FROM EnumLoadoutRole WHERE ID = '{{ #getdata: LoadoutRole | DataLoadout }}'; | 1 | EnumLoadoutRole }}
 
{{#rawquery: SELECT * FROM EnumLoadoutRole WHERE ID = '{{ #getdata: LoadoutRole | DataLoadout }}'; | 1 | EnumLoadoutRole }}
Line 222: Line 461:
 
{{!}}-
 
{{!}}-
 
{{!}} '''{{#getdata: Name | DataLoadout }}'''
 
{{!}} '''{{#getdata: Name | DataLoadout }}'''
 +
{{!}} '''{{#getdata: ID | DataLoadout }}'''
 
{{!}} [[{{#getdata: Description | EnumLoadoutRole }}]]
 
{{!}} [[{{#getdata: Description | EnumLoadoutRole }}]]
 
{{!}} {{#getdata: ReadyTime | DataLoadout }}
 
{{!}} {{#getdata: ReadyTime | DataLoadout }}
Line 229: Line 469:
 
{{!}} [[{{#getdata: Description | EnumLoadoutWeather }}]]
 
{{!}} [[{{#getdata: Description | EnumLoadoutWeather }}]]
 
{{!}}
 
{{!}}
−
{{{!}}class="wikitable sortable"
+
{{{!}}class="wikitable sortable mw-collapsible mw-collapsed"
 
!Quantity
 
!Quantity
 
!Name
 
!Name
 
!Type
 
!Type
 +
!Range
 +
!Targets
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname2
+
#loop: LoadoutWeaponIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataLoadoutWeaponsCount }}
 
| {{#getdata: COUNT(1) | DataLoadoutWeaponsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataLoadoutWeapons WHERE ID = '{{ #getdata: ID | DataLoadout }}' ; | {{#var:varname2}} | DataLoadoutWeapons }}
+
{{#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 DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataLoadoutWeapons }}'; | 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>
 
</div>
 
{{!}}-
 
{{!}}-
 
{{!}} {{#getdata: DefaultLoad | DataWeaponRecord }}
 
{{!}} {{#getdata: DefaultLoad | DataWeaponRecord }}
−
{{!}} {{#getdata: Name | DataWeapon }}
+
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataWeapon?ID={{#getdata: ID | DataWeapon }} {{#replace:{{#replace:{{#getdata: Name | DataWeapon }}|[|(}}|]|)}}]'''
 
{{!}} [[{{#getdata: Description | EnumWeaponType }}]]
 
{{!}} [[{{#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}}]]
 +
}}
 +
{{!}}}
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 257: Line 544:
 
{|class="wikitable sortable"
 
{|class="wikitable sortable"
 
!Signature Type
 
!Signature Type
−
!Front (nm)
+
!Front  
−
!Side (nm)
+
!Side  
−
!Rear (nm)
+
!Rear  
−
!Top (nm)
+
!Top  
 +
|-
 +
|
 +
|
 +
| nm for Visual/IR
 +
| dBsm for Radar
 +
| db for Sonar
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: SignatureIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftSignaturesCount }}
 
| {{#getdata: COUNT(1) | DataAircraftSignaturesCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftSignatures WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftSignatures }}
+
{{#rawquery: SELECT * FROM DataAircraftSignatures WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:SignatureIndex}} | DataAircraftSignatures }}
 
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataAircraftSignatures }}'; | 1 | EnumSignatureType }}
 
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataAircraftSignatures }}'; | 1 | EnumSignatureType }}
 
</div>
 
</div>
Line 289: Line 582:
 
|-
 
|-
 
{{
 
{{
−
#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 309: Line 602:
 
!Engines
 
!Engines
 
!Type
 
!Type
−
!Max Speed (kts)
+
!Loiter Speed (kts)
 +
!Cruise Speed (kts)
 +
!Military Speed (kts)
 +
!Afterburner Speed (kts)
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: PropulsionIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftPropulsionCount }}
 
| {{#getdata: COUNT(1) | DataAircraftPropulsionCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftPropulsion WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftPropulsion}}
+
{{#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 DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataAircraftPropulsion }}'; | 1 | DataPropulsion }}
 
{{#rawquery: SELECT * FROM EnumPropulsionType WHERE ID = '{{ #getdata: Type | DataPropulsion }}'; | 1 | EnumPropulsionType }}
 
{{#rawquery: SELECT * FROM EnumPropulsionType WHERE ID = '{{ #getdata: Type | DataPropulsion }}'; | 1 | EnumPropulsionType }}
−
{{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}'; | 1 | DataPropulsionPerformance }}
+
{{#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>
 
</div>
 
{{!}}-
 
{{!}}-
 
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataPropulsion}}|[|(}}|]|)}}
 
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataPropulsion}}|[|(}}|]|)}}
 
{{!}}[[{{#getdata: Description | EnumPropulsionType}}]]
 
{{!}}[[{{#getdata: Description | EnumPropulsionType}}]]
−
{{!}}{{#getdata: MAX(Speed) | DataPropulsionPerformance}}
+
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance1 | true }}
 +
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance2 | true }}
 +
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance3 | true }}
 +
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance4 | true }}
 
}}
 
}}
 
|}
 
|}
Line 335: Line 637:
 
|-
 
|-
 
{{
 
{{
−
#loop: varname
+
#loop: FuelIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataAircraftFuelCount }}
 
| {{#getdata: COUNT(1) | DataAircraftFuelCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataAircraftFuel WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftFuel }}
+
{{#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 DataFuel WHERE ID = '{{ #getdata: ComponentID | DataAircraftFuel }}'; | 1 | DataFuel }}
 
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}
 
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}

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"