User:Kiokurashi/sandbox: Difference between revisions

From IdleOn MMO Wiki
mNo edit summary
m (Replaced content with "{{#cargo_query:tables=ItemSources |fields=CONCAT('', Item, '')=Item, SourcesList<!--, COUNT(Item)=Number--> |where=SourcesList LIKE "%Unobtainable%" |format=table |limit=5000 }} <!--Old <!--https://idleon.info/wiki/Special:CargoTables <br/> {{#cargo_query: tables=Items |fields=Items._pageName |where=Items._pageName NOT IN ({{#cargo_query: tables=Items__NEXT |fields=CONCAT('"',Items__NEXT._pageName,'"') |order by=Items__NEXT._pageName |format:ul |limit=1500 |def...")
Tag: Replaced
Line 7: Line 7:
<!--Old
<!--Old


{{#invoke:Usedin|main|Copper Ore}}
<table class="scrolltest2"><tr>
<td style="vertical-align: top; max-height: 500px; max-width: 400px; overflow-y: scroll;"> {{POCoHeadImage|Simple Shippin}}
This shipping company asks for W1/W2 Skilling resources.
<tabber>Orders=
{{orders/head|description=Orders|collapsed=Yes}}
{{Orders/rowO|Copper Ore|150}}
{{Orders/rowO|Iron Ore|150}}
{{Orders/rowO|Copper Bar|50}}
{{Orders/rowO|Oak Logs|200}}
{{Orders/rowO|Bleach Logs|100}}
{{Orders/rowO|Jungle Logs|80}}
{{Orders/rowO|Goldfish|120}}
{{Orders/rowO|Fly|120}}
{{Orders/rowO|Hermit Can|100}}
{{Orders/rowO|Butterfly|100}}
{{Orders/rowO|Iron Bar|50}}
{{Orders/rowO|Thread|100}}
{{Orders/rowO|Trusty Nails|40}}
{{Orders/rowO|Gold Ore|100}}
{{Orders/rowO|Gold Bar|25}}
{{Orders/rowO|Potty Rolls|125}}
{{Orders/rowO|Jellyfish|70}}
{{Orders/rowO|Sentient Cereal|90}}
{{Orders/rowO|Boring Brick|25}}
{{Orders/rowO|Tropilogs|110}}
{{Orders/rowO|Bloach|40}}
{{Orders/rowO|Veiny Logs|100}}
{{Orders/rowO|Fruitfly|65}}
|}
|-|Rewards=
{{orders/head|description=Rewards|collapsed=Yes}}
{{Orders/rowR|Armor Upgrade Stone I|2}}
{{Orders/rowR|Weapon Upgrade Stone I|1}}
{{Orders/rowR|Tool Upgrade Stone I|2}}
{{Orders/rowR|Golden Jam|1}}
{{Orders/rowR|Peanut|50}}
{{Orders/rowR|Power Statue|1}}
{{Orders/rowR|Small Experience Balloon|1}}
{{Orders/rowR|Feasty Statue|1}}
{{Orders/rowR|Forest Villa Key|1}}
{{Orders/rowR|Efaunt's Tomb Key|1}}
{{Orders/rowR|Helmet Upgrade Stone I|1}}
{{Orders/rowR|Gem|1}}
|}</tabber></td>
<td style="vertical-align: top; max-width: 400px;"> {{POCoHeadImage|Plan-it Express}}
This shipping company asks for equipment (Armor, Weapons, Tools).
<div style="max-height: 500px; overflow-y: scroll;">
<tabber>Orders=
{{orders/head|description=Orders|collapsed=Yes}}
{{Orders/rowO|Farmer Brim|1}}
{{Orders/rowO|Wooden Spear|1}}
{{Orders/rowO|Flip Flops|1}}
{{Orders/rowO|Copper Boots|1}}
{{Orders/rowO|Iron Boots|1}}
{{Orders/rowO|Leather Cap|1}}
{{Orders/rowO|Copper Platebody|1}}
{{Orders/rowO|Top Hat|1}}
{{Orders/rowO|Blue Tee|1}}
{{Orders/rowO|Birch Longbow|1}}
{{Orders/rowO|Iron Pickaxe|1}}
{{Orders/rowO|Iron Helmet|1}}
{{Orders/rowO|Gold Helmet|1}}
{{Orders/rowO|Bandage Wraps|1}}
{{Orders/rowO|Starlight|1}}
{{Orders/rowO|Royal Bayonet|1}}
{{Orders/rowO|Iron Hatchet|1}}
{{Orders/rowO|Green Tee|1}}
{{Orders/rowO|Gold Boots|1}}
{{Orders/rowO|Copper Band|1}}
{{Orders/rowO|Carrot Launcher|1}}
{{Orders/rowO|Black Tee|1}}
{{Orders/rowO|Spiked Menace|1}}
{{Orders/rowO|Gold Fishing Rod|1}}
{{Orders/rowO|Golden Net|1}}
{{Orders/rowO|Pharaoh Bow|1}}
{{Orders/rowO|Plat Fishing Rod|1}}
{{Orders/rowO|Platinum Shins|1}}
{{Orders/rowO|Plat Hatchet|1}}
{{Orders/rowO|Platinum Pickaxe|1}}
{{Orders/rowO|Platinum Boots|1}}
|}
|-|Rewards=
{{orders/head|description=Rewards|collapsed=Yes}}
{{Orders/rowR|Armor Upgrade Stone I|2}}
{{Orders/rowR|Weapon Upgrade Stone I|2}}
{{Orders/rowR|Golden Nomwich|1}}
{{Orders/rowR|Average Speed Potion|100}}
{{Orders/rowR|Small Experience Balloon|1}}
{{Orders/rowR|Feasty Statue|1}}
{{Orders/rowR|Armor Upgrade Stone II|1}}
{{Orders/rowR|Tool Upgrade Stone II|1}}
{{Orders/rowR|Kachow Statue|1}}
{{Orders/rowR|Forest Villa Key|1}}
{{Orders/rowR|Helmet Upgrade Stone I|1}}
{{Orders/rowR|Small EXP Potion|100}}
{{Orders/rowR|Efaunt's Tomb Key|1}}
{{Orders/rowR|Weapon Upgrade Stone II|1}}
{{Orders/rowR|Gem|1}}
|}
</tabber></div></td>
<td style="vertical-align: top; max-width: 400px;"> {{POCoHeadImage|Dudes Next Door}}
This shipping company asks for W1/W2 monster drops.
<tabber>Orders=<div style="max-height: 500px; overflow-y: scroll;">{{orders/head|description=Orders|collapsed=Yes}}
{{Orders/rowO|Spore Cap|125}}
{{Orders/rowO|Frog Leg|120}}
{{Orders/rowO|Bean Slices|115}}
{{Orders/rowO|Slime Sludge|110}}
{{Orders/rowO|Snake Skin|105}}
{{Orders/rowO|Carrot Cube|100}}
{{Orders/rowO|Glublin Ear|100}}
{{Orders/rowO|Plank|90}}
{{Orders/rowO|Bullfrog Horn|90}}
{{Orders/rowO|Pocket Sand|100}}
{{Orders/rowO|Corn Kernels|100}}
{{Orders/rowO|Megalodon Tooth|95}}
{{Orders/rowO|Stick|80}}
{{Orders/rowO|Crabby Cakey|150}}
{{Orders/rowO|Rats Tail|100}}
{{Orders/rowO|Acorn|70}}
{{Orders/rowO|Amarok Slab|2}}
{{Orders/rowO|Coconotnotto|100}}
{{Orders/rowO|Furled Flag|100}}
{{Orders/rowO|Pincer Arm|80}}
{{Orders/rowO|Potato Remains|80}}
{{Orders/rowO|High Steaks|80}}
{{Orders/rowO|Wakka Cherry|80}}
{{Orders/rowO|Singlecle|80}}
{{Orders/rowO|Shrapshell|80}}
{{Orders/rowO|Ripped Tunic|2}}
|}</div>
|-|Rewards=<div style="max-height: 500px; overflow-y: scroll;">
{{orders/head|description=Rewards|collapsed=Yes}}
{{Orders/rowR|Armor Upgrade Stone I|2}}
{{Orders/rowR|Weapon Upgrade Stone I|2}}
{{Orders/rowR|Golden Kebabs|1}}
{{Orders/rowR|Average EXP Potion|100}}
{{Orders/rowR|Radioactive Waste|20}}
{{Orders/rowR|Small Experience Balloon|1}}
{{Orders/rowR|Armor Upgrade Stone II|1}}
{{Orders/rowR|Tool Upgrade Stone II|1}}
{{Orders/rowR|Weapon Upgrade Stone II|1}}
{{Orders/rowR|Efaunt's Tomb Key|1}}
{{Orders/rowR|Armor Upgrade Stone II|2}}
{{Orders/rowR|Tool Upgrade Stone II|2}}
{{Orders/rowR|Weapon Upgrade Stone III|1}}
{{Orders/rowR|Gem|2}}
|}</div>
</tabber></td></tr></table>
{| class='wikitable'
! Enemies/Droptables
|[[Floofie]], [[Shell Snake]], [[DropTable13]]
|-
! Quests
|[[Scripticus#The Choice is Yours!|The Choice is Yours!]], [[Scripticus#Can't somebody else do it?|Can't somebody else do it?]], [[Desert Davey#U Cool?|U Cool?]], [[Mutton#Clout Chasin'|Clout Chasin']], [[Fishpaste97#'Accidental' Exploit|'Accidental' Exploit]], [[Djonnut#Genie Dieting|Genie Dieting]], [[Snake Jar#A Noob, served Medium Rare!|A Noob, served Medium Rare!]], [[Cowbo Jones#No Country for One Character|No Country for One Character]], [[Centurion#Which one of yous is the Mafia?|Which one of yous is the Mafia?]], [[Loveulyte#Heart Hogger|Heart Hogger]], [[Iceland Irwin#Crikey, it's cold out!|Crikey, it's cold out!]], [[Hoggindaz#Trapping with the Lord|Trapping with the Lord]], [[Hoggindaz#Monke Tower Time!|Monke Tower Time!]], [[Shuvelle#Mayoral Luck|Mayoral Luck]], [[Lonely Hunter#Leaf Him Alone!|Leaf Him Alone!]], [[Lonely Hunter#Skeleton? Skelegone!|Skeleton? Skelegone!]]
|-
!Datarow stuff
|[[Gem Shop]], [[Skull Shop]], [[Alchemy#Level up Gift|Level up Gift]], [[Guild Giftbox]], [[Phone Box]]
|}
New
{| class='wikitable'
! Enemies/Droptables
|{{#cargo_query:tables=DropTables
|fields=CONCAT("[[", DropSourceEntity, "]]")
|where=DropItem="1 HR Time Candy" AND NOT DropSourceEntity LIKE "%DropTable%"
|format=list
|group by=DropSourceEntity
|order by=DropSourceEntity ASC
|default=
}}
|-
! Quests
|{{#cargo_query:tables=Quests
|fields=_pageName
|where=Rewards HOLDS LIKE "%>1 HR Time Candy<%"
|format=list
|group by=_pageName
|default=
}}
|-
!Datarow stuff
|Not done yet
{{#cargo_query:tables=Sources
|fields=CONCAT('[[', Link, ']]', IF(SpecialText = 'None', '', CONCAT(' (', SpecialText, ')')))
|where=Item="1 HR Time Candy"
|format=list
|order by=Source
|default=
}}
{{#cargo_query:tables=Sources
|fields=CONCAT("\n''", Item, " can be obtained from any enemy via 'Event Rules'''")
|where=Item="Phone Box" AND EventRules=1
|format=list
|group by=Item
|default=
}}
|}-->
<!--
<table style="display:flex; text-align: center;">
<tr><td colspan="6" style="width:100%;">{{ClassMiniBox|class=Beginner|skill=Fishing|dmg=Strength|acc=Wisdom}}</td></tr>
<tr>
<td colspan="2" style="width:33%;">{{ClassMiniBox|class=Warrior|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td colspan="2" style="width:33%;">{{ClassMiniBox|class=Archer|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td colspan="2" style="width:33%;">{{ClassMiniBox|class=Mage|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
</tr><tr>
<td>{{ClassMiniBox|class=Barbarian|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Squire|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Bowman|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Hunter|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Wizard|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Shaman|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
</tr><tr>
<td>{{ClassMiniBox|class=Blood Berserker|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Divine Knight|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Siege Breaker|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Beast Master|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Elemental Sorcerer|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
<td>{{ClassMiniBox|class=Bubonic Conjuror|skill=Fishing|dmg=Strength|acc=Wisdom}}</td>
</tr></table>-->
<!--
{{ClassMiniBox|class=Warrior|skill=Mining|dmg=Strength|acc=Wisdom}}{{ClassMiniBox|class=Warrior|skill=Mining|dmg=Agility|acc=Strength|sideview=true}}{{ClassMiniBox|class=Warrior|skill=Mining|dmg=Wisdom|acc=Agility}}{{ClassMiniBox|class=Warrior|skill=Mining|dmg=Luck|acc=Luck|sideview=true}}
-->
<!--{{Template:Builds/Skilltable}}
<div class="skillsetwrapper">
    <div class="notesbox">These are notes. Yaaaaay!
* Testing asterisks</div>
</div>-->


<!--https://idleon.info/wiki/Special:CargoTables <br/>
<!--https://idleon.info/wiki/Special:CargoTables <br/>

Revision as of 01:00, 24 March 2024

Item SourcesList
Alien Logs Unobtainable
Ancient Leggings Unobtainable
Anvil Tab 8 Unobtainable
Apple Stamp Unobtainable
Archer Talent Book Unobtainable
Average Critter Pouch Unobtainable
Average Soul Pouch Unobtainable
Beginner Talent Book Unobtainable
Blood Screamer Unobtainable
Blubbery Icey Unobtainable
Breezy Soul Card Unobtainable
Breezy Soul Unobtainable
Broken Mic Unobtainable
Bug Net Unobtainable
Cash Unobtainable
Cauldrunners Unobtainable
Chaotic Emperor Card Unobtainable
Chat Ring Unobtainable
Chocotastic Icey Unobtainable
Crabby Cake Supreme Unobtainable
Cramped Critter Pouch Unobtainable
Cramped Soul Pouch Unobtainable
Crystallax Shins Unobtainable
Delivery Box Unobtainable
Demon Horns Unobtainable
Double AFK Gain Ticket Unobtainable
Elderly Peanut Unobtainable
Emerald Eizon Unobtainable
Emperor Card Unobtainable
Experience Unobtainable
Eyern Boots Unobtainable
Farmer Brimer Unobtainable
Farmer Brimest Unobtainable
Firefly Card Unobtainable
Fishing Twine Unobtainable
Flaming Katana Unobtainable
Flap Flops Unobtainable
Flesh Reaper Unobtainable
Floop Flops Unobtainable
Flux Flops Unobtainable
Fly (fishing) Unobtainable
Forensic Leggings Unobtainable
Frozen Impaler Unobtainable
Gaia Shoes Unobtainable
Gear Stamp Unobtainable
Gem Note Unobtainable
Gilded Pilates Unobtainable
Gold Ring Unobtainable
Green Tea Unobtainable
Hermes Boots Unobtainable
Husky Hat Unobtainable
I Made This Game Unobtainable
Ice A La Crem Unobtainable
Ice Cream Sunday Unobtainable
Ice Dollar Unobtainable
Inventory Bag I Unobtainable
IOU One Blue Crystal Unobtainable
IOU One Fire Crystal Unobtainable
IOU one Sky Crystal Unobtainable
Iron Sword Unobtainable
Ladybug Card Unobtainable
Lava Icey Unobtainable
Lava Sez Buy More Gems Unobtainable
Lava Wings Unobtainable
Lava's Awesome Nametag Unobtainable
Legends Icey Unobtainable
Loot Dice Unobtainable
Lucky Fish Head Unobtainable
Merchantile Pants Unobtainable
Microphone Unobtainable
Miniature Bug Pouch Unobtainable
Miniature Fish Pouch Unobtainable
Mint Icey Unobtainable
Molden Crust Unobtainable
Molten Chest Unobtainable
Nondescript Game Show Host Hair Unobtainable
Not Yet Unobtainable
Original Gamer Unobtainable
Paralax Chest Unobtainable
Pet Crystal Unobtainable
Pete the Peanut Unobtainable
Picnic Stowaway's Jam Unobtainable
Platinum Obol of Blinding Speed Unobtainable
Player Rating With Letter P Unobtainable
Player Rating With Letter S Unobtainable
Prayday Stamp Unobtainable
Quartz Pendant Unobtainable
Rainbo Icey Unobtainable
Refurbished Cog Unobtainable
REPLACE ME Unobtainable
Rok Road Icey Unobtainable
Rooted Bow Unobtainable
Secretstone Unobtainable
Shiny Crab Stamp Unobtainable
Skill Experience Unobtainable
Slime Cap Unobtainable
Smartas Smithing Stamp Unobtainable
Sovereign Emperor Card Unobtainable
Special Talent Book Unobtainable
Spice Unobtainable
Spikeweed Ring Unobtainable
Spirit Card Pack Unobtainable
SpoOoky Stamp Unobtainable
Spriggly Staff Unobtainable
Stalagmite Unobtainable
Starlight Ore Unobtainable
Steel Spear Unobtainable
Strawbu Icey Unobtainable
Strung Steamy Unobtainable
Talent I Stamp Unobtainable
Talent Point Tab 5 Unobtainable
Talent V Stamp Unobtainable
Tanned Hide Unobtainable
The Used Bandaid Unobtainable
Toxic Bubbles Band Unobtainable
Trojan Helmet Unobtainable
Warrior Talent Book Unobtainable
Wizard Talent Book Unobtainable
Wood Fishing Rod Unobtainable
Yellow Belt Ninja Pants Unobtainable
Yeti Walkers Unobtainable