Template:UnitStinger: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
Created page with "<includeonly><!-- -->{{#cargo_query: tables = Unit = U, Translation = T |join on = S.id = T.target_id |where = T.language = '{{{lang}}}' AND T.type = 'unit' AND (S.id = "{{#replace|{{#replace|{{{id}}}|_upg|}}|_alt|}}" OR S.id = "{{#replace|{{#replace|{{{id}}}|_upg|}}|_alt|}}_upg" OR S.id = "{{#replace|{{#replace|{{{id}}}|_upg|}}|_alt|}}_upg_alt") |fields = GROUP_CONCAT(T.name SEPARATOR '~') = names, GROUP_CONCAT(U.faction SEPARATOR '~')..." |
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 | AND (S.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}" | ||
OR S.id = "{{#replace | OR S.id = "{{#replace:{{#replace:{{{id}}}|_upg|}}|_alt|}}_upg" | ||
OR S.id = "{{#replace | OR S.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:09, 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.
