Template:Query stat related skill gems: Difference between revisions
>SirClueless (Remove old comment about SMW) |
>Illviljan mNo edit summary |
||
Line 1: | Line 1: | ||
<includeonly>The following {{#ifeq: {{{type|active}}}| active |[[active skill gem]]|[[support skill gem]]}}s have {{#if: {{{quality|}}}|quality |}}[[stat]]s related to [[{{{stat_page}}}]]: | <includeonly>The following {{#ifeq: {{{type|active}}}| active | ||
|[[active skill gem]] | |||
|[[support skill gem]] | |||
}}s have {{#if: {{{quality|}}} | |||
|quality | |||
| | |||
}}[[stat]]s related to [[{{{stat_page}}}]]: | |||
{{Item table/skill_gems | {{Item table/skill_gems | ||
|q_tables=skill_stats_per_level | |q_tables = skill_stats_per_level | ||
|q_join=items._pageID=skill_stats_per_level._pageID | |q_join = items._pageID=skill_stats_per_level._pageID | ||
|q_where=items.class={{#ifeq: {{{type|active}}}| active |"Active Skill Gems"|"Support Skill Gems"}} AND skill_stats_per_level.is_quality_stat={{#if: {{{quality|}}}| | |q_where = | ||
|q_orderBy=items.name | items.class={{#ifeq: {{{type|active}}}| active | ||
|default=Currently, there are no {{#ifeq: {{{type|active}}}| active |[[active skill gem]]|[[support skill gem]]}}s that have {{#if: {{{quality|}}}|quality |}}[[stat]]s related to [[{{{stat_page}}}]]. | |"Active Skill Gems" | ||
|"Support Skill Gems" | |||
}} | |||
AND skill_stats_per_level.is_quality_stat={{#if: {{{quality|}}} | |||
|true | |||
|false | |||
}} | |||
AND skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}" | |||
|q_orderBy = items.name | |||
|default = Currently, there are no {{#ifeq: {{{type|active}}}| active | |||
|[[active skill gem]] | |||
|[[support skill gem]] | |||
}}s that have {{#if: {{{quality|}}} | |||
|quality | |||
| | |||
}}[[stat]]s related to [[{{{stat_page}}}]]. | |||
|level=yes | |level=yes | ||
|str=yes | |str=yes |
Revision as of 15:47, 13 January 2018
Overview
This template will perform a query based on Template:Item table with some fields already filled out based on the parameters.
Sub templates
- Template:Query stat related skill gems/page to create entire wiki pages in regards to stat related queries
Parameters
Parameter | Description | Optional |
---|---|---|
type | Type of the stat/gem to query for.
Can be either |
✗
|
stat_id_query | Id(s) to query for. This is the portion inside the " " in the Cargo where clause.
|
✗
|
where | Can be specified alternatively to stat_id_query to provide your own where clause (i.e. for multiple stat ids) | ✓
|
stat_page | Wiki page to link against in the intro and default descriptions | ✗
|
quality | If set, perform the query for quality stats instead of regular stats | ✓
|
Examples
{{Query stat related skill gems |type=active |stat_id_query=%attack_speed% |stat_page=attack speed |quality=1 }}
yields:
The following active skill gems have quality stats related to attack speed:
Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__items`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class`="Active Skill Gems"
AND `cargo__skill_stats_per_level`.`is_quality_stat`=true AND `cargo__skill_stats_per_level`.`id` LIKE "%attack_speed%") AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`name` LIMIT 5000
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.