Template:Navbox Support Gems: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(Multi-column layout for better readability)
>Illviljan
mNo edit summary
Line 5: Line 5:
|group1 = Dexterity Skills
|group1 = Dexterity Skills
|list1 = {{Simple item list
|list1 = {{Simple item list
|q_tables = skill_gems
|q_tables = skill, skill_gems
|q_join = items._pageID=skill_gems._pageID
|q_join = items._pageID=skill._pageID, items._pageID=skill_gems._pageID
|q_where = items.class_id="Support Skill Gem" AND skill_gems.dexterity_percent > 50
|q_where = items.class_id="Support Skill Gem" AND skill.skill_id NOT LIKE "%Plus" AND skill_gems.dexterity_percent > 50
|no_html = 1
|no_html = 1
}}
}}
Line 13: Line 13:
|group2 = Intelligence Skills
|group2 = Intelligence Skills
|list2 = {{Simple item list
|list2 = {{Simple item list
|q_tables = skill_gems
|q_tables = skill, skill_gems
|q_join = items._pageID=skill_gems._pageID
|q_join = items._pageID=skill._pageID, items._pageID=skill_gems._pageID
|q_where = items.class_id="Support Skill Gem" AND skill_gems.intelligence_percent > 50
|q_where = items.class_id="Support Skill Gem" AND skill.skill_id NOT LIKE "%Plus" AND skill_gems.intelligence_percent > 50
|no_html = 1  
|no_html = 1  
}}
}}
Line 21: Line 21:
|group3 = Strength Skills
|group3 = Strength Skills
|list3 = {{Simple item list
|list3 = {{Simple item list
|q_tables = skill_gems
|q_tables = skill, skill_gems
|q_join = items._pageID=skill_gems._pageID
|q_join = items._pageID=skill._pageID, items._pageID=skill_gems._pageID
|q_where = items.class_id="Support Skill Gem" AND skill_gems.strength_percent > 50
|q_where = items.class_id="Support Skill Gem" AND skill.skill_id NOT LIKE "%Plus" AND skill_gems.strength_percent > 50
|no_html = 1
|no_html = 1
}}
}}
Line 29: Line 29:
|group4 = Other Skills
|group4 = Other Skills
|list4 = {{Simple item list
|list4 = {{Simple item list
|q_tables=skill_gems
|q_tables = skill, skill_gems
|q_join=items._pageID=skill_gems._pageID
|q_join = items._pageID=skill._pageID, items._pageID=skill_gems._pageID
|q_where=items.class_id="Support Skill Gem" AND skill_gems.dexterity_percent < 35 AND skill_gems.strength_percent < 35 AND skill_gems.intelligence_percent < 35  
|q_where = items.class_id="Support Skill Gem" AND skill.skill_id NOT LIKE "%Plus" AND skill_gems.dexterity_percent < 35 AND skill_gems.strength_percent < 35 AND skill_gems.intelligence_percent < 35  
|no_html=1
|no_html=1
}}
}}
* [[Active skill gem]]
* [[Active skill gem]]
* [[Vaal skill gem]]
* [[Vaal skill gem]]
* [[Awakened support skill gem]]
}}
}}



Revision as of 07:55, 14 December 2019


Template documentation[view] [edit] [history] [purge]