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
Tag: Manual revert
(exclude sandbox)
Line 7: Line 7:
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = release_version IS NULL
|where = release_version IS NULL AND _pageName NOT LIKE "%sandbox%"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table
Line 18: Line 18:
|tables = items, skill_gems
|tables = items, skill_gems
|join on = items._pageName=skill_gems._pageName
|join on = items._pageName=skill_gems._pageName
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND _pageName NOT LIKE "%sandbox%"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table
Line 36: Line 36:
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = metadata_id IS NULL AND rarity_id = "normal"
|where = metadata_id IS NULL AND rarity_id = "normal" AND _pageName NOT LIKE "%sandbox%"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table

Revision as of 18:54, 30 March 2025

My bot MefistoBot.
My Sandbox.

Items without release_version

Table list [Expand]

Gems without gem_tier

Table list [Expand]

Unique flavuor

Table list [Expand]

Items without metadata_id

Files to fix

Big def values

Biggest defense values
Type Armour Evasion Energy Shield
Body Armour
Helmets
Gloves
Boots
Shields