Template:Sources: Difference between revisions

From IdleOn MMO Wiki
No edit summary
No edit summary
Line 5: Line 5:
   |Item=String (mandatory)
   |Item=String (mandatory)
   |Sources=WikiText
   |Sources=WikiText
}}</noinclude><includeonly><div style="display: None">{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=AnvilCraft
}}</noinclude><includeonly><div style="display: None">{{#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}}}}}"
Line 11: Line 11:
|order by=_pageName ASC
|order by=_pageName ASC
|default=
|default=
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#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%"
Line 18: Line 18:
|order by=DropSourceEntity ASC
|order by=DropSourceEntity ASC
|default=
|default=
|intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=Quests
}}}}{{#vardefine:sources|{{#var:sources}}{{#cargo_query:tables=Quests
|fields=_pageName
|fields=_pageName
|where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%"
|where=Rewards HOLDS LIKE "%>{{{1|{{PAGENAME}}}}}<%"
Line 25: Line 25:
|group by=_pageName
|group by=_pageName
|default=
|default=
|intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#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}}}}}"
Line 32: Line 32:
|order by=Vendor
|order by=Vendor
|default=
|default=
|intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#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}}}}}"
Line 39: Line 39:
|order by=Source
|order by=Source
|default=
|default=
|intro={{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.||, }}
|intro={{#ifeq:{{#var:sources}}|, }}
}}}}{{#invoke:LuaVar|append|name=Sources|value={{#cargo_query:tables=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>")
|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 49: Line 49:


### Cargo Store ###
### Cargo Store ###
-->{{#ifeq:{{#invoke:LuaVar|var|name=Sources}}|Sources is undefined.|{{#invoke:LuaVar|varDefine|name=Sources|value={{{backup|Unobtainable}}}}}}}{{#vardefine:list|{{#invoke:LuaVar|var|name=Sources}}}}{{#cargo_store:_table=FullSourceLists
-->{{#cargo_store:_table=FullSourceLists
   |Item={{{1|{{PAGENAME}}}}}
   |Item={{{1|{{PAGENAME}}}}}
   |Sources={{#var:list}}
   |Sources={{#ifeq:{{#var:sources}}|{{#var:sources}}|{{{backup|Unobtainable}}}}}
  }}</div><includeonly>
  }}</div><includeonly>

Revision as of 16:38, 27 December 2022

This template defines the table "FullSourceLists". This table has not been created yet.