Difference between revisions of "Template:MCFloorTotalCostItem"

From Dragalia Lost Wiki
Jump to navigation Jump to search
imported>Elaeagnifolia
(Created page with "<noinclude>{{doc}}Category:Templates</noinclude><includeonly>{{#vardefine:itemTotal|0}}<!-- ### Loop through all ManaPieceElement rows and find + sum Item -->{{#cargo_que...")
imported>Elaeagnifolia
Line 3: Line 3:
 
### Loop through all ManaPieceElement rows and find + sum Item
 
### Loop through all ManaPieceElement rows and find + sum Item
 
-->{{#cargo_query:tables=ManaPieceElement
 
-->{{#cargo_query:tables=ManaPieceElement
|fields=CONCAT("{{{1|}}}")=Item,ManaMaterialId11,ManaMaterialQuantity11,ManaMaterialId12,ManaMaterialId12,ManaMaterialId13,ManaMaterialId13,ManaMaterialId21,ManaMaterialQuantity21,ManaMaterialId22,ManaMaterialId22,ManaMaterialId23,ManaMaterialId23,ManaMaterialId31,ManaMaterialQuantity31,ManaMaterialId32,ManaMaterialId32,ManaMaterialId33,ManaMaterialId33,ManaMaterialId41,ManaMaterialQuantity41,ManaMaterialId42,ManaMaterialId42,ManaMaterialId43,ManaMaterialId43
+
|fields=CONCAT("{{{1|}}}")=Item,ManaMaterialId11,ManaMaterialQuantity11,ManaMaterialId12,ManaMaterialQuantity12,ManaMaterialId13,ManaMaterialQuantity13,ManaMaterialId21,ManaMaterialQuantity21,ManaMaterialId22,ManaMaterialQuantity22,ManaMaterialId23,ManaMaterialQuantity23,ManaMaterialId31,ManaMaterialQuantity31,ManaMaterialId32,ManaMaterialQuantity32,ManaMaterialId33,ManaMaterialQuantity33,ManaMaterialId41,ManaMaterialQuantity41,ManaMaterialId42,ManaMaterialQuantity42,ManaMaterialId43,ManaMaterialQuantity43
 
|where=ElementId="{{#replace:{{#var:manaCircleType}}|MC_|}}"
 
|where=ElementId="{{#replace:{{#var:manaCircleType}}|MC_|}}"
 
|default=0
 
|default=0

Revision as of 20:47, 25 December 2019

50px Documentation

Description

  • Adds up all the occurrences of a specified item for specific Mana Circles.