Caves of Qud Wiki

Unidentified artifacts: Difference between revisions

Unidentified artifacts (view source)

Revision as of 19:24, 7 October 2021

120 bytes added ,  19:24, 7 October 2021
Update to use new Cargo table + add unidentified images
m (update to use new cargo ArtifactData table)
(Update to use new Cargo table + add unidentified images)
Line 6: Line 6:


== Strange Tubes ==
== Strange Tubes ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=(AD.UnidentifiedNameStripped = 'strange tubes' OR AD.UnidentifiedAltNameStripped = 'strange tubes') AND GD.Commerce IS NOT NULL
|where=(AD.UnidentifiedNameStripped = 'strange tubes' OR AD.UnidentifiedAltNameStripped = 'strange tubes') AND GD.Commerce IS NOT NULL
Line 22: Line 23:


== Strange Plants ==  
== Strange Plants ==  
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'strange plant' OR AD.UnidentifiedAltNameStripped = 'strange plant'
|where=AD.UnidentifiedNameStripped = 'strange plant' OR AD.UnidentifiedAltNameStripped = 'strange plant'
Line 38: Line 40:


== Small Boxes ==
== Small Boxes ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small box' OR AD.UnidentifiedNameStripped = 'small metal box'
|where=AD.UnidentifiedNameStripped = 'small box' OR AD.UnidentifiedNameStripped = 'small metal box'
Line 54: Line 57:


== Small Trinkets ==
== Small Trinkets ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small trinket'
|where=AD.UnidentifiedNameStripped = 'small trinket'
Line 70: Line 74:


== Small Stones ==
== Small Stones ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small stone'
|where=AD.UnidentifiedNameStripped = 'small stone'
Line 86: Line 91:


== Weird Artifacts and More ==
== Weird Artifacts and More ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD,ItemsTable=IT
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey,AD.JoinKey=IT.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
COALESCE(GD.Weight,'-')=Weight,
COALESCE(GD.Weight,'-')=Weight,
AD.UnidentifiedName=Unidentified Name,
AD.UnidentifiedName=Unidentified Name,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
UnidentifiedAltName=Partially-Identified Name,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
IT.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|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
|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
Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/56623"