API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 21st, 2017
239
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 129.88 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.14  Distrib 5.5.50-MariaDB, for Linux (x86_64)
  2. --
  3. -- Host: localhost    Database: hb_6AMAIMoD
  4. -- ------------------------------------------------------
  5. -- Server version   5.5.50-MariaDB
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `hb_email_templates`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `hb_email_templates`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `hb_email_templates` (
  26.   `id` int(11) NOT NULL AUTO_INCREMENT,
  27.   `tplname` varchar(128) NOT NULL,
  28.   `group` enum('Domain','Product','Invoice','General','Support','Custom','Mobile') DEFAULT NULL,
  29.   `for` enum('Client','Admin') NOT NULL DEFAULT 'Client',
  30.   `language_id` int(11) NOT NULL DEFAULT '1',
  31.   `subject` text NOT NULL,
  32.   `message` text NOT NULL,
  33.   `altmessage` text NOT NULL,
  34.   `send` tinyint(1) DEFAULT '1',
  35.   `plain` tinyint(1) DEFAULT '0',
  36.   `system` tinyint(1) DEFAULT '1',
  37.   `hidden` tinyint(1) DEFAULT '0',
  38.   PRIMARY KEY (`id`,`language_id`),
  39.   KEY `tplname` (`tplname`(32)),
  40.   KEY `group` (`group`),
  41.   KEY `for` (`for`)
  42. ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;
  43. /*!40101 SET character_set_client = @saved_cs_client */;
  44.  
  45. --
  46. -- Dumping data for table `hb_email_templates`
  47. --
  48.  
  49. LOCK TABLES `hb_email_templates` WRITE;
  50. /*!40000 ALTER TABLE `hb_email_templates` DISABLE KEYS */;
  51. INSERT INTO `hb_email_templates` VALUES (1,'Details:Signup','General','Client',1,'Client:Welcome to Portal','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Welcome to {$business_name}!.</p>\r\n\r\n<h2>Your access details:</h2>\r\n<p>\r\n    <b>Email Address:</b> {$client.email}<br/>\r\n    <b>Password:</b> {$client.password}\r\n</p>\r\n\r\n\r\n<table class=\"body-action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td align=\"center\">\r\n                          <div>\r\n                            <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"{$system_url}?cmd=clientarea\" style=\"height:45px;v-text-anchor:middle;width:200px;\" arcsize=\"7%\" stroke=\"f\" fill=\"t\">\r\n                            <v:fill type=\"tile\" color=\"#22BC66\" />\r\n                            <w:anchorlock/>\r\n                            <center style=\"color:#ffffff;font-family:sans-serif;font-size:15px;\">Access Client Area</center>\r\n                          </v:roundrect><![endif]-->\r\n                            <a href=\"{$system_url}?cmd=clientarea\" class=\"button button--green\">Access Client Area</a>\r\n                          </div>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n                    \r\n                    <table class=\"body-sub\">\r\n                      <tbody><tr>\r\n                        <td>\r\n                          <p class=\"sub\">If you’re having trouble clicking the Access client area button, copy and paste the URL below into your web browser.\r\n                          </p>\r\n                          <p class=\"sub\"><a href=\"{$system_url}?cmd=clientarea\">{$system_url}?cmd=clientarea</a></p>\r\n                        </td>\r\n                      </tr>\r\n                    </tbody></table>\r\n       \r\n ','DEAR {$client.firstname} {$client.lastname},\r\n\r\nLOGIN DETAILS:\r\nEmail Address: {$client.email}\r\nPassword: {$client.password}\r\n{$system_url}?cmd=clientarea\r\n ',1,2,1,0),(2,'Invoice:New','Invoice','Client',1,'Invoice #{$invoice.id}: Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>New invoice has just been created in your account</p>\r\n\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td><h2>Invoice  #{$invoice.id}</h2></td>\r\n                        <td><h2 class=\"align-right\">{$invoice.date|dateformat:$date_format}</h2></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td><h3>Status:  {$invoice.status}</h3></td>\r\n                        <td><h3 class=\"align-right\">Due: {$invoice.duedate|dateformat:$date_format}</h3></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                            {foreach from=$invoiceitems item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description} {if $item.qty}{$item.qty} x {/if}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$invoice.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n       \r\n       <p>\r\n           <b>Payment method:</b> {$invoice.gateway}<br>\r\n           <b><a href=\"{$invoices_url}\">Browse all invoices</a></b>\r\n       </p>             \r\n','Dear {$client.firstname} {$client.lastname}, \r\n\r\nINVOICE  #{$invoice.id} \r\nSTATUS: {$invoice.status}\r\nAMOUNT DUE: {$invoice.total|price:$currency}\r\nDUE DATE: {$invoice.duedate|dateformat:$date_format}\r\nGENERATE ON: {$invoice.date|dateformat:$date_format}.\r\n\r\nPAYMENT METHOD:\r\n {$invoice.gateway}\r\n\r\nInvoice Items\r\n{foreach from=$invoiceitems item=item}\r\n {$item.description}  {if $item.qty}{$item.qty} x {/if}{$item.amount|price:$currency}\r\n{/foreach}\r\n------------------------------------------------------\r\n\r\nPAY LINK:\r\n {$invoices_url}\r\n\r\n',1,2,1,0),(3,'Invoice:Paid','Invoice','Client',1,'Invoice #{$invoice.id}: Paid','Dear {$client.firstname} {$client.lastname}, \r\n\r\nTHANK YOU FOR PAYMENT!\r\n\r\nINVOICE  #{$invoice.id} \r\nSTATUS: {$invoice.status}\r\nTOTAL PAID: {$invoice.total|price:$currency}\r\nSENT ON: {$invoice.date|dateformat:$date_format}\r\n\r\n\r\n\r\n\r\nINVOICE HISTORY: {$clientarea_url}\r\n','Dear {$client.firstname} {$client.lastname}, \r\n\r\nTHANK YOU FOR PAYMENT!\r\n\r\nINVOICE  #{$invoice.id} \r\nSTATUS: {$invoice.status}\r\nTOTAL PAID: {$invoice.total|price:$currency}\r\nSENT ON: {$invoice.date|dateformat:$date_format}\r\n\r\n\r\n\r\n\r\nINVOICE HISTORY: {$clientarea_url}\r\n',1,2,1,0),(4,'Order:New','General','Client',1,'New Order #{$order.number}','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Thank you for your recent order!</p>\r\n\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td><h2>Order  #{$order.number}</h2></td>\r\n                        <td></td>\r\n                      </tr>\r\n                      \r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                           {foreach from=$order_details item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$order.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n       \r\n<p>\r\n    We will activate your order as soon as possible after accounting payment (if applies) for this order\r\n</p>             \r\n\r\n\r\n ','DEAR {$client.firstname} {$client.lastname},\r\n\r\nThank you for your recent order!\r\n\r\nORDER NUMBER: {$order.number}\r\n\r\n{foreach from=$order_details item=item}\r\n {$item.description} {$item.amount|price:$currency}\r\n{/foreach}\r\n\r\n\r\nWe will activate your order as soon as possible after accounting payment (if applies) for this order\r\n ',1,2,1,0),(5,'Ticket:New','Support','Client',1,'Ticket:New','{$ticket.name},\r\n\r\nThank you for request. We will be in touch shortly.\r\n\r\nSUBJECT: {$ticket.subject}\r\n\r\nSTATUS:\r\n{$ticket.status}\r\n{$ticket_url}\r\n\r\n{if $ticket_attachments}\r\nFollowing files have been attached:\r\n{foreach from=$ticket_attachments item=attachment}\r\n{$attachment.org_filename},\r\n{/foreach}\r\n{/if}\r\n\r\n{if $ticket_attachments_errors}\r\nFollowing Files: {foreach from=$ticket_attachments_errors item=attachment}{$attachment.org_filename},{/foreach} have been rejected.\r\nSupported attachments extensions: {$attachments_ext}\r\n{/if}','{$ticket.name},\r\n\r\nThank you for request. We will be in touch shortly.\r\n\r\nSUBJECT: {$ticket.subject}\r\n\r\nSTATUS:\r\n{$ticket.status}\r\n{$ticket_url}\r\n\r\n{if $ticket_attachments}\r\nFollowing files have been attached:\r\n{foreach from=$ticket_attachments item=attachment}\r\n{$attachment.org_filename},\r\n{/foreach}\r\n{/if}\r\n\r\n{if $ticket_attachments_errors}\r\nFollowing Files: {foreach from=$ticket_attachments_errors item=attachment}{$attachment.org_filename},{/foreach} have been rejected.\r\nSupported attachments extensions: {$attachments_ext}\r\n{/if}',1,2,1,0),(7,'Account:Created:DirectAdmin','Product','Client',1,'New Hosting Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your order has been accepted and your hosting account has been set-up.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n    <b>Username:</b> {$service.username}<br>\r\n    <b>Password:</b> {$service.password}<br><br>\r\n    \r\n    <b>Control Panel URL: http://{$server.ip}:2222/<br>\r\n    Once your domain has propogated, you may also use http://www.{$service.domain}:2222/<br>\r\n</p>\r\n\r\n<h2>Server Information</h2>\r\n<p>\r\n    <b>Server Name:</b> {$server.name}<br>\r\n    <b>Server IP:</b> {$server.ip}<br><br>\r\n    \r\n    If you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n    \r\n    <b>Nameserver 1:</b> {$server.ns1} ({$server.ip1})<br>\r\n    <b>Nameserver 2:</b> {$server.ns2} ({$server.ip2})<br>{if $service_ns3}\r\n    <b>Nameserver 3:</b> {$server.ns3} ({$server.ip3})<br>{/if}{if $service_ns4}\r\n    <b>Nameserver 4:</b> {$server.ns4} ({$server.ip4})<br>{/if}\r\n</p>\r\n\r\n<h2>Uploading Your Website</h2>\r\n<p>\r\n    Once your domain has propagated you may use the details below:\r\n    <br><br>\r\n    <b>FTP Hostname:</b> www.{$service.domain}<br>\r\n    <b>Webpage URL:</b> http://www.{$service.domain}<br>\r\n</p>\r\n\r\n<h2>Email Settings</h2>\r\n<p>\r\n    For email accounts that you setup, you should use the following connection details in your email program:\r\n    <br><br>\r\n    <b>POP3 Host Address:</b> mail.{$service.domain}<br>\r\n    <b>SMTP Host Address:</b> mail.{$service.domain}<br>\r\n    <b>Username:</b> The email address you are checking email for<br>\r\n    <b>Password:</b> As specified in your control panel<br>\r\n</p>','Dear {$client.firstname} {$client.lastname}.\r\n\r\nYour order has been accepted and your hosting account has been activated.\r\n\r\n# New Account Information\r\n\r\nHosting Package: {$service.product_name}\r\nDomain: {$service.domain}\r\nFirst Payment Amount: {$service.firstpayment|price:$currency}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n# Login Details\r\n\r\nUsername: {$service.username}\r\nPassword: {$service.password}\r\n\r\nControl Panel URL: http://{$server.ip}:2222/\r\nOnce your domain has propogated, you may also use http://www.{$service.domain}:2222/\r\n\r\n# Server Information\r\n\r\nServer Name: {$server.name}\r\nServer IP: {$server.ip}\r\n\r\nIf you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n\r\nNameserver 1: {$server.ns1} ({$server.ip1})\r\nNameserver 2: {$server.ns2} ({$server.ip2}){if $service_ns3}\r\nNameserver 3: {$server.ns3} ({$server.ip3}){/if}{if $service_ns4}\r\nNameserver 4: {$server.ns4} ({$server.ip4}){/if}\r\n\r\n# Uploading Your Website\r\n\r\nOnce your domain has propagated you may use the details below:\r\n\r\nFTP Hostname: www.{$service.domain}\r\nWebpage URL: http://www.{$service.domain}\r\n\r\n# Email Settings\r\n\r\nFor email accounts that you setup, you should use the following connection details in your email program:\r\n\r\nPOP3 Host Address: mail.{$service.domain}\r\nSMTP Host Address: mail.{$service.domain}\r\nUsername: The email address you are checking email for\r\nPassword: As specified in your control panel\r\n',1,2,1,0),(8,'Account:Suspended','Product','Client',1,'Account :Suspended','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p><b >Your hosting account has been <span style=\"color:red\">suspended</span></b></p>\r\n\r\n\r\n<h2>Related Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\nYour hosting account has been suspended\r\n\r\n# Account Information\r\n\r\nHosting Package: {$service.product_name}\r\nDomain: {$service.domain}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n',1,2,1,0),(9,'Account:Unsuspended','Product','Client',1,'Account {$service.domain}: Unsuspended','DEAR {$client.firstname} {$client.lastname},\r\n\r\nYOUR HOSTING ACCOUNT HAS BEEN UNSUSPENDED \r\n\r\nDETAILS:\r\nPRODUCT/SERVICE: {$service.product_name}\r\nDOMAIN: {$service.domain}\r\n <strong>NEXT DUE DATE: {$service.next_due|dateformat:$date_format}</strong>\r\n\r\n','DEAR {$client.firstname} {$client.lastname},\r\n\r\nYOUR HOSTING ACCOUNT HAS BEEN UNSUSPENDED \r\n\r\nDETAILS:\r\nPRODUCT/SERVICE: {$service.product_name}\r\nDOMAIN: {$service.domain}\r\n <strong>NEXT DUE DATE: {$service.next_due|dateformat:$date_format}</strong>\r\n\r\n',1,2,1,0),(10,'Ticket:Reply','Support','Client',1,'Ticket:Reply','{$reply.body}\r\n\r\n{$reply.signature}\r\n----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nTicket URL:  {$ticket_url}\r\n----------------------------------------------','{$reply.body}\r\n\r\n{$reply.signature}\r\n----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nTicket URL:  {$ticket_url}\r\n----------------------------------------------',1,2,1,0),(11,'Ticket:Reply','Support','Admin',1,'New Admin Ticket Reply','{$reply.body}\r\n\r\n----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nURL: {$ticket_admin_url}\r\nAvailable actions:\r\n- Close ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&status=Closed&make=setstatus\r\n- Delete Ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&make=deleteticket\r\n----------------------------------------------','{$reply.body}\r\n\r\n----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nURL: {$ticket_admin_url}\r\nAvailable actions:\r\n- Close ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&status=Closed&make=setstatus\r\n- Delete Ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&make=deleteticket\r\n----------------------------------------------',1,2,1,0),(12,'Ticket:New','Support','Admin',1,'New Admin Ticket','{$ticket.body}\r\n\r\n------------------------------------------\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------','{$ticket.body}\r\n\r\n------------------------------------------\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------',1,2,1,0),(13,'Ticket:Bounce','Support','Client',1,'Your Ticket was not opened','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket because department you\'ve sent email to is for registered customers only, and Your email was not recognised as our customer\'s one.','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket because department you\'ve sent email to is for registered customers only, and Your email was not recognised as our customer\'s one.',1,2,1,0),(15,'Invoice:Overdue','Invoice','Client',1,'Invoice #{$invoice.id}: Payment Reminder','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your invoice is now <b style=\"color:red\">Overdue</b>. To avoid service interruption, please submit payment at your earliest convenience</p>\r\n\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td><h2>Invoice  #{$invoice.id}</h2></td>\r\n                        <td><h2 class=\"align-right\">{$invoice.date|dateformat:$date_format}</h2></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td><h3>Status:  {$invoice.status}</h3></td>\r\n                        <td><h3 class=\"align-right\">Due: {$invoice.duedate|dateformat:$date_format}</h3></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                            {foreach from=$invoiceitems item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description} {if $item.qty}{$item.qty} x {/if}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$invoice.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n       \r\n       <p>\r\n           <b>Payment method:</b> {$invoice.gateway}<br>\r\n           <b><a href=\"{$invoices_url}\">Browse all invoices</a></b>\r\n       </p>             \r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\nINVOICE:                {$invoice.id}\r\nGENERATED AT: {$invoice.date|dateformat:$date_format} \r\nDUE DATE:           {$invoice.duedate|dateformat:$date_format}.\r\n\r\nPAYMENT METHOD \r\n{$invoice.gateway}\r\n\r\n\r\nAmount Due: {$invoice.total|price:$currency}\r\n\r\nLINK TO PAY\r\n{$invoices_url}',1,2,1,0),(19,'Account:Automation Results','Product','Admin',1,'Account #{$service.id} Notify','<h1>Action: {$account_action}</h1>\r\n<h2>Result: {if $result}<span style=\"color:green\">Success</span>{else}<span style=\"color:red\">FAIL</span>{/if}</h2>\r\n\r\n{if $account_error}\r\n<h2 style=\"color:red\">Errors:</h2>\r\n    <p>{foreach from=$account_error item=errx}\r\n        {$errx}\r\n    {/foreach}</p>\r\n{/if}\r\n<hr />\r\n<p>\r\n    <b>Client:</b> {$client.firstname} {$client.lastname}<br><br>\r\n    \r\n    <b>Order ID:</b>  {$service.order_id} <br>\r\n    <b>Order Number:</b> {$service.order_num} <br>\r\n    <b>Product:</b> {$service.product_name} <br>\r\n    <b>Username:</b> {$service.username} <br> <br>\r\n    \r\n    {if $service.domain}<b>Hostname:</b> {$service.domain} <br>{/if}\r\n    {if $domain_module}<b>Registrar:</b> {$domain_module} <br> <br>{/if}\r\n    \r\n    <b>Server Name:</b> {$server.name} <br>\r\n    <b>Server Hostname:</b> {$server.host} <br>\r\n    <b>Server IP:</b> {$server.ip} <br>\r\n    <b>Server NameServer 1:</b> {$server.ns1} <br>\r\n    <b>Server NameServer 2:</b> {$server.ns2} <br>\r\n</p>\r\n','Action: {$account_action}\r\nResult: {if $result}Success{else}FAIL{/if}\r\n\r\n{if $account_error}Errors:\r\n    {foreach from=$account_error item=errx}\r\n        {$errx}\r\n    {/foreach}\r\n{/if}\r\n----------------------------------------------------\r\n# Client: {$client.firstname} {$client.lastname}\r\n# Order ID:  {$service.order_id}\r\n# Order Number: {$service.order_num}\r\n\r\n# Domain Name: {$service.domain}\r\n# Registrar: {$domain_module}\r\n\r\n# Server Name: {$server.name}\r\n# Server Hostname: {$server.host}\r\n# Server IP: {$server.ip}\r\n# Server NameServer 1: {$server.ns1}\r\n# Server NameServer 2: {$server.ns2}\r\n\r\n# Product: {$service.product_name}\r\n# Username: {$service.username}',1,2,1,0),(20,'Account:Created:Cpanel','Product','Client',1,'New Hosting Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your order has been accepted and your hosting account has been activated.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n    <b>Hosting Package:</b> {$service.product_name}<br>\r\n    <b>Domain:</b> {$service.domain}<br>\r\n    <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n    <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n    <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n    <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n    <b>Username:</b> {$service.username}<br>\r\n    <b>Password:</b> {$service.password}<br><br>\r\n    \r\n    <b>Control Panel URL:</b> http://{$server.ip}:2082/<br>\r\n    <b>Secure Control Panel URL:</b> https://{$server.ip}:2083/<br><br>\r\n    \r\n    Once your domain has propogated, you may also use http://www.{$service.domain}:2082/\r\n</p>\r\n\r\n<h2>Server Information</h2>\r\n<p>\r\n    <b>Server Name:</b> {$server.name}<br>\r\n    <b>Server IP:</b> {$server.ip}<br><br>\r\n    \r\n    If you are using an existing domain with your new hosting account, \r\n    you will need to update the nameservers to point to the nameservers listed below.<br><br>\r\n    \r\n    <b>Nameserver 1:</b> {$server.ns1} ({$server.ip1})<br>\r\n    <b>Nameserver 2:</b> {$server.ns2} ({$server.ip2})<br>{if $service_ns3}\r\n    <b>Nameserver 3:</b> {$server.ns3} ({$server.ip3})<br>{/if}{if $service_ns4}\r\n    <b>Nameserver 4:</b> {$server.ns4} ({$server.ip4})<br>{/if}\r\n</p>\r\n\r\n<h2>Uploading Your Website</h2>\r\n<p>\r\n    Once your domain has propagated you may use the details below:<br><br>\r\n    \r\n    <b>FTP Hostname:</b> www.{$service.domain}<br>\r\n    <b>Webpage URL:</b> http://www.{$service.domain}\r\n</p>\r\n<h2>Email Settings</h2>\r\n<p>\r\n    For email accounts that you setup, you should use the following connection details in your email program:\r\n    <br><br>\r\n    <b>POP3 Host Address:</b> mail.{$service.domain}<br>\r\n    <b>SMTP Host Address:</b> mail.{$service.domain}<br>\r\n    <b>Username:</b> The email address you are checking email for<br>\r\n    <b>Password:</b> As specified in your control panel\r\n</p>','Dear {$client.firstname} {$client.lastname}.\r\nYour order has been accepted and your hosting account has been activated.\r\n\r\n# New Account Information\r\nHosting Package: {$service.product_name}\r\nDomain: {$service.domain}\r\nFirst Payment Amount: {$service.firstpayment|price:$currency}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n# Login Details\r\n\r\nUsername: {$service.username}\r\nPassword: {$service.password}\r\n\r\nControl Panel URL: http://{$server.ip}:2082/\r\nSecure Connection Control Panel URL: https://{$server.ip}:2083/\r\nOnce your domain has propogated, you may also use http://www.{$service.domain}:2082/\r\n\r\n# Server Information\r\n\r\nServer Name: {$server.name}\r\nServer IP: {$server.ip}\r\n\r\nIf you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n\r\nNameserver 1: {$server.ns1} ({$server.ip1})\r\nNameserver 2: {$server.ns2} ({$server.ip2}){if $service_ns3}\r\nNameserver 3: {$server.ns3} ({$server.ip3}){/if}{if $service_ns4}\r\nNameserver 4: {$server.ns4} ({$server.ip4}){/if}\r\n\r\n# Uploading Your Website\r\n\r\nTemporarily you may use one of the addresses given below manage your web site:\r\n\r\nTemporary FTP Hostname: {$server.ip}\r\nTemporary Webpage URL: http://{$server.ip}/~{$service.username}/\r\n\r\nAnd once your domain has propagated you may use the details below:\r\n\r\nFTP Hostname: www.{$service.domain}\r\nWebpage URL: http://www.{$service.domain}\r\n\r\n# Email Settings\r\n\r\nFor email accounts that you setup, you should use the following connection details in your email program:\r\n\r\nPOP3 Host Address: mail.{$service.domain}\r\nSMTP Host Address: mail.{$service.domain}\r\nUsername: The email address you are checking email for\r\nPassword: As specified in your control panel',1,2,1,0),(21,'Account:Created:Plesk','Product','Client',1,'New Hosting Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your order has been accepted and your hosting account has been set-up.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n    <b>Username:</b> {$service.username}<br>\r\n    <b>Password:</b> {$service.password}<br><br>\r\n    \r\n    <b>Control Panel URL: https://{$server.ip}:8443/<br>\r\n</p>\r\n\r\n<h2>Server Information</h2>\r\n<p>\r\n    <b>Server Name:</b> {$server.name}<br>\r\n    <b>Server IP:</b> {$server.ip}<br><br>\r\n    \r\n    If you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n    \r\n    <b>Nameserver 1:</b> {$server.ns1} ({$server.ip1})<br>\r\n    <b>Nameserver 2:</b> {$server.ns2} ({$server.ip2})<br>{if $service_ns3}\r\n    <b>Nameserver 3:</b> {$server.ns3} ({$server.ip3})<br>{/if}{if $service_ns4}\r\n    <b>Nameserver 4:</b> {$server.ns4} ({$server.ip4})<br>{/if}\r\n</p>\r\n\r\n<h2>Uploading Your Website</h2>\r\n<p>\r\n    Once your domain has propagated you may use the details below:\r\n    <br><br>\r\n    <b>FTP Hostname:</b> www.{$service.domain}<br>\r\n    <b>Webpage URL:</b> http://www.{$service.domain}<br>\r\n</p>\r\n\r\n<h2>Email Settings</h2>\r\n<p>\r\n    For email accounts that you setup, you should use the following connection details in your email program:\r\n    <br><br>\r\n    <b>POP3 Host Address:</b> mail.{$service.domain}<br>\r\n    <b>SMTP Host Address:</b> mail.{$service.domain}<br>\r\n    <b>Username:</b> The email address you are checking email for<br>\r\n    <b>Password:</b> As specified in your control panel<br>\r\n</p>','Dear {$client.firstname} {$client.lastname}.\r\nYour order has been accepted and your hosting account has been activated.\r\n\r\n# New Account Information\r\n\r\nHosting Package: {$service.product_name}\r\nDomain: {$service.domain}\r\nFirst Payment Amount: {$service.firstpayment|price:$currency}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n# Login Details\r\n\r\nUsername: {$service.username}\r\nPassword: {$service.password}\r\n\r\nControl Panel URL: https://{$server.ip}:8443/\r\n\r\n# Server Information\r\n\r\nServer Name: {$server.name}\r\nServer IP: {$server.ip}\r\n\r\nIf you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n\r\nNameserver 1: {$server.ns1} ({$server.ip1})\r\nNameserver 2: {$server.ns2} ({$server.ip2}){if $server.ns3}\r\nNameserver 3: {$server.ns3} ({$server.ip3}){/if}{if $server.ns4}\r\nNameserver 4: {$server.ns4} ({$server.ip4}){/if}\r\n\r\n# Uploading Your Website\r\n\r\nTemporarily you may use one of the addresses given below manage your web site:\r\n\r\nTemporary FTP Hostname: {$server.ip}\r\nTemporary Webpage URL: https://{$server.ip}:8443/sitepreview/http/{$service.domain}/\r\n\r\nAnd once your domain has propagated you may use the details below:\r\n\r\nFTP Hostname: www.{$service.domain}\r\nWebpage URL: http://www.{$service.domain}\r\n\r\n# Email Settings\r\n\r\nFor email accounts that you setup, you should use the following connection details in your email program:\r\n\r\nPOP3 Host Address: mail.{$service.domain}\r\nSMTP Host Address: mail.{$service.domain}\r\nUsername: The email address you are checking email for\r\nPassword: As specified in your control panel\r\n',1,2,1,0),(23,'Cron Results','General','Admin',1,'Cron-Run Results','<h1>Cron Report generated: {$date}</h1>\r\n<p style=\"color:red\">{$failed_tasks}</p>\r\n\r\n<h2>Invoices</h2>\r\n    <h3>Invoices Generated ({$invoices_generated_count})</h3>\r\n    {if $invoices_generated}  \r\n    <p style=\"padding-left:10px\">\r\n        {foreach from=$invoices_generated item=gen_inv}\r\n            #{$gen_inv.id} - {$gen_inv.client}(ID: {$gen_inv.client_id}) - Total: {$gen_inv.total|price:$currency}<br/>\r\n        {/foreach}\r\n    </p>\r\n    {/if}\r\n\r\n\r\n<h3>Invoices Cancelled ({$invoices_cancelled_count})</h3>\r\n    {if $invoices_cancelled}\r\n    <p style=\"padding-left:10px\">\r\n        {foreach from=$invoices_cancelled item=can_inv}\r\n            #{$can_inv.id}: {$can_inv.firstname} {$can_inv.lastname}(ID: {$can_inv.client_id}) - Total: {$can_inv.total|price:$currency}, Balance: {$can_inv.balance|price:$currency}<br/>\r\n        {/foreach}\r\n    </p>\r\n    {/if}\r\n\r\n\r\n{if $reminds}\r\n<h3>Overdue Invoice Reminders Sent ({$reminds_count})</h3>\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$reminds item=remind}\r\n        {if $remind.number == 1}First{elseif $remind.number == 2}Second{else}Third{/if} Remind For {$remind.client}(ID:{$remind.client_id}) - Invoice #{$remind.id}<br/>\r\n    {/foreach}\r\n    </p>\r\n{/if}\r\n\r\n<br>\r\n\r\n<h2>Accounts</h2>\r\n<h3>Accounts Suspended ({$suspended_accounts_count})</h3>\r\n{if $suspended_accounts}\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$suspended_accounts item=sacc}\r\n        #{$sacc.id}: {$sacc.product_name} - {$sacc.domain} (Server: {$sacc.server_name} - {$sacc.server_ip}, Username: {$sacc.username}) Client: {$sacc.client}(ID:{$sacc.client_id})<br/>\r\n    {/foreach}\r\n</p>\r\n{/if}\r\n\r\n<h3>Accounts Terminated ({$terminated_accounts_count})</h3>\r\n{if $terminated_accounts}\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$terminated_accounts item=tacc}\r\n        #{$tacc.id}: {$tacc.product_name} - {$tacc.domain} (Server: {$tacc.server_name} - {$tacc.server_ip}, Username: {$tacc.username}) Client: {$tacc.client}(ID:{$tacc.client_id})<br/>\r\n    {/foreach}\r\n</p>\r\n{/if}\r\n\r\n<br>\r\n\r\n<h2>Addons</h2>\r\n<h3>Addons Suspended ({$suspended_addons_count})</h3>\r\n{if $suspended_addons}\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$suspended_addons item=sadd}<br/>\r\n        #{$sadd.id}: {$sadd.name} {if $sadd.product_name}({$sadd.product_name}, {$sadd.domain}){else}(Account ID:{$sadd.account_id}){/if} Client: {$sadd.client}(ID:{$sadd.client_id})<br/>\r\n    {/foreach}\r\n</p>\r\n{/if}\r\n\r\n<h3>Addons Terminated ({$terminated_addons_count})</h3>\r\n{if $terminated_addons}\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$terminated_addons item=tadd}\r\n        #{$tadd.id}: {$tadd.name} {if $tadd.product_name}({$tadd.product_name}, {$sadd.domain}){else}(Account ID:{$tadd.account_id}){/if} Client: {$tadd.client}(ID:{$tadd.client_id})<br/>\r\n    {/foreach}\r\n\r\n{/if}\r\n\r\n<br>\r\n\r\n<h2>Domains</h2>\r\n<h3>Upcoming Domain Renewal Notifications Sent ({$domain_reminds_count})</h3>\r\n\r\n{if $domain_reminds}\r\n <p style=\"padding-left:10px\">\r\n    {foreach from=$domain_reminds item=remind}\r\n  - Client: {$remind.client} (ID:{$remind.client_id}) - {$remind.domain} expiring: {$remind.expires|dateformat:$date_format}<br/>\r\n  {/foreach}\r\n  </p>\r\n{/if}\r\n<br>\r\n\r\n<h2>Cancellation Requests Processing</h2>\r\n<h3>Successfull automatic cancellations ({$cancellations_success_count})</h3>\r\n{if $cancellations_success}\r\n <p style=\"padding-left:10px\">\r\n {foreach from=$cancellations_success item=cancel}<br/>\r\n  #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain}<br/>\r\n    {/foreach}\r\n </p>\r\n{/if}\r\n\r\n\r\n<h3>Manual cancellation needed ({$cancellations_failed_count})</h3>\r\n{if $cancellations_failed}\r\n <p style=\"padding-left:10px\">\r\n      <strong style=\"color:red\">[see errors below]</strong><br/>\r\n    {foreach from=$cancellations_failed item=cancel}\r\n        #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain}<br/>\r\n    {/foreach}\r\n  </p>\r\n{/if}\r\n\r\n<br>\r\n\r\n<h2>Support</h2>\r\n\r\n<h3>Tickets Automatically Closed ({$tickets_closed_count})</h3>\r\n{if $tickets_closed}\r\n     <p style=\"padding-left:10px\">\r\n     {foreach from=$tickets_closed item=closed}\r\n        - {$closed.subject}<br/>\r\n    {/foreach}\r\n    </p>\r\n{/if}\r\n\r\n<hr />\r\n<h2>Errors</h2>\r\n{if $suspend_errors}\r\n\r\n    <h3>Failed accounts automatic suspension (<span style=\"color:red\">{$suspend_errors_count}</span>)</h3>\r\n    <p>{foreach from=$suspend_errors item=sus_err}\r\n        #{$sus_err.id}: {$sus_err.product_name} - {$sus_err.domain} (Server: {$sus_err.server_name} - {$sus_err.server_ip}, Username: {$sus_err.username}) Client: {$sus_err.client}(ID:{$sus_err.client_id})<br/>\r\n        <span style=\"color:red\">{$sus_err.error}</span><br/><br/>\r\n    {/foreach}</p>\r\n    \r\n{/if}\r\n\r\n{if $terminate_errors}\r\n\r\n    <h3>Failed accounts automatic termination (<span style=\"color:red\">{$terminate_errors_count}</span>)</h3>\r\n     <p>{foreach from=$terminate_errors item=ter_err}\r\n        #{$ter_err.id}: {$ter_err.product_name} - {$ter_err.domain} (Server: {$ter_err.server_name} - {$ter_err.server_ip}, Username: {$ter_err.username}) Client: {$ter_err.client}(ID:{$ter_err.client_id})<br/>\r\n        <span style=\"color:red\">{$ter_err.error}</span><br/><br/>\r\n    {/foreach}</p>\r\n{/if}\r\n\r\n{if $cancellations_failed}\r\n\r\n    <h3>Errors during automatic cancellation requests processing:</h3>\r\n     <p>{foreach from=$cancellations_failed item=cancel}<br/>\r\n       #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain} <br/>\r\n       {foreach from=$cancel.errors item=err} \r\n            <span style=\"color:red\">{$err}</span><br/>\r\n        {/foreach}<br/>\r\n      {/foreach}</p>\r\n{/if}\r\n\r\n<hr />\r\n {$output}\r\n','{$failed_tasks}\r\nCron Report generated: {$date}\r\nInvoices\r\nInvoices Generated ({$invoices_generated_count})\r\n{if $invoices_generated}\r\n{foreach from=$invoices_generated item=gen_inv}\r\n        #{$gen_inv.id} - {$gen_inv.client}(ID: {$gen_inv.client_id}) - Total: {$gen_inv.total|price:$currency}\r\n    {/foreach}\r\n{else}\r\n{/if}\r\nInvoices Cancelled ({$invoices_cancelled_count})\r\n{if $invoices_cancelled}\r\n    {foreach from=$invoices_cancelled item=can_inv}\r\n        #{$can_inv.id}: {$can_inv.firstname} {$can_inv.lastname}(ID: {$can_inv.client_id}) - Total: {$can_inv.total|price:$currency}, Balance: {$can_inv.balance|price:$currency}\r\n    {/foreach}\r\n{else}\r\n{/if}\r\n{if $reminds}\r\nOverdue Invoice Reminders Sent ({$reminds_count})\r\n    {foreach from=$reminds item=remind}\r\n        {if $remind.number == 1}First{elseif $remind.number == 2}Second{else}Third{/if} Remind For {$remind.client}(ID:{$remind.client_id}) - Invoice #{$remind.id}\r\n    {/foreach}\r\n{/if}\r\nAccounts\r\nAccounts Suspended ({$suspended_accounts_count})\r\n{if $suspended_accounts}\r\n    {foreach from=$suspended_accounts item=sacc}\r\n        #{$sacc.id}: {$sacc.product_name} - {$sacc.domain} (Server: {$sacc.server_name} - {$sacc.server_ip}, Username: {$sacc.username}) Client: {$sacc.client}(ID:{$sacc.client_id})\r\n    {/foreach}\r\n{else}\r\n{/if}\r\nAccounts Terminated ({$terminated_accounts_count})\r\n{if $terminated_accounts}\r\n    {foreach from=$terminated_accounts item=tacc}\r\n        #{$tacc.id}: {$tacc.product_name} - {$tacc.domain} (Server: {$tacc.server_name} - {$tacc.server_ip}, Username: {$tacc.username}) Client: {$tacc.client}(ID:{$tacc.client_id})\r\n    {/foreach}\r\n{else}\r\n{/if}\r\nAddons\r\nAddons Suspended ({$suspended_addons_count})\r\n{if $suspended_addons}\r\n    {foreach from=$suspended_addons item=sadd}\r\n        #{$sadd.id}: {$sadd.name} {if $sadd.product_name}({$sadd.product_name}, {$sadd.domain}){else}(Account ID:{$sadd.account_id}){/if} Client: {$sadd.client}(ID:{$sadd.client_id})\r\n    {/foreach}\r\n{else}\r\n{/if}\r\nAddons Terminated ({$terminated_addons_count})\r\n{if $terminated_addons}\r\n    {foreach from=$terminated_addons item=tadd}\r\n        #{$tadd.id}: {$tadd.name} {if $tadd.product_name}({$tadd.product_name}, {$sadd.domain}){else}(Account ID:{$tadd.account_id}){/if} Client: {$tadd.client}(ID:{$tadd.client_id})\r\n    {/foreach}\r\n{else}\r\n{/if}\r\nUpcoming Domain Renewal Notifications Sent ({$domain_reminds_count})\r\n{if $domain_reminds}\r\n  {foreach from=$domain_reminds item=remind}\r\n  - Client: {$remind.client} (ID:{$remind.client_id}) - {$remind.domain} expiring: {$remind.expires|dateformat:$date_format}\r\n   {/foreach}\r\n{/if}\r\nCancellation Requests Processing\r\nSuccessfull automatic cancellations ({$cancellations_success_count})\r\n{if $cancellations_success}\r\n {foreach from=$cancellations_success item=cancel}\r\n   #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain}\r\n     {/foreach}\r\n{/if}\r\nManual cancellation needed ({$cancellations_failed_count})\r\n{if $cancellations_failed} [see errors below]\r\n {foreach from=$cancellations_failed item=cancel}\r\n    #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain}\r\n     {/foreach}\r\n{/if}\r\nTickets\r\nTickets Automatically Closed ({$tickets_closed_count})\r\n{if $tickets_closed}\r\n {foreach from=$tickets_closed item=closed}\r\n- {$closed.subject}\r\n{/foreach}\r\n{/if}\r\n------------------------------------------------------------------------\r\nErrors:\r\n{if $suspend_errors}\r\n    Failed accounts automatic suspension ({$suspend_errors_count})\r\n    {foreach from=$suspend_errors item=sus_err}\r\n        #{$sus_err.id}: {$sus_err.product_name} - {$sus_err.domain} (Server: {$sus_err.server_name} - {$sus_err.server_ip}, Username: {$sus_err.username}) Client: {$sus_err.client}(ID:{$sus_err.client_id})\r\n        {$sus_err.error}\r\n    {/foreach}\r\n{/if}\r\n{if $terminate_errors}\r\n    Failed accounts automatic termination ({$terminate_errors_count})\r\n    {foreach from=$terminate_errors item=ter_err}\r\n        #{$ter_err.id}: {$ter_err.product_name} - {$ter_err.domain} (Server: {$ter_err.server_name} - {$ter_err.server_ip}, Username: {$ter_err.username}) Client: {$ter_err.client}(ID:{$ter_err.client_id})\r\n        {$ter_err.error}\r\n    {/foreach}\r\n{/if}\r\n{if $cancellations_failed}\r\nErrors during automatic cancellation requests processing:\r\n   {foreach from=$cancellations_failed item=cancel}\r\n    #Acc ID: {$cancel.account_id} - Client: {$cancel.client} (ID:{$cancel.client_id}) - {$cancel.domain} \r\n                           {foreach from=$cancel.errors item=err} {$err}\r\n       {/foreach}\r\n            {/foreach}\r\n{/if}\r\n------------------------------------------------------------------------\r\n {$output}\r\n',1,2,1,0),(24,'Order:New','General','Admin',1,'New Order #{$order.id}','<h1>New order: {$order.id}</h1>\r\n\r\n<h2>Order Info</h2>\r\n<p>\r\n    <b>Order ID:</b> {$order.id}<br>\r\n    <b>Order Number:</b> {$order.number}<br>\r\n    <b>Date Created:</b> {$order.date_created|dateformat:$date_format}<br>\r\n    <b>Invoice Number:</b> {$order.invoice_id}<br>\r\n    <b>Payment Method:</b> {$order.module}<br>\r\n    {if $order.fraudscore}<b>FraudModule risk score:</b> {$order.fraudscore}<br>{/if}\r\n    <b>IP:</b> {$ip_addr}<br>\r\n    <b>Host:</b> {$host_addr}<br>\r\n\r\n</p>\r\n\r\n\r\n<h2>Order Items</h2>\r\n{if $order_details}\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      \r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                           {foreach from=$order_details item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total (+tax):</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$order.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n{else}\r\n    <p>No items to list.</p>\r\n{/if}\r\n   \r\n   \r\n<h2>Client Info</h2>\r\n<p>\r\n    <b>ID:</b> {$client.id} <br>\r\n    <b>Name:</b> {$client.firstname} {$client.lastname} <br>\r\n    <b>Email:</b> {$client.email} <br>\r\n    <b>Company:</b> {$client.companyname} <br>\r\n    <b>Address 1:</b> {$client.address1} <br>\r\n    <b>Address 2:</b> {$client.address2} <br>\r\n    <b>City:</b> {$client.city} <br>\r\n    <b>State/Region:</b> {$client.state} <br>\r\n    <b>Zip Code:</b> {$client.postcode} <br>\r\n    <b>Country:</b> {$client.country} <br>\r\n    <b>Phone Number:</b> {$client.phonenumber} \r\n</p>\r\n','---------------------------------------------------------------\r\nOrder Info\r\n---------------------------------------------------------------\r\n# Order ID: {$order.id}\r\n# Order Number: {$order.number}\r\n# Date Created: {$order.date_created|dateformat:$date_format}\r\n# Invoice Number: {$order.invoice_id}\r\n# Payment Method: {$order.module}\r\n{if $order.fraudscore}# FraudModule risk score: {$order.fraudscore}{/if}\r\n\r\n---------------------------------------------------------------\r\nClient Info\r\n---------------------------------------------------------------\r\n# ID: {$client.id}\r\n# Name: {$client.firstname} {$client.lastname}\r\n# Email: {$client.email}\r\n# Company: {$client.companyname}\r\n# Address 1: {$client.address1}\r\n# Address 2: {$client.address2}\r\n# City: {$client.city}\r\n# State/Region: {$client.state}\r\n# Zip Code: {$client.postcode}\r\n# Country: {$client.country}\r\n# Phone Number: {$client.phonenumber}\r\n\r\n---------------------------------------------------------------\r\nOrder Items\r\n---------------------------------------------------------------\r\n{if $order_details}\r\n{foreach from=$order_details item=item}\r\n #  {$item.amount|price:$currency} - {$item.description}\r\n{/foreach}\r\n\r\nTotal(+tax): {$order.total|price:$currency}\r\n{else}\r\nNo items to list.\r\n{/if}\r\n\r\n\r\n---------------------------------------------------------------\r\nIP: {$ip_addr}\r\nHost: {$host_addr}',1,2,1,0),(25,'Account:Cancellation Request','General','Admin',1,'Account #{$details.acc_id} Cancellation Request','<h1>New cancellation request</h1>\r\n\r\n\r\n<p>\r\n    <b>Client ID:</b> {$client.id}  <br>\r\n    <b>Client Name:</b> {$client.firstname} {$client.lastname}  <br>\r\n</p>\r\n\r\n<p>\r\n    <b>Order ID:</b> {$order_id} <br>\r\n    <b>Account ID:</b> {$details.acc_id} <br>\r\n    <b>Type:</b> {$details.type} <br>\r\n    <b style=\"color:red\">Reason:</b> {$details.reason} <br> <br>\r\n</p>','Cancellation request has been submitted by:\r\n# Client ID: {$client.id} \r\n# Client Name: {$client.firstname} {$client.lastname} \r\n\r\n# Order ID: {$order_id}\r\n\r\n# Account ID: {$details.acc_id}\r\n# Type: {$details.type}\r\n# Reason: {$details.reason}',1,2,1,0),(28,'Domain:Registered','Domain','Client',1,'Domain {$domain.name}: Registered','Dear {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN: {$domain.name} has been registered.\r\n\r\n\r\nDETAILS:\r\nREGISTRATION DATE: {$domain.date_created|dateformat:$date_format}\r\nREGISTRATION PERIOD: {$domain.period} year/s\r\nNEXT DUE DATE: {$domain.next_due|dateformat:$date_format}\r\nAMOUNT: {$domain.firstpayment|price:$currency}','Dear {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN: {$domain.name} has been registered.\r\n\r\n\r\nDETAILS:\r\nREGISTRATION DATE: {$domain.date_created|dateformat:$date_format}\r\nREGISTRATION PERIOD: {$domain.period} year/s\r\nNEXT DUE DATE: {$domain.next_due|dateformat:$date_format}\r\nAMOUNT: {$domain.firstpayment|price:$currency}',1,2,1,1),(29,'Domain:Renewed','Domain','Client',1,'Domain {$domain.name}: Renewed','Dear {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN: {$domain.name} has been renewed!\r\n\r\nDETAILS:\r\nRENEWAL PERIOD:  {$domain.period} year/s\r\nRENEWAL PRICE: {$domain.recurring_amount|price:$currency}\r\nNEXT DUE DATE:  {$domain.next_due|dateformat:$date_format}\r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN: {$domain.name} has been renewed!\r\n\r\nDETAILS:\r\nRENEWAL PERIOD:  {$domain.period} year/s\r\nRENEWAL PRICE: {$domain.recurring_amount|price:$currency}\r\nNEXT DUE DATE:  {$domain.next_due|dateformat:$date_format}\r\n',1,2,1,1),(30,'Domain:Transfer Started','Domain','Client',1,'Domain {$domain.name}: Transfer Initiated','Dear {$client.firstname} {$client.lastname},\r\n\r\nTransfer of  DOMAIN: {$domain.name} has been initiated. \r\n\r\nDETAILS:\r\nREGISTRATION PERIOD:  {$domain.period} year/s\r\nAMOUNT:  {$domain.firstpayment|price:$currency}\r\nRENEWAL PRICE: {$domain.recurring_amount|price:$currency}\r\nNEXT DUE DATE:  {$domain.next_due|dateformat:$date_format}','Dear {$client.firstname} {$client.lastname},\r\n\r\nTransfer of  DOMAIN: {$domain.name} has been initiated. \r\n\r\nDETAILS:\r\nREGISTRATION PERIOD:  {$domain.period} year/s\r\nAMOUNT:  {$domain.firstpayment|price:$currency}\r\nRENEWAL PRICE: {$domain.recurring_amount|price:$currency}\r\nNEXT DUE DATE:  {$domain.next_due|dateformat:$date_format}',1,2,1,1),(32,'Details:Failed Login','General','Admin',1,'Failed Admin Login','{if $third}\r\n<p style=\"color:red\">\r\n     This is third failed login attempt!<br>\r\n    IP <b>{$ip}</b> has been banned for 5 hours.\r\n</p>\r\n   \r\n{else}\r\n    <h2>There was a failed login attempt to HostBill admin area.</h2>\r\n{/if}\r\n<p>\r\n    <b>Date:</b> {$date}<br>\r\n    <b>IP:</b> {$ip}<br>\r\n    <b>Host:</b> {$host}<br>\r\n    <b>Login:</b> {$login}\r\n</p>','{if $third}\r\nThis is third failed login attempt!\r\nIP has been banned for 5 hours.\r\n{else}\r\nThere was a failed login attempt to admin area in HostBill.\r\n{/if}\r\n----------------------------------------------------\r\nDate: {$date}\r\nIP: {$ip}\r\nHost: {$host}\r\n\r\nLogin: {$login}\r\n----------------------------------------------------',1,2,1,1),(33,'Clients:Details Changed','General','Admin',1,'Client #{$old.id} Details Changed','<h1>Client #{$old.id} changed his details</h1>\r\n\r\n<h2>Old details</h2>\r\n<p>\r\n    <b>First Name</b> {$old.firstname}<br>\r\n    <b>Last Name</b> {$old.lastname}<br>\r\n    <b>Email Address</b> {$old.email}<br>\r\n    <b>Company Name</b> {$old.companyname}<br>\r\n    <b>Address 1</b> {$old.address1}<br>\r\n    <b>Address 2</b> {$old.address2}<br>\r\n    <b>City</b> {$old.city}<br>\r\n    <b>State/Region</b> {$old.state}<br>\r\n    <b>Zip Code</b> {$old.postcode}<br>\r\n    <b>Country</b> {$old.country}<br>\r\n    <b>Phone Number</b> {$old.phonenumber}<br>\r\n</p>\r\n\r\n<h2>New details</h2>\r\n<p>\r\n    <b>First Name</b> {$new.firstname}<br>\r\n    <b>Last Name</b> {$new.lastname}<br>\r\n    <b>Email Address</b> {$new.email}<br>\r\n    <b>Company Name</b> {$new.companyname}<br>\r\n    <b>Address 1</b> {$new.address1}<br>\r\n    <b>Address 2</b> {$new.address2}<br>\r\n    <b>City</b> {$new.city}<br>\r\n    <b>State/Region</b> {$new.state}<br>\r\n    <b>Zip Code</b> {$new.postcode}<br>\r\n    <b>Country</b> {$new.country}<br>\r\n    <b>Phone Number</b> {$new.phonenumber}<br>\r\n</p>','Client with ID #{$old.id} changed his details.\r\n\r\n---------------------------------------------------------------\r\nOld Details\r\n---------------------------------------------------------------\r\n# First Name: {$old.firstname}\r\n# Last Name: {$old.lastname}\r\n# Email Address: {$old.email}\r\n# Company Name: {$old.companyname}\r\n# Address 1: {$old.address1}\r\n# Address 2: {$old.address2}\r\n# City: {$old.city}\r\n# State/Region: {$old.state}\r\n# Zip Code: {$old.postcode}\r\n# Country: {$old.country}\r\n# Phone Number: {$old.phonenumber}\r\n\r\n---------------------------------------------------------------\r\nNew Details\r\n---------------------------------------------------------------\r\n# First Name: {$new.firstname}\r\n# Last Name: {$new.lastname}\r\n# Email Address: {$new.email}\r\n# Company Name: {$new.companyname}\r\n# Address 1: {$new.address1}\r\n# Address 2: {$new.address2}\r\n# City: {$new.city}\r\n# State/Region: {$new.state}\r\n# Zip Code: {$new.postcode}\r\n# Country: {$new.country}\r\n# Phone Number: {$new.phonenumber}',1,2,1,1),(34,'Account:Automatic Setup','Product','Admin',1,'Automatic Setup: Account #{$service.id}','<h1>Automatic setup notification</h1>\r\n\r\n<p>\r\n    First payment has been received for the following order and account has been automatically created.\r\n</p>\r\n\r\n<p>\r\n    <b>Client:</b> {$client.firstname} {$client.lastname}, ID: {$client.client_id} <br>\r\n    <b>Product: </b>{$service.product_name} <br>\r\n    <b>Domain:</b> {$service.domain} <br>\r\n    <b>Order ID:</b> {$service.order_id} <br>\r\n    <b>Order Number:</b> {$service.order_num} <br>\r\n</p>','First payment has been received for the following order and account has been automatically created.\r\n\r\n# Order ID: {$service.order_id}\r\n# Order Number: {$service.order_num}\r\n\r\n# Client: {$client.firstname} {$client.lastname}, ID: {$client.client_id}\r\n# Product: {$service.product_name}\r\n# Domain: {$service.domain}',1,2,1,1),(35,'Details:Password Reset','General','Client',1,'Login details to {$system_url}','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your new client area password has been generated</p>\r\n<p>\r\n    <b>E-mail:</b> {$client.email}<br>\r\n    <b>Password:</b> {$newpass}<br><br>\r\n    \r\n    <b>Login URL:</b>  <a href=\"{$system_url}\">{$system_url}</a>\r\n</p>\r\n ','DEAR {$client.firstname} {$client.lastname},\r\n\r\n\r\nEMAIL: {$client.email}\r\nPASSWORD:{$newpass}\r\n\r\nLOGIN LINK  {$system_url}\r\n ',1,2,1,1),(54,'Domain:Reminder','Domain','Client',1,'Domain: {$domain.name} Renew Now','DEAR {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN:{$domain.name}  WILL EXPIRE ON {$domain.expires|dateformat:$date_format} .\r\n\r\n\r\n\r\nRENEW DOMAIN:\r\n {$clientarea_url}\r\n\r\n','DEAR {$client.firstname} {$client.lastname},\r\n\r\nDOMAIN:{$domain.name}  WILL EXPIRE ON {$domain.expires|dateformat:$date_format} .\r\n\r\n\r\n\r\nRENEW DOMAIN:\r\n {$clientarea_url}\r\n\r\n',1,2,1,0),(55,'Ticket:AutoClose','Support','Client',1,'Support Ticket Closed','{$ticket.name},\r\n\r\nTicket: #{$ticket.ticket_number} changed status from Open to Closed \r\nLast response: {$ticket_autoclose_time} hours ago. \r\n\r\nIf your issue is not resolved within a reasonable timeframe, you should contact us again.\r\n\r\n------------------------------------- \r\nSubject: {$ticket.subject} \r\nDepartment: {$ticket.department} \r\nStatus: {$ticket.status} \r\n-------------------------------------\r\n','{$ticket.name},\r\n\r\nTicket: #{$ticket.ticket_number} changed status from Open to Closed \r\nLast response: {$ticket_autoclose_time} hours ago. \r\n\r\nIf your issue is not resolved within a reasonable timeframe, you should contact us again.\r\n\r\n------------------------------------- \r\nSubject: {$ticket.subject} \r\nDepartment: {$ticket.department} \r\nStatus: {$ticket.status} \r\n-------------------------------------\r\n',1,2,1,0),(56,'Domain:Manual Register','Domain','Admin',1,'Register Domain {$domain.name}','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n{foreach from=$nameservers item=ns key=nsnr}\r\n{if $ns}# Name Server {$nsnr} : {$ns}{/if}\r\n{/foreach}\r\n\r\n# Registrant First Name: {$client.firstname}\r\n# Registrant Last Name: {$client.lastname}\r\n# Registrant Email: {$client.email}\r\n# Registrant Company: {$client.companyname}\r\n# Registrant Address 1: {$client.address1}\r\n# Registrant Address 2: {$client.address2}\r\n# Registrant City: {$client.city}\r\n# Registrant State/Region: {$client.state}\r\n# Registrant Zip Code: {$client.postcode}\r\n# Registrant Country: {$client.country}\r\n# Registrant Phone Number: {$client.phonenumber}\r\n\r\n# Admin First Name: {$client.firstname}\r\n# Admin Last Name: {$client.lastname}\r\n# Admin Email: {$client.email}\r\n# Admin Company: {$client.companyname}\r\n# Admin Address 1: {$client.address1}\r\n# Admin Address 2: {$client.address2}\r\n# Admin City: {$client.city}\r\n# Admin State/Region: {$client.state}\r\n# Admin Zip Code: {$client.postcode}\r\n# Admin Country: {$client.country}\r\n# Admin Phone Number: {$client.phonenumber}','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n{foreach from=$nameservers item=ns key=nsnr}\r\n{if $ns}# Name Server {$nsnr} : {$ns}{/if}\r\n{/foreach}\r\n\r\n# Registrant First Name: {$client.firstname}\r\n# Registrant Last Name: {$client.lastname}\r\n# Registrant Email: {$client.email}\r\n# Registrant Company: {$client.companyname}\r\n# Registrant Address 1: {$client.address1}\r\n# Registrant Address 2: {$client.address2}\r\n# Registrant City: {$client.city}\r\n# Registrant State/Region: {$client.state}\r\n# Registrant Zip Code: {$client.postcode}\r\n# Registrant Country: {$client.country}\r\n# Registrant Phone Number: {$client.phonenumber}\r\n\r\n# Admin First Name: {$client.firstname}\r\n# Admin Last Name: {$client.lastname}\r\n# Admin Email: {$client.email}\r\n# Admin Company: {$client.companyname}\r\n# Admin Address 1: {$client.address1}\r\n# Admin Address 2: {$client.address2}\r\n# Admin City: {$client.city}\r\n# Admin State/Region: {$client.state}\r\n# Admin Zip Code: {$client.postcode}\r\n# Admin Country: {$client.country}\r\n# Admin Phone Number: {$client.phonenumber}',1,2,1,1),(57,'Domain:Manual Transfer','Domain','Admin',1,'Transfer Domain {$domain.name}','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n# Epp Code: {$domain.epp_code}\r\n{foreach from=$nameservers item=ns key=nsnr}\r\n{if $ns}\r\n# Name Server {$nsnr} : {$ns}\r\n{/if}\r\n{/foreach}\r\n\r\n# Registrant First Name: {$client.firstname}\r\n# Registrant Last Name: {$client.lastname}\r\n# Registrant Email: {$client.email}\r\n# Registrant Company: {$client.companyname}\r\n# Registrant Address 1: {$client.address1}\r\n# Registrant Address 2: {$client.address2}\r\n# Registrant City: {$client.city}\r\n# Registrant State/Region: {$client.state}\r\n# Registrant Zip Code: {$client.postcode}\r\n# Registrant Country: {$client.country}\r\n# Registrant Phone Number: {$client.phonenumber}\r\n\r\n# Admin First Name: {$client.firstname}\r\n# Admin Last Name: {$client.lastname}\r\n# Admin Email: {$client.email}\r\n# Admin Company: {$client.companyname}\r\n# Admin Address 1: {$client.address1}\r\n# Admin Address 2: {$client.address2}\r\n# Admin City: {$client.city}\r\n# Admin State/Region: {$client.state}\r\n# Admin Zip Code: {$client.postcode}\r\n# Admin Country: {$client.country}\r\n# Admin Phone Number: {$client.phonenumber}','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n# Epp Code: {$domain.epp_code}\r\n{foreach from=$nameservers item=ns key=nsnr}\r\n{if $ns}\r\n# Name Server {$nsnr} : {$ns}\r\n{/if}\r\n{/foreach}\r\n\r\n# Registrant First Name: {$client.firstname}\r\n# Registrant Last Name: {$client.lastname}\r\n# Registrant Email: {$client.email}\r\n# Registrant Company: {$client.companyname}\r\n# Registrant Address 1: {$client.address1}\r\n# Registrant Address 2: {$client.address2}\r\n# Registrant City: {$client.city}\r\n# Registrant State/Region: {$client.state}\r\n# Registrant Zip Code: {$client.postcode}\r\n# Registrant Country: {$client.country}\r\n# Registrant Phone Number: {$client.phonenumber}\r\n\r\n# Admin First Name: {$client.firstname}\r\n# Admin Last Name: {$client.lastname}\r\n# Admin Email: {$client.email}\r\n# Admin Company: {$client.companyname}\r\n# Admin Address 1: {$client.address1}\r\n# Admin Address 2: {$client.address2}\r\n# Admin City: {$client.city}\r\n# Admin State/Region: {$client.state}\r\n# Admin Zip Code: {$client.postcode}\r\n# Admin Country: {$client.country}\r\n# Admin Phone Number: {$client.phonenumber}',1,2,1,1),(58,'Domain:Manual Renew','Domain','Admin',1,'Renew Domain {$domain.name}','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s','# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s',1,2,1,1),(59,'Invoice:Reminder','Invoice','Client',1,'Invoice #{$invoice.id}: Unpaid Reminder','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>We send this email to remind you that your invoice is still unpaid. To avoid service interruption, please submit payment at your earliest convenience</p>\r\n\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td><h2>Invoice  #{$invoice.id}</h2></td>\r\n                        <td><h2 class=\"align-right\">{$invoice.date|dateformat:$date_format}</h2></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td><h3>Status:  {$invoice.status}</h3></td>\r\n                        <td><h3 class=\"align-right\">Due: {$invoice.duedate|dateformat:$date_format}</h3></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                            {foreach from=$invoiceitems item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description} {if $item.qty}{$item.qty} x {/if}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$invoice.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n       \r\n       <p>\r\n           <b>Payment method:</b> {$invoice.gateway}<br>\r\n           <b><a href=\"{$invoices_url}\">Browse all invoices</a></b>\r\n       </p>             \r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\nINVOICE:                {$invoice.id}\r\nGENERATED AT: {$invoice.date|dateformat:$date_format} \r\nDUE DATE:           {$invoice.duedate|dateformat:$date_format}.\r\n\r\nPAYMENT METHOD \r\n{$invoice.gateway}\r\n\r\n\r\nAmount Due: {$invoice.total|price:$currency}\r\n\r\nLINK TO PAY\r\n{$invoices_url}',1,2,1,0),(60,'Account:Created:VPS','Product','Client',1,'New Hosting Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n<p>Your order has been accepted and your VPS Server has been set-up.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n   <b>Username:</b> {$service.username}<br>\r\n   <b>Password:</b> {$service.password}<br>\r\n   <b>RootPassword:</b> {$service.rootpassword}<br>\r\n\r\n{if $service.ip}<b>Main IP:</b> {$service.ip}<br>{/if}\r\n{if $service.additional_ip!=\"\"}<b>Additional IPs:</b> {$service.additional_ip}<br>{/if}\r\n{if $service.disk_limit!=\"0\"}<b>Disk Limit:</b> {$service.disk_limit} GB<br>{/if}\r\n{if $service.bw_limit!=\"0\"}<b>Bandwidth Limit:</b> {$service.bw_limit} MB<br>{/if}\r\n{if $service.guaranteed_ram!=\"0\"}<b>Memory:</b> {$service.guaranteed_ram} MB<br>{/if}\r\n{if $service.os!=\"\"}<b>OS:</b> {$service.os}<br>{/if}\r\n</p>\r\n\r\n','Dear {$client.firstname} {$client.lastname},\r\nYour order has been accepted and your VPS Server has been set-up.\r\n\r\n# New Account Information\r\n\r\n   Package: {$service.product_name}\r\n\r\n   Hostname: {$service.domain}\r\n\r\n   First Payment Amount: {$service.firstpayment|price:$currency}\r\n\r\n   Total Amount: {$service.total|price:$currency}\r\n\r\n   Billing Cycle: {$service.billingcycle}\r\n\r\n   Next Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n\r\n\r\n# Login Details\r\n\r\n   Username: {$service.username}\r\n\r\n   Password: {$service.password}\r\n\r\n   RootPassword: {$service.rootpassword}\r\n\r\n{if $service.ip}  Main IP: {$service.ip}\r\n{/if}\r\n{if $service.additional_ip!=\"\"}Additional IPs: {$service.additional_ip}\r\n{/if}\r\n{if $service.disk_limit!=\"0\"}Disk Limit: {$service.disk_limit} GB\r\n{/if}\r\n{if $service.bw_limit!=\"0\"}Bandwidth Limit: {$service.bw_limit} MB\r\n{/if}\r\n{if $service.guaranteed_ram!=\"0\"}Memory: {$service.guaranteed_ram} MB\r\n{/if}\r\n{if $service.os!=\"\"}OS: {$service.os}\r\n{/if}\r\n\r\n',1,2,1,0),(61,'Domain:Manual Change NS','Domain','Admin',1,'Domain: {$domain.name} Change Nameservers','# Domain Name: {$domain.name}\r\n\r\n{foreach from=$ns item=n key=k}\r\n# Nameserver {$k+1}: {$n} \r\n\r\n{/foreach} ','# Domain Name: {$domain.name}\r\n\r\n{foreach from=$ns item=n key=k}\r\n# Nameserver {$k+1}: {$n} \r\n\r\n{/foreach} ',1,2,1,1),(63,'Account:Created:InterWorx','Product','Client',1,'New Hosting Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your order has been accepted and your hosting account has been set-up.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n    <b>Username:</b> {$service.username}<br>\r\n    <b>Password:</b> {$service.password}<br>\r\n    <b>Domain:</b> {$service.domain}<br><br>\r\n\r\n    <b>Control Panel URL:</b> https://{$server.ip}:2443/siteworx/\r\n</p>\r\n\r\n<h2>Server Information</h2>\r\n<p>\r\n    <b>Server Name:</b> {$server.name}<br>\r\n    <b>Server IP:</b> {$server.ip}<br><br>\r\n    \r\n    If you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n    \r\n    <b>Nameserver 1:</b> {$server.ns1} ({$server.ip1})<br>\r\n    <b>Nameserver 2:</b> {$server.ns2} ({$server.ip2})<br>{if $service_ns3}\r\n    <b>Nameserver 3:</b> {$server.ns3} ({$server.ip3})<br>{/if}{if $service_ns4}\r\n    <b>Nameserver 4:</b> {$server.ns4} ({$server.ip4})<br>{/if}\r\n</p>\r\n\r\n<h2>Uploading Your Website</h2>\r\n<p>\r\n    Once your domain has propagated you may use the details below:\r\n    <br><br>\r\n    <b>FTP Hostname:</b> www.{$service.domain}<br>\r\n    <b>Webpage URL:</b> http://www.{$service.domain}<br>\r\n</p>\r\n\r\n<h2>Email Settings</h2>\r\n<p>\r\n    For email accounts that you setup, you should use the following connection details in your email program:\r\n    <br><br>\r\n    <b>POP3 Host Address:</b> mail.{$service.domain}<br>\r\n    <b>SMTP Host Address:</b> mail.{$service.domain}<br>\r\n    <b>Username:</b> The email address you are checking email for<br>\r\n    <b>Password:</b> As specified in your control panel<br>\r\n</p>','Dear {$client.firstname} {$client.lastname}.\r\nYour order has been accepted and your hosting account has been activated.\r\n\r\n# New Account Information\r\nHosting Package: {$service.product_name}\r\nDomain: {$service.domain}\r\nFirst Payment Amount: {$service.firstpayment|price:$currency}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n# Login Details\r\n\r\nUsername: {$service.username}\r\n\r\nEmail Address: {$client.email}\r\nPassword: {$service.password}\r\nDomain: {$service.domain}\r\n\r\nControl Panel URL: https://{$server.ip}:2443/siteworx/\r\n\r\n# Server Information\r\n\r\nServer Name: {$server.name}\r\nServer IP: {$server.ip}\r\n{if $server.host}Server Hostname: {$server.host}\r\n{/if}\r\nIf you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.\r\n\r\nNameserver 1: {$server.ns1} ({$server.ip1})\r\nNameserver 2: {$server.ns2} ({$server.ip2})\r\n{if $service_ns3}Nameserver 3: {$server.ns3} ({$server.ip3})\r\n{/if}{if $service_ns4}Nameserver 4: {$server.ns4} ({$server.ip4})\r\n{/if}\r\n',1,2,1,0),(64,'Account:Password Reset','Product','Admin',1,'Account #{$service.id} Password Reset','<h1>Account password changed</h1>\r\n\r\n<p>\r\n    <b>Account: </b> {$service.id}<br>\r\n    <b>Client: </b>  {$client.firstname} {$client.lastname}<br>\r\n    <br>\r\n    <b>Server Name:</b>  {$server.name}<br>\r\n    <b>Product:</b>  {$service.name}<br>\r\n    <b>Username:</b>  {$service.username}<br>\r\n    <b>Password:</b>  *HIDDEN*<br>\r\n</p>\r\n\r\n\r\n<p>\r\n    Changed by:<br>\r\n    <b>IP:</b> {$ip}<br>\r\n    <b>Host:</b> {$host} <br>\r\n</p>\r\n','Password for account has been changed.\r\n\r\n# Client: {$client.firstname} {$client.lastname}\r\n# Order ID:  {$service.order_id}\r\n\r\n# Server Name: {$server.name}\r\n# Product: {$service.name}\r\n# Username: {$service.username}\r\n# Password:*HIDDEN*\r\n\r\n#IP: {$ip}\r\n#Host: {$host}',1,2,1,0),(65,'Details:CreditCard:ChargeFailed','General','Client',1,'Credit Card Charge Failed','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\n    This is notification that <b>we were <span style=\"color:red\">unable</span> to automatically charge your credit card ({$details.cardnum}).</b>\r\n</p>\r\n<p>\r\n    Please verify credit card details in our client section.\r\n</p>','Dear {$details.firstname} {$details.lastname},\r\n\r\n\r\nThis is notification that we were unable to automatically charge your credit card ({$details.cardnum}).\r\nPlease verify credit card details in our client section.',1,2,1,0),(66,'Account:Password Reset','Product','Client',1,'Service Password Reset','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>You requested to reset the password for the service {$service.name}.</p>\r\n\r\n<h2>New access details:</h2\r\n<p>\r\n    <b>Username:</b> {$service.username}\r\n    <b>Password:</b> {$newpassword}\r\n</p>','Dear  {$client.firstname} {$client.lastname},\r\n\r\nYou requested to reset the password for the service {$service.name} .\r\n\r\n# This is your new details:\r\nUsername: {$service.username}\r\nPassword: {$newpassword}',1,2,1,0),(67,'Account:Created:Dedicated','Product','Client',1,'New Dedicated server set-up','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n<p>Your order has been accepted and your Dedicated Server has been set-up.</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n   <b>Package:</b> {$service.product_name}<br>\r\n   <b>Hostname:</b> {$service.domain}<br>\r\n   <b>First Payment Amount:</b> {$service.firstpayment|price:$currency}<br>\r\n   <b>Total Amount:</b> {$service.total|price:$currency}<br>\r\n   <b>Billing Cycle:</b> {$service.billingcycle}<br>\r\n   <b>Next Due Date:</b> {$service.next_due|dateformat:$date_format}<br>\r\n</p>\r\n\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n   <b>Username:</b> {$service.username}<br>\r\n   <b>Password:</b> {$service.password}<br>\r\n   <b>RootPassword:</b> {$service.rootpassword}<br>\r\n\r\n{if $service.ip}<b>Main IP:</b> {$service.ip}<br>{/if}\r\n{if $service.additional_ip!=\"\"}<b>Additional IPs:</b> {$service.additional_ip}<br>{/if}\r\n{if $service.disk_limit!=\"0\"}<b>Disk Limit:</b> {$service.disk_limit} GB<br>{/if}\r\n{if $service.bw_limit!=\"0\"}<b>Bandwidth Limit:</b> {$service.bw_limit} MB<br>{/if}\r\n{if $service.guaranteed_ram!=\"0\"}<b>Memory:</b> {$service.guaranteed_ram} MB<br>{/if}\r\n{if $service.os!=\"\"}<b>OS:</b> {$service.os}<br>{/if}\r\n</p>\r\n\r\n','Dear {$client.firstname} {$client.lastname},\r\nYour order has been accepted and your Dedicated Server has been set-up.\r\n\r\n# New Account Information\r\n\r\n   Package: {$service.product_name}\r\n\r\n   Hostname: {$service.domain}\r\n\r\n   First Payment Amount: {$service.firstpayment|price:$currency}\r\n\r\n   Total Amount: {$service.total|price:$currency}\r\n\r\n   Billing Cycle: {$service.billingcycle}\r\n\r\n   Next Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n\r\n\r\n# Login Details\r\n\r\n   Username: {$service.username}\r\n\r\n   Password: {$service.password}\r\n\r\n   RootPassword: {$service.rootpassword}\r\n\r\n{if $service.ip}  Main IP: {$service.ip}\r\n{/if}\r\n{if $service.additional_ip!=\"\"}Additional IPs: {$service.additional_ip}\r\n{/if}\r\n{if $service.disk_limit!=\"0\"}Disk Limit: {$service.disk_limit} GB\r\n{/if}\r\n{if $service.bw_limit!=\"0\"}Bandwidth Limit: {$service.bw_limit} MB\r\n{/if}\r\n{if $service.guaranteed_ram!=\"0\"}Memory: {$service.guaranteed_ram} MB\r\n{/if}\r\n{if $service.os!=\"\"}OS: {$service.os}\r\n{/if}\r\n\r\n',1,2,1,0),(69,'Affiliate Monthly Report','General','Client',1,'Affiliate Monthly Report','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n\r\n<p>This is your monthly affiliate referrals report. \r\nYou can view your affiliate statistics by logging in to the client area.</p>\r\n\r\n<p>\r\n    <b>Total Visitors:</b> {$affiliate.visits}<br>\r\n    <b>Current Balance:</b> {$affiliate.balance|price:$affiliate.currency_id}<br>\r\n    <b>Amount Withdrawn:</b> {$affiliate.total_withdrawn|price:$affiliate.currency_id}<br>\r\n</p>\r\n\r\n{if $affiliate.orders}\r\n<h2>New Signups this Month referred by you:</h2>\r\n\r\n{foreach from=$affiliate.orders item=order}\r\n<p>\r\n    {if $order.acstatus}<b>Account:</b> {$order.pname}<br>{/if}\r\n    {if $order.domstatus}<b>Domain:</b> {$order.domain}<br>{/if}\r\n    <b>Order Total:</b> {$order.total|price:$affiliate.currency_id} <br>\r\n    {if $moredetails}\r\n        {if $order.firstname || $order.lastname || $order.companyname}\r\n            Client Info: {if $order.companyname}{$order.companyname}<br>\r\n        {else}\r\n            {$order.firstname}{$order.lastname}{$order.companyname}<br>\r\n        {/if}\r\n    {/if}\r\n        {if $order.inv_id}Invoice ID: #{if $proforma && ($order.inv_status==\'Paid\' || $order.inv_status==\'Refunded\') && $order.inv_paid!=\'\'}{$order.inv_paid}\r\n        <br>\r\n        {else}\r\n            {$order.inv_date|invprefix:$prefix:$order.client_id}{$order.inv_id}\r\n        <br>{/if}\r\n        Invoice Date: {$order.inv_date|dateformat:$date_format}<br>\r\n        Invoice Due Date: {$order.inv_due|dateformat:$date_format}<br>\r\n        Invoice Total: {$order.inv_total|price:$order.currency_id} <br>\r\n    {/if}{/if}\r\n    <b>Commission:</b> {$order.commission|price:$affiliate.currency_id}\r\n</p>\r\n{/foreach}\r\n{else}\r\n<p><b>No new signups referred this month.</b></p>\r\n{/if}\r\n<p>Remember: You can refer new customers using your unique affiliate link: {$affiliate.url}</p>\r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\n\r\nThis is your monthly affiliate referrals report. You can view your affiliate statistics by logging in to the client area.\r\n\r\nTotal Visitors : {$affiliate.visits}\r\nCurrent Balance: {$affiliate.balance|price:$affiliate.currency_id}\r\nAmount Withdrawn: {$affiliate.total_withdrawn|price:$affiliate.currency_id}\r\n\r\n{if $affiliate.orders}\r\n# New Signups this Month referred by you:\r\n--\r\n{foreach from=$affiliate.orders item=order}\r\n{if $order.acstatus}Account: {$order.pname}\r\n{/if}{if $order.domstatus}Domain: {$order.domain}\r\n{/if}\r\nOrder Total: {$order.total|price:$affiliate.currency_id} \r\n{if $moredetails}\r\n{if $order.firstname || $order.lastname || $order.companyname}Client Info: {if $order.companyname}{$order.companyname}\r\n{else}{$order.firstname}{$order.lastname}{$order.companyname}\r\n{/if}\r\n{/if}\r\n{if $order.inv_id}Invoice ID: #{if $proforma && ($order.inv_status==\'Paid\' || $order.inv_status==\'Refunded\') && $order.inv_paid!=\'\'}{$order.inv_paid}\r\n{else}{$order.inv_date|invprefix:$prefix:$order.client_id}{$order.inv_id}\r\n{/if}\r\nInvoice Date: {$order.inv_date|dateformat:$date_format}\r\nInvoice Due Date: {$order.inv_due|dateformat:$date_format}\r\nInvoice Total: {$order.inv_total|price:$order.currency_id} \r\n{/if}{/if}\r\nCommission: {$order.commission|price:$affiliate.currency_id}\r\n--\r\n{/foreach}\r\n{/if}\r\nYou can refer new customers using your unique affiliate link: {$affiliate.url}\r\n',1,2,1,0),(70,'Details:Password Reset','General','Admin',1,'Admin Password Reset','<h1>Hi {$firstname} {$lastname},</h1>\r\n\r\n\r\n<p>\r\nYou have requested and confirmed password reset in Admin Area. Your new details:<br><br>\r\n    <b>Username:</b> {$username}<br>\r\n    <b>Password:</b> {$newpassword}<br>\r\n</p>\r\n\r\n<h3>Request info</h3>\r\n<p>\r\n    <b>Date:</b>  {$date}<br>\r\n    <b>IP:</b>  {$ip}<br>\r\n    <b>Host:  {$host}<br>\r\n</p>\r\n','Dear  {$firstname} {$lastname},\r\n\r\n You have requested password reset in Admin Area. Your new details:\r\n #Username: {$username}\r\n #Password: {$newpassword}\r\n\r\n ----------------------------------------------------\r\n Date: {$date}\r\n IP: {$ip}\r\n Host: {$host}\r\n ----------------------------------------------------',1,2,1,1),(71,'Details:Password Request','General','Client',1,'Password Reset for {$system_url}','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\nYou requested that you be reminded of your Client Area Login Details.\r\n</p>\r\n\r\n<p>Please click the link below to reset your password:</p>\r\n\r\n<table class=\"body-action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td align=\"center\">\r\n                          <div>\r\n                            <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"{$hash}\" style=\"height:45px;v-text-anchor:middle;width:200px;\" arcsize=\"7%\" stroke=\"f\" fill=\"t\">\r\n                            <v:fill type=\"tile\" color=\"#22BC66\" />\r\n                            <w:anchorlock/>\r\n                            <center style=\"color:#ffffff;font-family:sans-serif;font-size:15px;\">Reset password</center>\r\n                          </v:roundrect><![endif]-->\r\n                            <a href=\"{$hash}\" class=\"button button--green\">Reset password</a>\r\n                          </div>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n                    \r\n                    <table class=\"body-sub\">\r\n                      <tbody><tr>\r\n                        <td>\r\n                          <p class=\"sub\">If you’re having trouble clicking the Reset password button, copy and paste the URL below into your web browser.\r\n                          </p>\r\n                          <p class=\"sub\"><a href=\"{$hash}\">{$hash}</a></p>\r\n                        </td>\r\n                      </tr>\r\n                    </tbody></table>\r\n                    \r\n                    \r\n ','Dear  {$client.firstname} {$client.lastname},\r\n\r\nYou requested that you be reminded of your Client Area Login Details.\r\nPlease click the link below to reset your password:\r\n {$hash}\r\n ',1,2,1,0),(72,'Details:Password Request','General','Admin',1,'Admin Area new password','<h1>Hi {$firstname} {$lastname},</h1>\r\n\r\n\r\n<p>\r\n    There was an password reset attempt for your login in HostBill Admin.<br>\r\n    If this was not placed by you please investigate!<br>\r\n    <b>Request date:</b> {$date}<br>\r\n    <b>Request IP:</b> {$ip}<br>\r\n    <b>Request Host:</b> {$host}<br>\r\n    <br>\r\n    To <b>reset password</b>, please use link below:\r\n</p>\r\n\r\n\r\n\r\n<table class=\"body-action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td align=\"center\">\r\n                          <div>\r\n                            <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"{$hash}\" style=\"height:45px;v-text-anchor:middle;width:200px;\" arcsize=\"7%\" stroke=\"f\" fill=\"t\">\r\n                            <v:fill type=\"tile\" color=\"#22BC66\" />\r\n                            <w:anchorlock/>\r\n                            <center style=\"color:#ffffff;font-family:sans-serif;font-size:15px;\">Reset password</center>\r\n                          </v:roundrect><![endif]-->\r\n                            <a href=\"{$hash}\" class=\"button button--green\">Reset password</a>\r\n                          </div>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n                    \r\n                    <table class=\"body-sub\">\r\n                      <tbody><tr>\r\n                        <td>\r\n                          <p class=\"sub\">If you’re having trouble clicking the Reset password button, copy and paste the URL below into your web browser.\r\n                          </p>\r\n                          <p class=\"sub\"><a href=\"{$hash}\">{$hash}</a></p>\r\n                        </td>\r\n                      </tr>\r\n                    </tbody></table>\r\n                    ','Dear  {$firstname} {$lastname},\r\n\r\n You have requested password reset in Admin Area.\r\n Please click the link below to reset your password:\r\n {$hash}\r\n\r\n\r\n ----------------------------------------------------\r\n Date: {$date}\r\n IP: {$ip}\r\n Host: {$host}\r\n ----------------------------------------------------',1,2,1,1),(73,'Estimate','General','Client',1,'Requested Estimate','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\n     Attached is estimate you\'ve requested. You can view this estimate online following link below:\r\n     \r\n</p>\r\n\r\n<table class=\"body-action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td align=\"center\">\r\n                          <div>\r\n                            <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"{$estimate_link} \" style=\"height:45px;v-text-anchor:middle;width:200px;\" arcsize=\"7%\" stroke=\"f\" fill=\"t\">\r\n                            <v:fill type=\"tile\" color=\"#22BC66\" />\r\n                            <w:anchorlock/>\r\n                            <center style=\"color:#ffffff;font-family:sans-serif;font-size:15px;\">View estimate</center>\r\n                          </v:roundrect><![endif]-->\r\n                            <a href=\"{$estimate_link} \" class=\"button button--green\">View estimate</a>\r\n                          </div>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n                    \r\n                    <table class=\"body-sub\">\r\n                      <tbody><tr>\r\n                        <td>\r\n                          <p class=\"sub\">If you’re having trouble clicking th button above, copy and paste the URL below into your web browser.\r\n                          </p>\r\n                          <p class=\"sub\"><a href=\"{$estimate_link} \">{$estimate_link} </a></p>\r\n                        </td>\r\n                      </tr>\r\n                    </tbody></table>\r\n                    \r\n     <p>\r\n         \r\n {if $estimate.date_expires!=\'0000-00-00\'}<b>This estimate is valid until {$estimate.date_expires|dateformat:$date_format}</b><br>{/if}\r\n Contact us if you have any questions\r\n     </p>               \r\n','Dear {$client.firstname} {$client.lastname}, \r\n\r\n Attached is estimate you\'ve requested. You can view this estimate online following this link: {$estimate_link} \r\n\r\n {if $estimate.date_expires!=\'0000-00-00\'}Estimate is valid until {$estimate.date_expires|dateformat:$date_format}{/if}. \r\n \r\n Contact us if you have any questions',1,2,1,0),(74,'Domain:Automation Results','Domain','Admin',1,'Domain {$domain.name}:Automation Results','Action: {$domain_action}\r\nResult: {if $domain_result}Success{else}FAIL{/if}\r\n\r\n{if $domain_error}Error: {$domain_error}{/if}\r\n\r\n----------------------------------------------------\r\n# Client: {$client.firstname} {$client.lastname}\r\n# Order ID:  {$domain.order_id}\r\n# Order Number: {$domain.order_num}\r\n\r\n\r\n# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n# Registrar: {$domain.module}','Action: {$domain_action}\r\nResult: {if $domain_result}Success{else}FAIL{/if}\r\n\r\n{if $domain_error}Error: {$domain_error}{/if}\r\n\r\n----------------------------------------------------\r\n# Client: {$client.firstname} {$client.lastname}\r\n# Order ID:  {$domain.order_id}\r\n# Order Number: {$domain.order_num}\r\n\r\n\r\n# Domain Name: {$domain.name}\r\n# Period: {$domain.period} Year/s\r\n# Registrar: {$domain.module}',1,2,1,1),(75,'Account:Created:CakeMail','Product','Client',1,'New Email Marketing Account Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Your order has been accepted and your email marketing account has been activated!</p>\r\n\r\n<h2>Login Details</h2>\r\n<p>\r\n    <b>Username:</b> {$client.email}  <br>\r\n    <b>Password:</b> {$service.password}  <br>\r\n    <b>Login URL:</b> http://{$server.host} <br>\r\n</p>\r\n\r\n<h2>New Account Information</h2>\r\n<p>\r\n    Marketing Package: {$service.product_name} <br>\r\n    First Payment Amount: {$service.firstpayment|price:$currency} <br>\r\n    Total Amount: {$service.total|price:$currency} <br>\r\n    Billing Cycle: {$service.billingcycle} <br>\r\n    Next Due Date: {$service.next_due|dateformat:$date_format}\r\n</p>\r\n\r\n','Dear {$client.firstname} {$client.lastname}.\r\nYour order has been accepted and your email marketing account has been activated.\r\n\r\n<strong>New Account Information</strong>\r\nMarketing Package: {$service.product_name} \r\nFirst Payment Amount: {$service.firstpayment|price:$currency}\r\nTotal Amount: {$service.total|price:$currency}\r\nBilling Cycle: {$service.billingcycle}\r\nNext Due Date: {$service.next_due|dateformat:$date_format}\r\n\r\n<strong>Login Details</strong>\r\nUsername: {$client.email} \r\nPassword: {$service.password} \r\nLogin URL: http://{$server.host}',1,2,1,0),(76,'Ticket:By Admin','Support','Client',1,'Ticket: New','Subject: {$ticket.subject}\r\n {$ticket.body}\r\n\r\n\r\nTicket URL: {$ticket_url}','Subject: {$ticket.subject}\r\n {$ticket.body}\r\n\r\n\r\nTicket URL: {$ticket_url}',1,2,1,0),(77,'Ticket:Closed','Support','Admin',1,'Client closed ticket #{$ticket.ticket_number} ','----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nURL: {$ticket_admin_url}\r\nAvailable actions:\r\n- Re-Open ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&status=Open&make=setstatus\r\n- Delete Ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&make=deleteticket\r\n----------------------------------------------','----------------------------------------------\r\nTicket ID: {$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nURL: {$ticket_admin_url}\r\nAvailable actions:\r\n- Re-Open ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&status=Open&make=setstatus\r\n- Delete Ticket: {$admin_url}?cmd=tickets&action=menubutton&id={$ticket.ticket_number}&make=deleteticket\r\n----------------------------------------------',1,2,1,0),(78,'Ticket:Notes Change','Support','Admin',1,'Notes for ticket: #{$ticket.ticket_number}  updated','Notes has just been updated for ticket #{$ticket.ticket_number}\r\n\r\n{if $notes}\r\n{foreach from=$notes item=entry}\r\n----------------------------------------------------------------\r\n{$entry.date|dateformat:$date_format}\r\n{$entry.name}:  {$entry.note}\r\n{/foreach}\r\n----------------------------------------------------------------\r\n{/if}\r\n\r\n\r\nNew note:\r\n----------------------------------------------------------------\r\n{$note.date|dateformat:$date_format}\r\n{$note.name}:  {$note.msg}\r\n\r\nURL: {$ticket.url}','Notes has just been updated for ticket #{$ticket.ticket_number}\r\n\r\n{if $notes}\r\n{foreach from=$notes item=entry}\r\n----------------------------------------------------------------\r\n{$entry.date|dateformat:$date_format}\r\n{$entry.name}:  {$entry.note}\r\n{/foreach}\r\n----------------------------------------------------------------\r\n{/if}\r\n\r\n\r\nNew note:\r\n----------------------------------------------------------------\r\n{$note.date|dateformat:$date_format}\r\n{$note.name}:  {$note.msg}\r\n\r\nURL: {$ticket.url}',1,2,1,0),(80,'Clients:Add Contact','General','Admin',1,'Client #{$client.id} added new contact to his profile','<h3>Client #{$client.id} {$client.firstname} {$client.lastname} added new contact to his profile:</h3>\r\n\r\n<p>\r\n    <b> First Name</b> {$new.firstname}<br>\r\n    <b> Last Name</b> {$new.lastname}<br>\r\n    <b> Email Address</b> {$new.email}<br>\r\n    <b> Address 1</b> {$new.address1}<br>\r\n    <b> Address 2</b> {$new.address2}<br>\r\n    <b> City</b> {$new.city}<br>\r\n    <b> State/Region</b> {$new.state}<br>\r\n    <b> Zip Code</b> {$new.postcode}<br>\r\n    <b> Country</b> {$new.country}<br>\r\n    <b> Phone Number</b> {$new.phonenumber}<br>\r\n</p>','Client #{$client.id} {$client.firstname} {$client.lastname} added new contact to his profile:\r\n\r\n# First Name: {$new.firstname}\r\n# Last Name: {$new.lastname}\r\n# Email Address: {$new.email}\r\n# Address 1: {$new.address1}\r\n# Address 2: {$new.address2}\r\n# City: {$new.city}\r\n# State/Region: {$new.state}\r\n# Zip Code: {$new.postcode}\r\n# Country: {$new.country}\r\n# Phone Number: {$new.phonenumber}',1,2,1,0),(81,'Details:Admin Login Notification','General','Admin',1,'Login from {$ip}','<h2>Admin: \'{$login}\' logged into HostBill</h2>\r\n\r\n<p>\r\n    <b>Date:</b> {$date} <br>\r\n    <b>IP:</b> {$ip}  <br>\r\n    <b>Host:</b> {$host}   \r\n</p>\r\n','Admin: \'{$login}\' was logged into HostBill\r\n----------------------------------------------------\r\nDate: {$date} \r\nIP: {$ip} Host: {$host} \r\n----------------------------------------------------',1,2,1,1),(82,'Clients:Credit Balance Updated','General','Admin',1,'Client #{$client.id} {$client.firstname} {$client.lastname} Credit Balance Change','<h3>Client with ID {$client.id} credit balance was increased</h3>\r\n\r\n<p>\r\n    \r\n    <b>Previous balance:</b> {$credit.old_credit|price:$currency}<br>\r\n    <b>Current balance:</b> {$credit.new_credit|price:$currency}<br>\r\n</p>\r\n\r\n{if $credit.invoice_id}\r\n<p>\r\n    <b>Related invoice ID:</b> {$credit.invoice_id}<br>\r\n    <b>Related gateway:</b> {$credit.gateway}\r\n</p>\r\n{/if}','Client with ID {$client.id} credit balance was increased\r\n\r\n---------------------------------------------------------------\r\n# Previous balance: {$credit.old_credit|price:$currency}\r\n# Current balance: {$credit.new_credit|price:$currency}\r\n---------------------------------------------------------------\r\n{if $credit.invoice_id}\r\n# Related invoice ID: {$credit.invoice_id}\r\n# Related gateway: {$credit.gateway}\r\n---------------------------------------------------------------\r\n{/if}',1,2,1,1),(83,'Invoice:Refund','Invoice','Client',1,'Invoice #{$invoice.id}: Refund','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\n    Transaction <b>#{$transaction.trans_id}</b> has just been refunded, amount refunded <b>{$amount|price:$currency}</b>\r\n</p>\r\n\r\n','Dear {$client.firstname} {$client.lastname},\r\n\r\nTransaction #{$transaction.trans_id} has been refunded, amount refunded {$amount}\r\n',1,2,1,0),(84,'Mobile:Account:Created','Mobile','Client',1,'Your service is ready','Dear client, Your order has been accepted and your service {$service.product_name} is active','Dear client, Your order has been accepted and your service {$service.product_name} is active',1,2,1,0),(85,'Mobile:Domain:Registered','Mobile','Client',1,'Your domain has been registered','Dear client, Your domain: {$domain.name} has been registered','Dear client, Your domain: {$domain.name} has been registered',1,2,1,0),(86,'Mobile:Domain:Transfered','Mobile','Client',1,'Your domain has been transfered','Dear client, Your domain: {$domain.name} has been transfered','Dear client, Your domain: {$domain.name} has been transfered',1,2,1,0),(87,'Mobile:Domain:Reminder','Mobile','Client',1,'Your domain will soon expire','Dear client, Your domain: {$domain.name} will soon expire - make sure to renew!','Dear client, Your domain: {$domain.name} will soon expire - make sure to renew!',1,2,1,0),(88,'Mobile:Invoice:New','Mobile','Client',1,'New invoice','Dear client, New invoice has been added to your account with us, proceed to our client area for details','Dear client, New invoice has been added to your account with us, proceed to our client area for details',1,2,1,0),(89,'Mobile:Invoice:Reminder','Mobile','Client',1,'Due invoice','Dear client, Invoice in your account is due, to avoid downtimes pay it in time','Dear client, Invoice in your account is due, to avoid downtimes pay it in time',1,2,1,0),(90,'Mobile:Ticket:Reply','Mobile','Client',1,'Reply to ticket','Dear client, staff member replied to your support ticket -  {$ticket.subject}','Dear client, staff member replied to your support ticket -  {$ticket.subject}',1,2,1,0),(91,'Mobile:Ticket:New','Mobile','Admin',1,'New Support Ticket','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}',1,2,1,0),(92,'Mobile:Ticket:Escalated','Mobile','Admin',1,'Support Ticket Escalated','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}',1,2,1,0),(93,'Mobile:Ticket:Reply','Mobile','Admin',1,'Client repiled to ticket','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}',1,2,1,0),(94,'Mobile:Ticket:Note','Mobile','Admin',1,'New ticket note','#{$ticket.ticket_number} \r\n Note: {$note.msg}','#{$ticket.ticket_number} \r\n Note: {$note.msg}',1,2,1,0),(95,'Mobile:Failed Login','Mobile','Admin',1,'Adminarea failed login','Failed Login: Date: {$date}\r\nIP: {$ip}\r\nHost: {$host}\r\n\r\nLogin: {$login}','Failed Login: Date: {$date}\r\nIP: {$ip}\r\nHost: {$host}\r\n\r\nLogin: {$login}',1,2,1,0),(96,'Mobile:Order:New','Mobile','Admin',1,'New HostBill Order','Client: {$client.firstname} {$client.lastname}\r\nTotal(+tax): {$order.total|price:$currency}','Client: {$client.firstname} {$client.lastname}\r\nTotal(+tax): {$order.total|price:$currency}',1,2,1,0),(97,'Mobile:Transaction:New','Mobile','Admin',1,'New Payment from client','Transaction total: {$transaction.in|price:$currency}, Invoice: {$transaction.invoice_id}','Transaction total: {$transaction.in|price:$currency}, Invoice: {$transaction.invoice_id}',1,2,1,0),(98,'Mobile:AccountAutomation:Failed','Mobile','Admin',1,'Account automation failed','Action: {$account_action}, {if $account_error}Errors:{foreach from=$account_error item=errx} {$errx}    {/foreach}{/if}Account ID: {$service.id} ','Action: {$account_action}, {if $account_error}Errors:{foreach from=$account_error item=errx} {$errx}    {/foreach}{/if}Account ID: {$service.id} ',1,2,1,0),(99,'Mobile:DomainAutomation:Failed','Mobile','Admin',1,'Domain automation failed','Action:  {$domain_action} FAILED, {if $domain_error}Error: {$domain_error}{/if}, Domain Name: {$domain.name}','Action:  {$domain_action} FAILED, {if $domain_error}Error: {$domain_error}{/if}, Domain Name: {$domain.name}',1,2,1,0),(100,'Ticket:Assigned','Support','Admin',1,'You have been assigned to ticket: #{$ticket.ticket_number}','Staff member: {$admin.firstname} {$admin.lastname} assigned you to ticket #{$ticket.ticket_number}\r\n\r\n------------------------------------------\r\n\r\n{$ticket.body}\r\n\r\n------------------------------------------\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------','Staff member: {$admin.firstname} {$admin.lastname} assigned you to ticket #{$ticket.ticket_number}\r\n\r\n------------------------------------------\r\n\r\n{$ticket.body}\r\n\r\n------------------------------------------\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------',1,2,1,0),(101,'Ticket:Escalated','Support','Admin',1,'Ticket: #{$ticket.ticket_number} has been escalated','This ticket is now: {if $overdue}OVERDUE{else}ESCALATED{/if}\r\n\r\nTicket #{$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------','This ticket is now: {if $overdue}OVERDUE{else}ESCALATED{/if}\r\n\r\nTicket #{$ticket.ticket_number}\r\nSubject: {$ticket.subject}\r\nStatus: {$ticket.status}\r\nSubmitter: {$ticket.name}\r\nURL: {$ticket_admin_url}\r\n----------------------------------------------',1,2,1,0),(102,'Ticket:TimeLimit','Support','Client',1,'Your Ticket was not opened','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket, you have to wait {$time_left} second(s) before sending next request.','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket, you have to wait {$time_left} second(s) before sending next request.',1,2,1,0),(103,'LiveChat:Chat transcription','Support','Client',1,'Chat session transcription - {$chat.start_date|dateformat:$date_format}','Hello {$client.visitor_name},\r\n\r\nYou can find requested chat session transcription bellow.\r\n\r\n{foreach from=$chat.messages item=line}\r\n{if $line.type==\"Staff\"}\r\n\r\n#{$line.submitter_name}:\r\n{elseif $line.type==\"Client\"}\r\n\r\n#{$line.submitter_name}:\r\n{else}-{/if}{$line.message}\r\n{/foreach}','Hello {$client.visitor_name},\r\n\r\nYou can find requested chat session transcription bellow.\r\n\r\n{foreach from=$chat.messages item=line}\r\n{if $line.type==\"Staff\"}\r\n\r\n#{$line.submitter_name}:\r\n{elseif $line.type==\"Client\"}\r\n\r\n#{$line.submitter_name}:\r\n{else}-{/if}{$line.message}\r\n{/foreach}',1,2,1,0),(104,'Ticket:BounceClose','Support','Client',1,'Your ticket is closed','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket reply because related ticket has already been closed by staff member. If required, please open new ticket.','{$email_name},\r\n\r\nYour email to our support system could not be accepted as ticket reply because related ticket has already been closed by staff member. If required, please open new ticket.',1,2,1,0),(105,'Mobile:Ticket:Closed','Mobile','Admin',1,'Support Ticket Closed','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}','Subject: {$ticket.subject}\r\n Submitter: {$ticket.name} \r\n Dept: {$ticket.department}',1,2,1,0),(106,'Notes:Change','General','Admin',1,'Notes for {$type}: #{$id} updated','<h1>Notes for {$type}: #{$id} updated</h1>\r\n\r\n<p>\r\n    <b>URL:</b> {$url}\r\n</p>\r\n\r\n{if $note}\r\n    <h2>{if $note.action==\'add\'}New note:{else}Updated note:{/if}</h2>\r\n    <p>\r\n        <small>{$note.date|dateformat:$date_format}</small>\r\n        {$note.note}\r\n    </p>\r\n{/if}\r\n\r\n{if $notes}\r\n    {foreach from=$notes item=entry}\r\n    <p>\r\n        <small>{$entry.date|dateformat:$date_format}</small><br>\r\n        {$entry.note}\r\n    </p>\r\n    {/foreach}\r\n\r\n{/if}\r\n','Note has just been updated for {$type} #{$id}\r\n\r\n{if $notes}\r\n{foreach from=$notes item=entry}\r\n----------------------------------------------------------------\r\n{$entry.date|dateformat:$date_format}\r\n{$entry.note}\r\n{/foreach}\r\n----------------------------------------------------------------\r\n{/if}\r\n\r\n{if $note}\r\n{if $note.action==\'add\'}New note:{else}Updated note:{/if}\r\n----------------------------------------------------------------\r\n{$note.date|dateformat:$date_format}\r\n{$note.note}\r\n{/if}\r\nURL: {$url}',1,2,1,0),(107,'Invoice:Final','Invoice','Client',1,'Invoice #{$invoice.id} generated','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\n    This is notification that VAT invoice has been issued to your recent payment.<br/>\r\n    <br>\r\n    <b>Related Invoice:</b>  #{$invoice.id} <br>\r\n    <b>All invoices</b> <a href=\"{$clientarea_url}\">{$clientarea_url}</a>\r\n</p>','Dear {$client.firstname} {$client.lastname}, \r\n\r\nFinal invoice has been generated to your recent payment\r\n\r\nINVOICE  #{$invoice.id} \r\n\r\n\r\n\r\n\r\n\r\nINVOICE HISTORY: {$clientarea_url}\r\n',1,2,1,0),(108,'CreditNote:New','Invoice','Client',1,'New Credit Note Created','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>This is confirmation that new credit note has just been created</p>\r\n\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      <tr>\r\n                        <td>\r\n                          <h3>Credit Note #{$invoice.id}</h3></td>\r\n                        <td>\r\n                          <h3 class=\"align-right\">{$invoice.total|price:$currency}</h3></td>\r\n                      </tr>\r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                            {foreach from=$invoiceitems item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description} {if $item.qty}{$item.qty} x {/if}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$invoice.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n                    \r\n                    \r\n\r\n\r\n','Dear {$client.firstname} {$client.lastname}, \r\n\r\nCredit Note  #{$invoice.id} \r\nAMOUNT: {$invoice.total|price:$currency}\r\nGENERATED ON: {$invoice.date|dateformat:$date_format}.\r\n\r\nItems\r\n{foreach from=$invoiceitems item=item}\r\n {$item.description}  {if $item.qty}{$item.qty} x {/if}{$item.amount|price:$currency}\r\n{/foreach}\r\n\r\n',1,2,1,0),(109,'New Incoming Transaction','General','Admin',1,'Admin: New Incoming Transaction','<h1>New transaction added!</h1>\r\n\r\n<p>\r\n    <b>Customer:</b> {$client.firstname} {$client.lastname}<br>\r\n    <b>Gateway:</b> {$transaction.gateway}<br>\r\n    <b>Amount:</b> {$transaction.in|price:$currency}<br>\r\n    <b>Transaction id:</b> {$transaction.trans_id}<br>\r\n</p>\r\n\r\n\r\n{if $transaction.invoice_id}\r\n<p>\r\n    <b>Related invoice id:</b> {$transaction.invoice_id}<br>\r\n    <b>Related invoice status:</b> {$invoice.status}<br>\r\n    </p>\r\n{/if}','New transaction just came in!\r\n\r\nCustomer: {$client.firstname} {$client.lastname}\r\nGateway: {$transaction.gateway}\r\nAmount: {$transaction.in|price:$currency}\r\nTransaction id: {$transaction.trans_id}\r\n\r\n{if $transaction.invoice_id}\r\nRelated invoice id: {$transaction.invoice_id}\r\nRelated invoice status: {$invoice.status}\r\n{/if}',1,2,1,0),(110,'Admin:Order Ownership Changed','General','Admin',1,'Admin:Order Ownership Changed','\r\n<h1>Order ownership changed: {$order.id}</h1>\r\n\r\n<p>\r\n    Ownership for Order ID: {$order.id} has been  \r\n    {if $order.staff_member_id}changed to <b>{$order.admin_firstname} {$order.admin_lastname}</b>{else}<b>removed</b>{/if}\r\n</p>\r\n<h2>Order Info</h2>\r\n<p>\r\n    <b>Order ID:</b> {$order.id}<br>\r\n    <b>Order Number:</b> {$order.number}<br>\r\n    <b>Date Created:</b> {$order.date_created|dateformat:$date_format}<br>\r\n    <b>Invoice Number:</b> {$order.invoice_id}<br>\r\n    <b>Payment Method:</b> {$order.module}<br>\r\n    {if $order.fraudscore}<b>FraudModule risk score:</b> {$order.fraudscore}<br>{/if}\r\n    <b>IP:</b> {$ip_addr}<br>\r\n    <b>Host:</b> {$host_addr}<br>\r\n\r\n</p>\r\n\r\n\r\n<h2>Order Items</h2>\r\n{if $order_details}\r\n<table class=\"invoice-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                      \r\n                      <tr>\r\n                        <td colspan=\"2\">\r\n                          <table class=\"invoice-table\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n                            <tr>\r\n                              <th>\r\n                                <p>Description</p>\r\n                              </th>\r\n                              <th>\r\n                                <p class=\"align-right\">Amount</p>\r\n                              </th>\r\n                            </tr>\r\n                           {foreach from=$order_details item=item}\r\n                            <tr>\r\n                              <td width=\"80%\">{$item.description}</td>\r\n                              <td class=\"align-right\" width=\"20%\">{$item.amount|price:$currency}</td>\r\n                            </tr>\r\n                            {/foreach}\r\n                            <tr>\r\n                              <td width=\"80%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p class=\"total-cell_label\">Total (+tax):</p>\r\n                              </td>\r\n                              <td width=\"20%\" class=\"total-cell\" valign=\"middle\">\r\n                                <p>{$order.total|price:$currency}</p>\r\n                              </td>\r\n                            </tr>\r\n                          </table>\r\n                        </td>\r\n                      </tr>\r\n                    </table>\r\n{else}\r\n    <p>No items to list.</p>\r\n{/if}\r\n   \r\n   \r\n<h2>Client Info</h2>\r\n<p>\r\n    <b>ID:</b> {$client.id} <br>\r\n    <b>Name:</b> {$client.firstname} {$client.lastname} <br>\r\n    <b>Email:</b> {$client.email} <br>\r\n    <b>Company:</b> {$client.companyname} <br>\r\n    <b>Address 1:</b> {$client.address1} <br>\r\n    <b>Address 2:</b> {$client.address2} <br>\r\n    <b>City:</b> {$client.city} <br>\r\n    <b>State/Region:</b> {$client.state} <br>\r\n    <b>Zip Code:</b> {$client.postcode} <br>\r\n    <b>Country:</b> {$client.country} <br>\r\n    <b>Phone Number:</b> {$client.phonenumber} \r\n</p>\r\n','Ownership for Order ID: {$order.id} has been  {if $order.staff_member_id}changed to {$order.admin_firstname} {$order.admin_lastname}{else}removed{/if}\r\n\r\n---------------------------------------------------------------\r\nOrder Info\r\n---------------------------------------------------------------\r\n# Order ID: {$order.id}\r\n# Order Number: {$order.number}\r\n# Date Created: {$order.date_created|dateformat:$date_format}\r\n# Invoice Number: {$order.invoice_id}\r\n# Payment Method: {$order.module}\r\n{if $order.fraudscore}# FraudModule risk score: {$order.fraudscore}{/if}\r\n\r\n---------------------------------------------------------------\r\nClient Info\r\n---------------------------------------------------------------\r\n# ID: {$client.id}\r\n# Name: {$client.firstname} {$client.lastname}\r\n# Email: {$client.email}\r\n# Company: {$client.companyname}\r\n# Address 1: {$client.address1}\r\n# Address 2: {$client.address2}\r\n# City: {$client.city}\r\n# State/Region: {$client.state}\r\n# Zip Code: {$client.postcode}\r\n# Country: {$client.country}\r\n# Phone Number: {$client.phonenumber}\r\n\r\n---------------------------------------------------------------\r\nOrder Items\r\n---------------------------------------------------------------\r\n{if $order_details}\r\n{foreach from=$order_details item=item}\r\n #  {$item.amount|price:$currency} - {$item.description}\r\n{/foreach}\r\n\r\nTotal(+tax): {$order.total|price:$currency}\r\n{else}\r\nNo items to list.\r\n{/if}\r\n\r\n\r\n---------------------------------------------------------------\r\nIP: {$ip_addr}\r\nHost: {$host_addr}',1,2,1,0),(111,'Admin:Assigned Order Ownership','General','Admin',1,'Admin:Assigned Order Ownership','You were assigned to Order ID: {$order.id}\r\n\r\n---------------------------------------------------------------\r\nOrder Info\r\n---------------------------------------------------------------\r\n# Order ID: {$order.id}\r\n# Order Number: {$order.number}\r\n# Date Created: {$order.date_created|dateformat:$date_format}\r\n# Invoice Number: {$order.invoice_id}\r\n# Payment Method: {$order.module}\r\n{if $order.fraudscore}# FraudModule risk score: {$order.fraudscore}{/if}\r\n\r\n---------------------------------------------------------------\r\nClient Info\r\n---------------------------------------------------------------\r\n# ID: {$client.id}\r\n# Name: {$client.firstname} {$client.lastname}\r\n# Email: {$client.email}\r\n# Company: {$client.companyname}\r\n# Address 1: {$client.address1}\r\n# Address 2: {$client.address2}\r\n# City: {$client.city}\r\n# State/Region: {$client.state}\r\n# Zip Code: {$client.postcode}\r\n# Country: {$client.country}\r\n# Phone Number: {$client.phonenumber}\r\n\r\n---------------------------------------------------------------\r\nOrder Items\r\n---------------------------------------------------------------\r\n{if $order_details}\r\n{foreach from=$order_details item=item}\r\n #  {$item.amount|price:$currency} - {$item.description}\r\n{/foreach}\r\n\r\nTotal(+tax): {$order.total|price:$currency}\r\n{else}\r\nNo items to list.\r\n{/if}\r\n\r\n\r\n---------------------------------------------------------------\r\nIP: {$ip_addr}\r\nHost: {$host_addr}','You were assigned to Order ID: {$order.id}\r\n\r\n---------------------------------------------------------------\r\nOrder Info\r\n---------------------------------------------------------------\r\n# Order ID: {$order.id}\r\n# Order Number: {$order.number}\r\n# Date Created: {$order.date_created|dateformat:$date_format}\r\n# Invoice Number: {$order.invoice_id}\r\n# Payment Method: {$order.module}\r\n{if $order.fraudscore}# FraudModule risk score: {$order.fraudscore}{/if}\r\n\r\n---------------------------------------------------------------\r\nClient Info\r\n---------------------------------------------------------------\r\n# ID: {$client.id}\r\n# Name: {$client.firstname} {$client.lastname}\r\n# Email: {$client.email}\r\n# Company: {$client.companyname}\r\n# Address 1: {$client.address1}\r\n# Address 2: {$client.address2}\r\n# City: {$client.city}\r\n# State/Region: {$client.state}\r\n# Zip Code: {$client.postcode}\r\n# Country: {$client.country}\r\n# Phone Number: {$client.phonenumber}\r\n\r\n---------------------------------------------------------------\r\nOrder Items\r\n---------------------------------------------------------------\r\n{if $order_details}\r\n{foreach from=$order_details item=item}\r\n #  {$item.amount|price:$currency} - {$item.description}\r\n{/foreach}\r\n\r\nTotal(+tax): {$order.total|price:$currency}\r\n{else}\r\nNo items to list.\r\n{/if}\r\n\r\n\r\n---------------------------------------------------------------\r\nIP: {$ip_addr}\r\nHost: {$host_addr}',1,2,1,0),(112,'Details:ACHCard:ChargeFailed','General','Client',1,'Account/eCheck Charge Failed','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>\r\n    This is notification that <b>we were <span style=\"color:red\">unable</span> to automatically charge your bank account ({$details.account}).</b>\r\n</p>\r\n<p>\r\n    Please verify bank details in our client section.\r\n</p>','Dear {$details.firstname} {$details.lastname},\r\n\r\n\r\nThis is notification that we were unable to automatically charge your bank account ({$details.account}).\r\nPlease verify bank details in our client section.',1,2,1,0),(113,'Order:FraudOrder','General','Client',1,'Your recent order #{$order.number} marked as Fraud','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>Unfortunatelly our system has automatically classified your recent order as <b style=\"color:red\">Fraudulent</b></p>\r\n\r\n<p>Please contact us at your earliest convenience to resolve this case, please submit order number below for reference:<br>\r\n<b>ORDER NUMBER:</b> {$order.number}\r\n</p>','DEAR {$client.firstname} {$client.lastname},\r\n\r\nUnfortunatelly your recent order was automatically marked as Fraud.\r\nPlease contact us to resolve this case.\r\n\r\nORDER NUMBER: {$order.number}\r\n\r\n\r\n ',1,2,1,0),(114,'Ticket:BouncePublic','Support','Client',1,'Your reply was not accepted','Your email to our support system could not be accepted as reply, because ticket you\'re sending it to is public / announcement ticket.\r\nTo reply please open new support ticket in our client portal','Your email to our support system could not be accepted as reply, because ticket you\'re sending it to is public / announcement ticket.\r\nTo reply please open new support ticket in our client portal',1,2,1,0),(115,'Account:Cancellation Request','General','Client',1,'Cancellation Request','<h1>Dear {$client.firstname} {$client.lastname},</h1>\r\n\r\n<p>This email is a confirmation that we\'ve received your cancelation request</p>\r\n<p>If it was submitted by accident, make sure to contact with us as soon as possible to prevent service interruption</p>\r\n\r\n<p>\r\n    <b>Account ID:</b> {$details.acc_id}<br>\r\n    <b>Cancelation Type:</b> {$details.type}<br>\r\n    <b>Reason:</b> {$details.reason}\r\n</p>','Dear: {$client.firstname} {$client.lastname} \r\n\r\n# We have received following cancelation request: \r\n\r\n# Account ID: {$details.acc_id}\r\n# Type: {$details.type}\r\n# Reason: {$details.reason}',1,2,1,0),(116,'OnApp: Metered Billing Admin Report','Custom','Client',1,'OnApp Metered Billing Report for {$product.name}',' {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{  border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>HostBill Metered billing usage report {$date_from|dateformat:$date_format} - {$date_to|dateformat:$date_format}</h2>   <b>Package: {$product.name}</b>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">   <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report}       <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report item=row key=d}               <tr>                    <td colspan=\"{$colspan}\" class=\"dateseparate\">{$d|dateformat:$date_format}:</td>                </tr>               {foreach from=$row item=acc key=accid}              <tr>                    <td>Account #<a href=\"{$admin_url}/index.php?cmd=accounts&action=edit&id={$accid}\">{$accid}</a><br>Username: {$accounts[$accid].username}</td>                    {foreach from=$variables item=variab key=vr}                    <td>Avg: {$acc[$vr].use} {$variab.unit_name}<br>Price: {$acc[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$acc.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}              {/foreach}              {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>                     {/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured in related package (<em>#{$product.id} - {$product.name}</em>) metered pricing table. Usage is automatically synced with OnApp every hour. Table above represent  daily average usage of each measured variable across all accounts, since last generated admin report ({$date_from|dateformat:$date_format}). To get detailed hourly usage visit account details section  in HostBill adminarea and proceed to \"Metered Billing\" tab.  </div>  ','',1,1,0,0),(117,'OnApp: Metered Billing Client Report','Custom','Client',1,'Usage report {$product.name}','  {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{     border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>Usage report for {$product.name}, generated at {$date_created|dateformat:$date_format}</h2>   <div class=\"info\">This is detailed usage rerport to recently generated invoice for service: {$product.name}</div>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">    <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report.usage}         <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report.usage item=row key=d}                                 <tr>                    <td>{$d|dateformat:$date_format}</td>                   {foreach from=$variables item=variab key=vr}                    <td>Avg: {$row[$vr].use} {$variab.unit_name}<br>Price: {$row[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$row.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}      <thead>             <th >Total</th>             {foreach from=$variables item=variab key=vr}            <th>{$summary[$variab.id].charge|price:$currency}</th>          {/foreach}          <th>{$metered_total|price:$currency}</th>       </thead>                {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>{/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured were measured hourly throughout entire billing period. The table above represent daily average usage of each measured variable. Invoice may contain additional fixed recurring fee to coverage operational/non-measurable costs.  </div>  ','',1,1,0,0),(118,'OnApp: Metered Billing Admin Report','Custom','Client',1,'OnApp Metered Billing Report for {$product.name}',' {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{    border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>HostBill Metered billing usage report {$date_from|dateformat:$date_format} - {$date_to|dateformat:$date_format}</h2>   <b>Package: {$product.name}</b>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">   <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report}       <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report item=row key=d}               <tr>                    <td colspan=\"{$colspan}\" class=\"dateseparate\">{$d|dateformat:$date_format}:</td>                </tr>               {foreach from=$row item=acc key=accid}              <tr>                    <td>Account #<a href=\"{$admin_url}/index.php?cmd=accounts&action=edit&id={$accid}\">{$accid}</a><br>Username: {$accounts[$accid].username}</td>                    {foreach from=$variables item=variab key=vr}                    <td>Avg: {$acc[$vr].use} {$variab.unit_name}<br>Price: {$acc[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$acc.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}              {/foreach}              {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>                     {/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured in related package (<em>#{$product.id} - {$product.name}</em>) metered pricing table. Usage is automatically synced with OnApp every hour. Table above represent  daily average usage of each measured variable across all accounts, since last generated admin report ({$date_from|dateformat:$date_format}). To get detailed hourly usage visit account details section  in HostBill adminarea and proceed to \"Metered Billing\" tab.  </div>  ','',1,1,0,0),(119,'OnApp: Metered Billing Client Report','Custom','Client',1,'Usage report {$product.name}','  {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{     border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>Usage report for {$product.name}, generated at {$date_created|dateformat:$date_format}</h2>   <div class=\"info\">This is detailed usage rerport to recently generated invoice for service: {$product.name}</div>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">    <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report.usage}         <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report.usage item=row key=d}                                 <tr>                    <td>{$d|dateformat:$date_format}</td>                   {foreach from=$variables item=variab key=vr}                    <td>Avg: {$row[$vr].use} {$variab.unit_name}<br>Price: {$row[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$row.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}      <thead>             <th >Total</th>             {foreach from=$variables item=variab key=vr}            <th>{$summary[$variab.id].charge|price:$currency}</th>          {/foreach}          <th>{$metered_total|price:$currency}</th>       </thead>                {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>{/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured were measured hourly throughout entire billing period. The table above represent daily average usage of each measured variable. Invoice may contain additional fixed recurring fee to coverage operational/non-measurable costs.  </div>  ','',1,1,0,0),(120,'OnApp: Metered Billing Admin Report','Custom','Client',1,'OnApp Metered Billing Report for {$product.name}',' {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{    border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>HostBill Metered billing usage report {$date_from|dateformat:$date_format} - {$date_to|dateformat:$date_format}</h2>   <b>Package: {$product.name}</b>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">   <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report}       <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report item=row key=d}               <tr>                    <td colspan=\"{$colspan}\" class=\"dateseparate\">{$d|dateformat:$date_format}:</td>                </tr>               {foreach from=$row item=acc key=accid}              <tr>                    <td>Account #<a href=\"{$admin_url}/index.php?cmd=accounts&action=edit&id={$accid}\">{$accid}</a><br>Username: {$accounts[$accid].username}</td>                    {foreach from=$variables item=variab key=vr}                    <td>Avg: {$acc[$vr].use} {$variab.unit_name}<br>Price: {$acc[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$acc.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}              {/foreach}              {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>                     {/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured in related package (<em>#{$product.id} - {$product.name}</em>) metered pricing table. Usage is automatically synced with OnApp every hour. Table above represent  daily average usage of each measured variable across all accounts, since last generated admin report ({$date_from|dateformat:$date_format}). To get detailed hourly usage visit account details section  in HostBill adminarea and proceed to \"Metered Billing\" tab.  </div>  ','',1,1,0,0),(121,'OnApp: Metered Billing Client Report','Custom','Client',1,'Usage report {$product.name}','  {literal}  <style type=\"text/css\">  .usetable td,  .usetable th{     border:1px solid #C3C3C3;   padding:5px;    text-align:left;  }  .usetable, .info {  font-size:12px;  }  .info {  padding-top:10px;  width:500px;  text-align:justify;  }   .usetable th {   background: #E9E9E9;   }   .dateseparate {     background:#F4F4F4;  }  </style>  {/literal}   <h2>Usage report for {$product.name}, generated at {$date_created|dateformat:$date_format}</h2>   <div class=\"info\">This is detailed usage rerport to recently generated invoice for service: {$product.name}</div>   <br/>    <table  cellspacing=\"0\" cellpadding=\"3\" style=\"border-collapse: collapse;\" class=\"usetable\">    <thead>         <th width=\"150\"></th>          {foreach from=$variables item=variab}             <th width=\"120\">{$variab.name}</th>           {/foreach}       <th>Daily cost</th>     </thead>        <tbody>         {if !$report.usage}         <tr><td colspan=\"{$colspan}\">No data found</td></td>      {else}      {foreach from=$report.usage item=row key=d}                                 <tr>                    <td>{$d|dateformat:$date_format}</td>                   {foreach from=$variables item=variab key=vr}                    <td>Avg: {$row[$vr].use} {$variab.unit_name}<br>Price: {$row[$vr].price|price:$currency}</td>                 {/foreach}                    <td>{$row.dailycharge|price:$currency}</td>                                     </tr>               {/foreach}      <thead>             <th >Total</th>             {foreach from=$variables item=variab key=vr}            <th>{$summary[$variab.id].charge|price:$currency}</th>          {/foreach}          <th>{$metered_total|price:$currency}</th>       </thead>                {/if}   </tbody>   </table>  <br/>   <div class=\"info\">  <b>Legend</b><br/>    {foreach from=$variables item=vr}<b><em>{$vr.name}</em></b> - {$vr.description} <br/>{/foreach}  </div>   <div class=\"info\">  <b>How to read this report?</b><br/>  Variables listed in columns are configured were measured hourly throughout entire billing period. The table above represent daily average usage of each measured variable. Invoice may contain additional fixed recurring fee to coverage operational/non-measurable costs.  </div>  ','',1,1,0,0),(122,'Clients:Password Forgotten','General','Admin',1,'Client #{$client.id} requested password reminder','<h3>Client #{$client.id} {$client.firstname} {$client.lastname} Just requested his password reminder</h3>\r\n\r\n IP: {$ip_addr} \r\n Host: {$host_addr}','Client #{$client.id} {$client.firstname} {$client.lastname} Client #{$client.id} {$client.firstname} {$client.lastname} Just requested his password reminder \r\n\r\n IP: {$ip_addr} \r\n Host: {$host_addr}',1,2,1,0);
  52. /*!40000 ALTER TABLE `hb_email_templates` ENABLE KEYS */;
  53. UNLOCK TABLES;
  54. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  55.  
  56. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  57. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  58. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  59. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  60. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  61. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  62. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  63.  
  64. -- Dump completed on 2017-03-21  9:57:28
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!