Template:Sources: Difference between revisions
From IdleOn MMO Wiki
Kiokurashi (talk | contribs) No edit summary |
Kiokurashi (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#vardefine:sources|{{#cargo_query:tables=AnvilCraft | <includeonly>{{#vardefine:sources|{{#cargo_query:tables=AnvilCraft | ||
|fields=IF(RecipeFrom = "Start", CONCAT("\[\[Smithing\]\]"), CONCAT("[[Smithing]] (", RecipeFrom, ")")) | |fields=IF(RecipeFrom = "Start", CONCAT("\[\[Smithing\]\]"), CONCAT("\[\[Smithing\]\] (", RecipeFrom, ")")) | ||
|where=_pageName LIKE "{{{1|{{PAGENAME}}}}}" | |where=_pageName LIKE "{{{1|{{PAGENAME}}}}}" | ||
|format=list | |format=list | ||
| Line 6: | Line 6: | ||
|default= | |default= | ||
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=DropTables | }}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=DropTables | ||
|fields=CONCAT("[[", DropSourceEntity, "]]") | |fields=CONCAT("\[\[", DropSourceEntity, "\]\]") | ||
|where=DropItem="{{{1|{{PAGENAME}}}}}" AND NOT DropSourceEntity LIKE "%DropTable%" | |where=DropItem="{{{1|{{PAGENAME}}}}}" AND NOT DropSourceEntity LIKE "%DropTable%" | ||
|format=list | |format=list | ||
| Line 14: | Line 14: | ||
|intro={{#if:{{#var:sources}}|, }} | |intro={{#if:{{#var:sources}}|, }} | ||
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Quests | }}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Quests | ||
|fields=_pageName | |fields=CONCAT("\[\[", TRIM(_pageName), "\]\]") | ||
|where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%" | |where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%" | ||
|format=list | |format=list | ||
| Line 21: | Line 21: | ||
|intro={{#if:{{#var:sources}}|, }} | |intro={{#if:{{#var:sources}}|, }} | ||
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=VendorItems | }}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=VendorItems | ||
|fields=CONCAT("[[Vendors#", Vendor, "\{\{!\}\}", Vendor, "]]") | |fields=CONCAT("\[\[Vendors#", Vendor, "\{\{!\}\}", Vendor, "\]\]") | ||
|where=Item="{{{1|{{PAGENAME}}}}}" | |where=Item="{{{1|{{PAGENAME}}}}}" | ||
|format=list | |format=list | ||
| Line 28: | Line 28: | ||
|intro={{#if:{{#var:sources}}|, }} | |intro={{#if:{{#var:sources}}|, }} | ||
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Sources | }}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Sources | ||
|fields=CONCAT("[[", Link, "]]", IF(SpecialText = "None", "", CONCAT(" (", SpecialText, ")"))) | |fields=CONCAT("\[\[", Link, "\]\]", IF(SpecialText = "None", "", CONCAT(" (", SpecialText, ")"))) | ||
|where=Item="{{{1|{{PAGENAME}}}}}" | |where=Item="{{{1|{{PAGENAME}}}}}" | ||
|format=list | |format=list | ||
