User:Kiokurashi/sandbox: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
No edit summary
mNo edit summary
 
(269 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Usedin/head}}
<time class="countdown-timer" data-mode="labeled" data-timestamp="1717045200"></time>
{{#cargo_query:tables=AnvilCraft
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
|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
|template=Row
|named args=yes
|default=
}}
|}


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.
{{#invoke:RecipeDetails/Pull|Main|Item=Diabolical Headcase}}
{{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=
}}
|}
 
 
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


<!--
{{#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
|limit=5000
}}


 
<!--https://idleon.info/wiki/Special:CargoTables <br/>
 
{{#cargo_query:
 
tables=Items
<!--{{#cargo_query:tables=NPCs
|fields=Items._pageName
|fields=_pageName=%PAGE%,MapLocation=location,QuestCount=noquest
|where=Items._pageName NOT IN ({{#cargo_query:
|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")
tables=Items__NEXT
|format=template
|fields=CONCAT('"',Items__NEXT._pageName,'"')
|template=Npc/row
|order by=Items__NEXT._pageName
|named args=yes
|format:ul
|default=
|limit=1500
|intro={{Npctable/head|Jungle}}
|default="None"
|outro=</td></tr></table>
|no html
}}
}})
{{#cargo_query:tables=Quests
|order by=Items._pageName
|fields=QuestName=Quest,Quest_Text,Requirements,Rewards,Notes
|format=ol
|where=Rewards HOLDS LIKE "%Gem%"
|columns=4
|format=table
|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}}
-->

Latest revision as of 01:56, 23 May 2024


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