Difference between revisions of "Template:DataAircraftLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
(40 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 }}
Line 110: Line 126:
 
{{#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 mw-collapsible mw-collapsed" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;"  | }}
 
{{!}}+Sensors
 
{{!}}+Sensors
 
!Name
 
!Name
Line 123: Line 154:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 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 | DataSensor2 }}
 
}}
 
}}
Line 142: Line 188:
 
{{!}}{{#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 152: Line 199:
 
!ROF
 
!ROF
 
!Capacity
 
!Capacity
−
!Weapons and Sensors
+
!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
 
{{!}}+Weapons
 
!Name
 
!Name
Line 177: 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>
 
</div>
 
{{!}}-
 
{{!}}-
−
{{!}}{{#replace:{{#replace:{{#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}}]]
 
{{!}}{{#getdata: DefaultLoad | DataWeaponRecord}}
 
{{!}}{{#getdata: DefaultLoad | DataWeaponRecord}}
Line 216: Line 265:
 
{{!}}{{#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}}]]
 
}}
 
}}
 
{{!}}}
 
{{!}}}
 
}}
 
}}
 
{{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountSensorsCount }}
 
{{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountSensorsCount }}
−
{{{!}}class="wikitable sortable"  style="display:{{#ifeq: {{#getdata: COUNT(1) | DataMountSensorsCount }} | 0 | none | inline }};"
+
{{{!}}class="wikitable sortable mw-collapsible mw-collapsed"  {{#ifeq: {{#getdata: COUNT(1) | DataMountSensorsCount }} | 0 | style="display:none;" | }}
 
{{!}}+Sensors
 
{{!}}+Sensors
 
!Name
 
!Name
Line 228: Line 297:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname2
+
#loop: MountSensorIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataMountSensorsCount }}
 
| {{#getdata: COUNT(1) | DataMountSensorsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}' ; | {{#var:varname2}} | DataMountSensors}}
+
{{#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 DataSensor WHERE ID = '{{ #getdata: ComponentID | DataMountSensors }}'; | 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 238: Line 307:
 
{{#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 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
 
{{!}}+Sensors
 
!Name
 
!Name
Line 251: Line 336:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname3
+
#loop: MountSensorGroupIndex
 
| 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:varname3}} | DataSensorSensorGroups}}
+
{{#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 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 }}
Line 262: Line 347:
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
−
{{!}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}
+
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 
{{!}} [[{{#getdata: Description | EnumSensorType2}}]]
 
{{!}} [[{{#getdata: Description | EnumSensorType2}}]]
 
{{!}} {{#getdata: Description | EnumSensorRole2}}
 
{{!}} {{#getdata: Description | EnumSensorRole2}}
Line 269: Line 354:
 
{{!}}}
 
{{!}}}
 
{{!}} {{#getdata: RangeMax | DataSensor }}
 
{{!}} {{#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>
 +
{{!}}-
 +
{{!}}{{#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}}]]
 +
}}
 +
{{!}}}
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 279: Line 437:
 
{|class="wikitable sortable"
 
{|class="wikitable sortable"
 
!Name
 
!Name
 +
!ID
 
!Role
 
!Role
 
!Ready<br/>Time<br/>(minutes)
 
!Ready<br/>Time<br/>(minutes)
Line 288: 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 302: Line 461:
 
{{!}}-
 
{{!}}-
 
{{!}} '''{{#getdata: Name | DataLoadout }}'''
 
{{!}} '''{{#getdata: Name | DataLoadout }}'''
 +
{{!}} '''{{#getdata: ID | DataLoadout }}'''
 
{{!}} [[{{#getdata: Description | EnumLoadoutRole }}]]
 
{{!}} [[{{#getdata: Description | EnumLoadoutRole }}]]
 
{{!}} {{#getdata: ReadyTime | DataLoadout }}
 
{{!}} {{#getdata: ReadyTime | DataLoadout }}
Line 309: 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 337: 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 369: 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 395: Line 608:
 
|-
 
|-
 
{{
 
{{
−
#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 }}
Line 424: 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"