Файл: whmcs/install/sql/upgrade530.sql
Строк: 311
UPDATE `tblemailtemplates` SET `message` = '<p> Dear {$client_name},
</p> <p> This is a billing notice that your invoice no.
{$invoice_num} which was generated on {$invoice_date_created} is now
overdue. </p> <p> Your payment method is:
{$invoice_payment_method} </p> <p> Invoice:
{$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due
Date: {$invoice_date_due} </p> <p> You can login to your client
area to view and pay the invoice at {$invoice_link} </p> <p>
{$signature} </p>' WHERE `type` = 'invoice' AND `name` = 'First
Invoice Overdue Notice' AND `message` = '<p> Dear {$client_name},
</p> <p> This is a billing notice that your invoice no.
{$invoice_num} which was generated on {$invoice_date_created} is now
overdue. </p> <p> Your payment method is:
{$invoice_payment_method} </p> <p> Invoice:
{$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due
Date: {$invoice_date_due} </p> <p> You can login to your client
area to view and pay the invoice at {$invoice_link} </p> <p>
Your login details are as follows: </p> <p> Email Address:
{$client_email}<br /> Password: {$client_password} </p>
<p> {$signature} </p>';
UPDATE `tblemailtemplates` SET
`message` = '<p> Dear {$client_name}, </p> <p> This is
the second billing notice that your invoice no. {$invoice_num} which was
generated on {$invoice_date_created} is now overdue. </p> <p>
Your payment method is: {$invoice_payment_method} </p> <p>
Invoice: {$invoice_num}<br /> Balance Due: {$invoice_balance}<br
/> Due Date: {$invoice_date_due} </p> <p> You can login to
your client area to view and pay the invoice at {$invoice_link} </p>
<p> {$signature} </p>' WHERE `type` = 'invoice' AND `name` =
'Second Invoice Overdue Notice' AND `message` = '<p> Dear
{$client_name}, </p> <p> This is the second billing notice that
your invoice no. {$invoice_num} which was generated on
{$invoice_date_created} is now overdue. </p> <p> Your payment
method is: {$invoice_payment_method} </p> <p> Invoice:
{$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due
Date: {$invoice_date_due} </p> <p> You can login to your client
area to view and pay the invoice at {$invoice_link} </p> <p>
Your login details are as follows: </p> <p> Email Address:
{$client_email}<br /> Password: {$client_password} </p>
<p> {$signature} </p>';
UPDATE `tblemailtemplates` SET
`message` = '<p> Dear {$client_name}, </p> <p> This is
the third and final billing notice that your invoice no. {$invoice_num}
which was generated on {$invoice_date_created} is now overdue. Failure to
make payment will result in account suspension.</p> <p> Your
payment method is: {$invoice_payment_method} </p> <p> Invoice:
{$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due
Date: {$invoice_date_due} </p> <p> You can login to your client
area to view and pay the invoice at {$invoice_link} </p> <p>
{$signature} </p>' WHERE `type` = 'invoice' AND `name` = 'Third
Invoice Overdue Notice' AND `message` = '<p> Dear {$client_name},
</p> <p> This is the third and final billing notice that your
invoice no. {$invoice_num} which was generated on {$invoice_date_created}
is now overdue. Failure to make payment will result in account
suspension.</p> <p> Your payment method is:
{$invoice_payment_method} </p> <p> Invoice:
{$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due
Date: {$invoice_date_due} </p> <p> You can login to your client
area to view and pay the invoice at {$invoice_link} </p> <p>
Your login details are as follows: </p> <p> Email Address:
{$client_email}<br /> Password: {$client_password} </p>
<p> {$signature} </p>';
DELETE FROM `tblaffiliatesaccounts`
WHERE relid NOT IN (SELECT id FROM tblhosting);
INSERT INTO
`tblemailtemplates` (`type`, `name`, `subject`, `message`, `attachments`,
`fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`,
`plaintext`) VALUES
('support', 'Replies Only Bounce Message', 'Online
Submission Required', '<p>{$client_name},</p><p>Your
email to our support system could not be accepted because we require you to
submit all tickets via our online client support portal. You can do this at
the URL below.</p><p><a
href="{$whmcs_url}/submitticket.php">{$whmcs_url}/submitticket.php</a></p><p>{$signature}</p>',
'', '', '', '', '', '', '', 0);
UPDATE `tblemailtemplates` SET `name` =
'Clients Only Bounce Message' WHERE `name` = 'Bounce Message';
UPDATE
`tblemailtemplates` SET `message` = '<p>Dear
{$client_name},</p><p>Recently a request was submitted to reset
your password for our client area. If you did not request this, please
ignore this email. It will expire and become useless in 2 hours
time.</p><p>To reset your password, please visit the url
below:<br /><a
href="{$pw_reset_url}">{$pw_reset_url}</a></p><p>When
you visit the link above, you will have the opportunity to choose a new
password.</p><p>{$signature}</p>' WHERE `type` =
'general' AND `name` = 'Password Reset Validation' AND `message` =
'<p>Dear {$client_name},</p><p>Recently a request was
submitted to reset your password for our client area. If you did not
request this, please ignore this email. It will expire and become useless
in 2 hours time.</p><p>To reset your password, please visit the
url below:<br /><a
href="{$pw_reset_url}">{$pw_reset_url}</a></p><p>When
you visit the link above, your password will be reset, and the new password
will be emailed to you.</p><p>{$signature}</p>';
INSERT
INTO `tblemailtemplates` (`type`, `name`, `subject`, `message`,
`attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`,
`copyto`, `plaintext`) VALUES
('general', 'Unsubscribe Confirmation',
'Unsubscribe Confirmation', 'Dear {$client_name},<br /><br />We
have now removed your email address from our mailing list.<br
/><br />If this was a mistake or you change your mind, you can
re-subscribe at any time from the My Details section of our client
area.<br /><br /><a
href="{$whmcs_url}/clientarea.php?action=details">{$whmcs_url}/clientarea.php?action=details</a><br
/><br />{$signature}', '', '', '', '', '', '', '', 0);
CREATE
TABLE IF NOT EXISTS `tbltransientdata` (
`id` int(10) NOT NULL
AUTO_INCREMENT,
`name` varchar(1024) NOT NULL,
`data` text NOT NULL,
`expires` int(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `name`
(`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
UPDATE tblconfiguration SET value='5.3.0' WHERE setting='Version';