User:Kiokurashi/sandbox: Difference between revisions
From IdleOn MMO Wiki
imported>Kiokurashi No edit summary |
imported>Kiokurashi No edit summary |
||
Line 1: | Line 1: | ||
{{Usedin/head}} | {{Usedin/head}} | ||
{{#cargo_query:tables=AnvilCraft | {{#cargo_query:tables=AnvilCraft | ||
|fields=_pageName= | |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source | ||
|where=Resource1 LIKE " | |where=Resource1 LIKE "Spore Cap" | ||
|format=template | |||
|template=Row | |||
|named args=yes | |||
|default= | |||
}}{{#cargo_query:tables=AnvilCraft | |||
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity2=Quantity, CONCAT("Smithing")=Source | |||
|where=Resource2 LIKE "Spore Cap" | |||
|format=template | |||
|template=Row | |||
|named args=yes | |||
|default= | |||
}}{{#cargo_query:tables=AnvilCraft | |||
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity3=Quantity, CONCAT("Smithing")=Source | |||
|where=Resource3 LIKE "Spore Cap" | |||
|format=template | |||
|template=Row | |||
|named args=yes | |||
|default= | |||
}}{{#cargo_query:tables=AnvilCraft | |||
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source | |||
|where=Resource4 LIKE "Spore Cap" | |||
|format=template | |format=template | ||
|template=Row | |template=Row | ||
Line 10: | Line 31: | ||
|} | |} | ||
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. | |||
{{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= | |||
}} | |||
|} | |||
Revision as of 08:34, 9 June 2021
|}
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. Template:Usedin/head
|}
Used in items:
Set numbers: smithing points
Points | Image | Monster Drop | Quantity |
---|---|---|---|
1-5 | Spore Cap | 38 | |
6-15 | Frog Leg | 446 | |
16-25 | Bean Slices | 1129 | |
26-40 | Slime Sludge | 3342 | |
41-55 | Carrot Cube | 5710 | |
56-70 | Goblin Ear | 8443 | |
71-85 | Bullfrog Horn | 11503 | |
86-100 | Pocket Sand | 14844 | |
101-115 | Crabby Cakey | 18449 | |
116-130 | Coconotnotto | 22309 | |
131-150 | Pincer Arm | 36119 | |
151-175 | High Steaks | 56115 | |
176-200 | Wakka Cherry | 69153 | |
201-225 | Shrapshell | 83052 |
Lots:
post office, alchemy, stamps, 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