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
Line 7: Line 7:


{{#cargo_query:  
{{#cargo_query:  
  |tables=skill_stats_per_level, skill<!--, items-->
  |tables=skill_stats_per_level
<!--|tables=skill_stats_per_level, skill, items-->
  |fields=skill_stats_per_level._rowID, skill_stats_per_level._pageName, skill_stats_per_level.id
|join on=skill_stats_per_level._pageID=skill._pageID
<!--|join on=skill_stats_per_level._pageID=items._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, skill.stat_text, skill_stats_per_level._rowID, skill_stats_per_level._pageName, skill_stats_per_level.id
  |where=  
  |where=  
         skill_stats_per_level._pageName="Haste"
         skill_stats_per_level._pageName="Haste"
     AND skill_stats_per_level.level="1"
     AND skill_stats_per_level.level="1"
  |limit=100
}}
  <!--|format=template
{{#cargo_query:
|template=Mod table with items
  |tables=skill_stats_per_level
|intro={{Mod table with items/intro}}
  <!--|tables=skill_stats_per_level, skill-->
|outro={{Mod table with items/outro}}-->
  <!--|join on=skill_stats_per_level._pageID=skill._pageID-->
  <!--|order by=items.name-->
  |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
  <!--|group by=skill_stats_per_level._pageName, items._pageName-->
|where=
        skill._pageName="Haste"
    <!--AND skill_stats_per_level.level="1"-->
}}
}}



Revision as of 14:36, 27 January 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: 36
Requires 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 Effect
Place 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,127,648 Haste base_movement_velocity_+%
3,127,649 Haste attack_speed_+%_granted_from_skill
3,127,650 Haste cast_speed_+%_granted_from_skill
Error: Invalid table alias "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: 36
Requires 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 Effect
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
:

_rowID _pageName id
3,118,409 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
29,760 Headhunter Headhunter damage_+%_vs_rare_monsters 20 30
29,761 Headhunter Headhunter additional_strength 40 55
29,762 Headhunter Headhunter base_maximum_life 25 40
29,763 Headhunter Headhunter base_maximum_life 50 60
29,764 Headhunter Headhunter additional_dexterity 40 55
29,765 Headhunter Headhunter gain_rare_monster_mods_on_kill_ms 20,000 20,000