Translations: Difference between revisions
No edit summary |
No edit summary |
||
Line 13: | Line 13: | ||
=Translation= | =Translation= | ||
The translated phrase used in the selected language. Can safely delete unused language translations in the | The translated phrase used in the selected language. Can safely delete unused language translations in the <tt>zzzzsys_translate</tt> table. | ||
== Supported Languages == | == Supported Languages == | ||
=== Translation Stats === | |||
<pre> | |||
/* Translation Stats */ | |||
SELECT trl_language | |||
, COUNT(*) AS translated_strings | |||
, (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate | |||
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC; | |||
/* Missing Strings */ | |||
SET @lang:='German'; -- choose your language here | |||
SELECT a.trl_english | |||
FROM `zzzzsys_translate` a LEFT JOIN | |||
(SELECT b.trl_english FROM zzzzsys_translate b WHERE b.trl_language = @lang) lang | |||
USING (trl_english) | |||
WHERE lang.trl_english IS NULL | |||
GROUP BY a.trl_english; | |||
</pre> | |||
=== Stable Updated Version === | === Stable Updated Version === | ||
'''''Bold''' indicates 100% Translation'' | '''''Bold''' indicates 100% Translation'' of '''211''' strings available | ||
* Arabic | * Arabic | ||
* '''Armenian''' | * '''Armenian''' |
Revision as of 16:18, 10 January 2021
This allows you to make alternative phrases in other languages that can be used instead of nuBuilder Forte's English (Australian) phrases.
The translated phrases for all supported languages are stored in the zzzzsys_translate table.
Language
The User's language.
Dialects
Any changes to the English Translation (Australian) for other dialects like UK, US, Indian, etc can be treated as another language (UKEnglish, USEnglish, INEnglish) having the override strings alone with the parent English as fallback for strings not present in these modded dialects.
English
A translatable phrase used in nuBuilder Forte.
Translation
The translated phrase used in the selected language. Can safely delete unused language translations in the zzzzsys_translate table.
Supported Languages
Translation Stats
/* Translation Stats */ SELECT trl_language , COUNT(*) AS translated_strings , (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC; /* Missing Strings */ SET @lang:='German'; -- choose your language here SELECT a.trl_english FROM `zzzzsys_translate` a LEFT JOIN (SELECT b.trl_english FROM zzzzsys_translate b WHERE b.trl_language = @lang) lang USING (trl_english) WHERE lang.trl_english IS NULL GROUP BY a.trl_english;
Stable Updated Version
Bold indicates 100% Translation of 211 strings available
- Arabic
- Armenian
- Chinese
- Czech
- French
- German
- Greek
- Hindi
- Italian
- Malay
- Russian
- Spanish
- Tamil
- Vietnamese