User:BHY4A/sandbox: Difference between revisions
From IdleOn MMO Wiki
mNo edit summary |
mNo edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_compound_query: | |||
tables=AnvilCraft;where=Resource1="Spore Cap";fields=CONCAT('{{CraftReq{{!}}',Item,'}}')=Name,Quantity1=Quantity, CONCAT("Smithing")=Source | |||
|tables=AnvilCraft;where=Resource2="Spore Cap";fields=CONCAT(",Item,")=Name,Quantity2=Quantity, CONCAT("Smithing")=Source | |||
|tables=AnvilCraft;where=Resource3="Spore Cap";fields=Item=Name,Quantity3=Quantity, CONCAT("Smithing")=Source | |||
|tables=AnvilCraft;where=Resource4="Spore Cap";fields=Item=Name,Quantity4=Quantity, CONCAT("Smithing")=Source | |||
|tables=Stamps;where=Material="{{{Spore Cap}}}";fields=CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source, Bonus=TooltipString | |||
|tables=UsedinExtraData;where=Item="{{{Spore Cap|{{PAGENAME}}}}}";fields=CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source | |||
|named args=yes | |||
|format=template | |||
|template=Usedin/row | |||
|default= | |||
}} | |||
<div class="mainpage-container"> | <div class="mainpage-container"> | ||
<div class="mainpage-box"> | <div class="mainpage-box"> |