
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAvailabeTokens");
UPDATE `multi_lang` SET `content` = 'Available tokens:\r\n<br/><br/>\r\nName: {Name}<br/>\r\nEmail: {Email}<br/>\r\nPhone: {Phone}<br/>\r\nCity: {City}<br/>\r\nState: {State}<br/>\r\nZip: {Zip}<br/>\r\nAddress: {Address}<br/>\r\nNotes: {Notes}<br/>\r\nTickets: {Tickets}<br/>\r\nPDF Ticket: {PDF_Tickets}<br/><br/>\r\n\r\nCC type: {CCType}<br/>\r\nCC number: {CCNum}<br/>\r\nCC expiration: {CCExp}<br/>\r\nCC code: {CCSec}<br/>\r\nPayment: {PaymentMethod}<br/>\r\nEvent: {Event}<br/>\r\nEvent Title: {EventTitle}<br/>\r\nEvent Date/time: {EventDateTime}<br/>\r\n\r\nTotal price: {Total} </br>\r\nTax: {Tax} </br>\r\nDeposit: {Deposit} </br>\r\nRemaining Balance: {Balance} </br>\r\nBooking ID: {BookingID} </br>\r\nCancel URL: {CancelURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;