Template:Sandbox/Aurelain/HeroesNavbox: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<noinclude> | <noinclude> | ||
<pre><nowiki> | <pre><nowiki> | ||
{{Sandbox/Aurelain/HeroesNavbox|lang= | {{Sandbox/Aurelain/HeroesNavbox|lang=en}} | ||
</nowiki></pre> | </nowiki></pre> | ||
{{Sandbox/Aurelain/HeroesNavbox|lang= | {{Sandbox/Aurelain/HeroesNavbox|lang=en}} | ||
</noinclude><includeonly> | </noinclude><includeonly> | ||
{| class="wikitable mw-collapsible white-toggle-button" style="width:100%; text-align:left;" | {| class="wikitable mw-collapsible white-toggle-button" style="width:100%; text-align:left;" | ||
| Line 13: | Line 13: | ||
Translation=hero_t | Translation=hero_t | ||
|join on = H.id = hero_t.target_id | |join on = H.id = hero_t.target_id | ||
|where = H.class_type = ' | |where = H.class_type = 'magic_nature' | ||
AND hero_t.language = '{{{lang|en}}}' | |||
AND H.id NOT LIKE 'campaign%' | AND H.id NOT LIKE 'campaign%' | ||
AND H.id NOT LIKE 'tutorial%' | AND H.id NOT LIKE 'tutorial%' | ||
AND H.id NOT LIKE 'cm_fun%' | AND H.id NOT LIKE 'cm_fun%' | ||
|fields = CONCAT('hero') = type, | |fields = CONCAT('hero') = type, | ||
H.id = id, | H.id = id, | ||
