Template:Skill table: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<includeonly>{{#invoke:Item table|item_table |mode = skill |tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}} |join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} |where = items.is_in_game != false AND items.removal_version IS NULL AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") AND skill_gems.gem_tier IS NOT NULL {{#if: {{{where|}}} |AND ({{{where}}}) }} |orderBy = {{{orderBy|{{{orderby|skill...") |
No edit summary |
||
| (2 intermediate revisions 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 skill_gems.gem_tier IS | 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 | ||
