
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "notify_tokens_ARRAY_5");
UPDATE `multi_lang` SET `content` = 'available tokens:<br/>{fname}<br/>{lname}<br/>{email}<br/>{password}<br/>{confirmURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "notify_tokens_ARRAY_6");
UPDATE `multi_lang` SET `content` = 'available tokens:<br/>{companyname}<br/>{contactname}<br/>{email}<br/>{password}<br/>{confirmURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;