INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (-1, /*T*/'All ticket types'/*~T*/, '', 0, 1, 1, 0, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (1, /*T*/'Software'/*~T*/, '', 0, 1, 1, 0, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (2, /*T*/'Billing Issues'/*~T*/, '', 1, 1, 1, 1, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (3, /*T*/'Control Panel'/*~T*/, '', 2, 1, 1, 0, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (4, /*T*/'E-mail Problems'/*~T*/, '', 3, 1, 1, 0, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (5, /*T*/'Upgrades'/*~T*/, '', 4, 1, 1, 0, 0, 0);
INSERT INTO `troubleticket_type` (`id`, `name`, `description`, `myorder`, `enabled`, `enabled_public`, `is_billing_type`, `target_dept`, `target_staff`) VALUES (6, /*T*/'Other'/*~T*/, '', 5, 1, 1, 0, 0, 0);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (-1, 1, 'support_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (-1, 1, 'support_submit_ticket', 0);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'support_reopen_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'support_submit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'support_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'support_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'support_view_closed_tickets', 0);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_close_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_delete_trouble_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_edit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_reopen_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_submit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_view_all_closed_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_view_assigned_department_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'support_view_closed_tickets', 0);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_view_assigned_department_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_view_all_closed_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_reopen_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_edit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_delete_trouble_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_close_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'support_view_closed_tickets', 0);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_assigned_department_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_assigned_otherdepartment_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_reply_any_open_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_all_closed_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_submit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_reopen_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_edit_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_delete_trouble_ticket', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_assign_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_close_tickets', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_rates', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'support_view_closed_tickets', 0);

INSERT INTO `departments` (`id`, `name`, `is_generaldep`, `lead_id`) VALUES (1, 'General', 1, 100);
INSERT INTO `departments` (`id`, `name`, `is_generaldep`, `lead_id`) VALUES (2, 'Billing', 0, 100);

INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`, `assign_to`, `notify_to`, `sendclosed`, `sendfeedback`, `sendresolution`) VALUES (1, 100, 0, 0, 1, 1, 1, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`) VALUES (1, 2, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`) VALUES (1, 3, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`) VALUES (1, 4, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`) VALUES (1, 5, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`, `assign_to`, `notify_to`, `sendclosed`, `sendfeedback`, `sendresolution`) VALUES (2, 100, 0, 0, 1, 1, 1, 1);
INSERT INTO `departments_members` (`department_id`, `member_id`, `is_group`) VALUES (2, 4, 1);

INSERT INTO `routingrules` (`id`, `name`, `order`, `emails`, `user_type`, `autoresponder_template`, `openticket`, `target_type`, `target_priority`, `target_dept`, `target_staff`, `copy_destinataries`, `routing_type`, `filter_out`, `pop3_hostname`, `pop3_port`, `pop3_username`, `pop3_password`, `pop3_delete_emails`) VALUES(1, 'Default autoresponder for E-mails from registered users', 0, '*', 1, 1, 1, 6, 2, -1, -1, '', 1, 'Subject: ***SPAM***\r\nX-Spam-Status: Yes', '', '110', '', '', 0);
INSERT INTO `routingrules` (`id`, `name`, `order`, `emails`, `user_type`, `autoresponder_template`, `openticket`, `target_type`, `target_priority`, `target_dept`, `target_staff`, `copy_destinataries`, `routing_type`, `filter_out`, `pop3_hostname`, `pop3_port`, `pop3_username`, `pop3_password`, `pop3_delete_emails`) VALUES (2, 'Default autoresponder for E-mails from unregistered users', 1, '*', 2, 2, 0, 0, 0, 0, 0, '', 1, 'Subject: ***SPAM***\r\nX-Spam-Status: Yes', '', 110, '', '', 0);

INSERT INTO `autoresponders` (`id`, `type`, `name`, `subject`, `contents`, `contents_html`,`helpid`) VALUES (1, 1, 'Default', 'A new Support ticket has been added', '[CLIENTNAME],\r\n\r\nThank you for submitting a ticket with [COMPANYNAME].  Your request has been assigned the ticket number [TICKETNUMBER].  A technician will respond to your request shortly.\r\n\r\nMember Center:\r\n[CLIENTAPPLICATIONURL]\r\n\r\nThank you,\r\n[COMPANYNAME]', '[CLIENTNAME],<br />\r\n<br />\r\nThank you for submitting a ticket with [COMPANYNAME].  Your request has been assigned the ticket number [TICKETNUMBER].  A technician will respond to your request shortly.<br />\r\n<br />\r\nMember Center:<br />\r\n[CLIENTAPPLICATIONURL]<br />\r\n<br />\r\nThank you,<br />\r\n[COMPANYNAME]',0);
INSERT INTO `autoresponders` (`id`, `type`, `name`, `subject`, `contents`, `contents_html`,`helpid`) VALUES (2, 1, 'Bounce back', 'Support request failure', 'Your support E-mail cannot be processed at this time because our support center did not recognize your E-mail as one belonging to one of our customers.\r\nIf you need assistance please E-mail using your E-mail of record or submit a support ticket.\r\n\r\nSupport Team', 'Your support E-mail cannot be processed at this time because our support center did not recognize your E-mail as one belonging to one of our customers.<br />\r\nIf you need assistance please E-mail using your E-mail of record or submit a support ticket.<br />\r\n<br />\r\nSupport Team',0);
# data for all emails
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Invoice Template','Billing Department',"Due Date: [DATE]\r\nInvoice #[INVOICENUMBER]\r\n\r\nATTN: [CLIENTNAME],\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]","<HTML><head></head><body>Due Date: [DATE]<br />\r\nInvoice #[INVOICENUMBER]<br />\r\n<br />\r\nATTN: [CLIENTNAME],<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely matter.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>",'Template for invoices sent through E-mail.',50);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Payment Receipt Template','Billing Department',"Dear [CLIENTNAME],\r\n\r\nPayment receipt for Invoice #[INVOICENUMBER], sent on [SENTDATE].\r\n\r\nCompany: [COMPANYNAME].  \r\nTotal Charge: [AMOUNT] \r\n\r\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]\r\n\r\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\r\n\r\nNote: This email will serve as an official receipt for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]","<HTML><head></head><body>Dear [CLIENTNAME],<br />\r\n<br />\r\nPayment receipt for Invoice #[INVOICENUMBER], sent on [DATE].<br />\r\n<br />\r\nCompany: [COMPANYNAME].  <br />\r\nTotal Charge: [AMOUNT] <br />\r\n<br />\r\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]<br />\r\n<br />\r\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].<br />\r\n<br />\r\nNote: This email will serve as an official receipt for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>",'Template for the E-mail sent to clients after invoice is paid.',50);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Payment Rejected Template','Billing Department',"Dear [CLIENTNAME],\r\n\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]","<HTML><head></head><body>Dear [CLIENTNAME],<br />\r\n<br />\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely matter.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>",'Template for the E-mail sent to clients after invoice payment is rejected.',50);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Overdue Invoice Template','Billing Department',"Due Date: [DATE]\nInvoice #[INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\n\nTotal Due: [AMOUNT]\nPaid: [PAID]\nBalance Due: [BALANCEDUE]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the \"Billing\" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This E-mail will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]","<HTML><head></head><body>Due Date: [DATE]<br />\nInvoice #[INVOICENUMBER]<br />\n<br />\nATTN: [CLIENTNAME],<br />\n<br />\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].<br />\n<br />\nInvoice Description:<br />\n[INVOICEDESCRIPTION]<br />\n<br />\nTotal Due: [AMOUNT]<br />\nPaid: [PAID]<br />\nBalance Due: [BALANCEDUE]<br />\n<br />\nPayment Instructions:<br />\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\n2) Click on the \"Billing\" tab<br />\n3) Select the invoice you want to pay<br />\n4) Click on pay invoice<br />\n<br />\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.<br />\n<br />\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.<br />\n<br />\nNote: This E-mail will serve as an official invoice for this payment.<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>",'E-mail template used when notifying customer of outstanding invoices using the Invoice Reminder service.',50);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Batch Invoice Notification Template','Billing Department',"ATTN: [CLIENTNAME],\n\nYou have an upcoming invoice for [BALANCEDUE] on [DATE] that will be charged to your credit card on file with [COMPANYNAME].  If you do not approve of this charge and would like to cancel your subscription please contact us immediately.\n\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]\n\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\n\n\n[COMPANYNAME]\n[BILLINGEMAIL]","<HTML><head></head><body>ATTN: [CLIENTNAME],<br />\n<br />\nYou have an upcoming invoice for [BALANCEDUE] on [DATE] that will be charged to your credit card on file with [COMPANYNAME].  If you do not approve of this charge and would like to cancel your subscription please contact us immediately.<br />\n<br />\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]<br />\n<br />\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].<br />\n<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>",'Template for the E-mail sent to clients by the upcoming batch invoice notifier service.',50);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 3, 'Expiring CC Template','Billing Department - Expiring Credit Card Notice',"ATTN: [CLIENTNAME],\n\nYour credit card ending with [CCLASTFOUR] will soon be expiring on [CCEXPDATE].  Please login to update your credit card information as soon as possible at: [CLIENTAPPLICATIONURL]\n\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\n\n\n[COMPANYNAME]\n[BILLINGEMAIL]","<HTML><head></head><body>ATTN: [CLIENTNAME],<br />\n<br />\nYour credit card ending with [CCLASTFOUR] will soon be expiring on [CCEXPDATE].  Please login to update your credit card information as soon as possible at: [CLIENTAPPLICATIONURL]<br />\n<br />\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].<br />\n<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>",'Template for the E-mail sent to clients by the expiring credit card notifier service.',51);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 4, 'Domain Reminder Template','Expiring Domain Notice for [DOMAIN]: [EXPDATE]',"ATTN: [CLIENTNAME],\n\nThis is a notification that your domain, [DOMAINNAME], is nearing its expiration date of [EXPDATE].  Please ensure that your contact and billing information is up to date and that all payments are on time to ensure that your domain is renewed.\n\nYou may update your information by logging into: [CLIENTAPPLICATIONURL]\n\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\n\n\n[COMPANYNAME]\n[BILLINGEMAIL]","<HTML><head></head><body>ATTN: [CLIENTNAME],<br />\n<br />\nThis is a notification that your domain, [DOMAINNAME], is nearing its expiration date of [EXPDATE].  Please ensure that your contact and billing information is up to date and that all payments are on time to ensure that your domain is renewed.<br />\n<br />\nYou may update your information by logging into: [CLIENTAPPLICATIONURL]<br />\n<br />\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].<br />\n<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>",'E-mail sent to a customer regarding an expiring domain.',52);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 5, 'Forgot Password Template','Confirm Password',"[CLIENTNAME],\r\n\r\nA web user from [REQUESTIP] has just requested to change the password on this account.\r\n\r\nBy clicking on the confirmation link below you will be sent a new password and are recommended to change it after logging in.\r\n\r\nConfirmation URL: [CONFIRMATION URL]\r\n\r\nThank you,\r\n[COMPANYNAME]","<HTML><head></head><body>[CLIENTNAME],<br />\r\n<br />\r\nA web user from [REQUESTIP] has just requested to change the password on this account.<br />\r\n<br />\r\nBy clicking on the confirmation link below you will be sent a new password and are recommended to change it after logging in.<br />\r\n<br />\r\nConfirmation URL: [CONFIRMATION URL]<br />\r\n<br />\r\nThank you,<br />\r\n[COMPANYNAME]</body></HTML>",'Initial E-mail customer receives to confirm a password change to their account.',53);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 5, 'Get New Password Template','Password Reset',"[CLIENTNAME],\r\n\r\nYour password has been reset successfully.\r\n\r\nNew password: [NEWPASSWORD]\r\n\r\nPlease goto [CLIENTEXEC URL] to login.\r\n\r\nThank you,\r\n[COMPANYNAME]\r\n[COMPANYEMAIL]","<HTML><head></head><body>[CLIENTNAME],<br />\r\n<br />\r\nYour password has been reset successfully.<br />\r\n<br />\r\nNew password: [NEWPASSWORD]<br />\r\n<br />\r\nPlease goto [CLIENTEXEC URL] to login.<br />\r\n<br />\r\nThank you,<br />\r\n[COMPANYNAME]<br />\r\n[COMPANYEMAIL]</body></HTML>",'Initial E-mail the customer receives to know the new password to their account.',54);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 5, 'Account Rejected Template','Account Rejected',"[CLIENTNAME],\r\n\r\nThank you for your order.\r\n\r\nUnfortunately it has been rejected.\r\n\r\nPlease contact our sales team at [SUPPORTEMAIL] for additional information.\r\n\r\nThank you for choosing [COMPANYNAME]!","<HTML><head></head><body>[CLIENTNAME],<br />\r\n<br />\r\nThank you for your order.<br />\r\n<br />\r\nUnfortunately it has been rejected.<br />\r\n<br />\r\nPlease contact our sales team at [SUPPORTEMAIL] for additional information.<br />\r\n<br />\r\nThank you for choosing [COMPANYNAME]!</body></HTML>",'E-mail send to a customer when you reject their account, from the client list screen when viewing pending accounts.',55);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 6,'Team Status Reply Template','Team Status Reply',"[TEAMSTATUS]\r\n\r\nIn reply to [REPLIEDTEAMSTATUSUSERNAME] ([REPLIEDTEAMSTATUSDATE]):\r\n\r\n> [REPLIEDTEAMSTATUS]","<HTML><head></head><body>[TEAMSTATUS]<br />\r\n<br />\r\nIn reply to [REPLIEDTEAMSTATUSUSERNAME] ([REPLIEDTEAMSTATUSDATE]):<br />\r\n<br />\r\n> [REPLIEDTEAMSTATUS]</body></HTML>",'E-mail send to a user when someone replies to one of his Team Status.',56);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 6,'Team Status Activity Template','Your Team Status activity',"Here are the latest updates:\r\n\r\n\r\n[TEAMSTATUSDYNAMICBLOCK]","<HTML><head></head><body>Here are the latest updates:<br />\r\n<br />\r\n<br />\r\n[TEAMSTATUSDYNAMICBLOCK]</body></HTML>",'E-mail send to the Team Status users, to notify them the activity on Team Status.',57);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 6,'Team Status Activity Dynamic Block Template','na',"[TEAMSTATUSUSERNAME][TEAMSTATUSREPLYINFO]: [TEAMSTATUS]\r\n[TEAMSTATUSDATE]\r\n\r\n","[TEAMSTATUSUSERNAME][TEAMSTATUSREPLYINFO]: [TEAMSTATUS]<br />\r\n[TEAMSTATUSDATE]<br />\r\n<br />\r\n",'Dynamic block used to show the Team Status.',58);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 6,'Team Status Activity Reply Template','na'," in reply to [REPLIEDTEAMSTATUSUSERNAME]"," in reply to [REPLIEDTEAMSTATUSUSERNAME]",'Text to add when a Team Status is a  reply of another Team Status.',59);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Support Ticket Template','Support ticket has been updated',"ATTN: [CLIENTNAME],\n\nSupport Ticket #[TICKETNUMBER] has been updated\n\nDescription:\n[DESCRIPTION]\n\nIf you want to view the entire log of this ticket log onto our client management site at [CLIENTAPPLICATIONURL] with your username and password.\n\nIf you have any questions regarding this response or any other support questions please feel free to contact us.\n\nThank you,\n[COMPANYNAME]","<HTML><head></head><body>ATTN: [CLIENTNAME],<br />\n<br />\nSupport Ticket #[TICKETNUMBER] has been updated<br />\n<br />\nDescription:<br />\n[DESCRIPTION]<br />\n<br />\nIf you want to view the entire log of this ticket log onto our client management site at [CLIENTAPPLICATIONURL] with your username and password.<br />\n<br />\nIf you have any questions regarding this response or any other support questions please feel free to contact us.<br />\n<br />\nThank you,<br />\n[COMPANYNAME]</body></HTML>",'Template for E-mails that get sent out to clients after their tickets have been commented on or closed.',60);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Support Ticket Assigned Template','Ticket has been assigned to you',"ATTN: [COMPANYNAME] Support Staff,\r\n\r\nSupport Ticket #[TICKETNUMBER], submitted by [CLIENTNAME] has just been assigned to you.  Please take a look at your earliest convenience.\r\n\r\nDescription:\r\n[DESCRIPTION]\r\n\r\nMember Center:\r\n[CLIENTAPPLICATIONURL]\r\n\r\nThank you,\r\n[COMPANYNAME]","<HTML><head></head><body>ATTN: [COMPANYNAME] Support Staff,<br />\r\n<br />\r\nSupport Ticket #[TICKETNUMBER], submitted by [CLIENTNAME] has just been assigned to you.  Please take a look at your earliest convenience.<br />\r\n<br />\r\nDescription:<br />\r\n[DESCRIPTION]<br />\r\n<br />\r\nMember Center:<br />\r\n[CLIENTAPPLICATIONURL]<br />\r\n<br />\r\nThank you,<br />\r\n[COMPANYNAME]</body></HTML>",'Template for the E-mail sent to support staff after a ticket is assigned.',60);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Feedback Request for Closed Tickets Template','Feedback Request',"Dear [CLIENTNAME],\r\n\r\nAt [COMPANYNAME] we're always striving to deliver the best customer support in the industry. You have recently closed a support ticket, and we would like to know about your experience.\r\n\r\nPlease help us improve by qualifying the service you received, by pointing your web browser to the appropiate address:\r\n\r\nIf you think the service was excellent, go to [RATEEXCELLENTSERVICEURL].\r\nIf you think the service was good enough, go to [RATEGOODSERVICEURL].\r\nIf you think the service was not great, go to [RATENOTGREATSERVICEURL].\r\nIf you think the service was poor, go to [RATEPOORSERVICEURL].\r\n\r\nThank you for your time,\r\n[COMPANYNAME]","<HTML><head></head><body>Dear [CLIENTNAME],<br />\r\n<br />\r\nAt [COMPANYNAME] we're always striving to deliver the best customer support in the industry. You have recently closed a support ticket, and we would like to know about your experience.<br />\r\n<br />\r\nPlease help us improve by rating the service you received:<br />\r\n<br />\r\nIf you think the service was excellent, click <a href=\"[RATEEXCELLENTSERVICEURL]\">here</a>.<br />\r\nIf you think the service was good enough, click <a href=\"[RATEGOODSERVICEURL]\">here</a><br />\r\nIf you think the service was not great, click <a href=\"[RATENOTGREATSERVICEURL]\">here</a>.<br />\r\nIf you think the service was poor, click <a href=\"[RATEPOORSERVICEURL]\">here</a>.<br />\r\n<br />\r\nThank you for your time,<br />\r\n[COMPANYNAME]</body></HTML>",'Template for the E-mail sent to ask for customer feedback after a ticket is closed. You need to enable the appropriate setting under the support section of settings to have this E-mail be automatically sent.',61);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'AutoClose Ticket Service Template','AutoClose Service',"Dear [CLIENTNAME],\r\n\r\nAt [COMPANYNAME] we're always striving to deliver the best customer support in the industry.\r\n\r\nThis message concerns your Ticket #[TICKETNUMBER]. We have not received any response back from you in 120 hours, and would like to know if you consider this issue to be resolved.\r\n\r\nPlease note that the Ticket will automatically be closed within 24 hours if no response is received from you. The Ticket will not be closed in the case that you send another reply.\r\n\r\n\r\n\r\nThank you for your time,\r\n[COMPANYNAME]","<HTML><head></head><body>Dear [CLIENTNAME],<br><br>At [COMPANYNAME] we&#039;re always striving to deliver the best customer support in the industry.<br><br>This message concerns your Ticket #[TICKETNUMBER]. We have not received any response back from you in 120 hours, and would like to know if you consider this issue to be resolved.<br><br>Please note that the Ticket will automatically be closed within 24 hours if no response is received from you. The Ticket will not be closed in the case that you send another reply.<br><br>Thank you for your time,<br>[COMPANYNAME]</body></HTML>",'Template for the E-mail sent asking for response before auto-close a Ticket. You need to enable the appropriate setting under the support section of settings to have this E-mail be automatically sent.',62);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Support For New High Priority Tickets Template',"A new support ticket has been added","Dear Support Member,\r\n\r\nSupport ticket #[TICKETNUMBER] has been entered by [CLIENTNAME]\r\nSubject: [TICKETSUBJECT]\r\nTicket Type: [TICKETTYPE]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear Support Member,<br><br>Support ticket #[TICKETNUMBER] has been entered by [CLIENTNAME]<br>Subject: [TICKETSUBJECT]<br>Ticket Type: [TICKETTYPE]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify support for new high priority tickets. You may use tags.',63);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Department Lead For New Ticket Template',"A new support ticket has been added to the department [DEPARTMENT]","Dear Department Lead,\r\n\r\nSupport ticket #[TICKETNUMBER] has been assigned to the department [DEPARTMENT].\r\n\r\nSubject: [TICKETSUBJECT]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear Department Lead,<br><br>Support ticket #[TICKETNUMBER] has been assigned to the department [DEPARTMENT].<br><br>Subject: [TICKETSUBJECT]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify department lead for new ticket. You may use tags.',63);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Department List For New Ticket Template',"A new support ticket has been assigned to the department [DEPARTMENT]","Dear Support Member,\r\n\r\nSupport ticket #[TICKETNUMBER] has been assigned to the department [DEPARTMENT]\r\nSubject: [TICKETSUBJECT]\r\nTicket Type: [TICKETTYPE]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear Support Member,<br><br>Support ticket #[TICKETNUMBER] has been assigned to the department [DEPARTMENT]<br>Subject: [TICKETSUBJECT]<br>Ticket Type: [TICKETTYPE]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify department list for new ticket. You may use tags.',63);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Customer For New Ticket Template',"A new support ticket has been added","Dear [CLIENTNAME],\r\n\r\nSupport ticket #[TICKETNUMBER] has been created by our staff in response to your request.\r\nSubject: [TICKETSUBJECT]\r\nTicket Type: [TICKETTYPE]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear [CLIENTNAME],<br><br>Support ticket #[TICKETNUMBER] has been created by our staff in response to your request.<br>Subject: [TICKETSUBJECT]<br>Ticket Type: [TICKETTYPE]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify customer for new ticket. You may use tags.',64);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Anonymous For New Ticket Template',"A new support ticket has been added","Dear [CLIENTNAME],\r\n\r\nSupport ticket #[TICKETNUMBER] has been created by our staff in response to your request.\r\nSubject: [TICKETSUBJECT]\r\nTicket Type: [TICKETTYPE]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear [CLIENTNAME],<br><br>Support ticket #[TICKETNUMBER] has been created by our staff in response to your request.<br>Subject: [TICKETSUBJECT]<br>Ticket Type: [TICKETTYPE]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify anonymous for new ticket. You may use tags.',64);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify Assignee For Ticket Reply Template',"Support ticket has been updated","Dear Support Member,\r\n\r\nThere has been an update to ticket #[TICKETNUMBER] by [CLIENTNAME]\r\n\r\nMessage:\r\n[DESCRIPTION]","<HTML><head></head><body>Dear Support Member,<br><br>There has been an update to ticket #[TICKETNUMBER] by [CLIENTNAME]<br><br>Message:<br>[DESCRIPTION]</body></HTML>",'Template for the E-mail sent to notify assignee for ticket reply. You may use tags.',65);
INSERT autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 7,'Notify For New FeedBack Template',"A new feedback comment has been added","Dear Support Member,\r\n\r\nA new Feedback Request for Ticket: #[TICKETNUMBER] has been entered by [CLIENTNAME]\r\n\r\n[DESCRIPTION]\r\n","<HTML><head></head><body>Dear Support Member,<br><br>A new Feedback Request for Ticket: #[TICKETNUMBER] has been entered by [CLIENTNAME]<br><br>[DESCRIPTION]<br></body></HTML>",'Template for the E-mail sent to notify for new feedback. You may use tags.',66);