Template:Sandbox/Aurelain/HeroesWithSpell - Revision history

76561198048502585 at 10:49, 28 June 2026

2026-06-28T10:49:10Z

← Older revision		Revision as of 10:49, 28 June 2026
Line 24:		Line 24:
	T.name = text,		T.name = text,
	T.language = lang,		T.language = lang,
	IF(SM._value LIKE '%_special%', '~~#c8b36c~~', "") = color		IF(SM._value LIKE '%_special%', 'peru', "") = color
	\| format =		\| format =
	template		template

76561198048502585 at 10:48, 28 June 2026

2026-06-28T10:48:51Z

← Older revision		Revision as of 10:48, 28 June 2026
Line 1:		Line 1:
	<includeonly><!--		<includeonly><!--
	-->		-->{{#cargo_query:
	~~id={{{id\|-}}},lang={{{lang\|-}}},~~
	{{#cargo_query:
	tables =		tables =
	Hero = H,		Hero = H,
Line 13:		Line 11:
	H._ID = SM._rowID		H._ID = SM._rowID
	\| where =		\| where =
	~~<!-- (H.start_magics HOLDS '{{{id}}}' OR H.start_magics HOLDS '{{{id}}}_special') -->~~
	SM._value IN ('{{{id}}}', '{{{id}}}_special')		SM._value IN ('{{{id}}}', '{{{id}}}_special')
	AND H.id NOT LIKE 'campaign%'		AND H.id NOT LIKE 'campaign%'
Line 27:		Line 24:
	T.name = text,		T.name = text,
	T.language = lang,		T.language = lang,
	~~<!-- IF (H.start_magics LIKE '%_special', 'yellow', "") = color -->~~		IF(SM._value LIKE '%_special%', '#c8b36c', "") = color
	IF(SM._value LIKE '%_special%', '~~yellow~~', "") = color
	\| format =		\| format =
	template		template

76561198048502585 at 10:47, 28 June 2026

2026-06-28T10:47:45Z

← Older revision		Revision as of 10:47, 28 June 2026
Line 11:		Line 11:
	H.id = T.target_id,		H.id = T.target_id,
	H.id = E.target_id,		H.id = E.target_id,
	H.~~_pageName~~ = SM.~~_pageName~~		H._ID = SM._rowID
	\| 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') -->

76561198048502585 at 10:47, 28 June 2026

2026-06-28T10:47:03Z

← Older revision		Revision as of 10:47, 28 June 2026
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

76561198048502585 at 10:41, 28 June 2026

2026-06-28T10:41:16Z

← Older revision		Revision as of 10:41, 28 June 2026
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

76561198048502585 at 10:39, 28 June 2026

2026-06-28T10:39:20Z

← Older revision		Revision as of 10:39, 28 June 2026
Line 24:		Line 24:
	T.name = text,		T.name = text,
	T.language = lang,		T.language = lang,
	IF(H.~~id LIKE~~ '~~%special%~~', 'yellow', "") = color		IF (H.start_magics HOLDS '_special', 'yellow', "") = color
	\| format =		\| format =
	template		template

76561198048502585 at 10:38, 28 June 2026

2026-06-28T10:38:34Z

← Older revision		Revision as of 10:38, 28 June 2026
Line 28:		Line 28:
	template		template
	\| template =		\| template =
	Link/stack		Sandbox/Aurelain/Link/stack
	\| named args =		\| named args =
	yes		yes

76561198048502585 at 10:37, 28 June 2026

2026-06-28T10:37:27Z

← Older revision		Revision as of 10:37, 28 June 2026
Line 24:		Line 24:
	T.name = text,		T.name = text,
	T.language = lang,		T.language = lang,
	IF(H.id LIKE '%special%', 'yellow', '') = color		IF(H.id LIKE '%special%', 'yellow', "") = color
	\| format =		\| format =
	template		template
Line 43:		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>{{Sandbox/Aurelain/HeroesWithSpell \| id=~~primal_3_magic_wean~~}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/HeroesWithSpell \| id=night_6_magic_deaths_grip}}</nowiki></code>

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

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

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

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

	----<!--=====================================================================-->		----<!--=====================================================================-->
Line 59:		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>{{Sandbox/Aurelain/HeroesWithSpell \| id=~~neutral_magic_dimension_door~~}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/HeroesWithSpell \| id=foo}}</nowiki></code>

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

	</noinclude>		</noinclude>

76561198048502585 at 10:36, 28 June 2026

2026-06-28T10:36:22Z

← Older revision		Revision as of 10:36, 28 June 2026
Line 24:		Line 24:
	T.name = text,		T.name = text,
	T.language = lang,		T.language = lang,
	~~CASE WHEN~~ H.id LIKE '%special%' ~~THEN~~ 'yellow' ~~ELSE "" END~~ = color		IF(H.id LIKE '%special%', 'yellow', '') = color
	\| format =		\| format =
	template		template

76561198048502585 at 10:34, 28 June 2026

2026-06-28T10:34:59Z

← Older revision		Revision as of 10:34, 28 June 2026
Line 23:		Line 23:
	E.name = link,		E.name = link,
	T.name = text,		T.name = text,
	T.language = lang		T.language = lang,
			CASE WHEN H.id LIKE '%special%' THEN 'yellow' ELSE "" END = color
	\| format =		\| format =
	template		template