User:Kiokurashi/sandbox: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
No edit summary
mNo edit summary
 
(267 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=
}}
|}
 
 
 
 
 
 
 
 
 
 


{{#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
{{Usedin/head}}
== Unobtainables ==
{{#cargo_query:tables=AnvilCraft
{{#cargo_query:tables=ItemSources
|fields=CONCAT("[[",_pageName,"]]")=Name, Quantity1=Quantity, CONCAT("Smithing")=Source
|fields=CONCAT('[[', Item, ']]')=Item
|where=Resource1 LIKE "Spore Cap"
|where=SourcesList LIKE "%Unobtainable%"
|format=template
|format=ol
|template=Usedin
|columns=4
|named args=yes
|limit=5000
|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:''
<!--https://idleon.info/wiki/Special:CargoTables <br/>
smithing points
{{#cargo_query:
{| class="wikitable sortable mw-collapsible mw-collapsed"
tables=Items
|+Buy Points - Monster Drops
|fields=Items._pageName
!Points!!Image!!Monster Drop!!Quantity
|where=Items._pageName NOT IN ({{#cargo_query:
|-
tables=Items__NEXT
|1-5||[[File:Spore_Cap.png|alt=|frameless]]||[[Spore Cap]]||38
|fields=CONCAT('"',Items__NEXT._pageName,'"')
|-
|order by=Items__NEXT._pageName
|6-15||[[File:Frog_Legs.png|alt=|frameless]]||[[Frog Leg]]||446
|format:ul
|-
|limit=1500
|16-25||[[File:Bean_Slices.png|alt=|frameless]]||[[Bean Slices]]||1129
|default="None"
|-
|no html
|26-40||[[File:Slime_Sludge.png|alt=|frameless]]||[[Slime Sludge]]||3342
}})
|-
|order by=Items._pageName
|41-55||[[File:Carrot_Cube.png|alt=|frameless]]||[[Carrot Cube]]||5710
|format=ol
|-
|columns=4
|56-70||[[File:Goblin Ear.png|frameless]]||[[Goblin Ear]]||8443
|limit=2000
|-
|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
 
 
 
 
 
 
 
<!--{{#cargo_query:tables=NPCs
|fields=_pageName=%PAGE%,MapLocation=location,QuestCount=noquest
|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")
|format=template
|template=Npc/row
|named args=yes
|default=
|intro={{Npctable/head|Jungle}}
|outro=</td></tr></table>
}}
{{#cargo_query:tables=Quests
|fields=QuestName=Quest,Quest_Text,Requirements,Rewards,Notes
|where=Rewards HOLDS LIKE "%Gem%"
|format=table
}}-->
}}-->
<!--
{{#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"