[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) mNo edit summary |
Mefisto1029 (talk | contribs) |
||
| (47 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== | ||
{{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" ) | |||
}} | |||
==Big def values== | ==Big def values== | ||
{| class = "wikitable plainlist" | {| class = "wikitable plainlist" | ||
| Line 206: | 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 219: | 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 |
|---|---|
 Bluetongue | — |
 Splinter of Loratta | — |
 Solar Lance | — |
 The Smiling Knight | Coming soon |
 The Vile Knight | Coming soon |
 Corona of the Red Sun | Coming soon |
Big def values
| Type | Armour | Evasion | Energy Shield |
|---|---|---|---|
| Body Armour | |||
| Helmets | |||
| Gloves | |||
| Boots | |||
| Shields |
