Template:GatherableMaterialsTable: Difference between revisions

From Official Barotrauma Wiki
Jump to: navigation, search
(Materials table isn't being rendered due to `Error 1052: Column 'description' in field list is ambiguous (scpcbgamwiki.mysql.db)` error)
mNo edit summary
Line 4: Line 4:
! rowspan="2" style="width:8%;" | {{{1}}} Components
! rowspan="2" style="width:8%;" | {{{1}}} Components
! rowspan="2" style="width:16%;" | Description
! rowspan="2" style="width:16%;" | Description
! colspan="5" style="width:32%;" | Commonness
! colspan="5" style="width:32%;" | Commonness (Level, Cave, Abyss)
! colspan="5" style="width:20%;" | [[Store]]
! colspan="5" style="width:20%;" | [[Store]]
|-
|-
! [[Biomes#Cold Caverns|Cold Caverns]] !! [[Biomes#Europan Ridge|Europan Ridge]] !! [[Biomes#The Aphotic Plateau|The Aphotic Plateau]] !! [[Biomes#The Great Sea|The Great Sea]] !! [[Biomes#Hydrothermal Wastes|Hydrothermal Wastes]] !! Colony !! Habitation !! Research !! Military !! Mining
! [[Biomes#Cold Caverns|Cold Caverns]] !! [[Biomes#Europan Ridge|Europan Ridge]] !! [[Biomes#The Aphotic Plateau|The Aphotic Plateau]] !! [[Biomes#The Great Sea|The Great Sea]] !! [[Biomes#Hydrothermal Wastes|Hydrothermal Wastes]] !! Colony !! Habitation !! Research !! Military !! Mining
{{#cargo_query:
{{#cargo_query:
tables = Gatherable_Materials,Items
tables = Items
| join on = Gatherable_Materials.name = Items.name
| fields = icon, sprite, commonness, commonness_coldcaverns, commonness_europanridge, commonness_theaphoticplateau, commonness_thegreatsea, commonness_hydrothermalwastes,
| fields = Gatherable_Materials.name, icon, sprite, Gatherable_Materials.description, commonness,  
outpostsold, citysold, researchsold, militarysold, minesold, baseprice, outpostmultiplier, citymultiplier, researchmultiplier, militarymultiplier, minemultiplier, deconstructormaterials
commonness_coldcaverns, commonness_europanridge, commonness_theaphoticplateau, commonness_thegreatsea, commonness_hydrothermalwastes,
outpostsold, citysold, researchsold, militarysold, minesold,
baseprice, outpostmultiplier, citymultiplier, researchmultiplier, militarymultiplier, minemultiplier, deconstructormaterials
| where = Gatherable_Materials.type = "{{{1}}}"
| where = Gatherable_Materials.type = "{{{1}}}"
| format = template
| format = template

Revision as of 10:39, 12 January 2023