View source for Template:DataWeaponLong

<css>
p {
line-height:18px;
}
</css><div style="height:0px;">

__NOTITLE__

{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{{1}}}'; | 1 | DataWeapon }}

{{#rawquery: SELECT * FROM EnumWeaponType WHERE ID = '{{ #getdata: Type | DataWeapon }}'; | 1 | EnumWeaponType }}



{{DISPLAYTITLE:{{ #getdata: Name | DataWeapon }}}}

</div>
<img src="http://baloogan.images.blu3wolf.com/weapon_{{ #getdata: ID | DataWeapon }}.jpg" class="baloogan_small_image" id="baloogan_image"/>
<div style="min-height:40px;COLOR: #000066; FONT-WEIGHT: bold; FONT-SIZE: 14pt;  BACKGROUND: #eee;  FONT-FAMILY: Arial, Helvetica, sans-serif;BORDER: #ccc 1px solid;">
<nowiki>#</nowiki>{{ #getdata: ID | DataWeapon }} - {{ #getdata: Name | DataWeapon }} -- {{ #getdata: Comments | DataWeapon }}
</div>
{| style="width=100%;" |
| style="vertical-align:top;" |
__TOC__ 
| style="vertical-align:top;width=100%;min-width:200px;" |
{{Description:DB3000_Weapon_{{ #getdata: ID | DataWeapon }}}}

[http://wiki.baloogancampaign.com/index.php/Description:DB3000_Weapon_{{ #getdata: ID | DataWeapon }}?action=edit Edit description]
|}
====General Data====
{|class="wikitable"
|'''Type:'''
|{{#getdata: Description|EnumWeaponType}}
|-
|'''Length:'''
|{{ #getdata: Length | DataWeapon }} m
|-
|'''Span:'''
|{{ #getdata: Span | DataWeapon }} m
|-
|'''Diameter:'''
|{{ #getdata: Diameter | DataWeapon }} m
|-
|'''Weight:'''
|{{ #getdata: Weight | DataWeapon }} kg
|-
|'''Burnout Weight:'''
|{{#ifeq: {{ #getdata: BurnoutWeight | DataWeapon }} | 0 | | {{ #getdata: BurnoutWeight | DataWeapon }} kg }} 
|-
|'''Cruise Altitude:'''
|{{#ifeq: {{ #getdata: CruiseAltitude | DataWeapon }} | 0 | | {{ #getdata: CruiseAltitude | DataWeapon }} kg }} 
|-
|'''Waypoint Number:'''
|{{#ifeq: {{ #getdata: WaypointNumber| DataWeapon }} | 0 | |  {{ #getdata: WaypointNumber| DataWeapon }} kg }} 
|-
|'''IlluminationTime:'''
|{{#ifeq: {{ #getdata: IlluminationTime | DataWeapon }} | 0 | | {{ #getdata: IlluminationTime | DataWeapon }} kg }} 
|-
|'''CEP:'''
|{{#ifeq: {{ #getdata: CEP | DataWeapon }} | 0 | | {{ #getdata: CEP | DataWeapon }} % }} 
|-
|'''Air PK:'''
|{{#ifeq: {{ #getdata: AirPoK | DataWeapon }} | 0 | | {{ #getdata: AirPoK | DataWeapon }} % }} 
|-
|'''Surface PK:'''
|{{#ifeq: {{ #getdata: SurfacePoK | DataWeapon }} | 0 | | {{ #getdata: SurfacePoK | DataWeapon }} % }} 
|-
|'''Subsurface PK:'''
|{{#ifeq: {{ #getdata: SubsurfacePoK | DataWeapon }} | 0 | | {{ #getdata: SubsurfacePoK | DataWeapon }} % }} 
|-
|'''ClimbRate:'''
|{{#ifeq: {{ #getdata: ClimbRate | DataWeapon }} | 0 | | {{ #getdata: ClimbRate | DataWeapon }} m/s }} 
|-
|'''Air Min Range:'''
|{{#ifeq: {{ #getdata: AirRangeMin | DataWeapon }} | 0 | | {{ #getdata: AirRangeMin | DataWeapon }} nm }} 
|'''Air Max Range:'''
|{{#ifeq: {{ #getdata: AirRangeMax | DataWeapon }} | 0 | | {{ #getdata: AirRangeMax | DataWeapon }} nm }} 
|-
|'''Surface Min Range:'''
|{{#ifeq: {{ #getdata: SurfaceRangeMin | DataWeapon }} | 0 | | {{ #getdata: SurfaceRangeMin | DataWeapon }} nm }} 
|'''Surface Max Range:'''
|{{#ifeq: {{ #getdata: SurfaceRangeMax | DataWeapon }} | 0 | | {{ #getdata: SurfaceRangeMax | DataWeapon }} nm }} 
|-
|'''Subsurface Min Range:'''
|{{#ifeq: {{ #getdata: SubsurfaceRangeMin | DataWeapon }} | 0 | | {{ #getdata: SubsurfaceRangeMin | DataWeapon }} nm }} 
|'''Subsurface Max Range:'''
|{{#ifeq: {{ #getdata: SubsurfaceRangeMax | DataWeapon }} | 0 | | {{ #getdata: SubsurfaceRangeMax | DataWeapon }} nm }} 


|}

====Properties====
====Sensors/EW====

====Signatures====
{{#rawquery: SELECT COUNT(1) FROM DataWeaponSignatures WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponSignaturesCount }}
{|class="wikitable sortable"
!Signature Type
!Front 
!Side 
!Rear
|-
|
| nm for Visual/Pac
| dBsm for Radar
| db for Sonar
|-
{{
#loop: SignatureIndex
| 1
| {{#getdata: COUNT(1) | DataWeaponSignaturesCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataWeaponSignatures WHERE ID = '{{ #getdata: ID | DataWeapon }}' ; | {{#var:SignatureIndex}} | DataWeaponSignatures }}
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataWeaponSignatures }}'; | 1 | EnumSignatureType }}
</div>
{{!}}-
{{!}}[[{{#getdata: Description | EnumSignatureType}}]]
{{!}} {{#getdata: Front | DataWeaponSignatures}}
{{!}} {{#getdata: Side | DataWeaponSignatures}}
{{!}} {{#getdata: Rear | DataWeaponSignatures}}
}}
|}
====Loadouts====

<include wikitext nopre  src="http://render.baloogancampaign.com/weapon_join.php?ID={{ #getdata: ID | DataWeapon }}"/>

====Comms/Datalinks====
{{#rawquery: SELECT COUNT(1) FROM DataWeaponComms WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponCommsCount }}
{|class="wikitable sortable"
|+Comms
!Name
!Type
!Range (nm)
!Channels
|-
{{
#loop: CommIndex
| 1
| {{#getdata: COUNT(1) | DataWeaponCommsCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataWeaponComms WHERE ID = '{{ #getdata: ID | DataWeapon }}' ; | {{#var:CommIndex}} | DataWeaponComms}}
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataWeaponComms }}'; | 1 | DataComm }}
{{#rawquery: SELECT * FROM EnumCommType WHERE ID = '{{ #getdata: Type | DataComm }}'; | 1 | EnumCommType }}
</div>
{{!}}-
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataComm}}|[|(}}|]|)}}
{{!}}[[{{#getdata: Description | EnumCommType}}]]
{{!}}{{#getdata: MyRange | DataComm}}
{{!}}{{#getdata: Channels | DataComm }}
}}
|}
====Propulsion====
{{#rawquery: SELECT COUNT(1) FROM DataWeaponPropulsion WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponPropulsionCount }}
{|class="wikitable sortable"
!Engines
!Type
!Loiter Speed (kts)
!Cruise Speed (kts)
!Military Speed (kts)
!Afterburner Speed (kts)
|-
{{
#loop: PropulsionIndex
| 1
| {{#getdata: COUNT(1) | DataWeaponPropulsionCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataWeaponPropulsion WHERE ID = '{{ #getdata: ID | DataWeapon }}' ; | {{#var:PropulsionIndex}} | DataWeaponPropulsion}}
{{#rawquery: SELECT * FROM DataPropulsion WHERE ID = '{{ #getdata: ComponentID | DataWeaponPropulsion }}'; | 1 | DataPropulsion }}
{{#rawquery: SELECT * FROM EnumPropulsionType WHERE ID = '{{ #getdata: Type | DataPropulsion }}'; | 1 | EnumPropulsionType }}
{{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='1'; | 1 | DataPropulsionPerformance1 }}
{{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='2'; | 1 | DataPropulsionPerformance2 }}
{{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='3'; | 1 | DataPropulsionPerformance3 }}
{{#rawquery: SELECT MAX(Speed) FROM DataPropulsionPerformance WHERE ID = '{{ #getdata: ID | DataPropulsion }}' AND Throttle='4'; | 1 | DataPropulsionPerformance4 }}
</div>
{{!}}-
{{!}}{{#replace:{{#replace:{{#getdata: Name | DataPropulsion}}|[|(}}|]|)}}
{{!}}[[{{#getdata: Description | EnumPropulsionType}}]]
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance1 | true }}
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance2 | true }}
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance3 | true }}
{{!}} {{#getdata: MAX(Speed) | DataPropulsionPerformance4 | true }}
}}
|}

====Fuel====
{{#rawquery: SELECT COUNT(1) FROM DataWeaponFuel WHERE ID = '{{ #getdata: ID | DataWeapon }}'; | 1 | DataWeaponFuelCount }}
{|class="wikitable sortable"
!Fuel Type
!Quantity (kg)
|-
{{
#loop: FuelIndex
| 1
| {{#getdata: COUNT(1) | DataWeaponFuelCount }}
| <nowiki/><div style="display:none;">
{{#rawquery: SELECT * FROM DataWeaponFuel WHERE ID = '{{ #getdata: ID | DataWeapon }}' ; | {{#var:FuelIndex}} | DataWeaponFuel }}
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataWeaponFuel }}'; | 1 | DataFuel }}
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}
</div>
{{!}}-
{{!}}[[{{#getdata: Description | EnumFuelType}}]]
{{!}}{{#getdata: Capacity | DataFuel}}
}}
|}