Caves of Qud Wiki

Unidentified artifacts: Difference between revisions

Unidentified artifacts (view source)

Revision as of 19:46, 7 October 2021

658 bytes added ,  19:46, 7 October 2021
m
fix for missing image on desallination pellet
(Update to use new Cargo table + add unidentified images)
m (fix for missing image on desallination pellet)
Line 10: Line 10:
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
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' 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
|order by=Identified Object ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}
Line 27: Line 26:
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
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'
|order by=Identified Object ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}
Line 44: Line 42:
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
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 box' OR AD.UnidentifiedNameStripped = 'small metal box'
|order by=Identified Object ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}
Line 61: Line 58:
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
COALESCE(GD.Tier,'-')=Tier,
COALESCE(GD.Tier,'-')=Tier,
AD.Complexity,
AD.Complexity,
GD.Commerce=Trade Value
GD.Commerce=Trade Value
|where=AD.UnidentifiedNameStripped = 'small trinket'
|where=AD.UnidentifiedNameStripped = 'small trinket'
|order by=Identified Object ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}
Line 78: Line 74:
|fields=
|fields=
GD.Weight,
GD.Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ',AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
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 = 'small stone'
|order by=Identified Object ASC
|order by=Identified ASC
|format=table
|format=table
}}
}}
Line 95: Line 90:
|fields=
|fields=
COALESCE(GD.Weight,'-')=Weight,
COALESCE(GD.Weight,'-')=Weight,
AD.UnidentifiedName=Unidentified Name,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedName,'</strong>')=Unidentified,
CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px]]')=Img,
CONCAT('<strong>',CASE WHEN UnidentifiedImage IS NOT NULL THEN CONCAT('[[Image:',UnidentifiedImage,'{{!}}16px{{!}}link=]] ') ELSE '' END,AD.UnidentifiedAltName,'</strong>')=Partially-Identified,  
UnidentifiedAltName=Partially-Identified Name,  
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified,
CONCAT('{{((}}favilink page{{!}}',AD._pageName,'{{)}}')=Identified Object,
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 <> '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 ASC
|format=table
|format=table
|limit=500
|limit=500
Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/56628"