Enhanced nubuilder4.sql - Tamil included
Posted: Sun Dec 06, 2020 7:02 am
The nubuilder4.sql file in my fork of the project has been enhanced with the inclusion of the complete 211 string translation set for Tamil and Hindi along with missing translations for Russian, Armenian and German.
Read my changelog of fixes.
The current install's status of the translations can be found by:
and the missing strings can be found amidst (eg., for French):
Read my changelog of fixes.
The current install's status of the translations can be found by:
Code: Select all
SELECT trl_language, COUNT(*) AS translated_strings, 211-COUNT(*) AS ToTranslate
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC, trl_language ASC;
Code: Select all
SET @Lang:='French';
SELECT (@a:=@a+1)AS SlNo
, COALESCE(b.zzzzsys_translate_id, '') AS zzzzsys_translate_id
, @Lang AS trl_language, a.trl_english
, COALESCE(b.trl_translation, '') AS trl_translation
FROM
(SELECT '' AS zzzzsys_translate_id, @Lang AS trl_language, trl_english, '' AS trl_translation FROM `zzzzsys_translate` GROUP BY trl_english) a
LEFT JOIN
(SELECT * FROM zzzzsys_translate WHERE trl_language = @Lang) b USING (trl_english), (SELECT @a:=0) c;