Template:BTD4 upgrade info: Difference between revisions

costs by difficulty
mNo edit summary
Line 18: Line 18:
</tab>
</tab>
</tabs>
</tabs>
{|class="info-sub centered-cells"
{|class="info-sub"
!Tower
!Tower
|colspan="3"|[[{{{tower}}} (BTD4)|{{{tower}}}]]
|colspan="2"|[[{{{tower}}} (BTD4)|{{{tower}}}]]
|-
|-
!Upgrade cost
!Upgrade cost
Line 26: Line 26:
|-
|-
!Total cost
!Total cost
|colspan="2"|{{BTD4 cost by difficulty|{{#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|{{#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_upgrades|fields=CONCAT(SUM(cost_M)*0.8)|group by=tower|where=tower={{{tower}}}" AND tier<={{{tier}}}|no html}}}}
|colspan="2"|{{BTD4 cost by difficulty|{{#cargo_query:table=btd4_upgrades|fields=CONCAT(SUM(cost_M)*0.8)|group by=tower|where=tower={{{tower}}}" AND tier<="{{{tier}}}"|no html}}}}
|}
|}
|}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=btd4_upgrades
|}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=btd4_upgrades