
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAvailabeTokens");
UPDATE `multi_lang` SET `content` = 'Available tokens:<br/><br/>Name: {Name}<br/>Email: {Email}<br/>Phone: {Phone}<br/>City: {City}<br/>State: {State}<br/>Zip: {Zip}<br/>Address: {Address}<br/>Notes: {Notes}<br/>Tickets: {Tickets}<br/>PDF Ticket: {PDF_Tickets}<br/><br/>CC type: {CCType}<br/>CC number: {CCNum}<br/>CC expiration: {CCExp}<br/>CC code: {CCSec}<br/>Payment: {PaymentMethod}<br/>Event: {Event}<br/>Event Title: {EventTitle}<br/>Event Date/time: {EventDateTime}<br/>Event Location: {EventLocation}<br/>Total price: {Total} </br>Tax: {Tax} </br>Deposit: {Deposit} </br>Remaining Balance: {Balance} </br>Booking ID: {BookingID} </br>Cancel URL: {CancelURL}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;