8,290
edits
Unidentified artifacts: Difference between revisions
Unidentified artifacts (view source)
Revision as of 05:42, 18 December 2020
, 05:42, 18 December 2020no edit summary
(add weight and tier) |
No edit summary |
||
| Line 4: | Line 4: | ||
== Strange Tubes == | == Strange Tubes == | ||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD | {{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | ||
|join on=WAD.JoinKey=GD.JoinKey | |join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | ||
| Line 13: | Line 13: | ||
UnknownAltName=Partially-Identified Name, | UnknownAltName=Partially-Identified Name, | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | ||
GD.Tier | GD.Tier, | ||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownName = 'strange tubes' OR WAD.UnknownAltName = 'strange tubes') | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownName = 'strange tubes' OR WAD.UnknownAltName = 'strange tubes') | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||
| Line 20: | Line 21: | ||
== Strange Plants == | == Strange Plants == | ||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD | {{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | ||
|join on=WAD.JoinKey=GD.JoinKey | |join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | ||
| Line 29: | Line 30: | ||
UnknownAltName=Partially-Identified Name, | UnknownAltName=Partially-Identified Name, | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | ||
GD.Tier | GD.Tier, | ||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownName = 'strange plant' OR WAD.UnknownAltName = 'strange plant') | |where=WAD.UnknownImage IS NOT NULL AND (WAD.UnknownName = 'strange plant' OR WAD.UnknownAltName = 'strange plant') | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||
| Line 40: | Line 42: | ||
Most of those items have an unidentified tile that is identical to the {{favilink|Fix-It spray foam|possessive}} unidentified tile, which you can see in the table below. | Most of those items have an unidentified tile that is identical to the {{favilink|Fix-It spray foam|possessive}} unidentified tile, which you can see in the table below. | ||
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD | {{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT | ||
|join on=WAD.JoinKey=GD.JoinKey | |join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | CONCAT('[[File:',WAD.UnknownImage,'{{!}}25px]]')=Image, | ||
CONCAT('{{((}}ExplodeColors{{!}}', GD.TileColors, '{{))}}')=Colors, | CONCAT('{{((}}ExplodeColors{{!}}', GD.TileColors, '{{))}}')=Colors, | ||
GD.Weight, | COALESCE(GD.Weight,'-')=Weight, | ||
UnknownName=Unidentified Name, | UnknownName=Unidentified Name, | ||
UnknownAltName=Partially-Identified Name, | UnknownAltName=Partially-Identified Name, | ||
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Object, | ||
GD.Tier | COALESCE(GD.Tier,'-')=Tier, | ||
IT.Complexity | |||
|where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownName <> 'strange tubes' AND WAD.UnknownAltName <> 'strange tubes' AND WAD.UnknownName <> 'strange plant' AND WAD.UnknownAltName <> 'strange plant' | |where=WAD.UnknownImage IS NOT NULL AND WAD.UnknownName <> 'strange tubes' AND WAD.UnknownAltName <> 'strange tubes' AND WAD.UnknownName <> 'strange plant' AND WAD.UnknownAltName <> 'strange plant' | ||
|order by=Colors ASC, Object ASC | |order by=Colors ASC, Object ASC | ||