8,290
edits
Unidentified artifacts: Difference between revisions
Unidentified artifacts (view source)
Revision as of 05:56, 18 December 2020
, 05:56, 18 December 2020Additional categories
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 | ||
}} | }} | ||