User:Angelic knight/flaskQuery: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 17: | Line 17: | ||
passive_skill_stats.id = "charges_gained_+%" | passive_skill_stats.id = "charges_gained_+%" | ||
AND passive_skills.connections__full > "" | AND passive_skills.connections__full > "" | ||
AND passive_skills.ascendancy_class | AND (passive_skills.ascendancy_class IS NULL OR passive_skills.ascendancy_class = "") | ||
AND passive_skills.is_keystone = 0 | AND passive_skills.is_keystone = 0 | ||
AND passive_skills.stat_text > "" | AND passive_skills.stat_text > "" | ||
Line 24: | Line 24: | ||
|intro={{Mod table with items/intro}} | |intro={{Mod table with items/intro}} | ||
|outro={{Mod table with items/outro}} | |outro={{Mod table with items/outro}} | ||
}} | |||
{{#cargo_query: | |||
|tables=items, flasks | |||
|join on=items._pageID=flasks._pageID | |||
|where= | |||
items.class_id LIKE "%Flask%" | |||
AND items.rarity_id = "normal" | |||
AND items.required_level >= 42 | |||
AND items.name NOT IN ('Sacred Hybrid Flask' ) | |||
|fields= | |||
items._pageName=Flask, | |||
CONCAT(ROUND(life/duration, 2))=Life/s, | |||
CONCAT(ROUND(mana/duration, 2))=Mana/s, | |||
CONCAT(ROUND(life*charges_max/charges_per_use, 0), " life")=Life capacity, | |||
CONCAT(ROUND(mana*charges_max/charges_per_use, 0), " mana")=Mana capacity, | |||
CONCAT(ROUND(life/charges_per_use, 2), " life/charge")=Life per charge, | |||
CONCAT(ROUND(mana/charges_per_use, 2), " mana/charge")=Mana per charge | |||
|order by=items.class_id DESC | |||
}} | |||
{{Item table | |||
|q_tables=items,flasks | |||
|q_join=items._pageID=flasks._pageID | |||
|q_where= | |||
items.class_id LIKE "%Flask%" | |||
AND items.rarity_id = "normal" | |||
AND items.required_level >= 42 | |||
AND items.name NOT IN ('Sacred Hybrid Flask' ) | |||
|flask_life_per_second | |||
|flask_mana_per_second | |||
|flask_life | |||
|flask_mana | |||
|flask_life_per_charge | |||
|flask_mana_per_charge | |||
}} | }} |
Latest revision as of 03:42, 12 November 2021
Flask charges gained
Name | Stats |
---|---|
Flask Charges Gained | 10% increased Flask Charges gained [1] [2] [3] |
Mana and Flask Charges Gained | 8% increased maximum Mana 10% increased Flask Charges gained [1] [2] |
Mana Flasks | 10% increased Mana Recovery from Flasks 5% increased Flask Charges gained [1] [2] |
Essence Extraction | 15% increased Mana Recovery Rate during Effect of any Mana Flask 25% increased Flask Charges gained [1] |
Replenishing Remedies | Life Flasks gain 2 Charges every 3 seconds Mana Flasks gain 2 Charges every 3 seconds 15% increased Flask Charges gained [1] |
Name | Stats |
---|---|
Flask Charges Gained | 10% increased Flask Charges gained [1] [2] [3] |
Page | Mod id | Stat text | Is used in item | Created | Modified |
---|
name | id | stat text | connections full | ascendancy class | is keystone |
---|---|---|---|---|---|
Essence Extraction | mana_mana_flask_notable2616 | 15% increased Mana Recovery Rate during Effect of any Mana Flask<br>25% increased Flask Charges gained | mastery_flask125 • mana_mana_flask2615 • mastery_flask125 | No | |
Flask Charges Gained | flask_mana325 | 10% increased Flask Charges gained | flask_mana324 • dexterity865 | No | |
Mana and Flask Charges Gained | mana551 | 8% increased maximum Mana<br>10% increased Flask Charges gained | dexterity984 • mana_flasks_notable1699 | No | |
Mana Flasks | mana_mana_flask2615 | 10% increased Mana Recovery from Flasks<br>5% increased Flask Charges gained | mana_mana_flask_notable2616 • mana_mana_flask2614 • mana_mana_flask_notable2616 | No | |
Replenishing Remedies | elemental_reflect_notable_2796 | Life Flasks gain 2 Charges every 3 seconds<br>Mana Flasks gain 2 Charges every 3 seconds<br>15% increased Flask Charges gained | mastery_attack18 • elemental_reflect_2794 • elemental_reflect_2795 • mastery_attack18 | No |
Flask | Life/s | Mana/s | Life capacity | Mana capacity | Life per charge | Mana per charge |
---|---|---|---|---|---|---|
Sanctified Mana Flask | 169.23 | 5500 mana | 157.14 mana/charge | |||
Hallowed Mana Flask | 116.67 | 3500 mana | 116.67 mana/charge | |||
Eternal Mana Flask | 257.14 | 9450 mana | 225.00 mana/charge | |||
Divine Mana Flask | 280.00 | 7350 mana | 175.00 mana/charge | |||
Sanctified Life Flask | 973.33 | 2920 life | 97.33 life/charge | |||
Hallowed Life Flask | 497.50 | 5970 life | 199.00 life/charge | |||
Eternal Life Flask | 1040.00 | 6240 life | 138.67 life/charge | |||
Divine Life Flask | 685.71 | 7200 life | 160.00 life/charge | |||
Hallowed Hybrid Flask | 348.00 | 96.00 | 3480 life | 960 mana | 87.00 life/charge | 24.00 mana/charge |
Item |
---|
Divine Life FlaskDivine Life FlaskRecovers 2400 Life over 3.50 Seconds Consumes 15 of 45 Charges on useRequires Level 60Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Divine Mana FlaskDivine Mana FlaskRecovers 1400 Mana over 5.00 Seconds Consumes 8 of 42 Charges on useRequires Level 60Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Eternal Life FlaskEternal Life FlaskRecovers 2080 Life over 2.00 Seconds Consumes 15 of 45 Charges on useRequires Level 65Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Eternal Mana FlaskEternal Mana FlaskRecovers 1800 Mana over 7.00 Seconds Consumes 8 of 42 Charges on useRequires Level 65Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Hallowed Hybrid FlaskHallowed Hybrid FlaskRecovers 480 Mana over 5.00 Seconds Recovers 1740 Life over 5.00 Seconds Consumes 20 of 40 Charges on useRequires Level 60Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Hallowed Life FlaskHallowed Life FlaskRecovers 1990 Life over 4.00 Seconds Consumes 10 of 30 Charges on useRequires Level 42Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Hallowed Mana FlaskHallowed Mana FlaskRecovers 700 Mana over 6.00 Seconds Consumes 6 of 30 Charges on useRequires Level 42Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Sanctified Life FlaskSanctified Life FlaskRecovers 1460 Life over 1.50 Seconds Consumes 15 of 30 Charges on useRequires Level 50Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |
Sanctified Mana FlaskSanctified Mana FlaskRecovers 1100 Mana over 6.50 Seconds Consumes 7 of 35 Charges on useRequires Level 50Right click to drink. Can only hold charges while in belt. Refills as you kill monsters. |