Template:Sandbox/Aurelain/HeroesWithSpell: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
Hero = H, | Hero = H, | ||
Translation = T, | Translation = T, | ||
Translation = E | Translation = E, | ||
Hero__start_magics = SM | |||
| join on = | | join on = | ||
H.id = T.target_id, | H.id = T.target_id, | ||
H.id = E.target_id | H.id = E.target_id, | ||
H._pageName = SM._pageName | |||
| where = | | where = | ||
(H.start_magics HOLDS '{{{id}}}' OR H.start_magics HOLDS '{{{id}}}_special') | <!-- (H.start_magics HOLDS '{{{id}}}' OR H.start_magics HOLDS '{{{id}}}_special') --> | ||
SM._value IN ('{{{id}}}', '{{{id}}}_special') | |||
AND H.id NOT LIKE 'campaign%' | AND H.id NOT LIKE 'campaign%' | ||
AND H.id NOT LIKE 'tutorial%' | AND H.id NOT LIKE 'tutorial%' | ||
| Line 24: | Line 27: | ||
T.name = text, | T.name = text, | ||
T.language = lang, | T.language = lang, | ||
IF (H.start_magics LIKE '%_special', 'yellow', "") = color | <!-- IF (H.start_magics LIKE '%_special', 'yellow', "") = color --> | ||
IF(SM._value LIKE '%_special%', 'yellow', "") = color | |||
| format = | | format = | ||
template | template | ||
Revision as of 10:47, 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=-,
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,
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=-,
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
