[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
No edit summary
 
(39 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]].


=Stuff=
==Items without release_version==
{{Item/sandbox
{{Collapse top|Table list}}
|rarity_id                              = normal
{{#cargo_query:
|name                                    = Unearth
|tables = items
|class_id                                = Active Skill Gem
|where = release_version IS NULL
|size_x                                  = 1
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|size_y                                  = 1
|format = table
|drop_level                              = 1
}}
|tags                                    = gem, default
{{Collapse bottom}}
|metadata_id                            =
|drop_text                              = Obtained by gemcutting.
|is_drop_restricted                      = yes
|help_text                              = Skills can be managed in the Skills Panel.
|intelligence_percent                    = 100
|gem_tags                                = Minion, AoE, Physical, Duration
|gem_description                        = Raises spikes of bone from the earth in front of you, damaging enemies. The bones of Corpses in the area are ripped out and reassembled into short-lived Bone Construct Minions that fight for you.
|active_skill_name                      =  
|item_class_id_restriction              =  
|skill_id                                = Unearth
|cast_time                              = 0.95
|required_level                          = 1
|static_cost_types                      = Mana
|static_critical_strike_chance          = 15
|stat_text                              = Deals (4–107) to (6–160) Physical Damage<br>Limit (8–20) Bone Constructs<br>Cone length is 6 metres<br>Bone Construct duration is 12 seconds


|level1                                  = True
==Gems without gem_tier==
|skill_icon                              = Unearth
{{#cargo_query:
|release_version                        = 0.1.0
|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
}}
}}


==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}}


{{Item acquisition/sandbox|}}
==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" )
}}


=Boss rewards=
==[[Act 1]]==
{| class="wikitable"
! Location !! Boss !! Reward
|-
| [[The Riverbank]] || [[The Bloated Miller]] || ??
|-
| [[Clearfell]] || [[Beira of the Rotten Pack]] || {{il|Head of the Winter Wolf}}
|-
| [[The Mud Burrow]] || [[The Devourer]] || ??
|-
| [[The Old Forest]] || [[Gerung, the Brambleghast]] || Lv.1 {{il|page=Uncut Support Gem}}
|-
| [[The Red Vale]] || [[The Rust King]] || Lv.3 {{il|page=Uncut Skill Gem}}
|-
| [[The Grim Tangle]] || [[Fungus Behemoth]] || ??
|-
| [[The Graveyard]] || [[Lachlann of Endless Lament]] || {{il|Count Lachlann's Ring}}
|-
| [[The Mausoleum]] || [[Draven, Eternal Praetor]] || {{il|Draven's Memorial Key Piece}}
|-
| [[The Tomb]] || [[Asinia, Praetor Consort]] || {{il|Asinia's Memorial Key Piece}}
|-
| [[The Hunting Grounds]] || [[The Crowbell]] || {{il|Book of Specialisation}}
|-
| [[The Canopy]] || [[The King in the Mists]] || ??
|-
| [[The Farmlands]] || ??|| ??
|-
| [[Ogham Village]] || [[The Executioner]] || [[Leitis]]
|-
| [[The Courtyard]] || ?? || ??
|-
| [[The Iron Manor]] || [[Candlemass, the Living Rite]] || {{il|Candlemass' Essence}}
|-
| [[The Iron Manor]] || [[Count Geonor]] || ??
|}
==[[Act 2]]==
{| class="wikitable"
! Location !! Boss !! Reward
|-
| [[Vastiri Outskirts]] || [[Rathbreaker]] || ??
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|-
| Example || Example || Example
|}
=Other=
==Big def values==
==Big def values==
{| class = "wikitable plainlist"
{| class = "wikitable plainlist"
Line 297: 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 310: 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"