[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
 
(55 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|release_version}}
{| class="wikitable"
{{#cargo_query:
! Location !! Boss !! Reward
|tables = items
|-
|where = release_version IS NULL AND items._pageNamespace = 0
| [[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]] || ??
{{Collapse top|Table list|gem_tier}}
|-
{{#cargo_query:
| [[The Red Vale]] || [[The Rust King]] || Lv.3 {{il|page=Uncut Skill Gem}}
|tables = items, skill_gems
|-
|join on = items._pageName=skill_gems._pageName
| [[The Grim Tangle]] || [[Fungus Behemoth]] || ??
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND items._pageNamespace = 0
|-
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
| [[The Graveyard]] || [[Lachlann of Endless Lament]] || {{il|Count Lachlann's Ring}}
|format = table
|-
}}
| [[The Mausoleum]] || [[Draven, Eternal Praetor]] || {{il|Draven's Memorial Key Piece}}
{{Collapse bottom}}
|-
 
| [[The Tomb]] || [[Asinia, Praetor Consort]] || {{il|Asinia's Memorial Key Piece}}
==Unique items without flavuor==
|-
{{Collapse top|Table list|flavuor}}
| [[The Hunting Grounds]] || [[The Crowbell]] || {{il|Book of Specialisation}}
{{Drop enabled unique item table
|-
|flavour_text = 1
| [[The Canopy]] || [[The King in the Mists]] || ??
|where = items.class_id NOT LIKE "Relic" AND (flavour_text IS NULL OR flavour_text LIKE "Coming Soon" )
|-
}}
| [[The Farmlands]] || ??|| ??
{{Collapse bottom}}
|-
 
| [[Ogham Village]] || [[The Executioner]] || [[Leitis]]
==Items without metadata_id==
|-
{{Collapse top|Table list|metadata_id}}
| [[The Courtyard]] || ?? || ??
{{#cargo_query:
|-
|tables = items
| [[The Iron Manor]] || [[Candlemass, the Living Rite]] || {{il|Candlemass' Essence}}
|where = metadata_id IS NULL AND rarity_id = "normal" AND items._pageNamespace = 0
|-
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
| [[The Iron Manor]] || [[The Iron Count]] || ??
|format = table
|}
}}
{{Collapse bottom}}


==[[Act 2]]==
==Files to fix==
* {{il|Spark}}
* {{il|Falling Thunder}}
* {{il|page=Uncut Skill Gem}}
* {{il|page=Uncut Skill Gem (quest item)}}
* {{ql|The Trail of Corruption}}
* {{il|Balbala's Barya}}
* {{il|The Last Flame}}
* {{il|Heartbound Loop}}


=Other=
==Big def values==
==Big def values==
{| class = "wikitable plainlist"
{| class = "wikitable plainlist"
Line 240: Line 249:
|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 262:
|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 19:47, 30 March 2025

My bot MefistoBot.
My Sandbox.

Items without release_version

Table list ▾ [Expand] ▾

Gems without gem_tier

Table list ▾ [Expand] ▾

Unique items without flavuor

Table list ▾ [Expand] ▾

Items without metadata_id

Table list ▾ [Expand] ▾

Files to fix

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=33138"