Unidentified artifacts: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
mNo edit summary
m (update to use new cargo ArtifactData table)
Line 6: Line 6:


== Strange Tubes ==
== Strange Tubes ==
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=(WAD.UnknownNameStripped = 'strange tubes' OR WAD.UnknownAltNameStripped = 'strange tubes') AND GD.Commerce IS NOT NULL
|where=(AD.UnidentifiedNameStripped = 'strange tubes' OR AD.UnidentifiedAltNameStripped = 'strange tubes') AND GD.Commerce IS NOT NULL
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table
Line 22: Line 22:


== Strange Plants ==  
== Strange Plants ==  
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=WAD.UnknownNameStripped = 'strange plant' OR WAD.UnknownAltNameStripped = 'strange plant'
|where=AD.UnidentifiedNameStripped = 'strange plant' OR AD.UnidentifiedAltNameStripped = 'strange plant'
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table
Line 38: Line 38:


== Small Boxes ==
== Small Boxes ==
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=WAD.UnknownNameStripped = 'small box' OR WAD.UnknownNameStripped = 'small metal box'
|where=AD.UnidentifiedNameStripped = 'small box' OR AD.UnidentifiedNameStripped = 'small metal box'
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table
Line 54: Line 54:


== Small Trinkets ==
== Small Trinkets ==
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=WAD.UnknownNameStripped = 'small trinket'
|where=AD.UnidentifiedNameStripped = 'small trinket'
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table
Line 70: Line 70:


== Small Stones ==
== Small Stones ==
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=WAD.UnknownNameStripped = 'small stone'
|where=AD.UnidentifiedNameStripped = 'small stone'
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table
Line 86: Line 86:


== Weird Artifacts and More ==
== Weird Artifacts and More ==
{{#cargo_query:tables=WeirdArtifactData=WAD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
|join on=WAD.JoinKey=GD.JoinKey,WAD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|fields=
|fields=
COALESCE(GD.Weight,'-')=Weight,
COALESCE(GD.Weight,'-')=Weight,
UnknownName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
UnknownAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',WAD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
IT.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=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' AND GD.Commerce IS NOT NULL
|where=AD.UnidentifiedNameStripped <> 'strange tubes' AND AD.UnidentifiedAltNameStripped <> 'strange tubes' AND AD.UnidentifiedNameStripped <> 'strange plant' AND AD.UnidentifiedAltNameStripped <> 'strange plant' AND AD.UnidentifiedNameStripped <> 'small trinket' AND AD.UnidentifiedNameStripped <> 'small stone' AND AD.UnidentifiedNameStripped <> 'small box' AND AD.UnidentifiedNameStripped <> 'small metal box' AND GD.Commerce IS NOT NULL
|order by=Identified Object ASC
|order by=Identified Object ASC
|format=table
|format=table

Revision as of 01:49, 7 October 2021

Spoiler 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 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 trading multiplier), and/or name. Some items, however, cannot be told apart until fully identified (e.g. giant hands and high-grade dermal insulation).

Note that items which do not normally require identification, such as bronze long sword, may require identification when modded. These kinds of items are not included on the page below. For example, a flaming bronze long sword will appear as an unidentified Modded bronze long sword unidentified.png weird artifact in game until identified.

Strange Tubes

Error: No field named "Complexity" found for the database table "ItemsTable".

Strange Plants

Error: No field named "Complexity" found for the database table "ItemsTable".

Small Boxes

Error: No field named "Complexity" found for the database table "ItemsTable".

Small Trinkets

Error: No field named "Complexity" found for the database table "ItemsTable".

Small Stones

Error: No field named "Complexity" found for the database table "ItemsTable".

Weird Artifacts and More

Error: No field named "Complexity" found for the database table "ItemsTable".
Retrieved from "https://wiki.cavesofqud.com/index.php?title=Unidentified_artifacts&oldid=56588"