芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/portal.pulsehost.co.uk/resources/sql/upgrade510.sql

INSERT INTO tblconfiguration (setting,value) VALUES ('DomainSyncEnabled','on');
INSERT INTO tblconfiguration (setting,value) VALUES ('DomainSyncNextDueDate','');
INSERT INTO tblconfiguration (setting,value) VALUES ('DomainSyncNextDueDateDays','0');
ALTER TABLE `tbldomains` ADD `synced` INT( 1 ) NOT NULL;

ALTER TABLE `tblnotes` ADD `sticky` INT( 1 ) NOT NULL;

ALTER TABLE `tblproducts` CHANGE  `overagesenabled`  `overagesenabled` VARCHAR( 10 ) NOT NULL;

ALTER TABLE `tblproducts` ADD `retired` INT( 1 ) NOT NULL;

INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TicketMask', '%n%n%n%n%n%n');
ALTER TABLE  `tbltickets` CHANGE  `tid`  `tid` VARCHAR( 15 ) NOT NULL;

INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'admin', 'New Cancellation Request', 'New Cancellation Request', 'A new cancellation request has been submitted.Client ID: {$client_id} Client Name: {$clientname} Service ID: {$service_id} Product Name: {$product_name} Cancellation Type: {$service_cancellation_type} Cancellation Reason: {$service_cancellation_reason}{$whmcs_admin_link}', '', '', '', '', '', '', '', '0');
UPDATE `tblemailtemplates` SET `message` = 'Dear {$client_name},This email is to confirm that we have received your cancellation request for the service listed below.Product/Service: {$service_product_name} Domain: {$service_domain}{if $service_cancellation_type=="Immediate"}The service will be terminated within the next 24 hours.{else}The service will be cancelled at the end of your current billing period on {$service_next_due_date}.{/if}Thank you for using {$company_name} and we hope to see you again in the future.{$signature}' WHERE `name` = 'Cancellation Request Confirmation';

INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'admin', 'Support Ticket Flagged', 'New Support Ticket Flagged to You', 'A new support ticket has been flagged to you.Ticket #: {$ticket_tid} Client Name: {$client_name} (ID {$client_id}) Department: {$ticket_department} Subject: {$ticket_subject} Priority: {$ticket_priority}---------------------- {$ticket_message} ----------------------{$whmcs_admin_link}', '', '', '', '', '', '', '', '0');

ALTER TABLE  `tbladmins` ADD  `authmodule` TEXT NOT NULL AFTER  `password` , ADD  `authdata` TEXT NOT NULL AFTER  `authmodule`;

INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'domain', 'Domain Transfer Failed', 'Domain Transfer Failed: {$domain_name}', 'Dear {$client_name},Recently you placed a domain transfer order with us but unfortunately it has failed. The reason for the failure if available is shown below so once this has been resolved, please contact us to re-attempt the transfer.Domain: {$domain_name} Failure Reason: {$domain_transfer_failure_reason}If you have any questions, please open a support ticket from our client area @ {$whmcs_link}{$signature}', '', '', '', '', '', '', '', 0);

ALTER TABLE `tbldomains` ADD `reminders` TEXT NOT NULL AFTER `donotrenew`;
UPDATE `tblemailtemplates` SET `message` = 'Dear {$client_name},{if $days_until_expiry}The domain(s) listed below are due to expire within the next {$days_until_expiry} days.{else}The domain(s) listed below are going to expire in {$domain_days_until_expiry} days. Renew now before it\'s too late...{/if}{if $expiring_domains}{foreach from=$expiring_domains item=domain}{$domain.name} - {$domain.nextduedate} ({$domain.days} Days) {/foreach}{else}{$domain_name} - {$domain_next_due_date} ({$domain_days_until_nextdue} Days){/if}To ensure the domain does not expire, you should renew it now. You can do this from the domains management section of our client area here: {$whmcs_link}Should you allow the domain to expire, you will be able to renew it for up to 30 days after the renewal date. During this time, the domain will not be accessible so any web site or email services associated with it will stop working.{$signature}' WHERE `name` = 'Upcoming Domain Renewal Notice';

CREATE TABLE IF NOT EXISTS `tblorderstatuses` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `color` text NOT NULL,
  `showpending` int(1) NOT NULL,
  `showactive` int(1) NOT NULL,
  `showcancelled` int(1) NOT NULL,
  `sortorder` int(2) NOT NULL,
  PRIMARY KEY (`id`)
)  DEFAULT  CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `tblorderstatuses` (`id`, `title`, `color`, `showpending`, `showactive`, `showcancelled`, `sortorder`) VALUES
(1, 'Pending', '#cc0000', 1, 0, 0, 10),
(2, 'Active', '#779500', 0, 1, 0, 20),
(3, 'Cancelled', '#888888', 0, 0, 1, 30),
(4, 'Fraud', '#000000', 0, 0, 0, 40);
INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES ('1', '122');

ALTER TABLE  `tblpromotions` ADD `lifetimepromo` INT(1) NOT NULL AFTER `uses`;

ALTER TABLE  `tblquotes` ADD  `datesent` DATE NOT NULL , ADD  `dateaccepted` DATE NOT NULL ;

UPDATE `tblemailtemplates` SET `message` = 'Dear {$client_name},Here is the quote you requested for {$quote_subject}. The quote is valid until {$quote_valid_until}. You may {if $client_id}view the quote at any time at {$quote_link} and {/if}simply reply to this email with any further questions or requirement.{$signature}' WHERE `name` = 'Quote Delivery with PDF';
INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'general', 'Quote Accepted', 'Quote #{$quote_number} Accepted - {$quote_subject}', '\r\nDear {$client_name}, \r\n\r\n\r\nThis is a confirmation that quote generated on {$quote_date_created} has been accepted by you and invoice # {$invoice_num} is generated.\r\n\r\n{$signature} \r\n', '', '', '', '', '', '', '', '0');
INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `attachments`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'general', 'Quote Accepted Notification', 'Quote #{$quote_number} Accepted - {$quote_subject}', 'A quote has been accepted by the following customer.Customer Information\r\nCustomer ID: {$client_id} \r\nName: {$clientname} \r\nEmail: {$client_email} \r\nCompany: {$client_company_name} \r\nAddress 1: {$client_address1} \r\nAddress 2: {$client_address2} \r\nCity: {$client_city} \r\nState: {$client_state} \r\nPostcode: {$client_postcode} \r\nCountry: {$client_country} \r\nPhone Number: {$client_phonenumber}\r\nQuote Information\r\nQuote #: {$quote_number} \r\nQuote Subject: {$quote_subject}<a href="{$whmcs_admin_url}quotes.php?action=manage&id={$quote_number}">{$whmcs_admin_url}quotes.php?action=manage&id={$quote_number}</a>', '', '', '', '', '', '', '', 0);