nuBuilder Forum

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

Code: Select all

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