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_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_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_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 INTO 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\n[DIRECTPAYMENTLINK]\r\n\r\nOptional Payment 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 manner.\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 manner.<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 INTO 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 INTO 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 manner.\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 manner.<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 INTO 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]\r\n\r\n[DIRECTPAYMENTLINK]\r\n\r\nOptional Payment 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\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely manner.\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 manner.<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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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 INTO 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);
INSERT INTO `autoresponders` (`id`, `type`, `name`, `subject`, `contents`, `contents_html`, `helpid`, `description`) VALUES(32, 8, 'Shared Web Hosting', '', 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', 1, 'This welcome email was automatically created by the 4.1 upgrade script from the Product Group Shared Web Hosting');
INSERT INTO `autoresponders` VALUES(NULL, 8, 'Account Creation', 'Account Created', '[CLIENTNAME],\n\nThanks for choosing [COMPANYNAME], you have successfully created an account with us. Please keep this email as a reference of your login information.\n\nUsername: [CLIENTEMAIL]\n\nTo login to your account, please visit:\n[CLIENTAPPLICATIONURL]\n\nMany Thanks,\n[COMPANYNAME]\n', '<div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">[CLIENTNAME],</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">Thanks for choosing [COMPANYNAME], you have successfully created an account with us. Please keep this email as a reference of your login information.</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">Username: [CLIENTEMAIL]</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">To login to your account, please visit:</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">[CLIENTAPPLICATIONURL]</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;"><br></span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">Many Thanks,</span></font></div><div><font face="''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif"><span style="font-size: 12px;">[COMPANYNAME]</span></font></div><div style="color: rgb(0, 0, 0); font-family: ''Lucida Grande'', ''Lucida Sans Unicode'', Verdana, Arial, sans-serif; font-size: 12px; "><br></div>', 1, 'This email is sent to customers when they create an account in the system, generally during signup.');
INSERT INTO `autoresponders` VALUES(NULL, 8, 'Domain Registration', 'Your Domain Registration', 'Hello [CLIENTNAME],\n\nThis email is to confirm that your domain [DOMAINNAME] has been successfully registered with us, please allow up to 24 hours for your domain to become visible on the internet.\n\nIf you have also purchased any additional services with us you will receive a separate welcome email.\n\nThanks for choosing [COMPANYNAME] for your Domain Registration.', 'Hello [CLIENTNAME],<br><br>This email is to confirm that your domain [DOMAINNAME] has been successfully registered with us, please allow up to 24 hours for your domain to become visible on the internet. <br><br>If you have also purchased any additional services with us you will receive a separate welcome email.<br><br>Thanks for choosing [COMPANYNAME] for your Domain Registration.<br><br>', 1, '');
INSERT INTO autoresponders (`type`,`name`,subject,contents,contents_html,description,helpid) VALUES( 5, 'New Order Notification','New Order Notification',"Dear Support Member,\r\n\r\nA new order has been processed.\r\n\r\n[ORDERINFO]","<HTML><head></head><body>Dear Support Member,<br/><br/>A new order has been processed.<br/><br/>[ORDERINFO]</body></html>",'E-Mail received by those staff members identified of being notified of new orders.',67);