Difference between revisions of "Template:DataAircraftLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
Line 77: Line 77:
 
|-
 
|-
 
{{
 
{{
−
#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 100: Line 100:
 
|-
 
|-
 
{{
 
{{
−
#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 123: Line 123:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 }}
Line 156: Line 156:
 
|-
 
|-
 
{{
 
{{
−
#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 }}
Line 179: Line 179:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 }}
Line 228: Line 228:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 251: Line 251:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 281: Line 281:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#loop: varname2
+
#loop: MountMagazineIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }}
 
| {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
−
{{#rawquery: SELECT * FROM DataMountMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMount }}' ; | {{#var:varname2}} | DataMountMagazineWeapons}}
+
{{#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 DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMountMagazineWeapons }}'; | 1 | DataWeaponRecord }}
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
Line 339: Line 339:
 
|-
 
|-
 
{{
 
{{
−
#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 366: Line 366:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
−
#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 }}
Line 394: Line 394:
 
|-
 
|-
 
{{
 
{{
−
#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 420: Line 420:
 
|-
 
|-
 
{{
 
{{
−
#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 446: Line 446:
 
|-
 
|-
 
{{
 
{{
−
#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 475: Line 475:
 
|-
 
|-
 
{{
 
{{
−
#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 }}

Revision as of 19:00, 23 January 2014












<img src="http://baloogan.images.blu3wolf.com/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)

General Data

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)
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

Mounts

Mounts
Mount ROF Capacity Weapons, Sensors and Magazine Arc

Loadouts

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

Signatures

Signature Type Front (nm) Side (nm) Rear (nm) Top (nm)

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=2253"