
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblListingConfirmTokens");
UPDATE `multi_lang` SET `content` = 'These are the supported tokens which can be used in the email message<br> {Name} - customer''s name<br> {Email} - customer''s e-mail<br> {Phone} - phone number<br> {Notes} - additional notes<br> {CCType} - CC type<br> {CCNum} - CC number<br> {CCExp} - CC exp. date<br> {CCSec} - CC security code<br> {PaymentMethod} - payment method<br> {StartDate} - start date<br> {EndDate} - end date<br> {Price} - price<br> {Deposit} - deposit<br> {Security} - security amount<br> {Tax} - tax<br> {Total} - total price<br> {ListingID} - property ID<br> {ListingRefID} - property ref.ID<br> {ReservationID} - reservation ID<br> {ReservationUUID} - reservation unique ID<br> {CancelURL} - cancel reservation URL' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoConfirmationEmailsDesc");
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/><br/>\r\n<table style="width:100%;">\r\n	<tr>\r\n		<td style="width: 47%;">\r\n			{Name} - customer''s name<br/>\r\n			{Email} - customer''s e-mail<br/>\r\n			{Phone} - phone number<br/>\r\n			{Notes} - additional notes<br/>\r\n			{ListingID} - property ID<br/>\r\n			{ListingRefID} - property ref.ID<br/>\r\n			{ReservationID} - reservation ID<br/>\r\n			{ReservationUUID} - reservation unique ID<br/>\r\n			{CancelURL} - cancel reservation URL<br/>\r\n			{StartDate} - start date<br/>\r\n			{EndDate} - end date\r\n		</td>\r\n		<td style="width: 50%;">\r\n			{Price} - price<br/>\r\n			{Deposit} - deposit<br/>\r\n			{Security} - security amount<br/>\r\n			{PaymentMethod} - payment method<br/>\r\n			{Tax} - tax<br/>\r\n			{Total} - total price<br/>\r\n			{CCType} - CC type<br/>\r\n			{CCNum} - CC number<br/>\r\n			{CCExp} - CC exp. date<br/>\r\n			{CCSec} - CC security code\r\n		</td>\r\n	</tr>\r\n</table>' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;