Difference between revisions of "Template:DataFacilityLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
(username removed)
 
(27 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
</css><div style="height:0px;">
 
</css><div style="height:0px;">
  
−
__NOTITLE____NOTOC__
+
__NOTITLE__
  
 
{{#rawquery: SELECT * FROM DataFacility WHERE ID = '{{{1}}}'; | 1 | DataFacility }}
 
{{#rawquery: SELECT * FROM DataFacility WHERE ID = '{{{1}}}'; | 1 | DataFacility }}
Line 19: Line 19:
  
 
</div>
 
</div>
−
<img src="http://baloogan.images.blu3wolf.com/facility_{{ #getdata: ID | DataFacility }}.jpg" class="baloogan_small_image" id="baloogan_image"/>
+
<img src="http://11rdp.fr/dbimages/facility_{{ #getdata: ID | DataFacility }}.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;">
 
<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 | DataFacility }} - {{ #getdata: Name | DataFacility }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataFacility }}-{{ #getdata: YearDecommissioned | DataFacility }}, {{ #getdata: Comments | DataFacility }}
 
<nowiki>#</nowiki>{{ #getdata: ID | DataFacility }} - {{ #getdata: Name | DataFacility }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataFacility }}-{{ #getdata: YearDecommissioned | DataFacility }}, {{ #getdata: Comments | DataFacility }}
 
</div>
 
</div>
 +
{| style="width=100%;" |
 +
| style="vertical-align:top;" |
 +
__TOC__
 +
| style="vertical-align:top;width=100%;min-width:200px;" |
 +
{{Description:Facility_{{ #getdata: ID | DataFacility }}}}
 +
 +
[http://wiki.baloogancampaign.com/index.php/Description:Facility_{{ #getdata: ID | DataFacility }}?action=edit Edit description]
 +
|}
 
====General Data====
 
====General Data====
−
 
 
{|class="wikitable"
 
{|class="wikitable"
 +
|'''Country:'''
 +
| [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}}]]
 +
|'''Service:'''
 +
| [[{{#replace:{{#replace:{{ #getdata: Description | EnumOperatorCountry }}|[|(}}|]|)}} {{#replace:{{#replace:{{ #getdata: Description | EnumOperatorService }}|[|(}}|]|)}}]]
 +
|-
 
|'''Category:'''
 
|'''Category:'''
 
|[[{{ #getdata: Description | EnumFacilityCategory }}]]
 
|[[{{ #getdata: Description | EnumFacilityCategory }}]]
Line 44: Line 56:
 
|{{ #getdata: Width | DataFacility }} m
 
|{{ #getdata: Width | DataFacility }} m
 
|'''Mounts Are Aimpoints:'''
 
|'''Mounts Are Aimpoints:'''
−
|{{ #getdata: MountsAreAimpoints | DataFacility }} m
+
|{{ #getdata: MountsAreAimpoints | DataFacility }}  
 
|-
 
|-
 
|'''Area:'''
 
|'''Area:'''
Line 52: Line 64:
 
|{{ #getdata: Crew | DataFacility }}
 
|{{ #getdata: Crew | DataFacility }}
 
|}
 
|}
 +
 +
====Air Facilities====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilityAircraftFacilities WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityAircraftFacilitiesCount }}
 +
{|class="wikitable"
 +
!Facility Type
 +
!Physical Size
 +
!Capacity
 +
!Runway Length
 +
|-
 +
{{
 +
#loop: DataFacilityAircraftFacilityIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilityAircraftFacilitiesCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilityAircraftFacilities WHERE ID = '{{ #getdata: ID | DataFacility }}'; | {{#var:DataFacilityAircraftFacilityIndex}} | DataFacilityAircraftFacilities }}
 +
{{#rawquery: SELECT * FROM DataAircraftFacility WHERE ID = '{{ #getdata: ComponentID | DataFacilityAircraftFacilities }}'; | 1 | DataAircraftFacility }}
 +
{{#rawquery: SELECT * FROM EnumAircraftFacilityType WHERE ID = '{{ #getdata: Type | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityType }}
 +
{{#rawquery: SELECT * FROM EnumAircraftFacilityPhysicalSize WHERE ID = '{{ #getdata: PhysicalSize | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityPhysicalSize }}
 +
{{#rawquery: SELECT * FROM EnumAircraftFacilityRunwayLength WHERE ID = '{{ #getdata: RunwayLength | DataAircraftFacility }}'; | 1 | EnumAircraftFacilityRunwayLength }}
 +
</div>
 +
{{!}}-
 +
{{!}} [[{{#getdata: Description| EnumAircraftFacilityType }}]]
 +
{{!}} [[{{#getdata: Description| EnumAircraftFacilityPhysicalSize }}]]
 +
{{!}} {{#getdata: Capacity| DataAircraftFacility }}
 +
{{!}} {{#ifeq: {{#getdata: Description| EnumAircraftFacilityRunwayLength }} | None | | [[{{#getdata: Description| EnumAircraftFacilityRunwayLength }}]]}}
 +
}}
 +
|}
 +
 
====Sensors/EW====
 
====Sensors/EW====
 
{{#rawquery: SELECT COUNT(1) FROM DataFacilitySensors WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilitySensorsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataFacilitySensors WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilitySensorsCount }}
Line 60: Line 100:
 
!Role
 
!Role
 
!Max Range (nm)
 
!Max Range (nm)
−
!Arc
+
!Arc Search
 +
!Arc Engage
 
|-
 
|-
 
{{
 
{{
Line 78: Line 119:
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
−
{{!}}'''{{#getdata: Description | EnumSensorRole}}'''
+
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole}}|[|(}}|]|)}}]]'''
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" |  }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" |  }}
 
{{!}}-
 
{{!}}-
Line 115: Line 156:
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
−
{{!}}{{#getdata: Description | EnumSensorRole2}}
+
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole2}}|[|(}}|]|)}}]]'''
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }}
 
{{!}}-
 
{{!}}-
Line 135: Line 176:
 
{{!}}{{#getdata: RangeMax | DataSensor }}
 
{{!}}{{#getdata: RangeMax | DataSensor }}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataFacilitySensors }}|{{#getdata: SB2 | DataFacilitySensors }}|{{#getdata: SMF1 | DataFacilitySensors }}|{{#getdata: SMF2 | DataFacilitySensors }}|{{#getdata: SMA1 | DataFacilitySensors }}|{{#getdata: SMA2 | DataFacilitySensors }}|{{#getdata: SS1 | DataFacilitySensors }}|{{#getdata: SS2 | DataFacilitySensors }}|{{#getdata: PB1 | DataFacilitySensors }}|{{#getdata: PB2 | DataFacilitySensors }}|{{#getdata: PMF1 | DataFacilitySensors }}|{{#getdata: PMF2 | DataFacilitySensors }}|{{#getdata: PMA1 | DataFacilitySensors }}|{{#getdata: PMA2 | DataFacilitySensors }}|{{#getdata: PS1 | DataFacilitySensors }}|{{#getdata: PS2 | DataFacilitySensors }}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataFacilitySensors }}|{{#getdata: SB2 | DataFacilitySensors }}|{{#getdata: SMF1 | DataFacilitySensors }}|{{#getdata: SMF2 | DataFacilitySensors }}|{{#getdata: SMA1 | DataFacilitySensors }}|{{#getdata: SMA2 | DataFacilitySensors }}|{{#getdata: SS1 | DataFacilitySensors }}|{{#getdata: SS2 | DataFacilitySensors }}|{{#getdata: PB1 | DataFacilitySensors }}|{{#getdata: PB2 | DataFacilitySensors }}|{{#getdata: PMF1 | DataFacilitySensors }}|{{#getdata: PMF2 | DataFacilitySensors }}|{{#getdata: PMA1 | DataFacilitySensors }}|{{#getdata: PMA2 | DataFacilitySensors }}|{{#getdata: PS1 | DataFacilitySensors }}|{{#getdata: PS2 | DataFacilitySensors }}}}
 +
{{!}}{{RenderArc|{{#getdata: SB1Max | DataFacilitySensors }}|{{#getdata: SB2Max | DataFacilitySensors }}|{{#getdata: SMF1Max | DataFacilitySensors }}|{{#getdata: SMF2Max | DataFacilitySensors }}|{{#getdata: SMA1Max | DataFacilitySensors }}|{{#getdata: SMA2Max | DataFacilitySensors }}|{{#getdata: SS1Max | DataFacilitySensors }}|{{#getdata: SS2Max | DataFacilitySensors }}|{{#getdata: PB1Max | DataFacilitySensors }}|{{#getdata: PB2Max | DataFacilitySensors }}|{{#getdata: PMF1Max | DataFacilitySensors }}|{{#getdata: PMF2Max | DataFacilitySensors }}|{{#getdata: PMA1Max | DataFacilitySensors }}|{{#getdata: PMA2Max | DataFacilitySensors }}|{{#getdata: PS1Max | DataFacilitySensors }}|{{#getdata: PS2Max | DataFacilitySensors }}}}
 
}}
 
}}
 
|}
 
|}
 +
 
====Mounts====
 
====Mounts====
 
{{#rawquery: SELECT COUNT(1) FROM DataFacilityMounts WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityMountsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataFacilityMounts WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityMountsCount }}
Line 210: Line 253:
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | DataWeapon}} nm
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 247: Line 295:
 
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }}
 
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }}
 
{{#rawquery: SELECT COUNT(1) FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorSensorGroupsCount }}
 
{{#rawquery: SELECT COUNT(1) FROM DataSensorSensorGroups WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorSensorGroupsCount }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }}
 
</div>
 
</div>
 
{{!}}-
 
{{!}}-
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
−
{{!}}{{#getdata: Description | EnumSensorRole}}
+
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole}}|[|(}}|]|)}}]]'''
 +
 
 +
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }} | 0 | style="display:none;" | }}
 +
{{!}}-
 +
{{
 +
#loop: SensorCapabilityIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataSensorCapabilitiesCount }}
 +
|<nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}' ; | {{#var:SensorCapabilityIndex}} | DataSensorCapabilities }}
 +
{{#rawquery: SELECT * FROM EnumSensorCapability WHERE ID = '{{ #getdata: CodeID | DataSensorCapabilities }}'; | 1 | EnumSensorCapability  }}
 +
</div>
 +
{{!}}-
 +
{{!}} [[{{#getdata: Description | EnumSensorCapability }}]]
 +
}}
 +
{{!}}}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;" | }}
 
{{{!}}class="wikitable sortable" {{#ifeq: {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }} | 0 | style="display:none;" | }}
 
{{!}}+Sensors
 
{{!}}+Sensors
Line 329: Line 393:
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | DataWeapon}} nm
 
}}
 
}}
 
{{!}}}
 
{{!}}}
Line 349: Line 418:
 
{{!}}}
 
{{!}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataFacilityMounts }}|{{#getdata: SB2 | DataFacilityMounts }}|{{#getdata: SMF1 | DataFacilityMounts }}|{{#getdata: SMF2 | DataFacilityMounts }}|{{#getdata: SMA1 | DataFacilityMounts }}|{{#getdata: SMA2 | DataFacilityMounts }}|{{#getdata: SS1 | DataFacilityMounts }}|{{#getdata: SS2 | DataFacilityMounts }}|{{#getdata: PB1 | DataFacilityMounts }}|{{#getdata: PB2 | DataFacilityMounts }}|{{#getdata: PMF1 | DataFacilityMounts }}|{{#getdata: PMF2 | DataFacilityMounts }}|{{#getdata: PMA1 | DataFacilityMounts }}|{{#getdata: PMA2 | DataFacilityMounts }}|{{#getdata: PS1 | DataFacilityMounts }}|{{#getdata: PS2 | DataFacilityMounts }}}}
 
{{!}}{{RenderArc|{{#getdata: SB1 | DataFacilityMounts }}|{{#getdata: SB2 | DataFacilityMounts }}|{{#getdata: SMF1 | DataFacilityMounts }}|{{#getdata: SMF2 | DataFacilityMounts }}|{{#getdata: SMA1 | DataFacilityMounts }}|{{#getdata: SMA2 | DataFacilityMounts }}|{{#getdata: SS1 | DataFacilityMounts }}|{{#getdata: SS2 | DataFacilityMounts }}|{{#getdata: PB1 | DataFacilityMounts }}|{{#getdata: PB2 | DataFacilityMounts }}|{{#getdata: PMF1 | DataFacilityMounts }}|{{#getdata: PMF2 | DataFacilityMounts }}|{{#getdata: PMA1 | DataFacilityMounts }}|{{#getdata: PMA2 | DataFacilityMounts }}|{{#getdata: PS1 | DataFacilityMounts }}|{{#getdata: PS2 | DataFacilityMounts }}}}
 +
}}
 +
|}
 +
 +
====Magazines====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilityMagazines WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityMagazinesCount }}
 +
{|class="wikitable sortable"
 +
!Name
 +
!Capacity
 +
!Content
 +
|-
 +
{{
 +
#loop: MagazineIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilityMagazinesCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilityMagazines WHERE ID = '{{ #getdata: ID | DataFacility }}' ; | {{#var:MagazineIndex}} | DataFacilityMagazines }}
 +
{{#rawquery: SELECT * FROM DataMagazine WHERE ID = '{{ #getdata: ComponentID | DataFacilityMagazines }}'; | 1 | DataMagazine }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMagazine }}'; | 1 | DataMagazineWeaponsCount }}
 +
</div>
 +
{{!}}-
 +
{{!}} {{#getdata: Name | DataMagazine}}
 +
{{!}} {{#getdata: Capacity | DataMagazine}}
 +
{{!}}
 +
{{{!}}class="wikitable sortable"  {{#ifeq: {{#getdata: COUNT(1) | DataMagazineWeaponsCount }} | 0 | style="display:none;" |  }}
 +
!Name
 +
!Type
 +
!DefaultLoad
 +
!MaxLoad
 +
!ROF
 +
!Range
 +
!Targets
 +
{{!}}-
 +
{{
 +
#loop: MagazineWeaponIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataMagazineWeaponsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataMagazineWeapons WHERE ID = '{{ #getdata: ID | DataMagazine }}' ; | {{#var:MagazineWeaponIndex}} | DataMagazineWeapons}}
 +
{{#rawquery: SELECT * FROM DataWeaponRecord WHERE ID = '{{ #getdata: ComponentID | DataMagazineWeapons }}'; | 1 | DataWeaponRecord }}
 +
{{#rawquery: SELECT * FROM DataWeapon WHERE ID = '{{ #getdata: ComponentID | DataWeaponRecord }}'; | 1 | DataWeapon }}
 +
{{#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>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataWeapon?ID={{#getdata: ID | DataWeapon}} {{#replace:{{#replace:{{#getdata: Name | DataWeapon}}|[|(}}|]|)}}]'''
 +
{{!}}[[{{#getdata: Description | EnumWeaponType}}]]
 +
{{!}}{{#getdata: DefaultLoad | DataWeaponRecord}}
 +
{{!}}{{#getdata: MaxLoad | DataWeaponRecord}}
 +
{{!}}{{#getdata: ROF | DataWeaponRecord}}
 +
{{!}}
 +
{{{!}} class="wikitable"
 +
!
 +
!Min
 +
!Max
 +
{{!}}-
 +
{{#ifeq: {{#getdata: AirRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Air'''
 +
{{!}}{{#getdata: AirRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: AirRangeMax | DataWeapon}} nm
 +
{{!}}-
 +
}}
 +
{{#ifeq: {{#getdata: SurfaceRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Surface'''
 +
{{!}}{{#getdata: SurfaceRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: SurfaceRangeMax | DataWeapon}} nm
 +
{{!}}-
 +
}}
 +
{{#ifeq: {{#getdata: SubsurfaceRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Subsurface'''
 +
{{!}}{{#getdata: SubsurfaceRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: SubsurfaceRangeMax | DataWeapon}} nm
 +
}}
 +
{{#ifeq: {{#getdata: LandRangeMax | DataWeapon}} | 0 ||
 +
{{!}} '''Land'''
 +
{{!}}{{#getdata: LandRangeMin | DataWeapon}} nm
 +
{{!}}{{#getdata: LandRangeMax | 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}}]]
 +
}}
 +
{{!}}}
 +
}}
 +
{{!}}}
 +
}}
 +
|}
 +
 +
====Signatures====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilitySignatures WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilitySignaturesCount }}
 +
{|class="wikitable sortable"
 +
!Signature Type
 +
!Front (nm)
 +
!Side (nm)
 +
!Rear (nm)
 +
!Top (nm)
 +
|-
 +
|
 +
|
 +
| nm for Visual/Pac
 +
| dBsm for Radar
 +
| db for Sonar
 +
|-
 +
{{
 +
#loop: SignatureIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilitySignaturesCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilitySignatures WHERE ID = '{{ #getdata: ID | DataFacility }}' ; | {{#var:SignatureIndex}} | DataFacilitySignatures }}
 +
{{#rawquery: SELECT * FROM EnumSignatureType WHERE ID = '{{ #getdata: Type | DataFacilitySignatures }}'; | 1 | EnumSignatureType }}
 +
</div>
 +
{{!}}-
 +
{{!}}[[{{#getdata: Description | EnumSignatureType}}]]
 +
{{!}} {{#getdata: Front | DataFacilitySignatures}}
 +
{{!}} {{#getdata: Side | DataFacilitySignatures}}
 +
{{!}} {{#getdata: Rear | DataFacilitySignatures}}
 +
{{!}} {{#getdata: Top | DataFacilitySignatures}}
 +
}}
 +
|}
 +
 +
====Comms/Datalinks====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilityComms WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityCommsCount }}
 +
{|class="wikitable sortable"
 +
|+Comms
 +
!Name
 +
!Type
 +
!Range (nm)
 +
!Channels
 +
|-
 +
{{
 +
#loop: CommIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilityCommsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilityComms WHERE ID = '{{ #getdata: ID | DataFacility }}' ; | {{#var:CommIndex}} | DataFacilityComms}}
 +
{{#rawquery: SELECT * FROM DataComm WHERE ID = '{{ #getdata: ComponentID | DataFacilityComms }}'; | 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 }}
 +
}}
 +
|}
 +
 +
====Fuel====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilityFuel WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityFuelCount }}
 +
{|class="wikitable sortable"
 +
!Fuel Type
 +
!Quantity (kg)
 +
|-
 +
{{
 +
#loop: FuelIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilityFuelCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilityFuel WHERE ID = '{{ #getdata: ID | DataFacility }}' ; | {{#var:FuelIndex}} | DataFacilityFuel }}
 +
{{#rawquery: SELECT * FROM DataFuel WHERE ID = '{{ #getdata: ComponentID | DataFacilityFuel }}'; | 1 | DataFuel }}
 +
{{#rawquery: SELECT * FROM EnumFuelType WHERE ID = '{{ #getdata: Type | DataFuel }}'; | 1 | EnumFuelType }}
 +
</div>
 +
{{!}}-
 +
{{!}}[[{{#getdata: Description | EnumFuelType}}]]
 +
{{!}}{{#getdata: Capacity | DataFuel}}
 
}}
 
}}
 
|}
 
|}

Latest revision as of 07:03, 27 October 2015








<img src="http://11rdp.fr/dbimages/facility_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)

{{Description:Facility_DataInvoker Error: getData error: No such key in handle (ID)}}

DataInvoker Error: getData error: No such key in handle (ID)?action=edit Edit description

General Data

Country: [[DataInvoker Error: getData error: No such key in handle (Description)]] Service: [[DataInvoker Error: getData error: No such key in handle (Description) DataInvoker Error: getData error: No such key in handle (Description)]]
Category: [[DataInvoker Error: getData error: No such key in handle (Description)]] General Armor: DataInvoker Error: getData error: No such key in handle (Description)
Damage Points: DataInvoker Error: getData error: No such key in handle (DamagePoints) Mast Height: DataInvoker Error: getData error: No such key in handle (MastHeight) m
Length: DataInvoker Error: getData error: No such key in handle (Length) m Vehicle/Component Dispersal Radius: DataInvoker Error: getData error: No such key in handle (Radius) m
Width: DataInvoker Error: getData error: No such key in handle (Width) m Mounts Are Aimpoints: DataInvoker Error: getData error: No such key in handle (MountsAreAimpoints)
Area: DataInvoker Error: getData error: No such key in handle (Area) m
Crew: DataInvoker Error: getData error: No such key in handle (Crew)

Air Facilities

Facility Type Physical Size Capacity Runway Length

Sensors/EW

Sensors
Name Type Role Max Range (nm) Arc Search Arc Engage

Mounts

Mounts
Mount ROF Capacity Weapons, Sensors and Magazine Arc

Magazines

Name Capacity Content

Signatures

Signature Type Front (nm) Side (nm) Rear (nm) Top (nm)
nm for Visual/Pac dBsm for Radar db for Sonar

Comms/Datalinks

Comms
Name Type Range (nm) Channels

Fuel

Fuel Type Quantity (kg)
Retrieved from "https://wiki.baloogancampaign.com/index.php?title=Template:DataFacilityLong&oldid=5826"