[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) No edit summary |
||
Line 7: | Line 7: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
|where = | |where = items._pageNamespace = 0 AND release_version IS NULL | ||
|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 | |where = items._pageNamespace = 0 AND items.class_id LIKE "%Skill Gem" and skill_gems.gem_tier IS NULL | ||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |fields = CONCAT('{{il{{!}}', name, '}}') = Name | ||
|format = table | |format = table | ||
Line 28: | Line 28: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
|where = items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") | |where = items._pageNamespace = 0 AND items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") | ||
|fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page | |fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page | ||
|format = table | |format = table | ||
Line 46: | Line 46: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
|where = metadata_id IS NULL AND rarity_id = "normal" | |where = items._pageNamespace = 0 AND metadata_id IS NULL AND rarity_id = "normal" | ||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |fields = CONCAT('{{il{{!}}', name, '}}') = Name | ||
|format = table | |format = table |
Revision as of 13:55, 8 April 2025
My bot MefistoBot.
My Sandbox.
Items without release_version
Table list ▾
[Expand] ▾
Gems without gem_tier
Table list ▾
[Expand] ▾
Gems with diffrent name and pageName
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 |