imported>Kiokurashi |
|
| (266 intermediate revisions by 3 users not shown) |
| 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.
| | <time class="countdown-timer" data-mode="labeled" data-timestamp="1717045200"></time> |
| | |
| 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}}
| |
| | |
|
| |
|
| | {{#invoke:RecipeDetails/Pull|Main|Item=Diabolical Headcase}} |
|
| |
|
| | <!-- |
| | {{#invoke:RecipeDetails|Builder|Item=Diabolical Headcase}} |
| | {{#invoke:RecipeDetails|Main|Item=Diabolical Headcase}} |
|
| |
|
| | {{detrecipe/tab |
| | |reci= |
| | {{detrecipe|3|Lustre Veil|1}} |
| | {{detrecipe|40|Void Imperium Helmet|1}} |
| | {{detrecipe|80|Dementia Helmet|1}} |
| | {{detrecipe|120|Froge|5000}} |
| | {{detrecipe|120|Dementia Bar|300}} |
| | {{detrecipe|80|Spontaneity Salts|500}} |
| | {{detrecipe|80|Void Bar|1000}} |
| | {{detrecipe|80|Dense Water|5}} |
| | {{detrecipe|40|Skelefish|80000}} |
| | {{detrecipe|40|Lustre Bar|2500}} |
| | {{detrecipe|3|Blobfish|600000}} |
| | {{detrecipe|3|Starfire Bar|10000}} |
| | {{detrecipe|3|Nullo Salt|800}} |
| | |tot= |
| | {{detrecipe/totals|Blobfish|600000}} |
| | {{detrecipe/totals|Starfire Bar|10000}} |
| | {{detrecipe/totals|Nullo Salt|800}} |
| | {{detrecipe/totals|Skelefish|80000}} |
| | {{detrecipe/totals|Lustre Bar|2500}} |
| | {{detrecipe/totals|Spontaneity Salts|500}} |
| | {{detrecipe/totals|Void Bar|1000}} |
| | {{detrecipe/totals|Dense Water|5}} |
| | {{detrecipe/totals|Froge|5000}} |
| | {{detrecipe/totals|Dementia Bar|300}} |
| | }} |
|
| |
|
| | | <!--Old |
| | | == Unobtainables == |
| | | {{#cargo_query:tables=ItemSources |
| | | |fields=CONCAT('[[', Item, ']]')=Item |
| | | |where=SourcesList LIKE "%Unobtainable%" |
| | | |format=ol |
| <!-- | | |columns=4 |
| {{Usedin/head}}
| | |limit=5000 |
| {{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource1 LIKE "Spore Cap"
| |
| |format=template
| |
| |template=Usedin
| |
| |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=Usedin
| |
| |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=Usedin
| |
| |named args=yes
| |
| |default=
| |
| }}{{#cargo_query:tables=AnvilCraft
| |
| |fields=CONCAT("[[",_pageName,"]]")=Name, Quantity4=Quantity, CONCAT("Smithing")=Source
| |
| |where=Resource4 LIKE "Spore Cap"
| |
| |format=template
| |
| |template=Usedin
| |
| |named args=yes | |
| |default= | |
| }} | | }} |
| |}
| |
| -->
| |
| Used in items:
| |
|
| |
| ''Set numbers:''
| |
| smithing points
| |
| {| 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:''
| |
| post office, alchemy, stamps, refinery
| |
| <div class="mw-collapsible mw-collapsed">
| |
| "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"]
| |
| ]
| |
| </div>
| |
|
| |
| ''Queried:''
| |
| Quests, recipes
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| | | <!--https://idleon.info/wiki/Special:CargoTables <br/> |
| | | {{#cargo_query: |
| <!--{{#cargo_query:tables=NPCs | | tables=Items |
| |fields=_pageName=%PAGE%,MapLocation=location,QuestCount=noquest | | |fields=Items._pageName |
| |where=(MapLocation LIKE "%Hollowed Trunk%" OR MapLocation LIKE "%The Base Of The Bark%" OR MapLocation LIKE "%Jungle Perimeter%" OR MapLocation LIKE "%Winding Willows%" OR MapLocation LIKE "%Vegetable Patch%") AND (NPCType="NPC") | | |where=Items._pageName NOT IN ({{#cargo_query: |
| |format=template | | tables=Items__NEXT |
| |template=Npc/row | | |fields=CONCAT('"',Items__NEXT._pageName,'"') |
| |named args=yes | | |order by=Items__NEXT._pageName |
| |default= | | |format:ul |
| |intro={{Npctable/head|Jungle}} | | |limit=1500 |
| |outro=</td></tr></table> | | |default="None" |
| }}
| | |no html |
| {{#cargo_query:tables=Quests
| | }}) |
| |fields=QuestName=Quest,Quest_Text,Requirements,Rewards,Notes | | |order by=Items._pageName |
| |where=Rewards HOLDS LIKE "%Gem%" | | |format=ol |
| |format=table | | |columns=4 |
| | |limit=2000 |
| }}--> | | }}--> |
| <!--
| |
| {{#vardefine:i|0}}
| |
| {{#vardefine:AttackList|Fireball,Spike Trap,Rock Spikes,Sword,Rocketfist,Stomp,Uppercut}}
| |
| {{#vardefine:NormDamList}}
| |
| {| class="wikitable"
| |
| {{#while:
| |
| | {{#if: {{#explode:{{#var:AttackList}}|,|{{#var:i}}}} | true }}
| |
| | <nowiki />
| |
| {{!}}-
| |
| ! {{#explode:{{#var:AttackList}}|,|{{#var:i}}}}
| |
| {{!}} {{#explode:{{#var:NormDamList}}|,|{{#var:i}}}} {{#vardefine:i|{{#expr:{{#var:i}}+1}}}}
| |
| }}
| |
| |}
| |
|
| |
| {{#vardefine:j|0}}
| |
|
| |
| The list: {{#vardefineecho:RandNumArray|1871, 6840, 5129, 4952, 2306, 660, 9483, 8523, 6077, 7408, 3575, 7346, 2857, 2400, 7611, 3483, 9032, 8349, 1521, 53, 3345}}<br/>
| |
| {{#vardefine:MinNum|99999}}
| |
| {{#vardefine:MaxNum|0}}
| |
| {{#while:
| |
| | {{#if: {{#explode:{{#var:RandNumArray}}|,|{{#var:j}}}} | true }}
| |
| | <nowiki />
| |
| {{#ifexpr: {{#var:MinNum}} > {{#explode:{{#var:RandNumArray}}|,|{{#var:j}}}} |{{#vardefine:MinNum|{{#explode:{{#var:RandNumArray}}|,|{{#var:j}}}}}}|}}{{#ifexpr: {{#var:MaxNum}} < {{#explode:{{#var:RandNumArray}}|,|{{#var:j}}}} |{{#vardefine:MaxNum|{{#explode:{{#var:RandNumArray}}|,|{{#var:j}}}}}}|}}{{#vardefine:j|{{#expr:{{#var:j}}+1}}}}
| |
| }}
| |
| The min number is: {{#var:MinNum}}<br/>
| |
| The max number is: {{#var:MaxNum}}
| |
| -->
| |
Lustre Veil
Void Imperium Helmet
Dementia Helmet
Froge
Dementia Bar
Spontaneity Salts
Void Bar
Dense Water
Skelefish
Lustre Bar
Blobfish
Starfire Bar
Nullo Salt