IP : 18.220.255.227Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
./
../
var/
softaculous/
firefly/
../
extplorer/
../
../
softaculous/
livehelper/
livehelper.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `lhc_mailconv_match_rule` --
CREATE TABLE `lhc_mailconv_match_rule` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dep_id` int(11) unsigned NOT NULL, `conditions` text COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `mailbox_id` text COLLATE utf8mb4_unicode_ci NOT NULL, `from_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `from_mail` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_contains` text COLLATE utf8mb4_unicode_ci NOT NULL, `priority` int(11) NOT NULL, `priority_rule` int(11) NOT NULL, `options` text COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `active_priority` (`active`,`priority`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `lhc_mailconv_oauth_ms` --
CREATE TABLE `lhc_mailconv_oauth_ms` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `mailbox_id` bigint(20) unsigned NOT NULL, `oauth_uid` varchar(50) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `surname` varchar(200) NOT NULL, `display_name` varchar(200) NOT NULL, `txtSessionKey` varchar(255) NOT NULL, `txtCodeVerifier` varchar(255) NOT NULL, `dtExpires` bigint(20) unsigned NOT NULL, `txtRefreshToken` text NOT NULL, `txtToken` text NOT NULL, `txtIDToken` text NOT NULL, `completed` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `oauth_uid` (`oauth_uid`), KEY `user_id_completed` (`mailbox_id`,`completed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=31 ;
-- -- Table structure for table `lh_abstract_auto_responder` --
CREATE TABLE `lh_abstract_auto_responder` ( `id` int(11) NOT NULL AUTO_INCREMENT, `siteaccess` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `wait_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout` int(11) NOT NULL, `position` int(11) NOT NULL, `timeout_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `bot_configuration` text COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `operator` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `dep_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `only_proactive` int(11) NOT NULL, `repeat_number` int(11) NOT NULL DEFAULT '1', `survey_timeout` int(11) NOT NULL DEFAULT '0', `survey_id` int(11) NOT NULL DEFAULT '0', `disabled` tinyint(1) NOT NULL DEFAULT '0', `wait_timeout_hold_1` int(11) NOT NULL, `wait_timeout_hold_2` int(11) NOT NULL, `wait_timeout_hold_3` int(11) NOT NULL, `wait_timeout_hold_4` int(11) NOT NULL, `wait_timeout_hold_5` int(11) NOT NULL, `timeout_hold_message_1` text COLLATE utf8mb4_unicode_ci NOT NULL, `timeout_hold_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL, `timeout_hold_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL, `timeout_hold_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL, `timeout_hold_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_hold` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_2` int(11) NOT NULL, `timeout_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_3` int(11) NOT NULL, `timeout_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_4` int(11) NOT NULL, `timeout_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_5` int(11) NOT NULL, `timeout_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_reply_1` int(11) NOT NULL, `timeout_reply_message_1` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_reply_2` int(11) NOT NULL, `timeout_reply_message_2` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_reply_3` int(11) NOT NULL, `timeout_reply_message_3` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_reply_4` int(11) NOT NULL, `timeout_reply_message_4` text COLLATE utf8mb4_unicode_ci NOT NULL, `wait_timeout_reply_5` int(11) NOT NULL, `timeout_reply_message_5` text COLLATE utf8mb4_unicode_ci NOT NULL, `languages` text COLLATE utf8mb4_unicode_ci NOT NULL, `ignore_pa_chat` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `siteaccess_position` (`siteaccess`,`position`), KEY `disabled` (`disabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `lh_abstract_survey` --
CREATE TABLE `lh_abstract_survey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_1_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_1_pos` int(11) NOT NULL, `max_stars_2_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_2_pos` int(11) NOT NULL, `max_stars_2` int(11) NOT NULL, `max_stars_3_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_3_pos` int(11) NOT NULL, `max_stars_3` int(11) NOT NULL, `max_stars_4_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_4_pos` int(11) NOT NULL, `max_stars_4` int(11) NOT NULL, `max_stars_5_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `max_stars_5_pos` int(11) NOT NULL, `max_stars_5` int(11) NOT NULL, `question_options_1` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_1_items` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_1_pos` int(11) NOT NULL, `question_options_2` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_2_items` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_2_pos` int(11) NOT NULL, `question_options_3` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_3_items` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_3_pos` int(11) NOT NULL, `question_options_4` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_4_items` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_4_pos` int(11) NOT NULL, `question_options_5` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_5_items` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_options_5_pos` int(11) NOT NULL, `question_plain_1` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_plain_1_pos` int(11) NOT NULL, `question_plain_2` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_plain_2_pos` int(11) NOT NULL, `question_plain_3` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_plain_3_pos` int(11) NOT NULL, `question_plain_4` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_plain_4_pos` int(11) NOT NULL, `question_plain_5` text COLLATE utf8mb4_unicode_ci NOT NULL, `question_plain_5_pos` int(11) NOT NULL, `max_stars_1_enabled` int(11) NOT NULL, `max_stars_2_enabled` int(11) NOT NULL, `max_stars_3_enabled` int(11) NOT NULL, `max_stars_4_enabled` int(11) NOT NULL, `max_stars_5_enabled` int(11) NOT NULL, `question_options_1_enabled` int(11) NOT NULL, `question_options_2_enabled` int(11) NOT NULL, `question_options_3_enabled` int(11) NOT NULL, `question_options_4_enabled` int(11) NOT NULL, `question_options_5_enabled` int(11) NOT NULL, `question_plain_1_enabled` int(11) NOT NULL, `question_plain_2_enabled` int(11) NOT NULL, `question_plain_3_enabled` int(11) NOT NULL, `question_plain_4_enabled` int(11) NOT NULL, `question_plain_5_enabled` int(11) NOT NULL, `max_stars_1` int(11) NOT NULL, `max_stars_1_req` int(11) NOT NULL, `max_stars_2_req` int(11) NOT NULL, `max_stars_3_req` int(11) NOT NULL, `max_stars_4_req` int(11) NOT NULL, `max_stars_5_req` int(11) NOT NULL, `question_options_1_req` int(11) NOT NULL, `question_options_2_req` int(11) NOT NULL, `question_options_3_req` int(11) NOT NULL, `question_options_4_req` int(11) NOT NULL, `question_options_5_req` int(11) NOT NULL, `question_plain_1_req` int(11) NOT NULL, `question_plain_2_req` int(11) NOT NULL, `question_plain_3_req` int(11) NOT NULL, `question_plain_4_req` int(11) NOT NULL, `question_plain_5_req` int(11) NOT NULL, `configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `identifier` (`identifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `lh_abstract_widget_theme` --
CREATE TABLE `lh_abstract_widget_theme` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `name_company` text COLLATE utf8mb4_unicode_ci NOT NULL, `onl_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `bor_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'e3e3e3', `text_color` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `online_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `online_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `offline_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `offline_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `logo_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `logo_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `header_background` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_tcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_bcolor` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_border` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_close_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_hover_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_close_hover_bg` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `custom_status_css` text COLLATE utf8mb4_unicode_ci NOT NULL, `custom_container_css` text COLLATE utf8mb4_unicode_ci NOT NULL, `custom_widget_css` text COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_header` text COLLATE utf8mb4_unicode_ci NOT NULL, `need_help_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `online_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `offline_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `widget_border_color` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `copyright_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `copyright_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `widget_copyright_url` text COLLATE utf8mb4_unicode_ci NOT NULL, `show_copyright` int(11) NOT NULL DEFAULT '1', `explain_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `intro_operator_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `operator_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `operator_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `minimize_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `minimize_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `restore_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `restore_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `close_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `close_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `popup_image` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `popup_image_path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `hide_close` int(11) NOT NULL DEFAULT '0', `hide_popup` int(11) NOT NULL DEFAULT '0', `header_height` int(11) NOT NULL DEFAULT '0', `header_padding` int(11) NOT NULL DEFAULT '0', `widget_border_width` int(11) NOT NULL DEFAULT '0', `support_joined` text COLLATE utf8mb4_unicode_ci NOT NULL, `support_closed` text COLLATE utf8mb4_unicode_ci NOT NULL, `pending_join` text COLLATE utf8mb4_unicode_ci NOT NULL, `noonline_operators` text COLLATE utf8mb4_unicode_ci NOT NULL, `noonline_operators_offline` text COLLATE utf8mb4_unicode_ci NOT NULL, `show_need_help` int(11) NOT NULL DEFAULT '1', `show_need_help_timeout` int(11) NOT NULL DEFAULT '24', `show_voting` tinyint(1) NOT NULL DEFAULT '1', `department_title` text COLLATE utf8mb4_unicode_ci NOT NULL, `department_select` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_visitor_background` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_visitor_title_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_visitor_text_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_operator_background` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_operator_title_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `buble_operator_text_color` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `custom_popup_css` text COLLATE utf8mb4_unicode_ci NOT NULL, `hide_ts` tinyint(1) unsigned NOT NULL DEFAULT '0', `hide_op_ts` tinyint(1) unsigned NOT NULL DEFAULT '0', `widget_response_width` int(11) NOT NULL DEFAULT '0', `show_need_help_delay` int(11) NOT NULL DEFAULT '0', `show_status_delay` int(11) NOT NULL DEFAULT '0', `modern_look` tinyint(1) NOT NULL DEFAULT '0', `bot_status_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `bot_configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `notification_configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `pending_join_queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `modified` int(11) NOT NULL, `widget_show_leave_form` tinyint(1) NOT NULL, `enable_widget_embed_override` tinyint(1) NOT NULL, `widget_popheight` int(11) NOT NULL, `widget_popwidth` int(11) NOT NULL, `widget_survey` int(11) NOT NULL, `widget_position` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `widget_pright` int(11) NOT NULL, `widget_pbottom` int(11) NOT NULL, `alias` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `alias` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- -- Table structure for table `lh_chat_config` --
CREATE TABLE `lh_chat_config` ( `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint(1) NOT NULL DEFAULT '0', `explain` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `hidden` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Dumping data for table `lh_chat_config` --
INSERT INTO `lh_chat_config` VALUES ('accept_chat_link_timeout', '300', 0, 'How many seconds chat accept link is valid. Set 0 to force login all the time manually.', 0), ('accept_tos_link', '#', 0, 'Change to your site Terms of Service', 0), ('activity_timeout', '5', 0, 'How long operator should go offline automatically because of inactivity. Value in minutes', 0), ('activity_track_all', '0', 0, 'Track all logged operators activity and ignore their individual settings.', 0), ('allow_reopen_closed', '0', 0, 'Allow user to reopen closed chats?', 0), ('application_name', 'a:6:{s:3:"eng";s:31:"Live Helper Chat - live support";s:3:"lit";s:26:"Live Helper Chat - pagalba";s:3:"hrv";s:0:"";s:3:"esp";s:0:"";s:3:"por";s:0:"";s:10:"site_admin";s:31:"Live Helper Chat - live support";}', 1, 'Support application name, visible in browser title.', 0), ('assign_workflow_timeout', '0', 0, 'Chats waiting in pending line more than n seconds should be auto assigned first. Time in seconds', 0), ('autoclose_abandon_pending', '0,0', 0, 'Automatically close pending chats where visitor has left a chat. Timeout in minutes, last activity by visitor <desktop timeout>,<mobile timeout>,<status chat>', 0), ('autoclose_activity_timeout', '0', 0, 'Automatically close active chat if from last visitor/operator message passed. 0 - disabled, n > 0 time in minutes', 0), ('autoclose_timeout', '0', 0, 'Automatic chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0), ('autoclose_timeout_active', '0', 0, 'Automatic active chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0), ('autoclose_timeout_bot', '0', 0, 'Automatic bot chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0), ('autoclose_timeout_pending', '0', 0, 'Automatic pending chats closing. 0 - disabled, n > 0 time in minutes before chat is automatically closed', 0), ('autologin_data', 'a:3:{i:0;b:0;s:11:"secret_hash";s:16:"please_change_me";s:7:"enabled";i:0;}', 0, 'Autologin configuration data', 1), ('automatically_reopen_chat', '1', 0, 'Automatically reopen chat on widget open', 0), ('autopurge_timeout', '0', 0, 'Automatic chats purging. 0 - disabled, n > 0 time in minutes before chat is automatically deleted', 0), ('banned_ip_range', '', 0, 'Which ip should not be allowed to chat', 0), ('bbc_button_visible', '1', 0, 'Show BB Code button', 0), ('bbcode_options', 'a:2:{s:3:"div";a:0:{}s:3:"dio";a:0:{}}', 0, '', 1), ('cduration_timeout_operator', '10', 0, 'How long visitor can wait for message from operator before time between messages are ignored. Values in minutes.', 0), ('cduration_timeout_user', '4', 0, 'How long operator can wait for message from visitor before time between messages are ignored. Values in minutes.', 0), ('chatbox_data', 'a:6:{i:0;b:0;s:20:"chatbox_auto_enabled";i:0;s:19:"chatbox_secret_hash";[[chatbox_secret_hash]]s:20:"chatbox_default_name";s:7:"Chatbox";s:17:"chatbox_msg_limit";i:50;s:22:"chatbox_default_opname";s:7:"Manager";}', 0, 'Chatbox configuration', 1), ('checkstatus_timeout', '0', 0, 'Interval between chat status checks in seconds, 0 disabled.', 0), ('cleanup_cronjob', '0', 0, 'Cleanup should be done only using cronjob.', 0), ('customer_company_name', 'Live Helper Chat', 0, 'Your company name - visible in bottom left corner', 0), ('customer_site_url', 'http://livehelperchat.com', 0, 'Your site URL address', 0), ('dashboard_order', '[["online_operators","departments_stats","online_visitors"],["group_chats","my_chats","pending_chats","transfered_chats"],["active_chats","bot_chats"]]', 0, 'Home page dashboard widgets order', 0), ('default_admin_theme_id', '0', 0, 'Default admin theme ID', 1), ('default_theme_id', '0', 0, 'Default theme ID.', 1), ('departament_availability', '364', 0, 'How long department availability statistic should be kept? (days)', 0), ('disable_html5_storage', '1', 0, 'Disable HMTL5 storage, check it if your site is switching between http and https', 0), ('disable_iframe_sharing', '1', 0, 'Disable iframes in sharing mode', 0), ('disable_js_execution', '1', 0, 'Disable JS execution in Co-Browsing operator window', 0), ('disable_live_autoassign', '0', 0, 'Disable live auto assign', 0), ('disable_popup_restore', '0', 0, 'Disable option in widget to open new window. Restore icon will be hidden', 0), ('disable_print', '0', 0, 'Disable chat print', 0), ('disable_send', '0', 0, 'Disable chat transcript send', 0), ('disable_txt_dwnld', '0', 0, 'Disable chat download', 0), ('do_no_track_ip', '0', 0, 'Do not track visitors IP', 0), ('enable_status_cache', '0', 0, 'Enable status check cache using Redis. PHPResque extension is required.', 0), ('encrypt_msg_after', '0', 0, 'After how many days anonymize messages', 0), ('encrypt_msg_op', '0', 0, 'Anonymize also operators messages', 0), ('explicit_http_mode', '', 0, 'Please enter explicit http mode. Either http: or https:, do not forget : at the end.', 0), ('export_hash', '[[export_hash]]', 0, 'Chats export secret hash', 0), ('faq_email_required', '0', 0, 'Is visitor e-mail required for FAQ', 0), ('file_configuration', 'a:7:{i:0;b:0;s:5:"ft_op";s:47:"gif|jpe?g|png|zip|svg|rar|xls|doc|docx|xlsx|pdf";s:5:"ft_us";s:30:"gif|jpe?g|png|svg|doc|docx|pdf";s:6:"fs_max";i:2048;s:18:"active_user_upload";b:0;s:16:"active_op_upload";b:1;s:19:"active_admin_upload";b:1;}', 0, 'Files configuration item', 1), ('footprint_background', '0', 0, 'Footprint updates should be processed in the background. Make sure you are running workflow background cronjob.', 0), ('front_tabs', 'dashboard,online_users,online_map', 0, 'Home page tabs order', 0), ('geo_data', 'a:5:{i:0;b:0;s:21:"geo_detection_enabled";i:1;s:22:"geo_service_identifier";s:8:"max_mind";s:23:"max_mind_detection_type";s:7:"country";s:22:"max_mind_city_location";s:37:"var/external/geoip/GeoLite2-City.mmdb";}', 0, '', 1), ('geo_location_data', 'a:3:{s:4:"zoom";i:4;s:3:"lat";s:7:"49.8211";s:3:"lng";s:7:"11.7835";}', 0, '', 1), ('geoadjustment_data', 'a:8:{i:0;b:0;s:18:"use_geo_adjustment";b:0;s:13:"available_for";s:0:"";s:15:"other_countries";s:6:"custom";s:8:"hide_for";s:0:"";s:12:"other_status";s:7:"offline";s:11:"rest_status";s:6:"hidden";s:12:"apply_widget";i:0;}', 0, 'Geo adjustment settings', 1), ('hide_button_dropdown', '0', 0, 'Hide close button in dropdown', 0), ('hide_disabled_department', '1', 0, 'Hide disabled department widget', 0), ('hide_right_column_frontpage', '1', 0, 'Hide right column in frontpage', 0), ('ignorable_ip', '', 0, 'Which ip should be ignored in online users list, separate by comma', 0), ('ignore_typing', '0', 0, 'Do not store what visitor is typing', 0), ('ignore_user_status', '0', 0, 'Ignore users online statuses and use departments online hours', 0), ('inform_unread_message', '0', 0, 'Inform visitor about unread messages from operator, value in minutes. 0 - disabled', 0), ('list_closed', '0', 0, 'List closed chats', 0), ('list_online_operators', '1', 0, 'List online operators.', 0), ('list_unread', '0', 0, 'List unread chats', 0), ('listd_op', '10', 0, 'Default number of online operators to show', 0), ('max_message_length', '500', 0, 'Maximum message length in characters', 0), ('message_seen_timeout', '24', 0, 'Proactive message timeout in hours. After how many hours proactive chat mesasge should be shown again.', 0), ('mheight', '', 0, 'Messages box height', 0), ('mheight_op', '200', 0, 'Messages box height for operator', 0), ('min_phone_length', '8', 0, 'Minimum phone number length', 0), ('mobile_options', 'a:2:{s:13:"notifications";i:0;s:7:"fcm_key";s:152:"AAAAiF8DeNk:APA91bFVHu2ybhBUTtlEtQrUEPpM2fb-5ovgo0FVNm4XxK3cYJtSwRcd-pqcBot_422yDOzHyw2p9ZFplkHrmNXjm8f5f-OIzfalGmpsypeXvnPxhU6Db1B2Z1Acc-TamHUn2F4xBJkP";}', 0, '', 1), ('need_help_tip', '1', 0, 'Show need help tooltip?', 0), ('need_help_tip_timeout', '24', 0, 'Need help tooltip timeout, after how many hours show again tooltip?', 0), ('no_wildcard_cookie', '0', 0, 'Cookie should be valid only for domain where Javascript is embedded (excludes subdomains)', 0), ('notice_message', '', 0, '', 1), ('on_close_exit_chat', '0', 0, 'On chat close exit chat', 0), ('online_if', '0', 0, '', 0), ('open_closed_chat_timeout', '1800', 0, 'How many seconds customer has to open already closed chat.', 0), ('paidchat_data', '', 0, 'Paid chat configuration', 1), ('password_data', '', 0, 'Password requirements', 1), ('preload_iframes', '0', 0, 'Preload widget. It will avoid loading delay after clicking widget', 0), ('pro_active_invite', '1', 0, 'Is pro active chat invitation active. Online users tracking also has to be enabled', 0), ('pro_active_limitation', '-1', 0, 'Pro active chats invitations limitation based on pending chats, (-1) do not limit, (0,1,n+1) number of pending chats can be for invitation to be shown.', 0), ('pro_active_show_if_offline', '0', 0, 'Should invitation logic be executed if there is no online operators', 0), ('product_enabled_module', '0', 0, 'Product module is enabled', 1), ('product_show_departament', '0', 0, 'Enable products show by departments', 1), ('recaptcha_data', 'a:4:{i:0;b:0;s:8:"site_key";s:0:"";s:10:"secret_key";s:0:"";s:7:"enabled";i:0;}', 0, 'Re-captcha configuration', 1), ('remember_phone_email', '1', 0, 'Should we remember E-Mail, Phone for the next time visitor starts a chat?', 0), ('remember_username', '1', 0, 'Should we remember username for the next time visitor starts a chat?', 0), ('reopen_as_new', '1', 0, 'Reopen closed chat as new? Otherwise it will be reopened as active.', 0), ('reopen_chat_enabled', '0', 0, 'Reopen chat functionality enabled', 0), ('reverse_pending', '0', 0, 'Make default pending chats order from old to new', 0), ('run_departments_workflow', '0', 0, 'Should cronjob run departments transfer workflow, even if user leaves a chat', 0), ('run_unaswered_chat_workflow', '0', 0, 'Should cronjob run unanswered chats workflow and execute unaswered chats callback, 0 - no, any other number bigger than 0 is a minits how long chat have to be not accepted before executing callback.', 0), ('session_captcha', '0', 0, 'Use session captcha. LHC have to be installed on the same domain or subdomain.', 0), ('sharing_auto_allow', '0', 0, 'Do not ask permission for users to see their screen', 0), ('sharing_nodejs_enabled', '0', 0, 'NodeJs support enabled', 0), ('sharing_nodejs_path', '', 0, 'socket.io path, optional', 0), ('sharing_nodejs_secure', '0', 0, 'Connect to NodeJs in https mode', 0), ('sharing_nodejs_sllocation', 'https://cdn.jsdelivr.net/npm/socket.io-client@2/dist/socket.io.js', 0, 'Location of SocketIO JS library', 0), ('sharing_nodejs_socket_host', '', 0, 'Host where NodeJs is running', 0), ('show_language_switcher', '0', 0, 'Show users option to switch language at widget', 0), ('show_languages', 'eng,lit,hrv,esp,por,nld,ara,ger,pol,rus,ita,fre,chn,cse,nor,tur,vnm,idn,sve,per,ell,dnk,rou,bgr,tha,geo,fin,alb', 0, 'Between what languages user should be able to switch', 0), ('smtp_data', 'a:5:{s:4:"host";s:0:"";s:4:"port";s:2:"25";s:8:"use_smtp";i:0;s:8:"username";s:0:"";s:8:"password";s:0:"";}', 0, 'SMTP configuration', 1), ('sound_invitation', '1', 0, 'Play sound on invitation to chat.', 0), ('speech_data', 'a:3:{i:0;b:0;s:8:"language";i:7;s:7:"dialect";s:5:"en-US";}', 1, '', 1), ('start_chat_data', 'a:80:{i:0;b:0;s:21:"name_visible_in_popup";b:0;s:27:"name_visible_in_page_widget";b:0;s:19:"name_require_option";s:8:"required";s:22:"email_visible_in_popup";b:0;s:28:"email_visible_in_page_widget";b:0;s:20:"email_require_option";s:8:"required";s:24:"message_visible_in_popup";b:1;s:30:"message_visible_in_page_widget";b:1;s:22:"message_require_option";s:8:"required";s:22:"phone_visible_in_popup";b:0;s:28:"phone_visible_in_page_widget";b:0;s:20:"phone_require_option";s:8:"required";s:21:"force_leave_a_message";b:0;s:29:"offline_name_visible_in_popup";b:1;s:35:"offline_name_visible_in_page_widget";b:1;s:27:"offline_name_require_option";s:8:"required";s:30:"offline_phone_visible_in_popup";b:0;s:36:"offline_phone_visible_in_page_widget";b:0;s:28:"offline_phone_require_option";s:8:"required";s:32:"offline_message_visible_in_popup";b:1;s:38:"offline_message_visible_in_page_widget";b:1;s:30:"offline_message_require_option";s:8:"required";s:15:"auto_start_chat";b:0;s:12:"mobile_popup";b:0;s:17:"dont_auto_process";b:0;s:20:"tos_visible_in_popup";b:0;s:12:"requires_dep";b:0;s:17:"requires_dep_lock";b:0;s:17:"show_messages_box";b:1;s:26:"tos_visible_in_page_widget";b:0;s:19:"tos_checked_offline";b:0;s:18:"tos_checked_online";b:0;s:28:"offline_tos_visible_in_popup";b:0;s:34:"offline_tos_visible_in_page_widget";b:0;s:35:"offline_file_visible_in_page_widget";b:0;s:29:"offline_file_visible_in_popup";b:0;s:11:"name_hidden";b:0;s:15:"name_hidden_bot";b:0;s:24:"custom_fields_encryption";s:0:"";s:19:"offline_name_hidden";b:0;s:13:"pre_chat_html";s:0:"";s:21:"pre_offline_chat_html";s:0:"";s:12:"email_hidden";b:0;s:16:"email_hidden_bot";b:0;s:20:"offline_email_hidden";b:0;s:15:"user_msg_height";s:0:"";s:12:"phone_hidden";b:0;s:16:"phone_hidden_bot";b:0;s:20:"offline_phone_hidden";b:0;s:14:"message_hidden";b:0;s:18:"message_hidden_bot";b:0;s:18:"message_auto_start";b:0;s:28:"message_auto_start_key_press";b:0;s:22:"offline_message_hidden";b:0;s:21:"show_operator_profile";b:1;s:21:"remove_operator_space";b:0;s:18:"hide_message_label";b:0;s:17:"custom_fields_url";s:0:"";s:13:"custom_fields";s:0:"";s:21:"name_hidden_prefilled";b:0;s:22:"email_hidden_prefilled";b:0;s:24:"message_hidden_prefilled";b:0;s:22:"phone_hidden_prefilled";b:0;s:29:"offline_name_hidden_prefilled";b:0;s:32:"offline_message_hidden_prefilled";b:0;s:30:"offline_phone_hidden_prefilled";b:0;s:18:"disable_start_chat";b:0;s:18:"offline_name_width";i:0;s:19:"offline_email_width";i:0;s:19:"offline_phone_width";i:0;s:10:"name_width";i:0;s:11:"email_width";i:0;s:11:"phone_width";i:0;s:17:"hide_start_button";b:0;s:9:"lazy_load";b:0;s:28:"offline_email_require_option";s:8:"required";s:30:"offline_email_hidden_prefilled";b:0;s:36:"offline_email_visible_in_page_widget";b:1;s:30:"offline_email_visible_in_popup";b:1;}', 0, '', 1), ('suggest_leave_msg', '1', 0, 'Suggest user to leave a message then user chooses offline department', 0), ('sync_sound_settings', 'a:16:{i:0;b:0;s:12:"repeat_sound";i:1;s:18:"repeat_sound_delay";i:5;s:10:"show_alert";b:0;s:22:"new_chat_sound_enabled";b:1;s:31:"new_message_sound_admin_enabled";b:1;s:30:"new_message_sound_user_enabled";b:1;s:14:"online_timeout";d:300;s:22:"check_for_operator_msg";d:10;s:21:"back_office_sinterval";d:10;s:22:"chat_message_sinterval";d:3.5;s:20:"long_polling_enabled";b:0;s:30:"polling_chat_message_sinterval";d:1.5;s:29:"polling_back_office_sinterval";d:5;s:18:"connection_timeout";i:30;s:28:"browser_notification_message";b:0;}', 0, '', 1), ('track_activity', '0', 0, 'Track users activity on site?', 0), ('track_domain', '', 0, 'Set your domain to enable user tracking across different domain subdomains.', 0), ('track_footprint', '0', 0, 'Track users footprint. For this also online visitors tracking should be enabled', 0), ('track_if_offline', '0', 0, 'Track online visitors even if there is no online operators', 0), ('track_is_online', '0', 0, 'Track is user still on site, chat status checks also has to be enabled', 0), ('track_mouse_activity', '0', 0, 'Should mouse movement be tracked as activity measure, if not checked only basic events would be tracked', 0), ('track_online_visitors', '1', 0, 'Enable online site visitors tracking', 0), ('tracked_footprint_cleanup', '90', 0, 'How many days keep records of users footprint.', 0), ('tracked_users_cleanup', '160', 0, 'How many days keep records of online users.', 0), ('transfer_configuration', '0', 0, 'Transfer configuration', 1), ('translation_data', 'a:6:{i:0;b:0;s:19:"translation_handler";s:4:"bing";s:19:"enable_translations";b:0;s:14:"bing_client_id";s:0:"";s:18:"bing_client_secret";s:0:"";s:14:"google_api_key";s:0:"";}', 0, 'Translation data', 1), ('unban_ip_range', '', 0, 'Which ip should not be allowed to be blocked', 0), ('uonline_sessions', '364', 0, 'How long keep operators online sessions data? (days)', 0), ('update_ip', '127.0.0.1', 0, 'Which ip should be allowed to update DB by executing http request, separate by comma?', 0), ('use_secure_cookie', '0', 0, 'Use secure cookie, check this if you want to force SSL all the time', 0), ('valid_domains', '', 0, 'Domains where script can be embedded. E.g example.com, google.com', 0), ('voting_days_limit', '7', 0, 'How many days voting widget should not be expanded after last show', 0), ('vwait_to_long', '120', 0, 'How long we should wait before we inform operator about unanswered chat.', 0), ('xmp_data', 'a:14:{i:0;b:0;s:4:"host";s:15:"talk.google.com";s:6:"server";s:9:"gmail.com";s:8:"resource";s:6:"xmpphp";s:4:"port";s:4:"5222";s:7:"use_xmp";i:0;s:8:"username";s:0:"";s:8:"password";s:0:"";s:11:"xmp_message";s:98:"New chat request [{chat_id}] from [{department}]\r\n{messages}\r\nClick to accept a chat\r\n{url_accept}";s:10:"recipients";s:0:"";s:20:"xmp_accepted_message";s:89:"{user_name} has accepted a chat [{chat_id}] from [{department}]\r\n{messages}\r\n{url_accept}";s:16:"use_standard_xmp";i:0;s:15:"test_recipients";s:0:"";s:21:"test_group_recipients";s:0:"";}', 0, 'XMP data', 1);
-- -- Table structure for table `lh_chat_online_user` --
CREATE TABLE `lh_chat_online_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `vid` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `current_page` text COLLATE utf8mb4_unicode_ci NOT NULL, `page_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `referrer` text COLLATE utf8mb4_unicode_ci NOT NULL, `chat_id` bigint(20) NOT NULL, `invitation_seen_count` int(11) NOT NULL, `invitation_id` int(11) NOT NULL, `last_visit` int(11) NOT NULL, `first_visit` int(11) NOT NULL, `total_visits` int(11) NOT NULL, `pages_count` int(11) NOT NULL, `tt_pages_count` int(11) NOT NULL, `invitation_count` int(11) NOT NULL, `last_check_time` int(11) NOT NULL, `dep_id` int(11) NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci NOT NULL, `notes` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `user_country_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `user_country_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `visitor_tz` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `operator_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `operator_user_proactive` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `operator_user_id` int(11) NOT NULL, `conversion_id` int(11) NOT NULL, `message_seen` int(11) NOT NULL, `message_seen_ts` int(11) NOT NULL, `user_active` int(11) NOT NULL, `lat` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `lon` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `reopen_chat` int(11) NOT NULL, `time_on_site` int(11) NOT NULL, `tt_time_on_site` int(11) NOT NULL, `requires_email` int(11) NOT NULL, `requires_username` int(11) NOT NULL, `requires_phone` int(11) NOT NULL, `screenshot_id` int(11) NOT NULL, `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `operation` text COLLATE utf8mb4_unicode_ci NOT NULL, `online_attr_system` text COLLATE utf8mb4_unicode_ci NOT NULL, `operation_chat` text COLLATE utf8mb4_unicode_ci NOT NULL, `online_attr` text COLLATE utf8mb4_unicode_ci NOT NULL, `device_type` tinyint(1) NOT NULL DEFAULT '0', `chat_time` bigint(20) unsigned NOT NULL DEFAULT '0', `last_visit_prev` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `vid` (`vid`), KEY `dep_id` (`dep_id`), KEY `first_visit` (`first_visit`), KEY `last_visit_dep_id` (`last_visit`,`dep_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE `lh_webhook` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `event` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `bot_id_alt` int(11) NOT NULL DEFAULT '0', `trigger_id_alt` int(11) NOT NULL DEFAULT '0', `bot_id` int(11) NOT NULL, `trigger_id` int(11) NOT NULL, `disabled` tinyint(1) NOT NULL, `status` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `configuration` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `event_disabled` (`event`,`disabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;