Difference between revisions of "Template:DataFacilityLong"

From Baloogan Campaign Wiki
Jump to: navigation, search
 
(username removed)
 
(29 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 51: Line 63:
 
|'''Crew:'''
 
|'''Crew:'''
 
|{{ #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====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilitySensors WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilitySensorsCount }}
 +
{|class="wikitable sortable"
 +
|+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
!Arc Search
 +
!Arc Engage
 +
|-
 +
{{
 +
#loop: SensorIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilitySensorsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilitySensors WHERE ID = '{{ #getdata: ID | DataFacility }}' ; | {{#var:SensorIndex}} | DataFacilitySensors}}
 +
{{#rawquery: SELECT * FROM DataSensor WHERE ID = '{{ #getdata: ComponentID | DataFacilitySensors }}'; | 1 | DataSensor }}
 +
{{#rawquery: SELECT * FROM EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
 +
{{#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 DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }}
 +
</div>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 +
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 +
{{!}}'''[[{{#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;"  | }}
 +
{{!}}+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
{{!}}-
 +
{{
 +
#loop: SensorGroupIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#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 EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor2 }}'; | 1 | DataSensorCapabilitiesCount }}
 +
</div>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor2}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 +
{{!}}[[{{#getdata: Description | EnumSensorType2}}]]
 +
{{!}}'''[[{{#replace:{{#replace:{{#getdata: Description | EnumSensorRole2}}|[|(}}|]|)}}]]'''
 +
{{{!}}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 | DataSensor2 }}' ; | {{#var:SensorCapabilityIndex}} | DataSensorCapabilities }}
 +
{{#rawquery: SELECT * FROM EnumSensorCapability WHERE ID = '{{ #getdata: CodeID | DataSensorCapabilities }}'; | 1 | EnumSensorCapability  }}
 +
</div>
 +
{{!}}-
 +
{{!}} [[{{#getdata: Description | EnumSensorCapability }}]]
 +
}}
 +
{{!}}}
 +
{{!}}{{#getdata: RangeMax | DataSensor2 }}
 +
}}
 +
{{!}}}
 +
{{!}}{{#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: 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====
 +
{{#rawquery: SELECT COUNT(1) FROM DataFacilityMounts WHERE ID = '{{ #getdata: ID | DataFacility }}'; | 1 | DataFacilityMountsCount }}
 +
{|class="wikitable sortable"
 +
|+ Mounts
 +
!Mount
 +
!ROF
 +
!Capacity
 +
!Weapons, Sensors and Magazine
 +
!Arc
 +
|-
 +
{{
 +
#loop: MountIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataFacilityMountsCount }}
 +
|<nowiki/><div style="display:none;">
 +
{{#rawquery: SELECT * FROM DataFacilityMounts WHERE ID = '{{ #getdata: ID | DataFacility }}'; | {{#var:MountIndex}} | DataFacilityMounts}}
 +
{{#rawquery: SELECT * FROM DataMount WHERE ID = '{{ #getdata: ComponentID | DataFacilityMounts }}'; | 1 | DataMount }}
 +
{{#rawquery: SELECT COUNT(1) FROM DataMountWeapons WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountWeaponsCount }}
 +
</div>
 +
{{!}}-
 +
{{!}}'''{{#replace:{{#replace:{{#getdata: Name | DataMount}}|[|(}}|]|)}}'''
 +
{{!}}{{#getdata: ROF | DataMount}}
 +
{{!}}{{#getdata: Capacity | DataMount}}
 +
{{!}}
 +
{{{!}} class="wikitable sortable"
 +
{{!}}+Weapons
 +
!Name
 +
!Type
 +
!DefaultLoad
 +
!MaxLoad
 +
!ROF
 +
!Range
 +
!Targets
 +
{{!}}-
 +
{{
 +
#loop: MountWeaponIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataMountWeaponsCount }}
 +
|<nowiki/><div style="display:none;">
 +
{{#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 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}}]]
 +
}}
 +
{{!}}}
 +
}}
 +
{{!}}}{{#rawquery: SELECT COUNT(1) FROM DataMountSensors WHERE ID = '{{ #getdata: ID | DataMount }}'; | 1 | DataMountSensorsCount }}
 +
{{{!}}class="wikitable sortable"  {{#ifeq: {{#getdata: COUNT(1) | DataMountSensorsCount }} | 0 | style="display:none;" |  }}
 +
{{!}}+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
{{!}}-
 +
{{
 +
#loop: MountSensorIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataMountSensorsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#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 EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor }}'; | 1 | EnumSensorType }}
 +
{{#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 DataSensorCapabilities WHERE ID = '{{ #getdata: ID | DataSensor }}'; | 1 | DataSensorCapabilitiesCount }}
 +
</div>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor}}|[|(}}|]|)}}]'''
 +
{{!}}[[{{#getdata: Description | EnumSensorType}}]]
 +
{{!}}'''[[{{#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;" | }}
 +
{{!}}+Sensors
 +
!Name
 +
!Type
 +
!Role
 +
!Max Range (nm)
 +
{{!}}-
 +
{{
 +
#loop: MountSensorGroupIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataSensorSensorGroupsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#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 EnumSensorType WHERE ID = '{{ #getdata: Type | DataSensor2 }}'; | 1 | EnumSensorType2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
{{#rawquery: SELECT * FROM EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor2 }}'; | 1 | EnumSensorRole2 }}
 +
</div>
 +
{{!}}-
 +
{{!}} '''[http://wiki.baloogancampaign.com/index.php/DataSensor?ID={{#getdata: ID | DataSensor}} {{#replace:{{#replace:{{#getdata: Name | DataSensor2}}|[|(}}|]|)}}]'''
 +
{{!}} [[{{#getdata: Description | EnumSensorType2}}]]
 +
{{!}} {{#getdata: Description | EnumSensorRole2}}
 +
{{!}} {{#getdata: RangeMax | DataSensor2 }}
 +
}}
 +
{{!}}}
 +
{{!}} {{#getdata: RangeMax | DataSensor }}
 +
}}
 +
{{!}}}{{#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;" | inline }}
 +
{{!}}+Magazine
 +
!Name
 +
!Type
 +
!DefaultLoad
 +
!MaxLoad
 +
!ROF
 +
!Range
 +
!Targets
 +
{{!}}-
 +
{{
 +
#loop: MountMagazineIndex
 +
| 1
 +
| {{#getdata: COUNT(1) | DataMountMagazineWeaponsCount }}
 +
| <nowiki/><div style="display:none;">
 +
{{#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 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>
 +
{{!}}-
 +
{{!}}{{#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}}]]
 +
}}
 +
{{!}}}
 +
}}
 +
{{!}}}
 +
{{!}}{{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"