Template: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 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
Line 14:		Line 14:
	{{{1}}}💬		{{{1}}}💬
	\| more results text =		\| more results text =

	}}<!--		}}<!--
			--></includeonly><!--
	################################################################################		################################################################################
	--~~></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 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>{{Translation\|nature\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|en}}</nowiki></code>
Line 32:		Line 31:
	{{Color\|lime\|Output:}} {{Translation\|nature\|en}}		{{Color\|lime\|Output:}} {{Translation\|nature\|en}}

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

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

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

	{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|foo\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|foo\|en}}</nowiki></code>
Line 46:		Line 45:
	{{Color\|lime\|Output:}} {{Translation\|foo\|en}}		{{Color\|lime\|Output:}} {{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{{Translation\|nature\|en}}World</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>Hello{{Translation\|nature\|en}}World</nowiki></code>
Line 53:		Line 53:
	{{Color\|lime\|Output:}} Hello{{Translation\|nature\|en}}World		{{Color\|lime\|Output:}} Hello{{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>{{Translation\|luck\|en\|type=unit_stat}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|luck\|en\|type=unit_stat}}</nowiki></code>
Line 60:		Line 61:
	{{Color\|lime\|Output:}} {{Translation\|luck\|en\|type=unit_stat}}		{{Color\|lime\|Output:}} {{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>{{Translation\|nature\|en\|field=description}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|en\|field=description}}</nowiki></code>
Line 67:		Line 69:
	{{Color\|lime\|Output:}} {{Translation\|nature\|en\|field=description}}		{{Color\|lime\|Output:}} {{Translation\|nature\|en\|field=description}}


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

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

			{{Color\|lime\|Output:}} {{Translation\|dragon\|en\|field=description}}

			__NOTOC__
	</noinclude>		</noinclude>

76561198048502585 at 05:27, 3 August 2026

2026-08-03T05:27:43Z

← Older revision		Revision as of 05:27, 3 August 2026
Line 8:		Line 8:
	{{#if:{{{type\|}}}\|AND T.type="{{{type}}}"\|}}		{{#if:{{{type\|}}}\|AND T.type="{{{type}}}"\|}}
	\| fields =		\| fields =
	T.name		T.{{{field\|name}}}
	\| limit =		\| limit =
	1		1
Line 59:		Line 59:

	{{Color\|lime\|Output:}} {{Translation\|luck\|en\|type=unit_stat}}		{{Color\|lime\|Output:}} {{Translation\|luck\|en\|type=unit_stat}}

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

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

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

	</noinclude>		</noinclude>

76561198048502585 at 15:28, 15 July 2026

2026-07-15T15:28:49Z

← Older revision		Revision as of 15:28, 15 July 2026
Line 12:		Line 12:
	1		1
	\| default =		\| default =
	—		{{{1}}}💬
	\| more results text =		\| more results text =

76561198048502585 at 09:23, 15 July 2026

2026-07-15T09:23:05Z

← Older revision		Revision as of 09:23, 15 July 2026
Line 6:		Line 6:
	T.target_id = "{{{1}}}"		T.target_id = "{{{1}}}"
	AND T.language = "{{{2\|en}}}"		AND T.language = "{{{2\|en}}}"
			{{#if:{{{type\|}}}\|AND T.type="{{{type}}}"\|}}
	\| fields =		\| fields =
	T.name		T.name
Line 51:		Line 52:

	{{Color\|lime\|Output:}} Hello{{Translation\|nature\|en}}World		{{Color\|lime\|Output:}} Hello{{Translation\|nature\|en}}World

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

			{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|luck\|en\|type=unit_stat}}</nowiki></code>

			{{Color\|lime\|Output:}} {{Translation\|luck\|en\|type=unit_stat}}

	</noinclude>		</noinclude>

76561198048502585 at 15:02, 14 July 2026

2026-07-14T15:02:24Z

← Older revision		Revision as of 15:02, 14 July 2026
Line 6:		Line 6:
	T.target_id = "{{{1}}}"		T.target_id = "{{{1}}}"
	AND T.language = "{{{2\|en}}}"		AND T.language = "{{{2\|en}}}"
	\| fields = T.name\|limit = 1\|default = —\| more results text =}}<!--		\| fields =
			T.name
			\| limit =
			1
			\| default =
			—
			\| more results text =

			}}<!--
	################################################################################		################################################################################
	--></includeonly><noinclude>		--></includeonly><noinclude>
Line 17:		Line 25:
	== Usage ==		== Usage ==

	1. English		1. English:

	{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|en}}</nowiki></code>
Line 24:		Line 32:

	----		----
	2. Japanese		2. Japanese:

	{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|ja}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|ja}}</nowiki></code>
Line 31:		Line 39:

	----		----
	3. Missing id		3. Missing id:

	{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|foo\|en}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|foo\|en}}</nowiki></code>

	{{Color\|lime\|Output:}} {{Translation\|foo\|en}}		{{Color\|lime\|Output:}} {{Translation\|foo\|en}}

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

			{{Color\|yellow\|Input:}} <code><nowiki>Hello{{Translation\|nature\|en}}World</nowiki></code>

			{{Color\|lime\|Output:}} Hello{{Translation\|nature\|en}}World

	</noinclude>		</noinclude>

76561198048502585 at 14:48, 14 July 2026

2026-07-14T14:48:54Z

← Older revision		Revision as of 14:48, 14 July 2026
Line 6:		Line 6:
	T.target_id = "{{{1}}}"		T.target_id = "{{{1}}}"
	AND T.language = "{{{2\|en}}}"		AND T.language = "{{{2\|en}}}"
	\| fields =		\| fields = T.name\|limit = 1\|default = —\| more results text =}}<!--
	T.name
	\| limit =
	1
	\| default =
	—
	\| more results text =

	}}<!--
	################################################################################		################################################################################
	--></includeonly><noinclude>		--></includeonly><noinclude>

76561198048502585 at 14:36, 14 July 2026

2026-07-14T14:36:25Z

← Older revision		Revision as of 14:36, 14 July 2026
Line 37:		Line 37:

	{{Color\|lime\|Output:}} {{Translation\|nature\|ja}}		{{Color\|lime\|Output:}} {{Translation\|nature\|ja}}

			----
			3. Missing id

			{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|foo\|en}}</nowiki></code>

			{{Color\|lime\|Output:}} {{Translation\|foo\|en}}

	</noinclude>		</noinclude>

76561198048502585 at 14:35, 14 July 2026

2026-07-14T14:35:36Z

← Older revision		Revision as of 14:35, 14 July 2026
Line 5:		Line 5:
	\| where =		\| where =
	T.target_id = "{{{1}}}"		T.target_id = "{{{1}}}"
	AND T.language = "en"		AND T.language = "{{{2\|en}}}"
	\| fields =		\| fields =
	T.name		T.name
Line 11:		Line 11:
	1		1
	\| default =		\| default =
	-		—
	\| more results text =		\| more results text =

Line 34:		Line 34:
	2. Japanese		2. Japanese

	{{Color\|yellow\|Input:}} <code><nowiki>{{Translation \| nature \| ja}}</nowiki></code>		{{Color\|yellow\|Input:}} <code><nowiki>{{Translation\|nature\|ja}}</nowiki></code>

	{{Color\|lime\|Output:}} {{Translation \| nature \| ja}}		{{Color\|lime\|Output:}} {{Translation\|nature\|ja}}

	</noinclude>		</noinclude>

76561198048502585 at 14:32, 14 July 2026

2026-07-14T14:32:30Z

← Older revision		Revision as of 14:32, 14 July 2026
Line 4:		Line 4:
	Translation = T		Translation = T
	\| where =		\| where =
	T.target_id = "~~nature~~"		T.target_id = "{{{1}}}"
	AND T.language = "en"		AND T.language = "en"
	\| fields =		\| fields =
Line 10:		Line 10:
	\| limit =		\| limit =
	1		1
	\| default = ~~foo~~		\| default =
	\| more results text = ~~moree~~		-
			\| more results text =

	}}<!--		}}<!--
Line 26:		Line 27:
	1. English		1. English

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

	{{Color\|lime\|Output:}} {{Translation \| nature \| en}}		{{Color\|lime\|Output:}} {{Translation\|nature\|en}}

	----		----

76561198048502585 at 14:31, 14 July 2026

2026-07-14T14:31:15Z

← Older revision		Revision as of 14:31, 14 July 2026
Line 4:		Line 4:
	Translation = T		Translation = T
	\| where =		\| where =
	T.target_id = "~~{{{1}}}~~"		T.target_id = "nature"
	AND T.language = "~~{{{2\|~~en~~}}}~~"		AND T.language = "en"
	\| fields =		\| fields =
	T.name		T.name
	\| limit =		\| limit =
	1		1
	\| default =		\| default = foo
	~~{{Label\|none\|{{{2\|en}}}}}~~		\| more results text = moree
	\| more results text =

	}}<!--		}}<!--