Template:Sandbox/Aurelain/HeroesWithSpell: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
← Older editNewer edit →
No edit summary
No edit summary
Line 24: Line 24:
     T.name = text,
     T.name = text,
     T.language = lang,
     T.language = lang,
     IF (H.start_magics HOLDS '_special', 'yellow', "") = color
     IF (H.start_magics LIKE '%_special', 'yellow', "") = color
| format =
| format =
     template
     template

Revision as of 10:41, 28 June 2026


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 'H.start_magics' in 'SELECT'

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 (`H`.`start_magics` 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`)) WHERE (`H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= 'night_6_magic_deaths_grip') OR `H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= '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 'H.start_magics' in 'SELECT'

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 (`H`.`start_magics` 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`)) WHERE (`H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= 'night_6_magic_deaths_grip') OR `H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= '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 'H.start_magics' in 'SELECT'

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 (`H`.`start_magics` 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`)) WHERE (`H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= 'foo') OR `H`.`_ID` IN (SELECT `_rowID` FROM `mw4v_cargo__Hero__start_magics` WHERE `_value`= '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


Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:Sandbox/Aurelain/HeroesWithSpell&oldid=27136"