Caves of Qud Wiki

Unidentified artifacts: Difference between revisions

← Older edit
Pokedragonboy (talk | contribs)
1,622 edits
m Qud text-ified the "weird artifact
rip small trinkets
 
Line 9: Line 9:
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
COALESCE(GD.Weight,'-')=Weight,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
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{{!}}',AD._pageName,'{{)}}')=Identified,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
Line 21: Line 21:
}}
}}


== Strange Plants ==  
== Strange Plants and Meats ==  
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
COALESCE(GD.Weight,'-')=Weight,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
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{{!}}',AD._pageName,'{{)}}')=Identified,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
AD.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'
OR AD.UnidentifiedNameStripped = 'strange piece of meat' OR AD.UnidentifiedAltNameStripped = 'strange piece of meat'
|order by=Identified ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}


== Small Boxes ==
== Small Tubes ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
COALESCE(GD.Weight,'-')=Weight,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
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{{!}}',AD._pageName,'{{)}}')=Identified,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
AD.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 tube' OR AD.UnidentifiedAltNameStripped = 'small tube'
OR AD.UnidentifiedNameStripped = 'small *color* tube' OR AD.UnidentifiedAltNameStripped = 'small *color* tube'
|order by=Identified ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}


== Small Trinkets ==
== Odd Trinkets ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=
|fields=
GD.Weight,
COALESCE(GD.Weight,'-')=Weight,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,
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,
COALESCE(GD.Tier,'-')=Tier,
AD.Complexity,
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small trinket'
|order by=Identified ASC
|format=table
}}
 
== Small Stones ==
{{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|fields=
GD.Weight,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
AD.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small stone'
|where=AD.UnidentifiedNameStripped = 'odd trinket' OR AD.UnidentifiedAltNameStripped = 'odd trinket'
|order by=Identified ASC
|order by=Identified ASC
|format=table
|format=table
Line 91: Line 77:
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.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('<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{{!}}',AD._pageName,'{{)}}')=Identified,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
AD.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 <> '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
|order by=Identified ASC
|format=table
|format=table
Retrieved from "https://wiki.cavesofqud.com/wiki/Unidentified_artifacts"