[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) m (→Di) |
Mefisto1029 (talk | contribs) |
||
(27 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== | ||
{{Collapse top|Table list}} | |||
=== | {{#cargo_query: | ||
|tables = items | |||
|where = release_version IS NULL | |||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |||
|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 | |||
}} | |||
==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}} | ||
* | |||
==Unique flavuor== | ==Unique flavuor== | ||
Line 230: | 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 243: | 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 |