User:LordBlick/Sandbox/Test Item Stats: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>LordBlick
No edit summary
>LordBlick
No edit summary
 
(15 intermediate revisions by the same user not shown)
Line 14: Line 14:
}}
}}
{{#cargo_query:  
{{#cargo_query:  
  |tables=skill_stats_per_level
  |tables=skill
  <!--|tables=skill_stats_per_level, skill-->
  <!--|tables=skill_stats_per_level, skill-->
  <!--|join on=skill_stats_per_level._pageID=skill._pageID-->
  <!--|join on=skill_stats_per_level._pageID=skill._pageID-->
  |fields=skill.active_skill_name, skill.cast_time, skill.description, skill.has_percentage_mana_cost, skill.has_reservation_mana_cost, skill.item_class_restriction, skill.max_level, skill.projectile_speed, skill.quality_stat_text, skill.radius, skill.radius_description, skill.radius_secondary, skill.radius_secondary_description, skill.radius_tertiary, skill.radius_tertiary_description, skill.skill_icon, skill.skill_id
  |fields=skill._rowID, skill._pageName, skill.active_skill_name, skill.cast_time, skill.description, skill.has_percentage_mana_cost, skill.has_reservation_mana_cost, skill.static_mana_cost, skill.item_class_restriction, skill.max_level, skill.projectile_speed, skill.quality_stat_text, skill.radius, skill.radius_description, skill.radius_secondary, skill.radius_secondary_description, skill.radius_tertiary, skill.radius_tertiary_description, skill.skill_icon, skill.skill_id
  |where=  
  |where=  
         skill._pageName="Haste"
         skill._pageName="Haste"
Line 45: Line 45:
  |limit=100
  |limit=100
}}
}}
{{#cargo_query:
|tables=item_stats, items
|join on=item_stats._pageID=items._pageID
|fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max
|where= items.name="Hinekora's Sight"
|limit=100
}}
{{#cargo_query:
|tables=item_stats, items
|join on=item_stats._pageID=items._pageID
|fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max
|where= items.name="Cloak of Tawm'r Isley"
|limit=100
}}
{{#cargo_query:
|tables=item_stats, items
|join on=item_stats._pageID=items._pageID
|fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max
|where= items.name="The Effigon"
|limit=100
}}
{{#cargo_query:
|tables=item_stats, items
|join on=item_stats._pageID=items._pageID
|fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max
|where= items.name="Eclipse Solaris"
|limit=100
}}
==Subpages==
{{Special:PrefixIndex/User:LordBlick}}

Latest revision as of 20:07, 6 March 2018

Query in Special:CargoTables/item_stats
Use of Template:Item/cargo/item_stats

Quering Item Stats for some aura gems

HasteHasteAura, Spell, AoE
Level: (1-20)
Reservation: 50% Mana
Cooldown Time: 1.20 sec
Can Store 1 Use(s)
Cast Time: Instant
AoE Radius: 36Requires Level 24Casts an aura that increases the movement speed, attack speed and cast speed of you and your allies.+(0-1.9) metres to radius
You and nearby allies gain (10-16)% increased Movement Speed
You and nearby allies gain (15-24)% increased Attack Speed
You and nearby allies gain (15-24)% increased Cast Speed

Additional Effects From 1-20% Quality:
(2-40)% increased Area of EffectPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.:
https://pathofexile.gamepedia.com/index.php?title=Special:ViewData&limit=607&offset=51139&tables=skill_stats_per_level&fields=_pageName%2Cid%2Cis_quality_stat%2Clevel%2Cvalue&order_by=%60_pageName%60%2C+%60id%60%2C+%60is_quality_stat%60%2C+%60level%60%2C+%60value%60&max+display+chars=300
I'm searching for all mana costs mods and no idea for now…

_rowID _pageName id
3,465,260 Haste base_movement_velocity_+%
3,465,261 Haste attack_speed_+%_granted_from_skill
3,465,262 Haste cast_speed_+%_granted_from_skill
Error: No field named "has_percentage_mana_cost" found for the database table "skill".

ClarityClarityAura, Spell, AoE
Level: (1-20)
Reservation: (34-279) Mana
Cooldown Time: 1.20 sec
Can Store 1 Use(s)
Cast Time: Instant
AoE Radius: 36Requires Level 10Casts an aura that grants mana regeneration to you and your allies.+(0-1.9) metres to radius
You and nearby Allies Regenerate (2.9-33) Mana per second

Additional Effects From 1-20% Quality:
(2-40)% increased Area of EffectPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.:

_rowID _pageName id
3,530,192 Clarity base_mana_regeneration_rate_per_minute

Quering Item Stats for Headhunter

For sure HH exist in this table https://pathofexile.gamepedia.com/index.php?title=Special:ViewData&limit=35&offset=11007&tables=item_stats&fields=_pageName%2Cavg%2Cid%2Cis_implicit%2Cmax%2Cmin&order_by=%60_pageName%60%2C+%60avg%60%2C+%60id%60%2C+%60is_implicit%60%2C+%60max%60&max+display+chars=300

_rowID name _pageName id min max
76,751 Headhunter Headhunter damage_+%_vs_rare_monsters 20 30
76,752 Headhunter Headhunter additional_strength 40 55
76,753 Headhunter Headhunter base_maximum_life 25 40
76,754 Headhunter Headhunter base_maximum_life 50 60
76,755 Headhunter Headhunter additional_dexterity 40 55
76,756 Headhunter Headhunter gain_rare_monster_mods_on_kill_ms 20,000 20,000
_rowID name _pageName id min max
76,805 Hinekora's Sight Hinekora's Sight base_evasion_rating 600 1,000
76,806 Hinekora's Sight Hinekora's Sight additional_all_attributes 10 16
76,807 Hinekora's Sight Hinekora's Sight cannot_be_blinded 1 1
76,808 Hinekora's Sight Hinekora's Sight accuracy_rating 600 1,000
76,809 Hinekora's Sight Hinekora's Sight base_spell_damage_%_suppressed 3 3
_rowID name _pageName id min max
75,467 Cloak of Tawm'r Isley Cloak of Tawm'r Isley local_energy_shield_+% 150 200
75,468 Cloak of Tawm'r Isley Cloak of Tawm'r Isley display_socketed_minion_gems_supported_by_level_X_life_leech 16 16
75,469 Cloak of Tawm'r Isley Cloak of Tawm'r Isley magic_items_drop_identified 1 1
75,470 Cloak of Tawm'r Isley Cloak of Tawm'r Isley minions_cannot_be_blinded 1 1
75,471 Cloak of Tawm'r Isley Cloak of Tawm'r Isley minions_%_chance_to_blind_on_hit 15 15
_rowID name _pageName id min max
79,917 The Effigon The Effigon base_evasion_rating 100 150
79,918 The Effigon The Effigon attack_maximum_added_fire_damage 32 40
79,919 The Effigon The Effigon attack_minimum_added_fire_damage 18 24
79,920 The Effigon The Effigon reduce_enemy_fire_resistance_%_vs_blinded_enemies 10 10
79,921 The Effigon The Effigon base_item_found_rarity_+% 12 20
79,922 The Effigon The Effigon hits_cannot_be_evaded_vs_blinded_enemies 1 1
79,923 The Effigon The Effigon additional_dexterity 25 25
79,924 The Effigon The Effigon accuracy_rating 100 150
79,925 The Effigon The Effigon base_fire_damage_resistance_% 20 30
_rowID name _pageName id min max
76,144 Eclipse Solaris Eclipse Solaris local_minimum_added_fire_damage 30 45
76,145 Eclipse Solaris Eclipse Solaris critical_strike_chance_+%_vs_blinded_enemies 120 140
76,146 Eclipse Solaris Eclipse Solaris base_critical_strike_multiplier_+ 27 33
76,147 Eclipse Solaris Eclipse Solaris local_display_nearby_enemies_are_blinded 1 1
76,148 Eclipse Solaris Eclipse Solaris light_radius_+% 20 20
76,149 Eclipse Solaris Eclipse Solaris local_attack_speed_+% 6 10
76,150 Eclipse Solaris Eclipse Solaris spell_damage_+% 22 26
76,151 Eclipse Solaris Eclipse Solaris local_maximum_added_fire_damage 60 80

Subpages

Retrieved from "https://www.poewiki.net/index.php?title=User:LordBlick/Sandbox/Test_Item_Stats&oldid=332165"