Untitled

INSERT INTO `emails` (`id`, `title`, `subject`, `body`, `sms`) VALUES(1, 'Billing-Due', '$domain - You have an invoice due today.', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br />This e-mail is to inform you that your bill is due today.<strong><br /><br />Bill Invoice #$BillId<br /></strong>Your total bill amount is: $currency$BillGross<br />Your bill status is: $BillStatus<strong><br /><br />Invoice Description:</strong><br />$BillDetails</p>\r\n<p>You can pay your bill online by logging into your account at: $url</p>\r\n<p><strong>Payment Instructions:</strong></p>\r\n<ol>\r\n<li>Login to the control panel at $url</li>\r\n<li>Locate your bill invoice #$BillId from the Billing interface</li>\r\n<li>Select a Payment method on the bill</li>\r\n<li>Complete payment on the invoice</li>\r\n</ol>\r\n<p>Note: This e-mail will serve as an official invoice for this payment.</p>\r\n<hr />\r\n<p>If you have any questions please contact us.</p>\r\n<p>Thank you<br /> - $domain</p>', ''),(2, 'User-Suspended', '$domain - Your account has been suspended.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This e-mail is to inform you that your account has been suspended.</p>\n<p>Please contact us if you would like your account restored.</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(3, 'Server Information.', '$domain - Your Account Information', '<p>Hello $UserFirstName</p>\n<p>This e-mail contains important account information.</p>\n<p>Please review your account details below:</p>\n<hr />\n<p>User Name: $UserCPName<br />User Password: $UserPassword<br />Control Panel: $url</p>\n<p>$UserGameInfo<br />$UserVoiceInfo</p>\n<hr />\n<p>If you have any questions about your account information please contact us.<br /><br />Thank you<br />- $domain</p>', ''),(4, 'Billing-Pre', '$domain - Your invoice is due in $BillDaysTill days.', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br />This e-mail is to inform you that your bill is due in $BillDaysTill  days.<strong><br /><br />Bill Invoice #$BillId<br /></strong>Your total bill amount is: $currency$BillGross<br />Your bill status is: $BillStatus<strong><br /><br />Invoice Description:</strong><br />$BillDetails</p>\r\n<p>You can pay your bill online by logging into your account at: $url</p>\r\n<p><strong>Payment Instructions:</strong></p>\r\n<ol>\r\n<li>Login to the control panel at $url</li>\r\n<li>Locate your bill invoice #$BillId from the Billing interface</li>\r\n<li>Select a Payment method on the bill</li>\r\n<li>Complete payment on the invoice</li>\r\n</ol>\r\n<p>Note: This e-mail will serve as an official invoice for this payment.</p>\r\n<hr />\r\n<p>Thank you<br /> - $domain</p>', ''),(5, 'Billing-Past', '$domain - You have a past due invoice.', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br />This e-mail is to inform you that your bill is due $BillDaysTill  days ago.<strong><br /><br />Bill Invoice #$BillId<br /></strong>Your total bill amount is: $currency$BillGross<br />Your bill status is: $BillStatus<strong><br /><br />Invoice Description:</strong><br />$BillDetails</p>\r\n<p>You can pay your bill online by logging into your account at: $url</p>\r\n<p><strong>Payment Instructions:</strong></p>\r\n<ol>\r\n<li>Login to the control panel at $url</li>\r\n<li>Locate your bill invoice #$BillId from the Billing interface</li>\r\n<li>Select a Payment method on the bill</li>\r\n<li>Complete payment on the invoice</li>\r\n</ol>\r\n<p>Note: This e-mail will serve as an official invoice for this payment.</p>\r\n<hr />\r\n<p> </p>\r\n<p>If you have any questions please contact us.</p>\r\n<p>Thank you<br /> - $domain</p>', ''),(6, 'Tech-NewTicket', '[Ticket: $Var3] $subject', '<p>Hello $UserFirstName</p>\n<p><strong><br />Your support ticket has been received!</strong></p>\n<p>You can view the ticket at any time  @ $url/system/tt.php?mode=edit&tid=$Var3</p>\n<p>Please allow up to 24 hours Monday-Friday for a reply.</p>\n<p> </p>\n<hr />\n<p>Ticket ID: $Var3<br />Category: $Var1<br />Subject: $subject<br />Status: $status</p>\n<p> </p>', ''),(7, 'Manager-NewUser', '$domain - A new user has been added, $UserCPName', '<p>Hello $UserFirstName</p>\r\n<p>This is the Automated Notification System at $domain .</p>\r\n<p><strong>The following user has been added: </strong>$UserCPName</p>\r\n<p>Please login to: $url  To view the changes.</p>\r\n<hr />\r\n<p>Thank you<br /> - $domain</p>', ''),(8, 'Tech-ReplyTicket', '[Ticket: $Var3] $subject', '<p>$Var2</p>\n<p> </p>\n<hr />\n<p>Ticket ID: #$Var3<br /> Subject: $subject<br />Status: $status<br /> Ticket URL: <a href="$url/system/tt.php?mode=edit&tid=$Var3" target="_blank">$url/system/tt.php?mode=edit&tid=$Var3</a></p>\n<p> </p>', ''),(9, 'Tech-NoBranding', '$domain - Your servers branding is missing.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This message was sent to notify you that the server has automatically been disabled. Please add the proper branding to your servers hostname.</p>\n<p>You can login at: $url<br />Username: $UserCPName</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(10, 'Subuser-create', '$domain - Your Account Information', '<p>Hello $UserFirstName</p>\n<p>This e-mail contains important account information.</p>\n<p>Please review your account details below:</p>\n<hr />\n<p>User Name: $UserCPName<br />User Password: $UserPassword<br />Control Panel: $url</p>\n<p> </p>\n<hr />\n<p>If you have any questions about your account information please contact us.<br /><br />Thank you<br />- $domain</p>', ''),(11, 'User-ReplyTicket', '[Ticket: $Var3] $subject', '<p><strong>Your ticket reply was received.</strong></p>\n<p>Please allow up to 24 hours Monday-Friday for a reply.</p>\n<p> </p>\n<p>\n<hr style="width: 100%;" />\n<br />$Var2</p>\n<hr />\n<p>Ticket ID: $Var3<br />Category: $Var1<br />Subject: $subject<br /> Status: $status<br /> Ticket URL: <span style="color: #888888;"><a href="$url/system/tt.php?mode=edit&tid=$Var3" target="_blank">$url/system/tt.php?mode=edit&tid=$Var3</a></span></p>\n<p> </p>', ''),(12, 'Tech-Slots-Exceeded', '$domain - You have exceeded your maximum player limit.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This message was sent to notify you that the server has automatically been disabled.</p>\n<p>You can login at: $url<br />Username: $UserCPName</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(13, 'Tech-ServerDown', '$domain - A server is down,  $UserCPName $Var1', '<p>Hello $UserFirstName</p>\r\n<p>This is the Automated Notification System at $domain .</p>\r\n<p>The following user has a crashed server: $UserCPName</p>\r\n<p><strong>This server is located at:</strong> $Var1</p>\r\n<p> </p>\r\n<p> </p>\r\n<hr />\r\n<p>Thank you<br /> - $domain</p>\r\n<p> </p>', 'Message From $domain  \r\n\r\nThe following user has a crashed server:\r\n$UserCPName\r\n\r\nThis server is located at:\r\n$Var1\r\n\r\nThank you.'),(14, 'Tech-Non-private-private', '$domain - $Var3 is not private', '<p>Hello $UserFirstName</p>\r\n<p>This is the Automated Notification System at $domain .</p>\r\n<p>The following user has a non-private server: $Var1</p>\r\n<p>This server is located at: $Var2</p>\r\n<p>The Automated Server Status System reports that the server has a status of non-private but is marked in the system as a private server.</p>\r\n<p>Please manually correct then restart the server.  You can login at:</p>\r\n<p> </p>\r\n<p> </p>\r\n<hr />\r\n<p>Thank you<br /> - $domain</p>\r\n<p> </p>', ''),(15, 'Lost-Password', '$domain - Your password has been reset.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This email contains important account information from the Automated Notification System at $domain.</p>\n<p>Please do not send this e-mail to anyone you do not want to have access to your services.</p>\n<p><strong>Your new  password is:</strong> $Var1<br /></p>\n<hr />\n<p>If you have any questions or problems please contact us.</p>\n<p>Thank you<br />- $domain</p>', ''),(16, 'Tech-Time-Exceeded', '$domain - Your game servers time has expired!', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This message was sent to notify you that the server has automatically been disabled.</p>\n<p>You can login at: $url<br />Username: $UserCPName</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(17, 'Billing-Add', '$domain - A bill has been created', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br />This e-mail is to inform you that a new bill has been added to your account<br /><strong><br />Bill Invoice #$BillId<br /></strong>Your total bill amount is: $currency$BillGross<br />Your bill status is: $BillStatus<strong><br /><br />Invoice Description:</strong><br />$BillDetails</p>\r\n<p>You can pay your bill online by logging into your account at: $url</p>\r\n<p><strong>Payment Instructions:</strong></p>\r\n<ol>\r\n<li>Login to the control panel at $url</li>\r\n<li>Locate your bill invoice #$BillId from the Billing interface</li>\r\n<li>Select a Payment method on the bill</li>\r\n<li>Complete payment on the invoice</li>\r\n</ol>\r\n<p>Note: This e-mail will serve as an official invoice for this payment.</p>\r\n<hr />\r\n<p>If you have any questions please contact us.</p>\r\n<p>Thank you<br /> - $domain</p>', ''),(18, 'Lost-PasswordReset', '$domain - Reset your lost password.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>A user from $Var2 has requested that your password be reset.</p>\n<p><strong>Click the following URL to reset your password:</strong> $Var1</p>\n<hr />\n<p>If you have any questions or problems please contact us.</p>\n<p>Thank you<br />- $domain</p>', ''),(19, 'User-Unsuspended', '$domain - Your account has been un-suspended.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This e-mail is to inform you that your account has been un-suspended.</p>\n<p>Please contact us if you would like your account restored.</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(20, 'Service-Suspended', '$domain - Service #$Var1 has been suspended', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This e-mail is to inform you that a service #$Var1 has been suspended.</p>\n<p>$Var1</p>\n<p>$BillId</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(21, 'Service-Unsuspended', '$domain - Service #$Var1 has been un-suspended', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This e-mail is to inform you that a service has been un-suspended.</p>\n<p>Please contact us if you would like your account restored.</p>\n<p>$Var1</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(22, 'ContactUs', '$domain - Contact form submission', '<p>You have been contacted from your control panel.</p>\n<p><strong>Name</strong>: $cname</p>\n<p><strong>E-mail</strong>: $cemail</p>\n<p><strong>Notes</strong>: $cnotes</p>', ''),(23, 'Service-Moved', '$domain - Service #$Var2 has been moved', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This e-mail is to inform you that a service #$Var2 has been moved.</p>\n<p>Please contact us if you have any problems.</p>\n<p><strong>New address</strong>: $Var1</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>\n<p> </p>', ''),(24, 'Payment-Failed', '$domain - Payment Failed  $Var1 #$Var2', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br /><strong><br /><br />Payment Failed</strong></p>\n<p>$Var1: #$Var2<strong><br /></strong>Payment amount: $currency$Payment<br /><strong><br /><br /></strong></p>\n<p>You can view your bill online by logging into your account at: $url</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>', ''),(25, 'Payment-Pending', '$domain - Payment Pending  $Var1 #$Var2', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br /><strong><br /><br />Payment Pending</strong></p>\n<p>$Var1: #$Var2<strong><br /></strong>Payment amount: $currency$Payment<br /><strong><br /><br /></strong></p>\n<p>You can view your bill online by logging into your account at: $url</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>', ''),(26, 'Payment-Completed', '$domain - Payment Completed $Var1 #$Var2', '<p>Hello $UserFirstName<br /><br />This is the Automated Notification System at $domain .<br /><strong><br /><br />Payment Received</strong></p>\n<p>$Var1: #$Var2<strong><br /></strong>Payment amount: $currency$Payment<br />Bill status: $Status<strong><br /><br /></strong></p>\n<p>You can view your bill online by logging into your account at: $url</p>\n<p> </p>\n<hr />\n<p>Thank you<br /> - $domain</p>', ''),(27, 'Payment-Completed-Admin', '$domain - Payment Completed  $Var1 #$Var2', '<p>You have received a payment!</p>\n<p>$Var1 #$Var2</p>\n<p> </p>\n<p> </p>\n<p>$Var3</p>', ''),(28, 'Payment-Failed-Admin', '$domain - Payment Failed  $Var1 #$Var2', '<p>A Payment Has Failed!</p>\n<p>$Var1 #$Var2</p>\n<p> </p>\n<p> </p>\n<p>$Var3</p>', ''),(29, 'Payment-Pending-Admin', '$domain - Payment Pending  $Var1 #$Var2', '<p>You have a pending payment!</p>\n<p>MOST Pending payments will need to be manually validated and updated</p>\n<p>Click the following link to validate, once logged into the panel:</p>\n<p>$url/billing/?billStatus=Completed&bidd=$Var2&idd=$cid&update=status</p>\n<p> </p>\n<p>$Var1 #$Var2</p>\n<p>$Var3</p>', ''),(30, 'Payment-Pending-Queue', '$domain - Queue Payment Pending  $Var1 #$Var2', '<p>You have a pending payment!</p>\n<p>MOST Pending payments will need to be manually validated and updated</p>\n<p>Click the following link to validate, once logged into the panel:</p>\n<p>$url/manage/orders.php?mode=run&qid=$Var2&idd=$cid&update=status</p>\n<p> </p>\n<p>$Var1 #$Var2</p>\n<p>$Var3</p>', ''),(31, 'Tech-MachineDown', '$domain - A machine is down,  $UserCPName $Var1', '<p>Hello $UserFirstName</p>\r\n<p>This is the Automated Notification System at $domain .</p>\r\n<p>The following machine has crashed:</strong> $Var1</p>\r\n<p> </p>\r\n<p> </p>\r\n<hr />\r\n<p>Thank you<br /> - $domain</p>\r\n<p> </p>', 'Message From $domain  \r\n\r\nThe machine has crashed:\r\n$Var1\r\n\r\nThank you.'),(32, 'Tech-OverQuota', '$domain - You have exceeded your maximum disk quota.', '<p>Hello $UserFirstName</p>\n<p>This is the Automated Notification System at $domain .</p>\n<p>This message was sent to notify you that you are over your file disk quota on the following server:</p>\n<p>#$Var1</p>\n<p>You can login at: $url<br />Username: $UserCPName</p>\n<p> </p>\n<p> </p>\n<hr />\n<p>Thank you<br />- $domain</p>\n<p> </p>', '');