Unidentified artifacts: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(Additional categories) |
||
| Line 15: | Line 15: | ||
GD.Tier, | GD.Tier, | ||
IT.Complexity | IT.Complexity | ||
|where=WAD.UnknownImage IS NOT NULL AND (WAD. | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange tubes' OR WAD.UnknownAltNameStripped = 'strange tubes') | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||
|format=table | |format=table | ||
| Line 32: | Line 32: | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity | ||
|where=WAD.UnknownImage IS NOT NULL AND (WAD. | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'strange plant' OR WAD.UnknownAltNameStripped = 'strange plant') | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||
|format=table | |format=table | ||
}} | }} | ||
== | == Small Boxes == | ||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | |||
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | |||
|fields= | |||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | |||
CONCAT('{{((}}ExplodeColors{{!}}', GD.TileColors, '{{))}}')=Colors, | |||
GD.Weight, | |||
UnknownName=Unidentified Name, | |||
UnknownAltName=Partially-Identified Name, | |||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | |||
COALESCE(GD.Tier,'-')=Tier, | |||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownNameStripped = 'small box' OR WAD.UnknownNameStripped = 'small metal box') | |||
|order by=Colors ASC, Object ASC | |||
|format=table | |||
}} | |||
== Small Trinkets == | |||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | |||
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | |||
|fields= | |||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | |||
CONCAT('{{((}}ExplodeColors{{!}}', GD.TileColors, '{{))}}')=Colors, | |||
GD.Weight, | |||
UnknownName=Unidentified Name, | |||
UnknownAltName=Partially-Identified Name, | |||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | |||
COALESCE(GD.Tier,'-')=Tier, | |||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small trinket' | |||
|order by=Colors ASC, Object ASC | |||
|format=table | |||
}} | |||
== Small Stones == | |||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | |||
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | |||
|fields= | |||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | |||
CONCAT('{{((}}ExplodeColors{{!}}', GD.TileColors, '{{))}}')=Colors, | |||
GD.Weight, | |||
UnknownName=Unidentified Name, | |||
UnknownAltName=Partially-Identified Name, | |||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | |||
COALESCE(GD.Tier,'-')=Tier, | |||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped = 'small stone' | |||
|order by=Colors ASC, Object ASC | |||
|format=table | |||
}} | |||
== Weird Artifacts and More == | |||
Note that about a half-dozen items without a sprite in-game are missing from this table due to wiki limitations, such as the {{favilink|gaslight flyssa}} and other gaslight weapons. | Note that about a half-dozen items without a sprite in-game are missing from this table due to wiki limitations, such as the {{favilink|gaslight flyssa}} and other gaslight weapons. | ||
| Line 53: | Line 104: | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | IT.Complexity | ||
|where=WAD.UnknownImage IS NOT NULL AND WAD. | |where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownNameStripped <> 'strange tubes' AND WAD.UnknownAltNameStripped <> 'strange tubes' AND WAD.UnknownNameStripped <> 'strange plant' AND WAD.UnknownAltNameStripped <> 'strange plant' AND WAD.UnknownNameStripped <> 'small trinket' AND WAD.UnknownNameStripped <> 'small stone' AND WAD.UnknownNameStripped <> 'small box' AND WAD.UnknownNameStripped <> 'small metal box' | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||
|format=table | |format=table | ||
|limit=500 | |limit=500 | ||
}} | }} | ||
Revision as of 05:56, 18 December 2020
 |
Spoiler Warning: This article contains spoilers regarding objects that are normally a mystery until identified in game. Proceed at your own discretion. |
Spoiler Warning: This article contains spoilers regarding objects that are normally a mystery until identified in game. Proceed at your own discretion.
This page provides images and other aggregated information about unidentified artifacts.
Strange Tubes
Error: Table WeirdArtifactData not found.
Strange Plants
Error: Table WeirdArtifactData not found.
Small Boxes
Error: Table WeirdArtifactData not found.
Small Trinkets
Error: Table WeirdArtifactData not found.
Small Stones
Error: Table WeirdArtifactData not found.
Weird Artifacts and More
Note that about a half-dozen items without a sprite in-game are missing from this table due to wiki limitations, such as the 
gaslight flyssa and other gaslight weapons.
Most of those items have an unidentified tile that is identical to the 
Fix-It spray foam's unidentified tile, which you can see in the table below.
Error: Table WeirdArtifactData not found.