[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) (Better exclude, thx Vini) |
Mefisto1029 (talk | contribs) m (→Files to fix) |
||
| (6 intermediate revisions by the same user not shown) | |||
| 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 24: | Line 24: | ||
{{Collapse bottom}} | {{Collapse bottom}} | ||
==Unique flavuor== | ==Gems with diffrent name and pageName== | ||
{{Collapse top|Table list|name_and_pageName}} | |||
{{#cargo_query: | |||
|tables = items | |||
|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 | |||
|format = table | |||
}} | |||
{{Collapse bottom}} | |||
==Unique items without flavuor== | |||
{{Collapse top|Table list|flavuor}} | {{Collapse top|Table list|flavuor}} | ||
{{Drop enabled unique item table | {{Drop enabled unique item table | ||
| Line 36: | 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 | ||
| Line 43: | Line 53: | ||
==Files to fix== | ==Files to fix== | ||
* {{il|Spark}} | * {{il|Spark}}? | ||
* {{il|Falling Thunder}} | * {{il|Falling Thunder}}? | ||
* {{il|page=Uncut Skill Gem}} | * {{il|page=Uncut Skill Gem}}? | ||
* {{il|page=Uncut Skill Gem (quest item)}} | * {{il|page=Uncut Skill Gem (quest item)}}? | ||
* {{ql|The Trail of Corruption}} | * {{ql|The Trail of Corruption}} | ||
* {{il|Balbala's Barya}} | * {{il|Balbala's Barya}} | ||
* {{il|The Last Flame}} | * {{il|The Last Flame}} | ||
* {{il|Heartbound Loop}} | * {{il|Heartbound Loop}} | ||
* {{il|Whirling Slash}} | |||
==Big def values== | ==Big def values== | ||
Latest revision as of 20:53, 8 April 2025
My bot MefistoBot.
My Sandbox.
Items without release_version
Table list ▾
[Expand] ▾
Gems without gem_tier
Table list ▾
[Expand] ▾
| Name |
|---|
 Time Freeze |
Gems with diffrent name and pageName
Table list ▾
[Expand] ▾
Unique items without flavuor
Table list ▾
[Expand] ▾
| Item | Flavour text |
|---|---|
 Bluetongue | — |
 Tabula Rasa | Coming soon |
 Solar Lance | — |
 The Smiling Knight | Coming soon |
 The Vile Knight | Coming soon |
 Corona of the Red Sun | Coming soon |
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
Whirling Slash
Big def values
| Type | Armour | Evasion | Energy Shield |
|---|---|---|---|
| Body Armour | |||
| Helmets | |||
| Gloves | |||
| Boots | |||
| Shields |
