Template:Skill table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
AND items.removal_version IS NULL | AND items.removal_version IS NULL | ||
AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") | AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") | ||
AND NOT (items.class_id IN ("Support Skill Gem") AND skill_gems.gem_tier IS NULL) | AND NOT (items.class_id IN ("Support Skill Gem") AND (skill_gems.gem_tier IS NULL OR items.drop_enabled = false)) | ||
{{#if: {{{where|}}} | {{#if: {{{where|}}} | ||
|AND ({{{where}}}) | |AND ({{{where}}}) | ||
}} | }} | ||
|orderBy = {{{orderBy|{{{orderby|skill_gems.primary_attribute}}}}}}, items.name | |orderBy = {{{orderBy|{{{orderby|skill_gems.gem_tier, skill_gems.primary_attribute}}}}}}, items.name | ||
|gem_tier={{{gem_tier|yes}}} | |gem_tier={{{gem_tier|yes}}} | ||
|int=yes | |int=yes | ||
