User:Ttobas/sandbox/SourcesTemplate: Difference between revisions

From IdleOn MMO Wiki
(Created page with "<includeonly><div style="display: None">{{#vardefine:sources|{{#cargo_query:tables=AnvilCraft |fields=IF(RecipeFrom = "Start", CONCAT("Smithing"), CONCAT("Smithing (", RecipeFrom, ")")) |where=_pageName LIKE "{{{1|{{PAGENAME}}}}}" |format=list |order by=_pageName ASC |default= }}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=DropTables |fields=CONCAT("", DropSourceEntity, "") |where=DropItem="{{{1|{{PAGENAME}}}}}" AND NOT DropSourceEntity LIKE "...")
 
(Blanked the page)
Tag: Blanking
 
Line 1: Line 1:
<includeonly><div style="display: None">{{#vardefine:sources|{{#cargo_query:tables=AnvilCraft
 
|fields=IF(RecipeFrom = "Start", CONCAT("[[Smithing]]"), CONCAT("[[Smithing]] (", RecipeFrom, ")"))
|where=_pageName LIKE "{{{1|{{PAGENAME}}}}}"
|format=list
|order by=_pageName ASC
|default=
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=DropTables
|fields=CONCAT("[[", DropSourceEntity, "]]")
|where=DropItem="{{{1|{{PAGENAME}}}}}" AND NOT DropSourceEntity LIKE "%DropTable%"
|format=list
|group by=DropSourceEntity
|order by=DropSourceEntity ASC
|default=
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Quests
|fields=_pageName
|where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%"
|format=list
|group by=_pageName
|default=
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=VendorItems
|fields=CONCAT("[[Vendors#", Vendor, "\{\{!\}\}", Vendor, "]]")
|where=Item="{{{1|{{PAGENAME}}}}}"
|format=list
|order by=Vendor
|default=
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Sources
|fields=CONCAT("[[", Link, "]]", IF(SpecialText = "None", "", CONCAT(" (", SpecialText, ")")))
|where=Item="{{{1|{{PAGENAME}}}}}"
|format=list
|order by=Source
|default=
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Sources
|fields=CONCAT("<br/><sup><i>", Item, " can be obtained from any enemy during its event.</i></sup>")
|where=Item="{{{1|{{PAGENAME}}}}}" AND EventRules=1
|format=list
|group by=Item
|default=
}}}}</div>{{#if:{{#var:sources}}|{{#var:sources}}|{{{backup|Unobtainable}}}}}<includeonly>

Latest revision as of 04:14, 28 December 2022