User:Crimsonfalconer

CrimsonFalconer

Query Examples

Unique Items ▾ [Expand] ▾

Unique Items

Unique Item Based on Name

{{Query unique items|where=items.name="Vessel of Vinktar"
|large=1
|stat=1
|level=1
}}

Yields:

Item		Stats
Vessel of VinktarVessel of Vinktar Topaz FlaskLasts 4.00 Seconds Consumes (54-60) of 60 Charges on use +50% to Lightning Resistance 20% less Lightning Damage takenRequires Level 68(80-100)% increased Charges used Shocks nearby Enemies during Flask effect, causing 10% increased Damage taken You are Shocked during Flask effect, causing 50% increased Damage taken 20% of Lightning Damage Leeched as Life during Flask effect <One of the five modifiers>The great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters.	68	(80-100)% increased Charges used Shocks nearby Enemies during Flask effect, causing 10% increased Damage taken You are Shocked during Flask effect, causing 50% increased Damage taken 20% of Lightning Damage Leeched as Life during Flask effect <One of the five modifiers> Adds (25-35) to (110-130) Lightning Damage to Attacks during Flask effect Adds (15-25) to (70-90) Lightning Damage to Spells during Flask effect Damage Penetrates 10% Lightning Resistance during Flask effect 20% of Physical Damage Converted to Lightning during Flask effect

Unique Items Based on Stats

{{Query unique items
|tables=item_stats
|join=items._pageID=item_stats._pageID
|where=(item_stats.id like "%gain_per_target%" OR item_stats.id like "%granted_when_hit%" OR item_stats.id like "%gained_on%hit%") AND item_stats.is_implicit=0
|large=1
|stat=1
|level=1
|q_limit=3
}}

Yields:

Item		Stats
Kaom's SignKaom's Sign Coral Ring+(20-30) to maximum Life+(10-20) to Strength +(2-4) Life gained for each Enemy hit by your Attacks +1 to Maximum Endurance ChargesA token from the sea A sign for Kaom to lead his Karui to Wraeclast.	1	+(20-30) to maximum Life+(10-20) to Strength +(2-4) Life gained for each Enemy hit by your Attacks +1 to Maximum Endurance Charges
RedbeakRedbeak Rusted SwordOne Handed Sword Quality: +20% Physical Damage: 10.2-25.5 Critical Strike Chance: 5.00% Attacks per Second: 1.71 Weapon Range: 1140% increased Global Accuracy Rating100% increased Damage when on Low Life 50% increased Physical Damage Adds 2 to 6 Physical Damage 10% increased Attack Speed +(20-30) to maximum Life +2 Life gained for each Enemy hit by AttacksAs battle calms, blood turns to rust.	1	40% increased Global Accuracy Rating100% increased Damage when on Low Life 50% increased Physical Damage Adds 2 to 6 Physical Damage 10% increased Attack Speed +(20-30) to maximum Life +2 Life gained for each Enemy hit by Attacks
Watcher's EyeWatcher's Eye Prismatic JewelLimited to: 1(4-6)% increased maximum Energy Shield (4-6)% increased maximum Life (4-6)% increased maximum Mana <Two or Three random aura modifiers>One by one, they stood their ground against a creature they had no hope of understanding, let alone defeating, and one by one, they became a part of it.Place into an allocated Jewel Socket on the Passive Skill Tree. Right click to remove from the Socket.	1	(4-6)% increased maximum Energy Shield (4-6)% increased maximum Life (4-6)% increased maximum Mana <Two or Three random aura modifiers> (1-1.5)% of Fire Damage Leeched as Life while affected by Anger Damage Penetrates (10-15)% Fire Resistance while affected by Anger +(30-50)% to Critical Strike Multiplier while affected by Anger (40-60)% increased Fire Damage while affected by Anger Gain (15-25)% of Physical Damage as Extra Fire Damage while affected by Anger (25-40)% of Physical Damage Converted to Fire Damage while affected by Anger (6-10)% of Damage taken from Mana before Life while affected by Clarity (15-20)% of Damage taken gained as Mana over 4 seconds when Hit while affected by Clarity Gain (6-10)% of Maximum Mana as Extra Maximum Energy Shield while affected by Clarity (10-15)% increased Mana Recovery Rate while affected by Clarity (10-15)% chance to Recover 10% of Mana when you use a Skill while affected by Clarity Non-Channelling Skills have -(10-5) to Total Mana Cost while affected by Clarity +(600-1000) to Armour while affected by Determination +(5-8)% Chance to Block Attack Damage while affected by Determination (5-8)% additional Physical Damage Reduction while affected by Determination You take (60-40)% reduced Extra Damage from Critical Strikes while affected by Determination (50-40)% reduced Reflected Physical Damage taken while affected by Determination Unaffected by Vulnerability while affected by Determination +(5-8)% Chance to Block Spell Damage while affected by Discipline +(20-30) Energy Shield gained for each Enemy Hit while affected by Discipline (10-15)% increased Energy Shield Recovery Rate while affected by Discipline Regenerate (1.5-2.5)% of Energy Shield per Second while affected by Discipline (30-40)% faster start of Energy Shield Recharge while affected by Discipline +(5-8)% chance to Evade Attack Hits while affected by Grace (30-50)% chance to Blind Enemies which Hit you while affected by Grace (6-10)% chance to Dodge Attack Hits while affected by Grace (10-15)% increased Movement Speed while affected by Grace Unaffected by Enfeeble while affected by Grace (5-8)% chance to Dodge Spell Hits while affected by Haste (30-50)% increased Cooldown Recovery Rate of Movement Skills used while affected by Haste Debuffs on you expire (20-15)% faster while affected by Haste You gain Onslaught for 4 seconds on Kill while affected by Haste You have Phasing while affected by Haste Unaffected by Temporal Chains while affected by Haste Adds (58-70) to (88-104) Cold Damage while affected by Hatred +(1.2-1.8)% to Critical Strike Chance while affected by Hatred Damage Penetrates (10-15)% Cold Resistance while affected by Hatred (40-60)% increased Cold Damage while affected by Hatred (25-40)% of Physical Damage Converted to Cold Damage while affected by Hatred +(18-22)% to Damage over Time Multiplier while affected by Malevolence (8-12)% increased Recovery rate of Life and Energy Shield while affected by Malevolence Unaffected by Bleeding while affected by Malevolence Unaffected by Poison while affected by Malevolence Damaging Ailments you inflict deal Damage (10-15)% faster while affected by Malevolence Cannot be Blinded while affected by Precision Gain a Flask Charge when you deal a Critical Strike while affected by Precision (40-60)% increased Attack Damage while affected by Precision (10-15)% increased Attack Speed while affected by Precision +(20-30)% to Critical Strike Multiplier while affected by Precision (8-12)% chance to deal Double Damage while using Pride 25% chance to Impale Enemies on Hit with Attacks while using Pride Impales you inflict last 2 additional Hits while using Pride (40-60)% increased Attack Physical Damage while using Pride Your Hits Intimidate Enemies for 4 seconds while you are using Pride +(30-50)% to Chaos Resistance while affected by Purity of Elements (50-40)% reduced Reflected Elemental Damage taken while affected by Purity of Elements (8-12)% of Physical Damage from Hits taken as Cold Damage while affected by Purity of Elements (8-12)% of Physical Damage from Hits taken as Fire Damage while affected by Purity of Elements (8-12)% of Physical Damage from Hits taken as Lightning Damage while affected by Purity of Elements Unaffected by Elemental Weakness while affected by Purity of Elements Immune to Ignite while affected by Purity of Fire (6-10)% of Physical Damage from Hits taken as Fire Damage while affected by Purity of Fire Unaffected by Burning Ground while affected by Purity of Fire Unaffected by Flammability while affected by Purity of Fire Immune to Freeze while affected by Purity of Ice (6-10)% of Physical Damage from Hits taken as Cold Damage while affected by Purity of Ice Unaffected by Chilled Ground while affected by Purity of Ice Unaffected by Frostbite while affected by Purity of Ice Immune to Shock while affected by Purity of Lightning (6-10)% of Physical Damage from Hits taken as Lightning Damage while affected by Purity of Lightning Unaffected by Conductivity while affected by Purity of Lightning Unaffected by Shocked Ground while affected by Purity of Lightning (0.8-1.2)% of Damage leeched as Life while affected by Vitality +(20-30) Life gained for each Enemy Hit while affected by Vitality (50-70)% increased Life Recovery from Flasks while affected by Vitality (10-15)% increased Life Recovery Rate while affected by Vitality Regenerate (1-1.5)% of Life per second while while affected by Vitality (70-100)% increased Critical Strike Chance while affected by Wrath (40-60)% increased Lightning Damage while affected by Wrath (1-1.5)% of Lightning Damage is Leeched as Energy Shield while affected by Wrath Damage Penetrates (10-15)% Lightning Resistance while affected by Wrath Gain (15-25)% of Physical Damage as Extra Lightning Damage while affected by Wrath (25-40)% of Physical Damage Converted to Lightning Damage while affected by Wrath (10-15)% increased Cast Speed while affected by Zealotry Effects of Consecrated Ground you create while affected by Zealotry Linger for 2 seconds Consecrated Ground you create while affected by Zealotry causes enemies to take (8-10)% increased Damage (100-120)% increased Critical Strike Chance against Enemies on Consecrated Ground while affected by Zealotry Critical Strikes Penetrate (8-10)% of Enemy Elemental Resistances while affected by Zealotry Gain Arcane Surge for 4 seconds when you create Consecrated Ground while affected by Zealotry 30% increased Maximum total Recovery per second from Energy Shield Leech while affected by Zealotry

Base Items ▾ [Expand] ▾

Base Items

{{Query base items
|tables=item_stats
|join=items._pageID=item_stats._pageID
|where=(item_stats.id like "additional_%dexterity%" or item_stats.id="additional_all_attributes") AND item_stats.is_implicit=1
|level=1
|stat_column1_header=Dexterity
|stat_column1_stat_format=add
|stat_column1_stat1_id=additional_dexterity
|stat_column1_stat2_id=additional_strength_and_dexterity
|stat_column1_stat3_id=additional_dexterity_and_intelligence
|stat_column1_stat4_id=additional_all_attributes
}}

Yields:

Item		Dexterity
Jade AmuletJade AmuletRequires Level 5+(20-30) to Dexterity	5	(20-30)
Citrine AmuletCitrine AmuletRequires Level 16+(16-24) to Strength and Dexterity	16	(16-24)
Turquoise AmuletTurquoise AmuletRequires Level 16+(16-24) to Dexterity and Intelligence	16	(16-24)
Onyx AmuletOnyx AmuletRequires Level 20+(10-16) to all Attributes	20	(10-16)
Lion SwordLion SwordTwo Hand Sword Physical Damage: 69-115 Critical Strike Chance: 5.00% Attacks per Second: 1.45 Weapon Range: 13Requires Level 65, 104 Str, 122 Dex+50 to Strength and Dexterity	65	50

Query Gems ▾ [Expand] ▾

Query Gems

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=skill_stats_per_level.id like "%gain_per_target%" OR skill_stats_per_level.id like "%granted_when_hit%"
|level=yes
|int=yes
|dex=yes
|str=yes
|q_sort=Has primary attribute, Has name
}}

Yields:

Skill gem
Life Gain on Hit SupportLife Gain on Hit SupportAttack, Support Icon: h Level: (1-20) Cost & Reservation Multiplier: 130%Requires Level 8Supports attack skills.Per 1% Quality:1Superior2Anomalous3Divergent+0.5 Life gained for each Enemy hit by Attacks from Supported SkillsSupported Skills deal 2% increased Damage when on Full Life+0.1 Mana gained for each Enemy hit by Attacks from Supported Skills+(6-44) Life gained for each Enemy hit by Attacks from Supported SkillsThis is a Support Gem. It does not grant a bonus to your character, but to skills in sockets connected to it. Place into an item socket connected to a socket containing the Active Skill Gem you wish to augment. Right click to remove from a socket.		N/A	N/A	8
Poacher's MarkPoacher's MarkSpell, Duration, Curse, Mark Level: (1-20) Cost: (16-33) Mana Cast Time: 0.50 secRequires Level 24Curses a single enemy, lowering their physical damage reduction, and adding physical damage to all hits against them. Attacking the cursed enemy will grant life and mana, and killing them will grant a frenzy charge. You can only have one Mark at a time.Per 1% Quality:1Superior2Anomalous3DivergentCursed Enemies have a 0.25% chance to grant a Frenzy Charge when HitCursed enemies take 0.2% increased DamageCursed enemies have -0.25% to Physical Damage ReductionBase duration is (6-9.8) seconds Adds (6-30) to (9-45) Physical Damage to Hits against Cursed Enemies Cursed enemies have -20% to Physical Damage Reduction Cursed enemies grant (15-50) Life when Hit by Attacks Cursed enemies grant (8-25) Mana when Hit by Attacks Cursed enemies have a 100% chance to grant a Frenzy Charge when slainPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	24

Base Stats

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=0
|level=yes
|int=yes
|dex=yes
|str=yes
|default=There are currently no support skill gems with related base stats.
}}

Yields:

Quality Stats

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=1
|level=yes
|int=yes
|dex=yes
|str=yes
|default=There are currently no support skill gems with related quality stats.
}}

Yields:

Threshold Jewels

{{Skill threshold jewel list|stat_id=jewel_fireball}}