[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) Tag: Manual revert |
Mefisto1029 (talk | contribs) (exclude sandbox) |
||
Line 7: | Line 7: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
|where = release_version IS NULL | |where = release_version IS NULL AND _pageName NOT LIKE "%sandbox%" | ||
|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%" and skill_gems.gem_tier IS NULL | |where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND _pageName NOT LIKE "%sandbox%" | ||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |fields = CONCAT('{{il{{!}}', name, '}}') = Name | ||
|format = table | |format = table | ||
Line 36: | Line 36: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables = items | |tables = items | ||
|where = metadata_id IS NULL AND rarity_id = "normal" | |where = metadata_id IS NULL AND rarity_id = "normal" AND _pageName NOT LIKE "%sandbox%" | ||
|fields = CONCAT('{{il{{!}}', name, '}}') = Name | |fields = CONCAT('{{il{{!}}', name, '}}') = Name | ||
|format = table | |format = table |
Revision as of 18:54, 30 March 2025
My bot MefistoBot.
My Sandbox.
Items without release_version
Table list ▾
[Expand] ▾
Gems without gem_tier
Table list ▾
[Expand] ▾
Unique 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 |