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. | |||
{{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= | |||
}} | |||
|} | |||
<!-- | |||
{{Usedin/head}} | {{Usedin/head}} | ||
{{#cargo_query:tables=AnvilCraft | {{#cargo_query:tables=AnvilCraft | ||
Line 4: | Line 31: | ||
|where=Resource1 LIKE "Spore Cap" | |where=Resource1 LIKE "Spore Cap" | ||
|format=template | |format=template | ||
|template= | |template=Usedin | ||
|named args=yes | |named args=yes | ||
|default= | |default= | ||
Line 11: | Line 38: | ||
|where=Resource2 LIKE "Spore Cap" | |where=Resource2 LIKE "Spore Cap" | ||
|format=template | |format=template | ||
|template= | |template=Usedin | ||
|named args=yes | |named args=yes | ||
|default= | |default= | ||
Line 18: | Line 45: | ||
|where=Resource3 LIKE "Spore Cap" | |where=Resource3 LIKE "Spore Cap" | ||
|format=template | |format=template | ||
|template= | |template=Usedin | ||
|named args=yes | |named args=yes | ||
|default= | |default= | ||
Line 24: | Line 51: | ||
|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 "Spore Cap" | ||
|format=template | |format=template | ||
|template=Usedin | |template=Usedin | ||
Line 42: | Line 57: | ||
}} | }} | ||
|} | |} | ||
--> | |||
Used in items: | Used in items: | ||
Revision as of 08:35, 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.
|}
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