
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblTicketDataTokens");
UPDATE `multi_lang` SET `content` = '<u>Available tokens:</u><br/>{Name}<br/>{Email}<br/>{Phone}<br/>{Event}<br/>{EventDate}<br/>{Ticket}<br/>{Seat}' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAvailableTokens");
UPDATE `multi_lang` SET `content` = 'Use the tokens below to personalize your email messages. <br/><br/><div class="float_left w200">{Title}<br/>{Name}<br/>{Email}<br/>{Phone}<br/>{Company}<br/>{Address}<br/>{City}<br/>{State}<br/>{Zip}</div><div class="float_left w250">{Country}<br/>{Notes}<br/>{BookingID}<br/>{Event}<br/>{EventDate}<br/>{Tickets}<br/>{SubTotal}<br/>{Tax}<br/>{Total}<br/></div><div class="float_left w200">{Deposit}<br/>{PaymentMethod}<br/>{CCType}<br/>{CCNum}<br/>{CCExp}<br/>{CCSec}<br/>{CancelURL}<br/>{PDFTicket}</div>' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;