Enhanced nubuilder4.sql - Tamil included

[apmuthu]

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:

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;

and the missing strings can be found amidst (eg., for French):

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;

[kev1n]

Hi,

Thanks a lot for your efforts and the Tamil translation!

Please note my comment for the German translation of Username:

https://github.com/apmuthu/nubuilder4/c ... #r44846507

[apmuthu]

Thanks. Done.

[kev1n]

apmuthu,

I noticed that the Tamil translation strings can get quite long sometimes. This causes text to be cut off or overlapped.
To address this, the simplest solution is to insert <br> tags in the translation strings to force a linebreak.
This prevents text overlapping, being cut off, etc.

Example:

line wrap.png

Sometimes it also helps when rearranging objects.

Here's my inoffical build where I have already incorporated most of your suggestens and fixes. The goal is to have them soon in the official build.
Please have a look at it and tell me what you think.
https://github.com/smalos/nubuilder4

[apmuthu]

Thanks. Line breaks incorporated.