Difference between revisions of "Template:DataShipLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
Line 78: Line 78:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: PropertyIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipCodesCount }}
 
| {{#getdata: COUNT(1) | DataShipCodesCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:varname}} | DataShipCodes}}
+
{{#rawquery: SELECT * FROM DataShipCodes WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:PropertyIndex}} | DataShipCodes}}
 
{{#rawquery: SELECT * FROM EnumShipCode WHERE ID = '{{ #getdata: CodeID | DataShipCodes }}'; | 1 | EnumShipCode }}
 
{{#rawquery: SELECT * FROM EnumShipCode WHERE ID = '{{ #getdata: CodeID | DataShipCodes }}'; | 1 | EnumShipCode }}
 
</div>
 
</div>
Line 101: Line 101:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: SensorIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
 
| {{#getdata: COUNT(1) | DataShipSensorsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipSensors}}
+
{{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:SensorIndex}} | DataShipSensors}}
 
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataShipSensors }}'; | 1 | DataSensor }}
 
{{#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 EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
Line 124: Line 124:
 
{{!}}-
 
{{!}}-
 
{{
 
{{
#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) | DataShipMountsCount }}
 
| {{#getdata: COUNT(1) | DataShipMountsCount }}
 
|<nowiki/><div style="display:none;">
 
|<nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipMounts WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:varname}} | DataShipMounts}}
+
{{#rawquery: SELECT * FROM DataShipMounts WHERE ID = '{{ #getdata: ID | DataShip }}'; | {{#var:MountIndex}} | DataShipMounts}}
 
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataShipMounts }}'; | 1 | DataMount }}
 
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataShipMounts }}'; | 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 336: Line 336:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: SignatureIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipSignaturesCount }}
 
| {{#getdata: COUNT(1) | DataShipSignaturesCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipSignatures WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipSignatures }}
+
{{#rawquery: SELECT * FROM DataShipSignatures WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:SignatureIndex}} | DataShipSignatures }}
 
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataShipSignatures }}'; | 1 | EnumSignatureType }}
 
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataShipSignatures }}'; | 1 | EnumSignatureType }}
 
</div>
 
</div>
Line 362: Line 362:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: CommIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipCommsCount }}
 
| {{#getdata: COUNT(1) | DataShipCommsCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipComms WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipComms}}
+
{{#rawquery: SELECT * FROM DataShipComms WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:CommIndex}} | DataShipComms}}
 
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataShipComms }}'; | 1 | DataComm }}
 
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataShipComms }}'; | 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 388: Line 388:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: PropulsionIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipPropulsionCount }}
 
| {{#getdata: COUNT(1) | DataShipPropulsionCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipPropulsion WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipPropulsion}}
+
{{#rawquery: SELECT * FROM DataShipPropulsion WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:PropulsionIndex}} | DataShipPropulsion}}
 
{{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataShipPropulsion }}'; | 1 | DataPropulsion }}
 
{{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataShipPropulsion }}'; | 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 417: Line 417:
 
|-
 
|-
 
{{
 
{{
#loop: varname
+
#loop: FuelIndex
 
| 1
 
| 1
 
| {{#getdata: COUNT(1) | DataShipFuelCount }}
 
| {{#getdata: COUNT(1) | DataShipFuelCount }}
 
| <nowiki/><div style="display:none;">
 
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataShipFuel WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:varname}} | DataShipFuel }}
+
{{#rawquery: SELECT * FROM DataShipFuel WHERE ID = '{{ #getdata: ID | DataShip }}' ; | {{#var:FuelIndex}} | DataShipFuel }}
 
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataShipFuel }}'; | 1 | DataFuel }}
 
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataShipFuel }}'; | 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 20:33, 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)

Properties

Property

Sensors/EW

Sensors
Name Type Role Max Range (nm) Arc

Mounts

Mounts
Mount ROF Capacity Weapons, Sensors and Magazine Arc

Signatures

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

Comms/Datalinks

Comms
Name Type Range (nm) Channels

Propulsion

Engines Type Creep Speed (kts) Cruise Speed (kts) Full Speed (kts) Flank Speed (kts)

Fuel

Fuel Type Quantity (kg)