Version 2.4.16 [Maintenance Release - New Options ] 2/9/2004-----------------------------------------

Edited File: /admin/tools/client_management_client_form_inc.php
-> updated state/province form fields to used dropdowns as in step_four.php

Edited File: /admin/themes/blue/main_general_block.php
-> added in open batch count to AuthNet display

Edited File: /admin/config_editor.php
-> added switch to turn on/off domain registrations
-> added in support email address
-> added swtithc to turn on/off internal help desk

Edited File: /admin/view_batch.php
-> added invoice number view in batch view

Edited File: /inc/client_functions.php
-> added new vars to EMID 10
-> adjusted ticket emails to be sent to support email address

Edited File: /inc/connect.php
-> added domain registration on/off switch
-> added support email variable
-> added switch to turn on/off internal help desk

Edit File: /inc/whm_functions.php
-> fixed the email admin copy of reseller email
-> added new vars to EMID 10

Edited File: /client_area.php
-> added switch to turn on/off internal help desk

Edited File: /step_one.php
-> added domain registration on/off switch
-> left variable code in to turn off per GID for dedicated servers

DATABASE UPDATE:

ALTER TABLE `config` ADD `do_registrations` CHAR( 3 ) DEFAULT 'yes' NOT NULL AFTER `run_domain_expire` ;
UPDATE `email_templates` SET `attr_avail` = '{{ip}}|{{whm_username}}|{{whm_password}}|{{domain_name}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{generate_date}}|{{clientarea_username}}|{{clientarea_password}}|{{clientarea_loginlink}}|{{installed_on_server}}|{{server_location}}' WHERE `emid` = '10' LIMIT 1 ;
ALTER TABLE `config` ADD `email_admin` VARCHAR( 255 ) NOT NULL AFTER `email_support` ;
ALTER TABLE `config` ADD `activate_support` CHAR( 3 ) DEFAULT 'yes' NOT NULL AFTER `email_support` ;


(Version 2.4.15[Maintenance Release 2]) 2/2/2004 ----------------------------------------------------------------------------------

Edited File: /admin/view_batch.php
-> added invoice number to view

Edited File: /admin/client_view.php
-> added domain options to the account information section

Edited File: /admin/tools/client_view_account_info.php
-> added domain options to the account information section

Edited File: /admin/tools/client_view_domain_info.php
-> added domain options to the account information section

Edited File: /inc/invoice_functions.php
-> fixed issue with invoices not marked as paid
-> fixed bug: invoice report showing all paid instead of unpaid
-> fixed bug with domain registration and invoices not being created
-> fixed bug with 0 amounts on invoice report
-> added domain options to the account information section

Edited File: /admin/server_config.php
-> added server cost in for reporting values
-> added Server NOC name for better tracking of boxes

Edited File: /admin/server_edit.php
-> added 'active accounts' count to server display
-> added notes
-> added additional information for each server in inventory

Edited Fiel: /inc/whm_functions.php
-> expanded on server revenue report

DATABASE UPDATES:

ALTER TABLE `server_config` ADD `server_cost` FLOAT DEFAULT '0' NOT NULL AFTER `manual_install_active` ;
ALTER TABLE `server_config` ADD `server_noclocal` VARCHAR( 255 ) DEFAULT '0' NOT NULL AFTER `server_cost` ;

UPDATE `email_templates` SET `attr_avail` = '{{ip}}|{{whm_username}}|{{whm_password}}|{{domain_name}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{generate_date}}|{{clientarea_username}}|{{clientarea_password}}|{{clientarea_loginlink}}' WHERE `emid` = '10' LIMIT 1 ;


(Version 2.4.15[Maintenance Release 1]) 2/2/2004 ----------------------------------------------------------------------------------

Edited File: /admin/process_batch.php
-> fixed "read error" issue
-> fixed issue with invoices not marked as paid

Edited File: /inc/invoice_functions.php
-> fixed issue with invoices not marked as paid
-> fixed bug: invoice report showing all paid instead of unpaid

Edited File: /mail_payment.php
-> fixed issue: http://www.whmautopilot.com/forum/index.php?showtopic=3121&st=0&#entry18696

(Version 2.4.15) 1/31/2004 ----------------------------------------------------------------------------------

Edited File: /admin/index2.php
-> fixed bug - only 1 ticket showing on main page
-> fixed error in calc. total unresolved domains
-> changed the "System Stats at a Glance" "Total Records" to reflect:
(total monthly*12) + (total quarterly*4) + (total semi-annual*2) + annual

Edited File: /admin/invoice_create.php
-> added stripslashes to select box

Edited File: /admin/invoice_client_editor.php
-> fixed bug - apostrophe parsed out on updates

Edited File: /admin/cron_invoice.php
-> added line to query to force status of pending for new invoices

Edited File: /admin/process_batch.php
-> added line to query to force status of pending for new invoices
-> added code to ensure the invoice is marked as paid when it should be

Edited File: /admin/client_view.php
-> fixed bug auto create not installing parked domains

Edited File: /admin/tools/client_view_dedicated_account_info.php
-> addons now show up in client_view.php for dedicated servers

Edited File: /inc/whm_functions.php
-> changed revenue per server report

Edited File: /inc/invoice_functions.php
-> made changes to totals displayed in this report
-> domain reg. now shows up in the invoice notes section if ordered
-> fixed looping invoice history tool in cases of date issues

Edited File: /tools/credit_card_code[0].php
Edited File: /tools/credit_card_code[1].php
Edited File: /tools/credit_card_code[2].php
-> now passes in invoice number for invoice service transactions
-> added option to use cc on file from hosting and billable service order system
-> added option to use cc on file from order system

Edited File: /tools/step_two_code[0].php
-> added condition to usernames that begin with 0-9

Edited File: /tools/step_three_code[0].php
-> bug fix: added tld to domain for private ns prefix display

Edited File: /paypal_success.php
-> added error suppression

Edited File: /authnet_success.php
-> added option to use cc on file from order system

Edited File: /invoice_credit_card.php
-> added cvv2 graphic
-> added today and recurring billing amount to be displayed
-> added option to use cc on file from hosting and billable service order system

Edited File: /credit_card.php
-> added today and recurring billing amount to be displayed
-> added option to use cc on file from order system

Edited File: /invoice_hosting.php
-> added recurring back to invoice display on initial invoices

Edited File: /invoice_hosting_payable.php
-> added recurring back to invoice display on initial invoices

DATABASE UPDATES:
UPDATE `email_templates` SET `attr_avail` = '{{admin_reply_details}}|{{ticket_number}}|{{ticket_details}}|{{generate_date}}|' WHERE `emid` = '46' LIMIT 1 ;

(Version 2.4.11) 1/12/2004 -----------------------------------------------------------------------------------
*** BUG FIX RELEASE ONLY ***

Edited File: /tools/credit_card_code[0].php
Edited File: /tools/credit_card_code[1].php
Edited File: /tools/credit_card_code[2].php
-> Bug fix for eProcessing Network payment gateway.

Edited File: /admin/cron_1215.php
-> released unencrypted for all releases
**** please be sure to upload this new file ****

Edit File: /affiliate_signup.php
-> fixed function error

Edit File: /invoice_hosting.php
-> fixed parse errors

Edited File: /invoice_hosting_payable.php
-> fixed PaySystems error
-> fixed parse errors

Edited File: /invoice_service.php
-> fixed parse errors

Edited File: /cc_update
-> fixed parse errors

Edited File: /invoice_service_payable.php
-> fixed parse errors

Edited File: /tools/verify_order_code[0].php
-> fixed parse errors

Edited Language Files:
--> fixed broken language vars
--> added consistency to EMail text
/inc/languages/english.php
/inc/languages/english/affiliate_signup.php
/inc/languages/english/cc_update.php
/inc/languages/english/client_area.php
/inc/languages/english/clogin.php
/inc/languages/english/credit_card.php
/inc/languages/english/elogin.php
/inc/languages/english/step_four.php
/inc/languages/english/trouble_ticket_submit.php
/inc/languages/english/mail_payment.php
/inc/languages/english/invoice_new.php


(Version 2.4.1) 1/5/2004 -----------------------------------------------------------------------------------

Release/Upgrade Documentation: http://www.whmautopilot.com/upgrade_241.php

Edited File: /cc_update.php
-> fixed broken var for $text_goback

Edited File: /invoice_service.php
-> fixed broken var for $text_additionalinformation
-> fixed broken var for $text_readonlyinvoice
-> fixed broken var for $text_thisinvoice

Edited File: /admin/invoice_hosting_history.php
-> invoice bug fixes

Edited File: /admin/invoice_hosting_history_details.php
-> invoice bug fixes

Edited File: /admin/invoice_hosting_unpaid.php
-> invoice bug fixes

Edited File: /admin/invoice.php
-> invoice bug fixes

Edited File: /admin/invoice_hosting.php
-> invoice bug fixes

Edited File: /admin/invoice_hosting_past_due.php
-> invoice bug fixes

Edited File: /admin/invoice_hosting_paid.php
-> invoice bug fixes

Edited File: /admin/config_editor.php
-> changed radio button to a checkbox for "use enom"
-> added input for Enom "Registered IP"

Edited File: /inc/invoice_functions.php
-> invoice bug fixes

Edited File: /inc/enom_functions.php
-> now sending in the IP of the http_host to resolve IP conflicts.

Edited File: /inc/whm_functions.php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /inc/languages/english/step_two.php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /tools/step_two_code[0].php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /tools/step_two_code[1].php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /tools/step_two_code[2].php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /tools/step_two_code[3].php
-> added error checking for domains ending/beginning in - or w/ the char -

Edited File: /admin/plan_build_dedicated.php
-> Bug #0000268 enlarged text boxes

Edited File: /admin/plan_edit.php
-> Bug #0000269 changed click to edit, delete and plan link

Edited File: /admin/csv.php
-> Bug #0000271, fixed spelling errors.

Edited File: /admin/enom_incomplete.php
-> added delete option to queue management.

Edited File: /admin/process_batch.php
-> now marks invoice as paid.

Edited File: /tools/verify_order_code[0].php
-> bug fix for invoice amounts

Edited File: /inc/invoice_functions.php
-> bug fix for invoice amounts

Edited File: /inc/client_functions.php
-> bug fix for {{admin_reply_details}} not showing in admin reply
-> fixed mysql error on client reply

Edited File: /trouble_ticket_view.php
-> fixed mysql error on client reply

Edited File: /step_one_code[0].php
-> Bug #0000266 spelling error

DATABASE CHANGES:
ALTER TABLE `config` ADD `enom_ip` VARCHAR( 22 ) NOT NULL AFTER `enom_pass` ;

/*-------------------------------------------------------+
| LANGUAGE PARSED CONTRIBUTION |
| Language Files - v2.4.1 |
| translation & contribution by dotanything.net |
+-------------------------------------------------------*/

To utilize the language options in your links, call your order
pages in this fashion:

step_one.php?Language=english
or
step_one.php?Language=spanish

If you do not call in a language, the script will use your default
language set in the configuration area of the script.

You are welcome to copy the language files and create your own
local language to be utilized in the script. Once created, you
would upload the matching files ( renamed to your local lang )
up to the /languages folder and then call the same way.

Ex:
Created files and folder for /german
---> upload to /languages your /german.php and /german folder

Then:

step_one.php?Language=german

Will set that as the users local language or you can set it as
the scripts default langauge at the admin 'Edit Configuration' area.

Any questions, feel free to comment in the forums and thank [e-mail]
for this wonderful contribution.

(Version 2.4.0) 12/24/2003 -----------------------------------------------------------------------------------

Release/Upgrade Documentation: http://www.whmautopilot.com/upgrade_240.php

Edited File: /admin/config_editor.php
-> enom integration

Edited File: /admin/themes/blue/main_general_block.php
-> enom integration

Edited File: /inc/connect.php
-> enom integration

Edited File: /inc/whm_functions.php
-> added {email_address} to emid=43
-> added additional checks to IP functions

Edited File: /inc/select.php
-> enom integration

Edited File: /inc/languages/english/step_four.php
-> enom integration

Edited File: /inc/whois.php
-> added .au to whois

Edited File: /tools/step_four_code[0].php
-> enom integration

Edited File: /tools/step_two_code[3].php
-> added .au to whois, changed domain format

Edited File: /tools/step_two_code[0].php
-> added .au to whois, changed domain format

Edited File: /step_four.php
-> enom integration

Edited File: /paypal_success.php
-> enom integration

Edited File: /2checkout_success.php
-> enom integration

Edited File: /authnet_success.php
-> enom integration

Edited File: /worldpay_success.php
-> enom integration

Edited File: /authnet_success.php
-> enom integration

ADDED FILE: /inc/tpp_pro_functions.php
-> enom integration

ADDED FILE: /register_enom.php
-> enom integration

ADDED FILE: /admin/enom_incomplete.php
-> enom integration

DATABASE:
ALTER TABLE `config` ADD `enom_user` VARCHAR( 255 ) NOT NULL , ADD `enom_pass` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `config` ADD `use_enom` INT( 1 ) DEFAULT '0' NOT NULL AFTER `resolve_works` ;
ALTER TABLE `session_history` ADD `sorp` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `hosting_order` ADD `sorp` INT( 1 ) DEFAULT '0' NOT NULL ;

INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES (47, 'Admin Domain Registration E-mail', 'eNom Domain Registration - {{domain_name}}', 'Hello, Below are the results of an automated registration through your eNom account. Order ID: {{enom_order_id}} Response: {{enom_response_code}} Domain Name: {{domain_name}} Domain Expiration: {{expiration_date}} * approximate date Registrant Information: {{first_name}} {{last_name}} {{address_1}} {{address_2}} {{city}} {{state}} {{zip}} {{country}} {{phone}} {{fax}} If this registration was successful, there are no actions needed on your part. If there was an error given in the response above, manual registration may need to be completed for this domain. Thank You Your AutoPilot Message Generated on: {{generate_date}}', '{{domain_name}}|{{enom_order_id}}|{{enom_response_code}}|{{expiration_date}}|{{first_name}}|{{last_name}}|{{address_1}}|{{address_2}}|{{city}}|{{state}}|{{country}}|{{zip}}|{{phone}}|{{fax}}|{{generate_date}}|', '');
UPDATE `email_templates` SET `attr_avail` = '{{domain_name}}|{{generate_date}}|{{first_name}}|{{last_name}}|{{domain_reg_price}}|{{company_name}}|{{address_1}}|{{address_2}}|{{city}}|{{state}}|{{zip}}|{{phone}}|{{fax}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{email_address}}|' WHERE `emid` = '43' LIMIT 1 ;

(Version 2.3.13) 12/09/2003 -----------------------------------------------------------------------------------

Release/Upgrade Documentation: http://www.whmautopilot.com/upgrade_2313.php

Edited File: /admin/tools/client_view_domain_info.php
-> added note about domain reg status to client view

Edited File: /admin/master_batch.php
-> changed how cc updates work
-> fixed issue with cc # not sticking

Edited File: /admin/cron_1215.php
-> removed the call to run cron_authnet.php
*** cron_authnet.php should be deleted from admin ***

Edited File: /admin/trouble_ticket_active.php
-> moved support emails from the code to templates

Edited File: /inc/whm_functions.php
-> fixed issue with dedicated IP not auto installing
-> fixed replicating revenue report
-> fixed the .5 bug in account stats

Edited File: /inc/client_functions.php
-> added new parsable objects
-> now sending cron resolver email report
-> fixed redundant data in monthly revenue report
-> moved support emails from the code to templates

Edited File: /inc/auth_functions.php
-> country not sticking for master cc updates

Edited File: /inc/verify_order_code[0].php
-> support for multi year domains
-> issue with https resolved

Edited File: /tools/verify_order_code[0].php
-> changed paypal 'cancel' return to /step_one.php
-> fixed worldpay callback with https:// issues

Edited File: /trouble_ticket_submit.php
-> moved support emails from the code to templates

Edited File: /trouble_ticket_view.php
-> moved support emails from the code to templates

Edited File: /verify_order.php
-> support for multi year domains

Edited File: /cc_update.php
-> changed how cc updates work
-> fixed issue with cc # not sticking

Edited File: /invoice_service_payable.php
-> fixed worldpay callback with https:// issues
-> fixed issue with $currency in paypal
-> changed paypal 'cancel' return to go to /step_one.php

DATABASE UPDATES:

INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('44', 'Support Ticket Opened by Client', '{{first_name}} {{last_name}} has opened a new support ticket [ Ticket # {{ticket_number}} ]', 'Hello, A new support request has been logged by a user. Here are the details: Ticket #{{ticket_number}} --------------------------- {{ticket_details}} --------------------------- Please login to your admin area to respond to this ticket. Thank you. Your AutoPilot Generated on {{generate_date}}', '{{first_name}}|{{last_name}}|{{ticket_number}}|{{ticket_details}}|{{generate_date}}|', '');
INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('45', 'Client Reply to Support Ticket', '{{first_name}} {{last_name}} has replied to ticket [ Ticket # {{ticket_number}} ]', 'Hello, A response from the client has been made on the following ticket, details below: Here are the details: Ticket #{{ticket_number}} --------------------------- {{ticket_details}} --------------------------- Please login to your admin area to respond to this ticket. Thank you. Your AutoPilot Generated on {{generate_date}}', '{{first_name}}|{{last_name}}|{{ticket_number}}|{{ticket_details}}|{{generate_date}}|', '');
INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('46', 'Admin Reply to Support Ticket', '[ Ticket # {{ticket_number}} ] Reply to support ticket', 'Hello, Below is the tech reply to your support request Ticket #{{ticket_number}} --------------- {{admin_reply_details}} --------------- Please do not reply directly to this email but login to your client area and update your request from your ticket management area in that location. If you feel this reply resolved your situation, please be sure to close your ticket from your client area. Thank You. Support Team Generated on {{generate_date}}', '{{last admin_reply_details}}|{{ticket_number}}|{{ticket_details}}|{{generate_date}}|', '');

(Version 2.3.12) 11/25/2003 -----------------------------------------------------------------------------------

Release/Upgrade Documentation: http://www.whmautopilot.com/upgrade_2313.php

Edited File: /admin/tools/authnet_batch.php
-> changed how cc updates work

Edited File: /admin/view_batch.php
-> changed how cc updates work

Edited File: /admin/master_batch.php
-> changed how cc updates work

Edited File: /admin/process_batch.php
-> changed how cc updates work

Edited File: /admin/cron_authnet.php
-> changed how cc updates work

Edited File: /admin/cron_authnet.php
-> now sending cron resolver email report

Edited File: /tools/billable_service_history.php
-> fixed broken sql query

Edited File: /tools/credit_card_code[0].php
-> changed how cc updates work

Edited File: /tools/credit_card_code[1].php
-> changed how cc updates work

Edited File: /tools/credit_card_code[2].php
-> changed how cc updates work

Edited File: /inc/client_functions.php
-> added new parsable objects
-> now sending cron resolver email report

Edited File: /inc/client_functions.php
-> fixed redundant data in monthly revenue report

Edited File: /invoice_new.php
-> added support for new domain registration system

Edited File: /cc_update.php
-> changed how cc updates work

Edited File: /invoice_credit_card.php
-> changed how cc updates work

Edited File: /authnet_success.php
-> changed how cc updates work

DATABASE UPDATES:
CREATE TABLE `authnet_master_cc` (
`ccid` bigint(22) unsigned NOT NULL auto_increment,
`customer_first_name` varchar(255) NOT NULL default '',
`customer_last_name` varchar(255) NOT NULL default '',
`customer_address` varchar(255) NOT NULL default '',
`customer_city` varchar(255) NOT NULL default '',
`customer_state` varchar(255) NOT NULL default '',
`customer_zip` varchar(255) NOT NULL default '',
`customer_country` varchar(255) NOT NULL default '',
`customer_phone` varchar(25) NOT NULL default '',
`customer_fax` varchar(25) NOT NULL default '',
`customer_email` varchar(255) NOT NULL default '',
`card_info` text NOT NULL,
`ogcreate` varchar(40) NOT NULL default '',
`uid` bigint(22) NOT NULL default '0',
`master_cc` int(1) NOT NULL default '0',
PRIMARY KEY (`ccid`)
) TYPE=MyISAM COMMENT='Authorize.net master cc data' AUTO_INCREMENT=1 ;

ALTER TABLE `authnet_batch` ADD `ccid` BIGINT( 22 ) NOT NULL AFTER `uid` ;


11/25/2003 -----------------------------------------------------------------------------------

Edited File: /admin/themes/blue/header.php
-> reworked Recurring Revenue Per Server Report

Edited File: /admin/domain_specs.php
-> added 5 and 10 year registration periods

Edited File: /admin/client_view.php
-> added support for switch to invoice separately for domains

Edited File: /admin/manage_session_history.php
-> pre-populate IP and NS info in client view
-> fixed issue with tld/sld not being added

Edited File: /inc/whm_functions.php
-> set timeout to 8 seconds for curl transactions
-> fixed resolver display issue
-> reworked Recurring Revenue Per Server Report

Edited File: /inc/client_functions.php
-> fixed resolver display issue

Edited File: /tools/step_two_code[0].php
-> new whois functions

Edited File: /tools/step_two_code[3].php
-> added 5 and 10 year registration periods

Edited File: /paypal_success.php
-> fixed logic error when checking for unique IP that came into play with the pre-population of IP and NS1/NS2

Edited File: /2checkout_success.php
-> fixed logic error when checking for unique IP that came into play with the pre-population of IP and NS1/NS2

Edited File: /tpp_pro_success.php
-> fixed logic error when checking for unique IP that came into play with the pre-population of IP and NS1/NS2

Edited File: /authnet_success.php
-> fixed logic error when checking for unique IP that came into play with the pre-population of IP and NS1/NS2

Edited File: /worldpay_success.php
-> fixed logic error when checking for unique IP that came into play with the pre-population of IP and NS1/NS2

Edited File: /verify_order.php
-> switched out the text for "* Will be billed separately."

Edited File: /step_two.php
-> switched out the text for "* Will be billed separately."

Added File: /inc/whois.php

DATABASE:
UPDATE `email_templates` SET `subject` = 'Recurring Revenue per Server Report', `message` = '================================================= RECURRING REVENUE PER SERVER FOR {{site_name}} ================================================= {{server_details}} This message was generated on: {{generate_date}}' WHERE `emid` = '30' LIMIT 1 ;
ALTER TABLE `config` CHANGE `domain_fee` `domain_fee` INT( 1 ) DEFAULT '0' NOT NULL

11/21/2003 -----------------------------------------------------------------------------------

Edited File: /admin/client_view.php
-> removed debugging from the production release

Edited File: /admin/coupon_build.php
-> fixed issue with coupon deletion

Edited File: /admin/domain_specs.php
-> added 1 or 2 year domain flag

Edited File: /admin/config_editor.php
-> added switch to config area to charge domain fees at order time or invoice later - defaults to charge at order time.
** Note: You will need to edit the wording of the last paragraph in emid: 43 email template to reflect your choice

Edited File: /inc/client_functions.php
-> added switch to config area to charge domain fees at order time or invoice later - defaults to charge at order time.
** Note: You will need to edit the wording of the last paragraph in emid: 43 email template to reflect your choice

Edited File: /inc/languages/english/step_two.php
-> added 1 or 2 year domain flag

Edited File: /tools/step_two_code[3].php
-> added 1 or 2 year domain flag

Edited File: /client_area.php
-> fixed issue with "if domain resolved, should send EMID 2 instead of EMID 10"

Edited File: /paypal_success.php
-> fixed issue with empty variables in the domain registration email
-> pre-populate IP and NS info in client view

Edited File: /2checkout_success.php
-> fixed issue with empty variables in the domain registration email
-> pre-populate IP and NS info in client view

Edited File: /tpp_pro_success.php
-> fixed issue with empty variables in the domain registration email
-> pre-populate IP and NS info in client view

Edited File: /authnet_success.php
-> fixed issue with empty variables in the domain registration email
-> pre-populate IP and NS info in client view

Edited File: /worldpay_success.php
-> fixed issue with empty variables in the domain registration email
-> pre-populate IP and NS info in client view

DATABASE UPDATES:
ALTER TABLE `tld_chart` ADD `reg_period` INT( 1 ) DEFAULT '1' NOT NULL AFTER `cost` ;

11/21/2003 -----------------------------------------------------------------------------------

Edited File: /inc/whm_functions.php
-> fixed issue with CGI not being configured correctly on new installs.
-> resolver rewrite
-> added domain registration functions
-> fixed bug #0000212

Edited File: /inc/client_functions.php
-> added function to check for exec nslookup capabilities
-> resolver rewrite
-> fixed 2.3.0 issue with empty dns/dns IP for emid 1
-> added domain registration functions
-> fixed bug #0000219

Edited File: /admin/client_view.php
-> fixed email sent when unexpected bug for dedicated servers

Edited File: /admin/client_email.php
-> added stripslashes() to outgoing email

Edited File: /admin/plan_build_dedicated.php
-> added htmlentities() for textarea £ now stays £ instead of Ł

Edited File: /admin/plan_build.php
-> added htmlentities() for textarea £ now stays £ instead of Ł

Edited File: /admin/invoice_hosting_history.php
-> send payable invoice works now

Edited File: /admin/themes/blue/header.php
-> added domain registration functions

Edited File: /admin/config_editor.php
-> added new resolver functions

Edited File: /admin/resolver.php
-> resolver rewrite

Edited File: /admin/cron_resolver.php
-> resolver rewrite

Edited File: /admin/group_editor.php
-> tweaked reseller functions

Edited File: /admin/cron_1215.php
-> consolidated cron job

Edited File: /admin/client_view.php
-> fixed path bug

Edited File: /tools/step_one_code[0].php
-> added domain registration functions

Edited File: /tools/step_two_code[0].php
-> added domain registration functions

Edited File: /tools/verify_order_code[0].php
-> added domain registration functions

Edited File: /tools/billable_service_history.php
-> Fixed bug with non hosting clients billable service invoices not showing up.

Edited File: /inc/languages/english/step_two.php
-> added domain registration functions

Edited File: /inc/whm_functions.php
-> fixed csv issue for imports

Edited File: /step_one.php
-> added domain registration functions

Edited File: /step_two.php
-> added domain registration functions

Edited File: /paypal_success.php
-> tweaked reseller functions
-> added domain registration functions

Edited File: /tpp_pro_success.php
-> tweaked reseller functions
-> added domain registration functions

Edited File: /authnet_success.php
-> tweaked reseller functions
-> added domain registration functions

Edited File: /2checkout_success.php
-> tweaked reseller functions
-> added domain registration functions

Edited File: /worldpay_success.php
-> tweaked reseller functions
-> added domain registration functions

Edited File: /admin/client_view.php
-> Added the pull in for display of client IP
-> Added the pull in for display of client ISP

Edited File: /admin/payment_process.php
-> removed extra space in worldpay callback

Edited File: /admin/tools/authnet_batch.php
-> fixes some issues with batch creation

Edited File: /invoice_hosting.php
-> changed var from address_1 to address_2 now displays proper address_2 variable

Edited File: /invoice_hosting_payable.php
-> changed var from address_1 to address_2 now displays proper address_2 variable

Edited File: /invoice_service.php
-> changed var from address_1 to address_2 now displays proper address_2 variable

Edited File: /invoice_service_payable.php
-> changed var from address_1 to address_2 now displays proper address_2 variable

Edited File: /admin/tools/client_view_info.php
-> removed IF statement for display of address_2 now displays blank field for editing if needed
Also added new display info to display client IP and track the IP address using free lookup provided by ripe.net
Added display of client ISP host as well

Edited File: /admin/tools/client_view_info.php
-> extended ZIP field to 10 for longer zipcodes

Edited File: /admin/trouble_ticket_active.php
-> changed secure_path to http_web

Edited File: /admin/trouble_ticket_close.php
-> changed secure_path to http_web

Edited File: /admin/invoice_create.php
-> extended size and maxlenght values to accomodate longer vars (i.e. 0.0175)
changed sprintf("%01.2 to sprintf("%01.4 to display longer decimal values

Edited File: /credit_card.php
-> changed states dropdown to text input field

Edited File: /cc_update
-> changed states dropdown to text input field

Edited File: /admin/themes/blue/images/cvv-pic-3cards.gif
-> ** this displays on credit_card.php only **

Edited File: /credit_card.php
-> combined phone / fax to 1 input box

Edited File: /tools/credit_card_code[0].php
-> combined phone / fax to 1 input box

Edited File: /credit_card.php
-> combined phone / fax to 1 input box

Edited File: /cc_update.php
-> combined phone / fax to 1 input box

Edited File: /tools/credit_card_code[1].php
-> combined phone / fax to 1 input box

Edited File: /tools/credit_card_code[2].php
-> combined phone / fax to 1 input box

Edited File: /admin/master_batch.php
-> combined phone / fax to 1 input box

Added File: /admin/domain_specs.php
-> added domain registration functions

Added File: /admin/cron_1215.php
-> cron consolidation

Added File: /tools/step_two_code[1].php
-> added domain registration functions

Added File: /tools/step_two_code[2].php
-> added domain registration functions

Added File: /tools/step_two_code[3].php
-> added domain registration functions

Added:
{{clientarea_password}}
{{clientarea_username}}
{{clientarea_loginlink}} vars to EMID 10

DATABASE:
CREATE TABLE `tld_chart` (
`tld_id` BIGINT( 22 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tld` VARCHAR( 8 ) NOT NULL ,
`cost` FLOAT NOT NULL ,
PRIMARY KEY ( `tld_id` )
);

ALTER TABLE `session_history` ADD `tld` VARCHAR( 23 ) NOT NULL AFTER `domain_name` ;
ALTER TABLE `hosting_order` CHANGE `domain_lock` `domain_lock` INT( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `hosting_order` ADD `tld_id` BIGINT( 22 ) NOT NULL AFTER `domain_registration` ;
INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('', 'Domain Registration Notice', 'Domain Registration Requested for {{domain_name}}', 'Hello Admin, On, {{generate_date}}, {{first_name}} {{last_name}} ordered hosting that included the registration of a domain name. Domain: {{domain_name}} Cost Agreed: {{domain_reg_price}} Registrant Information: {{first_name}} {{last_name}} {{company_name}} {{address_1}} {{address_2}} {{city}} {{state}}, {{zip}} {{phone}} {{fax}} Please register this domain for the client immediately and make sure the nameservers placed in at the time of order are: {{primary_ns}} {{primary_ns_ip}} {{secondary_ns}} {{secondary_ns_ip}} This client has NOT been charged for this domain registration. Please login to your admin area after successful registration and invoice the client from your non-hosting products area for this registration. Thank you. Your AutoPilot Message Generated on: {{generate_date}}', '{{domain_name}}|{{generate_date}}|{{first_name}}|{{last_name}}|{{domain_reg_price}}|{{company_name}}|{{address_1}}|{{address_2}}|{{city}}|{{state}}|{{zip}}|{{phone}}|{{fax}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|', '');
ALTER TABLE `hosting_order` ADD `client_host` VARCHAR( 255 ) NOT NULL AFTER `client_ip` ;
UPDATE `email_templates` SET `attr_avail` = '{{ip}}|{{whm_username}}|{{whm_password}}|{{domain_name}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{generate_date}}|{{clientarea_username}}|{{clientarea_password}}|{{clientarea_loginlink}}' WHERE `emid` = '10' LIMIT 1 ;

10/29/2003 -----------------------------------------------------------------------------------

Edited File: /admin/client_view.php
-> fixed can't update domain status via client_view.php

Edited File: /admin/invoice_create.php
-> fixed overlib issue

Edited File: /tools/step_one_code[0].php
-> put space in between dollar amount and currency type

Edited File: /tools/step_two_code[0].php
-> fixed coupon / navigation issue / addons not displaying on order system

Edited File: /tools/step_four_code[0].php
-> fixed coupon / navigation issue / addons not displaying on order system

Edited File: /inc/whm_functions.php
-> tweaked whm username generation

Edited File: /inc/client_functions.php
-> resolved gethostbyname() failure in unresolved email functions

Edited File: /invoice_service_payable
-> non-hosting invoices is using USD as default

Edited File: /invoice_hosting_payable.php
-> added note for one time fees

10/24/2003 -----------------------------------------------------------------------------------

Final Release:
/inc/invoice_functions.php
-> updating invoice from client_view.php now updates the domain name on the invoice
-> invoice math fixes
-> report conditions added

/inc/whm_functions.php
-> updated functions list_accounts()
-> updated to remove '-' from usernames before account creation on server

/inc/client_view.php
-> updating invoice from client_view.php now updates the domain name on the invoice

/admin/tools/client_view_account_info.php
-> overlib issues

/admin/tools/client_view_dedicated_account_info.php
-> overlib issues

/admin/addon_edit.php
-> overlib issues

/admin/addon_group_editor.php
-> overlib issues

/admin/invoice_hosting_history.php
-> past invoice creation tool

/admin/themes/blue/header.php
-> past invoice creation tool

ADDED FILE:
/admin/invoice_create_per_client.php
-> past invoice creation tool

-----------------------------------------------------------------------------------

Day 2 Changes:
/admin/invoice_hosting_paid.php
-> overlib issues

/admin/invoice_hosting_unpaid.php
-> overlib issues

/admin/invoice_hosting_past_due.php
-> overlib issues

/admin/addon_group_editor.php
-> overlib issues

/admin/addon_edit.php
-> overlib issues

/admin/tools/client_view_account_info.php
-> overlib issues
-> added pagination support

/admin/tools/client_view_dedicated_account_info.php
-> overlib issues
-> added pagination support

/admin/tools/client_view_domain_info.php
-> added pagination support

/admin/tools/client_view_info.php
-> added pagination support

/admin/tools/client_view_complete_inc.php
-> added pagination support

/admin/tools/client_view.php
-> added pagination support

/admin/client_management.php
-> resolved bug #0000178 to do with next due date on inital invoices for manually created accounts

/admin/manage_session_history.php
-> incomplete orders now create invoices

/invoice_hosting.php
-> fixed adding of recurring fee to total invoice amount display
-> added pagination support

/invoice_hosting_payable.php
-> fixed adding of recurring fee to total invoice amount display

/authnet_success.php
-> fixed query bug

/admin/cron_invoice.php
-> added in past invoice creation support

/admin/invoice_hosting_unpaid.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by domain

/admin/invoice_hosting_paid.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by domain

/admin/invoice_hosting_past_due.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by domain

/admin/invoice_hosting_history.php
-> order by invoice number desc
-> added delete
-> added pagination support

/admin/invoice_create.php
-> added pagination support

/admin/invoice_hosting_history_details.php
-> added pagination support

/admin/invoice_client_editor.php
-> display change

/admin/invoice_pending.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by user

/admin/invoice_past_due.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by user

/admin/invoice_paid.php
-> order by invoice number desc
-> added delete
-> added pagination support
-> added display by user

/admin/invoice_hosting.php
-> added domain name to invoice editor

/invoice_hosting.php
-> fixed several date issues and made the created date editable

/tools/client_view_account_info.php
-> wrote back in a bug fix for the sql error.

/tools/verify_order_code[0].php
-> logs transaction ID now

/inc/invoice_functions.php
-> added pagination support

/authnet_success.php
-> logs transaction ID now

/paypal_success.php
-> logs transaction ID now

/tpp_pro_success.php
-> logs transaction ID now

/worldpay_success.php
-> fixed date issues

/2checkout_success.php
-> logs transaction ID now

/invoice_success_service.php
-> logs transaction ID now

/invoice_success_service.php
-> logs transaction ID now

/tools/credit_card_code[0].php
-> logs transaction ID now

/tools/credit_card_code[1].php
-> logs transaction ID now

/tools/credit_card_code[2].php
-> logs transaction ID now

/inc/invoice_functions.php
-> logs transaction ID now

/admin/invoice_create.php
-> logs transaction ID now

/admin/invoice_hosting.php
-> logs transaction ID now

/admin/invoice_hosting_history_details.php
-> logs transaction ID now

/invoice_success.php
-> logs transaction ID now

/client_area.php
-> changed the billable service view

/billing_history.php
-> changed the billable service view

ADDED IMAGES:
/admin/themes/blue/images/x.gif
/admin/themes/blue/images/x_.gif

ADDED FILE:
/tools/billable_service_history.php
-> changed the billable service view

/admin/create_past_invoices.php
-> creates past invoices for all of your clients & logs the last run to /mib_data/create_past_invoice[random #].log

DATABASE CHANGES:
ALTER TABLE `invoice` ADD `txn_id` VARCHAR( 255 ) NOT NULL AFTER `payment_method` ;
ALTER TABLE `authnet_batch` ADD `txn_id` VARCHAR( 255 ) NOT NULL AFTER `bid` ;
ALTER TABLE `hosting_order` ADD `txn_id` VARCHAR( 255 ) NOT NULL AFTER `uid` ;

Day 1 Changes:
/admin/invoice_create.php
-> removed words: future pay
-> displays date paid now
-> error showing all billable services on an invoice.
-> added tax/vat support display options in invoice
-> added support for non hosting clients

/admin/tools/themes/blue/header.php
-> added report for billable services

/admin/cron_invoice.php
-> added report for billable services
-> new invoices for existing clients are now created x amount of time before the due date
configured in the config editor.

/admin/client_view.php
-> fixed date bug affecting account create date when updating domain info - Thanks Steve
-> deleting an account now deletes the invoice too
-> added support for dedicated next due date

/admin/tools/client_view_account_info.php
-> changed MIB to AutoPilot

/admin/tools/client_view_dedicated_account_info.php
-> added support for dedicated next due date

/admin/tools/client_management_errors_inc.php
-> must enter a domain to continue

/admin/client_management.php
-> logic changes

/admin/add_new_client.php
-> logic changes

/admin/invoice_hosting.php
-> Fixed invalid paid date/losing creation date when manually marking an invoice as paid.

/admin/invoice_hosting.php
-> added ability to view non hosting users

/admin/invoice_hosting_history.php
-> added invoice amount to listings

/admin/invoice_hosting_paid.php
-> added invoice amount to listings

/admin/invoice_hosting_unpaid.php
-> added invoice amount to listings

/admin/invoice_hosting_past_due.php
-> added invoice amount to listings

/admin/invoice_pending.php
-> added invoice amount to listings

/admin/invoice_past_due.php
-> added invoice amount to listings

/admin/invoice_paid.php
-> added invoice amount to listings

/admin/csv_add_user_accounts.php
-> date bug fixed

/admin/csv_add_reseller_accounts.php
-> date bug fixed

/admin/tools/csv_server.php
-> date bug fixed

/admin/csv_server.php
-> date bug fixed

/admin/config_editor.php
-> Added support for user created languages

/tools/verify_order_code[0].php
-> added invoice support for mail in orders

/inc/client_functions.php
-> language dir scan function added

/inc/invoice_functions.php
-> added reporting functions

/verify_order.php
-> added invoice support for mail in orders

/invoice_service.php
-> added tax/vat support

/invoice_service_payalbe.php
-> added tax/vat support

ADDED FILE:
/admin/reports_daily_invoice_service.php
-> needed report for billable services

/admin/invoice_non_hosting_clients.php
-> added ability to view non hosting users

/admin/invoice_client_editor.php
-> added ability to view non hosting users

/admin/invoice_non_hosting_client_summary.php
-> added ability to view non hosting users

DATABASE:
ALTER TABLE `invoice` ADD `tax_type` VARCHAR( 3 ) NOT NULL AFTER `charge_tax` ;
ALTER TABLE `config` CHANGE `domain_fee` `domain_fee` FLOAT NOT NULL;
INSERT INTO `email_templates` (`emid`, `name`, `subject`, `message`, `attr_avail`, `default_email`) VALUES (42, 'Daily Billable Service Invoice Summary Report', 'Daily Invoice Summary Report', 'Hello,\r\n\r\nBelow is a list of billable service invoices in the system that are either past due or unpaid past due.\r\n\r\n*** UnPaid and Past Due Invoices as of {{generate_date}} Seperated by Payment Gateway ***\r\n\r\n{{mail_in_summary}}{{paypal_summary}}{{paysystems_summary}}{{authorize.net_summary}}{{2checkout}}{{worldpay_summary}}', '{{generate_date}}|{{mail_in_summary}}|{{paypal_summary}}|{{paysystems_summary}}|{{authorize.net_summary}}|{{2checkout}}|{{worldpay_summary}}|', '');

##~~~~
## START Release Version R2.2.3 - 10/04/2003 ---------------------------------------------------------
##~~~~

UPGRADE INSTRUCTIONS

[Start Developer's Opinion]

You should install this update as a brand new fresh install in a new directory.

If you do choose to upgrade your installed copy, you need to make backups.

[End Developer's Opinion]

STEP 1
1. upload this new file: /public_html/admin/config_editor.php
2. upload this file: /public_html/admin/themes/blue/main_general_block.php
3. Run the database changes below
4. Log into AutoPilot
5. in "General Administration Links", click "Edit WHM AutoPilot Configuration"
6. Once there, complete all fields and "Save Changes"
7. edit var.php to look like this, basically taking out everything except the db connection variable:

$dbhost="localhost";
$dbuser="benchmar_admin";
$dbpass="digger";
$db="benchmar_autopilot";
?>

8. Continue to "STEP 2" below

STEP 2
1. Backup your database just before attempting any of "STEP 2".
2. Make sure you have the following folder: /public_html/mib_data/dbbackup chmod'ed 0777
3. Only run this file one (1) time in your web browser: http://yourwebsite.com/autopilot/admin/convert_mysql2unix.php
3a. VERY IMPORTANT: once you load the above file do not hit the stop or refresh buttons in your browser - just let it run.
4. Once this is successful, move to "REQUIRED UPDATES:" below:

REQUIRED UPDATES:
1. all files in /public_html/admin area
2. all files in /public_html/tools
3. in /public_html/inc update the following
- affiliate_functions.php
- auth_functions.php
- client_functions.php
- login_functions.php
- whm_functions.php
4. in /public_html update the following
- client_view.php
- invoice_new.php
- mail_payment.php
- trouble_ticket_view.php
- affiliate.php
- affiliate_signup.php
- affiliate_view.php
- authnet_success.php
- cancel_account.php
- cc_update.php
- new_affiliate.php
- 2checkout_success.php
- paypal_success.php
- tpp_pro_success.php
- trouble_ticket_submit.php
- trouble_ticket_view.php
5. For the following files, only 1 line of code changed, on line 2 of each file was changed:

from: include $server_inc."/connect.php";
to: include "inc/connect.php";

- elogin.php
- cancel_revoke.php
- client_area.php
- clogin.php
- credit_card.php

6. + all other files in this changelog for the current release.


Deleted files:
/public_html/admin/tools/client_management_server_form_inc.php
/public_html/admin/tools/client_management_addon_form_inc.php
/public_html/admin/tools/client_management_complete_na_inc.php
/public_html/admin/tools/client_management_complete_inc.php
/public_html/admin/tools/client_management_dedicated_account_info.php


DATABASE CHANGES:
INSERT INTO `email_templates` VALUES ('38', 'Invoice Ready Notification to Client ', 'Your Invoice is Ready', 'Greetings {{first_name}}, Please visit the URL to view and pay this invoice. {{pay_link}} Thanks, Web Support Team This email was generated on: {{generate_date}}', '{{first_name}}|{{pay_link}}|{{generate_date}}|', '');
INSERT INTO `email_templates` VALUES ('37', 'Invoice Paid Successfully', 'Invoice #{{invoice_number}} was paid successfully!', 'Greetings, On {{date_paid}}, {{first_name}} {{last_name}} paid invoice #{{invoice_number}} in the amount of {{total_invoice_amount}}. Please visit your AutoPilot for the invoice details. Thanks Your AutoPilot This email was generated on: {{generate_date}}', '{{invoice_number}}|{{date_paid}}|{{first_name}}|{{last_name}}|{{total_invoice_amount}}|', '');
INSERT INTO `email_templates` VALUES ('39', 'Invoice Due in X Days Notice', 'Your account is due in {{days_until_due}}', 'Greetings {{first_name}}, Your account, {{domain_name}}, is due in {{days_until_due}} and will be billed for {{total_recuur}} via {{payment_processor}}. No action is required on your part, this is just a reminder. Thanks, Web Support Team This email was generated on: {{generate_date}}', '{{days_until_due}}|{{first_name}}|{{domain_name}}|{{total_recuur}}|{{payment_processor}}|{{generate_date}}|', '');
INSERT INTO `email_templates` VALUES ('40', 'Incomplete Order Notification', 'You have incomplete orders', 'Hello, You currently have {{incomplete_orders}} order(s) in the incomplete orders area of your AutoPilot. Please login to your admin area to view/process these orders. Thank you. Your AutoPilot This message was generated on: {{generate_date}}', '{{incomplete_orders}}|{{generate_date}}|', '');
INSERT INTO `email_templates` VALUES ('41', 'Daily Invoice Summary Report', 'Daily Invoice Summary Report', 'Hello,\r\n\r\nBelow is a list of hosting order invoices in the system that are either past due or unpaid past due.\r\n\r\nPlease login to your admin area and go to the invoice management area to update the status of these invoices.\r\n\r\nSome of these may have just rotated into a new billing cycle and have been billed by the proper gateway. If this has\r\nhappened, verify payment was made at the gateway and update the invoice as paid in your system. Marking them as paid\r\nwill reset the next due date accordingly for the hosting order.\r\n\r\n*** Past Due Invoices as of {{generate_date}} Seperated by Payment Gateway ***\r\n\r\n{{mail_in_summary}}{{paypal_summary}}{{paysystems_summary}}{{authorize.net_summary}}{{2checkout}}{{worldpay_summary}}', '{{generate_date}}|{{mail_in_summary}}|{{paypal_summary}}|{{paysystems_summary}}|{{authorize.net_summary}}|{{2checkout}}|{{worldpay_summary}}|', '[e-mail]');
ALTER TABLE `user` ADD `rsid` VARCHAR( 32 ) NOT NULL AFTER `sid` ;
DROP TABLE `session`

CREATE TABLE `config` (
`license` text NOT NULL,
`site_title` varchar(255) NOT NULL default '',
`site_name` varchar(255) NOT NULL default '',
`balance_required_for_payment` int(6) NOT NULL default '0',
`currency` char(1) NOT NULL default '',
`currency_type` varchar(4) NOT NULL default '',
`domain_fee` int(2) NOT NULL default '0',
`resolve_server` varchar(255) NOT NULL default '',
`run_domain_expire` char(3) NOT NULL default '',
`http_web` varchar(255) NOT NULL default '',
`server_root` varchar(255) NOT NULL default '',
`below_public` varchar(255) NOT NULL default '',
`default_reseller_cpanel_theme` varchar(255) NOT NULL default '',
`theme` varchar(255) NOT NULL default '',
`strong_security` char(2) NOT NULL default '',
`phpbb_active` char(2) NOT NULL default '',
`input_style` varchar(255) NOT NULL default '',
`button_style` varchar(255) NOT NULL default '',
`copyright` varchar(255) NOT NULL default '',
`get_mib_news` varchar(255) NOT NULL default '',
`email_support` varchar(255) NOT NULL default '',
`http_web_tools` varchar(255) NOT NULL default '',
`http_admin` varchar(255) NOT NULL default '',
`http_admin_tools` varchar(255) NOT NULL default '',
`http_images` varchar(255) NOT NULL default '',
`server_backup` varchar(255) NOT NULL default '',
`resolver_log` varchar(255) NOT NULL default '',
`server_tools` varchar(255) NOT NULL default '',
`server_admin_inc` varchar(255) NOT NULL default '',
`server_inc` varchar(255) NOT NULL default '',
`server_admin` varchar(255) NOT NULL default '',
`server_admin_tools` varchar(255) NOT NULL default '',
`local_lang` varchar(255) NOT NULL default 'english',
`invoice_notice_period` int(11) NOT NULL default '0',
`tos_agreement` varchar(255) NOT NULL default '',
`session_expire` int(3) NOT NULL default '36',
KEY `site_title` (`site_title`),
KEY `site_name` (`site_name`),
KEY `currency` (`currency`),
KEY `currency_type` (`currency_type`),
KEY `domain_fee` (`domain_fee`),
KEY `resolve_server` (`resolve_server`),
KEY `run_domain_expire` (`run_domain_expire`),
KEY `http_web` (`http_web`),
KEY `server_root` (`server_root`),
KEY `server_deploy` (`below_public`),
KEY `default_reseller_cpanel_theme` (`default_reseller_cpanel_theme`),
KEY `theme` (`theme`),
KEY `strong_security` (`strong_security`),
KEY `phpbb_active` (`phpbb_active`),
KEY `input_style` (`input_style`),
KEY `button_style` (`button_style`),
KEY `copyright` (`copyright`),
KEY `get_mib_news` (`get_mib_news`),
KEY `email_support` (`email_support`),
KEY `http_web_tools` (`http_web_tools`),
KEY `http_admin` (`http_admin`),
KEY `http_admin_tools` (`http_admin_tools`),
KEY `http_images` (`http_images`),
KEY `server_backup` (`server_backup`),
KEY `resolver_log` (`resolver_log`),
KEY `server_tools` (`server_tools`),
KEY `server_admin_inc` (`server_admin_inc`),
KEY `server_inc` (`server_inc`),
KEY `server_admin` (`server_admin`),
KEY `server_admin_tools` (`server_admin_tools`),
KEY `local_lang` (`local_lang`),
KEY `balance_required_for_payment` (`balance_required_for_payment`)
) TYPE=MyISAM COMMENT='Config Table';

INSERT INTO `config` (`license`, `site_title`, `site_name`, `balance_required_for_payment`, `currency`, `currency_type`, `domain_fee`, `resolve_server`, `run_domain_expire`, `http_web`, `server_root`, `below_public`, `default_reseller_cpanel_theme`, `theme`, `strong_security`, `phpbb_active`, `input_style`, `button_style`, `copyright`, `get_mib_news`, `email_support`, `http_web_tools`, `http_admin`, `http_admin_tools`, `http_images`, `server_backup`, `resolver_log`, `server_tools`, `server_admin_inc`, `server_inc`, `server_admin`, `server_admin_tools`, `local_lang`, `invoice_notice_period`, `tos_agreement`, `session_expire`) VALUES ('', '', '', 50, '$', 'USD', 15, '', 'yes', '', '', '', 'x', 'blue', 'no', 'no', 'style="font-family:verdana, arial, helvetica; font-size: 8pt; border-style: solid; border-color: 000000; border-width: 1pxl; background-color: dbedf9; font-weight: 800"', 'style="font-family:verdana, arial, helvetica; font-size: 8pt; border-style: solid; border-color: 000000; border-width: 1pxl; background-color: dbedf9; font-weight: 800"', '� 2002 Benchmark Designs, LLC.', 'http://benchmarkdesigns.net/mib_news.nfo', '', '', '', '', '', '', '', '', '', '', '', '', 'english', 86400, '', 36);

CREATE TABLE `invoice` (
`iid` bigint(22) unsigned NOT NULL auto_increment,
`uid` bigint(22) NOT NULL default '0',
`oid` bigint(22) NOT NULL default '0',
`due_date` int(10) NOT NULL default '0',
`payment_method` int(3) NOT NULL default '0',
`additional_information` text NOT NULL,
`invoice_details` text NOT NULL,
`invoice_terms` int(2) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`created` int(10) NOT NULL default '0',
`date_paid` int(10) NOT NULL default '0',
`invoice_number` bigint(22) NOT NULL default '0',
`invoice_type` int(1) NOT NULL default '0',
`total_due_today` float NOT NULL default '0',
`total_due_reoccur` float NOT NULL default '0',
`charge_tax` float NOT NULL default '0',
`extras` text NOT NULL,
`master` int(11) NOT NULL default '0',
`checkout_id` varchar(25) NOT NULL default '',
PRIMARY KEY (`iid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `invoice_config` (
`logo_path` varchar(255) NOT NULL default '',
`company_contact` mediumtext NOT NULL,
`payable_to` varchar(255) NOT NULL default '',
`invoice_number` bigint(22) NOT NULL default '1000'
) TYPE=MyISAM;

INSERT INTO `invoice_config` (`logo_path`, `company_contact`, `payable_to`, `invoice_number`) VALUES ('', 'Your Company\r\n123 Mocking Bird Lane\r\nSomeTown, State Zip USA', 'Your Company', 1000);

CREATE TABLE `invoice_service` (
`srid` bigint(22) unsigned NOT NULL auto_increment,
`service_name` varchar(255) NOT NULL default '',
`service_description` text NOT NULL,
`service_show_description` int(1) NOT NULL default '0',
`service_cost` float NOT NULL default '0',
PRIMARY KEY (`srid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `invoice_session` (
`sid` text NOT NULL,
`created` int(10) NOT NULL default '0'
) TYPE=MyISAM;


Added Folder: /public_html/inc/languages
-> to store language files and folders

Added Folder: /public_html/inc/languages/english
-> to store the main english language files

NOTE: LANGUAGE SUPPORT WILL ONLY BE IMPLEMENTED ON THE CLIENT SIDE
ADMIN FILES WILL NOT BE SUPPORTED FOR MULTI-LANGUAGE SUPPORT

Added Graphic: /public_html/admin/themes/blue/images/payable_invoice.gif
Added Graphic: /public_html/admin/themes/blue/images/resend_invoice.gif
Added Files for language support:
--> /public_html/inc/languages/english.php
--> /public_html/inc/languages/english/step_one.php
--> /public_html/inc/languages/english/step_two.php
--> /public_html/inc/languages/english/step_three.php
--> /public_html/inc/languages/english/step_four.php
--> /public_html/inc/languages/english/verify_order.php
--> /public_html/inc/pagefind.php

Added file: /public_html/admin/config_editor.php
-> Databased config editor suppor

Added file: /public_html/tools/step_two_code[0].php
-> separating the code from the HTML
-> added additional conditions to duplicate whm domain name/user checks

Added file: /public_html/tools/step_three_code[0].php
-> separating the code from the HTML

Added file: /public_html/tools/step_four_code[0].php
-> separating the code from the HTML

Added file: /public_html/tools/verify_order_code[0].php
-> separating the code from the HTML

Added file: /public_html/tools/verify_order_code[1].php
-> separating the code from the HTML

Added file: /public_html/tools/verify_order_code[2].php
-> separating the code from the HTML

Added file: /public_html/tools/credit_card_code[2].php
-> separating the code from the HTML

Added file: /public_html/tools/credit_card_code[1].php
-> separating the code from the HTML

Added files: /public_html/admin
ALL FILES THAT START WITH invoice_ . You should update every file in the admin area.

Added files: /public_html/inc/invoice_functions.php
-> invoice module


Added files: /public_html/billing_history.php
-> invoice module

Added files: /public_html/invoice_credit_card.php
-> invoice module

Added files: /public_html/invoice_hosting.php
-> invoice module

Added files: /public_html/invoice_hosting_payable.php
-> invoice module

Added files: /public_html/invoice_service.php
-> invoice module

Added files: /public_html/invoice_service_payable.php
-> invoice module

Added files: /public_html/invoice_success.php
-> invoice module

Added files: /public_html/invoice_success_service.php
-> invoice module


Edited file: /public_html/admin/themes/blue/header.php
-> added invoice menu options

Edited file: /public_html/admin/themes/blue/main_general_block.php
-> added invoice menu options

Edited file: /public_html/admin/index2.php
-> calc. error resolved for semi-annual payment terms

Edited file: /public_html/inc/whm_functions.php
-> added additional domain checks!

Edited file: /public_html/tools/step_one_code[0].php
-> fixed issue with hidden groups and new parse engine functions. Thanks Sam!
-> validate coupon per group - Thanks Mike!

Edited file: /public_html/admin/csv_add_user_accounts.php
-> fixed bug that caused csv import errors. Thanks Larry!

Edited file: /public_html/step_one.php
-> validate coupon per group - Thanks Mike!
-> added multi-language support

Edited file: /public_html/tools/step_one_code[0].php
-> Increased the time incomplete orders stay in session history from 8 hours to 3 days

Edited file: /public_html/step_two.php
-> added additional domain checks
-> separating the code from the HTML
-> added multi-language support

Edited file: /public_html/step_three.php
-> separating the code from the HTML
-> added multi-language support

Edited file: /public_html/step_four.php
-> separating the code from the HTML
-> added multi-language support

Edited file: /public_html/verify_order.php
-> validate coupon per group - just in case.. - Thanks Mike!
-> separating the code from the HTML
-> added multi-language support

Edited file: /public_html/credit_card.php
-> validate coupon per group - Thanks Mike!
-> separating the code from the HTML

Edited file: /public_html/admin/client_view.php
-> coupon tweaks

Edited file: /public_html/admin/tools/client_view_account_info.php
-> coupon tweaks

##~~~~
## END Release Version R2.2.3 - 10/04/2003 ---------------------------------------------------------
##~~~~#

##~~~~
## START Release Version R2.2.1 - 7/23/2003 ---------------------------------------------------------
##~~~~#

ALTER TABLE `authnet_batch` ADD `invoice_number` VARCHAR( 255 ) NOT NULL AFTER `uid` ;

Edited file: /public_html/admin/reseller_profile.php
-> Fixed "Quota Modification" misspelling.
-> Added "MB" to limit by space/bandwidth.

Edited file: /public_html/admin/client_veiw.php
-> tweaked the IP settings for "Activate Account - Install Now"
-> added code to set resolve monitor to off for dedicated servers

Edited file: /public_html/admin/master_batch.php
-> Removed edit button

Edited file: /public_html/admin/view_batch.php
-> Removed submit button

Edited file: /public_html/admin/tools/client_view_account_info.php
-> Set flags to manually enter dates if 1969 - Thanks Michael!

Edited file: /public_html/inc/whm_functions.php
-> tweak to fix issue with static IP - Thanks Drew!
-> added features to stabilize and enhance the resolver functions
-> removed "invalid domain expire" email from production.

Edited file: /public_html/inc/var.php
-> added variable for new resolver functions. Add the following code to your var.php file:

// should be your providers primary nameserver (IP is valid too)
// leaving it as will cause your resolver to fail
// ex: ns1.nac.net
$resolve_server="64.191.13.90";
$resolve_server="ns1.yourprovider.net";

Add the following line to var.php just below the last entry for // Server local variables
$resolver_log=$below_public."/resolver_logs"; # added 7/28/2003

Edited file: /public_html/inc/auth_functions.php
-> Moved country & state select boxes to /public_html/inc/select.php

Edited file: /public_html/inc/select.php
-> Moved country & state select boxes into this file from auth_functions.php

Edited file: /public_html/tools/step_one_code[0].php
-> fixed bug with coupon reading as expired with no expiration date

Edited file: /public_html/credit_card.php
-> switched file to read country & state from /public_html/inc/select.php instead of /public_html/inc/auth_functions.php
-> now recording the Authorize.net returned invoice # for easy transaction identification

Edited file: /public_html/verify_order.php
-> fixed logic error associated with 100% coupons and setup fees
-> added code to set resolve monitor to off for dedicated servers
-> replace misspellecd "reoccurring" with "Recurring"

Edited file: /public_html/authnet_success.php
-> fixed date issue with reseller orders - Thanks Michael!
-> now recording the Authorize.net returned invoice # for easy transaction identification

##~~~~
## END Release Version R2.2.1 - 7/23/2003 ---------------------------------------------------------
##~~~~#


##~~~~
## START Release Version R2.2.1 - 7/16/2003 ---------------------------------------------------------
##~~~~#
DATABASE:
UPDATE `email_templates` SET `attr_avail` = '{{order_date}}|{{active_server_name}}|{{first_name}}|{{last_name}}|{{domain_name}}|{{hosting_package}}|{{addons}}|{{payment_gateway}}|{{total_due_today}}||{{generate_date}}|{{total_reoccur}}|{{payment_term}}|{{email_address}}|{{how_found}}|{{coupon}}|{{pns1}}|{{pns2}}|{{client_notes}}|' WHERE `emid` = '7' LIMIT 1 ;
UPDATE `email_templates` SET `attr_avail` = '{{first_name}}|{{last_name}}|{{domain_name}}|{{hosting_package}}|{{addons}}|{{payment_gateway}}|{{total_due_today}}|{{total_reoccur}}|{{payment_term}}|{{generate_date}}|{{email_address}}|{{how_found}}|{{coupon}}|{{pns1}}|{{pns2}}|{{client_notes}}| ' WHERE `emid` = '8' LIMIT 1 ;

UPDATE VIA EDIT EMAIL TEMPLATE TOOL IN ADMIN AREA:
EMID = 7
--------------------------------------------------------------------------
Hello,

On {{order_date}}, a new client {{active_server_name}}

Here are the details:

Client: {{first_name}} {{last_name}}
Email: {{email_address}}
How did you find us: {{how_found}}
Domain: {{domain_name}}
Package Ordered: {{hosting_package}}
{{addons}}{{pns1}}
{{pns2}}
Payment Type: {{payment_gateway}}
{{coupon}}
Total Due Today: {{total_due_today}}

This order will rebill at a rate of {{total_reoccur}} {{payment_term}}

{{client_notes}}

Thank you.

Your AutoPilot

This message was generated on: {{generate_date}}
--------------------------------------------------------------------------
EMID = 8
--------------------------------------------------------------------------
Hello,

We have received your hosting ORDER and will be processing it shortly.

The details of this ORDER are below:

First Name: {{first_name}} {{last_name}}
Email: {{email_address}}
How did you find us: {{how_found}}
Domain Name: {{domain_name}}
Package Ordered: {{hosting_package}}
{{addons}}{{pns1}}
{{pns2}}
Payment Gateway: {{payment_gateway}}
{{coupon}}
Total Due Today: {{total_due_today}}

This ORDER will rebill at a rate of {{total_reoccur}} {{payment_term}}

You should receive an email FROM us within the next 24 hours with more information.

{{client_notes}}

Thank You.

Web Host Support

This message was generated on: {{generate_date}}
--------------------------------------------------------------------------


Edited file: /public_html/admin/tools/client_view_dedicated_account_info.php
-> added delete function for dedicated servers

Edited file: /public_html/admin/tools/client_view_account_info.php
-> fixed plans showing -1
-> reseller upgrades/downgrades
-> added ns info to private ns addons

Edited file: /public_html/admin/client_view.php
-> added delete function for dedicated servers

Edited file: /public_html/admin/client_view_edit.php
-> added switch to show either server hostname or http://
-> fixed >2 bug when searching for by domain. Thanks Richyc

Edited file: /public_html/admin/index2.php
-> dedicated servers no longer show up under unresolved
-> dedicated servers now show hostname in the pending list

Edited file: /public_html/admin/manage_session_history.php
-> changed flow of forms, now creates the account as pending and moves you to client_view.php to complete.

Edited file: /public_html/inc/whm_functions.php
-> added ns info for private nameserver orders and also client notes to emid 7 & 8

##~~~~
## START Release Version R2.2.1 - 7/16/2003 ---------------------------------------------------------
##~~~~#



##~~~~
## START Release Version R2.2.1 - 7/16/2003 ---------------------------------------------------------
##~~~~#
GENERAL NOTES:
Please update all files in the following dirs:
/public_html/admin
/public_html/inc
/public_html/tools

DATABASE CHANGES:
ALTER TABLE `user` ADD `logged` INT( 1 ) DEFAULT '0' NOT NULL ;

ADMIN AREA FILES:
Edited file: /public_html/admin/client_management.php
-> new flow for manually added accounts

Edited file: /public_html/admin/client_view.php
-> change of ownership added

Edited file: /public_html/admin/trouble_ticket_active.php
-> fixed issue with back button

Edited file: /public_html/admin/affiliate_approve.php
-> fixed date issue.

Edited file: /public_html/admin/edit_templates.php
-> fixed user display of "From" email addr - Thanks James

Edited file: /public_html/admin/plan_build.php
-> fixed problem with link - Thanks speckados

Edited file: /public_html/admin/tools/client_management_client_form_inc.php
-> new flow for manually added accounts

Edited file: /public_html/admin/themes/blue/header.php
-> new session management enhancements

Edited file: /public_html/admin/themes/blue/main_resolver_block.php
-> tweaked the resolver dropdown menu - Thanks Richyc

INC FOLDER FILES:
Added file: /public_html/inc/login_functions.php
-> new session management enhancements

Edited file: /public_html/inc/whm_functions.php
-> fixed resolver issue with expiry date - Thanks Richyc

Edited file: /public_html/inc/client_functions.php
-> new session management enhancements
-> fixed date issue with cancel account

TOOLS DIR:
Edited file: /public_html/tools/step_one_code[0].php
-> fixed parse error
-> fixed issue with domain purchase not showing up.

PUBLIC AREAS:
Edited file: /public_html/step_two.php
-> fixed bug with domain reg.

#~~~~
## END Release Version R2.2.1 - 7/16/2003 ---------------------------------------------------------
##~~~~#


#~~~~
## START Release Version R2.2.0 - 7/9/2003 ---------------------------------------------------------
##~~~~

# GENERAL
# ---------------------------------------------------------------------------------------------------
Remove or comment out the following lines from /public_html/inc/var.php:
// Enter the path to curl or leave blank to use the PHP Curl functions
// ex. /usr/bin/curl
$curl_root="";


// Http variables
$http_ssl="https://216.67.249.105";
$http_no_ssl="http://216.67.249.105";

// Auto switch ssl and not
if (isset($HTTPS))
{
if (strtolower($HTTPS)=="on")
{
// SSL
$http_web=$http_ssl;
}
else
{
// NON SSL
$http_web=$http_no_ssl;
}
}
else
{
// NON SSL
$http_web=$http_no_ssl;
}

# ADD THE FOLLOWING LINES TO VAR.PHP
// Should be using SSL if you have it
$http_web="http://216.67.249.105";

# GRAPHICS
# ---------------------------------------------------------------------------------------------------
Added file: /public_html/admin/themes/blue/dedicated.gif
Added file: /public_html/admin/themes/blue/reseller.gif
Added file: /public_html/admin/themes/blue/mailinpayment.gif


# SQL
# ---------------------------------------------------------------------------------------------------
CREATE TABLE `reseller_profile` (
`rid` BIGINT( 22 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`profile_name` VARCHAR( 255 ) NOT NULL ,
`edit_ns` INT( 1 ) DEFAULT '0' NOT NULL ,
`limit_type` INT( 1 ) NOT NULL ,
`resnumlimitamt` INT( 25 ) NOT NULL ,
`rslimit_disk` INT( 25 ) NOT NULL ,
`rsolimit_disk` INT( 25 ) NOT NULL ,
`rslimit_bw` INT( 25 ) NOT NULL ,
`rsolimit_bw` INT( 25 ) NOT NULL ,
`acl_list` TEXT NOT NULL ,
PRIMARY KEY ( `rid` )
) COMMENT = 'Reseller Profile Table';

ALTER TABLE `plan_specs` ADD `rid` BIGINT( 22 ) DEFAULT '0' NOT NULL AFTER `gid` ;

ALTER TABLE `session_history` ADD `pns1` VARCHAR( 25 ) DEFAULT 'ns1' NOT NULL , ADD `pns2` VARCHAR( 25 ) DEFAULT 'ns2' NOT NULL ;
ALTER TABLE `hosting_order` ADD `pns1` VARCHAR( 25 ) NOT NULL , ADD `pns2` VARCHAR( 25 ) NOT NULL ;
ALTER TABLE `plan_specs` ADD `ip_addresses` VARCHAR( 50 ) NOT NULL , ADD `memory` VARCHAR( 50 ) NOT NULL , ADD `processor` VARCHAR( 50 ) NOT NULL , ADD `os` VARCHAR( 50 ) NOT NULL , ADD `display_text` TEXT NOT NULL , ADD `dedicated` INT( 1 ) DEFAULT '0' NOT NULL ;

INSERT INTO email_templates VALUES (34, 'Reseller Welcome Email', 'Your reseller account has been activated, please save and print', 'Hello {{first_name}},\r\n\r\n/\\/\\/\\/\\/\\/\\/\\/\\~~~~~~~~~~[ DETAILS ]~~~~~~~~~~/\\/\\/\\/\\/\\/\\/\\/\\/\\\r\n\r\nYour Package: {{package}}\r\nTotal Quota: {{space}}\r\nTotal Bandwidth: {{bandwidth}}\r\nAccounts Included: {{accounts}}\r\n\r\nThis account is installed on {{server_name}}\r\n\r\n/\\/\\/\\/\\/\\/\\/\\/\\~~~~~~~~~~~~~~~~~~~~~~~~~~~/\\/\\/\\/\\/\\/\\/\\/\\/\\\r\n\r\nThe next areas describe how to access your WHM and cPanel.\r\n\r\nPlease print this email for your records.\r\n\r\n------------------------------------------------------------------------\r\nWeb Host Manager Quicky\r\n------------------------------------------------------------------------\r\nTo Create a new account:\r\n\r\nTo access your Web Host Manager, use the following address:\r\n\r\nhttp://{{ip}}:2086\r\n\r\nUsername: {{username}}\r\nPassword: {{password}}\r\n\r\nFirst thing you need to do is scroll down on the left and click on \'Add Package\'\r\nso that you can create your own hosting packages. You cannot install a domain\r\nonto your account without a package created.\r\n\r\n1. - click on \'Create a New Account\' from the left hand side menu\r\n2. - put the domain in the \'Domain\' box (no www or http or spaces - just\r\ndomainname.com). After putting in the domain, it will automatically\r\ncreate a username.\r\n\r\n3. - Your package selection should one that you created earlier\r\n4. - Then press the create button\r\n\r\nThis will create a confirmation page - right click in this area and\r\nselect print (for your records)\r\n\r\n------------------------------------------------------------------------\r\n\r\nPlease do not click on anything that you are not sure what it does. Please do not\r\ntry to alter the WHM Theme from the selection box - fatal errors will occur.\r\n\r\nYour Domain Information:\r\n\r\nDomain: {{domain}}\r\nIp: {{ip}}\r\nUserName: {{username}}\r\nPassWord: {{password}}\r\n\r\nStarting Space for this domain: 50 megs. If you need more space, that will deduct\r\nfrom your {{space}} allotted for your client accounts.\r\n\r\nFor FTP:\r\n\r\nHost Address: {{ip}} or {{domain}} if resolved\r\nUsername: {{username}}\r\nPassword: {{password}}\r\n\r\nTo log in to your CPanel (for hosting on this domain) use this address:\r\n\r\nhttp://{{ip}}:2082 or http://{{domain}}:2082 if it has resolved\r\n\r\nUsername: {{username}}\r\nPassword: {{password}}\r\n\r\nUse the IP address if your domain has not resolved to this server yet.\r\nThe http:// must be present in the address to access port :2082\r\n\r\nTo access your Web Host Manager, use the following address:\r\n\r\nhttp://{{ip}}:2086\r\n\r\nUsername: {{username}}\r\nPassword: {{password}}\r\n\r\nYour domain, when you chose one, or if you already have it registered\r\nneeds to point to the following nameservers:\r\n\r\n{{primary_nameserver}}\r\n---> {{primary_nameserver_ip}}\r\n{{secondary_nameserver}}\r\n---> {{secondary_nameserver_ip}}\r\n\r\nAll of your clients will need to point here as well to be hosted in your\r\nreseller block of the server. If you are creating your own nameservers,\r\nhere is the needed information to register them:\r\n\r\n{{primary_nameserver_reseller}} resolves to {{primary_nameserver_ip_reseller}}\r\n{{primary_nameserver_ip_reseller}} resolves to {{secondary_nameserver_ip_reseller}}\r\n\r\nThanks,\r\n\r\nSupport Team\r\nWeb Hosting Company\r\n\r\n\r\n============================================================\r\nBRIEF OVERVIEW / TUTORIAL of the WHM\r\n============================================================\r\n\r\nlot of the features in the WHM will be used daily, some may not ever be\r\nused at all. This email will explain the first few menu options on the left\r\nas soon as you login to your WHM.\r\n\r\nTo login, use the following method:\r\n\r\nhttp://{{ip}}:2086\r\n\r\nusername: {{username}}\r\npassword: {{password}}\r\n\r\nthe http:// must be in the address line to connect to port :2086\r\n\r\nLet\'s begin:\r\n\r\n============================================================================\r\nWeb Host Manager Tutorial / Explanation\r\n----------------------------------------------------------------------------\r\n\r\nThe web host manager (WHM) is your gateway to the server for installation\r\nand managing of your reseller accounts. I have broken down the WHM in\r\nsections below, with explanations of each feature and what it is good for.\r\n\r\nServer Setup\r\n------------------------------------------------\r\nSetup Remote Access Key\r\n------------------------------------------------\r\nThis function creates a secure key code that will allow perl programs (still\r\nin development) to communicate to your WHM to install,modify and delete\r\nclients without accessing the WHM. This feature is something that is in\r\ndevelopment and would not be a used feature for your program at this time.\r\n\r\nServer Status\r\n------------------------------------------------\r\nServices Status\r\n------------------------------------------------\r\nThis will allow you to view the heath of the server, at any time. By\r\nclicking on this link, you will be able to see all the server services\r\nrunning, their status and their usage. Yellow lights are ok - red lights\r\nare acceptable as long as it is not for long periods of time. We also\r\nmanage and view these services. If you see a problem, 99% of the time we are\r\nalready addressing it.\r\n\r\n------------------------------------------------\r\nServer Information\r\n------------------------------------------------\r\nThis allows you to see what makes the server. The processors, hard drive,\r\nserver name, disk usage, etc.\r\n\r\nAccount Functions\r\n------------------------------------------------\r\nList Accounts\r\n------------------------------------------------\r\nThis shows all of your client domains, Server IP, Username, Install Date,\r\nand Space used. This feature will not show you your clients QUOTA since you\r\nwill be modifying this (if needed) from the \'Quota Modification\' section\r\ndiscussed later.\r\n\r\n------------------------------------------------\r\nCreate a New Account\r\n------------------------------------------------\r\nThis one is pretty much self explanatory but there are some items that need\r\nto be looked out for while installing clients onto the server.\r\n\r\n1 - There cannot be any spaces before or after the domain name. All that is\r\nneeded is this block is just the domain name (no www. or http://)\r\n\r\n2 - The username cannot start with a number or have any spaces or dashes in\r\nit. If the username defaults to a name with a dash, remove the dash or\r\nerrors will occur when the user attempts to install scripts included in the\r\nCPanel.\r\n\r\nBad usernames: 123domai or 123-doma or domain-\r\nGood Usernames: domainco or domainxx or domainqt\r\n\r\nTry to keep the username all lower case, as well as the password when you\r\ncreate it.\r\n\r\nTo install a new account, follow these steps:\r\n\r\n1 - input the client domain into the domain box - this will automatically\r\ncreate a username after you press the TAB key when done. If the username\r\nhas a - in it or starts with a number, please modify the username to be a\r\nclean, acceptable username.\r\n\r\n2 - Create password for the user. This can be whatever you wish to have as\r\nthe password or the user can request a specific password when signing up for\r\nservices. A good rule of thumb is to not use an everyday word or, if you\r\nuse an everyday word like \'tree\', modify it with a few numbers -\r\n\'tree78787\'.\r\n\r\n3 - Select your default package (there will only be one package in your\r\ndropdown) and press the create button at the top.\r\n\r\nYour default package will only install the account on 10 megs of space. If\r\nyou need to modify this space, use the \'Quota Modification\' feature\r\nexplained later.\r\n\r\n********GOOD RULE OF THUMB***********\r\nAfter you press the create button, a confirmation page will come up showing\r\nthe domain installed, the IP, the username and password. Right click on\r\nthis page and select the print option. Keep this in your file for this user\r\nsince this will be your only record of the users original password.\r\n*************************************\r\n\r\n------------------------------------------------\r\nSkeleton Directory\r\n------------------------------------------------\r\nThis directory is where you would install a basic index.html page that would\r\nbe installed on all new domains after you have installed them -\r\nautomatically. If you want to use this feature, you must first click on\r\nthis link to create the cpanel3-skel directory on your reseller domain.\r\n\r\n1 - Create a simple index.html page - Hosted by ______________________ or\r\nsomething a little more feature rich. If you are using images, host the\r\nimages somewhere else and use full url links to the images IMG\r\nSRC="http://yourdomain.com/images/welcome.gif".\r\n\r\n2 - FTP into your main domain and open the /cpanel3-skel folder. Then open\r\nthe /public_html folder.\r\n\r\n3 - Upload your basic index.html page into this folder. THAT\'S IT!\r\nEverytime you install an account, this index page will be installed onto\r\nthat domain. Once the domain resolves, your page will be seen. The user\r\ncan delete or replace them at their own desire.\r\n\r\n------------------------------------------------\r\nTerminate an Account\r\n------------------------------------------------\r\nPretty much self explanatory. Only one word of caution - FILES ARE NOT\r\nRECOVERABLE AFTER TERMINATION.\r\n\r\n------------------------------------------------\r\nView Bandwidth Usage\r\n------------------------------------------------\r\nAgain, pretty much self explanatory. This feature will give you a summary\r\nof all your clients bandwidth usage for the current month. You have the\r\nability to preview previous months by clicking on the link at the top of the\r\nbandwidth page. If you notice a client with a highlighted listing (yellow\r\nor red) - Keep an eye on them for they are using alot of bandwidth.\r\n\r\n------------------------------------------------\r\nLimit Bandwidth Usage\r\n------------------------------------------------\r\nIf you want to limit the bandwidth per account, you can do so here. This is\r\ncounted in MEGS of bandwidth so make sure you use the following method:\r\n\r\nFor 1 GIG of Bandwidth, use 1024 megs, etc.\r\n\r\nOnce this account goes over 1 gig in bandwidth, a page will show up on their\r\ndomain stating bandwidth limit has been reached, contact system admin. This\r\ngives you total control over bandwidth so nothing gets out of hand.\r\n\r\n------------------------------------------------\r\nSuspend or Unsuspend and account & List Suspended Accounts\r\n------------------------------------------------\r\nSelf explanatory area. This will allow you to FREEZE a clients domain which\r\nwill product a customized (explained later) page on their website stating\r\nthey have been suspended, please contact system admin.\r\n\r\n------------------------------------------------\r\nModify Suspended Account Page\r\n------------------------------------------------\r\nClicking this will give you a form field with the HTML code of your \'Account\r\nSuspended\' page. Create a standard \'account suspended\' web page (with full\r\nurl links to images) in a normal web design program. Cut and paste the\r\nsource into this box and press save.\r\n\r\n------------------------------------------------\r\nQuota Modification\r\n-------------------------------------------------\r\nAfter you install and account, and they have been assigned 10 megs on your\r\nreseller area - you can click here to alter that space to meet their needs.\r\nPretty much self explanatory once inside. Find the domain, replace the 10\r\nwith what they purchases and press the submit button next to the box.\r\n\r\n------------------------------------------------\r\nPassword Modification\r\n------------------------------------------------\r\nIf a user misplaces or forgets their password, you can go here and either\r\nreset it to original (pull out copy of printout from account creation) or\r\nyou can make an entire new password for them.\r\n\r\n------------------------------------------------\r\nList Subdomains\r\n------------------------------------------------\r\nIf an account has been enabled to use sub-domains (unique IP required) - you\r\nwill be able to view all the sub-domains by clicking this link for all\r\naccounts in your reseller block.\r\n\r\n============================================================================', '{{first_name}}|{{package}}|{{space}}|{{bandwidth}}|{{accounts}}|{{server_name}}|{{domain}}|{ip}}|{{username}}|{{password}}|{{generate_date}}|{{primary_nameserver}}|{{primary_nameserver_ip}}|{{secondary_nameserver}}|{{secondary_nameserver_ip}}|{{primary_nameserver_reseller}}|{{primary_nameserver_ip_reseller}}|{{secondary_nameserver_reseller}}|{{secondary_nameserver_ip_reseller}}|');

ALTER TABLE `session_history` ADD `server_hostname` VARCHAR( 255 ) NOT NULL , ADD `root_pw` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `hosting_order` ADD `server_hostname` VARCHAR( 255 ) NOT NULL , ADD `root_pw` VARCHAR( 255 ) NOT NULL ;

INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` ) VALUES ('', 'Dedicated Server Activation', 'SUBJECT: Your Dedicated Server has been Activated and is Ready', 'Hello {{first_name}}, /\\/\\/\\/\\/\\/\\/\\/\\~~~~~~~~~~[ DETAILS ]~~~~~~~~~~/\\/\\/\\/\\/\\/\\/\\/\\/\\ Server Name: {{dedicated_server_name}} Operating System: {{dedicated_operating_system}} Server Specifications: {{dedicated_server_specs}} Main IP: {{dedicated_main_ip}} Initial IP Allocation: {{dedicated_ipblock_range}} Root Access Password: {{dedicated_root_password}} This servers rack location is: {{dedicated_rack_location}} /\\/\\/\\/\\/\\/\\/\\/\\~~~~~~~~~~~~~~~~~~~~~~~~~~~/\\/\\/\\/\\/\\/\\/\\/\\/\\ The next areas describe how to access your WHM AVAILABLE DOCUMENTATION: CPanel Manual: http://www.cpanel.net/docs/cp/ WebHostManager Manual: http://www.cpanel.net/docs/whm/ Automate your client installs immediately after they order, visit: http://www.whmautopilot.com/autopilot.php Please print this email for your records. ------------------------------------------------------------------------ FIRST STEPS TO GET THIS SERVER UP AND RUNNING ------------------------------------------------------------------------ This server has been built to \'standard\' specifications and no specific \'user\' related information may be in place. Step One: Log into your Dedicated Servers ROOT WHM: https://{{dedicated_main_ip}}:2087/ Root Password: {{dedicated_root_password}} Username: root [1] Click on \'Edit Setup\' on the left hand frame (A)---> make sure primary and secondary nameservers are correct If yes, assign an IP and create the A record (each) (B)---> make sure hostname is correct. If not, make a note and we\'ll discuss how to change that later. (C)---> If you have AOL IM, we highly recommend putting that information in here so that you can be alerted via AOL IM if something has a problem. After all these have been reviewed, and found to be correct - click submit at the bottom of this page to save your changes to this area. [2] With the above done, and the A Records made for your private nameservers, you will need to register those with your domain registrar. [3] Get to know your WHM by using the manual link above and please, if you do not know what something does - do not click it. Remember, you have root access to this box and that access should never be shared nor given to anyone outside of your trust limits. Root access controls all the configurations of the server and, with the wrong command or edit, can crash your server and entail costs of $75 per man hour to correct. ------------------------------------------------------------------------ BASIC ROOT COMMANDS FOR A DEDICATED SERVER - USE AT YOUR OWN RISK ------------------------------------------------------------------------ These commands are to be run in an SSH Window via login to port 22 as root A good program for this is called PuTTY ----------------------- To restart server : reboot Check Disk Usage : dj -k Stop HTTPD (apache) : /etc/rc.d/init.d/httpd stop Start HTTPD (apache) : /ect/rc.d/init.d/httpd start Restart HTTPD (apache) : httpd restart View current processes : top Display a file : cat /path/to/filename Editing a file : pico /path/to/filename Domain Name Lookup : fwhois yourname.com Ping IP/Domain : ping domain.com or ping 000.000.000.000 Recompile Apache : /scripts/easyapache (use with caution) Fixing Disk Quotas : /scripts/fixquotas ----------------------- Basic File/Script Locations on the server: Admin control scripts : /scripts Admin control interface : /scripts/admin Web Account Directory : /home/username/ Access/Error logs : /usr/local/apache/logs Domain Access Logs : /usr/local/apache/domlogs Apache Conf File : /etc/httpd/conf/httpd.conf We ask that you use any script on the server with caution understanding that anything you do affects all of your users on the server. If there are any scripts/processes found on this server that breaches the AUP for this service, they will be removed/stopped and you could lose root access to your server. If you have any questions, please, don\'t hestiate to contact our support team. Thanks, Support Team Web Hosting Company', '{{first_name}}|{{dedicated_rack_location}}|{{dedicated_root_password}}|{{dedicated_ipblock_range}}|{{dedicated_main_ip}}|{{dedicated_server_specs}}|{{dedicated_operating_system}}|{{dedicated_server_name}}|');

ALTER TABLE `hosting_order` ADD `server_specs` TEXT NOT NULL , ADD `ipblock` TEXT NOT NULL , ADD `rack` TEXT NOT NULL ;

UPDATE `email_templates` SET `subject` = 'Your Dedicated Server has been Activated and is Ready' WHERE `emid` = '36' LIMIT 1 ;

ALTER TABLE `plan_specs` ADD `in_stock` INT( 5 ) NOT NULL ;

ALTER TABLE `email_templates` ADD `default_email` VARCHAR( 255 ) NOT NULL ;

# ADMIN FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Added file: /public_html/admin/reseller_profile.php
-> WHM Reseller support.

Added file: /public_html/admin/reseller_profile_edit.php
-> WHM Reseller support.

Added file: /public_html/admin/tools/client_view_dedicated_account_info.php
-> Dedicated Server support.

Edited file: /public_html/admin/themes/blue/main_glance_block.php
-> Dedicated Server support.

Edited file: /public_html/admin/themes/blue/main_server_block.php
-> Replaced "Open WHM" link with new secure link

Edited file: /public_html/admin/themes/blue/header.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/admin/themes/blue/main_glance_block.php
-> changed wording.

Edited file: /public_html/admin/client_view.php
-> Dedicated Server support.

Edited file: /public_html/admin/client_view_edit.php
-> Dedicated Server support.
-> WHM Reseller support.
-> added support for mail in payment printable invoice
-> now visually marks different account types

Edited file: /public_html/admin/coupon_build.php
-> Changed look slightly.
-> Navagation change.
-> fixed bug with invalid expire time on coupons

Edited file: /public_html/admin/plan_build.php
-> extended Paypal free trial period to 30 months from 12 months

Edited file: /public_html/admin/plan_build_dedicated.php
-> Dedicated Server support.

Edited file: /public_html/admin/plan_edit.php
-> Dedicated Server support.

Edited file: /public_html/admin/plan_build.php
-> WHM Reseller support.

Edited file: /public_html/admin/manage_session_history.php
-> added overlib support

Edited file: /public_html/admin/addon_build.php
-> WHM Reseller support.

Edited file: /public_html/admin/server_config.php
-> Security Update - now requires curl compiled with PHP.

Edited file: /public_html/admin/index.php
-> scripting enhancements.

Edited file: /public_html/admin/index2.php
-> scripting enhancements.


# INC FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Edited file: /public_html/inc/whm_functions.php
-> Security Update - now requires curl compiled with PHP.
-> scripting enhancements.
-> fixed a manual install bug in current_server_internal() - Thanks to Jeremy for the bug find.
-> WHM Reseller support.
-> Dedicated Server support.
-> added ability to define who emails are sent from based on entry in /admin/email_templates.php

Edited file: /public_html/inc/client_functions.php
-> scripting enhancements.
-> added ability to define who emails are sent from based on entry in /admin/email_templates.php

Edited file: /public_html/inc/affiliate_functions.php
-> added ability to define who emails are sent from based on entry in /admin/email_templates.php


# /TOOLS FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Added file: /public_html/tools/step_one_code[0].php
-> separated most php from the html to make way for client side parse-able templates.

# PUBLIC_HTML FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Edited file: /public_html/step_one.php
-> Dedicated Server support.
-> separated most php from the html to make way for client side parse-able templates.
-> added Javascript to select input by clicking on payment graphic

Edited file: /public_html/step_two.php
-> bug fix for nameservers showing []
-> Dedicated Server support.
-> fixed addon nav display bug

Edited file: /public_html/step_three.php
-> WHM Reseller support.
-> moved to more stable code for storing addon choices

Edited file: /public_html/step_four.php
-> fixed addon nav display bug
-> now remembers org. "how found:" for logged in users/existing clients

Edited file: /public_html/verify_order.php
-> fixed blank addon page issue when going back in the forms.
-> WHM Reseller support.
-> Dedicated Server support.
-> bug fix for nameservers showing []

Edited file: /public_html/invoice_new.php
-> Dedicated Server support.

Edited file: /public_html/paypal_success.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/2checkout_success.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/authnet_success.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/tpp_pro_success.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/worldpay_success.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/client_area.php
-> WHM Reseller support.
-> Dedicated Server support.

Edited file: /public_html/new_affiliate.php
-> bug fix for affiliate display mix ups


##~~~~
## END Release Version R2.2.0 - 7/9/2003 ---------------------------------------------------------
##~~~~





##~~~~
## START Release Version R2.1.2 - 6/10/2003 ---------------------------------------------------------
##~~~~

# SQL
# ---------------------------------------------------------------------------------------------------
ALTER TABLE `plan_specs` ADD `free_trial` INT( 1 ) DEFAULT '0' NOT NULL ,
ADD `free_trial_length` INT( 2 ) DEFAULT '0' NOT NULL ;

ALTER TABLE `addon_specs` ADD `coupon` INT( 1 ) DEFAULT '0' NOT NULL ,
ADD `coupon_code` VARCHAR( 255 ) NOT NULL ,
ADD `coupon_discount_type` INT( 1 ) DEFAULT '0' NOT NULL ,
ADD `coupon_discount_percent` FLOAT NOT NULL ,
ADD `coupon_discount_whole` FLOAT NOT NULL ,
ADD `expires` INT( 40 ) NOT NULL ;

ALTER TABLE `addon_specs` ADD `coupon_terms` INT( 1 ) DEFAULT '0' NOT NULL AFTER `coupon` ;

ALTER TABLE `session_history` ADD `whm_id` BIGINT( 22 ) NOT NULL AFTER `uid` ;

UPDATE `email_templates` SET `message` = 'Hello, On {{order_date}}, a new client {{active_server_name}} Here are the details: Client: {{first_name}} {{last_name}} Email: {{email_address}} How did you find us: {{how_found}} Domain: {{domain_name}} Package Ordered: {{hosting_package}} {{addons}} Payment Type: {{payment_gateway}} {{coupon}} Total Due Today: {{total_due_today}} This order will rebill at a rate of {{total_reoccur}} {{payment_term}} Thank you. Your AutoPilot This message was generated on: {{generate_date}}', `attr_avail` = '{{order_date}}|{{active_server_name}}|{{first_name}}|{{last_name}}|{{domain_name}}|{{hosting_package}}|{{addons}}|{{payment_gateway}}|{{total_due_today}}||{{generate_date}}|{{total_reoccur}}|{{payment_term}}|{{email_address}}|{{how_found}}|{{coupon}}|' WHERE `emid` = '7' LIMIT 1 ;

UPDATE `email_templates` SET `message` = 'Hello, We have received your hosting ORDER and will be processing it shortly. The details of this ORDER are below: First Name: {{first_name}} {{last_name}} Email: {{email_address}} How did you find us: {{how_found}} Domain Name: {{domain_name}} Package Ordered: {{hosting_package}} {{addons}} Payment Gateway: {{payment_gateway}} {{coupon}} Total Due Today: {{total_due_today}} This ORDER will rebill at a rate of {{total_reoccur}} {{payment_term}} You should receive an email FROM us within the next 24 hours with more information. Thank You. Web Host Support This message was generated on: {{generate_date}}', `attr_avail` = '{{first_name}}|{{last_name}}|{{domain_name}}|{{hosting_package}}|{{addons}}|{{payment_gateway}}|{{total_due_today}}|{{total_reoccur}}|{{payment_term}}|{{generate_date}}|{{email_address}}|{{how_found}}|{{coupon}} ' WHERE `emid` = '8' LIMIT 1 ;


# ADMIN FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Added file: /public_html/admin/coupon_build.php
-> added coupon / promotion code support

Added file: /public_html/admin/coupon_edit.php
-> added coupon / promotion code support

Edited file: /public_html/admin/themes/blue/header.php
-> added coupon support

Edited file: /public_html/admin/addon_edit.php
-> added coupon support

Edited file: /public_html/admin/client_view.php
-> Rolled back IP code - applies here only - too much can go wrong.

Edited file: /public_html/admin/addon_edit.php
-> Added error checking to prevent parent addons from being deleted
without first deleting the associated children.

Edited file: /public_html/admin/payment_process.php
-> added code to clear cache

Edited file: /public_html/admin/affiliate_plan_edit.php
-> added code to calc when monthly totals are -1 [only affected display to user in admin

Edited file: /public_html/admin/affiliate_plan.php
-> added code to calc when monthly totals are -1 [only affected display to user in admin]

Edited file: /public_html/admin/affiliate_approve.php
-> support for affiliate user signups only without hosting service.

Edited file: /public_html/admin/plan_build.php
-> added support for Paypal free trial periods

Edited file: /public_html/admin/master_batch.php
-> not storing cvv2 now.

Edited file: /public_html/admin/process_batch.php
-> not storing cvv2 now.

Edited file: /public_html/admin/csv.php
-> must be root to change ownership of an account - added new switch.

Edited file: /public_html/admin/csv_change_owner.php
-> removed double entry for "You are currently working with..."

Edited file: /public_html/admin/index.php
-> changed key server to IP

Edited file: /public_html/admin/index2.php
-> set timeout on fopen for stream for news


# INC FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Edited file: /public_html/inc/whm_functions.php
-> added function to clear cache
-> added T/S tool to create_account() function
-> revised create_account() function with encoding
-> added coupon / promotion code support
-> changed the support link
-> upgraded to Curl for better stability
-> revised functions for stable connectivity

Edited file: /public_html/inc/client_functions.php
-> added fix for semi-annual package math bug

Edited file: /public_html/inc/select.php
-> added Holland as option


# PUBLIC_HTML FOLDER UPDATES
# ---------------------------------------------------------------------------------------------------
Added file: /public_html/affiliate_signup.php
-> support for affiliate user signups only without hosting service.

Edited file: /public_html/trouble_ticket_view.php
-> Added header before back button displayed.

Edited file: /public_html/invoice_new.php
-> Fixed http:///cpanel bug

Edited file: /public_html/verify_order.php
-> added support for Paypal free trial periods

Edited file: /public_html/credit_card.php
-> not storing cvv2 now.

Edited file: /public_html/cc_update.php
-> not storing cvv2 now.

Edited file: /public_html/step_one.php
-> fixed radio button issue.
-> added code to fix step_two nameserver bug
-> added coupon / promotion code support

Edited file: /public_html/step_two.php
-> added code to fix step_two nameserver bug

Edited file: /public_html/verify_order.php
-> added code to fix step_two nameserver bug
-> added support for Paypal free trial periods
-> added coupon / promotion code support

##~~~~
## END Release Version R2.1.2 - 6/10/2003 ---------------------------------------------------------
##~~~~

##~~~~
## START Release Version R2.1.1 - 3/27/2003 ---------------------------------------------------------
##~~~~
Database Changes:
DROP TABLE IF EXISTS authnet_batch;
CREATE TABLE authnet_batch (
bid bigint(22) unsigned NOT NULL auto_increment,
customer_ip_address varchar(25) NOT NULL default '',
description varchar(255) NOT NULL default '',
currency_code varchar(10) NOT NULL default '',
transaction_type varchar(25) NOT NULL default '',
recurring_billing char(3) NOT NULL default 'YES',
payment_method char(2) NOT NULL default 'CC',
customer_first_name varchar(255) NOT NULL default '',
customer_last_name varchar(255) NOT NULL default '',
customer_address varchar(255) NOT NULL default '',
customer_city varchar(255) NOT NULL default '',
customer_state varchar(255) NOT NULL default '',
customer_zip varchar(255) NOT NULL default '',
customer_country varchar(255) NOT NULL default '',
customer_phone varchar(25) NOT NULL default '',
customer_fax varchar(25) NOT NULL default '',
customer_email varchar(255) NOT NULL default '',
card_info text NOT NULL,
ogcreate varchar(40) NOT NULL default '',
response_reason_text varchar(255) NOT NULL default '',
batch_status int(1) NOT NULL default '0',
oid bigint(22) NOT NULL default '0',
uid bigint(22) NOT NULL default '0',
master_batch int(1) NOT NULL default '0',
PRIMARY KEY (bid)
) TYPE=MyISAM COMMENT='Authorize.net Batch Creation';


DROP TABLE IF EXISTS addon_groups;
CREATE TABLE addon_groups (
addon_gid int(11) unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
group_payment text NOT NULL,
group_addons text NOT NULL,
group_status int(1) NOT NULL default '0',
PRIMARY KEY (addon_gid)
) TYPE=MyISAM COMMENT='Addon Group table.';

#
# Dumping data for table `addon_groups`
#

INSERT INTO addon_groups (addon_gid, name, group_payment, group_addons, group_status) VALUES (19, 'Standard Addon Group Example', '1|3|6|4|2|', '44|42|43|', 1);
# --------------------------------------------------------

#
# Table structure for table `addon_specs`
#

DROP TABLE IF EXISTS addon_specs;
CREATE TABLE addon_specs (
aid bigint(22) unsigned NOT NULL auto_increment,
addon_pay_methods text NOT NULL,
addon_name varchar(255) NOT NULL default '',
addon_description text NOT NULL,
addon_show_description int(1) NOT NULL default '0',
setup_cost float NOT NULL default '0',
setup_activate int(1) NOT NULL default '0',
addon_cost float NOT NULL default '0',
addon_state varchar(255) NOT NULL default '',
addon_activate int(1) NOT NULL default '0',
unique_ip int(1) NOT NULL default '0',
extra_webspace int(15) NOT NULL default '0',
PRIMARY KEY (aid)
) TYPE=MyISAM;

#
# Dumping data for table `addon_specs`
#

INSERT INTO addon_specs (aid, addon_pay_methods, addon_name, addon_description, addon_show_description, setup_cost, setup_activate, addon_cost, addon_state, addon_activate, unique_ip, extra_webspace) VALUES (44, '', 'Extra WebSpace Example', '', 0, '0', 0, '10', '2', 1, 0, 5);
INSERT INTO addon_specs (aid, addon_pay_methods, addon_name, addon_description, addon_show_description, setup_cost, setup_activate, addon_cost, addon_state, addon_activate, unique_ip, extra_webspace) VALUES (42, '', 'Private Nameservers Example', '', 0, '0', 0, '10', '2', 1, 0, 0);
INSERT INTO addon_specs (aid, addon_pay_methods, addon_name, addon_description, addon_show_description, setup_cost, setup_activate, addon_cost, addon_state, addon_activate, unique_ip, extra_webspace) VALUES (43, '', 'Unique IP Address Example', '', 0, '0', 0, '10', '2', 1, 1, 0);



ALTER TABLE `plan_specs` ADD `addon_gid` BIGINT( 22 ) NOT NULL AFTER `gid` ;
ALTER TABLE `session_history` ADD `addon_choices` TEXT NOT NULL AFTER `domain_expire` ;
ALTER TABLE `hosting_order` ADD `addon_choices` TEXT NOT NULL AFTER `payment_term` ;
ALTER TABLE `hosting_order` ADD `next_due_date` TEXT NOT NULL AFTER `uid` ;

ALTER TABLE `payment_process` ADD `x_gateway` VARCHAR( 255 ) NOT NULL AFTER `name` ,
ADD `x_Login` VARCHAR( 255 ) NOT NULL AFTER `x_gateway` ,
ADD `x_Password` VARCHAR( 255 ) NOT NULL AFTER `x_Login` ,
ADD `x_Currency_Code` VARCHAR( 5 ) NOT NULL AFTER `x_Password`,
ADD `x_fields` TEXT NOT NULL AFTER `x_Currency_Code` ;

INSERT INTO `payment_process` ( `pid` , `demo` , `name` , `x_gateway` , `x_Login` , `x_Password` , `x_Currency_Code` , `paypal_address` , `paypal_image_url` , `checkout_sid` , `paysystems_companyid` , `worldpay_id` , `worldpay_cc` , `worldpay_demo` , `worldpay_callback` , `plugnpay_subject` , `plugnpay_publisheremail` , `plugnpay_publishername` , `plugnpay_cardallowed` , `bymail_to` , `bymail_address1` , `bymail_address2` , `bymail_city` , `bymail_state` , `bymail_zip` , `status` , `default_email` ) VALUES (8, '0', 'Authorize.net', '', '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '');

Added new variable {{temporary_path}} and updated the email template. Running the
following sql will allow the scripts send out the correct temp. path in the welcome email
if you order a dedicated IP.

update email_templates set name='Hosting Account Installed - Client Email', subject='{{domain_name}} has been installed on our servers', message='Your new site, on our servers, is now fully operational and awaits publication of your code!\r\n \r\n------------------------------------------------------\r\nYOUR NEW HOSTING ACCOUNT INFORMATION\r\n------------------------------------------------------\r\n\r\nDomain: {{domain_name}}\r\n\r\nTemporary Web Path: http://{{temporary_path}}\r\n(until your domain name resolves, use this link to access your site)\r\n\r\nIP: {{ip}}\r\n\r\nUsername: {{whm_username}}\r\n\r\nPassword: {{whm_password}} (please note password is CaSe SeNsItIvE)\r\n\r\nSMTP/POP3 mail server: mail.{{domain_name}}\r\n* email will not work until your domain resolved to our servers.\r\n\r\n------------------------------------------------------\r\n IMPORTANT INFORMATION\r\n------------------------------------------------------\r\n\r\nCPanel Login:\r\nUsing CPanel, you can completely administer your new web hosting account! Login and check it out.\r\n\r\nhttp://{{ip}}/cpanel\r\n\r\nUsername: {{whm_username}}\r\nPassword: {{whm_password}} (please note password is CaSe SeNsItIvE)\r\n\r\nIf this account will use a transferred domain name, please update the DNS at your registrar to use the following servers:\r\n\r\n{{primary_ns}} {{primary_ns_ip}}\r\n{{secondary_ns}} {{secondary_ns_ip}}\r\n\r\nThank you for your order!\r\n\r\nWeb Support Team\r\n\r\nThis message was generated on: {{generate_date}}', attr_avail='{{ip}}|{{whm_username}}|{{whm_password}}|{{domain_name}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{generate_date}}|{{temporary_path}}' where emid='10';

ALTER TABLE `hosting_order` ADD `cont_resolve` INT( 1 ) DEFAULT '1' NOT NULL ;

ALTER TABLE `session_history` ADD `client_notes` TEXT NOT NULL ;
ALTER TABLE `hosting_order` ADD `client_notes` TEXT NOT NULL ;
ALTER TABLE `hosting_order` ADD `admin_notes` TEXT NOT NULL ;


INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` ) VALUES ('33', 'Resend Password: Client Side', 'Account Login Information', 'Greetings, Someone, possibly you, requested account login information for this email address which is associated with a user account at {{site_name}}. Below is your account information: Username: {{username}} Password: {{password}} Network Operations Team {{site_name}}\n\nThis message was generated on: {{generate_date}}', '{{generate_date}}|{{site_name}}|{{username}}|{{password}}|');

Added following lines to /public_html/inc/var.php
// Enter the path to curl or leave blank to use the PHP Curl functions
// ex. /usr/bin/curl
$curl_root="";

// Have resolver check for expired domains?
$run_domain_expire="yes"; // or no

Added image: /public_html/admin/themes/blue/main_general_block.php
-> Authorize.net support

Added image: /public_html/admin/themes/blue/images/authorize.gif
-> Authorize.net support

Added file: /public_html/admin/process_batch.php
-> Authorize.net support

Added file: /public_html/admin/authnet_functions.php
-> Authorize.net support.

Added file: /public_html/inc/auth_functions.php
-> Authorize.net support.

Added file: /pubilc_html/credit_card.php
-> Authorize.net support.

Added file: /public_html/authnet_success.php
-> Authorize.net support.

Added file: /public_html/admin/tools/authnet_functions.php
- Authorize.net support.

Added file: /public_html/admin/addon_migration.php
-> support for new addon management tools.

Added file: /public_html/admin/addon_edit.php
-> support for new addon management tools.

Added file: /public_html/admin/addon_build.php
-> support for new addon management tools.

Added file: /public_html/admin/addon_group_editor.php
-> support for new addon management tools.

Edited file: /public_html/admin/invoice_new.php
-> bugfix for the "Printer Friendly".
-> Authorize.net support.

Edited file: /public_html/new_affiliate.php
-> fixed stripslashes bug - Thanks Brian.

Edited file: /public_html/client_view_news.php
-> fixed stripslashes bug - Thanks Brian.

Edited file: /public_html/clogin.php
-> added dynamic email template

Edited file: /public_html/elogin.php
-> added dynamic email template

Edited file: /public_html/admin/client_view_edit.php
-> support for new addon management tools.
-> resolved "suspended showing as cancelled" bug.

Edited file: /public_html/inc/select.php
-> Remove USSR, Byleorussian SSR, and changed Wallis to Wallis and Futuna - Thanks Robert.

Edited file: /public_html/admin/client_view.php
-> support for new addon management tools.
-> fixed bug with affiliate system unique to version 2.1.0 beta

Edited file: /public_html/admin/tools/client_view_complete_inc.php
-> support for new addon management tools.

Edited file: /public_html/admin/tools/client_view_account_info.php
-> support for new addon management tools.
-> fixed bug with affiliate system unique to version 2.1.0 beta
-> fixed bug with semi-annual payment terms not displaying correctly

Edited file: /public_html/admin/tools/client_management_server_form_inc.php
-> support for new addon management tools.
-> fixed bug with displaying payment graphics.
-> Authorize.net support.

Edited file: /public_html/admin/tools/client_management_addon_form_inc.php
-> support for new addon management tools.

Edited file: /public_html/admin/tools/client_management_complete_inc.php
-> support for new addon management tools.
-> Authorize.net support

Edited file: /public_html/admin/tools/client_management_complete_na_inc.php
-> support for new addon management tools.
-> Authorize.net support

Edited file: /public_html/admin/tools/client_management_select_inc.php
-> fixed image path issue for creating new accounts.

Edited file: /public_html/admin/tools/csv_complete.php
-> Authorize.net support

Edited file: /public_html/inc/header.php
-> removed some javascript for support for new addon management tools.

Edited file: /public_html/inc/whm_functions.php
-> bugfix for Monthly New Signups - Thanks Steve.
-> bugfix for Monthly Revenue per Server - Thanks Steve.
-> support for new addon management tools.
-> support for new dedicated IP auto installs.
-> fixed bug with http:// in db record emid=10 in the the email_templates table
-> fixed bug with sending duplicate emails
-> fixed bug with not sending welcome email to clients on mail in payment
-> fixed bug with running an individual domain resolve from admin area.
-> Authorize.net support

Edited file: /public_html/inc/client_functions.php
-> support for new addon management tools.
-> added code to resolve errors with affiliate & client area news.
-> added code for email template

Edited file: /public_html/admin/index.php
-> fixed mcrypt migration bug.

Edited file: /public_html/admin/index2.php
-> fixed resold accounts count bug.

Edited file: /public_html/admin/plan_edit.php
-> support for new addon management tools.

Edited file: /public_html/admin/payment_process.php
-> Authorize.net support.

Edited file: /public_html/admin/plan_build.php
-> support for new addon management tools.

Edited file: /public_html/admin/group_editor.php
-> fixed issue with auto-population of payment processors.
-> added authorize.net support

Edited file: /public_html/admin/client_email.php
-> important bugfix.

Edited file: /public_html/admin/client_cancel_account.php
-> Bug fix - cancel account date issue.

Edited file: /public_html/admin/csv_server.php
-> support for new addon management tools.

Edited file: /public_html/admin/csv_addon.php
-> support for new addon management tools.

Edited file: /public_html/admin/tools/csv_addon.php
-> support for new addon management tools.

Edited file: /public_html/admin/tools/payment_process_email.php
-> Authorize.net support.

Edited file: /public_html/admin/themes/blue/header.php
-> support for new addon management tools.

Edited file: /public_html/admin/themes/blue/main_general_block.php
-> support for new addon management tools.

Edited file: /public_html/client_view.php
-> support for new addon management tools.

Edited file: /public_html/tools/client_view_account_info.php
-> support for new addon management tools.

Edited file: /public_html/tools/client_view_domains.php
-> fixed bug - resend logins issue
-> fixed bug - cancel button not showing when viewing active accounts.

Edited file: /public_html/cancel_account.php
-> bug fix for cancel account.

Edited file: /public_html/cancel_revoke.php
-> bug fix for cancel account.

Edited file: /public_html/client_area.php
-> resend logins issue

Edited file: /public_html/step_one.php
-> support for new addon management tools.
-> Authorize.net support

Edited file: /public_html/step_two.php
-> support for new addon management tools.

Edited file: /public_html/step_three.php
-> support for new addon management tools.

Edited file: /public_html/step_four.php
-> support for new addon management tools.

Edited file: /public_html/verify_order.php
-> support for new addon management tools.
-> Authorize.net support

Edited file: /public_html/invoice_new.php
-> support for new addon management tools.

Edited file: /public_html/mail_payment.php
-> support for new addon management tools.
-> Fixed some broken HTML.

Edited file: /public_html/paypal_success.php
-> support for new addon management tools.
-> support for new dedicated IP auto installs.

Edited file: /public_html/worldpay_success.php
-> support for new addon management tools.
-> support for new dedicated IP auto installs.

Edited file: /public_html/2checkout_success.php
-> support for new addon management tools.
-> support for new dedicated IP auto installs.

Edited file: /public_html/tpp_pro_success.php
-> support for new addon management tools.
-> support for new dedicated IP auto installs.

Edited file: /public_html/new_affiliate.php
-> fixed bug with one time / percent mix up.

Edited file: /public_html/admin/client_view_edit.php
-> fixed suspended accounts displaying as cancelled in the admin area.

##~~~~
## START Release Version R2.0.5 - 3/27/2003 ---------------------------------------------------------
##~~~~

Critical Updates:
/public_html/cancel_account.php
/public_html/affiliate_view.php
/public_html/cancel_revoke.php
/public_html/client_view.php
/public_html/trouble_ticket_view.php
/public_html/verify_order.php
/public_html/mail_payment.php

/public_html/tools/client_view_account_info.php
/public_html/tools/client_view_domains.php
/public_html/tools/client_view_new_order.php

/public_html/inc/affiliate_functions.php
/public_html/inc/client_functions.php
/public_html/inc/whm_functions.php

/public_html/admin/affiliate_accounting.php
/public_html/admin/affiliate_details_view.php
/public_html/admin/client_email.php
/public_html/admin/client_cancel_account.php
/public_html/admin/client_view.php
/public_html/admin/client_view_edit.php
/public_html/admin/client_management.php
/public_html/admin/client_view_edit.php
/public_html/admin/csv_change_owner.php
/public_html/admin/csv_pri_2_user.php
/public_html/admin/group_editor.php
/public_html/admin/server_position.php
/public_html/admin/trouble_ticket_closed.php

/public_html/admin/tools/client_view_domains.php

Database Changes:
ALTER TABLE `plan_specs` ADD `whm_id` BIGINT( 22 ) NOT NULL AFTER `gid` ;
ALTER TABLE `plan_groups` ADD `group_payment` VARCHAR( 255 ) NOT NULL AFTER `name` ;
ALTER TABLE `payment_process` ADD `default_email` TEXT NOT NULL;
ALTER TABLE `hosting_order` ADD `client_ip` VARCHAR( 25 ) NOT NULL ;
ALTER TABLE `payment_process` ADD `paypal_image_url` VARCHAR( 255 ) NOT NULL AFTER `paypal_address` ;

Added file: /public_html/admin/tools/payment_process_email.php
Added file: /public_html/admin/invoice_new.php

Edited file: /public_html/verify_order.php
Edited file: /public_html/2checkout_success.php
Edited file: /public_html/paypal_success.php
Edited file: /public_html/ttp_pro_success.php
Edited file: /public_html/worldpay_success.php
-> logging IP/Order now.

Edited file: /public_html/tools/client_view_new_order.php

Edited file: /public_html/admin/tools/client_view_info.php
-> added support to show how the client found us.
-> added support to show who referred orders, if any.

Edited file: /public_html/admin/client_view.php
-> added support to show how the client found us.
-> added support to show who referred orders, if any.

Edited file: /public_html/admin/tools/client_view_account_info.php
-> added the ability to change the "Installed on:" server for active account. This tool does not actually
move the account to a new server. It only makes the change in the AP database.

Edited file: /public_html/admin/payment_process.php
-> added support for custom emails per payment processors
-> added the ability to add your custom logo for paypal

Edited file: /public_html/inc/whm_functions.php
-> added switch for custom emails per payment processors
-> added link to the support forums
-> added identifier "Domain Registration" to the "Addons Ordered:" portion of the "New Account Installed" (emid = 7) email.

Edited file: /tools/client_view_info.php
-> fixed bug associated with the zip code.

Edited file: /public_html/admin/group_editor.php
-> added in support for disabling payment processors per group.

Edited file: /public_html/admin/plan_build.php
-> added advanced Auto Install options.

Edited file: /public_html/admin/server_edit.php
-> removed obselete Auto-install notifications.

Edited file: /public_html/inc/whm_functions.php
-> added advanced Auto Install functions.

Edited file: /public_html/step_one.php
-> added advanced Auto Install functions.

Edited file: /public_html/step_two.php
-> added advanced Auto Install functions.

Edited file: /public_html/verify_order.php
-> added advanced Auto Install functions.

Edited file: /public_html/2checkout_success.php
-> added advanced Auto Install functions.

Edited file: /public_html/tpp_pro_success.php
-> added advanced Auto Install functions.

Edited file: /public_html/paypal_success.php
-> added advanced Auto Install functions.

Edited file: /public_html/worldpay_success.php
-> added advanced Auto Install functions.

Edited file: /public_html/invoice_new.php
-> added advanced Auto Install functions.

Edited file: /public_html/admin/index.php
-> added advanced Auto Install functions.

Edited file: /public_html/admin/index2.php
-> added advanced Auto Install functions.

Edited file: /public_html/admin/plan_build.php
-> added advanced Auto Install functions.

Edited file: /public_html/admin/tools/client_view_info.php
-> fixed bug with not being able to edit email and also
added the ability to see the Phone and Fax number for the client.


##~~~~
## START Release Version R2.0.2 - 3/14/2003 ---------------------------------------------------------
##~~~~
DATABASE CAHNGES:
ALTER TABLE `payment_process` ADD `worldpay_id` VARCHAR( 255 ) NOT NULL AFTER `checkout_sid` ;
ALTER TABLE `payment_process` ADD `worldpay_cc` VARCHAR( 6 ) NOT NULL AFTER `worldpay_id` ;
ALTER TABLE `payment_process` ADD `worldpay_demo` INT( 3 ) DEFAULT '0' NOT NULL AFTER `worldpay_cc` ;
ALTER TABLE `payment_process` ADD `worldpay_callback` VARCHAR( 255 ) NOT NULL AFTER `worldpay_demo` ;
INSERT INTO payment_process (pid, demo, name, paypal_address, checkout_sid, paysystems_companyid, worldpay_id, plugnpay_subject, plugnpay_publisheremail, plugnpay_publishername, plugnpay_cardallowed, bymail_to, bymail_address1, bymail_address2, bymail_city, bymail_state, bymail_zip, status) VALUES (2, 0, 'WorldPay Future Pay', '', '', '', '60558', '', '', '', '', '', '', '', '', '', '', 1);

Added file: /public_html/admin/group_editor.php
Note: Removed the group management tool from plan_build.php and created a replacement tool to take it's place.
The new tool is located in Manage Hosting Plans drop down menu.

Added file: /public_html/worldpay_success.php
Added file: /public_html/admin/tools/worldpay_select.php
Added file: /public_html/admin/client_email.php
Added File: /public_html/admin/manage_session_history.php
Added File: /public_html/admin/manage_session_history_complete_order.php
Added graphic: /public_html/admin/themes/blue/worldpay.gif
Added graphic: /public_html/admin/themes/blue/images/view_invoice.gif
Added graphic: /public_html/admin/themes/blue/images/down_arrow.gif

Edited file: /public_html/admin/themes/blue/main_news_block.php
-> added in support for more than 75 chars in the news and updates block. Also added in 2 new links in
in that block that allow 1 click access to our bug track and support desk systems.

Edited file: /public_html/admin/themes/blue/main_general_block.php
-> added support for the Manage Incomplete Orders tool.
-> added support for the client email tool.

Edited file: /public_html/step_one.php
-> scripts will not delete locked records from session history.

Edited file: /public_html/admin/plan_build.php
-> removed group management support.

Edited file: /public_html/admin/themes/blue/header.php
-> added a group management tool.

Edited file: /public_html/admin/index2.php
Edited file: /public_html/admin/main_news_block.php
Edited file: /public_html/admin/mib_all_news.php
Edited file: /public_html/inc/whm_functions.php
-> Added more the ability to have more than 75 chars of news displayed and also direct links to support and bug reporting

Edited file: /public_html/admin/themes/blue/main_general_block.php
-> added link it client_email.php

Edited file: /public_html/admin/client_view_edit.php
-> added the ability to view a printable invoice of original order.

Edited file: All files in /public_html/admin/ for normal or strong security switch.

Edited file: /public_html/inc/var.php
-> added in variable for strong security or not.
-> Add this code anywhere in /public_html/inc/var.php: $strong_security="no"; // yes == strong security, no == normal security

NOTE: Setting $strong_security="no" will allow you to do things like refresh the browser and use the back button.

Edited file: /public_html/client_area.php
-> Added switch to resend the right welcome email based on resolved status.

Edited file: /public_html/admin/client_management.php
-> Added switch to resend the right welcome email based on resolved status.

Edited file: /public_html/verify_order.php
-> Now script does not send emails at the wrong time.

Edited file: /public_html/verify_order.php
-> Fixed title tag for monthly cost.

Edited file: /public_html/admin/payment_process.php
-> Added WorldPay support

Edited file: /public_html/step_one.php
-> Added WorldPay support

Edited file: /public_html/verify_order.php
-> Added WorldPay support

##~~~~
## START Release Version R2.0.2 - 3/3/2003 ---------------------------------------------------------
##~~~~
DATABASE CHANGES:
ALTER TABLE `payment_process` ADD `demo` INT( 1 ) DEFAULT '0' NOT NULL AFTER `pid` ;

INSERT INTO payment_process (pid, name, paypal_address, checkout_sid, paysystems_companyid, plugnpay_subject, plugnpay_publisheremail, plugnpay_publishername, plugnpay_cardallowed, bymail_to, bymail_address1, bymail_address2, bymail_city, bymail_state, bymail_zip, status) VALUES (4, '2Checkout', '', '37177', '', '', '', '', '', '', '', '', '', '', '', 1);

ALTER TABLE `plan_specs` ADD `monthly_pid` VARCHAR( 32 ) NOT NULL AFTER `annual_cost` ,
ADD `quarterly_pid` VARCHAR( 32 ) NOT NULL AFTER `monthly_pid` ,
ADD `semi_annual_pid` VARCHAR( 32 ) NOT NULL AFTER `quarterly_pid` ,
ADD `annual_pid` VARCHAR( 32 ) NOT NULL AFTER `semi_annual_pid` ;

Edited file: /public_html/admin/plan_build.php
-> Added 2co support

Edited file: /public_html/admin/payment_process.php
-> Added 2co. support
-> 3/4/2003 -> added fix for demo not updating.

Edited file: /public_html/step_one.php
-> Added 2co. support

Edited file: /public_html/step_two.php
-> Added 2co. support

Edited file: /public_html/step_four.php
-> Added 2co. support

Edited file: /public_html/verify_order.php
-> Added 2co. support

Added file: /public_html/2checkout_success.php


##~~~~
## START Release Version R2.0.2 - 2/26/2003 ---------------------------------------------------------
##~~~~

Edited file: /public_html/inc/whm_functions.php
-> Fixed logic error line 682 in the current_server() function which caused all account to auto install.

Edited file: /public_html/admin/plan_edit.php
-> Added direct links to every plan.

Edited file: /public_html/step_one.php
-> Fixed bug for hidden package display and also Javascript error when only 1 package exists for group.

Edited file: /public_html/inc/step_one_tables.php
-> Removed call to create variable GID if not set.

##~~~~
## START Release Version R2.0.2 - 2/21/2003 ---------------------------------------------------------
##~~~~

DATABASE CHANGES:
ALTER TABLE `user` ADD `reseller` INT( 1 ) DEFAULT '0' NOT NULL AFTER `status` ,
ADD `reseller_primary_domain` BIGINT( 22 ) NOT NULL AFTER `reseller` ,
ADD `reseller_profile` BIGINT( 22 ) NOT NULL AFTER `reseller_primary_domain` ;
ALTER TABLE `hosting_order` ADD `reseller` INT( 1 ) DEFAULT '0' NOT NULL AFTER `status` ;

Added File: /public_html/admin/csv.php
Added File: /public_html/admin/csv_user.php
Added File: /public_html/admin/tools/csv_user.php
Added File: /public_html/admin/csv_add_user_account.php
Added File: /public_html/admin/csv_reseller_user.php
Added File: /public_html/admin/csv_user_2_reseller.php
Added File: /public_html/admin/csv_add_reseller_accounts.php
Added File: /public_html/admin/csv_pri_2_user.php
Added File: /public_html/admin/csv_change_owner.php
Added File: /public_html/admin/pb_2_ap.php
Added File: /public_html/admin/csv_server.php
Added File: /public_html/admin/tools/csv_server.php
Added File: /public_html/admin/csv_edit.php

Edited file: /public_html/inc/whm_functions.php
-> Added functions: write_csv(), clean_record(), display_time(), convert_month(), change_ownership()
-> Added functions: migrate_user_to_phpbb(), reset_phpbb_pw(), reset_phpbb_email(),
-> Added functions: suspend_phpbb_user(), unsuspend_phpbb_user(), delete_phpbb_user()
-> Added functions: get_whois_server(), parse_a(), parse_b(), lookup(), whois_parse()

Edited file: /public_html/admin/affiliate_plan_edit.php
-> Added the ability to reset a commission plan undefined. (delete the plan)

Edited file: /public_html/inc/var.php
-> Added switch for PHPBB integration for testing.

Edited file: /public_html/admin/tools/client_view_account_info.php
-> Added PHPBB integration for testing.

Edited file: /public_html/admin/client_management.php
-> Added PHPBB integration for testing.

Edited file: /public_html/admin/client_view.php
-> Added PHPBB integration for testing.

Edited file: /public_html/paypal_success.php
-> Added PHPBB integration for testing.

Edited file: /public_html/tpp_pro_success.php
-> Added PHPBB integration for testing.

Edited file: /public_html/admin/index2.php
-> Fixed bug with new csv integration and "at a glance menu"

Edited file: /public_html/admin/index2.php
-> Added total resellers, and resold accounts to "at a glance menu"

Edited file: /public_html/admin/themes/blue/main_glance_block.php
-> Added total resellers, and resold accounts to display

* NOTE: The PHPBB compatiable release is located in the /public_html/inc/ directory.
Unfortunately, the PHPBB integration cannot be released to the public just yet.
After all bugs are worked out we will release.


##~~~~
## START Release Version R2.0.2 -2/21/2003 ---------------------------------------------------------
##~~~~

Edited file: /public_html/clogin.php
Edited file: /public_html/elogin.php
-> Changed $admin_email to $email_admin.



##~~~~
## START Release Version R2.0.2 - 2/10/2003 ---------------------------------------------------------
##~~~~

Edited file: /public_html/admin/client_management.php
-> Fixed error with grabbing default IP.



##~~~~
## START Release Version R2.0.2 - 1/24/2003 ---------------------------------------------------------
##~~~~

Edited file: /public_html/admin/affiliate_accounting.php
-> Fixed the "Payable to:" to display the actual payable_to col. from db instead of first/last
name from the user table.

Edited file: /public_html/paypal_success.php
Edited file: /public_html/tpp_pro_success.php
-> Took out second occurrence of add_affiliate_user().

Edited file: /public_html/admin/client_management.php
-> Moved small chunck of code that processes IP to fix the blank IP issue.

Edited file: /public_html/inc/client_functions.php
-> updated the function resend_welcome_email_ip() to not use gethostbyname()

Changed the properties of the session ID from VARCHAR( 8 ) to VARCHAR( 32 )
and also the function create_sid() in the file: /public_html/inc/client_functions.php
-> ALTER TABLE `user` CHANGE `sid` `sid` VARCHAR( 32 ) NOT NULL

Edited file: /public_html/inc/whm_functions.php
-> Added a condition to the reports_monthly_revenue_sales() function to resolve an issue
with reporting false totals.

Edited file: /public_html/admin/index2.php
-> Changed the format of Active Gateway(s) in the "at a glance block".

Edited file: /public_html/admin/themes/blue/main_glance_block.php
-> Removed est. monthly income.



##~~~~
## START Release Version R2.0.1 - 1/24/2003 -------------------------------------------------------
##~~~~

Added column to the server_config table for the server rotation upgrade.
-> ALTER TABLE `server_config` ADD `install_order` INT( 5 ) NOT NULL AFTER `max_accounts`

Changed hosting_order whm_password column to be varchar(32)
-> ALTER TABLE `hosting_order` CHANGE `whm_password` `whm_password` VARCHAR( 32 ) NOT NULL

Added/Updated the email_templates database
-> UPDATE email_templates set name='Max. Clients/Server Reached', subject='Maximum Clients Reached on {{previous_active_server_name}}', message='Hello,\r\n\r\nYou have reached {{max_clients}} clients on {{previous_active_server_name}}. The server is full.\r\n\r\nThe AutoPilot successfully switched {{new_active_server_name}} to the {{server_role}} server.\r\n\r\nYou will need to login to the system and define the next active server.\r\n\r\nThank You.\r\n\r\nYour AutoPilot\r\n\r\nThis message was generated on: {{generate_date}}', attr_avail='{{max_clients}}|{{previous_active_server_name}}|{{new_active_server_name}}|{{server_role}}|{{generate_date}}|' where emid='6';
-> INSERT INTO email_templates (emid, name, subject, message, attr_avail) VALUES (32, 'Max. Clients/Server Reached - No Rotation', '{{server_name}} has reach capaicty', 'Hello,\r\n\r\nYou have reached {{max_accounts}} clients on {{server_name}}. The server is full.\r\n\r\nWe will continue to install accounts on this server until you login to the admin area and define a new active or manual install server.\r\n\r\nThank You.\r\n\r\nYour AutoPilot\r\n\r\nThis message was generated on: {{generate_date}}', '{{max_accounts}}|{{server_name}}|{{generate_date}}|');

Edited file: /public_html/inc/whm_functions.php
-> Added error suppression in terminate_account()

Edited file: /public_html/inc/whm_functions.php
-> Fixed a syntax error in the current_server() function that dealt with manual servers.

Edited file: /public_html/inc/whm_functions.php
-> Added server rotation emails and upgraded auto_switch_server().

Edited file: /public_html/admin/server_edit.php
-> Added role check to ensure that if you only have 1 server, you cannot make that server an
installed server.
-> Added check to prevent an active/manual default server to be demoted to an installed server
without first promoting an installed server to active/manual default.

Edited file: /public_html/admin/server_position.php
-> Upgraded tool for server rotation management.

Edited file: /public_html/admin/themes/blue/header.php
-> Added server rotation menu item to the server management tab.

A full update is reccommended. If you can't do a full update, replacing the following files
with files from release R2.0.1:

INCLUDE DIRECTORY:
/public_html/inc/whm_functions.php
/public_html/inc/client_functions.php
/public_html/inc/affiliate_functions.php

PUBLIC DIRECTORY:
/public_html/tpp-pro_success.php
/public_html/paypal_success.php
/public_html/verify_order.php

ADMIN DIRECTORY
/public_html/admin/client_management.php