SET @Name = ‘Spanish’;
SET @Local = ‘Espanol’;
INSERT INTO jos_huruhelpdesk_language (langname,localized) VALUES (@Name,@Local);
SELECT id INTO @Id FROM jos_huruhelpdesk_language WHERE langname = @Name AND localized = @Local;
INSERT INTO jos_huruhelpdesk_langstrings (lang_id, variable, langtext) (SELECT @Id, variable, langtext FROM jos_huruhelpdesk_langstrings WHERE lang_id = 1)