Template:Usedin: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
No edit summary
mNo edit summary
 
(30 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly><!--
<includeonly>{{#invoke:Usedin|main|{{{1|{{PAGENAME}}}}}}}</includeonly>
<!-- OLD METHOD FOR BACKUP


## Anvil Section.
## Anvil, Stamps, and UsedinExtra Section.
-->{{#cargo_query:tables=AnvilCraft
{{#cargo_compound_query:
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source
|where=Resource1="{{{1|{{PAGENAME}}}}}"
|tables=AnvilCraft;where=Resource2="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity2=Quantity, CONCAT("Smithing")=Source
|format=template
|tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source
|template=Usedin/row
|tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source
|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=Icon=Icon,CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source;order by=Source ASC
|named args=yes
|named args=yes
|default=
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity2=Quantity, CONCAT("Smithing")=Source
|where=Resource2="{{{1|{{PAGENAME}}}}}"
|format=template
|format=template
|template=Usedin/row
|template=Usedin/row
|named args=yes
|default=
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source
|where=Resource3="{{{1|{{PAGENAME}}}}}"
|format=template
|template=Usedin/row
|named args=yes
|default=
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
|where=Resource4="{{{1|{{PAGENAME}}}}}"
|format=template
|template=Usedin/row
|named args=yes
|default=
|default=
}}<!--
}}<!--


## 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=_pageName=Icon, 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}}}}}<%"
OR Requirements LIKE "%Sticky {{PAGENAME}}%")
|format=template
|format=template
|template=Usedin/questsrow
|template=Usedin/questsrow
|named args=yes
|named args=yes
|default=
|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
|default=
}}</includeonly>

Latest revision as of 02:19, 15 March 2024


Retrieved from "https://idleon.wiki/wiki/index.php?title=Template:Usedin&oldid=75052"