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
 
(25 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]].


==Di==
==Items without release_version==
'''Boss dial''':
{{Collapse top|Table list}}
===Act 3===
{{#cargo_query:
* '''Mektul, the Forgemaster''': Infernal woman... Your burning heart shall join my forge... (Infernalist)
|tables = items
* '''Queen of Filth''': Cleanskin wench! Does my family disgust you They taste better than they look. (Witch? Generic?)
|where = release_version IS NULL
* '''Ketzuli, High Priest of the Sun''': I pledge my body and soul to you; oh Great Kopec.
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
}}
{{Collapse bottom}}


==Gems without gem_tier==
{{#cargo_query:
|tables = items, skill_gems
|join on = items._pageName=skill_gems._pageName
|fields = items.name
|format = template
|template = il
|delimiter = ,&nbsp;
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
|limit = 25
}}


'''Witch''':
==Files to fix==
===Full inventory===
* {{il|Spark}}
* No.
* {{il|Falling Thunder}}
* I think not.
* {{il|page=Uncut Skill Gem}}
* Too. Much. Clutter.
* {{il|page=Uncut Skill Gem (quest item)}}
 
* {{ql|The Trail of Corruption}}
===Entering locations===
* {{il|Balbala's Barya}}
====Act 1====
* {{il|The Last Flame}}
* '''[[The Riverbank]]''':
* {{il|Heartbound Loop}}
* '''[[Clearfell Encampment]]''':
* '''[[Clearfell]]''':
* '''[[Mud Burrow]]''':
* '''[[The Grelwood]]''':
* '''[[The Red Vale]]''':
* '''[[The Grim Tangle]]''':
* '''[[Cemetery of the Eternals]]''':
* '''[[Mausoleum of the Praetor]]''':
* '''[[Tomb of the Consort]]''':
* '''[[Hunting Grounds]]''':
* '''[[Freythorn]]''':
* '''[[Ogham Farmlands]]''':
* '''[[Ogham Village]]''':
* '''[[The Manor Ramparts]]''':
* '''[[Ogham Manor]]''':
 
 
===Boss defeated===
====Act 1====
* '''[[The Bloated Miller]]''': Impresive size but little acuity. Dismal.
* '''[[Beira of the Rotten Pack]]''':
* '''[[The Devourer]]''':
* '''[[The Brambleghast]]''':
* '''[[The Rust King]]''':
* '''[[The Rotten Druid]]''':
* '''[[Draven, the Eternal Praetor]]''':
* '''[[Asinia, the Praetor's Consort]]''':
* '''[[Lachlann of Endless Lament]]''':
 
===act3===
====Act 3====
Loc:
* '''[[The Drowned City]]''': Utzaal, wretched and drowned. I'm sure I'd prefer you this way.
* '''[[Apex of Filth]]''': While I do admire darkness, filth I cannot abide.
* '''[[The Molten Vault]]''': Seems this place has long been forgootten... But is not without life.
* '''[[Temple of Kopec]]''': Blinding... Ugh.
* '''[[Utzaal]]''': —
* '''[[Aggorat]]''': Flower petals... Everywhere... Boring.
* '''[[The Black Chambers]]''': —
 
Boss:
* '''[[Mektul, the Forgemaster]]''': —
* '''[[Queen of Filth]]''': What a disgusting pig of a woman.
* '''[[Ketzuli, High Priest of the Sun]]''': I'm sure Kopec will love to see you.
* '''[[Viper Napuatzi]]''': Somehow, I've been cheated out of another kill.
* '''[[Doryani, Royal Thaumaturge]]''': A gift from Fate.


==Unique flavuor==
==Unique flavuor==
Line 269: 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 282: 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.pngBattershoutBind SpectreFile:Commiserate inventory icon.pngCommiserateFile:Concoct inventory icon.pngConcoctFile:Derance inventory icon.pngDeranceFile:Embitter inventory icon.pngEmbitterFile:Perfection inventory icon.pngPerfectionFile: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