Difference between revisions of "Template:MCFloorTotalCostItem"
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, | + | |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 | ||