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

From Path of Exile Wiki
Jump to navigation Jump to search
>ARTyficial
>LordBlick
No edit summary
Line 4: Line 4:
{{il|Haste}}:<br />
{{il|Haste}}:<br />
{{#cargo_query:  
{{#cargo_query:  
  |tables=mod_stats, items
  |tables=item_stats, items
  <!--|tables=mod_stats-->
  <!--|tables=item_stats-->
  <!--|join on=mod_stats._pageName=items._pageName-->
  <!--|join on=item_stats._pageName=items._pageName-->
  <!--|join on=items.mods HOLDS mod_stats._pageName-->
  <!--|join on=items.mods HOLDS item_stats._pageName-->
  <!--|join on=items.mods=mod_stats._pageName-->
  <!--|join on=items.mods=item_stats._pageName-->
  |join on=mod_stats._pageID=items._pageID
  |join on=item_stats._pageID=items._pageID
  <!--|fields=mod_stats._pageName, mod_stats.id, mod_stats.is_implicit, mod_stats.min, mod_stats.max-->
  <!--|fields=item_stats._pageName, item_stats.id, item_stats.is_implicit, item_stats.min, item_stats.max-->
  <!--|fields=mod_stats._rowID, mod_stats._pageName, mod_stats.id, mod_stats.min, mod_stats.max-->
  <!--|fields=item_stats._rowID, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max-->
  |fields=mod_stats._rowID, items.name, mod_stats._pageName, mod_stats.id, mod_stats.min, mod_stats.max
  |fields=item_stats._rowID, items.name, item_stats._pageName, item_stats.id, item_stats.min, item_stats.max
  |where=  
  |where=  
       <!--mod_stats._pageName="Haste"-->
       <!--item_stats._pageName="Haste"-->
       <!--items.name="Haste"-->
       <!--items.name="Haste"-->
       <!--items.name LIKE "%Haste%"-->
       <!--items.name LIKE "%Haste%"-->
       <!--mod_stats._pageName LIKE "%Haste%"-->
       <!--item_stats._pageName LIKE "%Haste%"-->
  |limit=10
  |limit=10
  <!--|format=template
  <!--|format=template
Line 24: Line 24:
  |outro={{Mod table with items/outro}}-->
  |outro={{Mod table with items/outro}}-->
  |order by=items.name
  |order by=items.name
  |group by=mod_stats._pageName, items._pageName
  |group by=item_stats._pageName, items._pageName
}}
}}
<!-- {{Item/cargo/item_stats
<!-- {{Item/cargo/item_stats

Revision as of 16:00, 26 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: 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.:

_rowID name _pageName id min max
74,409 Abberath's Hooves Abberath's Hooves base_chance_to_ignite_% 6 10
74,416 Abberath's Horn Abberath's Horn spell_minimum_added_fire_damage 4 6
64,593 Abhorrent Interrogation Abhorrent Interrogation local_evasion_and_energy_shield_+% 100 150
83,217 Abomination Map Map:Abomination Map (Necropolis) map_is_uber_map 1 1
81,971 Abyss Scarab Abyss Scarab map_num_extra_abysses 1 1
83,093 Abyss Scarab of Edifice Abyss Scarab of Edifice map_abyss_spawn_hoards 1 1
83,095 Abyss Scarab of Emptiness Abyss Scarab of Emptiness map_rare_abyss_monster_drop_abyss_socket_rare_% 50 50
83,092 Abyss Scarab of Multitudes Abyss Scarab of Multitudes map_abyss_monster_spawn_amount_+% 75 75
83,147 Abyss Scarab of Profound Depth Abyss Scarab of Profound Depth map_abyss_monsters_enhanced_per_chasm_closed 1 1
81,972 Abyssal Sceptre Abyssal Sceptre elemental_damage_+% 30 30

More...

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

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
Retrieved from "https://www.poewiki.net/index.php?title=User:LordBlick/Sandbox/Test_Item_Stats&oldid=332140"