Directory:~$ /home/lmsyaran/public_html/j3/administrator/components/com_helpdeskpro/sql/

Upload File

[Home] [System Details] [Kill Me]

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);