User:LordBlick/Sandbox/Test Item Stats: Difference between revisions
>LordBlick No edit summary |
>LordBlick No edit summary |
||
(57 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
===Quering Item Stats for some aura gems=== | ===Quering Item Stats for some aura gems=== | ||
{{il|Haste}}:<br /> | {{il|Haste}}:<br /> | ||
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<br /> | |||
I'm searching for all mana costs mods and no idea for now… | |||
{{#cargo_query: | |||
|tables=skill_stats_per_level | |||
|fields=skill_stats_per_level._rowID, skill_stats_per_level._pageName, skill_stats_per_level.id | |||
|where= | |||
skill_stats_per_level._pageName="Haste" | |||
AND skill_stats_per_level.level="1" | |||
}} | |||
{{#cargo_query: | {{#cargo_query: | ||
|tables= | |tables=skill | ||
<!--|tables= | <!--|tables=skill_stats_per_level, skill--> | ||
<!--|join on= | <!--|join on=skill_stats_per_level._pageID=skill._pageID--> | ||
|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" | |||
<!--AND skill_stats_per_level.level="1"--> | |||
}} | }} | ||
{{il|Clarity}}:<br /> | {{il|Clarity}}:<br /> | ||
<!-- Let's try same as above if succeed --> | <!-- Let's try same as above if succeed --> | ||
{{#cargo_query: | |||
|tables=skill_stats_per_level | |||
|fields=skill_stats_per_level._rowID, skill_stats_per_level._pageName, skill_stats_per_level.id | |||
|where= | |||
skill_stats_per_level._pageName="Clarity" | |||
AND skill_stats_per_level.level="1" | |||
|limit=100 | |||
}} | |||
===Quering Item Stats for Headhunter=== | ===Quering Item Stats for Headhunter=== | ||
For sure HH exist in this table | 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 | 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<br /> | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables= | |tables=item_stats, items | ||
|join on= | |join on=item_stats._pageID=items._pageID | ||
|fields= | |fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max | ||
|where= | |where= items.name="Headhunter" | ||
|limit=100 | |||
|limit= | }} | ||
{{#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 |
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,534,323 | 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
- LordBlick
- LordBlick/Sandbox
- LordBlick/Sandbox/BlindyUnique
- LordBlick/Sandbox/List of active skill gems
- LordBlick/Sandbox/List of Skill gems listed by damage type
- LordBlick/Sandbox/Pantheon Useful Info
- LordBlick/Sandbox/Regeneration Bases
- LordBlick/Sandbox/Template:Prophecy description cargo
- LordBlick/Sandbox/test
- LordBlick/Sandbox/test2
- LordBlick/Sandbox/test3
- LordBlick/Sandbox/Test Item Stats