Template:Skills navbox: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
m (fixing minor typos in sql code causing dex gems to not be fetched)
No edit summary
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{navbox
{{Navbox
|name = Navbox Skills
|name = Navbox Skills
|title = [[Skill gem]]s
|title = [[Skill]]s
|listclass = plainlist multicol-15
|listclass = hlist
|group1 = Dexterity skills
|group1 = Skills
|list1 = {{Simple item list
|list1 =  
|q_tables = skill_gems, skill_gems__gem_tags
* [[Skill gem]]
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
* [[Transfigured skill gem]]
|q_where = items.class_id="Active Skill Gem"
* [[Vaal skill]]
  AND skill_gems.dexterity_percent > 50
* [[Cost]]
  AND items._pageNamespace = 0
* [[Reservation]]
|q_groupBy = items.name
|group2 = Support
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
|list2 =  
|no_html = 1
* [[Support gem]]
}}
* [[Awakened support gem]]
<hr>
* [[Exceptional gem]]
|group2 = Intelligence skills
* [[Socket]]
|list2 = {{Simple item list
* [[Link]]
|q_tables = skill_gems, skill_gems__gem_tags
|group3 = Gem tags
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|list3 =  
|q_where = items.class_id="Active Skill Gem"
* [[AoE]]
  AND skill_gems.intelligence_percent > 50
* [[Arcane]]
  AND items._pageNamespace = 0
* [[Attack]]
|q_groupBy = items.name
* [[Aura]]
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
* [[Blessing skill|Blessing]]
|no_html = 1
* [[Blink]]
}}
* [[Bow]]
<hr>
* [[Brand]]
|group3 = Strength skills
* [[Chaining]]
|list3 = {{Simple item list
* [[Channelling]]
|q_tables = skill_gems, skill_gems__gem_tags
* [[Chaos]]
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
* [[Cold]]
|q_where = items.class_id="Active Skill Gem"
* [[Critical]]
  AND skill_gems.strength_percent > 50
* [[Curse]]
  AND items._pageNamespace = 0
* [[Duration]]
|q_groupBy = items.name
* [[Fire]]
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
* [[Golem]]
|no_html = 1
* [[Guard Skill|Guard]]
}}
* [[Herald]]
<hr>
* [[Hex]]
|group4 = Other skills
* [[Lightning]]
|list4 = {{Simple item list
* [[Link skill|Link]]
|q_tables = skill_gems, skill_gems__gem_tags
* [[Mark]]
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
* [[Melee]]
|q_where = items.class_id="Active Skill Gem"
* [[Mine]]
  AND skill_gems.dexterity_percent < 35
* [[Minion]]
  AND skill_gems.strength_percent < 35
* [[Movement]]
  AND skill_gems.intelligence_percent < 35
* [[Nova]]
  AND items._pageNamespace = 0
* [[Orb (gem tag)|Orb]]
|q_groupBy = items.name
* [[Prismatic]]
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
* [[Projectile]]
|no_html = 1
* [[Physical]]
}}
* [[Slam]]
* [[Aspect|Aspect skills]]
* [[Spell]]
* [[Vaal skill gem]]s
* [[Stance]]
* [[List of base items granting skills|Base items skills]]
* [[Strike]]
* [[Unique item skill]]s
* [[Totem]]
* [[List of glove enchantment mods|Enchantments]]
* [[Trap]]
* [[Focus]]
* [[Travel]]
* [[Call of Steel]]
* [[Trigger]]
 
* [[Vaal skill|Vaal]]
|group5 = Related items
* [[Warcry]]
|list5 =
|group4 = Lists
* [[Support gem]]s
|list4 =  
}}
* [[List of skill gems]]
 
* [[List of transfigured skill gems]]
<noinclude>
* [[List of Vaal skill gems]]
{{documentation}}
* [[List of support gems]]
<!-- Add categories and interwikis to the /doc subpage, not here! -->
* [[List of awakened support gems]]
}}<noinclude>
{{Documentation}}
</noinclude>
</noinclude>

Latest revision as of 04:22, 9 December 2023

Template documentation[view] [edit] [history] [purge]
The above documentation is transcluded from Template:Skills navbox/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Skills_navbox&oldid=1397855"