Template:Query stat related skill gems: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>OmegaK2
No edit summary
>94Connor949-gpuser
No edit summary
Line 1: Line 1:
<includeonly>The following {{#ifeq: {{{type|active}}}| active
<onlyinclude><includeonly>{{#ifeq: {{{stat_page|{{PAGENAME}}}}} | {{PAGENAME}} || The following [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | active }} skill gem]]s have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page}}}]]: }}
    |[[active skill gem]]
    |[[support skill gem]]
}}s have {{#if: {{{quality|}}}
    |quality&nbsp;
    |
}}[[stat]]s related to [[{{{stat_page}}}]]:
 
{{Query skill gems
{{Query skill gems
|tables = {{{tables|skill_stats_per_level}}}
|tables = {{{tables|skill_stats_per_level}}}
|join = {{{join|items._pageID=skill_stats_per_level._pageID}}}
|join = {{{join|items._pageID=skill_stats_per_level._pageID}}}
|where =
|where =
    items.class={{#ifeq: {{{type|active}}}| active
    items.class="{{#ifeq: {{ucfirst: {{lc: {{{type|}}} }} }} | Support | Support | Active }} Skill Gems"
        |"Active Skill Gems"
AND skill_stats_per_level.is_quality_stat={{#if: {{{quality|}}} | true | false }}  
        |"Support Skill Gems"
AND ({{{where|skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"}}})
    }}
|default = There are currently no [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | active }} skill gem]]s that have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page|{{PAGENAME}}}}}]].
    AND skill_stats_per_level.is_quality_stat={{#if: {{{quality|}}}
        |true
        |false
    }}  
    AND ({{{where|skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"}}})
|default = Currently, there are no {{#ifeq: {{{type|active}}}| active
        |[[active skill gem]]
        |[[support skill gem]]
    }}s that have {{#if: {{{quality|}}}
        |quality&nbsp;
        |
    }}[[stat]]s related to [[{{{stat_page}}}]].
|q_limit=200
|q_limit=200
}}</includeonly><noinclude>{{documentation}}</noinclude>
}}</includeonly></onlyinclude>
{{documentation}}

Revision as of 19:56, 17 December 2018

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


Overview

This template will perform a query based on Template:Item table with some fields already filled out based on the parameters.

Sub templates

Parameters

Parameter Description Optional
type Type of the stat/gem to query for.

Can be either active or support

✗
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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__items`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`drop_enabled` = true AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240611140356) AND `cargo__items`.`class_id` IN ("Active Skill Gem", "Support Skill Gem") AND (`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__skill_gems`.`primary_attribute`,`cargo__items`.`name` LIMIT 200

. ru:Шаблон:Query stat related skill gems

The above documentation is transcluded from Template:Query stat related skill gems/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Query_stat_related_skill_gems&oldid=896208"