Difference between revisions of "Template:DataShipLong"
From Baloogan Campaign Wiki
Line 177: | Line 177: | ||
====Mounts==== | ====Mounts==== | ||
− | {{#rawquery: SELECT COUNT(1) FROM | + | {{#rawquery: SELECT COUNT(1) FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | 1 | DataAircraftMountsCount }} |
{|class="wikitable sortable" | {|class="wikitable sortable" | ||
|+ Mounts | |+ Mounts | ||
Line 189: | Line 189: | ||
#loop: MountIndex | #loop: MountIndex | ||
| 1 | | 1 | ||
− | | {{#getdata: COUNT(1) | | + | | {{#getdata: COUNT(1) | DataAircraftMountsCount }} |
|<nowiki/><div style="display:none;"> | |<nowiki/><div style="display:none;"> | ||
− | {{#rawquery: SELECT * FROM | + | {{#rawquery: SELECT * FROM DataAircraftMounts WHERE ID = '{{ #getdata: ID | DataAircraft }}'; | {{#var:MountIndex}} | DataAircraftMounts}} |
− | {{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | | + | {{#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 }} | ||
</div> | </div> | ||
Line 208: | Line 208: | ||
!ROF | !ROF | ||
!Range | !Range | ||
+ | !Targets | ||
{{!}}- | {{!}}- | ||
{{ | {{ | ||
Line 218: | Line 219: | ||
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | {{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | ||
{{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | {{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponTargetsCount }} | ||
</div> | </div> | ||
{{!}}- | {{!}}- | ||
Line 247: | Line 249: | ||
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | {{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | ||
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | {{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: WeaponTargetIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataWeaponTargetsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | {{#var:WeaponTargetIndex}} | DataWeaponTargets }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponTarget WHERE ID = '{{ #getdata: CodeID | DataWeaponTargets }}'; | 1 | EnumWeaponTarget }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumWeaponTarget}}]] | ||
}} | }} | ||
{{!}}} | {{!}}} | ||
Line 302: | Line 319: | ||
}} | }} | ||
{{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountMagazineWeaponsCount }} | {{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountMagazineWeaponsCount }} | ||
− | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }} | 0 | style="display:none;" | }} | + | {{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }} | 0 | style="display:none;" | inline }} |
{{!}}+Magazine | {{!}}+Magazine | ||
!Name | !Name | ||
Line 310: | Line 327: | ||
!ROF | !ROF | ||
!Range | !Range | ||
+ | !Targets | ||
{{!}}- | {{!}}- | ||
{{ | {{ | ||
Line 320: | Line 338: | ||
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | {{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }} | ||
{{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | {{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }} | ||
+ | {{#rawquery: SELECT COUNT(1) FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponTargetsCount }} | ||
</div> | </div> | ||
{{!}}- | {{!}}- | ||
− | {{! | + | {{!}}{{#replace:{{#replace:{{#getdata: Name | DataWeapon}}|[|(}}|]|)}} |
{{!}}[[{{#getdata: Description | EnumWeaponType}}]] | {{!}}[[{{#getdata: Description | EnumWeaponType}}]] | ||
{{!}}{{#getdata: DefaultLoad | DataWeaponRecord}} | {{!}}{{#getdata: DefaultLoad | DataWeaponRecord}} | ||
Line 349: | Line 368: | ||
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | {{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm | ||
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | {{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm | ||
+ | }} | ||
+ | {{!}}} | ||
+ | {{!}} | ||
+ | {{{!}} class="wikitable" | ||
+ | {{!}}- | ||
+ | {{ | ||
+ | #loop: WeaponTargetIndex | ||
+ | | 1 | ||
+ | | {{#getdata: COUNT(1) | DataWeaponTargetsCount }} | ||
+ | |<nowiki/><div style="display:none;"> | ||
+ | {{#rawquery: SELECT * FROM DataWeaponTargets WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | {{#var:WeaponTargetIndex}} | DataWeaponTargets }} | ||
+ | {{#rawquery: SELECT * FROM EnumWeaponTarget WHERE ID = '{{ #getdata: CodeID | DataWeaponTargets }}'; | 1 | EnumWeaponTarget }} | ||
+ | </div> | ||
+ | {{!}}- | ||
+ | {{!}} [[{{#getdata: Description | EnumWeaponTarget}}]] | ||
}} | }} | ||
{{!}}} | {{!}}} | ||
}} | }} | ||
{{!}}} | {{!}}} | ||
− | {{!}}{{RenderArc|{{#getdata: SB1 | | + | {{!}}{{RenderArc|{{#getdata: SB1 | DataAircraftMounts }}|{{#getdata: SB2 | DataAircraftMounts }}|{{#getdata: SMF1 | DataAircraftMounts }}|{{#getdata: SMF2 | DataAircraftMounts }}|{{#getdata: SMA1 | DataAircraftMounts }}|{{#getdata: SMA2 | DataAircraftMounts }}|{{#getdata: SS1 | DataAircraftMounts }}|{{#getdata: SS2 | DataAircraftMounts }}|{{#getdata: PB1 | DataAircraftMounts }}|{{#getdata: PB2 | DataAircraftMounts }}|{{#getdata: PMF1 | DataAircraftMounts }}|{{#getdata: PMF2 | DataAircraftMounts }}|{{#getdata: PMA1 | DataAircraftMounts }}|{{#getdata: PMA2 | DataAircraftMounts }}|{{#getdata: PS1 | DataAircraftMounts }}|{{#getdata: PS2 | DataAircraftMounts }}}} |
}} | }} | ||
|} | |} |
Revision as of 23:39, 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 |
---|
Magazines
Name | Capacity | Content |
---|
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) |
---|