|
|
| (46 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| <includeonly>{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=AnvilCraft
| | |
| |fields=IF(RecipeFrom = "Start", CONCAT("[[Smithing]]"), CONCAT("[[Smithing]] (", RecipeFrom, ")"))
| |
| |where=_pageName LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=list
| |
| |order by=_pageName ASC
| |
| |no html
| |
| |default=
| |
| }}}}{{#invoke:LuaVar|append|name=Sources|value={{#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
| |
| |no html
| |
| |default=
| |
| |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
| |
| }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Quests
| |
| |fields=_pageName
| |
| |where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%"
| |
| |format=list
| |
| |group by=_pageName
| |
| |no html
| |
| |default=
| |
| |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
| |
| }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=VendorItems
| |
| |fields=CONCAT("[[Vendors#", Vendor, "\{\{!\}\}", Vendor, "]]")
| |
| |where=Item="{{{1|{{PAGENAME}}}}}"
| |
| |format=list
| |
| |order by=Vendor
| |
| |no html
| |
| |default=
| |
| |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
| |
| }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Sources
| |
| |fields=CONCAT("[[", Link, "]]", IF(SpecialText = "None", "", CONCAT(" (", SpecialText, ")")))
| |
| |where=Item="{{{1|{{PAGENAME}}}}}"
| |
| |format=list
| |
| |order by=Source
| |
| |no html
| |
| |default=
| |
| |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
| |
| }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Sources
| |
| |fields=CONCAT("\n''", Item, " can be obtained from any enemy during its event.''")
| |
| |where=Item="{{{1|{{PAGENAME}}}}}" AND EventRules=1
| |
| |format=list
| |
| |group by=Item
| |
| |default=
| |
| |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
| |
| }}}}<includeonly>
| |
