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


=Template=
==Items without release_version==
==Dialogues==
{{Collapse top|Table list}}
===Entering locations===
{{#cargo_query:
====Act 1====
|tables = items
* '''[[The Riverbank]]''':  
|where = release_version IS NULL
* '''[[Clearfell Encampment]]''':
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
* '''[[Clearfell]]''':
|format = table
* '''[[Mud Burrow]]''':
}}
* '''[[The Grelwood]]''':
{{Collapse bottom}}
* '''[[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]]''':


====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
* '''[[The Halani Gates]]''' (1):
|format = template
* '''[[Traitor's Passage]]''':
|template = il
* '''[[The Halani Gates]]''' (2):
|delimiter = ,&nbsp;
* '''[[Mastodon Badlands]]''':
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
* '''[[The Bone Pits]]''':
|limit = 25
* '''[[Keth]]''':
}}
* '''[[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]]''':
* '''[[Apex of Filth]]''':
* '''[[The Molten Vault]]''':
* '''[[Temple of Kopec]]''':
* '''[[Utzaal]]''':
* '''[[Aggorat]]''':
* '''[[The Black Chambers]]''':
 
===Boss defeated===
====Act 1====
* '''[[The Bloated Miller]]''':
* '''[[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]]''':
* '''[[The Crowbell]]''':
* '''[[The King in the Mists (Freythorn)|The King in the Mists]]''':
* '''[[The Executioner]]''':
* '''[[Candlemass, the Living Rite]]''':
* '''[[Count Geonor]]''':


====Act 2====
==Files to fix==
* '''[[Rathbreaker]]''':
* {{il|Spark}}
* '''[[Rudja, the Dread Engineer]]''':
* {{il|Falling Thunder}}
* '''[[Balbala, the Traitor]]''':
* {{il|page=Uncut Skill Gem}}
* '''[[Jamanra, the Risen King]]''':
* {{il|page=Uncut Skill Gem (quest item)}}
* '''[[Ekbab, Ancient Steed]]''':
* {{ql|The Trail of Corruption}}
* '''[[Kabala, Constrictor Queen]]''':
* {{il|Balbala's Barya}}
* '''[[Azarian, the Forsaken Son]]''':
* {{il|The Last Flame}}
* '''[[Zalmarath, the Colossus]]''':
* {{il|Heartbound Loop}}
* '''[[Tor Gul, the Defiler]]''':
* '''[[Jamanra, the Abomination]]''':


====Act 3====
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* '''[[xxx]]''':
* TBA
* '''[[Mektul, the Forgemaster]]''':
* '''[[Queen of Filth]]''':
* '''[[Ketzuli, High Priest of the Sun]]''':
* '''[[Viper Napuatzi]]''':
* '''[[Doryani, Royal Thaumaturge]]''':
=[[Witch]]=
==Dialogues==
===Entering locations===
====Act 2====
* '''[[Vastiri Outskirts]]''': So... The Maraketh. Strong-minded women aplenty. I approve.
* '''[[The Ardura Caravan]]''': A roving village... How clever.
* '''[[Mawdun Quarry]]''': Seems the Faridun have been up to no good in the Hills of Mawdun...
* '''[[Mawdun Mine]]''': This lot were left down here to die... Or worse.
* '''[[The Halani Gates]]''' (1): Ugh, why have we stopped?
* '''[[Traitor's Passage]]''': Creepers and crawlers in dark spaces... How wonderful.
* '''[[The Halani Gates]]''' (2): Recent corpses... An easy distraction.
* '''[[Mastodon Badlands]]''': A place of ritual and bone... I should retire here someday.
* '''[[The Bone Pits]]''': Pit graves and necromancers. This place just gets better and better.
* '''[[Keth]]''': The skeleton city of once great culture... How adorable.
* '''[[The Lost City]]''': The once verdant city is still mostly intact... But overwhelmed with sand. Pretty.
* '''[[Buried Shrines]]''': Long forgotten Shrines... Show me your secrets.
* '''[[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===
====Act 2====
* '''[[Rathbreaker]]''': So many corpses, so little time. A shame I have to rush back to that caravan.
* '''[[Rudja, the Dread Engineer]]''': A defector... I admire those who resist tyrants.
* '''[[Balbala, the Traitor]]''': Her spirit... In a coin? How fun!
* '''[[Jamanra, the Risen King]]''': —
* '''[[Ekbab, Ancient Steed]]''': I suppose I am your better, necromancer.
* '''[[Kabala, Constrictor Queen]]''': Hmmm... A relic of Chaos it seems.
* '''[[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.
=Other=
==Unique flavuor==
==Unique flavuor==
{{Drop enabled unique item table
{{Drop enabled unique item table
Line 372: 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 385: 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