INSERT INTO `announcement` VALUES (NULL, 0, 'Welcome', 'Welcome to our new billing and support application, ClientExec!  From within, you can easily view and pay your invoices, request assistance with any problems you may encounter, maintain your billing information, resend your welcome E-mail and so much more!', 'Welcome to our new billing and support application, ClientExec!&nbsp; From within, you can easily view and pay your invoices, request assistance with any problems you may encounter, maintain your billing information, resend your welcome E-mail and so much more!', '2007-06-01 20:23:00', '1', '100', '0');

INSERT INTO `billingtype` VALUES('-2', 'Domain Name', 'Domain Name Registration', 'Default name registration detail','0.00',0);
INSERT INTO `billingtype` VALUES ('-3', 'Discount', 'Discount', 'Discount generated by a discount coupon entered at signup','0.00',0);
INSERT INTO `billingtype` VALUES ('-4', 'Package add-on', 'Package add-on', 'Package add-on fee','0.00',0);
INSERT INTO `billingtype` VALUES ('1', 'Miscellaneous', 'Miscellaneous', 'Miscellaneous','0.00',0);

INSERT INTO `cache` VALUES ('ADMINSUMMARY', '2003-02-14 22:29:43', '');

INSERT INTO `currency` (`id`, `name`, `symbol`, `decimalssep`, `thousandssep`, `abrv`, `alignment`, `precision`, `rate`, `enabled`) VALUES
(1, 'Swiss Franc', 'CHF', '.', ',', 'CHF', 'left', 2, 1, 1),
(2, 'Malaysian Ringgit', 'RM', '.', ',', 'MYR', 'left', 2, 1, 1),
(3, 'Australian Dollar', '$', '.', ',', 'AUD', 'left', 2, 1, 1),
(4, 'United States Dollar', '$', '.', ',', 'USD', 'left', 2, 1, 1),
(5, 'Canadian Dollar', '$', '.', ',', 'CAD', 'left', 2, 1, 1),
(6, 'New Zealand Dollars', '$', '.', ',', 'NZD', 'left', 2, 1, 1),
(7, 'Saudi Riyal', 'SR', '.', ',', 'SAR', 'left', 2, 1, 1),
(8, 'Turkish Lira', 'TL', '.', ',', 'TRY', 'right', 2, 1, 1),
(9, 'Swedish Krona', 'kr', ',', 'space', 'SEK', 'left', 2, 1, 1),
(10, 'Singapore Dollar', '$', '.', ',', 'SGD', 'left', 2, 1, 1),
(11, 'Euro', '€', '.', ',', 'EUR', 'left', 2, 1, 1),
(12, 'Indian Rupees', 'Rs.', '.', ',', 'INR', 'left', 2, 1, 1),
(13, 'Philippine Peso', '₱', '.', ',', 'PHP', 'left', 2, 1, 1),
(14, 'Yen', '¥', '.', ',', 'JPY', 'left', 2, 1, 1),
(15, 'Pound Sterling (GBP)', '£', '.', ',', 'GBP', 'left', 2, 1, 1),
(16, 'Indonesian Rupiah (Rp)', 'Rp', '.', ',', 'IDR', 'left', 2, 1, 1),
(17, 'Argentine Peso', '$', '.', ',', 'ARS', 'left', 2, 1, 1),
(NULL, 'United Arab Emirates Dirham', 'د.إ', '.', ',', 'AED', 'right', 2, 1, 0),
(NULL, 'South African Rand', 'R', '.', ',', 'ZAR', 'left', 2, 1, 0),
(NULL, 'Mexican Peso', '$', '.', ',', 'MXN', 'left', 2, 1, 0),
(NULL, 'Brazilian Real', 'R$', '.', ',', 'BRL', 'left', 2, 1, 0),
(NULL, 'CFP Franc', 'F', '.', ',', 'XPF', 'left', 2, 1, 0),
(NULL, 'Romania New Lei', 'lei', '.', ',', 'RON', 'right', 2, 1, 0),
(NULL, 'Egyptian Pound', 'E£', '.', ',', 'EGP', 'left', 3, 1, 0),
(NULL, 'Polish Złoty', 'zł', '.', ',', 'PLN', 'left', 2, 1, 0),
(NULL, 'Iranian Rial', 'IRR', '.', ',', 'IRR', 'left', 2, 1, 0),
(NULL, 'Estonian Kroon', 'KR', '.', ',', 'EEK', 'left', 2, 1, 0),
(NULL, 'Lithuanian Litas', 'Lt', '.', ',', 'LTL', 'right', 2, 1, 0),
(NULL, 'Hungarian Forint', 'Ft', '.', ',', 'HUF', 'right', 2, 1, 0);

INSERT INTO `currency` (`id`, `name`, `symbol`, `decimalssep`, `thousandssep`, `abrv`, `alignment`, `precision`, `rate`, `enabled`) VALUES
(NULL, 'Algerian Dinar', 'DA', '.', ',', 'DZD', 'right', 2, 1, 0),
(NULL, 'Angolan Kwanza', 'Kz', '.', ',', 'AOA', 'right', 2, 1, 0),
(NULL, 'West African CFA Franc', 'CFA', '.', ',', 'XOF', 'right', 2, 1, 0),
(NULL, 'Central African CFA Franc', 'FCFA', '.', ',', 'XAF', 'right', 2, 1, 0),
(NULL, 'Burundian Franc', 'FBu', '.', ',', 'BIF', 'right', 2, 1, 0),
(NULL, 'Comorian Franc', 'CF', '.', ',', 'KMF', 'right', 2, 1, 0),
(NULL, 'Congolese Franc', 'FC', '.', ',', 'CDF', 'right', 2, 1, 0),
(NULL, 'Djiboutian Franc', 'Fdj', '.', ',', 'DJF', 'right', 2, 1, 0),
(NULL, 'Eritrean Nakfa', 'Nfk', '.', ',', 'ERN', 'right', 2, 1, 0),
(NULL, 'Botswana Pula', 'P', '.', ',', 'BWP', 'left', 2, 1, 0),
(NULL, 'Ethiopian Birr', 'Br', '.', ',', 'ETB', 'left', 2, 1, 0),
(NULL, 'Gambian Dalasi', 'D', '.', ',', 'GMD', 'left', 2, 1, 0),
(NULL, 'Ghana Cedi', 'GH¢', '.', ',', 'GHS', 'left', 2, 1, 0),
(NULL, 'Guinean Franc', 'FG', '.', ',', 'GNF', 'left', 2, 1, 0),
(NULL, 'Kenyan Shilling', 'KSh', '.', ',', 'KES', 'left', 2, 1, 0),
(NULL, 'Lesotho Loti', 'M', '.', ',', 'LSL', 'left', 2, 1, 0),
(NULL, 'Liberian Dollar', 'L$', '.', ',', 'LRD', 'left', 2, 1, 0),
(NULL, 'Libyan Dinar', 'LD', '.', ',', 'LYD', 'left', 3, 1, 0),
(NULL, 'Malagasy Ariary', 'Ar', '.', ',', 'MGA', 'left', 2, 1, 0),
(NULL, 'Malawian Kwacha', 'MK', '.', ',', 'MWK', 'left', 2, 1, 0),
(NULL, 'Mauritanian Ouguiya', 'UM', '.', ',', 'MRO', 'left', 2, 1, 0),
(NULL, 'Mauritian Rupee', 'Rp', '.', ',', 'MUR', 'left', 2, 1, 0),
(NULL, 'Mozambican Metical', 'MT', '.', ',', 'MZN', 'left', 2, 1, 0),
(NULL, 'Namibian Dollar', 'N$', '.', ',', 'NAD', 'left', 2, 1, 0),
(NULL, 'Rwanda Franc', 'FRw', '.', ',', 'RWF', 'left', 2, 1, 0),
(NULL, 'São Tomé and Príncipe Dobra', 'Db', '.', ',', 'STD', 'left', 2, 1, 0),
(NULL, 'Seychellois Rupee', 'SR', '.', ',', 'SCR', 'left', 2, 1, 0),
(NULL, 'Sierra Leonean Leone', 'Le', '.', ',', 'SLL', 'left', 2, 1, 0),
(NULL, 'Sudanese Dinar', '£Sd', '.', ',', 'SDD', 'left', 2, 1, 0),
(NULL, 'Swazi Lilangeni', 'E', '.', ',', 'SZL', 'left', 2, 1, 0),
(NULL, 'Tunisian Dinar', 'DT', '.', ',', 'TND', 'left', 3, 1, 0),
(NULL, 'Ugandan Shilling', 'USh', '.', ',', 'UGX', 'left', 2, 1, 0),
(NULL, 'Zambian Kwacha', 'ZK', '.', ',', 'ZMK', 'left', 2, 1, 0),
(NULL, 'Moroccan Dirham', 'د.م.', '.', ',', 'MAD', 'right', 2, 1, 0),
(NULL, 'Nigerian Naira', '₦', '.', ',', 'NGN', 'left', 2, 1, 0),
(NULL, 'Pakistani Rupee', 'Rs.', '.', ',', 'PKR', 'left', 2, 1, 0),
(NULL, 'Thai Baht', '฿', '.', ',', 'THB', 'left', 2, 1, 0);

INSERT INTO `currency` (`id`, `name`, `symbol`, `decimalssep`, `thousandssep`, `abrv`, `alignment`, `precision`, `rate`, `enabled`) VALUES
(NULL, 'Norwegian Krone', 'kr', ',', 'space', 'NOK', 'left', 2, 1, 0),
(NULL, 'Danish Krone', 'kr', ',', 'space', 'DKK', 'left', 2, 1, 0),
(NULL, 'Icelandic Króna', 'kr', ',', 'space', 'ISK', 'left', 2, 1, 0);

INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(1, 'Customer', 0, 0, 0, 1, 'All customers belong to this group. You can\'t erase this group.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(2, 'Super Admin', 1, 1, 0, 0, 'Main administrator. He has all permissions in the system and is the only one with permissions to modify staff groups and permissions.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(3, 'Support Staff', 1, 0, 0, 0, 'Has limited permissions on the support module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(4, 'Billing', 1, 0, 0, 0, 'By default, he has all the permissions in the billing module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(5, 'Support Manager', 1, 0, 0, 0, 'By default, he has all the permissions in the Support module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(6, 'Priority Customers', 0, 0, 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(8, 'Big Accounts', 0, 0, 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(7, 'Business Partners', 0, 0, 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `iscompanysuperadmin`, `iscustomersmaingroup`, `description`) VALUES(9, 'Personal acquaintances', 0, 0, 0, 0, '');

INSERT INTO `help` VALUES (1, 'Welcome Email Tags', /*T*/'[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br> Company address<br>[<font class=bodyhighlight>ACCOUNTINFORMATION</font>]*<br> Includes Domain Name, Username, Password, IP<br>[<font class=bodyhighlight>DOMAINNAME</font>]<br> domain name without http://www.<br>[<font class=bodyhighlight>DOMAINUSERNAME</font>]*<br> Domain User Name<br>[<font class=bodyhighlight>DOMAINPASSWORD</font>]*<br> Domain Password<br>[<font class=bodyhighlight>DOMAINIP</font>]*<br> IP Address to Domain<br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your web site<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> E-mail to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>]<br> URL to retrieve forgotten password.<br>[<font class=bodyhighlight>CLIENTNAME</font>]<br>Both first and last name<br>[<font class=bodyhighlight>FIRSTNAME</font>]<br>First name<br>[<font class=bodyhighlight>CLIENTEMAIL</font>]<br>Client''s Email<br>[<font class=bodyhighlight>ORGANIZATION</font>] <br> Client''s Organization<br>[<font class=bodyhighlight>PLANNAME</font>] <br> Client''s Plan<br>[<font class=bodyhighlight>NAMESERVERS</font>]<br>lists only hostnames<br>[<font class=bodyhighlight>NAMESERVERSANDIPS</font>]<br>lists both IPs and hostnames<br>[<font class=bodyhighlight>SERVERHOSTNAME</font>]*<br>example server1.yourdomain.com<br>[<font class=bodyhighlight>SERVERSHAREDIP</font>]*<br>shared IP for server<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name<br>[<font class=bodyhighlight>CUSTOMPACKAGE_xxxx</font>]<br>where xxx is custom package field name<br/><br/>(* Hosting Packages Only)'/*~T*/, 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (6, 'Ticket Template Tags', /*T*/'[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>]<br>[<font class=bodyhighlight>DESCRIPTION</font>]<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>CUSTOM_xxxx</font>]<br>where xxx is custom field name'/*~T*/, 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (8, 'Run schedule format', /*T*/'In the Run Schedule fields you can enter any format accepted by the Cron utility. For example for the field Minute: <ul> <li>* : every minute <li>Number: e.g. 4 will make it run at :04 <li>Range: e.g. 1-3 will make it run at :01, :02, :03 <li>List: e.g. 1,3,7 will make it run at :01, :03, :07 <li>Step: e.g. */3 will make it run every third minute <li>Range and step: 0-30/2 will make it run every other minute till :30 </ul> In Day of the Week you can enter a number in the range 0-6 (0 for Sunday) or a 3 letter shortcut (e.g. sun).'/*~T*/, 'Click to view schedule format', 240, 420);
INSERT INTO `help` VALUES (9, 'Batch Invoice Notifier Tags', /*T*/'[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>COMPANYADDRESS</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] E-mail address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name'/*~T*/, 'Click to view available tags', '240', '320');
INSERT INTO `help` VALUES (11, 'Announcement Tags', /*T*/'[<font class=bodyhighlight>CLIENTNAME</font>]<br> Includes name and last name<br>[<font class=bodyhighlight>FIRSTNAME</font>]<br> First name of the client<br>[<font class=bodyhighlight>LASTNAME</font>]<br> Last name of the client<br>[<font class=bodyhighlight>ORGANIZATION</font>]<br> Client\'s Organization<br>[<font class=bodyhighlight>DATE</font>]<br> Actual Date<br>[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br> Company address'/*~T*/, 'Click to view available tags', 240, 320);
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('50', 'Invoice Template Tags', '[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>SENTDATE</font>] Date invoice was last sent.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>CLIENTNUMBER</font>]<br/>[<font class=bodyhighlight>INVOICENUMBER</font>]<br/>[<font class=bodyhighlight>DIRECTPAYMENTLINK</font>]<br/>Add direct link for invoice payment. Only visible for applicable plugins that support this method of payment. [<font class=bodyhighlight>INVOICEHASH</font>] A hash for the invoice in case you need to send one.<br>[<font class=bodyhighlight>INVOICEDESCRIPTION</font>]<br>[<font class=bodyhighlight>TAX</font>]<br>[<font class=bodyhighlight>AMOUNT_EX_TAX</font>] The total price excluding taxes.<br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>PAID</font>] The amount already paid of the invoice.<br>[<font class=bodyhighlight>BALANCEDUE</font>] The balance due of the invoice.<br>[<font class=bodyhighlight>RAW_AMOUNT</font>] The total price excluding currency symbol.<br>[<font class=bodyhighlight>PMTREFERENCE</font>] The value used in the payment reference field of the invoice.<br>[<font class=bodyhighlight>PMTTRANSACTIONS</font>] The transactions applied to the invoice.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>COMPANYADDRESS</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] E-mail address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('51', 'Expiring CC Template', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>CCLASTFOUR</font>] The last four digits of the customer\'s credit card.<br>[<font class=bodyhighlight>CCEXPDATE</font>] The expiration date of the customer\'s credit card.<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>COMPANYADDRESS</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] Email address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('52', 'Domain Reminder Tags', '[<font class=bodyhighlight>CLIENTNAME</font>]<br>[<font class=bodyhighlight>FIRSTNAME</font>]<br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>DOMAIN</font>] <br> The client domain name.<br>[<font class=bodyhighlight>EXPDATE</font>] <br> The expiry date of the domain.<br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] <br> URL to retrieve forgotten password.<br>[<font class=bodyhighlight>BILLINGEMAIL</font>] <br> Email address for billing inquiries<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to Client Exec.<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name.<br>', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('53', 'Reset Password Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>]<br>[<font class=bodyhighlight>COMPANYADDRESS</font>]<br>[<font class=bodyhighlight>REQUESTIP</font>] IP of the machine which requested the password change.<br>[<font class=bodyhighlight>CONFIRMATION URL</font>] URL that user must press to confirm the password change<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('54', 'Get New Password Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>NEWPASSWORD</font>] <br>[<font class=bodyhighlight>CLIENTEXEC URL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>COMPANYEMAIL</font>]', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('55', 'Rejection E-Mail Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your web site<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> E-mail to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to ClientExec.', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('56', 'Team Status Reply E-Mail Tags', "[<font class=bodyhighlight>TEAMSTATUS</font>]<br> Team status used to reply<br>[<font class=bodyhighlight>REPLIEDTEAMSTATUSUSERNAME</font>]<br> Name of the user who's team status was replied<br>[<font class=bodyhighlight>REPLIEDTEAMSTATUSDATE</font>]<br> Date of the team status replied<br>[<font class=bodyhighlight>REPLIEDTEAMSTATUS</font>]<br> Team status replied<br>", 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('57', 'Team Status Activity E-Mail Tags', "[<font class=bodyhighlight>TEAMSTATUSDYNAMICBLOCK</font>]<br> Use for add the information of the Team Status Activity Dynamic Block Template<br>", 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('58', 'Team Status Dynamic Block Tags', "[<font class=bodyhighlight>TEAMSTATUSUSERNAME</font>]<br> Name of the user who post the team status<br>[<font class=bodyhighlight>TEAMSTATUS</font>]<br> Team status<br>[<font class=bodyhighlight>TEAMSTATUSDATE</font>]<br> Date of the team status<br>[<font class=bodyhighlight>TEAMSTATUSREPLYINFO</font>]<br> Use for add the information of the Team Status Activity Reply Template<br>", 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('59', 'Team Status Activity Reply Tags', "[<font class=bodyhighlight>REPLIEDTEAMSTATUSUSERNAME</font>]<br> Name of the user who's team status was replied<br>", 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('60', 'Ticket Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>TICKETURL</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>]<br>[<font class=bodyhighlight>TICKETSUBJECT</font>]<br>[<font class=bodyhighlight>DESCRIPTION</font>]<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('61', 'Feedback Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>]<br>[<font class=bodyhighlight>COMPANYADDRESS</font>]<br>[<font class=bodyhighlight>RATEEXCELLENTSERVICEURL</font>]<br />[<font class=bodyhighlight>RATEGOODSERVICEURL</font>]<br />[<font class=bodyhighlight>RATENOTGREATSERVICEURL</font>]<br />[<font class=bodyhighlight>RATEPOORSERVICEURL</font>]<br />[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('62', 'AutoClose Service Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>]<br>[<font class=bodyhighlight>COMPANYADDRESS</font>]<br>[<font class=bodyhighlight>TICKETNUMBER</font>]<br />[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is a profile custom field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('63', 'Notify Support For New High Priority Ticket Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>] <br>[<font class=bodyhighlight>TICKETSUBJECT</font>] <br>[<font class=bodyhighlight>TICKETTYPE</font>] <br>[<font class=bodyhighlight>DESCRIPTION</font>] <br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('64', 'Notify Customer For New Ticket Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>] <br>[<font class=bodyhighlight>TICKETSUBJECT</font>] <br>[<font class=bodyhighlight>TICKETTYPE</font>] <br>[<font class=bodyhighlight>DESCRIPTION</font>]<br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('65', 'Notify Assignee For Ticket Reply Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>] <br>[<font class=bodyhighlight>DESCRIPTION</font>]', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('66', 'Notify For New FeedBack Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>FIRSTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>] <br>[<font class=bodyhighlight>DESCRIPTION</font>]', 'Click to view available tags', '240', '320');
INSERT INTO `help` (`id`, `title`, `detail`, `linkwords`, `width`, `height`) VALUES ('67', 'Notify For New Order', '[<font class=bodyhighlight>ORDERINFO</font>]', 'Click to view available tags', '240', '320');


INSERT INTO `package` VALUES(1, 'Basic', 'Plan Features:<br>\n1Gig Bandwidth<br>\n75MB Diskspace<br>\n...', 1, 1, 'a:12:{s:6:"price1";s:4:"9.95";s:14:"price1included";i:1;s:6:"price3";s:5:"29.85";s:14:"price3included";i:1;s:6:"price6";s:4:"59.7";s:14:"price6included";i:1;s:7:"price12";s:5:"119.4";s:15:"price12included";i:1;s:7:"price24";s:5:"238.8";s:15:"price24included";i:1;s:5:"setup";s:1:"0";s:7:"taxable";i:1;}', 0, 1, 1, 1, 'a:5:{s:12:"stockEnabled";i:0;s:14:"availableStock";N;s:7:"soldOut";i:0;s:13:"acceptSoldOut";i:0;s:14:"showStockLevel";i:0;}', 32, '','');
INSERT INTO `package` VALUES(2, 'Standard', 'Plan Features:<br>\n3Gig Bandwidth<br> \n150MB Diskspace<br>\n...', 1, 1, 'a:12:{s:6:"price1";s:5:"17.95";s:14:"price1included";i:1;s:6:"price3";s:5:"53.85";s:14:"price3included";i:1;s:6:"price6";s:5:"107.7";s:14:"price6included";i:1;s:7:"price12";s:5:"215.4";s:15:"price12included";i:1;s:7:"price24";s:5:"430.8";s:15:"price24included";i:1;s:5:"setup";s:1:"0";s:7:"taxable";i:1;}', 0, 1, 1, 1, 'a:5:{s:12:"stockEnabled";i:0;s:14:"availableStock";N;s:7:"soldOut";i:0;s:13:"acceptSoldOut";i:0;s:14:"showStockLevel";i:0;}', 32, '','');
INSERT INTO `package` VALUES(3, 'Charity', 'Only for charity sites with low bandwidth and diskspace<br><br>\nPlan Features:<br>\n500Gig Bandwidth<br> \n10MB Diskspace<br>\n...', 1, 1, 'a:12:{s:6:"price1";s:1:"3";s:14:"price1included";i:1;s:6:"price3";s:1:"9";s:14:"price3included";i:1;s:6:"price6";s:2:"18";s:14:"price6included";i:1;s:7:"price12";s:2:"36";s:15:"price12included";i:1;s:7:"price24";s:2:"72";s:15:"price24included";i:1;s:5:"setup";s:1:"0";s:7:"taxable";i:0;}', 0, 1, 1, 1, 'a:5:{s:12:"stockEnabled";i:0;s:14:"availableStock";N;s:7:"soldOut";i:0;s:13:"acceptSoldOut";i:0;s:14:"showStockLevel";i:0;}', 32, '','');
INSERT INTO `package` VALUES(4, 'Free', 'Plan Features:<br>\n1Gig Bandwidth<br> \n75MB Diskspace<br>\n...', 1, 1, 'a:12:{s:6:"price1";s:1:"0";s:14:"price1included";i:0;s:6:"price3";s:1:"0";s:14:"price3included";i:0;s:6:"price6";s:1:"0";s:14:"price6included";i:0;s:7:"price12";s:1:"0";s:15:"price12included";i:0;s:7:"price24";s:1:"0";s:15:"price24included";i:0;s:5:"setup";s:4:"9.99";s:7:"taxable";i:0;}', 0, 1, 1, 1, 'a:5:{s:12:"stockEnabled";i:0;s:14:"availableStock";N;s:7:"soldOut";i:0;s:13:"acceptSoldOut";i:0;s:14:"showStockLevel";i:0;}', 32, '','');
INSERT INTO `package` VALUES(5, 'Domain Name', 'This product is used to handle all default domain name activities.', 2, 0, 'a:0:{}', 0, 1, 1, 1, '0', 0, '','');

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'admin_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'admin_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'admin_view', 0);

INSERT INTO `promotion` VALUES(1, 'This product group is used for all standard webhosting packages sold through our website.', 1, 'Shared Web Hosting', 1, 1, 1);
INSERT INTO `promotion` VALUES(2, 'This product group is used for all domain related services sold through our website. This group cannot be deleted or have its type changed, any domain names sold will be tied to a Domain product that is part of this group.', 1, 'Domain Services', 3, 0, 99);
INSERT INTO `promotion` VALUES(3, 'This product group is used for all SSL related services sold through our website. This group cannot be deleted or have its type changed, any SSL certificates sold will be tied to a SSL product that is part of this group.', 0, 'SSL Certificates', 2, 0, 98);

INSERT INTO `report` VALUES ('Monthly_Signup_Rate_And_Percentage-Account_&_packages.php', '1', '1');
INSERT INTO `report` VALUES ('Support_Tickets_Opened-Support.php', '1', '1');
INSERT INTO `report` VALUES ('Support_Tickets_Closed-Support.php', '1', '1');

INSERT INTO `server` VALUES (1, 'server1', 'server1.yourserver.com', '00.00.00.00', 1, '', '0000-00-00 00:00:00', 0, '', 0);

INSERT INTO `setting` VALUES (NULL, 0, 'ClientExec Version', '', '', 'Version of ClientExec', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,1);
INSERT INTO `setting` VALUES (NULL, 0, 'Default Country Currency2', '', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,1);
INSERT INTO `setting` VALUES (NULL, 0, 'Default Country Name', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,1);
INSERT INTO `setting` VALUES (NULL, 0, 'Default Gateway', 'paypal', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Selected Currency Plugin', 'europeancentralbank', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Default Currency', 'USD', '', 'Select the default currency you would like ClientExec to use for your customers. This will also be the currency used during customer signup', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,1);
INSERT INTO `setting` VALUES (NULL, 0, 'Integrate Control Panel', '1', '', 'Select YES if you want to integrate with a specific hosting control panel. NOTE: You must provide the required information for the control panel you select.', 9, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Cpanel Port', '2082', '', 'List the port number used in your installation of the Cpanel Control Panel. NOTE: This is usually set to 2082 as the default setting', 9, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Show All Settings', '0', '', 'This setting allows you to view all settings for a given type at once.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Default Country Currency', '', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'LastDateGenerateInvoices', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'LastDateRunBatch', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'license', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Email Piping In Use', 0, '', 'If E-mail piping is in use set this to true so the reply above this line can be added to support ticket E-mails.', 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1,0);
INSERT INTO `setting` VALUES (NULL, 0, 'E-mail Piping Last Five', '', '', 'Stores a serialized array of the last five E-mails addresses that have piped a reply into the system and the time that they were processed.', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Domains Taxable', '0', NULL , 'Charge tax for domain fees', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1,0);
INSERT INTO `setting` VALUES (NULL, 0, 'Default TLD', 'com', NULL , 'Select the TLD that should be preselected in the sign up form.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1,0);
INSERT INTO `setting` VALUES (NULL, 0, 'TeamStatusAPIInfo', '', '', 'API information for team status to send to CampFire or HipChat', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,0);
INSERT INTO `setting` VALUES (NULL , 0, 'plugin_teamstatusnotifier_lastrun', '', '', 'Last runtime for teamstatus notifier service.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting`(`id`, `name`, `value`,`description`, `type`, `issession`, `ishidden`) VALUES (NULL, 'RoutingFilters', 'Subject: ***SPAM***\r\nX-Spam-Status: Yes', 'Filters used in routing rules to omit unwanted emails.', -1, 0, 1);

INSERT INTO `users` VALUES (100, 0, 0, '2checkout', 0, 2, '43e9a4ab75570f5b', '0000-00-00', 'admin@domain.com\r\nReinventing Support!', 'admin@domain.com<br />\r\nReinventing Support!', 0, '2003-02-14 22:29:45', '2003-02-14 22:29:45', '', 0, 1, 1, 'USD', '', 0, '0', '0', '', '', '', 0, 0, 0, 1, 'Admin', 'User', 'admin@domain.com', '', '', '', 0, 0, 0);

INSERT INTO `setting` (`id`, `name`, `value`, `value_alternate`, `description`, `type`, `isrequired`, `istruefalse`, `istextarea`, `issmalltextarea`, `isfromoptions`, `myorder`, `helpid`, `plugin`, `ispassword`, `ishidden`, `issession`) VALUES (NULL, 'CE-APIKEY', '', NULL, 'System Generated API-Key', '-1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0');
UPDATE setting set type=0 where type > 0;
