Template:HeroesWithSpell - Revision history

76561198048502585 at 10:50, 28 June 2026

2026-06-28T10:50:25Z

← Older revision		Revision as of 10:50, 28 June 2026
Line 4:		Line 4:
	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._ID = SM._rowID
	\| where =		\| where =
	(~~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 21:		Line 23:
	E.name = link,		E.name = link,
	T.name = text,		T.name = text,
	T.language = lang		T.language = lang,
			IF(SM._value LIKE '%_special', 'peru', "") = color
	\| format =		\| format =
	template		template
Line 40:		Line 43:
	1. Basic, with the {{b\|id}} of the spell:		1. Basic, with the {{b\|id}} of the spell:

	{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=~~primal_3_magic_wean~~}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=night_6_magic_deaths_grip}}</nowiki></code>

	{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=~~primal_3_magic_wean~~}}		{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=night_6_magic_deaths_grip}}

	----<!--=====================================================================-->		----<!--=====================================================================-->
Line 48:		Line 51:
	2. With {{b\|lang}}:		2. With {{b\|lang}}:

	{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=~~primal_3_magic_wean~~ \| lang=ja}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=night_6_magic_deaths_grip \| lang=ja}}</nowiki></code>

	{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=~~primal_3_magic_wean~~ \| lang=ja}}		{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=night_6_magic_deaths_grip \| lang=ja}}

	----<!--=====================================================================-->		----<!--=====================================================================-->
Line 56:		Line 59:
	3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:		3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:

	{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=~~neutral_magic_dimension_door~~}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{HeroesWithSpell \| id=foo}}</nowiki></code>

	{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=~~neutral_magic_dimension_door~~}}		{{Color\|lime\|Output:}} {{HeroesWithSpell \| id=foo}}

	</noinclude>		</noinclude>

76561198048502585 at 16:38, 27 June 2026

2026-06-27T16:38:09Z

← Older revision		Revision as of 16:38, 27 June 2026
Line 9:		Line 9:
	H.id = E.target_id		H.id = E.target_id
	\| where =		\| where =
	H.start_magics HOLDS '{{{id}}}'		(H.start_magics HOLDS '{{{id}}}' OR H.start_magics HOLDS '{{{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%'

76561198048502585: Created page with "{{#cargo_query: tables = Hero = H, Translation = T, Translation = E | join on = H.id = T.target_id, H.id = E.target_id | where = H.start_magics HOLDS '{{{id}}}' 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 = '{{{lang|en}}}' AND E.type = 'hero' AND E.language = 'en' | fields = CONCAT(E.name, '.png') = filename, E.na..."

2026-06-27T16:28:52Z

Created page with "<includeonly>{{#cargo_query: tables = Hero = H, Translation = T, Translation = E | join on = H.id = T.target_id, H.id = E.target_id | where = H.start_magics HOLDS '{{{id}}}' 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 = '{{{lang|en}}}' AND E.type = 'hero' AND E.language = 'en' | fields = CONCAT(E.name, '.png') = filename, E.na..."

New page

<includeonly>{{#cargo_query:
tables =
Hero = H,
Translation = T,
Translation = E
| join on =
H.id = T.target_id,
H.id = E.target_id
| where =
H.start_magics HOLDS '{{{id}}}'
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 = '{{{lang|en}}}'
AND E.type = 'hero'
AND E.language = 'en'
| fields =
CONCAT(E.name, '.png') = filename,
E.name = link,
T.name = text,
T.language = lang
| format =
template
| template =
Link/stack
| named args =
yes
| default =
{{Label|none|{{{lang|en}}}|nolink}}
}}</includeonly><noinclude>

This template enumerates the heroes starting with a particular spell.

===Usage===

1. Basic, with the {{b|id}} of the spell:

{{Color|yellow|Input:}} <code><nowiki>{{HeroesWithSpell | id=primal_3_magic_wean}}</nowiki></code>

{{Color|lime|Output:}} {{HeroesWithSpell | id=primal_3_magic_wean}}

----

2. With {{b|lang}}:

{{Color|yellow|Input:}} <code><nowiki>{{HeroesWithSpell | id=primal_3_magic_wean | lang=ja}}</nowiki></code>

{{Color|lime|Output:}} {{HeroesWithSpell | id=primal_3_magic_wean | lang=ja}}

----

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

{{Color|yellow|Input:}} <code><nowiki>{{HeroesWithSpell | id=neutral_magic_dimension_door}}</nowiki></code>

{{Color|lime|Output:}} {{HeroesWithSpell | id=neutral_magic_dimension_door}}

</noinclude>