Difference between revisions of "Template:DataAircraftLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
Line 17: Line 17:
 
{{#rawquery: SELECT * FROM EnumAircraftCategory WHERE ID = '{{ #getdata: Category | DataAircraft }}'; | 1 | EnumAircraftCategory }}
 
{{#rawquery: SELECT * FROM EnumAircraftCategory WHERE ID = '{{ #getdata: Category | DataAircraft }}'; | 1 | EnumAircraftCategory }}
  
−
{{#rawquery: SELECT COUNT(1) FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftSensorsCount }}
+
 
−
{{#rawquery: SELECT COUNT(1) FROM DataAircraftCodes WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftCodesCount }}
+
 
−
{{#rawquery: SELECT COUNT(1) FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftMountsCount }}
+
 
  
 
{{#rawquery: SELECT * FROM EnumAircraftPhysicalSize WHERE ID = '{{ #getdata: PhysicalSizeCode | DataAircraft }}'; | 1 | EnumAircraftPhysicalSize }}
 
{{#rawquery: SELECT * FROM EnumAircraftPhysicalSize WHERE ID = '{{ #getdata: PhysicalSizeCode | DataAircraft }}'; | 1 | EnumAircraftPhysicalSize }}
Line 72: Line 72:
  
 
====Properties====
 
====Properties====
 +
{{#rawquery: SELECT COUNT(1) FROM DataAircraftCodes WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftCodesCount }}
 
{|class="wikitable"
 
{|class="wikitable"
 
!Property
 
!Property
Line 89: Line 90:
  
 
====Sensors/EW====
 
====Sensors/EW====
 +
{{#rawquery: SELECT COUNT(1) FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftSensorsCount }}
 
{|class="wikitable"
 
{|class="wikitable"
 
|+Sensors
 
|+Sensors
Line 117: Line 119:
  
 
====Mounts/Stores/Weapons====
 
====Mounts/Stores/Weapons====
 +
{{#rawquery: SELECT COUNT(1) FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftMountsCount }}
 
{|class="wikitable"
 
{|class="wikitable"
 
|+ Mounts
 
|+ Mounts
Line 169: Line 172:
  
 
====Comms/Datalinks====
 
====Comms/Datalinks====
 +
{{#rawquery: SELECT COUNT(1) FROM DataAircraftComms WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftCommsCount }}
 
{|class="wikitable"
 
{|class="wikitable"
 
!Name
 
!Name
Line 175: Line 179:
 
!Channels
 
!Channels
 
!Properties
 
!Properties
 +
|}
 +
 +
{|class="wikitable"
 +
|+Comms
 +
!Name
 +
!Type
 +
!Max Range
 +
!Channels
 +
|-
 +
{{
 +
#loop: varname
 +
| 1
 +
| {{#getdata: COUNT(1) | DataAircraftSensorsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataAircraftSensors WHERE ID = '{{ #getdata: ID | DataAircraft }}' ; | {{#var:varname}} | DataAircraftSensors}}
 +
{{#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 EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }}
 +
</div>
 +
{{!}}-
 +
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}
 +
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 +
{{!}}{{#getdata: Description | EnumSensorRole}}
 +
{{!}}{{#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 }}}}
 +
}}
 
|}
 
|}
 
====Signatures====
 
====Signatures====

Revision as of 22:27, 22 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 Arc

Mounts/Stores/Weapons

Mounts
Mount ROF Capacity Weapons Arc

Comms/Datalinks

Name Type Max Range Channels Properties
Comms
Name Type Max Range Channels

Signatures

Signature Type Front Side Rear

Propulsion

Engines Type Max Speed

Fuel

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