|
|
(9 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
− | <css>
| + | {{DatabaseHeader}} |
− | <!--#bodyContent{
| + | {{ #if: {{#urlget:ID}} | {{DataShipLong|{{#urlget:ID}}}} | {{DataShipList}} }} |
− | height:3000px;
| + | {{DatabaseFooter}} |
− | }--> | + | {{BlankCSS}} |
− | p {
| |
− | line-height:10px;
| |
− | } | |
− | </css><div style="height:0px;">
| |
− | | |
− | __NOTITLE____NOTOC__
| |
− | | |
− | {{#rawquery: SELECT * FROM DataShip WHERE ID = '{{#urlget:ID|3}}'; | 1 | DataShip }} | |
− | | |
− | {{#rawquery: SELECT * FROM EnumOperatorCountry WHERE ID = '{{ #getdata: OperatorCountry | DataShip }}'; | 1 | EnumOperatorCountry }}
| |
− | | |
− | {{#rawquery: SELECT * FROM EnumOperatorService WHERE ID = '{{ #getdata: OperatorService | DataShip }}'; | 1 | EnumOperatorService }} | |
− | | |
− | {{#rawquery: SELECT * FROM EnumShipType WHERE ID = '{{ #getdata: Type | DataShip }}'; | 1 | EnumShipType }}
| |
− | | |
− | {{#rawquery: SELECT * FROM EnumShipCategory WHERE ID = '{{ #getdata: Category | DataShip }}'; | 1 | EnumShipCategory}}
| |
− | | |
− | {{#rawquery: SELECT COUNT(1) FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}'; | 1 | DataShipSensorsCount }}
| |
− | | |
− | {{#rawquery: SELECT * FROM EnumShipPhysicalSize WHERE ID = '{{ #getdata: PhysicalSizeCode | DataShip }}'; | 1 | EnumShipPhysicalSize }}
| |
− | | |
− | {{DISPLAYTITLE:{{ #getdata: Name | DataShip }}}}
| |
− | | |
− | </div>
| |
− | <img src="http://baloogan.images.blu3wolf.com/ship_{{ #getdata: ID | DataAircraft }}.jpg" style="float:right;max-width:50%;"/>
| |
− | <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 | DataShip }} - {{ #getdata: Name | DataShip }} -- {{ #getdata: Description | EnumOperatorCountry }} ({{ #getdata: Description | EnumOperatorService }}), {{ #getdata: YearCommissioned | DataShip }}-{{ #getdata: YearDecommissioned | DataShip }}, {{ #getdata: Comments | DataShip }}
| |
− | </div>
| |
− | ====General Data====
| |
− | {|class="wikitable"
| |
− | |Category:
| |
− | |{{ #getdata: Description | EnumShipCategory }}
| |
− | |Max Sea State:
| |
− | |{{ #getdata: MaxSeaState | DataShip }}
| |
− | |-
| |
− | |Type:
| |
− | |{{ #getdata: Description | EnumShipType }}
| |
− | |Troop Capacity:
| |
− | |{{ #getdata: TroopCapacity | DataShip }}
| |
− | |-
| |
− | |Damage Points:
| |
− | |{{ #getdata: DamagePoints | DataShip }}
| |
− | |Cargo Capacity:
| |
− | |{{ #getdata: CargoCapacity | DataShip }}
| |
− | |-
| |
− | |Length:
| |
− | |{{ #getdata: Length | DataShip }} m
| |
− | |Pier / Dock / Davit Size:
| |
− | |{{ #getdata: Description | EnumShipPhysicalSize }}
| |
− | |-
| |
− | |Beam:
| |
− | |{{ #getdata: Span | DataShip }} m
| |
− | |-
| |
− | |Draft:
| |
− | |{{ #getdata: Draft | DataShip }} m
| |
− | |-
| |
− | |Height:
| |
− | |{{ #getdata: Height | DataShip }} m
| |
− | |-
| |
− | |Empty Displacement:
| |
− | |{{ #getdata: DisplacementEmpty | DataShip }} tons
| |
− | |-
| |
− | |Standard Displacement:
| |
− | |{{ #getdata: DisplacementStandard | DataShip }} tons
| |
− | |-
| |
− | |Full Displacement:
| |
− | |{{ #getdata: DisplacementFull | DataShip }} tons
| |
− | |-
| |
− | |Crew:
| |
− | |{{ #getdata: Crew | DataShip }}
| |
− | |}
| |
− | | |
− | ====Sensors/EW====
| |
− | | |
− | {{
| |
− | #loop: varname
| |
− | | 1
| |
− | | {{#getdata: COUNT(1) | DataShipSensorsCount }}
| |
− | | <nowiki/>{{#rawquery: SELECT * FROM DataShipSensors WHERE ID = '{{ #getdata: ID | DataShip }}' AND ComponentNumber = '{{#var:varname}}'; | 1 | DataShipSensors }}{{#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 EnumSensorRole WHERE ID = '{{ #getdata: Role | DataSensor }}'; | 1 | EnumSensorRole }}
| |
− | * {{#getdata: Name | DataSensor}} -{{#getdata: Comments | DataSensor}}
| |
− | ** '''{{#getdata: Description | EnumSensorType}}'''
| |
− | ** '''{{#getdata: Description | EnumSensorRole}}'''
| |
− | ** Range Min: {{#getdata: RangeMin | DataSensor }}
| |
− | ** Range Max: {{#getdata: RangeMax | DataSensor }}
| |
− | ** Altitude Min: {{#getdata: AltitudeMin | DataSensor }}
| |
− | ** Altitude Max: {{#getdata: AltitudeMax | DataSensor }}
| |
− | ** Scan Interval: {{#getdata: ScanInterval | DataSensor }}
| |
− | ** ECM Peak Power: {{#getdata: ECMPeakPower | DataSensor }}
| |
− | ** ECM Number of Targets: {{#getdata: ECMNumberOfTargets | DataSensor }}
| |
− | ** Sonar Min Deployment Depth: {{#getdata: SonarMinimumDeploymentDepth | DataSensor }}
| |
− | ** Sonar Max Deployment Depth: {{#getdata: SonarMaximumDeploymentDepth | DataSensor }}
| |
− | }}
| |
− | ====Credits====
| |
− | * Information out of [[DB3000]] by Warfare Sims
| |
− | * Images: stormridersp, fab94, renders, alkiap, sstrong, RoyHarper, Runibl, bradinggs, Steven Lohr, Jeff Leslie, Meroka37, conforoa, OldPascas, SilentHunter, snowburn, incredibletwo, Henry Morgan, fool12342000, Papa_Hausser, baskreuger
| |
− | * Images hosted by Blu3wolf
| |