Template:Usedin: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
No edit summary
imported>Kiokurashi
No edit summary
Line 1: Line 1:
<includeonly><!--
<includeonly><!--


## Anvil Section.
## Anvil, Stamps, and UsedinExtra Section.
-->{{#cargo_compound_query:
-->{{#cargo_compound_query:
tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source
tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source
Line 7: Line 7:
|tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source
|tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source
|tables=Stamps;where=Material="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source
|tables=UsedinExtraData;where=Item="{{{1|{{PAGENAME}}}}}";fields=CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source
|named args=yes
|named args=yes
|format=template
|format=template
Line 13: Line 15:
}}<!--
}}<!--


## Quests Section.
## 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=CONCAT("[[",_pageName,"#",QuestName,"|",QuestName,"]]")=Name, Requirements=Quantity, CONCAT("Quests")=Source
|where=(Requirements LIKE "%>{{{1|{{PAGENAME}}}}}<%") AND NOT (Requirements LIKE "%{{PAGENAME}} Tooth%"
|where=(Requirements LIKE "%>{{{1|{{PAGENAME}}}}}<%") <!--AND NOT (Requirements LIKE "%{{PAGENAME}} Tooth%"
OR Requirements LIKE "%Sticky {{PAGENAME}}%")
OR Requirements LIKE "%Sticky {{PAGENAME}}%") ## Testing, but I think this part isn't needed now. -->
|format=template
|format=template
|template=Usedin/questsrow
|template=Usedin/questsrow
|named args=yes
|default=
}}<!--
## Stamps Section.
-->{{#cargo_query:tables=Stamps
|fields=CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source
|where=Material="{{{1|{{PAGENAME}}}}}"
|format=template
|template=Usedin/row
|named args=yes
|default=
}}<!--
## Extra Data Section. (Things not in the above sections)
-->{{#cargo_query:tables=UsedinExtraData
|fields=CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source
|where=Item="{{{1|{{PAGENAME}}}}}"
|format=template
|template=Usedin/row
|named args=yes
|named args=yes
|default=
|default=
}}</includeonly>
}}</includeonly>

Revision as of 08:23, 10 November 2021