imported>Kiokurashi |
|
| (48 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 LIKE "{{{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 LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=template
| |
| |template=Usedin/row
| |
| |named args=yes
| |
| |default=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource3 LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=template | | |format=template |
| | |
| |template=Usedin/row | | |template=Usedin/row |
| |named args=yes
| |
| |default=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource4 LIKE "{{{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 Requirements NOT LIKE "%{{{1|{{PAGENAME}}}}} Crafted%" | | |where=Requirements LIKE "%>{{{1|{{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 LIKE "%{{{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 LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=template
| |
| |template=Usedin/row
| |
| |named args=yes
| |
| |default=
| |
| }}<!--
| |
| | |
| ## Alchemy Section.
| |
| -->{{#switch:{{{1|{{PAGENAME}}}}}
| |
| |Copper Ore|Oak Logs|Spore Cap|Thread|Copper Bar|Bean Slices|Trusty Nails|Snake Skin|Jungle Logs|Iron Bar|Goblin Ear|Potty Rolls|Gold Ore|Bullfrog Horn|Goldfish|Fly|Hermit Can|Megalodon Tooth|Rats Tail|Platinum Ore|BobJoePickle|Floof Ploof|Forest Soul|Crabbo|Void Ore|Redox Salts|Mosquisnow|Tundra Logs|Poison Froge|Mamooth Tusk|Dune Soul|Mousey|Pen|Explosive Salts|Snow Ball|Frigid Soul|Sippy Straw|Bunny|Contact Lense|Cryo Soul|Honker={{Usedin/row|[[Alchemy#Vials|Alchemy]]|Lots|Alchemy Vials}}|#default=}}{{#switch:{{{1|{{PAGENAME}}}}}
| |
| |Bean Slices|Bleach Logs|Bloach|Boring Brick|Butterfly|Carrot Cube|Chain Link|Coconotnotto|Copper Bar|Copper Ore|Crabbo|Crabby Cakey|Dementia Ore|Dune Soul|Explosive Salts|Fly|Flycicle|Forest Fibres|Forest Soul|Frigid Soul|Frog Leg|Froge|Fruitfly|Furled Flag|Goblin Ear|Gold Bar|Gold Ore|Goldfish|Hermit Can|High Steaks|Iron Bar|Iron Ore|Jellyfish|Jungle Logs|Leather Hide|Liquid Nitrogen|Materials|Megalodon Tooth|Melty Cube|Mosquisnow|Mousey|Moustache Comb|Oak Logs|Owlio|Pingy|Pinion Spur|Plank|Platinum Bar|Platinum Ore|Pocket Sand|Potty Rolls|Redox Salts|Rooted Soul|Scorpie|Sentient Cereal|Shrapshell|Singlecle|Sippy Straw|Slime Sludge|Snake Skin|Spore Cap|Thread|Tropilogs|Trusty Nails|Tundra Logs|Veiny Logs|Wakka Cherry|Water Droplets|Wispy Lumber={{Usedin/row|[[Alchemy#Cauldrons|Alchemy]]|Lots|Alchemy Bubbles}}
| |
| |#default=}}</includeonly>
| |
