User:LordBlick/Sandbox/Test Item Stats: Difference between revisions
>LordBlick No edit summary |
>LordBlick No edit summary |
||
| Line 7: | Line 7: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=skill_stats_per_level, <!--skill,--> | |tables=skill_stats_per_level, <!--skill, items--> | ||
<!--|tables=skill_stats_per_level, skill, items--> | <!--|tables=skill_stats_per_level, skill, items--> | ||
|join on=skill_stats_per_level._pageID=items._pageID | |join on=skill_stats_per_level._pageID=items._pageID | ||
|fields=skill_stats_per_level._rowID, items.name, skill_stats_per_level._pageName, skill_stats_per_level.id | |fields=skill_stats_per_level._rowID, <!--items.name,--> skill_stats_per_level._pageName, skill_stats_per_level.id | ||
|where= | |where= | ||
skill_stats_per_level._pageName LIKE "%Haste%" | skill_stats_per_level._pageName LIKE "%Haste%" | ||
| Line 18: | Line 18: | ||
|intro={{Mod table with items/intro}} | |intro={{Mod table with items/intro}} | ||
|outro={{Mod table with items/outro}}--> | |outro={{Mod table with items/outro}}--> | ||
|order by=items.name | <!--|order by=items.name--> | ||
|group by=skill_stats_per_level._pageName, items._pageName | |group by=skill_stats_per_level._pageName<!--, items._pageName--> | ||
}} | }} | ||
<!-- {{Item/cargo/item_stats | <!-- {{Item/cargo/item_stats | ||
Revision as of 16:29, 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.
:
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
605 mods vs only one in table…
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 |
|---|---|---|---|---|---|
| 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 |