
START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'btnSendMessage', 'backend', 'Button / Send message', 'script', '2015-05-08 14:42:55');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Send message', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblGetSubscriptionForm', 'backend', 'Label / Get subscription form', 'script', '2015-05-08 15:04:52');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Get Subscription Form integration code', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblPreviewSubscriptionForm', 'backend', 'Label / Preview subscription form', 'script', '2015-05-08 15:05:24');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Preview subscription form', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnPreviewForm', 'backend', 'Button / Preview form', 'script', '2015-05-08 15:16:53');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Preview form', 'script');

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSendBody");
UPDATE `multi_lang` SET `content` = 'Send an email message to one or multiple subscribers\' lists. Once you select a message you can click on the two icons either to edit or preview the message. Then you need to select the list(s) you want to send message to. A new line with total subscribers for the selected list(s) will show up so you know how many subscribers will receive the message.<br /><br />  With the "Schedule" option you can set the message to be sent right after you click the Send button or select a date/time when the message should be sent.<br /><br />  With the "Send in batches" option you can split the subscribers in portions and send the message to each portion in equal intervals. This is useful if you have to send many emails but your server limits the number of outgoing messages.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoMailQueueBody");
UPDATE `multi_lang` SET `content` = 'Below you can send a list with all messages that have been sent or waiting to be sent. You can delete any of the messages from the queue.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSendConfirmBody");
UPDATE `multi_lang` SET `content` = 'If you check "Confirm subscription" then people who subscribe for this list will receive a confirmation message with a link in it. Please, note that you should include {ConfirmURL} token which is used for this confirmation link. They should click on that link to confirm their subscription. Use additional tokens to personalize the confirmation message.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSendResponseBody");
UPDATE `multi_lang` SET `content` = 'Automatically send a message to every subscriber who subscribes to this list. Use available tokens to personalize the confirmation message.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoImportBody");
UPDATE `multi_lang` SET `content` = 'You can either upload a CSV file with your subscribers or copy/paste from Excel. If you check "Update subscribers" then subscribers who are already in your list will be updated with the new data provided. Otherwise each new subscriber will be added to the list and duplicates may be possible. Sample CSV file can be found <a href="import-sample.csv">here</a>.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoMessagesDesc");
UPDATE `multi_lang` SET `content` = 'Below you can see all the messages that you\'ve created - how many subscribers it has been sent to, when it was last sent and its status. If you want to create a new message, click on the button "+ Create message". Using the icon buttons next to each message you can edit, delete, preview, duplicate and send a quick test.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoAddMessageBody");
UPDATE `multi_lang` SET `content` = 'You can create a message using the form below. Just fill in message subject and body, attach files and save it. You have the option to add both HTML and Plain text version for your email message.<br /><br />  Use these tokens and the message and they will be replaced by the actual subscriber\'s data.<br /><br /><label>{FirstName}</label><label>{LastName}</label><label>{Email}</label><label>{Phone}</label><label>{Website}</label><label>{Gender}</label><label>{Age}</label><label>{Birthday}</label><label>{Address}</label><label>{City}</label><label>{State}</label><label>{Country}</label><label>{Zip}</label><label>{CompanyName}</label><label>{Unsubscribe}</label>' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSubscritionFormBody");
UPDATE `multi_lang` SET `content` = 'Copy the code below and put it on your web page. It will show a subscription form which people will use to subscribe to the selected list. If you select "Let subscriber choose list" then your subscribers will see all available lists and will have the option to select the list they want to subscribe to.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblMessageTokens");
UPDATE `multi_lang` SET `content` = 'Use these tokens and the message and they will be replaced by the actual subscriber\'s data.<br /><br /><label>{FirstName}</label><label>{LastName}</label><label>{Email}</label><label>{Phone}</label><label>{Website}</label><label>{Gender}</label><label>{Age}</label><label>{Birthday}</label><label>{Address}</label><label>{City}</label><label>{State}</label><label>{Country}</label><label>{Zip}</label><label>{CompanyName}</label><label>{Unsubscribe}</label>' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;