Unidentified artifacts: Difference between revisions
imported>Eels1900 this will probably come back to bite me but as of 2.0.201.88 all strange tubes are dark cyan |
rip small trinkets |
||
(12 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
{{Spoiler|objects that are normally a mystery until identified in game}} | {{Spoiler|objects that are normally a mystery until identified in game}} | ||
This page provides | This page provides aggregated information about complex artifacts that always require identification. It may be possible to narrow down which item an unidentified item is by using the item's weight, trade value (adjusting for the [[Commerce#Trading_Multiplier_Formula|trading multiplier]]), and/or name. Some items, however, cannot be told apart until fully identified (e.g. {{favilink|giant hands}} and {{favilink|high-grade dermal insulation}}). | ||
Note that items which do not normally require identification, such as {{qud text|&wbronze &ylong sword}}, may require identification when modded | Note that items which do not normally require identification, such as {{qud text|&wbronze &ylong sword}}, may require identification when modded. These kinds of items are not included on the page below. For example, a {{Qud shader|fiery|flaming}} {{qud text|&wbronze &ylong sword}} will appear as an unidentified [[File:Modded bronze long sword unidentified.png|25px]] {{Qud text|weird artifact}} in game until identified. | ||
== Strange Tubes == | == Strange Tubes == | ||
{{#cargo_query:tables= | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on= | |join on=AD.JoinKey=GD.JoinKey | ||
|fields= | |fields= | ||
COALESCE(GD.Weight,'-')=Weight, | |||
' | CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified, | ||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified, | |||
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified, | |||
CONCAT('[[ | |||
CONCAT('{{((}}favilink page{{!}}', | |||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
AD.Complexity, | |||
GD.Commerce=Trade Value | GD.Commerce=Trade Value | ||
|where= | |where=(AD.UnidentifiedNameStripped = 'strange tubes' OR AD.UnidentifiedAltNameStripped = 'strange tubes') AND GD.Commerce IS NOT NULL | ||
|order by= | |order by=Identified ASC | ||
|format=table | |format=table | ||
}} | }} | ||
== | == Strange Plants and Meats == | ||
{{#cargo_query:tables= | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on= | |join on=AD.JoinKey=GD.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[ | COALESCE(GD.Weight,'-')=Weight, | ||
CONCAT('{{ | CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified, | ||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified, | |||
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified, | |||
CONCAT('{{((}}favilink page{{!}}', | |||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
AD.Complexity, | |||
GD.Commerce=Trade Value | GD.Commerce=Trade Value | ||
|where= | |where=AD.UnidentifiedNameStripped = 'strange plant' OR AD.UnidentifiedAltNameStripped = 'strange plant' | ||
|order by= | OR AD.UnidentifiedNameStripped = 'strange piece of meat' OR AD.UnidentifiedAltNameStripped = 'strange piece of meat' | ||
|order by=Identified ASC | |||
|format=table | |format=table | ||
}} | }} | ||
== Small | == Small Tubes == | ||
{{#cargo_query:tables= | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on= | |join on=AD.JoinKey=GD.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[ | COALESCE(GD.Weight,'-')=Weight, | ||
CONCAT('{{ | CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified, | ||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified, | |||
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified, | |||
CONCAT('{{((}}favilink page{{!}}', | |||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
AD.Complexity, | |||
GD.Commerce=Trade Value | GD.Commerce=Trade Value | ||
|where= | |where=AD.UnidentifiedNameStripped = 'small tube' OR AD.UnidentifiedAltNameStripped = 'small tube' | ||
|order by= | OR AD.UnidentifiedNameStripped = 'small *color* tube' OR AD.UnidentifiedAltNameStripped = 'small *color* tube' | ||
|order by=Identified ASC | |||
|format=table | |format=table | ||
}} | }} | ||
== | == Odd Trinkets == | ||
{{#cargo_query:tables= | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on= | |join on=AD.JoinKey=GD.JoinKey | ||
|fields= | |fields= | ||
CONCAT('[[ | COALESCE(GD.Weight,'-')=Weight, | ||
CONCAT('{{ | CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified, | ||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified, | |||
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified, | |||
CONCAT('{{((}}favilink page{{!}}', | |||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
AD.Complexity, | |||
GD.Commerce=Trade Value | GD.Commerce=Trade Value | ||
|where= | |where=AD.UnidentifiedNameStripped = 'odd trinket' OR AD.UnidentifiedAltNameStripped = 'odd trinket' | ||
|order by= | |order by=Identified ASC | ||
|format=table | |format=table | ||
}} | }} | ||
== Weird Artifacts and More == | == Weird Artifacts and More == | ||
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | |||
|join on=AD.JoinKey=GD.JoinKey | |||
{{#cargo_query:tables= | |||
|join on= | |||
|fields= | |fields= | ||
COALESCE(GD.Weight,'-')=Weight, | COALESCE(GD.Weight,'-')=Weight, | ||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified, | |||
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified, | |||
CONCAT('{{((}}favilink page{{!}}', | CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified, | ||
COALESCE(GD.Tier,'-')=Tier, | COALESCE(GD.Tier,'-')=Tier, | ||
AD.Complexity, | |||
GD.Commerce=Trade Value | GD.Commerce=Trade Value | ||
|where= | |where=AD.UnidentifiedNameStripped <> 'strange tubes' AND AD.UnidentifiedAltNameStripped <> 'strange tubes' | ||
|order by= | AND AD.UnidentifiedNameStripped <> 'strange plant' AND AD.UnidentifiedAltNameStripped <> 'strange plant' | ||
AND AD.UnidentifiedNameStripped <> 'strange piece of meat' AND AD.UnidentifiedAltNameStripped <> 'strange piece of meat' | |||
AND AD.UnidentifiedNameStripped <> 'small tube' AND AD.UnidentifiedAltNameStripped <> 'small tube' | |||
AND AD.UnidentifiedNameStripped <> 'small *color* tube' AND AD.UnidentifiedAltNameStripped <> 'small *color* tube' | |||
AND AD.UnidentifiedNameStripped <> 'odd trinket' AND AD.UnidentifiedAltNameStripped <> 'odd trinket' | |||
AND GD.Commerce IS NOT NULL | |||
|order by=Identified ASC | |||
|format=table | |format=table | ||
|limit=500 | |limit=500 | ||
}} | }} | ||
{{Mechanics Navbox}} | |||
[[Category:Mechanics]] |