Difference between revisions of "Template:MCNodeBreakdown"

From Dragalia Lost Wiki
Jump to navigation Jump to search
imported>Elaeagnifolia
imported>Elaeagnifolia
Line 5: Line 5:
 
-->{{#vardefine:nodeCount|{{#cargo_query:tables=MCNodes
 
-->{{#vardefine:nodeCount|{{#cargo_query:tables=MCNodes
 
|fields=COUNT(Id)
 
|fields=COUNT(Id)
|where=MC="{{#var:manaCircleName}}" AND ManaPieceType="{{{Id|}}}"
+
|where=MC="{{#var:manaCircleName}}" AND ManaPieceType="{{{Id|}}}" {{#if:{{{Floor|}}} | AND Hierarchy="{{{Floor|}}}" }}
 
|no html
 
|no html
 
}}}}<!--
 
}}}}<!--
Line 14: Line 14:
 
|HP=
 
|HP=
 
* {{#var:nodeCount}}x Upgrade HP
 
* {{#var:nodeCount}}x Upgrade HP
** Total HP: {{#expr: {{#var:hp0}}+{{#var:hp1}}+{{#var:hp2}}+{{#var:hp3}}+{{#var:hp4}}}} + {{Tooltip|{{#var:mcHpBonus}}|Bonus HP upon completing Mana Circle Floor 5}} ({{#expr: {{#var:hp0}}+{{#var:hp1}}+{{#var:hp2}}+{{#var:hp3}}+{{#var:hp4}} + {{#var:mcHpBonus}} }})
+
** Total HP: {{#if:{{{Floor|}}} | {{#var:hp{{#expr:{{{Floor|}}}-1}}}} | {{#expr: {{#var:hp0}}+{{#var:hp1}}+{{#var:hp2}}+{{#var:hp3}}+{{#var:hp4}}}} + {{Tooltip|{{#var:mcHpBonus}}|Bonus HP upon completing Mana Circle Floor 5}} ({{#expr: {{#var:hp0}}+{{#var:hp1}}+{{#var:hp2}}+{{#var:hp3}}+{{#var:hp4}} + {{#var:mcHpBonus}} }})}}
 
|Strength=
 
|Strength=
 
* {{#var:nodeCount}}x Upgrade Strength
 
* {{#var:nodeCount}}x Upgrade Strength
** Total Strength: {{#expr: {{#var:str0}}+{{#var:str1}}+{{#var:str2}}+{{#var:str3}}+{{#var:str4}}}} + {{Tooltip|{{#var:mcStrBonus}}|Bonus strength upon completing Mana Circle Floor 5}} ({{#expr: {{#var:str0}}+{{#var:str1}}+{{#var:str2}}+{{#var:str3}}+{{#var:str4}} + {{#var:mcStrBonus}} }})
+
** Total Strength: {{#if:{{{Floor|}}} | {{#var:str{{#expr:{{{Floor|}}}-1}}}} | {{#expr: {{#var:str0}}+{{#var:str1}}+{{#var:str2}}+{{#var:str3}}+{{#var:str4}}}} + {{Tooltip|{{#var:mcStrBonus}}|Bonus strength upon completing Mana Circle Floor 5}} ({{#expr: {{#var:str0}}+{{#var:str1}}+{{#var:str2}}+{{#var:str3}}+{{#var:str4}} + {{#var:mcStrBonus}} }})}}
 
|HP/Str=
 
|HP/Str=
 
* {{#var:nodeCount}}x Upgrade HP/Strength (Mana Spiral)
 
* {{#var:nodeCount}}x Upgrade HP/Strength (Mana Spiral)

Revision as of 15:01, 26 December 2019