Template:Sandbox/Aurelain/Translation: Difference between revisions
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><!-- | <includeonly><!-- | ||
--> | -->{{#cargo_query: | ||
tables = | tables = | ||
Translation = T | Translation = T | ||
| 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><!-- | |||
}} | |||
<!-- | |||
################################################################################ | ################################################################################ | ||
-- | --><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 34: | 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>. | ||
1. English: | ==1. English:== | ||
{{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation| | {{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation|nature|en}}</nowiki></code> | ||
{{Color|lime|Output:}} {{Sandbox/Aurelain/Translation| | {{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 49: | 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 56: | Line 45: | ||
{{Color|lime|Output:}} {{Sandbox/Aurelain/Translation|foo|en}} | {{Color|lime|Output:}} {{Sandbox/Aurelain/Translation|foo|en}} | ||
4. Surrounded by text | ==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 63: | 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}} | ==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 70: | 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}} | ==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 77: | 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:== | |||
(to prove html markup works) | |||
{{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/Translation|dragon|en|field=description}}</nowiki></code> | |||
{{Color|lime|Output:}} {{Sandbox/Aurelain/Translation|dragon|en|field=description}} | |||
__NOTOC__ | |||
</noinclude> | </noinclude> | ||
Latest revision as of 11:47, 6 August 2026
Retrieves the name value from the Translation Cargo table for a target id, in the desired language.
This is very similar to the Label template, but is more generic, allowing you to pull any id
from the Translation table, not just those prefixed with wiki_.
1. English:
Input: {{Sandbox/Aurelain/Translation|nature|en}}
Output: Grove
2. Japanese:
Input: {{Sandbox/Aurelain/Translation|nature|ja}}
Output: グローヴ
3. Missing id:
Input: {{Sandbox/Aurelain/Translation|foo|en}}
Output: foo💬
4. Surrounded by text:
(to prove this template doesn't add unexpected whitespace)
Input: Hello{{Sandbox/Aurelain/Translation|nature|en}}World
Output: HelloGroveWorld
5. With type:
(when collisions are a concern)
Input: {{Sandbox/Aurelain/Translation|luck|en|type=unit_stat}}
Output: Luck
6. With field:
(to get the description)
Input: {{Sandbox/Aurelain/Translation|nature|en|field=description}}
Output: Each of the Murmurwoods’ elemental spirits is a unique powerhouse, supported by equally strong — and expensive — rangers and druids.
7. Getting a rich text:
(to prove html markup works)
Input: {{Sandbox/Aurelain/Translation|dragon|en|field=description}}
Output: A powerful ancient creature, often intelligent and imbued with wondrous magic.
Morale range: 0 to 5.
Luck range: 0 to 3.
Fallen Dragons can be raised as Undead after battle.
