Template:Sandbox/Aurelain/SpellsNavbox/row: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
< | <includeonly><!-- | ||
--><tr><!-- | |||
--><th style='padding:4px; color:#fff; background:{{ | |||
#switch: {{{school}}} | |||
|day=#62410F | |||
|night=#3F1B52 | |||
|space=#1C444F | |||
|primal=#67281B | |||
|neutral=#383765 | |||
}}'><!-- | |||
-->[[File:{{ | |||
#switch: {{{school}}} | |||
|day=Daylight | |||
|night=Nightshade | |||
|space=Arcane | |||
|primal=Primal | |||
|neutral=Neutral_school | |||
}}_icon.png|32px|link=]] {{ | |||
#switch: {{{school}}} | |||
|neutral={{Label|spellbox_neutral|{{{lang}}}|nolink}} | |||
{{ | |#default={{Link|id=skill_magic_{{{school}}}|type=skill|lang={{{lang}}}|color=white}} | ||
|lang= | |||
| | |||
}} | }} | ||
</nowiki></ | <!-- | ||
--></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%' | |||
AND S.id not like '%astral_summon_unfrozen%' | |||
AND S.id not like '%astral_summon_2%' | |||
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' | |||
AND S.id !='night_bonus_magic_1_magic' | |||
AND S.id !='primal_bonus_magic_1_magic' | |||
AND T.type = 'spell' | |||
AND T.language = '{{{lang|en}}}' | |||
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><noinclude> | |||
{{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/SpellsNavbox/row|lang=en|school=day}}</nowiki></code> | |||
Output: | {{Color|lime|Output:}} {{Sandbox/Aurelain/SpellsNavbox/row|lang=en|school=day}} | ||
{{Sandbox/Aurelain/SpellsNavbox/row | |||
|lang=en | |||
|school=day | |||
</noinclude | </noinclude> | ||
