[dismiss]

The wiki is currently a work in progress. If you'd like to help out, please check the Community Portal and our getting started guide. Also, check out our sister project on poewiki.net.

User:Mefisto1029: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
 
(46 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Sister|poewiki}}
{{Sister|poewiki}}
[[User:Mefisto1029/sandbox|Sandbox]]
My bot [[User:MefistoBot|MefistoBot]].<br>
My [[User:Mefisto1029/sandbox|Sandbox]].


=Boss rewards=
==Items without release_version==
==[[Act 1]]==
{{Collapse top|Table list}}
{| class="wikitable"
{{#cargo_query:
! Location !! Boss !! Reward
|tables = items
|-
|where = release_version IS NULL
| [[The Riverbank]] || [[Bloated Miller]] || ??
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|-
|format = table
| [[Clearfell]] || [[Carrion Crone]] || {{il|Head of the Winter Wolf}}
}}
|-
{{Collapse bottom}}
| [[The Mud Burrow]] || [[The Devourer]] || ??
 
|-
==Gems without gem_tier==
| [[The Old Forest]] || [[Bramble Abomination]] || ??
{{#cargo_query:
|-
|tables = items, skill_gems
| [[The Red Vale]] || [[The Rust King]] || Lv.3 {{il|page=Uncut Skill Gem}}
|join on = items._pageName=skill_gems._pageName
|-
|fields = items.name
| [[The Grim Tangle]] || [[Fungus Behemoth]] || ??
|format = template
|-
|template = il
| [[The Graveyard]] || [[Lachlann of Endless Lament]] || {{il|Count Lachlann's Ring}}
|delimiter = ,&nbsp;
|-
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
| [[The Mausoleum]] || [[Draven, Eternal Praetor]] || {{il|Draven's Memorial Key Piece}}
|limit = 25
|-
}}
| [[The Tomb]] || [[Asinia, Praetor Consort]] || {{il|Asinia's Memorial Key Piece}}
 
|-
==Files to fix==
| [[The Hunting Grounds]] || [[The Crowbell]] || {{il|Book of Specialisation}}
* {{il|Spark}}
|-
* {{il|Falling Thunder}}
| [[The Canopy]] || [[The King in the Mists]] || ??
* {{il|page=Uncut Skill Gem}}
|-
* {{il|page=Uncut Skill Gem (quest item)}}
| [[The Farmlands]] || ??|| ??
* {{ql|The Trail of Corruption}}
|-
* {{il|Balbala's Barya}}
| [[Ogham Village]] || [[The Executioner]] || [[Leitis]]
* {{il|The Last Flame}}
|-
* {{il|Heartbound Loop}}
| [[The Courtyard]] || ?? || ??
|-
| [[The Iron Manor]] || [[Candlemass, the Living Rite]] || {{il|Candlemass' Essence}}
|-
| [[The Iron Manor]] || [[The Iron Count]] || ??
|}


==[[Act 2]]==
==Unique flavuor==
{{Drop enabled unique item table
|flavour_text = 1
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
}}


=Other=
==Big def values==
==Big def values==
{| class = "wikitable plainlist"
{| class = "wikitable plainlist"
Line 240: Line 238:
|q_where = items.rarity_id = "normal"
|q_where = items.rarity_id = "normal"
   AND items.drop_enabled = 1
   AND items.drop_enabled = 1
   AND items.class_id = "Shield"
   AND items.class_id = "Buckler"
   AND armours.energy_shield_range_maximum = 0
   AND armours.energy_shield_range_maximum = 0
   AND armours.evasion_range_maximum > 0
   AND armours.evasion_range_maximum > 0
Line 253: Line 251:
|q_where = items.rarity_id = "normal"
|q_where = items.rarity_id = "normal"
   AND items.drop_enabled = 1
   AND items.drop_enabled = 1
   AND items.class_id = "Shield"
   AND items.class_id = "Focus"
   AND armours.energy_shield_range_maximum > 0
   AND armours.energy_shield_range_maximum > 0
   AND armours.evasion_range_maximum = 0
   AND armours.evasion_range_maximum = 0

Latest revision as of 20:43, 17 January 2025

My bot MefistoBot.
My Sandbox.

Items without release_version

Table list ▾ [Expand] ▾

Gems without gem_tier

File:Battershout inventory icon.pngBattershout, Bind Spectre, File:Commiserate inventory icon.pngCommiserate, File:Concoct inventory icon.pngConcoct, File:Derance inventory icon.pngDerance, File:Embitter inventory icon.pngEmbitter, File:Perfection inventory icon.pngPerfection, File:Volcanic Eruption inventory icon.pngVolcanic Eruption

Files to fix

Unique flavuor

ItemFlavour text
Bluetongue—
Splinter of Loratta—
Solar Lance—
The Smiling KnightComing soon
The Vile KnightComing soon
Corona of the Red SunComing soon

Big def values

Biggest defense values
Type Armour Evasion Energy Shield
Body Armour
Helmets
Gloves
Boots
Shields
Retrieved from "https://www.poe2wiki.net/index.php?title=User:Mefisto1029&oldid=27939"