Template:Sandbox/Aurelain/SkillInfobox/base: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 30: Line 30:
                     |where =
                     |where =
                         H.faction = '{{#invoke:Sandbox/Aurelain/SkillInfobox|getFaction|{{{id}}}}}'
                         H.faction = '{{#invoke:Sandbox/Aurelain/SkillInfobox|getFaction|{{{id}}}}}'
                        AND Hero.id not like "campaign%"
                        AND Hero.id not like "tutorial%"
                        AND Hero.id not like "%_fun_%"
                     |fields =
                     |fields =
                         H.id = id,
                         H.id = id,

Revision as of 06:16, 2 September 2026

0. Faction:

faction=nature,


Exclusive to heroes of
Error 1054: Unknown column 'Hero.id' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `H`.`_pageID` AS `cargo_backlink_page_id_H`,`H`.`id` AS `id`,CONCAT('en') AS `lang`,CONCAT('hero') AS `type`,CONCAT('1') AS `filename` FROM `mw4v_cargo__Hero` `H` WHERE `H`.`faction` = 'nature'

                       AND `Hero`.`id` not like "campaign%"
                       AND `Hero`.`id` not like "tutorial%"
                       AND `Hero`.`id` not like "%_fun_%"  ORDER BY `H`.`_pageID`,`H`.`id`,CONCAT('en'),CONCAT('hero'),CONCAT('1') LIMIT 100  
Internal ID
skill_faction_nature
{{Sandbox/Aurelain/SkillInfobox/base
    | lang = en
    | id = skill_faction_nature
    | epic_classes =
}}

1. English:

faction=,

{{Sandbox/Aurelain/SkillInfobox/base
    | lang = en
    | id = skill_assault
    | epic_classes = sub_class_demons_magic_2,sub_class_dungeon_might_1,sub_class_human_might_1,sub_class_nature_might_2,sub_class_undead_magic_2,sub_class_unfrozen_might_1
}}

2. Japanese:

faction=,

{{Sandbox/Aurelain/SkillInfobox/base
    | lang = ja
    | id = skill_assault
    | epic_classes = sub_class_demons_magic_2,sub_class_dungeon_might_1,sub_class_human_might_1,sub_class_nature_might_2,sub_class_undead_magic_2,sub_class_unfrozen_might_1
}}