[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
Jump to navigation
Jump to search
Mefisto1029 (talk | contribs) No edit summary |
Mefisto1029 (talk | contribs) |
||
(7 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]]. | |||
==Items without release_version== | ==Items without release_version== | ||
{{Collapse top|Table list}} | |||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
Line 8: | Line 10: | ||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |fields = CONCAT('{{il{{!}}', name, '}}') = Name | ||
|format = table | |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 = , | |||
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL | |||
|limit = 25 | |||
}} | }} | ||
Line 16: | Line 31: | ||
* {{il|page=Uncut Skill Gem (quest item)}} | * {{il|page=Uncut Skill Gem (quest item)}} | ||
* {{ql|The Trail of Corruption}} | * {{ql|The Trail of Corruption}} | ||
* {{il|Balbala's Barya}} | |||
* {{il|The Last Flame}} | |||
* {{il|Heartbound Loop}} | |||
==Unique flavuor== | ==Unique flavuor== | ||
Line 220: | 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 = " | 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 233: | 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 = " | 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
Spark
Falling Thunder
Uncut Skill Gem
Uncut Skill Gem
The Trail of Corruption
Balbala's Barya
The Last Flame
Heartbound Loop
Unique flavuor
Item | Flavour text |
---|---|
![]() | — |
![]() | — |
![]() | — |
![]() | Coming soon |
![]() | Coming soon |
![]() | Coming soon |
Big def values
Type | Armour | Evasion | Energy Shield |
---|---|---|---|
Body Armour | |||
Helmets | |||
Gloves | |||
Boots | |||
Shields |