
START TRANSACTION;

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

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

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

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoEmailBody");
UPDATE `multi_lang` SET `content` = 'The system will send email notifications automatically in some cases as defined below. Use the available tokens and manage the emails'' subjects and messages to personalize them. For your convenience we have set default messages, which we highly recommend to be customized. You can manage the email account that will be used as "mail from" when sending these notifications on Options menu -> Options tab.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoEditorEmailBody");
UPDATE `multi_lang` SET `content` = 'The system will send email notifications automatically in some cases as defined below. Use the available tokens and manage the emails'' subjects and messages to personalize them. For your convenience we have set default messages, which we highly recommend to be customized.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoListingAddressBody");
UPDATE `multi_lang` SET `content` = 'You can show a map with the location of the package accommodation on the package details page. Submit the full address first and then click on "Get coordinates from Google Maps API" button. Save your data.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoListingExtendBody");
UPDATE `multi_lang` SET `content` = 'To publish your package or to extend its expiration date (if the package has already been published) choose the appropriate submission period. If for the desired period charges are applicable, then click on "Buy now" button and make the payment required. After payment is received the package will be automatically published / extended.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSubmissionsBody");
UPDATE `multi_lang` SET `content` = 'You can allow/disallow website users to submit their own vacation packages after registering into the system. These users are named "Owners". You can manage owners'' accounts through Users menu. You can also charge owners for publishing their packages. If you wish to enable user submissions set carefully all options bellow and also set the Emails tab options.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblListingStatusTip");
UPDATE `multi_lang` SET `content` = 'You can add a package but choose not to show it on the website listing by choosing "No". You can publish the package by choosing "Yes" or you can make it live only till a certain date by choosing "Based on expiration date".' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_period_note");
UPDATE `multi_lang` SET `content` = 'Set prices for submitting packages by owners. You can charge different price according to the length of time that the vacation package is active (visible) on your listing. To do this add and manage "period / price" rows below. If you wish to set a "free trial" period then set the number of the days and set "0" into the price field. If you do not wish to charge owners for submitting their packages, then leave just one "period / price" row, define a relevant large number of days into the period filed, and set "0" into the price field.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AL91");
UPDATE `multi_lang` SET `content` = 'You can define here all policies and fees that your package has. "Booking terms" field text will show up in a special box next to the enquiry form on your package details page. You can use it to highlight your booking conditions.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoFlightBody");
UPDATE `multi_lang` SET `content` = 'If there is a flight that is available along with the package, then choose "Yes" for Flight Included option and fill in the flight details and conditions. By default at the front-end will show airplane icon and "Flight included" text on the package listing. If you need to change the "Flight included" text then go to Options menu -> Languages Tab, search for this front-end title and edit it.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoOwnerContactBody");
UPDATE `multi_lang` SET `content` = 'If you have "Owner" type of users into the system, then you can assign an owner to a package. If owners submit packages through their accounts then an owner and a package will be linked together automatically.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblListingCityTip");
UPDATE `multi_lang` SET `content` = 'Note that the city you enter will be used on Filter by Location autofill filter field at the front-end. Keep the same cites written consistently. "NY" and "Mew York" are recognized as two different cities by the system.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoListingSummaryBody");
UPDATE `multi_lang` SET `content` = 'Pay attention to Expire date status. If it says "Not active" then your package is not published on the website listing yet. Click on "Publish" button and choose the appropriate submission period for you. If there is a specific date as a status, then your package will be live on the website listing till that date. You can extend that period by clicking on "Extend expire date" button. If the status says "Unlimited", then the package will be live until not deleted.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoOwnerFlightBody");
UPDATE `multi_lang` SET `content` = 'If there is a flight that is available along with the package, then choose "Yes" for Flight Included option and fill in the flight details and conditions.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;