Template:Sandbox/Aurelain/HeroesNavbox/Row: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
 
Line 1: Line 1:
<includeonly><!--
<includeonly><!--
-->{{#cargo_query:
-->{{#cargo_query:
  tables =
    tables =
      Hero = H,
        Hero = H,
      Translation = T,
        Translation = T,
      Translation = E
        Translation = E
  | join on =
    |join on =
      H.id = T.target_id,
        H.id = T.target_id,
      H.id = E.target_id
        H.id = E.target_id
  | where =
    |where =
      H.class_id = '{{{class}}}'
        H.class_id = '{{{class}}}'
      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%'
      AND T.type = 'hero'
        AND T.type = 'hero'
      AND T.language = '{{{lang|en}}}'
        AND T.language = '{{{lang|en}}}'
      AND E.type = 'hero'
        AND E.type = 'hero'
      AND E.language = 'en'
        AND E.language = 'en'
  | order by =
    |order by =
      H.id
        H.id
  | fields =
    |fields =
      T.language = lang,
        T.language = lang,
      H.id = id,
        H.id = id,
        'hero' = type,
         '1' = filename,
         '1' = filename,
        'hero' = type,
         '1' = stack
         '1' = stack
 
    |format = template
  | format =
    |template = LinkIcon
        template
    |named args = yes
  | template =
        LinkIcon
  | named args =
        yes
}}</includeonly><!--
}}</includeonly><!--
################################################################################
################################################################################

Latest revision as of 07:34, 2 September 2026