imported>Kiokurashi |
|
(60 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=
| |
| |outro=
| |
| }}{{#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=
| |
| |outro=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource3 LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=template
| |
| |template=Usedin/row
| |
| |named args=yes
| |
| |default=
| |
| |outro=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource4 LIKE "{{{1|{{PAGENAME}}}}}"
| |
| |format=template | | |format=template |
| | |
| |template=Usedin/row | | |template=Usedin/row |
| |named args=yes
| |
| |default= | | |default= |
| |outro=
| |
| }}<!-- | | }}<!-- |
|
| |
|
| ## 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}}}}}%" | | |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=
| |
| }}<!--
| |
| | |
| ## Smithing Points Section. -->
| |
| {{#switch:{{{1|{{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)}}}}<!--
| |
| | |
| ## Post Office Section. -->
| |
| {{#switch:{{{1|{{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:{{{1|{{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:{{{1|{{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}} }}<!--
| |
| | |
| ## Refinery Section. -->
| |
| {{#switch:{{{1|{{PAGENAME}}}}}
| |
| |Spore Cap|Copper Ore={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|Redox Salts Refinery}}
| |
| |Bullfrong Horn|Forest Fibres|Redox Salts={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|Explosive Salts Refinery}}
| |
| |Pocket Sand|Goldfish|Fly|Explosive Salts={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|Spontaneity SaltsRefinery}}
| |
| |Floof Ploof|Dune Soul|Scorpie|Spontaneity Salts={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|Dioxide Synthesis Refinery}}
| |
| |Cracked Glass|Bloach|Sentient Cereal|Mousey|Dioxide Synthesis={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|??? Refinery}}
| |
| |Contact Lense|Void Bar|Wispy Lumber|Flycycle|Frigid Soul|Red Salt={{Usedin/row|[[Construction#Refinery|Refining]]|Lots|??? Refinery}} }}<!--
| |
| | |
| ## 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}} }}
| |
| {{#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}} }}</includeonly>
| |