Template:BATTD upgrade info: Difference between revisions

(5 intermediate revisions by one other user not shown)

Line 3:

|-

|

{|class="~~info-sub~~ main centered-cells"

{|class="subtable main centered-cells"

|style="text-align:center"|[[File:{{{image}}}|100px]]

|-

|{{{description}}}

|}

{|class="~~info-sub~~"

{|class="subtable"

![[Character]]

|colspan="2"|[[{{{tower}}} (BATTD)|{{{tower}}}]]

Line 23:

|-

!Prerequisites

|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=~~main_mk~~, battd_upgrades__previous, battd_upgrades=~~prerequisites_mk~~

|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=main_table, battd_upgrades__previous, battd_upgrades=prerequisites_table

|join on = ~~main_mk~~._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=~~prerequisites_mk~~.id

|join on = main_table._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_table.id

|fields=CONCAT("[[", ~~prerequisites_mk~~._pageName, "|", ~~prerequisites_mk~~.name, "]]") = text

|fields=CONCAT("[[", prerequisites_table._pageName, "|", prerequisites_table.name, "]]") = text

|where=~~main_mk~~.id = "{{{id|x}}}"

|where=main_table.id = "{{{id|x}}}" AND NOT prerequisites_table.unused

|format=ul

|default=―

Line 32:

|-

!Prerequisite of

|colspan="2"|{{#cargo_query:table=battd_upgrades

|colspan="2"|{{#if:{{{prerequisite of|}}}|

*{{{prerequisite of}}}|{{#cargo_query:table=battd_upgrades

|fields=CONCAT("[[", _pageName, "|", name, "]]") = text

|where=previous HOLDS "{{{id|x}}}"

|where=previous HOLDS "{{{id|x}}}" AND NOT unused

|format=ul

|default=―

}}

}}}}

|}

|}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=battd_upgrades

@@ Line 3: / Line 3: @@
 |-
 |
-{|class="info-sub main centered-cells"
+{|class="subtable main centered-cells"
 |style="text-align:center"|[[File:{{{image}}}|100px]]
 |-
 |{{{description}}}
 |}
-{|class="info-sub"
+{|class="subtable"
 ![[Character]]
 |colspan="2"|[[{{{tower}}} (BATTD)|{{{tower}}}]]
@@ Line 23: / Line 23: @@
 |-
 !Prerequisites
-|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=main_mk, battd_upgrades__previous, battd_upgrades=prerequisites_mk
+|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=main_table, battd_upgrades__previous, battd_upgrades=prerequisites_table
-|join on = main_mk._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id
+|join on = main_table._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_table.id
-|fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text
+|fields=CONCAT("[[", prerequisites_table._pageName, "|", prerequisites_table.name, "]]") = text
-|where=main_mk.id = "{{{id|x}}}"
+|where=main_table.id = "{{{id|x}}}" AND NOT prerequisites_table.unused
 |format=ul
 |default=―
@@ Line 32: / Line 32: @@
 |-
 !Prerequisite of
-|colspan="2"|{{#cargo_query:table=battd_upgrades
+|colspan="2"|{{#if:{{{prerequisite of|}}}|
+*{{{prerequisite of}}}|{{#cargo_query:table=battd_upgrades
 |fields=CONCAT("[[", _pageName, "|", name, "]]") = text
-|where=previous HOLDS "{{{id|x}}}"
+|where=previous HOLDS "{{{id|x}}}" AND NOT unused
 |format=ul
 |default=―
-}}
+}}}}
 |}
 |}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=battd_upgrades