Template:UnitStinger: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 6: Line 6:
|where = T.language = '{{{lang}}}'
|where = T.language = '{{{lang}}}'
     AND T.type = 'unit'
     AND T.type = 'unit'
     AND (S.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}"
     AND (U.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}"
         OR S.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}_upg"
         OR U.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}_upg"
         OR S.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}_upg_alt")
         OR U.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}_upg_alt")
|fields = GROUP_CONCAT(T.name SEPARATOR '~') = names,
|fields = GROUP_CONCAT(T.name SEPARATOR '~') = names,
     GROUP_CONCAT(U.faction SEPARATOR '~') = factions
     GROUP_CONCAT(U.faction SEPARATOR '~') = factions

Revision as of 05:10, 2 August 2026

An intro for each unit.

1. Base

Input: {{UnitStinger | lang=en | id=esquire}}

Output:

Error: table "S" is not in list of table names or aliases.

2. Upgraded

Input: {{UnitStinger | lang=en | id=esquire_upg}}

Output:

Error: table "S" is not in list of table names or aliases.

3. Alternative

Input: {{UnitStinger | lang=en | id=esquire_upg}}

Output:

Error: table "S" is not in list of table names or aliases.

4. Russian

Input: {{UnitStinger | lang=ru | id=esquire_upg}}

Output:

Error: table "S" is not in list of table names or aliases.