UPDATE setting set value='2.2.4' where name='ClientExec Version';
UPDATE `setting` SET `description` = 'String that is visible in the browser title. This string with the slogan variable make up the title for all pages.' WHERE name='Title';
UPDATE `setting` SET `description` = 'The URL to this application. This value is used in many places where the client is sent a link or where any 3rd party billing might return to give control back to this site.<br>Note: Make sure you include http:// in front of the domain name<br>(example: http://www.clientexec.com)' WHERE name='ClientExec URL';
UPDATE `setting` SET `description` = 'Determine the default language for your site.' WHERE name='Language';
UPDATE `setting` SET `description` = 'Please enter the absolute path to Curl on your system.<br>Note: Leaving this blank will instruct CE to assume you have php compiled with libCurl.' WHERE name='Path to Curl';
UPDATE `setting` SET `description` = 'Select the template you wish your users to see. For new templates to be visible you must place the new style in the templates folder, which is off of the ClientExec root directory.' WHERE name='Template';
UPDATE `setting` SET `description` = 'Determine the number you wish to start numbering your invoices.' WHERE name='Invoice Start Number';
UPDATE `setting` SET `description` = 'Determine if you want your clients to view the pay invoice button.' WHERE name='Enable Pay Invoice';
UPDATE `setting` SET `description` = 'Additional information to provide for those clients that make payments via checks. This text will be provided as well in the PDF invoices if the field is not left blank.' WHERE name='Additional Notes for Invoices';
UPDATE `setting` SET `description` = 'Select the number of days prior to your invoice\'s due date to send your customer their invoice.' WHERE name='Send Invoice Offset';
UPDATE `setting` SET `description` = 'Select YES if you want to send the PDF invoice as an attachment when sending invoices.' WHERE name='Attach PDF When Mailing Invoice';
UPDATE `setting` SET `description` = 'Determine the number you wish to start numbering your trouble tickets.' WHERE name='Trouble Ticket Start Number';
UPDATE `setting` SET `description` = 'Email addresses ClientExec will send email notification on all new trouble tickets. You can separate emails by a comma.<br>Example: support1@domain.com, support2@domain.com' WHERE name='Email For New Trouble Tickets';
UPDATE `setting` SET `description` = '<i>For email piping only</i><br>In the event that a user submits an email to your support email piping address without an existing account or recognizable email address, ClientExec will forward to this email address. Leaving this setting blank will signal ClientExec to bounce back the email with the text found in the \'Bounce Back Template\' Setting.' WHERE name='Alternate Support Address';
UPDATE `setting` SET `value` = 'Your suppor email cannot be processed at this time because our support center did not recognize your email as one belonging to one of our customers. If you need assistance please email using your email of record or submit a support ticket. Support Team', `description` = '<i>For email piping only</i><br>Text used in the bounced email sent by ClientExec when an email is received via the pipe cron that does not belong to one of your customers.' WHERE name='Bounce Back Template';
UPDATE `setting` SET `description` = 'Initial email customer receives to confirm a password change to their account.' WHERE name='Forgot Password Template';
UPDATE `setting` SET `description` = 'Template for emails that get sent out to clients after their tickets have been commented on or closed.' WHERE name='Trouble Ticket Template';
UPDATE `setting` SET `description` = 'Select YES if you want to show percentage saved in signup script when a customer selects a longer billing cycle.' WHERE name='Include Saved Percentage';
UPDATE `setting` SET `description` = 'Select YES if you want ClientExec to check on customer\'s domain availability during signup.' WHERE name='Check Domain Availability';
DELETE FROM setting WHERE name='Offer Domain Services';
UPDATE `setting` SET `description` = 'Select YES if you want ClientExec to forward all new customers to the gateway selected for payment. CHECK and MONEY ORDER selections will just create the pending account and notify admin.' WHERE name='Forward To Gateway';
UPDATE `setting` SET `description` = 'Text shown upon signup completion for new customers that are not forwarded to a payment gateway.<br><b>Note:</b> HTML is accepted.<br>' WHERE name='Signup Completion Template';
UPDATE `help` SET `detail` = '[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>SENTDATE</font>] Date invoice was originally sent.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>INVOICENUMBER</font>]<br>[<font class=bodyhighlight>INVOICEDESCRIPTION</font>]<br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to Client Exec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] Email address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name' WHERE title='Invoice Template Tags';
UPDATE `setting` SET `description` = 'Select YES if you want ClientExec to show the terms and conditions and enforce approval before completing the signup process.' WHERE name='Show Terms and Conditions';
UPDATE `setting` SET `description` = 'Terms and Conditions that new customers need to agree to before receiving your services. The setting, Show Terms and Conditions, will need to be set to YES before this content is displayed in the signup process.<br><b>Note:</b> Content will be displayed inside a text area.' WHERE name='Terms and Conditions';
UPDATE `setting` SET `description` = 'Email addresses ClientExec will send email notifications to after all new signups. You can separate emails by a comma.<br>Example: support1@domain.com, support2@domain.com' WHERE name='Email for New Signups';
UPDATE `setting` SET `description` = 'Select YES if you want ClientExec to enforce the use of proper domain names. Selecting No will allow entries without TLD.' WHERE name='Ensure Proper Domain Format';
UPDATE `setting` SET `description` = 'Select the day you want to prorate all new orders to.' WHERE name='Prorate To Day';
UPDATE `setting` SET `description` = '<i>prorate option</i><br>Select if you want to include the next payment when prorating.' WHERE name='Include Following Payment';
UPDATE `setting` SET `description` = 'Setting allows MaxMind customers to check orders for fraud.' WHERE name='Enable MaxMind Fraud Control';
UPDATE `setting` SET `description` = 'Setting allows you to reject any order using free email services like hotmail and yahoo (free e-mail = higher risk).<br><b>Note: </b>Requires MaxMind' WHERE name='Reject Free Email Service';
UPDATE `setting` SET `description` = 'Setting allows you to reject any order where country of IP address does not match the billing address country (mismatch = higher risk).<br><b>Note: </b>Requires MaxMind' WHERE name='Reject Country Mismatch';
UPDATE `setting` SET `description` = 'Setting allows you to reject any order where the IP address is an Anonymous Proxy (anonymous proxy = very high risk).<br><b>Note: </b>Requires MaxMind' WHERE name='Reject Anonymous Proxy';
UPDATE `setting` SET `description` = 'Setting allows you to reject any order where the country the IP is based from is considered a country where fraudulent order is likely.<br><b>Note: </b>Requires MaxMind' WHERE name='Reject High Risk Country';
UPDATE `setting` SET `description` = 'MaxMind risk score is based on known risk factors and their likelihood to indicate possible fraud. Select the threshold you want ClientExec to reject on. ( 0=low risk 10=high risk)<br><b>Note:</b> Requires MaxMind<br>To see how the fraud score is obtained visit <br><a href=http://www.maxmind.com/app/web_services_score2?rId=clientexec target=_blank>http://www.maxmind.com/app/web_services_score2</a>' WHERE name='MaxMind Fraud Risk Score';
INSERT INTO `setting` (`name`, `value`, `description`, `type`, `isrequired`, `istruefalse`, `istextarea`, `isfromoptions`, `myorder`, `helpid`, `plugin`, `ispassword`, `ishidden`) VALUES ('Signup Rejection Template', '<center><b>Thank you for your order.  Unfortunately it has been rejected by our merchant.</b><br><br>Please contact our sales team at [SUPPORTEMAIL] for additional information.<br><br>Thank you for choosing [COMPANYNAME]!</center>', 'Text shown to customer upon signup rejections.<br><b>Note:</b> HTML accepted<br>', 10, 0, 0, 1, 0, 0, 7, 0, 0, 0);
UPDATE `help` SET `detail` = '[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your website<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> Email to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to Client Exec.' WHERE title='Signup Completion Tags';
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('DASHBOARD_INVOICEFILTER', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
CREATE TABLE files (
  id_file int(11) NOT NULL auto_increment,
  id_cat int(11) default NULL,
  name varchar(50) NOT NULL default '',
  description varchar(100) NOT NULL default '',
  hash varchar(16) NOT NULL default '',
  visible int(11) NOT NULL default '0',
  PRIMARY KEY  (id_file)
) ENGINE=MyISAM;
CREATE TABLE files_cats (
  id_cat int(11) NOT NULL auto_increment,
  id_parent int(11) default NULL,
  name varchar(50) NOT NULL default '',
  visible int(11) NOT NULL default '0',
  PRIMARY KEY  (id_cat)
) ENGINE=MyISAM;
CREATE TABLE files_cats_clienttypes (
  id_cat int(11) NOT NULL default '0',
  id_clienttype int(11) NOT NULL default '0',
  PRIMARY KEY  (id_cat,id_clienttype)
) ENGINE=MyISAM;
CREATE TABLE files_cats_users (
  id_cat int(11) NOT NULL default '0',
  id_user int(11) NOT NULL default '0',
  PRIMARY KEY  (id_cat,id_user)
) ENGINE=MyISAM;
CREATE TABLE files_clienttypes (
  id_file int(11) NOT NULL default '0',
  id_clienttype int(11) NOT NULL default '0',
  PRIMARY KEY  (id_file,id_clienttype)
) ENGINE=MyISAM;
CREATE TABLE files_users (
  id_file int(11) NOT NULL default '0',
  id_user int(11) NOT NULL default '0',
  PRIMARY KEY  (id_file,id_user)
) ENGINE=MyISAM;
