
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AO25");
UPDATE `multi_lang` SET `content` = 'Email notifications will be sent to people who make a reservation after reservation form is completed or/and payment is made. Suppored tokens to be used in the email are: \r\n<br/>\r\n<div style="float:left; width: 350px;">\r\n{Name} - The customer''s name<br/>	\r\n{Phone} - The customer''s phone number<br/>\r\n{Email} - The customer''s e-mail<br/>\r\n{Notes} - Any additional notes<br/>	\r\n{Address1} - The provided address 1<br/>\r\n{Address2} - The provided address 2<br/>\r\n{City} - The provided city<br/>\r\n{State} - The provided state<br/>\r\n{Zip} - The provided zip code<br/>\r\n{Country} - The provided country<br/>\r\n{CCType} - The provided CC type<br/>\r\n{CCType} - The provided CC type<br/>\r\n{CCType} - The provided CC type<br/>\r\n{CCNum} - The provided CC number\r\n</div>\r\n<div style="float:right; width: 350px;">\r\n{CCExpMonth} - The provided CC exp.month<br/>\r\n{CCExpYear} - The provided CC exp.year<br/>\r\n{CCSec} - The provided CC sec. code<br/>\r\n{PaymentMethod} - The payment method<br/>\r\n{Back} - How will you return the equipment?<br/>\r\n{Forth} - How do you get the equipment?<br/>\r\n{Items} - Booking''s items<br/>\r\n{Deposit} - Deposit<br/>\r\n{Tax} - Tax<br/>\r\n{Security} - Security<br/>\r\n{Total} - Total amount<br/>\r\n{DtFrom} - Booking''s start date/time<br/>\r\n{DtTo} - Booking''s end date/time<br/>\r\n{BookingID} - Booking''s ID<br/>\r\n{BookingUUID} - Booking''s UUID\r\n</div>\r\n' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblListingConfirmTokens");
UPDATE `multi_lang` SET `content` = 'Supported tokens are:\r\n{Name} - The customer''s name\r\n{Phone} - The customer''s phone number\r\n{Email} - The customer''s e-mail\r\n{Notes} - Any additional notes\r\n{Address1} - The provided address 1\r\n{Address2} - The provided address 2\r\n{City} - The provided city\r\n{State} - The provided state\r\n{Zip} - The provided zip code\r\n{Country} - The provided country\r\n{Back} - How will you return the equipment?\r\n{Forth} - How do you get the equipment?\r\n{CCType} - The provided CC type\r\n{CCNum} - The provided CC number\r\n{CCExpMonth} - The provided CC exp.month\r\n{CCExpYear} - The provided CC exp.year\r\n{CCSec} - The provided CC sec. code\r\n{PaymentMethod} - The payment method\r\n{Items} - Booking items\r\n{Deposit} - Deposit\r\n{Security} - Security\r\n{Tax} - Tax\r\n{Total} - Total amount\r\n{DtFrom} - Booking''s start date/time\r\n{DtTo} - Booking''s end date/time\r\n{BookingID} - Booking''s ID\r\n{BookingUUID} - Booking''s UUID' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblListingPaymentTokens");
UPDATE `multi_lang` SET `content` = 'Supported tokens are:\r\n{Name} - The customer''s name\r\n{Phone} - The customer''s phone number\r\n{Email} - The customer''s e-mail\r\n{Notes} - Any additional notes\r\n{Address1} - The provided address 1\r\n{Address2} - The provided address 2\r\n{City} - The provided city\r\n{State} - The provided state\r\n{Zip} - The provided zip code\r\n{Country} - The provided country\r\n{Back} - How will you return the equipment?\r\n{Forth} - How do you get the equipment?\r\n{CCType} - The provided CC type\r\n{CCNum} - The provided CC number\r\n{CCExpMonth} - The provided CC exp.month\r\n{CCExpYear} - The provided CC exp.year\r\n{CCSec} - The provided CC sec. code\r\n{PaymentMethod} - The payment method\r\n{Items} - Booking items\r\n{Deposit} - Deposit\r\n{Security} - Security\r\n{Tax} - Tax\r\n{Total} - Total amount\r\n{DtFrom} - Booking''s start date/time\r\n{DtTo} - Booking''s end date/time\r\n{BookingID} - Booking''s ID\r\n{BookingUUID} - Booking''s UUID' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;