Template:Sandbox/Aurelain/Translation - Revision history

76561198048502585 at 11:47, 6 August 2026

2026-08-06T11:47:32Z

← Older revision		Revision as of 11:47, 6 August 2026
Line 77:		Line 77:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}

			__NOTOC__
	</noinclude>		</noinclude>

76561198048502585 at 11:46, 6 August 2026

2026-08-06T11:46:35Z

← Older revision		Revision as of 11:46, 6 August 2026
Line 24:		Line 24:
	from the {{b\|Translation}} table, not just those prefixed with <code>wiki_</code>.		from the {{b\|Translation}} table, not just those prefixed with <code>wiki_</code>.

	~~== Usage ==~~

	1. English:		==1. English:==

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|en}}</nowiki></code>
Line 32:		Line 31:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en}}

	~~----~~
	2. Japanese:		==2. Japanese:==

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|ja}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|ja}}</nowiki></code>
Line 39:		Line 38:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|ja}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|ja}}

	~~----~~
	3. Missing id:		==3. Missing id:==

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|foo\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|foo\|en}}</nowiki></code>
Line 46:		Line 45:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|foo\|en}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|foo\|en}}

	~~----~~
	4. Surrounded by text, to prove this template doesn't add unexpected whitespace:		==4. Surrounded by text:==
			(to prove this template doesn't add unexpected whitespace)

	{{Color\|yellow\|Input:}} <code><nowiki>Hello{{Sandbox/Aurelain/Translation\|nature\|en}}World</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>Hello{{Sandbox/Aurelain/Translation\|nature\|en}}World</nowiki></code>
Line 53:		Line 53:
	{{Color\|lime\|Output:}} Hello{{Sandbox/Aurelain/Translation\|nature\|en}}World		{{Color\|lime\|Output:}} Hello{{Sandbox/Aurelain/Translation\|nature\|en}}World

	~~----~~
	5. With {{b\|type}}, when collisions are a concern:		==5. With {{b\|type}}:==
			(when collisions are a concern)

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|luck\|en\|type=unit_stat}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|luck\|en\|type=unit_stat}}</nowiki></code>
Line 60:		Line 61:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|luck\|en\|type=unit_stat}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|luck\|en\|type=unit_stat}}

	~~----~~
	6. With {{b\|field}}, to get the description:		==6. With {{b\|field}}:==
			(to get the description)

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}</nowiki></code>
Line 67:		Line 69:
	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}

	~~----~~
	7. Getting a rich text		==7. Getting a rich text:==
			(to prove html markup works)

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}</nowiki></code>

76561198048502585 at 11:45, 6 August 2026

2026-08-06T11:45:05Z

← Older revision		Revision as of 11:45, 6 August 2026
Line 70:		Line 70:
	7. Getting a rich text		7. Getting a rich text

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|~~demon_hero_6~~\|en\|field=description}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}</nowiki></code>

	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|~~demon_hero_6~~\|en\|field=description}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|dragon\|en\|field=description}}

	</noinclude>		</noinclude>

76561198048502585 at 11:44, 6 August 2026

2026-08-06T11:44:21Z

← Older revision		Revision as of 11:44, 6 August 2026
Line 70:		Line 70:
	7. Getting a rich text		7. Getting a rich text

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|demon_hero_6\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|demon_hero_6\|en\|field=description}}</nowiki></code>

	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|demon_hero_6\|en}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|demon_hero_6\|en\|field=description}}

	</noinclude>		</noinclude>

76561198048502585 at 11:43, 6 August 2026

2026-08-06T11:43:56Z

← Older revision		Revision as of 11:43, 6 August 2026
Line 1:		Line 1:
	<includeonly><!--		<includeonly><!--
	-->T={{#cargo_query:		-->{{#cargo_query:
	tables =		tables =
	Translation = T		Translation = T
Line 14:		Line 14:
	{{{1}}}💬		{{{1}}}💬
	\| more results text =		\| more results text =
			}}<!--
	~~}},~~		--></includeonly><!--
	~~L={{#cargo_query:~~
	~~tables = Translation=T, Translation=EN~~
	~~\|join on = T.target_id = EN.target_id~~
	~~\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'~~
	~~AND EN.target_id = '{{{1}}}' AND EN.language='en'~~
	~~\|fields = CONCAT(T.name)~~
	~~\|limit = 1~~
	~~\|more results text=~~
	}},
	<!--
	################################################################################		################################################################################
	--~~></includeonly~~><noinclude>		--><noinclude>

	Retrieves the {{b\|name}} value from the {{b\|Translation}} Cargo table for a target id, in the desired language.		Retrieves the {{b\|name}} value from the {{b\|Translation}} Cargo table for a target id, in the desired language.
Line 38:		Line 28:
	1. English:		1. English:

	{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|~~wiki_units_no_counter~~\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|nature\|en}}</nowiki></code>

	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|~~wiki_units_no_counter~~\|en}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en}}

	----		----
Line 76:		Line 66:

	{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}		{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|nature\|en\|field=description}}

			----
			7. Getting a rich text

			{{Color\|yellow\|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation\|demon_hero_6\|en}}</nowiki></code>

			{{Color\|lime\|Output:}} {{Sandbox/Aurelain/Translation\|demon_hero_6\|en}}

	</noinclude>		</noinclude>

76561198048502585 at 11:41, 6 August 2026

2026-08-06T11:41:33Z

← Older revision		Revision as of 11:41, 6 August 2026
Line 8:		Line 8:
	{{#if:{{{type\|}}}\|AND T.type="{{{type}}}"\|}}		{{#if:{{{type\|}}}\|AND T.type="{{{type}}}"\|}}
	\| fields =		\| fields =
	T.{{{field\|name}}}		CONCAT(T.{{{field\|name}}})
	\| limit =		\| limit =
	1		1

76561198048502585 at 11:41, 6 August 2026

2026-08-06T11:41:07Z

← Older revision		Revision as of 11:41, 6 August 2026
Line 21:		Line 21:
	\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'		\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'
	AND EN.target_id = '{{{1}}}' AND EN.language='en'		AND EN.target_id = '{{{1}}}' AND EN.language='en'
	\|fields = CONCAT(~~'[[',~~ T.name~~, ']]'~~)		\|fields = CONCAT(T.name)
	\|limit = 1		\|limit = 1
	\|more results text=		\|more results text=

76561198048502585 at 11:40, 6 August 2026

2026-08-06T11:40:55Z

← Older revision		Revision as of 11:40, 6 August 2026
Line 21:		Line 21:
	\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'		\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'
	AND EN.target_id = '{{{1}}}' AND EN.language='en'		AND EN.target_id = '{{{1}}}' AND EN.language='en'
	\|fields = CONCAT('[['~~, EN.name~~, T.name, ']]')		\|fields = CONCAT('[[', T.name, ']]')
	\|limit = 1		\|limit = 1
	\|more results text=		\|more results text=

76561198048502585 at 11:40, 6 August 2026

2026-08-06T11:40:32Z

← Older revision		Revision as of 11:40, 6 August 2026
Line 21:		Line 21:
	\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'		\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'
	AND EN.target_id = '{{{1}}}' AND EN.language='en'		AND EN.target_id = '{{{1}}}' AND EN.language='en'
	\|fields = EN.name		\|fields = CONCAT('[[', EN.name, T.name, ']]')
	\|limit = 1		\|limit = 1
	\|more results text=		\|more results text=

76561198048502585 at 11:40, 6 August 2026

2026-08-06T11:40:05Z

← Older revision		Revision as of 11:40, 6 August 2026
Line 21:		Line 21:
	\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'		\|where = T.target_id = '{{{1}}}' AND T.language='{{{2\|en}}}'
	AND EN.target_id = '{{{1}}}' AND EN.language='en'		AND EN.target_id = '{{{1}}}' AND EN.language='en'
	\|fields = ~~CONCAT('[[',~~ EN.name~~, '{{#ifeq:{{{2\|en}}}\|en\|\|/{{{2}}}}}\|', T.name, ']]')~~		\|fields = EN.name
	\|limit = 1		\|limit = 1
	\|more results text=		\|more results text=