
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "tokens_ARRAY_register");
UPDATE `multi_lang` SET `content` = 'Available tokens:\r\n\r\n{Group}\r\n{FirstName}\r\n{LastName}\r\n{Email}\r\n{Password}\r\n{Phone}\r\n{Website}\r\n{Gender}\r\n{Age}\r\n{Birthday}\r\n{Address}\r\n{City}\r\n{State}\r\n{Country}\r\n{Zip}\r\n{CompanyName}\r\n{Fee}\r\n{ConfirmURL}\r\n{InvoiceURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "tokens_ARRAY_notify");
UPDATE `multi_lang` SET `content` = 'Available tokens:\r\n\r\n{Group}\r\n{FirstName}\r\n{LastName}\r\n{Email}\r\n{Password}\r\n{Phone}\r\n{Website}\r\n{Gender}\r\n{Age}\r\n{Birthday}\r\n{Address}\r\n{City}\r\n{State}\r\n{Country}\r\n{Zip}\r\n{CompanyName}\r\n{Fee}\r\n{InvoiceURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "tokens_ARRAY_payment");
UPDATE `multi_lang` SET `content` = 'Available tokens:\r\n\r\n{Group}\r\n{FirstName}\r\n{LastName}\r\n{Email}\r\n{Password}\r\n{Phone}\r\n{Website}\r\n{Gender}\r\n{Age}\r\n{Birthday}\r\n{Address}\r\n{City}\r\n{State}\r\n{Country}\r\n{Zip}\r\n{CompanyName}\r\n{Fee}\r\n{InvoiceURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "tokens_ARRAY_created");
UPDATE `multi_lang` SET `content` = 'Available tokens:\r\n\r\n{Group}\r\n{FirstName}\r\n{LastName}\r\n{Email}\r\n{Password}\r\n{Phone}\r\n{Website}\r\n{Gender}\r\n{Age}\r\n{Birthday}\r\n{Address}\r\n{City}\r\n{State}\r\n{Country}\r\n{Zip}\r\n{CompanyName}\r\n{Fee}\r\n{InvoiceURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

UPDATE `notifications` SET `message` = 'Dear {FirstName},<br/><br/>There is a new member registered. Here is the detail information of the account.<br/><br/>Group: {Group}<br/>Firstname: {FirstName}<br/>Last name: {LastName}<br/>Email: {Email}<br/>Password: {Password}<br/>Phone: {Phone}<br/>Website: {Website}<br/>Gender: {Gender}<br/>Age: {Age}<br/>Birthday: {Birthday}<br/>Address: {Address}<br/>City: {City}<br/>State: {State}<br/>Country: {Country}<br/>Zip: {Zip}<br/>Company name: {CompanyName}<br/>{Fee}<br/><br/>Thanks!' WHERE `key` = "notify";
UPDATE `notifications` SET `message` = 'Dear {FirstName},<br/><br/>You have just registered for new member account. Here is the detail information of your account.<br/><br/>Group: {Group}<br/><br/>Firstname: {FirstName}<br/>Last name: {LastName}<br/>Email: {Email}<br/>Password: {Password}<br/>Phone: {Phone}<br/>Website: {Website}<br/>Gender: {Gender}<br/>Age: {Age}<br/>Birthday: {Birthday}<br/>Address: {Address}<br/>City: {City}<br/>State: {State}<br/>Country: {Country}<br/>Zip: {Zip}<br/>Company name: {CompanyName}<br/>{Fee}<br/><br/>Please click on the link below to confirmation your registration and also activate your account.<br/><br/>{ConfirmURL} <br/><br/>Thanks!' WHERE `key` = "register";
UPDATE `notifications` SET `message` = 'Dear {FirstName},<br/><br/>You have just paid for the member registration. Your account should be active now. <br/><br/>Here is the detail information.<br/><br/>Group: {Group}<br/>Firstname: {FirstName}<br/>Last name: {LastName}<br/>Email: {Email}<br/>Password: {Password}<br/>Phone: {Phone}<br/>Website: {Website}<br/>Gender: {Gender}<br/>Age: {Age}<br/>Birthday: {Birthday}<br/>Address: {Address}<br/>City: {City}<br/>State: {State}<br/>Country: {Country}<br/>Zip: {Zip}<br/>Company name: {CompanyName}<br/><br/>Registration and subscription fee:<br/>{Fee} <br/><br/>Thanks!' WHERE `key` = "payment";
UPDATE `notifications` SET `message` = 'Dear {FirstName},<br/><br/>You have just registered for new member account. Here is the detail information of the account.<br/><br/>Group: {Group}<br/>Firstname: {FirstName}<br/>Last name: {LastName}<br/>Email: {Email}<br/>Password: {Password}<br/>Phone: {Phone}<br/>Website: {Website}<br/>Gender: {Gender}<br/>Age: {Age}<br/>Birthday: {Birthday}<br/>Address: {Address}<br/>City: {City}<br/>State: {State}<br/>Country: {Country}<br/>Zip: {Zip}<br/>Company name: {CompanyName}<br/>{Fee}<br/><br/>Thanks!' WHERE `key` = "created";
UPDATE `notifications` SET `message` = 'Dear {FirstName},<br/><br/>We have received a password recovery request by this email. Please, find below your password:<br/><br/>Password: {Password}<br/><br/>Thanks!' WHERE `key` = "forgot";

COMMIT;