Template:Query stat related skill gems: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(fix the naming of gem to inline with the new canon)
No edit summary
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<onlyinclude><includeonly>{{#ifeq: {{lc: {{{stat_page|{{PAGENAME}}}}} }} | {{lc: {{PAGENAME}} }} || The following [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | active }} skill gem]]s have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page}}}]]:<br>}}
<includeonly>The following [[{{#switch: {{{type|}}} | support = support | #default = skill}} gem]]s have [[stat]]s {{#if: {{{quality|}}} | from [[quality]]}} related to [[{{{stat_page|{{PAGENAME}}}}}|{{lc:{{PAGENAMEBASE|{{{stat_page|{{PAGENAME}}}}}}}}}]]:
 
{{Query skill gems
{{Query skill gems
|tables = {{{tables|skill, skill_stats_per_level, skill_quality_stats}}}
|tables = skill, skill_stats_per_level, skill_quality_stats
|join = {{{join|items._pageID=skill._pageID, items._pageID=skill_stats_per_level._pageID, items._pageID=skill_quality_stats._pageID}}}
|join = items._pageID=skill._pageID, items._pageID=skill_stats_per_level._pageID, items._pageID=skill_quality_stats._pageID
|where =
|where = items.class_id="{{#switch: {{{type|}}} | support = Support | #default = Active}} Skill Gem"
    items.class_id="{{#ifeq: {{ucfirst: {{lc: {{{type|}}} }} }} | Support | Support | Active }} Skill Gem"
  AND ({{{where
AND ({{{where
    | {{#if: {{{quality|}}}
    | {{#if: {{{quality|}}}  
      | skill_quality_stats.id LIKE "{{{stat_id_query|+}}}"
        | skill_quality_stats.id LIKE "{{{stat_id_query|+}}}"
      | skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"
        | skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"
    }}
    }}  
  }}})
}}})
|default = There are no {{#switch: {{{type|}}} | support = support | #default = skill}} gems that have stats {{#if: {{{quality|}}} | from quality}} related to {{lc:{{PAGENAMEBASE|{{{stat_page|{{PAGENAME}}}}}}}}}.
|default = There are currently no [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | skill }} gem]]s that have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page|{{PAGENAME}}}}}]].
}}</includeonly><noinclude>
|q_limit=200
{{Documentation}}
}}</includeonly></onlyinclude>
</noinclude>
{{documentation}}

Revision as of 21:02, 2 May 2024

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 skill gems have stats from quality related to attack speed:

GemRequired levelGem has strength requirementGem has dexterity requirementGem has intelligence requirement
Blood RageBlood RageSpell, Duration, Physical
Level: (1-20)
Cost: (12-29) Life
Cooldown Time: 1.00 sec
Can Store 1 Use(s)
Cast Time: Instant
Requires Level 16Adds a buff that deals Physical Damage over time, while increasing Attack Speed and Life Leech. Killing an enemy while this buff is active refreshes the buff duration, and can grant a Frenzy Charge.Base duration is (7.00-10.80) seconds
Grants (5-15)% increased Attack Speed
1.2% of Attack Physical Damage Leeched as Life
You take 4% of your Maximum Life per second as Physical Damage
You take 4% of your Maximum Energy Shield per second as Physical Damage
25% chance to gain a Frenzy Charge on Kill

Additional Effects From 1-20% Quality:
Grants (0.25-5)% increased Attack Speed
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
16N/AyesN/A
Cyclone of TumultCyclone of TumultAttack, AoE, Movement, Channelling, Physical, Melee
Level: (1-20)
Cost: 2 Mana
Attack Speed: 160% of base
Attack Damage: (44-59)% of base
Effectiveness of Added Damage: (44-59)%
Requires Level 28Channel this skill to move towards a targeted location while spinning constantly attacking enemies in an area around you. While channelling this skill, you cannot be knocked back.(5-28) to (8-42) Added Attack Physical Damage
10% increased Area of Effect per 0.1 metre additional Melee Strike Range
20% more Attack Speed per Stage
Gains 1 Stage every 0.5 seconds while Channelling
Maximum 6 Stages
+0.1 metres to radius per Stage
10% less Movement Speed per Stage
Lose 1 Stage every 0.5 seconds while not Channelling

Additional Effects From 1-20% Quality:
(0.25-5)% more Attack Speed per Stage
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
28yesyesN/A
Double Strike of MomentumDouble Strike of MomentumAttack, Melee, Strike
Level: (1-20)
Cost: 5 Mana
Attack Speed: 80% of base
Attack Damage: (60-95)% of base
Effectiveness of Added Damage: (60-95)%
Performs two fast strikes with a melee weapon, gaining stages which cause this skill to attack faster. All stages are lost when you move.10% more Attack Speed for each Stage
Gain a Stage at the start of each pair of swings
Maximum 10 Stages

Additional Effects From 1-20% Quality:
(0.2-4)% more Attack Speed for each Stage
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
1N/AyesN/A
FrenzyFrenzyAttack, Projectile, Melee, Strike, Bow
Level: (1-20)
Cost: 10 Mana
Attack Damage: (115-135)% of base
Effectiveness of Added Damage: (115-135)%
Requires Level 16Performs an attack that gives the character a frenzy charge if it hits. Frenzy charges increase your attack speed.5% more Attack Damage per Frenzy Charge
5% more Attack Speed per Frenzy Charge

Additional Effects From 1-20% Quality:
+(0.1-2)% more Attack Damage per Frenzy Charge
+(0.1-2)% more Attack Speed per Frenzy Charge
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
16N/AyesN/A
Frenzy of OnslaughtFrenzy of OnslaughtAttack, Projectile, Melee, Strike, Bow
Level: (1-20)
Cost: 10 Mana
Attack Damage: (115-135)% of base
Effectiveness of Added Damage: (115-135)%
Requires Level 16Performs an attack that gives the character a frenzy charge if it hits. Frenzy charges increase your attack speed.Consume all Frenzy Charges when you Hit an enemy while at maximum Frenzy Charges to gain Onslaught for 1 second per Charge consumed
5% more Attack Damage per Frenzy Charge
5% more Attack Speed per Frenzy Charge

Additional Effects From 1-20% Quality:
+(0.1-2)% more Attack Damage per Frenzy Charge
+(0.1-2)% more Attack Speed per Frenzy Charge
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
16N/AyesN/A
LacerateLacerateAttack, AoE, Physical, Melee
Level: (1-20)
Cost: 8 Mana
Attack Speed: 60% of base
Attack Damage: (100-154)% of base
Effectiveness of Added Damage: (100-154)%
AoE Radius: 38
Requires Level 12Slashes twice, releasing waves of force that damage enemies they hit. Enemies in the middle of the slashes can be hit by both. The slashes will have a chance to inflict bleeding in Blood Stance, or have a wider angle in Sand Stance. Can be used with Axes and Swords. You are in Blood Stance by default.(5-75) to (8-113) Added Attack Physical Damage
+(0-0.9) metres to radius
(50-88)% more Damage with Bleeding while in Blood Stance
25% chance to cause Bleeding while in Blood Stance
50% increased angle while in Sand Stance

Additional Effects From 1-20% Quality:
(1-20)% increased Attack Speed if you've changed Stance Recently
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
12yesyesN/A
Siege BallistaSiege BallistaAttack, Projectile, Totem, Bow
Level: (1-20)
Cost: (6-11) Mana
Attack Speed: 50% of base
Attack Damage: (100-145)% of base
Effectiveness of Added Damage: (100-145)%
Projectile Speed: 3260
Requires Level 12Summons a ballista totem that attacks with piercing arrows. Requires a Bow.Arrows Pierce (6-9) additional Targets
+(2-3) to maximum number of Summoned Totems
Totem lasts 8 seconds
Summons a Ballista Totem which uses this Skill

Additional Effects From 1-20% Quality:
(0.25-5)% increased Attack Speed per maximum Totem
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
12N/AyesN/A
Whirling BladesWhirling BladesAttack, Movement, Travel, Melee
Level: (1-20)
Cost: 10 Mana
Attack Damage: (100-150)% of base
Effectiveness of Added Damage: (100-150)%
Requires Level 10Dive through enemies, dealing weapon damage. If dual wielding attacks with both weapons, dealing the damage of both in one hit. Only works with Daggers, Claws, and One-Handed Swords. Cannot be supported by Multistrike.When Dual Wielding, Deals 75% Damage from each Weapon combined
+0.6 seconds to Attack Time

Additional Effects From 1-20% Quality:
(0.5-10)% increased Attack Speed
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
10N/Ayesyes

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