Template:Navbox Support Gems: Difference between revisions
Jump to navigation
Jump to search
Neokowloon (talk | contribs) No edit summary |
(Limit query to main namespace so that users' test pages don't get picked up.) |
||
| Line 1: | Line 1: | ||
{{navbox | {{navbox | ||
|name = Navbox Support Gems | |name = Navbox Support Gems | ||
|title = [[Support | |title = [[Support gem]]s | ||
|listclass = plainlist multicol-15 | |listclass = plainlist multicol-15 | ||
|group1 = Dexterity gems | |group1 = Dexterity gems | ||
| Line 7: | Line 7: | ||
|q_tables = skill, skill_gems | |q_tables = skill, skill_gems | ||
|q_join = items._pageID=skill._pageID, 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.skill_id NOT LIKE "%Plus" 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 | |||
AND items._pageNamespace = 0 | |||
|no_html = 1 | |no_html = 1 | ||
}} | }} | ||
| Line 15: | Line 18: | ||
|q_tables = skill, skill_gems | |q_tables = skill, skill_gems | ||
|q_join = items._pageID=skill._pageID, 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.skill_id NOT LIKE "%Plus" 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 | |||
AND items._pageNamespace = 0 | |||
|no_html = 1 | |no_html = 1 | ||
}} | }} | ||
| Line 23: | Line 29: | ||
|q_tables = skill, skill_gems | |q_tables = skill, skill_gems | ||
|q_join = items._pageID=skill._pageID, 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.skill_id NOT LIKE "%Plus" 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 | |||
AND items._pageNamespace = 0 | |||
|no_html = 1 | |no_html = 1 | ||
}} | }} | ||
| Line 31: | Line 40: | ||
|q_tables = skill, skill_gems | |q_tables = skill, skill_gems | ||
|q_join = items._pageID=skill._pageID, 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.skill_id NOT LIKE "%Plus" 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 | |||
AND items._pageNamespace = 0 | |||
|no_html=1 | |no_html=1 | ||
}} | }} | ||
* [[Awakened support | * [[Awakened support gem]]s | ||
|group5 = Related items | |group5 = Related items | ||
|list5 =* [[ | |list5 =* [[Skill gem]]s | ||
* [[Vaal skill gem]] | * [[Vaal skill gem]]s | ||
}} | }} | ||
<noinclude> | <noinclude> | ||
Revision as of 16:24, 16 October 2021
The above documentation is transcluded from Template:Navbox Support Gems/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.