Difference between revisions of "Template:DataShipLong"
From Baloogan Campaign Wiki
								
												
				| Line 78: | Line 78: | ||
| |- | |- | ||
| {{ | {{ | ||
| − | #loop:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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:  | + | #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: | + | {{#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
| Name | Type | Role | Max Range (nm) | Arc | 
|---|
Mounts
| Mount | ROF | Capacity | Weapons, Sensors and Magazine | Arc | 
|---|
Signatures
| Signature Type | Front (nm) | Side (nm) | Rear (nm) | Top (nm) | 
|---|
Comms/Datalinks
| 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) | 
|---|

