Difference between revisions of "Template:DataShipLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
Line 73: Line 73:
  
 
====Sensors/EW====
 
====Sensors/EW====
 
+
{{#rawquery: SELECT COUNT(1) FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipSensorsCount }}
 +
{|class="wikitable sortable"
 +
|+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
!Arc
 +
|-
 
{{
 
{{
 
#loop: varname
 
#loop: varname
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
| <nowiki/>{{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' AND ComponentNumber = '{{#var:varname}}'; | 1 | DataShipSensors}}
+
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataShipSensors }}'; | 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 DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipSensors}}
{{#if: {{#getdata: Name | DataSensor|true}} |
+
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataShipSensors }}'; | 1 | DataSensor }}
* {{#getdata: Name | DataSensor}} -{{#getdata: Comments | DataSensor}}  
+
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
** {{#getdata: Description | EnumSensorType}}
+
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }}
** {{#getdata: Description | EnumSensorRole}}
+
</div>
** Range Min: {{#getdata: RangeMin | DataSensor }}
+
{{!}}-
** Range Max: {{#getdata: RangeMax | DataSensor }}
+
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}
** Altitude Min: {{#getdata: AltitudeMin | DataSensor }}
+
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
** Altitude Max: {{#getdata: AltitudeMax | DataSensor }}
+
{{!}}{{#getdata: Description | EnumSensorRole}}
** Scan Interval: {{#getdata: ScanInterval | DataSensor }}
+
{{!}}{{#getdata: RangeMax | DataSensor }}
** ECM Peak Power: {{#getdata: ECMPeakPower | DataSensor }}  
+
{{!}}{{RenderArc|{{#getdata: SB1 | DataShipSensors }}|{{#getdata: SB2 | DataShipSensors }}|{{#getdata: SMF1 | DataShipSensors }}|{{#getdata: SMF2 | DataShipSensors }}|{{#getdata: SMA1 | DataShipSensors }}|{{#getdata: SMA2 | DataShipSensors }}|{{#getdata: SS1 | DataShipSensors }}|{{#getdata: SS2 | DataShipSensors }}|{{#getdata: PB1 | DataShipSensors }}|{{#getdata: PB2 | DataShipSensors }}|{{#getdata: PMF1 | DataShipSensors }}|{{#getdata: PMF2 | DataShipSensors }}|{{#getdata: PMA1 | DataShipSensors }}|{{#getdata: PMA2 | DataShipSensors }}|{{#getdata: PS1 | DataShipSensors }}|{{#getdata: PS2 | DataShipSensors }}}}
** ECM Number of Targets: {{#getdata: ECMNumberOfTargets | DataSensor }}  
 
** Sonar Min Deployment Depth: {{#getdata: SonarMinimumDeploymentDepth | DataSensor }}  
 
** Sonar Max Deployment Depth: {{#getdata: SonarMaximumDeploymentDepth | DataSensor }}
 
|}}
 
 
}}
 
}}
 +
|}

Revision as of 01:04, 23 January 2014










<img src="http://baloogan.images.blu3wolf.com/ship_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)]] Max Sea State: DataInvoker Error: getData error: No such key in handle (MaxSeaState)
Type: [[DataInvoker Error: getData error: No such key in handle (Description)]] Troop Capacity: DataInvoker Error: getData error: No such key in handle (TroopCapacity)
Damage Points: DataInvoker Error: getData error: No such key in handle (DamagePoints) Cargo Capacity: DataInvoker Error: getData error: No such key in handle (CargoCapacity)
Length: DataInvoker Error: getData error: No such key in handle (Length) m Pier / Dock / Davit Size: DataInvoker Error: getData error: No such key in handle (Description)
Beam: DataInvoker Error: getData error: No such key in handle (Beam) m
Draft: DataInvoker Error: getData error: No such key in handle (Draft) m
Height: DataInvoker Error: getData error: No such key in handle (Height) m
Empty Displacement: DataInvoker Error: getData error: No such key in handle (DisplacementEmpty) tons
Standard Displacement: DataInvoker Error: getData error: No such key in handle (DisplacementStandard) tons
Full Displacement: DataInvoker Error: getData error: No such key in handle (DisplacementFull) tons
Crew: DataInvoker Error: getData error: No such key in handle (Crew)

Sensors/EW

Sensors
Name Type Role Max Range (nm) Arc