Template:Sandbox/Aurelain/SpellsNavbox/row: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 17: Line 17:
</noinclude><includeonly><!--
</noinclude><includeonly><!--
####################################################################
####################################################################
-->{{#cargo_query:
    --><tr><!--
tables =
        --><th colspan='2' style="text-align:center; letter-spacing:.3px;"><!--
    Spell = S,
            -->[[File:{{
    Translation = T,
#switch: {{{school}}}
    Translation = E,
|day=Daylight
| join on =
|night=Nightshade
    S.id = T.target_id,
|space=Arcane
    S.id = E.target_id
|primal=Primal
| where =
|neutral=Neutral_school
    S.school = '{{{school}}}'
}}_icon.png|32px|link=]]<!--
    AND S.id not like '%_special'
        --></th><!--
    AND S.id not like '%astral_summon_nature%'
    --></tr><!--
    AND S.id not like '%astral_summon_unfrozen%'
    --><tr><!--
    AND S.id not like '%astral_summon_unfrozen%'
        --><td><!--
    AND S.id not like '%astral_summon_2%'
            -->{{#cargo_query:
    AND S.id not like '%astral_summon_3%'
            tables =
    AND S.id not like '%astral_summon_4%'
              Spell = S,
    AND S.id not like '%astral_summon_5%'
              Translation = T,
    AND S.id !='bonus_magic_kill_summon'
              Translation = E,
    AND S.id !='neutral_1_magic_back_to_garrison'
            | join on =
    AND S.id !='neutral_1_magic_mana_transfer'
              S.id = T.target_id,
    AND S.id !='night_bonus_magic_1_magic'
              S.id = E.target_id
    AND S.id !='primal_bonus_magic_1_magic'
            | where =
    AND T.type = 'spell'
              S.school = '{{{school}}}'
    AND T.language = '{{{lang|en}}}'
              AND S.id not like '%_special'
    AND E.type = 'spell'
              AND S.id not like '%astral_summon_nature%'
    AND E.language = 'en'
              AND S.id not like '%astral_summon_unfrozen%'
| order by =
              AND S.id not like '%astral_summon_unfrozen%'
    S.rank ASC, S.id ASC
              AND S.id not like '%astral_summon_2%'
| fields =
              AND S.id not like '%astral_summon_3%'
    S.id = id,
              AND S.id not like '%astral_summon_4%'
    S.icon = icon,
              AND S.id not like '%astral_summon_5%'
    T.language = lang,
              AND S.id !='bonus_magic_kill_summon'
    T.name = name,
              AND S.id !='neutral_1_magic_back_to_garrison'
    E.name = name_en
              AND S.id !='neutral_1_magic_mana_transfer'
| format =
              AND S.id !='night_bonus_magic_1_magic'
    template
              AND S.id !='primal_bonus_magic_1_magic'
| template =
              AND T.type = 'spell'
    Sandbox/Aurelain/SpellsNavbox/spell
              AND T.language = '{{{lang|en}}}'
| named args =
              AND E.type = 'spell'
    yes
              AND E.language = 'en'
}}<!--
            | order by =
              S.rank ASC, S.id ASC
            | fields =
              S.id = id,
              S.icon = icon,
              T.language = lang,
              T.name = name,
              E.name = name_en
            | format =
              template
            | template =
              Sandbox/Aurelain/SpellsNavbox/spell
            | named args =
              yes
            }}<!--
        --></td><!--
    --></tr><!--
####################################################################
####################################################################
--></includeonly>
--></includeonly>

Revision as of 14:29, 23 June 2026