Template:Sandbox/Aurelain/HeroesWithSpell

This template enumerates the heroes starting with a particular spell.

Usage

1. Basic, with the id of the spell:

Input: {{Sandbox/Aurelain/HeroesWithSpell | id=night_6_magic_deaths_grip}}

Output: id=night_6_magic_deaths_grip,lang=-,

Error 1054: Unknown column 'SM._pageName' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`H`.`_pageID` AS `cargo_backlink_page_id_H`,CONCAT(`E`.`name`, '.png') AS `filename`,`E`.`name` AS `link`,`T`.`name` AS `text`,`T`.`language` AS `lang`,IF(`SM`.`_value` LIKE '%_special%', 'yellow', "") AS `color` FROM `mw4v_cargo__Hero` `H` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`H`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`H`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Hero__start_magics` `SM` ON ((`H`.`_pageName`=`SM`.`_pageName`)) WHERE `SM`.`_value` IN ('night_6_magic_deaths_grip', 'night_6_magic_deaths_grip_special')

   AND `H`.`id` NOT LIKE 'campaign%'
   AND `H`.`id` NOT LIKE 'tutorial%'
   AND `H`.`id` NOT LIKE 'cm_fun%'
   AND `T`.`type` = 'hero'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'hero'
   AND `E`.`language` = 'en'  ORDER BY `E`.`_pageID`,`T`.`_pageID`,`H`.`_pageID`,CONCAT(`E`.`name`, '.png'),`E`.`name` LIMIT 100

2. With lang:

Input: {{Sandbox/Aurelain/HeroesWithSpell | id=night_6_magic_deaths_grip | lang=ja}}

Output: id=night_6_magic_deaths_grip,lang=ja,

Error 1054: Unknown column 'SM._pageName' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`H`.`_pageID` AS `cargo_backlink_page_id_H`,CONCAT(`E`.`name`, '.png') AS `filename`,`E`.`name` AS `link`,`T`.`name` AS `text`,`T`.`language` AS `lang`,IF(`SM`.`_value` LIKE '%_special%', 'yellow', "") AS `color` FROM `mw4v_cargo__Hero` `H` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`H`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`H`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Hero__start_magics` `SM` ON ((`H`.`_pageName`=`SM`.`_pageName`)) WHERE `SM`.`_value` IN ('night_6_magic_deaths_grip', 'night_6_magic_deaths_grip_special')

   AND `H`.`id` NOT LIKE 'campaign%'
   AND `H`.`id` NOT LIKE 'tutorial%'
   AND `H`.`id` NOT LIKE 'cm_fun%'
   AND `T`.`type` = 'hero'
   AND `T`.`language` = 'ja'
   AND `E`.`type` = 'hero'
   AND `E`.`language` = 'en'  ORDER BY `E`.`_pageID`,`T`.`_pageID`,`H`.`_pageID`,CONCAT(`E`.`name`, '.png'),`E`.`name` LIMIT 100

3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:

Input: {{Sandbox/Aurelain/HeroesWithSpell | id=foo}}

Output: id=foo,lang=-,

Error 1054: Unknown column 'SM._pageName' in 'ON'

Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`H`.`_pageID` AS `cargo_backlink_page_id_H`,CONCAT(`E`.`name`, '.png') AS `filename`,`E`.`name` AS `link`,`T`.`name` AS `text`,`T`.`language` AS `lang`,IF(`SM`.`_value` LIKE '%_special%', 'yellow', "") AS `color` FROM `mw4v_cargo__Hero` `H` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`H`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`H`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Hero__start_magics` `SM` ON ((`H`.`_pageName`=`SM`.`_pageName`)) WHERE `SM`.`_value` IN ('foo', 'foo_special')

   AND `H`.`id` NOT LIKE 'campaign%'
   AND `H`.`id` NOT LIKE 'tutorial%'
   AND `H`.`id` NOT LIKE 'cm_fun%'
   AND `T`.`type` = 'hero'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'hero'
   AND `E`.`language` = 'en'  ORDER BY `E`.`_pageID`,`T`.`_pageID`,`H`.`_pageID`,CONCAT(`E`.`name`, '.png'),`E`.`name` LIMIT 100