Template:Skills navbox: Difference between revisions
Jump to navigation
Jump to search
>ThemJohns No edit summary |
(Multi-column layout for better readability) |
||
| Line 1: | Line 1: | ||
{{navbox | {{navbox | ||
| name | |name = Navbox Skills | ||
| title = [[Active skill | |title = [[Active skill gem]]s | ||
| group1 = Dexterity Skills | |listclass = plainlist multicol-15 | ||
| list1 | |group1 = Dexterity Skills | ||
|q_tables=skill_gems, skill_gems__gem_tags | |list1 = {{Simple item list | ||
|q_join=items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | |q_tables = skill_gems, skill_gems__gem_tags | ||
|q_where=items.class="Active Skill Gems" AND skill_gems.dexterity_percent > 50 | |q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | ||
|q_groupBy=items.name | |q_where = items.class="Active Skill Gems" AND skill_gems.dexterity_percent > 50 | ||
|q_having=SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | |q_groupBy = items.name | ||
|no_html=1 | |q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | ||
|no_html = 1 | |||
}} | |||
<hr> | <hr> | ||
| group2 = Intelligence Skills | |group2 = Intelligence Skills | ||
| list2 | |list2 = {{Simple item list | ||
|q_tables=skill_gems, skill_gems__gem_tags | |q_tables = skill_gems, skill_gems__gem_tags | ||
|q_join=items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | |q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | ||
|q_where=items.class="Active Skill Gems" AND skill_gems.intelligence_percent > 50 | |q_where = items.class="Active Skill Gems" AND skill_gems.intelligence_percent > 50 | ||
|q_groupBy=items.name | |q_groupBy = items.name | ||
|q_having=SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | |q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | ||
|no_html=1 | |no_html = 1 | ||
}} | |||
<hr> | <hr> | ||
| group3 = Strength Skills | |group3 = Strength Skills | ||
| list3 | |list3 = {{Simple item list | ||
|q_tables=skill_gems, skill_gems__gem_tags | |q_tables = skill_gems, skill_gems__gem_tags | ||
|q_join=items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | |q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | ||
|q_where=items.class="Active Skill Gems" AND skill_gems.strength_percent > 50 | |q_where = items.class="Active Skill Gems" AND skill_gems.strength_percent > 50 | ||
|q_groupBy=items.name | |q_groupBy = items.name | ||
|q_having=SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | |q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | ||
|no_html=1 | |no_html = 1 | ||
}} | |||
<hr> | <hr> | ||
| group4 = Other Skills | |group4 = Other Skills | ||
| list4 | |list4 = {{Simple item list | ||
|q_tables=skill_gems, skill_gems__gem_tags | |q_tables = skill_gems, skill_gems__gem_tags | ||
|q_join=items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | |q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID | ||
|q_where=items.class="Active Skill Gems" AND skill_gems.dexterity_percent < 35 AND skill_gems.strength_percent < 35 AND skill_gems.intelligence_percent < 35 | |q_where = items.class="Active Skill Gems" AND skill_gems.dexterity_percent < 35 AND skill_gems.strength_percent < 35 AND skill_gems.intelligence_percent < 35 | ||
|q_groupBy=items.name | |q_groupBy = items.name | ||
|q_having=SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | |q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0 | ||
|no_html=1 | |no_html = 1 | ||
}} | }} | ||
* [[Support skill gem]]s | * [[Support skill gem]]s | ||
| Line 46: | Line 47: | ||
* [[List of glove enchantment mods|Enchantments]] | * [[List of glove enchantment mods|Enchantments]] | ||
* [[Focus]] | * [[Focus]] | ||
}} | }} | ||
Revision as of 00:01, 3 April 2019
The above documentation is transcluded from Template:Skills navbox/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.