Template:Query stat related skill gems

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

• 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 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)	✓
join	Override the default joins (items, skill_stats_per_level)	✓
where	Override the default tables (items, skill_stats_per_level)	✓
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 quality stats related to attack speed:

Gem
Blood RageBlood RageSpell, Duration, Physical Level: (1-20) Cost: (12-29) Life Cooldown Time: 1.00 sec Can Store 1 Use(s) Cast Time: InstantRequires 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 SpeedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	16	N/A		N/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 StagePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	28			N/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 StagePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	1	N/A		N/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 ChargePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	16	N/A		N/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 ChargePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	16	N/A		N/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: 38Requires 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 RecentlyPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	12			N/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: 3260Requires 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 TotemPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	12	N/A		N/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 SpeedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	10	N/A

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.