8,290
edits
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 | {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
|join on=AD.JoinKey=GD | |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, | ||
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 |