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;"><!-- | ||
-->[[File:{{ | |||
#switch: {{{school}}} | |||
|day=Daylight | |||
| join on = | |night=Nightshade | ||
|space=Arcane | |||
|primal=Primal | |||
| where = | |neutral=Neutral_school | ||
}}_icon.png|32px|link=]]<!-- | |||
--></th><!-- | |||
--></tr><!-- | |||
--><tr><!-- | |||
--><td><!-- | |||
-->{{#cargo_query: | |||
tables = | |||
Spell = S, | |||
Translation = T, | |||
Translation = E, | |||
| join on = | |||
S.id = T.target_id, | |||
S.id = E.target_id | |||
| where = | |||
S.school = '{{{school}}}' | |||
AND S.id not like '%_special' | |||
AND S.id not like '%astral_summon_nature%' | |||
AND S.id not like '%astral_summon_unfrozen%' | |||
| order by = | AND S.id not like '%astral_summon_unfrozen%' | ||
AND S.id not like '%astral_summon_2%' | |||
| fields = | AND S.id not like '%astral_summon_3%' | ||
AND S.id not like '%astral_summon_4%' | |||
AND S.id not like '%astral_summon_5%' | |||
AND S.id !='bonus_magic_kill_summon' | |||
AND S.id !='neutral_1_magic_back_to_garrison' | |||
AND S.id !='neutral_1_magic_mana_transfer' | |||
| format = | AND S.id !='night_bonus_magic_1_magic' | ||
AND S.id !='primal_bonus_magic_1_magic' | |||
| template = | AND T.type = 'spell' | ||
AND T.language = '{{{lang|en}}}' | |||
| named args = | AND E.type = 'spell' | ||
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
Input:
{{Sandbox/Aurelain/SpellsNavbox/row
|lang=en
|school=day
}}
Output:
![]()
}


