-- http://www.phpmyadmin.net
--




--
-- Database: `directoryplus`
--

DELETE FROM `language` WHERE lang='en';


INSERT INTO `language` (`lang`, `section`, `template`, `var_name`, `translated`) VALUES
('en', 'admin', 'plans', 'txt_order', 'Order (at which they will appear to the user in the Select Plan page)'),
('en', 'admin', 'plans', 'txt_period', 'Plan Period (Number of days. Only valid for free and ''one time payments'' plan types). Enter 0 or leave blank for non expiring ads (permanent)'),
('en', 'admin', 'plans', 'txt_plan_name', 'Plan Name'),
('en', 'admin', 'plans', 'txt_plan_price', 'Plan Price'),
('en', 'admin', 'plans', 'txt_plan_status', 'Plan Status'),
('en', 'admin', 'plans', 'txt_plan_type', 'Plan Type'),
('en', 'admin', 'plans', 'txt_price', 'Price'),
('en', 'admin', 'plans', 'txt_remove_plan', 'Remove Plan'),
('en', 'admin', 'plans', 'txt_toggle_active', 'Toggle Active/Inactive'),
('en', 'admin', 'plans', 'txt_plan_created', 'Plan created successfully'),
('en', 'admin', 'plans', 'txt_create_problem', 'Problem creating plan'),
('en', 'admin', 'plans', 'txt_plan_updated', 'Plan updated sucessfully'),
('en', 'admin', 'plans', 'txt_plan_removed', 'Plan removed'),
('en', 'admin', 'plans', 'txt_plan_period', 'Plan Period (Number of days. Only valid for free or ''one time payments'' plan types)'),
('en', 'admin', 'plans', 'txt_plan_order', 'Plan Order'),
('en', 'admin', 'plans', 'txt_change_price', 'It''s not possible to change the price for the ''free'' plan type'),
('en', 'admin', 'plans-trash', 'txt_html_title', 'Billing Plans - Trash'),
('en', 'admin', 'plans-trash', 'txt_main_title', 'Billing Plans - Trash'),
('en', 'admin', 'plans-trash', 'txt_plan_name', 'Plan Name'),
('en', 'admin', 'plans-trash', 'txt_plan_type', 'Plan Type'),
('en', 'admin', 'plans-trash', 'txt_price', 'Price'),
('en', 'admin', 'plans-trash', 'txt_remove', 'Remove permanently'),
('en', 'admin', 'plans-trash', 'txt_remove_sure', 'Are you sure you want to remove this plan? This action cannot be undone.'),
('en', 'admin', 'plans-trash', 'txt_remove_all_sure', 'Are you sure you want to remove permanently all plans in the trash bin? This action cannot be undone.'),
('en', 'admin', 'plans-trash', 'txt_removed_all', 'All plans removed'),
('en', 'admin', 'process-settings', 'txt_html_title', 'Settings Updated'),
('en', 'admin', 'process-settings', 'txt_main_title', 'Settings'),
('en', 'admin', 'process-settings', 'txt_update_success', 'Settings saved'),
('en', 'admin', 'reviews', 'txt_html_title', 'Reviews'),
('en', 'admin', 'reviews', 'txt_main_title', 'Reviews'),
('en', 'admin', 'reviews', 'txt_place_name', 'Place Name'),
('en', 'admin', 'reviews', 'txt_tooltip_toggle_approved', 'Toggle Approved/Pending'),
('en', 'admin', 'reviews', 'txt_tooltip_expand_review', 'Expand Review'),
('en', 'admin', 'reviews', 'txt_tooltip_remove_review', 'Remove Review'),
('en', 'admin', 'reviews', 'txt_no_reviews_pending', 'There are no reviews pending moderation'),
('en', 'admin', 'reviews-trash', 'txt_html_title', 'Reviews - Trash'),
('en', 'admin', 'reviews-trash', 'txt_main_title', 'Reviews - Trash'),
('en', 'admin', 'reviews-trash', 'txt_empty_trash', 'Empty Reviews Trash'),
('en', 'admin', 'reviews-trash', 'txt_place_name', 'Place name'),
('en', 'admin', 'reviews-trash', 'txt_remove_perm', 'Remove permanently'),
('en', 'admin', 'reviews-trash', 'txt_remove_perm_sure', 'Are you sure you want to remove this review permanently? This action cannot be undone.'),
('en', 'admin', 'reviews-trash', 'txt_remove_perm_sure_all', 'Are you sure you want to remove permanently all reviews in the trash can? This action cannot be undone.'),
('en', 'admin', 'reviews-trash', 'txt_remove_review', 'Remove review'),
('en', 'admin', 'reviews-trash', 'txt_tooltip_expand_review', 'Expand review'),
('en', 'admin', 'reviews-trash', 'txt_tooltip_remove_review', 'Remove review permanently'),
('en', 'admin', 'reviews-trash', 'txt_tooltip_restore', 'Restore review'),
('en', 'admin', 'settings', 'txt_html_title', 'Settings'),
('en', 'admin', 'settings', 'txt_main_title', 'Settings'),
('en', 'admin', 'settings', 'txt_admin_email', 'Admin email'),
('en', 'admin', 'settings', 'txt_contact_business_subject', 'Contact Business Subject'),
('en', 'admin', 'settings', 'txt_contact_user_subject', 'Contact User Subject'),
('en', 'admin', 'settings', 'txt_country_code', 'Country code'),
('en', 'admin', 'settings', 'txt_country_code_explain', 'ISO 3166-1 alpha-2: two-letter country code, will also be used to build canonical urls so don''t change this often'),
('en', 'admin', 'settings', 'txt_country_name', 'Country name'),
('en', 'admin', 'settings', 'txt_currency_code', 'Currency code'),
('en', 'admin', 'settings', 'txt_currency_code_explain', '3-character <a href=''https://en.wikipedia.org/wiki/ISO_4217#Active_codes'' target=''_blank''>ISO-4217</a> currency code. This will be used when sending data to Paypal.'),
('en', 'admin', 'settings', 'txt_currency_symbol', 'Currency symbol'),
('en', 'admin', 'settings', 'txt_default_cat', 'Default category'),
('en', 'admin', 'settings', 'txt_default_city_id', 'Default city id'),
('en', 'admin', 'settings', 'txt_default_city_id_explain', 'The database row id of the default city '),
('en', 'admin', 'settings', 'txt_default_city_slug', 'Default city slug'),
('en', 'admin', 'settings', 'txt_default_city_slug_explain', 'Slugs are used in urls, lower case name of the default city without special characters or spaces(use dash instead)'),
('en', 'admin', 'settings', 'txt_default_coupon_qty', 'Coupons per ad'),
('en', 'admin', 'settings', 'txt_default_lat', 'Default latitude'),
('en', 'admin', 'settings', 'txt_default_lng', 'Default longitude'),
('en', 'admin', 'settings', 'txt_dev_email', 'Dev email'),
('en', 'admin', 'settings', 'txt_disqus_shortname', 'Disqus Shortname'),
('en', 'admin', 'settings', 'txt_facebook_key', 'Facebook API key'),
('en', 'admin', 'settings', 'txt_facebook_key_explain', 'Used for social login.'),
('en', 'admin', 'settings', 'txt_facebook_secret', 'Facebook API Secret'),
('en', 'admin', 'settings', 'txt_gateway_currency', 'Currency '),
('en', 'admin', 'settings', 'txt_gateway_mode', 'Gateway Mode'),
('en', 'admin', 'settings', 'txt_gmaps_key', 'Google maps key'),
('en', 'admin', 'settings', 'txt_gmaps_key_explain', 'This API key is required to display maps using Google Maps'),
('en', 'admin', 'settings', 'txt_here_key', 'HERE App ID'),
('en', 'admin', 'settings', 'txt_here_secret', 'HERE App Code'),
('en', 'admin', 'settings', 'txt_html_lang', 'HTML lang'),
('en', 'admin', 'settings', 'txt_html_lang_explain', 'the value for the html lang attribute'),
('en', 'admin', 'settings', 'txt_items_per_page', 'Items per page'),
('en', 'admin', 'settings', 'txt_items_per_page_explain', 'How many items to show on each results page'),
('en', 'admin', 'settings', 'txt_live', 'Live'),
('en', 'admin', 'settings', 'txt_live_publishable_key', 'Live Publishable Key'),
('en', 'admin', 'settings', 'txt_live_secret_key', 'Live Secret Key'),
('en', 'admin', 'settings', 'txt_mail_after_post', 'Receive notification on post/edit listing?'),
('en', 'admin', 'settings', 'txt_maintenance_mode', 'Maintenance Mode'),
('en', 'admin', 'settings', 'txt_map_provider', 'Map Provider'),
('en', 'admin', 'settings', 'txt_mapbox_secret', 'MapBox Access Token'),
('en', 'admin', 'settings', 'txt_max_pics', 'Max pics'),
('en', 'admin', 'settings', 'txt_max_pics_explain', 'How many pictures can each business upload'),
('en', 'admin', 'settings', 'txt_paypal_checkout_logo_url', 'Paypal Checkout Logo Url'),
('en', 'admin', 'settings', 'txt_paypal_checkout_logo_url_explain', 'The URL of the logo that will be used on the Paypal checkout page.'),
('en', 'admin', 'settings', 'txt_paypal_header', 'Paypal Settings'),
('en', 'admin', 'settings', 'txt_paypal_locale', 'Paypal login page locale'),
('en', 'admin', 'settings', 'txt_paypal_merchant_id', 'Paypal merchant id'),
('en', 'admin', 'settings', 'txt_paypal_mode', 'Paypal mode (live or sandbox)'),
('en', 'admin', 'settings', 'txt_paypal_sandbox_merch_id', 'Paypal Sandbox merchant id'),
('en', 'admin', 'settings', 'txt_sandbox', 'Sandbox'),
('en', 'admin', 'settings', 'txt_site_name', 'Site name'),
('en', 'admin', 'settings', 'txt_smtp_pass', 'SMTP pass'),
('en', 'admin', 'settings', 'txt_smtp_port', 'SMTP port'),
('en', 'admin', 'settings', 'txt_smtp_server', 'SMTP server'),
('en', 'admin', 'settings', 'txt_smtp_user', 'SMTP user'),
('en', 'admin', 'settings', 'txt_stripe_currency_code', '3-Letter ISO Code'),
('en', 'admin', 'settings', 'txt_stripe_header', 'Stripe Settings'),
('en', 'admin', 'settings', 'txt_stripe_test_mode', 'Test'),
('en', 'admin', 'settings', 'txt_tab_apis', 'APIs'),
('en', 'admin', 'settings', 'txt_tab_email', 'Email'),
('en', 'admin', 'settings', 'txt_tab_general', 'General'),
('en', 'admin', 'settings', 'txt_tab_payment', 'Payment'),
('en', 'admin', 'settings', 'txt_test_publishable_key', 'Test Publishable Key'),
('en', 'admin', 'settings', 'txt_test_secret_key', 'Test Secret Key'),
('en', 'admin', 'settings', 'txt_timezone', 'Timezone'),
('en', 'admin', 'settings', 'txt_timezone_explain', 'Enter your timezone. <a href=''http://php.net/manual/en/timezones.php'' target=''_blank''>Click here</a> for a list of possible values.'),
('en', 'admin', 'settings', 'txt_tomtom_secret', 'TomTom Key'),
('en', 'admin', 'settings', 'txt_twitter_key', 'Twitter API key'),
('en', 'admin', 'settings', 'txt_twitter_key_explain', 'Used for social login.'),
('en', 'admin', 'settings', 'txt_twitter_secret', 'Twitter API secret'),
('en', 'admin', 'tools', 'txt_html_title', 'Admin Tools'),
('en', 'admin', 'tools', 'txt_main_title', 'Admin Tools'),
('en', 'admin', 'tools', 'txt_deactivate_expired', 'Deactivate expired listings'),
('en', 'admin', 'tools', 'txt_deactivate_success', 'Expired listings deactivated successfully'),
('en', 'admin', 'tools', 'txt_deactivate_fail', 'Expired listings deactivated failed'),
('en', 'admin', 'tools', 'txt_delete_tmp_pics', 'Delete temp images'),
('en', 'admin', 'tools', 'txt_regenerate_sitemap', 'Regenerate sitemap.xml'),
('en', 'admin', 'tools', 'txt_submit_sitemap', 'Submit sitemap.xml to Google'),
('en', 'admin', 'tools', 'txt_tool', 'Tool'),
('en', 'admin', 'transactions', 'txt_html_title', 'Transactions History'),
('en', 'admin', 'transactions', 'txt_main_title', 'Transactions History'),
('en', 'admin', 'transactions', 'txt_txn_id', 'Txn Id'),
('en', 'admin', 'transactions', 'txt_place_id', 'Place Id'),
('en', 'admin', 'transactions', 'txt_txn_type', 'Txn Type'),
('en', 'admin', 'transactions', 'txt_amount', 'Amount'),
('en', 'admin', 'transactions', 'txt_sub_id', 'Subscr Id'),
('en', 'admin', 'transactions', 'txt_txn_date', 'Txn Date'),
('en', 'admin', 'users', 'txt_html_title', 'Users'),
('en', 'admin', 'users', 'txt_main_title', 'Users'),
('en', 'admin', 'users', 'txt_by_date', 'By date'),
('en', 'admin', 'users', 'txt_by_email', 'By email'),
('en', 'admin', 'users', 'txt_by_name', 'By name'),
('en', 'admin', 'users', 'txt_created', 'Created'),
('en', 'admin', 'users', 'txt_no_users', 'There are no users'),
('en', 'admin', 'users', 'txt_approve_profile_pic', 'Approve Profile Pic'),
('en', 'admin', 'users', 'txt_remove_user', 'Remove User'),
('en', 'admin', 'users-trash', 'txt_html_title', 'Users - Trash'),
('en', 'admin', 'users-trash', 'txt_main_title', 'Users - Trash'),
('en', 'admin', 'users-trash', 'txt_by_date', 'By date'),
('en', 'admin', 'users-trash', 'txt_by_email', 'By email'),
('en', 'admin', 'users-trash', 'txt_by_name', 'By name'),
('en', 'admin', 'users-trash', 'txt_created', 'Created'),
('en', 'admin', 'users-trash', 'txt_modal_remove_title', 'Remove User'),
('en', 'admin', 'users-trash', 'txt_remove_perm_sure', 'Are you sure you want to remove this user permanently? This action cannot be undone.'),
('en', 'admin', 'users-trash', 'txt_remove_perm_sure_all', 'Are you sure you want to remove permanently all users in the trash can? This action cannot be undone.'),
('en', 'admin', 'users-trash', 'txt_tooltip_remove_user', 'Remove user permanently'),
('en', 'admin', 'users-trash', 'txt_tooltip_restore', 'Restore user'),
('en', 'admin', 'admin-global', 'txt_language', 'Language'),
('en', 'admin', 'language', 'txt_main_title', 'Language'),
('en', 'admin', 'language', 'txt_html_title', 'Language'),
('en', 'admin', 'language', 'txt_installed_lang', 'Installed languages'),
('en', 'admin', 'language', 'txt_create_lang', 'Create Language'),
('en', 'admin', 'language', 'txt_template', 'Template'),
('en', 'admin', 'language', 'txt_load_vars', 'Load vars'),
('en', 'admin', 'language', 'txt_vars', 'Vars'),
('en', 'admin', 'language', 'txt_select_lang_create', 'Select language to create'),
('en', 'admin', 'language', 'txt_install_sql', 'Or install from available sql files'),
('en', 'admin', 'language', 'txt_install', 'Install'),
('en', 'admin', 'language', 'txt_installing', 'Installing...'),
('en', 'admin', 'language', 'txt_done', 'Done'),
('en', 'admin', 'language', 'txt_install_lang', 'Install language'),
('en', 'admin', 'custom-fields-trash', 'txt_field_name', 'Field Name'),
('en', 'admin', 'custom-fields-trash', 'txt_field_type', 'Field Type'),
('en', 'admin', 'custom-fields-trash', 'txt_type_text', 'Text'),
('en', 'admin', 'custom-fields-trash', 'txt_type_radio', 'Radio'),
('en', 'admin', 'custom-fields-trash', 'txt_type_select', 'Select'),
('en', 'admin', 'custom-fields-trash', 'txt_type_check', 'Checkbox'),
('en', 'admin', 'custom-fields-trash', 'txt_type_multiline', 'Text Multiline'),
('en', 'admin', 'custom-fields-trash', 'txt_type_url', 'URL'),
('en', 'admin', 'custom-fields-trash', 'txt_values_list', 'List of values allowed <em>(separated by ;)</em> *only used for radio, select and checkboxes'),
('en', 'admin', 'custom-fields-trash', 'txt_tooltip', 'Tooltip <em>(optional)</em>'),
('en', 'admin', 'custom-fields-trash', 'txt_icon', 'Icon tag (e.g. fontawesome tag)'),
('en', 'admin', 'custom-fields-trash', 'txt_options', 'Options'),
('en', 'admin', 'custom-fields-trash', 'txt_required', 'Required?'),
('en', 'admin', 'custom-fields-trash', 'txt_searchable', 'Searchable?'),
('en', 'admin', 'custom-fields-trash', 'txt_field_order', 'Field Order'),
('en', 'admin', 'custom-fields-trash', 'txt_categories', 'Categories'),
('en', 'admin', 'custom-fields-trash', 'txt_show_html_title', 'Custom Fields - Trash'),
('en', 'admin', 'custom-fields-trash', 'txt_show_main_title', 'Custom Fields - Trash'),
('en', 'admin', 'custom-fields-trash', 'txt_show_create_field', 'Create Field'),
('en', 'admin', 'custom-fields-trash', 'txt_show_edit_field', 'Edit this custom field'),
('en', 'admin', 'custom-fields-trash', 'txt_show_remove_field', 'Remove this custom field'),
('en', 'admin', 'custom-fields-trash', 'txt_field_created', 'Field created'),
('en', 'admin', 'custom-fields-trash', 'txt_create_another', 'Create another field.'),
('en', 'admin', 'custom-fields-trash', 'txt_field_removed', 'Field removed'),
('en', 'admin', 'custom-fields-trash', 'txt_header_custom_fields', 'Additional Information'),
('en', 'admin', 'custom-fields-trash', 'txt_no_custom_fields', 'No custom fields available for this category'),
('en', 'admin', 'custom-fields-trash', 'txt_html_title', 'Custom Fields - Trash'),
('en', 'admin', 'custom-fields-trash', 'txt_main_title', 'Custom Fields - Trash'),
('en', 'admin', 'custom-fields-trash', 'txt_meta_desc', 'Custom Fields'),
('en', 'admin', 'custom-fields-trash', 'txt_search_results', 'Search Results'),
('en', 'admin', 'custom-fields-trash', 'txt_label_keyword', 'Keyword'),
('en', 'admin', 'custom-fields-trash', 'txt_label_city', 'Select City'),
('en', 'admin', 'custom-fields-trash', 'txt_label_category', 'Select Category'),
('en', 'admin', 'custom-fields-trash', 'txt_label_cat_all', 'Select All'),
('en', 'admin', 'custom-fields-trash', 'txt_remove_custom_field', 'Remove Custom Field'),
('en', 'admin', 'custom-fields-trash', 'txt_remove_sure', 'Are you sure you want to remove this field? This action cannot be undone.'),
('en', 'admin', 'custom-fields-trash', 'txt_remove_all_sure', 'Are you sure you want to empty the trash bin? This action cannot be undone.'),
('en', 'public', 'maintenance', 'txt_html_title', 'Site Maintenance'),
('en', 'public', 'maintenance', 'txt_message', 'The site will be back soon'),
('en', 'admin', 'language', 'txt_create_string', 'Create String'),
('en', 'admin', 'language', 'txt_var_name', 'Variable Name (starts with txt_ e.g. txt_var_name)'),
('en', 'admin', 'language', 'txt_string_value', 'String Value'),
('en', 'admin', 'language', 'txt_string_created', 'String Created'),
('en', 'admin', 'admin-global', 'txt_maps', 'Maps'),
('en', 'admin', 'settings', 'txt_permalink_struct', 'Permalink Structure (*regenerate sitemap after change)'),
('en', 'admin', 'settings', 'txt_permalink_struct_explain', 'Available tags(use / as separator): %category%/%region%/%city%/%title%'),
('en', 'admin', 'language', 'txt_string_created', 'String Created'),
('en', 'admin', 'admin-global', 'txt_maps', 'Maps'),
('en', 'user', 'create-listing', 'txt_primary_category', 'Primary Category'),
('en', 'user', 'create-listing', 'txt_additional_categories', 'Additional Categories'),
('en', 'user', 'edit-listing', 'txt_primary_category', 'Primary Category'),
('en', 'user', 'edit-listing', 'txt_additional_categories', 'Additional Categories');

--
-- v.3.32
--

INSERT INTO `language` (`lang`, `section`, `template`, `var_name`, `translated`) VALUES
('en', 'public', 'global', 'txt_nearby', 'Nearby'),
('en', 'public', 'global', 'txt_enable_geo', 'Geolocation is not enabled. Please enable to use this feature'),
('en', 'admin', 'settings', 'txt_nearby_filter_values', 'Nearby filter values(separated by semicolon)'),
('en', 'admin', 'settings', 'txt_distance_unit', 'Distance unit'),
('en', 'public', 'global', 'txt_filters', 'Filters'),
('en', 'public', 'global', 'txt_from', 'from'),
('en', 'public', 'global', 'txt_to', 'to');

