Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_helpdeskpro/sql/config.helpdeskpro.sql
Назад
INSERT INTO `#__helpdeskpro_configs` (`id`, `config_key`, `config_value`) VALUES (1, 'allow_public_user_submit_ticket', '0'), (2, 'enable_captcha', '0'), (3, 'date_format', 'l, d M Y g:i a'), (4, 'default_ticket_priority_id', '3'), (5, 'new_ticket_status_id', '1'), (6, 'ticket_status_when_customer_add_comment', '2'), (7, 'ticket_status_when_admin_add_comment', '3'), (8, 'closed_ticket_status', '4'), (9, 'enable_attachment', '1'), (10, 'allowed_file_types', 'bmp|csv|doc|docx|gif|ico|jpg|jpeg|odg|odp|ods|odt|pdf|png|ppt|txt|xcf|xls|xlsx|zip|gzip'), (11, 'max_number_attachments', '3'), (12, 'send_ticket_attachments_to_email', '1'), (13, 'process_bb_code', '1'), (14, 'highlight_code', '1'), (15, 'programming_languages', 'Php,JScript,Css,Xml'), (16, 'staff_group_id', '5'), (17, 'from_name', ''), (18, 'from_email', ''), (19, 'notification_emails', ''), (20, 'new_ticket_admin_email_subject', '[[CATEGORY_TITLE] - #[TICKET_ID]](New) [TICKET_SUBJECT]'), (21, 'new_ticket_admin_email_body', '<p>User <strong>[NAME]</strong> has just submitted support ticket #[TICKET_ID]</p>\r\n<p><strong>[TICKET_SUBJECT]</strong></p>\r\n<p>[TICKET_MESSAGE]</p>\r\n<p><a href="[FRONTEND_LINK]">You can click here to view the ticket from front-end</a></p>\r\n<p><a href="[BACKEND_LINK]">You can click here to view the ticket from back-end of your site</a></p>'), (22, 'new_ticket_user_email_subject', '[[CATEGORY_TITLE]]Ticket #[TICKET_ID] received'), (23, 'new_ticket_user_email_body', '<p>Dear <strong>[NAME]</strong></p>\r\n<p>We received your support request for ticket #[TICKET_ID]. Our support staff will check and reply you within 24 hours. Below are detail of your support ticket:</p>\r\n<p><strong>[TICKET_SUBJECT]</strong></p>\r\n<p>[TICKET_MESSAGE]</p>\r\n<p><a href="[FRONTEND_LINK]">You can click here to view the ticket</a></p>\r\n<p><a href="[FRONTEND_LINK_WITHOUT_LOGIN]">You can also click here to view the ticket without having to login</a></p>'), (24, 'ticket_updated_admin_email_subject', '[[CATEGORY_TITLE] - #[TICKET_ID]](Updated) [TICKET_SUBJECT]'), (25, 'ticket_updated_admin_email_body', '<p>User [NAME] has just added a comment to ticket #[TICKET_ID] :</p>\r\n<p>[TICKET_COMMENT]</p>\r\n<p><a href="[FRONTEND_LINK]">You can click here to view the ticket from front-end</a></p>\r\n<p><a href="[BACKEND_LINK]">You can click here to view the ticket from back-end of your site</a></p>'), (26, 'ticket_updated_user_email_subject', '[[CATEGORY_TITLE] - #[TICKET_ID]](Updated) [TICKET_SUBJECT]'), (27, 'ticket_updated_user_email_body', '<p>Dear <strong>[NAME]</strong></p>\r\n<p>User <strong>[MANAGER_NAME]</strong> has just added a comment to ticket #<strong>[TICKET_ID]</strong>:</p>\r\n<p>[TICKET_COMMENT]</p>\r\n<p><a href="[FRONTEND_LINK]">You can click here to view the ticket</a></p>\r\n<p><a href="[FRONTEND_LINK_WITHOUT_LOGIN]">You can also click here to view the ticket without having to login</a></p>'), (28, 'ticket_assiged_email_subject', 'New Ticket assignment'), (29, 'ticket_assiged_email_body', '<p>Dear [STAFF_NAME]</p>\r\n<p>[MANAGER_NAME] has just assigned a new ticket #[TICKET_ID] to you. Please login to your account, check and work on the ticket.</p>'), (30, 'notify_manager_when_staff_reply', '1'), (31, 'notify_staff_when_customer_reply', '1'); INSERT INTO `#__helpdeskpro_priorities` (`id`, `title`, `ordering`, `published`) VALUES (1, '1 - VERY LOW', 1, 1), (2, '2 - LOW', 2, 1), (3, '3 - NORMAL', 3, 1), (4, '4 - ELEVATED', 4, 1), (5, '4 - ELEVATED', 5, 1), (6, '5 - HIGH', 6, 1); INSERT INTO `#__helpdeskpro_statuses` (`id`, `title`, `ordering`, `published`) VALUES (1, 'NEW', 1, 1), (2, 'PENDING RESOLUTION', 2, 1), (3, 'REQUIRE FEEDBACK', 3, 1), (4, 'CLOSED', 4, 1);
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка