UPDATE `help` SET `detail` = '[<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>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>INVOICENUMBER</font>]<br>[<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>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' WHERE `title` = 'Invoice Template Tags';

# ---------------------------------------------------------
# Fixing typo in invoice email templates if they are unmodified.
# ---------------------------------------------------------

UPDATE autoresponders SET contents="Due Date: [DATE]\r\nInvoice #[INVOICENUMBER]\r\n\r\nATTN: [CLIENTNAME],\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely manner.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]" WHERE name='Invoice Template' AND contents="Due Date: [DATE]\r\nInvoice #[INVOICENUMBER]\r\n\r\nATTN: [CLIENTNAME],\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]";
UPDATE autoresponders SET contents_html="<HTML><head></head><body>Due Date: [DATE]<br />\r\nInvoice #[INVOICENUMBER]<br />\r\n<br />\r\nATTN: [CLIENTNAME],<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely manner.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>" WHERE name='Invoice Template' AND contents_html="<HTML><head></head><body>Due Date: [DATE]<br />\r\nInvoice #[INVOICENUMBER]<br />\r\n<br />\r\nATTN: [CLIENTNAME],<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely matter.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>";

UPDATE autoresponders SET contents="Dear [CLIENTNAME],\r\n\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely manner.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]" WHERE name='Payment Rejected Template' AND contents="Dear [CLIENTNAME],\r\n\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].\r\n\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\nPaid: [PAID]\r\nBalance Due: [BALANCEDUE]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]";
UPDATE autoresponders SET contents_html="<HTML><head></head><body>Dear [CLIENTNAME],<br />\r\n<br />\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely manner.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>" WHERE name='Payment Rejected Template' AND contents_html="<HTML><head></head><body>Dear [CLIENTNAME],<br />\r\n<br />\r\nPayment was rejected for Invoice #[INVOICENUMBER], sent on [DATE].<br />\r\n<br />\r\nYou currently have a balance of [BALANCEDUE] due on your account with [COMPANYNAME].  <br />\r\n<br />\r\nInvoice Description:<br />\r\n[INVOICEDESCRIPTION]<br />\r\n<br />\r\nTotal Due: [AMOUNT]<br />\r\nPaid: [PAID]<br />\r\nBalance Due: [BALANCEDUE]<br />\r\n<br />\r\nPayment Instructions:<br />\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\r\n2) Click on the \"Billing\" tab<br />\r\n3) Select the invoice you want to pay<br />\r\n4) Click on pay invoice<br />\r\n<br />\r\nWe greatly appreciate your efforts to ensure that payment<br />\r\nis received in a timely matter.<br />\r\n<br />\r\nIf you have any questions regarding your account or if <br />\r\nyou wish to pay by check, please feel free to contact us.<br />\r\n<br />\r\nNote: This email will serve as an official invoice for this payment.<br />\r\n<br />\r\n[COMPANYNAME]<br />\r\n[BILLINGEMAIL]</body></HTML>";

UPDATE autoresponders SET contents="Due Date: [DATE]\nInvoice #[INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\n\nTotal Due: [AMOUNT]\nPaid: [PAID]\nBalance Due: [BALANCEDUE]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the \"Billing\" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely manner.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This E-mail will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]" WHERE name='Overdue Invoice Template' AND contents="Due Date: [DATE]\nInvoice #[INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\n\nTotal Due: [AMOUNT]\nPaid: [PAID]\nBalance Due: [BALANCEDUE]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the \"Billing\" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This E-mail will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]";
UPDATE autoresponders SET contents_html="<HTML><head></head><body>Due Date: [DATE]<br />\nInvoice #[INVOICENUMBER]<br />\n<br />\nATTN: [CLIENTNAME],<br />\n<br />\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].<br />\n<br />\nInvoice Description:<br />\n[INVOICEDESCRIPTION]<br />\n<br />\nTotal Due: [AMOUNT]<br />\nPaid: [PAID]<br />\nBalance Due: [BALANCEDUE]<br />\n<br />\nPayment Instructions:<br />\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\n2) Click on the \"Billing\" tab<br />\n3) Select the invoice you want to pay<br />\n4) Click on pay invoice<br />\n<br />\nWe greatly appreciate your efforts to ensure that payment is received in a timely manner.<br />\n<br />\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.<br />\n<br />\nNote: This E-mail will serve as an official invoice for this payment.<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>" WHERE name='Overdue Invoice Template' AND contents_html="<HTML><head></head><body>Due Date: [DATE]<br />\nInvoice #[INVOICENUMBER]<br />\n<br />\nATTN: [CLIENTNAME],<br />\n<br />\nYou currently have an overdue invoice of [BALANCEDUE] due on your account with [COMPANYNAME].<br />\n<br />\nInvoice Description:<br />\n[INVOICEDESCRIPTION]<br />\n<br />\nTotal Due: [AMOUNT]<br />\nPaid: [PAID]<br />\nBalance Due: [BALANCEDUE]<br />\n<br />\nPayment Instructions:<br />\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password<br />\n2) Click on the \"Billing\" tab<br />\n3) Select the invoice you want to pay<br />\n4) Click on pay invoice<br />\n<br />\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.<br />\n<br />\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.<br />\n<br />\nNote: This E-mail will serve as an official invoice for this payment.<br />\n<br />\n[COMPANYNAME]<br />\n[BILLINGEMAIL]</body></HTML>";

# ---------------------------------------------------------
# Adding ResellerClub domains that require special attributes.
# ---------------------------------------------------------

INSERT INTO `registrars` VALUES ('resellerclub', 'us', 'a:2:{s:7:"purpose";a:3:{s:2:"ID";i:1;s:11:"description";s:13:"Nexus Purpose";s:7:"options";a:5:{s:10:"For Profit";a:2:{s:11:"description";s:24:"Business use for profit.";s:5:"value";s:2:"P1";}s:10:"Non-profit";a:2:{s:11:"description";s:68:"Non-profit business, club, association, religious organization, etc.";s:5:"value";s:2:"P2";}s:8:"Personal";a:2:{s:11:"description";s:13:"Personal use.";s:5:"value";s:2:"P3";}s:11:"Educational";a:2:{s:11:"description";s:19:"Education purposes.";s:5:"value";s:2:"P4";}s:10:"Government";a:2:{s:11:"description";s:20:"Government purposes.";s:5:"value";s:2:"P5";}}}s:8:"category";a:3:{s:2:"ID";i:2;s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:48:"A natural person who is a United States citizen.";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:119:"A natural person who is a permanent resident of the United States of America, or any of its possessions or territories.";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:454:"A US-based organization or company (A US-based organization or company formed within one of the fifty (50) U.S. states, the District of Columbia, or any of the United States possessions or territories, or organized or otherwise constituted under the laws of a state of the United States of America, the District of Columbia or any of its possessions or territories or a U.S. federal, state, or local government entity or a political subdivision thereof).";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:2:{s:11:"description";s:348:"A foreign entity or organization (A foreign entity or organization that has a bona fide presence in the United States of America or any of its possessions or territories who regularly engages in lawful activities (sales of goods or services or other business, commercial or non-commercial, including not-for-profit relations in the United States)).";s:5:"value";s:3:"C31";}s:15:"US Based Office";a:2:{s:11:"description";s:60:"Entity has an office or other facility in the United States.";s:5:"value";s:3:"C32";}}}}');