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


=[[Witch]]=
==Items without release_version==
==Dialogues==
{{Collapse top|Table list}}
===Entering locations===
{{#cargo_query:
====Act 1====
|tables = items
* '''[[The Riverbank]]''': I will not join the dead today.
|where = release_version IS NULL
* '''[[Clearfell Encampment]]''': Is this all that remains?
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
* '''[[Clearfell]]''': —
|format = table
* '''[[Mud Burrow]]''': A descent into darkness. I wouldn't have it any other way.
}}
* '''[[The Grelwood]]''': The Grelwood has turned foul... I think I prefer it this way.
{{Collapse bottom}}
* '''[[The Red Vale]]''': Blood, bones, and rust... death in abundance.
* '''[[The Grim Tangle]]''': The roots here have a mind of their own. I'll need to convince them to part for me.
* '''[[Cemetery of the Eternals]]''': —
* '''[[Mausoleum of the Praetor]]''': Dreadful Draven... Where are you hiding?
* '''[[Tomb of the Consort]]''': —
* '''[[Hunting Grounds]]''': Life and death are well balanced here... Disgusting.
* '''[[Freythorn]]''': There's an immensely disturbing energy here. Time to seek it out.
* '''[[Ogham Farmlands]]''': —
* '''[[Ogham Village]]''':
* '''[[The Manor Ramparts]]''':
* '''[[Ogham Manor]]''':


====Act 2====
==Gems without gem_tier==
* '''[[Vastiri Outskirts]]''':
{{#cargo_query:
* '''[[The Ardura Caravan]]''':
|tables = items, skill_gems
* '''[[Mawdun Quarry]]''':
|join on = items._pageName=skill_gems._pageName
* '''[[Mawdun Mine]]''':
|fields = items.name
* '''[[Traitor's Passage]]''':
|format = template
* '''[[The Halani Gates]]''':
|template = il
* '''[[Mastodon Badlands]]''':
|delimiter = ,&nbsp;
* '''[[The Bone Pits]]''':
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
* '''[[Keth]]''':
|limit = 25
* '''[[The Lost City]]''':
}}
* '''[[Buried Shrines]]''':
* '''[[Valley of the Titans]]''':
* '''[[The Titan Grotto]]''':
* '''[[Deshar]]''':
* '''[[Path of Mourning]]''':
* '''[[The Spires of Deshar]]''':
* '''[[The Dreadnought]]''':
* '''[[Dreadnought Vanguard]]''':
* '''[[Trial of the Sekhemas]]''':
 
====Act 3====
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* TBA
* '''[[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 defeated===
==Files to fix==
====Act 1====
* {{il|Spark}}
* '''[[The Bloated Miller]]''': Impresive size but little acuity. Dismal.
* {{il|Falling Thunder}}
* '''[[Beira of the Rotten Pack]]''': —
* {{il|page=Uncut Skill Gem}}
* '''[[The Devourer]]''': The raven always outsmarts the worm.
* {{il|page=Uncut Skill Gem (quest item)}}
* '''[[The Brambleghast]]''': It's a pity to end you, nibstrous weed.
* {{ql|The Trail of Corruption}}
* '''[[The Rust King]]''': Very loud and very dull.
* {{il|Balbala's Barya}}
* '''[[The Rotten Druid]]''': At least he died in a place he loved... Or some such nonsense.
* {{il|The Last Flame}}
* '''[[Draven, the Eternal Praetor]]''': Give it a rest... Your Empire is no more.
* {{il|Heartbound Loop}}
* '''[[Asinia, the Praetor's Consort]]''': I hate to put down a sister witch, but you had it coming.
* '''[[Lachlann of Endless Lament]]''': Your dreary tale is over, old man.
* '''[[The Crowbell]]''': Aww. We were just getting started.
* '''[[The King in the Mists]]''': It's never easy watching your friends turn mad. I do know how it feels.
* '''[[The Executioner]]''':
* '''[[Candlemass, the Living Rite]]''':
* '''[[Count Geonor]]''':
 
====Act 2====
* '''[[Rathbreaker]]''':
* '''[[Rudja, the Dread Engineer]]''':
* '''[[Balbala, the Traitor]]''':
* '''[[Jamanra, the Risen King]]''':
* '''[[Iktab, the Deathlord]] and [[Ekbab, Ancient Steed]]''':
* '''[[Kabala, Constrictor Queen]]''':
* '''[[The Ninth Treasure of Keth]]''':
* '''[[Azarian, the Forsaken Son]]''':
* '''[[Zalmarath, the Colossus]]''':
* '''[[Tor Gul, the Defiler]]''':
* '''[[Jamanra, the Abomination]]''':
 
====Act 3====
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* TBA
* '''[[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 305: 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 318: 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