imported>Kiokurashi |
|
(94 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
| <includeonly>{{#cargo_query:tables=AnvilCraft | | <includeonly>{{#invoke:Usedin|main|{{{1|{{PAGENAME}}}}}}}</includeonly> |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source | | <!-- OLD METHOD FOR BACKUP |
| |where=Resource1 LIKE "{{PAGENAME}}" | | |
| |format=template
| | ## Anvil, Stamps, and UsedinExtra Section. |
| |template=Usedin/row | | {{#cargo_compound_query: |
| |named args=yes
| | tables=AnvilCraft;where=Resource1="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity1=Quantity, CONCAT("Smithing")=Source |
| |default=
| | |tables=AnvilCraft;where=Resource2="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity2=Quantity, CONCAT("Smithing")=Source |
| }}{{#cargo_query:tables=AnvilCraft
| | |tables=AnvilCraft;where=Resource3="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity3=Quantity, CONCAT("Smithing")=Source |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity2=Quantity, CONCAT("Smithing")=Source | | |tables=AnvilCraft;where=Resource4="{{{1|{{PAGENAME}}}}}";fields=Item=Icon,CONCAT("[[",Item,"]]")=Name,Quantity4=Quantity, CONCAT("Smithing")=Source |
| |where=Resource2 LIKE "{{PAGENAME}}" | | |tables=Stamps;where=Material="{{{1|{{PAGENAME}}}}}";fields=_pageName=Icon,CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source, Bonus=TooltipString |
| |format=template
| | |tables=UsedinExtraData;where=Item="{{{1|{{PAGENAME}}}}}";fields=Icon=Icon,CONCAT("[[",Source,"]]")=Name, Amount=Quantity, Type=Source;order by=Source ASC |
| |template=Usedin/row | |
| |named args=yes
| |
| |default=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source | |
| |where=Resource3 LIKE "{{PAGENAME}}" | |
| |format=template
| |
| |template=Usedin/row
| |
| |named args=yes | | |named args=yes |
| |default=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource4 LIKE "{{PAGENAME}}"
| |
| |format=template | | |format=template |
| | |
| |template=Usedin/row | | |template=Usedin/row |
| |named args=yes
| |
| |default=
| |
| }}{{#cargo_query:tables=Quests
| |
| |fields=CONCAT("[[",_pageName,"#",QuestName,"|",QuestName,"]]")=Name, Requirements=Quantity, CONCAT("Quests")=Source
| |
| |where=Requirements LIKE "%{{PAGENAME}}%"
| |
| |format=template
| |
| |template=Usedin/questrow
| |
| |named args=yes
| |
| |default= | | |default= |
| }}{{#cargo_query:tables=Stamps | | }}<!-- |
| |fields=CONCAT("[[",_pageName,"]]")=Name, CONCAT("Lots")=Quantity, CONCAT("Stamps")=Source | | |
| |where=Material LIKE "%{{PAGENAME}}%" | | ## Quests Section. Separate because needs different template. |
| | {{#cargo_query:tables=Quests |
| | |fields=_pageName=Icon, CONCAT("[[",_pageName,"#",QuestName,"|",QuestName,"]]")=Name, Requirements=Quantity, CONCAT("Quests")=Source |
| | |where=Requirements LIKE "%>{{{1|{{PAGENAME}}}}}<%" |
| |format=template | | |format=template |
| |template=Usedin/row | | |template=Usedin/questsrow |
| |named args=yes | | |named args=yes |
| |default= | | |default= |
| }}{{#switch:{{PAGENAME}}
| | }} |
| |Spore Cap={{Usedin/row|[[Smithing#Produce|Smithing Points]]|38|Smithing Points (per character)}}
| | --> |
| |Frog Leg={{Usedin/row|[[Smithing#Produce|Smithing Points]]|446|Smithing Points (per character)}}
| |
| |Bean Slices={{Usedin/row|[[Smithing#Produce|Smithing Points]]|1129|Smithing Points (per character)}}
| |
| |Slime Sludge={{Usedin/row|[[Smithing#Produce|Smithing Points]]|3342|Smithing Points (per character)}}
| |
| |Carrot Cube={{Usedin/row|[[Smithing#Produce|Smithing Points]]|5710|Smithing Points (per character)}}
| |
| |Goblin Ear={{Usedin/row|[[Smithing#Produce|Smithing Points]]|8443|Smithing Points (per character)}}
| |
| |Bullfrog Horn={{Usedin/row|[[Smithing#Produce|Smithing Points]]|11503|Smithing Points (per character)}}
| |
| |Pocket Sand={{Usedin/row|[[Smithing#Produce|Smithing Points]]|14844|Smithing Points (per character)}}
| |
| |Crabby Cakey={{Usedin/row|[[Smithing#Produce|Smithing Points]]|18449|Smithing Points (per character)}}
| |
| |Coconotnotto={{Usedin/row|[[Smithing#Produce|Smithing Points]]|22309|Smithing Points (per character)}}
| |
| |Pincer Arm={{Usedin/row|[[Smithing#Produce|Smithing Points]]|36119|Smithing Points (per character)}}
| |
| |High Steaks={{Usedin/row|[[Smithing#Produce|Smithing Points]]|56115|Smithing Points (per character)}}
| |
| |Wakka Cherry={{Usedin/row|[[Smithing#Produce|Smithing Points]]|69153|Smithing Points (per character)}}
| |
| |Shrapshell={{Usedin/row|[[Smithing#Produce|Smithing Points]]|83052|Smithing Points (per character)}}
| |
| }}{{#switch:{{PAGENAME}}
| |
| |Copper Ore|Iron Ore|Copper Bar|Oak Logs|Bleach Logs|Jungle Logs|Goldfish|Fly|Hermit Can|Butterfly|Iron Bar|Thread|Trusty Nails|Gold Ore|Gold Bar|Potty Rolls|Jellyfish|Sentient Cereal|Boring Brick|Tropilogs|Bloach|Veiny Logs|Fruitfly={{Usedin/row|[[Post Office#Simple Shippin|Simple Shippin]]|Lots|Post Office}}
| |
| }}{{#switch:{{PAGENAME}}
| |
| |Farmer Brim|Wooden Spear|Flip Flops|Copper Boots|Iron Boots|Leather Cap|Copper Platebody|Top Hat|Blue Tee|Birch Longbow|Iron Pickaxe|Iron Helmet|Gold Helmet|Bandage Wraps|Starlight|Royal Bayonet|Iron Hatchet|Green Tee|Gold Boots|Copper Band|Carrot Launcher|Black Tee|Spiked Menace|Gold Fishing Rod|Gilded Net|Pharoah Bow|Plat Fishing Rod|Platinum Shins|Plat Hatchet|Platinum Pickaxe|Fuscismatia|Platinum Boots={{Usedin/row|[[Post Office#Plan-It Express|Plan-It Express]]|Lots|Post Office}}
| |
| }}{{#switch:{{PAGENAME}}
| |
| |Spore Cap|Frog Leg|Bean Slices|Slime Sludge|Snake Skin|Carrot Cube|Goblin Ear|Plank|Bullfrog Horn|Pocket Sand|Corn Kernels|Megalodon Tooth|Stick|Crabby Cakey|Rats Tail|Acorn|Amarok Slab|Coconotnotto|Furled Flag|Pincer Arm|Potato Remains|High Steaks|Wakka Cherry|Singlecle|Shrapshell={{Usedin/row|[[Post Office#Dudes Next Door|Dudes Next Door]]|Lots|Post Office}}
| |
| }}{{#switch:{{PAGENAME}}
| |
| |Spore Cap|Copper Ore={{Usedin/row|[[Construction#Refinery]]|Lots|Redox Salts Refinery}}
| |
| |Bullfrong Horn|Forest Fibres|Redox Salts={{Usedin/row|[[Construction#Refinery]]|Lots|Explosive Salts Refinery}}
| |
| |Pocket Sand|Goldfish|Fly|Explosive Salts={{Usedin/row|[[Construction#Refinery]]|Lots|Spontaneity SaltsRefinery}}
| |
| |Floof Ploof|Dune Soul|Scorpie|Spontaneity Salts={{Usedin/row|[[Construction#Refinery]]|Lots|Dioxide Synthesis Refinery}}
| |
| |Cracked Glass|Bloach|Sentient Cereal|Mousey|Dioxide Synthesis={{Usedin/row|[[Construction#Refinery]]|Lots|??? Refinery}}
| |
| |Contact Lense|Void Bar|Wispy Lumber|Flycycle|Frigid Soul|Red Salt={{Usedin/row|[[Construction#Refinery]]|Lots|??? Refinery}}
| |
| }}{{#switch:{{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]]|Lots|Alchemy Vials}}
| |
| }}{{#switch:{{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]]|Lots|Alchemy Bubbles}}
| |
| }}</includeonly>
| |