User:Kiokurashi/sandbox: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
No edit summary
imported>Kiokurashi
No edit summary
Line 1: Line 1:
Try: passing the Requirements to a separate table that is only for quests and will feed that into template (NumberNabber) with the additional secondary parameter of the pagename to shrink down the string and get the last number group via regex.
Example searching for "%Small%":
{{Usedin/head}}
{{#cargo_query:tables=Quests
|fields=QuestName=Name, Requirements=Quantity, CONCAT("Quests")=Source
|where=Requirements LIKE "%Small%"
|format=template
|template=Usedin
|named args=yes
|default=
}}
|}
{{NumberNabber|Small|Small}}




Line 30: Line 9:
{{#cargo_query:tables=AnvilCraft
{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
|where=Resource1 LIKE "Spore Cap"
|where=Resource1 LIKE "{{PAGENAME}}"
|format=template
|format=template
|template=Usedin
|template=Usedin/row
|named args=yes
|named args=yes
|default=
|default=
}}{{#cargo_query:tables=AnvilCraft
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity2=Quantity, CONCAT("Smithing")=Source
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity2=Quantity, CONCAT("Smithing")=Source
|where=Resource2 LIKE "Spore Cap"
|where=Resource2 LIKE "{{PAGENAME}}"
|format=template
|format=template
|template=Usedin
|template=Usedin/row
|named args=yes
|named args=yes
|default=
|default=
}}{{#cargo_query:tables=AnvilCraft
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source
|where=Resource3 LIKE "Spore Cap"
|where=Resource3 LIKE "{{PAGENAME}}"
|format=template
|format=template
|template=Usedin
|template=Usedin/row
|named args=yes
|named args=yes
|default=
|default=
}}{{#cargo_query:tables=AnvilCraft
}}{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
|where=Resource4 LIKE "Spore Cap"
|where=Resource4 LIKE "{{PAGENAME}}"
|format=template
|template=Usedin/row
|named args=yes
|default=
}}{{#cargo_query:tables=Quests
|fields=QuestName=Name, Requirements=Quantity, CONCAT("Quests")=Source
|where=Requirements LIKE "%{{PAGENAME}}%"
|format=template
|format=template
|template=Usedin
|template=Usedin/questrow
|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}}
}}
}}
|}
 
-->
-->
Used in items:
Used in items:


''Set numbers:''
''Set numbers:''
smithing points
<s>smithing points</s>
{| class="wikitable sortable mw-collapsible mw-collapsed"
 
|+Buy Points - Monster Drops
!Points!!Image!!Monster Drop!!Quantity
|-
|1-5||[[File:Spore_Cap.png|alt=|frameless]]||[[Spore Cap]]||38
|-
|6-15||[[File:Frog_Legs.png|alt=|frameless]]||[[Frog Leg]]||446
|-
|16-25||[[File:Bean_Slices.png|alt=|frameless]]||[[Bean Slices]]||1129
|-
|26-40||[[File:Slime_Sludge.png|alt=|frameless]]||[[Slime Sludge]]||3342
|-
|41-55||[[File:Carrot_Cube.png|alt=|frameless]]||[[Carrot Cube]]||5710
|-
|56-70||[[File:Goblin Ear.png|frameless]]||[[Goblin Ear]]||8443
|-
|71-85||[[File:Bullfrog Horn.png|frameless]]||[[Bullfrog Horn]]||11503
|-
|86-100||[[File:Pocket Sand.png|frameless]]||[[Pocket Sand]]||14844
|-
|101-115||[[File:Crabby Cakey.png|frameless]]||[[Crabby Cakey]]||18449
|-
|116-130||[[File:Coconotnotto.png|alt=|frameless]]||[[Coconotnotto]]||22309
|-
|131-150||[[File:Pincer Arm.png|frameless]]||[[Pincer Arm]]||36119
|-
|151-175||[[File:High Steaks.png|frameless]]||[[High Steaks]]||56115
|-
|176-200||[[File:Wakka_Cherry.png|alt=|frameless]]||[[Wakka Cherry]]||69153
|-
|201-225||[[File:Shrapshell.png|alt=|frameless]]||[[Shrapshell]]||83052
|}




''Lots:''
''Lots:''
post office, alchemy, stamps, refinery
<s>post office</s>, alchemy, refinery
<div class="mw-collapsible mw-collapsed">
<div class="mw-collapsible mw-collapsed">
     "Refinery1": [
     "Refinery1": [
Line 139: Line 115:


''Queried:''
''Queried:''
Quests, recipes
<s>Quests, recipes</s>, stamps (Queried & Lots)




Revision as of 20:19, 9 June 2021




Used in items:

Set numbers: smithing points


Lots: post office, alchemy, refinery 

   "Refinery1": [
       ["Grasslands1", "10"],
       ["Copper", "5"]
   ],
   "Refinery2": [
       ["Forest3", "10"],
       ["ForestTree", "5"],
       ["Refinery1", "2"]
   ],
   "Refinery3": [
       ["DesertA1", "50"],
       ["Fish1", "30"],
       ["Bug1", "40"],
       ["Refinery2", "3"]
   ],
   "Refinery4": [
       ["SnowA1", "10"],
       ["Soul2", "2"],
       ["Critter3", "1"],
       ["Refinery3", "1"]
   ],
   "Refinery5": [
       ["SnowB4", "25"],
       ["Fish4", "5"],
       ["Bug3", "5"],
       ["Critter4", "5"],
       ["Refinery4", "2"]
   ],
   "Refinery6": [
       ["SnowC4", "50"],
       ["VoidBar", "5"],
       ["Tree7", "5"],
       ["Bug6", "5"],
       ["Soul4", "5"],
       ["Refinery5", "3"]
   ]

Queried: Quests, recipes, stamps (Queried & Lots)





Retrieved from "https://idleon.wiki/wiki/index.php?title=User:Kiokurashi/sandbox&oldid=46401"