Template:BTD4 upgrade info: Difference between revisions
No edit summary |
mNo edit summary |
||
| Line 26: | Line 26: | ||
|- | |- | ||
!Total cost | !Total cost | ||
|colspan="2"|{{BTD4 cost by difficulty|{{#cargo_query:table=btd4_towers|fields=cost_M|where=name="{{{tower}}}"}}+{{#cargo_query:table=btd4_upgrades|fields=CONCAT(SUM(cost_M))|group by=tower|where=tower="{{{tower}}}" AND tier<="{{{tier}}}"|no html}}}} | |colspan="2"|{{BTD4 cost by difficulty|{{#expr:{{#cargo_query:table=btd4_towers|fields=cost_M|where=name="{{{tower}}}"}}+{{#cargo_query:table=btd4_upgrades|fields=CONCAT(SUM(cost_M))|group by=tower|where=tower="{{{tower}}}" AND tier<="{{{tier}}}"|no html}}}}}} | ||
|- | |- | ||
!Sell value | !Sell value | ||
|colspan="2"|({{BTD4 cost by difficulty|{{#cargo_query:table=btd4_towers|fields=cost_M|where=name="{{{tower}}}"}}*0.8)+{{#cargo_query:table=btd4_upgrades|fields=ROUND(SUM(cost_M*0.8),0)|group by=tower|where=tower="{{{tower}}}" AND tier<="{{{tier}}}"|no html}}}} | |colspan="2"|({{BTD4 cost by difficulty|{{#expr:({{#cargo_query:table=btd4_towers|fields=cost_M|where=name="{{{tower}}}"}}*0.8)+{{#cargo_query:table=btd4_upgrades|fields=ROUND(SUM(cost_M*0.8),0)|group by=tower|where=tower="{{{tower}}}" AND tier<="{{{tier}}}"|no html}}}}}} | ||
|} | |} | ||
|- | |- | ||