
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "menuGroups");
UPDATE `multi_lang` SET `content` = 'Lists' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblGroup");
UPDATE `multi_lang` SET `content` = 'List' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblGroupDetails");
UPDATE `multi_lang` SET `content` = 'List details' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoGroupTitle");
UPDATE `multi_lang` SET `content` = 'Lists' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoGroupBody");
UPDATE `multi_lang` SET `content` = 'You can organize the subscribers in lists. Create as many lists as you want and assign each subscriber to one or multiple lists. Later you can send messages to specific lists only. Each list has own registration form so people can subscribe to specific list only.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoAddGroupTitle");
UPDATE `multi_lang` SET `content` = 'Create new list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoAddGroupBody");
UPDATE `multi_lang` SET `content` = 'Enter list name and click on "Save" button. On next screen you will be able to set various option for the list - subscribers\' data to be collected, confirmation and autoresponder messages, subscription form code.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoUpdateGroupTitle");
UPDATE `multi_lang` SET `content` = 'Update list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoUpdateGroupBody");
UPDATE `multi_lang` SET `content` = 'Open the tabs below to change different settings for this list.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSubscriberDataBody");
UPDATE `multi_lang` SET `content` = 'Select the fields that this list\'s subscribers should fill in on the subscription form.' 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 you a link in it. They should click on the link to confirm their subscription.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSendResponseBody");
UPDATE `multi_lang` SET `content` = 'You can send a message to every person who subscribes for this list. Check "Send autoresponder" and fill in message details and the message will be sent to everyone who fill in and submit the subscription form.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSendBody");
UPDATE `multi_lang` SET `content` = 'Using the form below you can send an email message to one of multiple subscribers\' lists. First you need to select the message that will be sent. There are two icons to edit and preview the message. Then you need to select the list(s) and 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` = "infoAddSubscriberBody");
UPDATE `multi_lang` SET `content` = 'Fill in the form below to add a subscriber. You can assign the subscriber to one or multiple different lists.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoUpdateSubscriberBody");
UPDATE `multi_lang` SET `content` = 'Fill in the form below to edit subscriber information. You can assign the subscriber to one or multiple different lists.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AO25");
UPDATE `multi_lang` SET `content` = '' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AO25");
UPDATE `multi_lang` SET `content` = '' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AO25");
UPDATE `multi_lang` SET `content` = '' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

INSERT INTO `fields` VALUES (NULL, 'lblAll', 'backend', 'Label / All', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'lblRemoveFromCurrentGroup', 'backend', 'Label / Remove from current group(s)', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Remove from current group(s)', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnAddSubscriber', 'backend', 'Label / + Add subscriber', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Add subscriber', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoSubscribersTitle', 'backend', 'Infobox / List of subscribers', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'List of subscribers', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoSubscribersDesc', 'backend', 'Infobox / List of subscribers', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can find below the list of subscriber. Click on the button "+ Add subscriber" to add new subscriber. You can view more details about a specific subscriber by clicking on the pencil icon on the corresponding entry.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblSource', 'backend', 'Label / Source', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'import_sources_ARRAY_csv', 'arrays', 'import_sources_ARRAY_csv', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'upload CSV file', 'script');

INSERT INTO `fields` VALUES (NULL, 'import_sources_ARRAY_excel', 'arrays', 'import_sources_ARRAY_excel', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'copy/paste from Excel', 'script');

INSERT INTO `fields` VALUES (NULL, 'error_titles_ARRAY_AS20', 'arrays', 'error_titles_ARRAY_AS20', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'error_bodies_ARRAY_AS20', 'arrays', 'error_bodies_ARRAY_AS20', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Subscribers pasted from Excel have been updated.', 'script');

INSERT INTO `fields` VALUES (NULL, 'error_titles_ARRAY_AS21', 'arrays', 'error_titles_ARRAY_AS21', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Subscribers data invalid', 'script');

INSERT INTO `fields` VALUES (NULL, 'error_bodies_ARRAY_AS21', 'arrays', 'error_bodies_ARRAY_AS21', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Importing cannot be processed because of invalid data. ', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnCreateList', 'backend', 'Button / + Create list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '+ Create list', 'script');

INSERT INTO `fields` VALUES (NULL, 'btnCreateMessage', 'backend', 'Button / + Create message', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'menuSubscriptionForms', 'backend', 'Menu / Subscription forms', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'lblLetChoose', 'backend', 'Label / Let subscriber choose list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Let subscriber choose list', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblSelectAList', 'backend', 'Label / Select a list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Select a list', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_required_ARRAY_list', 'arrays', 'front_required_ARRAY_list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Select a list is required.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_label_select_list', 'frontend', 'Label / Select a list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Select a list', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_label_select_list_prompt', 'frontend', 'Label / Select a list', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Please select a list that you want to subscribe to.', 'script');

COMMIT;