[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) m (→Unique flavuor) |
||
| (57 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|release_version}} | |||
{{#cargo_query: | |||
|tables = items | |||
|where = release_version IS NULL AND items._pageNamespace = 0 | |||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |||
|format = table | |||
}} | |||
{{Collapse bottom}} | |||
==Gems without gem_tier== | |||
{{Collapse top|Table list|gem_tier}} | |||
{{#cargo_query: | |||
|tables = items, skill_gems | |||
|join on = items._pageName=skill_gems._pageName | |||
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND items._pageNamespace = 0 | |||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |||
|format = table | |||
}} | |||
{{Collapse bottom}} | |||
==Unique items without flavuor== | |||
{{Collapse top|Table list|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" ) | |||
}} | |||
{{Collapse bottom}} | |||
==Items without metadata_id== | |||
{{Collapse top|Table list|metadata_id}} | |||
{{#cargo_query: | |||
|tables = items | |||
|where = metadata_id IS NULL AND rarity_id = "normal" AND items._pageNamespace = 0 | |||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |||
|format = table | |||
}} | |||
{{Collapse bottom}} | |||
==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}} | |||
==Big def values== | ==Big def values== | ||
| Line 199: | Line 249: | ||
|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 212: | Line 262: | ||
|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 19:47, 30 March 2025
My bot MefistoBot.
My Sandbox.
Items without release_version
Table list ▾
[Expand] ▾
Gems without gem_tier
Table list ▾
[Expand] ▾
Unique items without flavuor
Table list ▾
[Expand] ▾
Items without metadata_id
Files to fix
Spark
Falling Thunder
Uncut Skill Gem- Uncut Skill Gem
The Trail of Corruption
Balbala's Barya
The Last Flame
Heartbound Loop
Big def values
| Type | Armour | Evasion | Energy Shield |
|---|---|---|---|
| Body Armour | |||
| Helmets | |||
| Gloves | |||
| Boots | |||
| Shields |
