Caves of Qud Wiki

Unidentified artifacts: Difference between revisions

Unidentified artifacts (view source)

Revision as of 01:49, 7 October 2021

88 bytes added ,  01:49, 7 October 2021
m
update to use new cargo ArtifactData table
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
Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/56588"