Helmets: Difference between revisions

From IdleOn MMO Wiki
mNo edit summary
mNo edit summary
Line 1: Line 1:
==Helmets==
==Helmets==
{{Armor/head|Helmets}}
{{Armor/head|Helmets}}
{{#cargo_query:tables=Items, SlabOrder
{{#cargo_query:tables=Items, SlabOrder,ItemSources
|join on=Items._pageName=SlabOrder.Item
|join on=Items._pageName=SlabOrder.Item,Items._pageName=ItemSources.Item
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, Items.Source=source, Skill=skill
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, SourcesList=source, Skill=skill
|named args=yes
|named args=yes
|where=type="Helmet" AND NOT Items.Source LIKE "%Unobtainable%" AND NOT Items.Source LIKE "%Event%"
|where=type="Helmet" AND NOT SourcesList LIKE "%Unobtainable%" AND NOT Items.Source LIKE "%Event%"
|format=template
|format=template
|template=InfoItem/Armorrow
|template=InfoItem/Armorrow
Line 15: Line 15:
==Limited-Time/Event==
==Limited-Time/Event==
{{Armor/head|Limited-Time/Event}}
{{Armor/head|Limited-Time/Event}}
{{#cargo_query:tables=Items, SlabOrder
{{#cargo_query:tables=Items, SlabOrder,ItemSources
|join on=Items._pageName=SlabOrder.Item
|join on=Items._pageName=SlabOrder.Item,Items._pageName=ItemSources.Item
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, Items.Source=source, Skill=skill
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, SourcesList=source, Skill=skill
|named args=yes
|named args=yes
|where=type="Helmet" AND Items.Source LIKE "%Event%"
|where=type="Helmet" AND SourcesList LIKE "%Event%"
|format=template
|format=template
|template=InfoItem/Armorrow
|template=InfoItem/Armorrow
Line 29: Line 29:
==Unobtainable==
==Unobtainable==
{{Armor/head|Unobtainable}}
{{Armor/head|Unobtainable}}
{{#cargo_query:tables=Items, SlabOrder
{{#cargo_query:tables=Items, SlabOrder,ItemSources
|join on=Items._pageName=SlabOrder.Item
|join on=Items._pageName=SlabOrder.Item,Items._pageName=ItemSources.Item
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, Items.Source=source
|fields=Items._pageName=Name, Items.Image=Image, Items.Class=class, Items.Level=level, Items.SkillPower=skillpower, Items.STR=str, Items.AGI=agi, Items.WIS=wis, Items.LUCK=luck, Items.Defence=defence, Items.WeaponPower=weaponpower, Items.MISC=misc, Items.MISC2=misc2, Items.Upgrade=upgrade, Items.SellPrice=sellprice, SourcesList=source
|named args=yes
|named args=yes
|where=type="Helmet" AND Items.Source LIKE "%Unobtainable%"
|where=type="Helmet" AND SourcesList LIKE "%Unobtainable%"
|format=template
|format=template
|template=InfoItem/Armorrow
|template=InfoItem/Armorrow

Revision as of 01:36, 22 March 2024

Helmets

Helmets
Name Image Class Level Skill Str Agi Wis Luk Def WP Misc Slots Sell Price Source
Error 1054: Unknown column 'mw_cargo__Items.Source' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Items`.`_pageName` AS `Name`,`mw_cargo__Items`.`Image` AS `Image`,`mw_cargo__Items`.`Class` AS `class`,`mw_cargo__Items`.`Level` AS `level`,`mw_cargo__Items`.`SkillPower` AS `skillpower`,`mw_cargo__Items`.`STR` AS `str`,`mw_cargo__Items`.`AGI` AS `agi`,`mw_cargo__Items`.`WIS` AS `wis`,`mw_cargo__Items`.`LUCK` AS `luck`,`mw_cargo__Items`.`Defence` AS `defence`,`mw_cargo__Items`.`WeaponPower` AS `weaponpower`,`mw_cargo__Items`.`MISC` AS `misc`,`mw_cargo__Items`.`MISC2` AS `misc2`,`mw_cargo__Items`.`Upgrade` AS `upgrade`,`mw_cargo__Items`.`SellPrice` AS `sellprice`,`SourcesList` AS `source`,`Skill` AS `skill` FROM `mw_cargo__Items` LEFT OUTER JOIN `mw_cargo__SlabOrder` ON ((`mw_cargo__Items`.`_pageName`=`mw_cargo__SlabOrder`.`Item`)) LEFT OUTER JOIN `mw_cargo__ItemSources` ON ((`mw_cargo__Items`.`_pageName`=`mw_cargo__ItemSources`.`Item`)) WHERE type="Helmet" AND NOT SourcesList LIKE "%Unobtainable%" AND NOT `mw_cargo__Items`.`Source` LIKE "%Event%" ORDER BY `mw_cargo__SlabOrder`.`Number` LIMIT 500

Limited-Time/Event

Limited-Time/Event
Name Image Class Level Skill Str Agi Wis Luk Def WP Misc Slots Sell Price Source
Ice Guard Helmet Ice Guard Helmet.png All 1 — 5 5 5 5 5 3 5% Xp From Monsters 5 Copper Coin.png1 Random Events (Glacial Guild)
Big Pretty Bow Big Pretty Bow.png All 1 — 1 1 1 0 0 0 5% Xp From Monsters 3 Copper Coin.png1 3rd Anniversary Event Boxes, Choco Box
Bunny Ears Bunny Ears.png All 1 — 0 4 0 0 0 0 4% Xp From Monsters 3 Copper Coin.png1 Egg Capsule, Spring Splendor Event
Summer Shell Summer Shell.png All 1 — 0 4 0 0 0 0 4% Xp From Monsters 3 Copper Coin.png1 Summer Cooler
Santa Hat Santa Hat.png All 1 — 1 1 1 0 0 0 5% Xp From Monsters 3 Copper Coin.png1 Giftmas Box, 2021 Giftmas Login Bonus
3rd Anniversary Ice Cream Topper 3rd Anniversary Ice Cream Topper.png All 1 — 0 0 0 0 5 2 4% XP From Monsters
3% Drop Chance 		3 Copper Coin.png1 3rd Anniversary Event Boxes
Steam Cap Steam Cap.png All 1 — 1 1 1 1 0 0 3% Xp From Monsters 0 Copper Coin.png1 Steam Launch Event
Apple Launch Hat Apple Launch Hat.png All 1 — 0 0 0 0 3 3 5% Xp From Monsters 5 Copper Coin.png1 3rd Anniversary Event Boxes, Phone Box, Golden Oyster
Funny Hat Funny Hat.png All 20 — 5 5 5 5 10 3 6% Skill Efficiency 5 Copper Coin.png1 Idle Skilling Crossover
Meteorhead Meteorhead.png All 1 — 5 5 5 5 5 3 5% Xp From Monsters 5 Copper Coin.png1 Random Events (Meteorite)

Unobtainable

Unobtainable
Name Image Class Level Skill Str Agi Wis Luk Def WP Misc Slots Sell Price Source
Farmer Brimer Farmer Brimer.png All 3 0 0 4 2 0 4 0 — 2 Silver Coin.png1 Copper Coin.png50 Unobtainable
Farmer Brimest Farmer Brimest.png All 5 0 3 3 3 3 6 0 — 3 Silver Coin.png4 Unobtainable
Trojan Helmet Trojan Helmet.png All 15 0 2 2 0 0 0 0 — 2 Silver Coin.png2 Unobtainable
Demon Horns Demon Horns.png All 15 0 3000 3000 3000 3000 10000 400 — 2 Silver Coin.png2 Unobtainable
Slime Cap Slime Cap.png Beginner 15 0 0 4 0 2 0 0 — 4 Silver Coin.png2 Unobtainable
Ice Cream Sunday Ice Cream Sunday.png Beginner 30 0 0 0 6 0 5 0 10% Gold Food Effect 5 Silver Coin.png2 Unobtainable
Nondescript Game Show Host Hair Nondescript Game Show Host Hair.png All 1 0 25 40 0 50 0 100 100% Family 8 Copper Coin.png1 Unobtainable
Retrieved from "https://idleon.wiki/wiki/index.php?title=Helmets&oldid=75224"