Template:Usedin: Difference between revisions

From IdleOn MMO Wiki
mNo edit summary
mNo edit summary
Line 3: Line 3:
## Anvil, Stamps, and UsedinExtra Section.
## Anvil, Stamps, and UsedinExtra Section.
-->{{#cargo_compound_query:
-->{{#cargo_compound_query:
tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Item,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source
tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource2="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Item,"]]")=Name,Quantity2=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource2="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity2=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Item,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Item,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source
|tables=Stamps;where=Material="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source, Bonus=TooltipString
|tables=Stamps;where=Material="{{{1|{{PAGENAME}}}}}";fields=_pageName=Icon,CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source, Bonus=TooltipString
|tables=UsedinExtraData;where=Item="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source
|tables=UsedinExtraData;where=Item="{{{1|{{PAGENAME}}}}}";fields=Icon=Icon,CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source
|named args=yes
|named args=yes
|format=template
|format=template
Line 17: Line 17:
## Quests Section. Separate because needs different template.
## Quests Section. Separate because needs different template.
-->{{#cargo_query:tables=Quests
-->{{#cargo_query:tables=Quests
|fields=CONCAT("[[",_pageName,"#",QuestName,"|",QuestName,"]]")=Name, Requirements=Quantity, CONCAT("Quests")=Source
|fields=_pageName=Icon, CONCAT("[[",_pageName,"#",QuestName,"|",QuestName,"]]")=Name, Requirements=Quantity, CONCAT("Quests")=Source
|where=Requirements LIKE "%>{{{1|{{PAGENAME}}}}}<%"
|where=Requirements LIKE "%>{{{1|{{PAGENAME}}}}}<%"
|format=template
|format=template

Revision as of 01:07, 29 October 2023