[nubuilder 4] Backported all French strings

[apmuthu]

Created installs on different DBs for nubuilder4 and nubuilder45 in a single DB server.

Extracted missing translations from v4.5 into v4.

Manually corrected existing v4 translations from v4.5.

SQLs used:

Code: Select all

SET @lang:='French';

CREATE TABLE nubuilder4.backport_translations
SELECT c.zzzzsys_translate_id, c.trl_language, c.trl_english, c.trl_translation FROM (

/* Backported Missing Translations */
SELECT a.zzzzsys_translate_id,  a.trl_language, a.trl_english, a.trl_translation FROM `nubuilder45`.`zzzzsys_translate` a LEFT JOIN `nubuilder4`.`zzzzsys_translate` b USING (trl_english, trl_language) 
WHERE a.trl_language = @lang AND b.trl_translation IS NULL) c

INNER JOIN (

/* Missing Strings */
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

) d USING (trl_english);

INSERT INTO `zzzzsys_translate` SELECT * FROM nubuilder4.backport_translations;
DROP TABLE nubuilder4.backport_translations; 

-- manual backport of corrections to existing strings

Committed into my updated v4 repo.

[apmuthu]

Russian is also complete.
Existing users can execute:

Code: Select all

INSERT INTO `zzzzsys_translate` (`zzzzsys_translate_id`, `trl_language`, `trl_english`, `trl_translation`) VALUES
('nu5ec114f258aa059','Russian','Username','Имя пользователя');

Current Translation Status for nuBuilder v4 in my updated repo:

nuBuilder v4 Translation status.png