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>{{#cargo_query:tables=AnvilCraft | <includeonly>{{#invoke:LuaVar|append|name=Sources|value={{#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}}}}}" | ||
| Line 5: | Line 5: | ||
|order by=_pageName ASC | |order by=_pageName ASC | ||
|default= | |default= | ||
}}{{#cargo_query:tables=DropTables | }}}}{{#invoke:LuaVar|append|name=Sources|value={{#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%" | ||
| Line 12: | Line 12: | ||
|order by=DropSourceEntity ASC | |order by=DropSourceEntity ASC | ||
|default= | |default= | ||
}}{{#cargo_query:tables=Quests | |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }} | ||
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Quests | |||
|fields=_pageName | |fields=_pageName | ||
|where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%" | |where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%" | ||
| Line 18: | Line 19: | ||
|group by=_pageName | |group by=_pageName | ||
|default= | |default= | ||
|intro= | |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }} | ||
}}{{#cargo_query:tables=VendorItems | }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=VendorItems | ||
|fields=CONCAT("[[Vendors#", Vendor, "\{\{!\}\}", Vendor, "]]") | |fields=CONCAT("[[Vendors#", Vendor, "\{\{!\}\}", Vendor, "]]") | ||
|where=Item="{{{1|{{PAGENAME}}}}}" | |where=Item="{{{1|{{PAGENAME}}}}}" | ||
| Line 25: | Line 26: | ||
|order by=Vendor | |order by=Vendor | ||
|default= | |default= | ||
|intro= | |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }} | ||
}}{{#cargo_query:tables=Sources | }}}}{{#invoke:LuaVar|append|name=Sources|value={{#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}}}}}" | ||
| Line 32: | Line 33: | ||
|order by=Source | |order by=Source | ||
|default= | |default= | ||
|intro= | |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }} | ||
}}{{#cargo_query:tables=Sources | }}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Sources | ||
|fields=CONCAT("<br/><sup><i>", Item, " can be obtained from any enemy during its event.</i></sup>") | |fields=CONCAT("<br/><sup><i>", Item, " can be obtained from any enemy during its event.</i></sup>") | ||
|where=Item="{{{1|{{PAGENAME}}}}}" AND EventRules=1 | |where=Item="{{{1|{{PAGENAME}}}}}" AND EventRules=1 | ||
| Line 39: | Line 40: | ||
|group by=Item | |group by=Item | ||
|default= | |default= | ||
}}<includeonly> | |intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }} | ||
}}}}{{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||{{#invoke:LuaVar|var|name=Sources}}}}<includeonly> | |||
