$ld$ Revision: 56 Author: brandee Date: 8:59:02 AM, Friday, July 28, 2006 Message: replaced domain with IP on license check to bypass recursive blocking in then named.conf file on servers ---- Modified : /trunk/rename_upload/admin/index.php Revision: 55 Author: brandee Date: 8:58:02 AM, Friday, July 28, 2006 Message: added error checking in activations ---- Modified : /trunk/rename_upload/admin/client_view.php Revision: 54 Author: brandee Date: 8:57:21 AM, Friday, July 28, 2006 Message: added error checking in activations ---- Modified : /trunk/rename_upload/admin/tools/client_view_account_info.php Revision: 52 Author: rockwellpa Date: 3:22:40 PM, Thursday, June 22, 2006 Message: Ticket #SVU-91501, Added code to check for both upper and lower case user entered TLDs. ---- Modified : /trunk/rename_upload/inc/whois.php Revision: 51 Author: rockwellpa Date: 4:15:10 PM, Tuesday, June 20, 2006 Message: No longer parses out ` for mysql 5. ---- Modified : /trunk/rename_upload/inc/install1.php Revision: 50 Author: rockwellpa Date: 2:32:09 PM, Wednesday, June 14, 2006 Message: Ticket #PID-51714, No Credit Card Number error. $ccid was missing, added check to catch missing $ccid and map it out based on UID. ---- Modified : /trunk/rename_upload/admin/view_batch.php Revision: 49 Author: rockwellpa Date: 2:02:30 PM, Wednesday, June 14, 2006 Message: Fixed issue with   display. Changed all instances of   to   ---- Modified : /trunk/rename_upload/admin/view_batch.php Revision: 48 Author: rockwellpa Date: 3:55:45 PM, Wednesday, June 07, 2006 Message: Support ticket #IST-91182, sql in query changed to `sql` ---- Modified : /trunk/rename_upload/admin/plan_build.php Revision: 42 Author: brandee Date: 11:48:55 AM, Friday, June 02, 2006 Message: corrected charset ---- Modified : /trunk/rename_upload/inc/whm_functions.php Revision: 41 Author: brandee Date: 11:47:26 AM, Friday, June 02, 2006 Message: fixed charset ---- Modified : /trunk/rename_upload/inc/client_functions.php Revision: 40 Author: eric Date: 9:02:39 AM, Monday, May 15, 2006 Message: * replace all instances of sql with `sql` for mysql v5 compat. ---- Modified : /trunk/rename_upload/2checkout_success.php Modified : /trunk/rename_upload/admin/client_view.php Modified : /trunk/rename_upload/admin/manage_session_history_complete_order.php Modified : /trunk/rename_upload/admin/plan_build.php Modified : /trunk/rename_upload/admin/tools/plan_build.php Modified : /trunk/rename_upload/authnet_success.php Modified : /trunk/rename_upload/cybersource_success.php Modified : /trunk/rename_upload/internet_secure_success.php Modified : /trunk/rename_upload/linkpoint_success.php Modified : /trunk/rename_upload/paypal_success.php Modified : /trunk/rename_upload/psigate_success.php Modified : /trunk/rename_upload/tools/cybersource_success.php Modified : /trunk/rename_upload/tools/step_one_code[0].php Modified : /trunk/rename_upload/tpp_pro_success.php Modified : /trunk/rename_upload/worldpay_success.php Revision: 39 Author: rockwellpa Date: 9:43:59 AM, Wednesday, May 03, 2006 Message: # Prevents cron from running 2x (05-03-2006) # ---------------------------------------------------------- # ALTER TABLE `invoice_config` ADD `cron_ran` DATE NOT NULL; # ALTER TABLE `invoice_config` ADD UNIQUE (`cron_ran`); # ---------------------------------------------------------- @mysql_query("insert into invoice_config set cron_ran='".date('Y-m-d')."'"); if (mysql_error()==1062) { die('Cron has ran for today already.'); } # ---------------------------------------------------------- # end:Prevents cron from running 2x (05-03-2006) ---- Modified : /trunk/rename_upload/admin/cron_invoice.php Revision: 38 Author: brandee Date: 10:48:22 AM, Friday, April 21, 2006 Message: make email address editable for non hosting clients ---- Modified : /trunk/rename_upload/admin/invoice_client_editor.php ########## V2.5.40[n] ############ Modifications made to support MySQL 5 in areas of client & admin area. Revision: 34 was not handling the error handler properly allowing blank values sent resulting in empty emails to the admin for the credit card details ---- Modified : ==> rename_upload/tools/credit_card_code[off0].php Revision: 33 added values to pass through to 2Checkout ---- Modified : ==> rename_upload/tools/verify_order_code[0].php Revision: 32 removed my debug code ---- Modified : ==> rename_upload/inc/whm_functions.php Revision: 31 updated paypal carryover ---- Modified : ==> rename_upload/inc/varilogix_form.php Revision: 30 added simple tag to tell if there is no credit card on file for an offline order ---- Modified : ==> rename_upload/admin/client_view_edit.php Revision: 29 removed unlimited as an option for parked and addon domains ---- Modified : ==> rename_upload/admin/plan_build.php Revision: 28 removed overLIB ---- Modified : ==> rename_upload/admin/invoice_create.php Modified : ==> rename_upload/admin/invoice_edit_billable_service.php Revision: 26 added identity tags to the echo data tags ---- Modified : ==> rename_upload/step_one.php Revision: 25 * vlx doesn't return a proper response when *listed ---- Modified : ==> rename_upload/inc/varilogix_functions.php Revision: 24 added new invoice report to nav ---- Modified : ==> rename_upload/admin/themes/blue/header.php Revision: 23 new invoice report ---- Added : ==> rename_upload/admin/invoice_reporting.php Revision: 22 * URGENT SECURITY FIX: blacklisted numbers can order, which is now fixed using an api response of "blacklist" ---- Modified : ==> rename_upload/process_phone.php Revision: 18 new license system validation during installation ---- Modified : ==> rename_upload/inc/install3.php Modified : ==> rename_upload/inc/install4.php Revision: 16 added new license validation for the new license system so that the EOL can be enforced later this month ---- Modified : ==> rename_upload/admin/index.php Revision: 14 added contact email to WHM activations ---- Modified : ==> rename_upload/inc/whm_functions.php Revision: 13 added the clients email address and that the client owns their account upon activation in autopilot. Also added support for unlimited addon domains ---- Modified : ==> rename_upload/inc/whm_functions.php Revision: 12 fixed affiliate referral ID for email notifications to go to the affiliate as opposed to a random client based on the referring ID ---- Modified : ==> rename_upload/inc/client_functions.php ########## V2.5.35[n] ############ ## FILES TOUCHED ## /inc/whm_functions.php -> now populates the contactemail variable when activating accounts -> if package = ($reseller), reseller will own their main domain in WHM ** ENTIRE ADMIN AREA UPDATE REQUIRED ** This version is built off the new license system. If you do not have a new license key issued to you for the EOL, this version will not activate for you. Your current V2 key will cease to work after -------> APRIL 5, 2006 <------- Failure to obtain your new key and upgrade will cause script failure This upgrade is a required upgrade. ########## V2.5.30 ############ ## DATABASE UPDATE ** ALTER TABLE `tld_chart` ADD `coid` VARCHAR( 32 ) DEFAULT '0' NOT NULL ; ## FILES TOUCHED ## /step_one.php -> added 2Checkout compliance line to footer ( if 2co is active ) /tools/verify_order_code[0].php -> added handler for domain registration 2Checkout package support /tools/step_one_code[0].php -> added 2Checkout compliance line to footer ( if 2co is active ) /credit_card_code[lp0].php -> updated to prevent declined cards from passing /paypal_success.php -> updated ** full admin area update required, as usual ** ########### V2.5.15 ############ This release includes /admin/upgrade_2515.php After files are transfered, visit /upgrade_2515.php to perform the database update. Once completed, please delete that file. ### Database Changes ### ALTER TABLE `config` ADD `maintenance` VARCHAR( 3 ) DEFAULT 'no' NOT NULL AFTER `allow_proxy` ; ALTER TABLE `affiliate_history` ADD `paid_date` INT( 10 ) NOT NULL AFTER `period_of` ; ALTER TABLE `affiliate_details` ADD `last_updated` INT( 10 ) NOT NULL AFTER `ogcreate` ; ALTER TABLE `affiliate_history` CHANGE `owed_to_client` `owed_to_client` DECIMAL( 10, 2 ) DEFAULT '0' NOT NULL ; ALTER TABLE `affiliate_details` CHANGE `total_amount_package` `total_amount_package` DECIMAL( 10, 2 ) DEFAULT '0' NOT NULL ; ALTER TABLE `affiliate_details` CHANGE `total_due_to_client` `total_due_to_client` DECIMAL( 10, 2 ) DEFAULT '0' NOT NULL ; UPDATE `payment_process` SET `name` = 'AlternatePalPay' WHERE `pid` =12 LIMIT 1 ; ### BUGS ZAPPED ### [1] client resend welcome email from client area => /inc/client_functions.php --> resolved issue with 'blank default email' causing mail not to send to client [2] Authorize.net batches not marking invoices as paid when ran => /admin/process_batch.php --> now marks as paid based on IID as opposed to UID [3] tweaked cPanel link in admin => /admin/tools/clinet_view_account_info.php --> uses http://ipaddress:2082/login/?user=username&pass=password to login [4] cancel account now an option in the admin "manage options" for account management => removed suspend account when the account is not even active, only shows after activation [5] Affiliate Accounting Issues => /admin/affiliate_accounting.php => /admin/affiliate_details.php => /admin/cron_affiliate.php => /inc/affiliate_functions.php => /inc/client_functions.php => /affiliate.php ### FILES ADJUSTED ### [1] /admin/config_editor.php => added 'maintenance' switch --> if set to yes, your entire order system will show as under maintenance and not accept orders --> requires /inc/header.php update [2] /inc/header.php => added 'maintenance' switch [code added to top of file] if($maintenance=="yes") { header("Location: ".$http_web."/maintenance.php"); exit; } [end code added] [3] /maintenance.php => file added to display your maintenance page ** this can be edited to suit your needs ** ############## CHANGE LOG ############## ############### v2.5.12 ############### Upgrade Standards: [1] always completely replace/upload the /admin folder [ all contents ] [2] always update/upload the /inc/config.php folder ** these items are not mentioned in changelog ** If you are running v2.5.1, you can perform a quick file transfer from here http://www.whmautopilotlicensing.com/d/quickup/upgrade_2512.php user: autopilot pass: upgrade This release has NO database update, file updates only. There are still a few bugs being worked on in the FraudGate "before the sale" hanlder. We recommend utilizig the 'after the sale' preference when activating this screening system until we pull it out of testing and deem stable. # Bugs Resolved in v2.5.12 [1] Dual PayPal display at step_one.php when only one is active ==> touched /tools/step_one_code.[0].php ==> touched /admin/payment_process.php [ encrypted ] [2] Domain Registration 'tick' with Mail In Payment * would show as 'you will register' if they chose for the company to register * ==> touched /tools/verify_order_code[0].php [3] Addon names no longer display if they have a description ** only in the admin area ** ==> touched /admin/addon_edit.php [ encrypted ] [4] Java 'error' at step_three.php ==> touched /tool/step_three_code[0].php [5] Daily invoice reports now show all invoices unpaid, not just past-due --> also now displays all new gateways added since v2.4.5 ==> touched /inc/invoice_functions.php [ encrypted ] [6] Surpressing server stats on homepage fixed. ** it was still connecting, just not displaying ** ==> touched /admin/index2.php [ encrypted ] [7] Domain registrations charged twice --> if domain registration selected & free trial active --> it would collect fees for domain & charge again after free trial ==> touched /tools/verify_order_code[2].php ==> touched /verify_order.php [8] VariLogix handler tweak ==> touched /process_phone.php # Tweaks [1] Added gateway cycle summaries to admin ==> touched /admin/index2.php [ encrypted ] =[new]=> /admin/themes/blue/income_breakdown.php =[new]=> /admin/themes/blue/images <= mutliple new images [2] Added display if invoices are marked "past due" ** will show a past due balance upon login to client area ** ==> touched /tools/client_view_domains.php [3] Added pagination to client_view.php in admin area --> sorts orders in pages of 100 orders per page --> sorts orders "active" per gateway --> has option to show all orders with no pagination ** will drastically speed up this page for those with more than 500 domains ** ==> touched /admin/client_view.php [ encrypted ] [4] Added redirect file to admin area =[new]=> /admin/redirect.php [ encrypted ] ** strips referrer from link out of admin area ** ###### CHANGELOG V2.5.1 ###### Upgrade Standards: [1] always completely replace/upload the /admin folder [2] always update/upload the /inc/config.php folder ** these items are not mentioned in changelog ** If you are running v2.5.0, you can perform a quick file transfer from here http://www.whmautopilotlicensing.com/d/quickup/index.php user: autopilot pass: upgrade DATABASE UPDATE: maintenance_v251.sql ** IN THE SQL FOLDER ** ###################################### Client Area File Changes: /mail_payment.php -> informational display -> auto-fill of server & cPanel user information in order ** no longer requires manual input before activation ** /cybersource_success.php [ encrypted file ] -> fixed 404 error in service invoice payment return /invoice_hosting_payable.php -> fixed error of 0.00 with Cybersource invoices on recurring invoices /billing_history.php -> if invoice is not paid, it will state 'unpaid' next to invoice -> if unpaid, link to view will take them to invoice_hosting_payable.php -> if paid, link to view invoice will take them to invoice_hosting.php /2Checkout_success.php [ encrypted file ] -> removed debugging tags ####### FRAUDGATE ADDED / TOUCHED FILES ###### [--- this is in beta testing mode ---] The fraudgate system works whereas if the order 'fails' the phone validation, the order will automatically change from 'pending' to suspending in the order sysetm and will display as suspended when viewing your accounts list. If a pending order is 'suspended', it will not display in your pending orders list. You have the ability to change that to any option in the config settings. This module was writtend directly from FraudGate and all errors or bugs are to be reported through us and we'll pass them on to Alexander at FraudGate for repairs. ###################################### /invoice_new.php [ edited ] /receive_call.php [ NEW ] /step_four.php [ edited ] /step_fraudgate_one.php [ NEW ] /step_fraudgate_two.php [ NEW ] /step_fraudgate_three.php [ NEW ] /tools/verify_order_code[0].php [ edited ] /tools/verify_order_code[2].php [ edited ] /inc/step_fraudgate_form.php [ NEW ] /inc/languages/english/step_fraudgate.php [ NEW ] ++++++ CHANGES IN V2.5.0 ++++++ You must be running v2.4.7 in order to upgrade to this version without errors. If you are not running v2.4.7, please upgrade to that version before upgrading to this non-public BETA release. ### FEEDBACK AVENUE ### Please forward all feedback directly to bdiggs@benchmarkdesigns.net ### BUGS RESOLVED ### [1] Internet Secure not passing through coupon discounts [2] WorldPay[2] errors passed to gateway ### ISSUES ADDRESSED AND RESOLVED ### [1] File Include Vulnerability [2] Cross Site Scripting (XSS) Vulnerability [3] Information Disclosure --> after installation, please delete the phpinfo.php file so that your server information is not public information ### RELEASE INFORMATION ### OffLine Credit Card Gateway The offline credit card gateway will accept orders via credit card without any live authorization of the credit card. What the module will do is snip the card into two piece and send the middle portion of the credit card, as the processing key. This key is sent to a seperate email address, configured at the gateway setup, and will only be sent once. The rest will be sent in EMID 112 as the offline confirmation of the clients information. ### DATABASE UPDATES ### ALTER TABLE `payment_process` ADD `offline_email` TEXT NOT NULL AFTER `plugnpay_cardallowed` ; INSERT INTO `payment_process` VALUES (15, 0, 'Credit Card', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 1, ''); ALTER TABLE `session_history` ADD `offcid` BIGINT( 22 ) NOT NULL AFTER `lpid` ; ALTER TABLE `hosting_order` ADD `offcid` VARCHAR( 22 ) NOT NULL AFTER `lpid` ; CREATE TABLE `offline_holding_queue` ( `offcid` bigint(22) unsigned NOT NULL auto_increment, `sid` varchar(32) NOT NULL default '', `oid` bigint(22) NOT NULL default '0', `uid` bigint(22) NOT NULL default '0', `startdate` text NOT NULL, `chargetotal` float NOT NULL default '0', `recurringamount` float NOT NULL default '0', `periodicity` text NOT NULL, `comments` varchar(255) default NULL, `cardnumber` varchar(255) NOT NULL default '0', `cardexpmonth` varchar(255) NOT NULL default '0', `cardexpyear` varchar(255) NOT NULL default '0', `ip` varchar(255) default NULL, `name` varchar(255) default NULL, `address1` varchar(255) default NULL, `city` varchar(255) default NULL, `state` varchar(255) default NULL, `country` varchar(255) default NULL, `phone` varchar(255) default NULL, `fax` varchar(255) default NULL, `email` varchar(255) default NULL, `zip` varchar(255) default NULL, `status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`offcid`) ) TYPE=MyISAM COMMENT='Holding Queue for offline processor' AUTO_INCREMENT=1 ; INSERT INTO `email_templates` VALUES (112, 'Offline Credit Card Confirmation', '[112] Confirmation Information for {{client_name}} on {{generate_date}}', 'Client Information:\r\n\r\n{{name}}\r\n{{address1}}\r\n{{city}}, {{state}} {{zip}}\r\n{{country}}\r\n\r\nPhone: {{phone}}\r\nFax: {{fax}}\r\nEmail: {{email}}\r\n\r\n====================\r\nCard Number: {{cardnumber}} Exp: {{cardexpmonth}} / {{cardexpyear}}\r\nCard Type: {{cardtype}}\r\n====================\r\n\r\nDomains: {{comments}}\r\nBilling Cycle: {{periodicity}}\r\n\r\nCharge Total Today: {{charge_total}}\r\nTotal to Reoccur: {{recurring_amount}}\r\n\r\n===========================', '{{generate_date}}|{{client_name}}|{{comments}}|{{periodicity}}|{{cardnumber}}|{{cardtype}}|{{cardexpmonth}}|{{cardexpyear}}|{{name}}|{{address1}}|{{city}}|{{state}}|{{country}}|{{phone}}|{{fax}}|{{email}}|{{zip}}|{{charge_total}}|{{recurring_amount}}', ''); ### FILES TOUCHED / CHANGED ### /admin/group_editor.php -> add handler /admin/index2.php -> add images /admin/client_view_edit.php -> add images /admin/payment_process.php -> added gateway /tools/step_one_code[0].php -> added gateway /step_one.php -> added gateway /tools/verify_order_code[0].php -> added gateway handler /tools/verify_order_code[2].php -> added gateway handler /invoice_hosting_payable.php -> added handler /invoice_service_payable.php -> added handler /invoice_hosting.php -> added image /invoice_service.php -> added image ### NEW FILES ### /credit_card_off.php -> new file for offline processing /offline_success.php -> handler for offline credit card processing /invoice_ocredit_card.php -> new file for offline invoice payments /admin/themes/blue/images/offlinecc_gif.gif -> admin area image /admin/themes/blue/images/offlinecc.gif -> client side image // version 2.4.7 Release - Date: December 30, 2004 \\ // always upload the FULL /admin folder on all updgrades \\ // always be sure to upload the /inc/connect.php on upgrades \\ ++++++++ CHANGES V2.4.7 ++++++++ BUGS FIXED: [1] admin log rotation on all logins [2] PayPal duplications caused by IPN dual passback [3] 2Checkout orders reverting to blank values on invoice_new.php [4] nameservers not displaying on pending orders [5] undefined function display_country() in auth batches [6] password encryption error on completion of incomplete orders [7] password encryption error on creation of users through invoice area TWEAK ADDED: [1] display fraud-score from VariLogix when viewing orders that have gone through the system ### DATABASE CHANGES ### ALTER TABLE `config` ADD `activate_serverstats` CHAR( 3 ) DEFAULT 'yes' NOT NULL AFTER `activate_support` ; ### FILES ALTERED OR CHANGED ### ** MULTIPLE ADMIN FILES - FULL FOLDER SHOULD ALWAYS BE UPLOADED FOR /admin *** /2checkout_success.php -> fixed error in account creation /invoice_new.php -> now displays nameservers on pending accounts /inc/auth_functions.php -> display_country() value re-inserted /inc/login_functions.php -> the access log rotation mdY issue resolved that rotated logs upon login, each instance /process_phone.php -> corrected score recordation ** all success files touched ** -> corrected insertion of fraud_score into hosting_order table after completion /tools/verify_order_code[0].php -> fixed paypal issue with duplicate IPN postings /inc/connect.php -> added `activate_serverstats` variable to vars // version 2.4.6.5 Release - Date: November 30, 2004 \\ // always upload the FULL /admin folder on all updgrades \\ // always be sure to upload the /inc/connect.php on upgrades \\ ## DATABASE UPDATE ## INSERT INTO `payment_process` ( `pid` , `demo` , `name` , `x_gateway` , `x_Login` , `x_Password` , `x_Currency_Code` , `x_fields` , `paypal_address` , `paypal_image_url` , `checkout_sid` , `co_system` , `paysystems_companyid` , `linkpoint_storeid` , `linkpoint_type` , `psigate_merchant` , `psigate_chargetype` , `psigate_emailclient` , `internetsecure_merchant_id` , `internetsecure_language` , `internetsecure_return_cgi` , `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 ( '14', '0', 'CyberSourceHOP', '', '', '', '', '', '', '', '', '0', '', '', '', '', '0', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '' ); ## FILES CHANGED ## /admin/tools/client_view_account_info -> now displays order number, if captured, for payment gateway /admin/payment_process.php -> gateway activation & information /admin/group_editor.php -> added active per package group /admin/index2.php -> image display for gateway /admin/client_view_edit.php -> image display for gateway /admin/trouble_ticket_active.php -> fixed link to view client area of client submitting ticket /tools/step_one_code[0].php -> gateway select added /tools/verify_order_code[0].php -> cybersource support /tools/verify_order_code[2].php -> cybersource support /inc/select.php -> fixed AuthNET issues with country reverts to US /step_one.php -> cybersource support added /verify_order.php -> cybersource support added /invoice_hosting.php /invoice_service.php /invoice_hosting_payable.php /invoice_service_payable.php -> cybersource support added /linkpoint_success.php -> bug fixed in periodic batch creation -> bug fix in not auto-install /2checkout_success.php -> grabs order_number and inserts into hosting_order table /psigate_success.php -> bug fix in not auto-install /paypal_success.php -> tweaked for client_ip retention /cc_update.php -> fixed bug with country list /authnet_success.php -> fixed bug clean_number() /invoice_new.php -> fixed bug with not displaying 'payment gateway' for new gateways /admin/master_batch.php -> fixed bug with country listing ## NEW FILES ## /cybersource_success.php /inc/mod_HOP.php /admin/themes/blue/images/cybersource_gif.gif /admin/themes/blue/images/cybersource.gif /admin/themes/blue/images/lp_rec_active.gif /admin/themes/blue/images/lp_rec_notactive.gif // version 2.4.6 Release - Date: November 12, 2004 \\ // always upload the FULL /admin folder on all updgrades \\ // always be sure to upload the /inc/connect.php on upgrades \\ ### BUGS ZAPPED ### [1] EMID 8 Duplicated to Admin -> fix function in whm_functions.php on accout receipt --> now sends EMID 7 to admin ( correct ) --> now sends EMID 8 to the client ONLY if there is no default email set at the payment gateway --> Admin will get a CC of EMID 8 ( or the gateway email ) ** all gateway emails will need to be reset to default, then edited over again to correct ** [2] Table Offset in client_view.php -> fixed tag location for the in the Addon table to prevent the table from looking 'offset' when no addons are active. [3] Admin Management email bug -> was not holding the admin email during creation of admins causing admin resends to fail ** to reset your admin, delete ALL admins from the admin management and recreate w/ emails ** [4] invoice_credit_card.php table offset -> fixed by adding and closing a floating table [5] Addon Math errors -> fixed math function for addons & plan cycle deviations -> corrected math error with annual addons being included in monthly recurring amounts [6] Coupon amounts off ? -> fixed calculations for todays charges coupons [7] TLD Pricing not grabbing 1 year on creation -> fixed missing field result [8] Annual addons showed $domain cost per year as opposed to 'annually' -> corrected language tag in verify_order_code[1].php [9] Domain Registration costs w/ PayPal free trials -> added domain registration costs to be included in the intial payment if domain registration is included in the hosting order. ### Tweaks Added ### [1] Database Optimization -> added function to optimize ALL database tables during the cron_dbbackup.php nightly backups [2] Cloned the following gateways *** this is for multi-currency abilities *** --> PayPal ( shows as PayPal[2] ) --> WorldPay ( shows as WorldPay[2] ) [3] Added Row highlights in client_view.php -> will show red text if required field for activation is blank -> grey highlights show critical fields for activation [4] Tweak '[visit client area]' in client_view.php -> link to clogin.php includes ?username and ?password passed through to autopopulate the fields for login [5] Many forgetting to setup email addresses for the script -> added error box on main page when addresses are missing [6] Reports of orders not working due to gateways not active -> added simple error box on main page if no gateways are activated *** Manual Fraud Check Items Added *** [7] Added free email check in client_view.php [8] Changed the IP lookup link to a IP Geo Lookup in client_view.php [9] Added a whois lookup link for the domain in client_view.php ### Database Changes ### ALTER TABLE `payment_process` ADD `psigate_merchant` VARCHAR( 64 ) NOT NULL AFTER `linkpoint_type` ; ALTER TABLE `payment_process` ADD `psigate_chargetype` VARCHAR( 2 ) DEFAULT '0' NOT NULL AFTER `psigate_merchant` ; ALTER TABLE `payment_process` ADD `psigate_emailclient` VARCHAR( 4 ) NOT NULL AFTER `psigate_chargetype` ; INSERT INTO `payment_process` VALUES (11, 0, 'PSiGate', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', '', '', '0', '1', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 0, ''); INSERT INTO `payment_process` VALUES (12, 0, 'PayPal[2]', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 0, ''); INSERT INTO `payment_process` VALUES (13, 0, 'WorldPay[2]', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', '', '', '0', '', '', '', '', '', 'USD', 0, '', '', '', '', '', '', '', '', '', '', '', 0, ''); CREATE TABLE `psigate_logging` ( `logid` tinyint(22) unsigned NOT NULL auto_increment, `oid` varchar(22) NOT NULL default '', `iid` varchar(22) NOT NULL default '', `sid` varchar(32) NOT NULL default '', `raw_log` text NOT NULL, PRIMARY KEY (`logid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; ### File Changes ### /admin/index2.php -> images /admin/cron_dbbackup.php -> added MySQL database optimization command to optimze the tables nightly /admin/group_editor.php -> gateway active addition /admin/client_view_edit.php -> images /admin/client_view.php -> added area to display PSiGate's postback information per order /admin/tools/client_view_account_info.php -> table offset -> added PSiGate raw data field -> added row highlights /tools/step_one_code[0].php -> added handler /step_one.php -> added data handler /tools/verify_order_code[0].php -> added gateway handler /tools/verify_order_code[2].php -> image display /inc/varilogix_form.php -> added psigate holding function /invoice_hosting_payable.php -> PSiGate handler /invoice_service_payable.php -> PSiGate handler /invoice_credit_card.php -> table offset fixed /invoice_lcredit_card.php -> table offset fixed /inc/languages/english/step_one.php -> changed the transfer text ( misleading ) to "I have a domain and will update my nameservers" /inc/client_functions.php /inc/whm_functions.php /inc/login_functions.php /inc/enom_functions.php -> listed bug fixes & tweaks /inc/connect.php -> version incrementation ### NEW FILES ### /pcredit_card.php -> new file for processing PSiGate orders /psigate_success.php -> landing file for successful orders /psigate_errors.php -> landing file for orders with errors that will redirect back to fix errors /psigate_invoice_errors.php -> landing file for errors during invoice payment /psigate_invoice_service_success.php -> landing file for successful service invoice payments /psigate_invoice_success.php -> landing file for successful hosting invoice payments /tools/credit_card_code[ps0].php -> handler for new orders /tools/credit_card_code[ps1].php -> handler for invoice_hosting_payable.php /tools/credit_card_code[ps2].php -> handler for invoice_service_payable.php /invoice_pcredit_card.php -> payment file for processing invoice payments /inc/languages/english/pcredit_card.php /inc/languages/english/invoice_pcredit_card.php Maintenance Release - Version 2.4.5.6 [ new gateway / tweaks ] -- October 16, 2004 ############################################################################### New Files: /inc/lpnt.pem --> RSA & CERT File /inc/lphp.php /tools/credit_card_code[lp0].php /tools/credit_card_code[lp1].php /tools/credit_card_code[lp2].php /lcredit_card.php /inc/languages/english/lcredit_card.php /invoice_lcredit_card.php /inc/languages/english/invoice_lcredit_card.php /linkpoint_success.php /admin/linkpoint_holding.php /admin/linkpoint_holding_view.php /admin/themes/blue/images/lpoint_gif.gif /admin/themes/blue/images/linkpoint.gif --> graphics for gateway Files Touched: /admin/payment_process.php -> added handler for LinkPoint /admin/group_editor.php -> edited all lines for activation of gateway /admin/index2.php -> added image for display in areas /admin/client_view_edit.php -> added image for display in areas /tools/step_one_code[0].php -> added handler for new gateway /step_one.php -> added data row for new gateway /tools/verify_order_code[0].php -> linkpoint handler added /tools/verify_order_code[2].php -> linkpoint handler added /invoice_hosting.php /invoice_hosting_payable.php /invoice_service.php /invoice_service_payable.php -> added graphic call for LinkPoint -> [payable]-> added linkpoint handler /inc/client_functions.php -> image handler for LinkPoint *** items remedied in this release *** Items that have been floating /tools/client_view_news.php -> no longer shows a code error if no news is in place ** also tweaked client_functions.php to surpress the affiliate paragraph errors if none exists ** /inc/affiliate_functions.php -> released unencrypted to allow editing of text & expansion by others /tools/step_three_code[0] -> fixed FireFox and Netscape issues with clickables /process_phone.php -> varilogix functions tweaked /2checkout_success.php -> fixed IP retaining of client ( no longer displays 2checkout IP ) /2checkout_success.php /worldpay_success.php /paypal_success.php /tpp_pro_success.php /authnet_success.php -> fixed issue with initial invoices not being marked as paid DATABASE UPDATES: ========================================= CREATE TABLE `linkpoint_holding_queue` ( `lpid` bigint(22) unsigned NOT NULL auto_increment, `sid` varchar(32) NOT NULL default '', `oid` bigint(22) NOT NULL default '0', `uid` bigint(22) NOT NULL default '0', `startdate` text NOT NULL, `chargetotal` float NOT NULL default '0', `periodicity` text NOT NULL, `thisgoesin` varchar(255) default NULL, `comments` varchar(255) default NULL, `cardnumber` varchar(255) NOT NULL default '0', `cardexpmonth` varchar(255) NOT NULL default '0', `cardexpyear` varchar(255) NOT NULL default '0', `ip` varchar(255) default NULL, `name` varchar(255) default NULL, `address1` varchar(255) default NULL, `city` varchar(255) default NULL, `state` varchar(255) default NULL, `country` varchar(255) default NULL, `phone` varchar(255) default NULL, `fax` varchar(255) default NULL, `email` varchar(255) default NULL, `zip` varchar(255) default NULL, `linkpoint_type` varchar(32) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`lpid`) ) TYPE=MyISAM COMMENT='Recurring queue for LinkPoint' AUTO_INCREMENT=1 ; ALTER TABLE `payment_process` ADD `linkpoint_storeid` VARCHAR( 255 ) NOT NULL AFTER `paysystems_companyid` ; ALTER TABLE `payment_process` ADD `linkpoint_type` VARCHAR( 255 ) NOT NULL AFTER `linkpoint_storeid` ; INSERT INTO `payment_process` VALUES (10, 0, 'LinkPoint', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', 'SALE', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 0, ''); ALTER TABLE `hosting_order` ADD `linkpoint_recid` VARCHAR( 255 ) DEFAULT '0' NOT NULL ; ALTER TABlE `hosting_order` ADD `lpid` VARCHAR( 22 ) DEFAULT '' NOT NULL; ALTER TABLE `session_history` ADD `lpid` VARCHAR( 22 ) DEFAULT '' NOT NULL; Maintenance Release - Version v2.4.5.2 [ beta fixes ]-- 9/3/2004 -------------- /inc/client_functions.php -> added condition to resolve addon math issue /tools/credit_card_code[0].php /tools/credit_card_code[1].php /tools/credit_card_code[2].php -> fixed issue "Error." /tools/step_one_code[0].php /tools/verify_order_code[0].php -> InternetSecure Support added /2checkout_success.php /checkout_success.php /worldpay_success.php -> fixed issue with grabbing the wrong client IP address /invoice_new.php -> fixed issue with displaying wrong nameservers in this file -> InternetSecure Support added /invoice_service_payable.php -> fixed 2checkout (new) error of 0.00 amounts during passthru to cart /invoice_hosting.php /invoice_hosting_payable.php -> InternetSecure Support added New File: /internet_secure_success.php DATABASE CHANGES: ALTER TABLE `payment_process` ADD `internetsecure_merchant_id` VARCHAR( 25 ) NOT NULL AFTER `paysystems_companyid` ; ALTER TABLE `payment_process` ADD `internetsecure_language` VARCHAR( 100 ) NOT NULL AFTER `internetsecure_merchant_id` ; ALTER TABLE `payment_process` ADD `internetsecure_return_cgi` VARCHAR( 255 ) NOT NULL AFTER `internetsecure_language` ; INSERT INTO `payment_process` VALUES (9, 0, 'Internet Secure', '', 'SSC5LA==', 'SSC5LA==', '', '', '', '', '', 0, '', '', 'English', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', 1, ''); Maintenance Release - Version v2.4.5.1 [ beta fixes ]-- 8/02/2004 -------------- /admin/domain_specs.php -> now parses out any . that may be present in tld /admin/config_editor.php -> added switch for proxy users in admin sessions /inc/whm_functions.php -> fixed issue with domain expire emails sent to admin instead of client /inc/client_functions.php -> fixed 'email resend' not including the user & pass & login url /inc/login_functions.php -> added switch for proxy users in admin sessions /inc/connect.php -> added switch for proxy users in admin sessions /inc/varilogix_functions.php -> fixed issue with 1.x.x codes not processing /inc/languages/english.php -> added text: International Customers: use 011 + country code + phone number /step_four.php -> added text: International Customers: use 011 + country code + phone number /invoice_hosting.php /invoice_hosting_payable.php /invoice_service.php /invoice_service_payable.php -> added organization name to the invoice ( if exists ) -> removed dual address_1 var from invoice_service.php DATABASE CHANGES: ALTER TABLE `config` ADD `allow_proxy` CHAR( 3 ) DEFAULT 'no' NOT NULL ; ******** OLD CODE REMOVED FROM THIS FILE ********* /clogin.php -> removed old 'auto login' code that was utilized when accessing client area from admin Ref: [Full-Disclosure] email that was received by some clients /process_call.php -> fixed issue with 1.x.x codes not processing Maintenance Release - Version v2.4.5.0 [ beta fixes ]-- 7/13/2004 -------------- /inc/install1.php -> now trims variables before writing /inc/var.php /inc/whm_functions.php /inc/affiliate_functions.php /inc/client_functions.php -> quoted charset in email headers /tools/verify_order_code[0].php -> fixed issue with dedicated server mail in orders /inc/invoice_functions.php -> fixed issue with annual accounts showing the wrong due date on invoice /authnet_success.php -> added support for varilogix.com fraud call API /step_four.php -> added additional condition for varilogix.com fraud call /2checkout_success.php /paypal_success.php /tpp-pro-success.php /worldpay_success.php -> left out varilogix include. DATABASE CHANGES: ALTER TABLE `hosting_order` ADD `fraudcall_score` VARCHAR( 10 ) NOT NULL ; Maintenance Release - Version v2.5.0 -- 7/9/2004 -------------- /admin/themes/blue/main_general_block.php -> added support for varilogix.com fraud call API -> added switch for IP restrictions or not for admin area /admin/fraud_call.php -> added support for varilogix.com fraud call API /admin/index.php -> added logging for certain access attempts /admin/plan_build.php -> Fixed issue with package description not sticking when adding new shared package. /admin/client_view.php -> added ability to "Reset Account to pending in AutoPilot only" in the Hosting Account Information -> Manage Account: select box -> client area password now shows up in plain text /admin/tools/client_view_account_info.php -> added ability to "Reset Account to pending in AutoPilot only" in the Hosting Account Information -> Manage Account: select box -> client area password now shows up in plain text /admin/csv_change_ownership.php -> fixed issue with invoice and batch not updating on ownership change /tools/client_view_trouble_ticket.php -> Blank name issue resolved /tools/client_view_account_info.php -> added ability to login to cpanel from AP client area via form /tools/verify_order_code[0].php -> added support for varilogix.com fraud call API -> fixed mail in payment password issue /inc/whm_functions.php -> fixed issue with resend welcome email giving wrong password /inc/client_functions.php -> fixed math error with monthly hosting and annual addons /inc/invoice_functions.php -> fixed issue with date_paid date not set for manually created orders. Thanks Anthony! /inc/whm_functions.php -> fixed issue with invoice and batch not updating on ownership change /inc/login_functions.php -> added switch for IP restrictions or not for admin area -> added logging for certain access attempts /inc/connect.php -> added switch for IP restrictions or not for admin area /inc/languages/english.php -> added support for varilogix.com fraud call API new variable $text_cc_bin & $text_bin for authorize.net orders /inc/languages/english/step_four.php -> added support for varilogix.com fraud call API new requirement - BIN - for authorize.net orders /inc/languages/english/credit_card.php -> added support for varilogix.com fraud call API new error - $text_short_card_number /inc/languages/english/verify_order.php -> added support for varilogix.com fraud call API /tools/step_four_code[0].php -> added support for varilogix.com fraud call API /tools/credit_card_code[0].php -> added support for varilogix.com fraud call API /step_four.php -> added support for varilogix.com fraud call API -> added switch to make step_four.php state/provice easy to set default /validate_phone.php -> added support for varilogix.com fraud call API /credit_card.php -> added support for varilogix.com fraud call API /trouble_ticket_submit.php -> Blank name issue resolved /mail_payment.php -> Resolved issue with printer friendly shows blank invoice /register_enom.php -> Renew date not recorded -> Extra , making query fail. Thanks John! /2checkout_success.php -> added support for varilogix.com fraud call API /paypal_success.php -> added support for varilogix.com fraud call API /tpp_pro_success.php -> added support for varilogix.com fraud call API /worldpay_success.php -> added support for varilogix.com fraud call API /verify_order.php -> added support for varilogix.com fraud call API ADDED FILES: /admin/themes/blue/images/callback[-1].gif /admin/themes/blue/images/callback[2].gif /admin/themes/blue/images/callback[4].gif /admin/themes/blue/images/callback[6].gif -> added support for varilogix.com fraud call API /admin/admin_access.php -> added switch for IP restrictions or not for admin area /inc/varilogix_functions.php -> added support for varilogix.com fraud call API /inc/varilogix_form.php -> added support for varilogix.com fraud call API /inc/validate_phone.php -> added support for varilogix.com fraud call API /inc/process_phone.php -> added support for varilogix.com fraud call API GENERAL NOTES: Create a new directory: /mib_data/access_logs and make it 777 DATABASE CHANGES: ALTER TABLE `config` ADD `ip_restrict` CHAR( 3 ) DEFAULT 'no' NOT NULL ; CREATE TABLE `autopilot_ip` (`ipid` BIGINT( 22 ) UNSIGNED NOT NULL AUTO_INCREMENT ,`ip` VARCHAR( 40 ) NOT NULL , `created` INT( 20 ) NOT NULL , PRIMARY KEY ( `ipid` ) ); ALTER TABLE `session_history` ADD `fraudcall_api_response` VARCHAR( 25 ) NOT NULL , ADD `fraudcall_score` VARCHAR( 25 ) NOT NULL ; ALTER TABLE `session_history` ADD `bin_number` INT( 6 ) NOT NULL ; Maintenance Release - Version 2.4.3.1 -- 06/17/2004 -------------- /admin/affiliate_details.php -> Fixed issue with affiliate display details /admin/index.php -> Added error supression /admin/process_batch.php -> Added error supression /admin/view_batch.php -> Added error supression /admin/cron_invoice.php -> Fixed sql error /admin/config_editor.php [6/23/2004] -> Added support for multiple charsets defautls for email /admin/trouble_ticket_active.php [6/23/2004] -> Clicking name now pre populates the un/pw at client area /admin/trouble_ticket_closed.php [6/23/2004] -> Clicking name now pre populates the un/pw at client area /admin/process_batch.php -> Parsed out unexpected chars in authnet repsonse_code /admin/cron_1215.php -> Moved DB dump to the last process ran in order to capture changes during cron in db /admin/csv_user.php [6/21/2004] -> Fixed bug with new user password creation in this file. /admin/client_view_edit.php [6/21/2004] -> Clicking the client area link now pre-populates the login form. /admin/client_management.php [6/21/2004] -> Fixed bug with new user password creation in this file. /inc/install1.php -> Looks for variants of mysql file - if you've already installed ignore this /inc/client_functions.php [6/24/2004] -> corrected order total math error /inc/connect.php [6/23/2004] -> Added support for multiple charsets defautls for email /tools/credit_card_code[0].php [6/23/2004] -> Fixed issue with formatting /tools/credit_card_code[1].php [6/23/2004] -> fix batch amount math -> Fixed issue with formatting /tools/credit_card_code[2].php [6/23/2004] -> Fixed issue with formatting /affiliate_signup.php [6/24/2004] -> Now uses new encryption methods for passwords /invoice_new.php [6/21/2004] -> Added fix for blank printable invoices /2checkout_success.php -> Compensated for changed with posted vars from 2Co's new system -> Added layer of postback security /worldpay_success.php -> Fixed bug with cancel at worldpay -> Added layer of postback security /paypal_success.php [6/21/2004] -> Added layer of postback security /tpp_pro_success.php -> Added layer of postback security /register_enom.php [6/23/2004] -> Now updates domain expire date for new registrations DATABASE CHANGES: ALTER TABLE `config` ADD `charset` VARCHAR( 25 ) DEFAULT 'en-iso-8859-1' NOT NULL ; Maintenance Release - Version 2.4.3[a] -- 6/15/2004 ---------------------------------------------------------------------------------- Instructions: http://www.whmautopilot.com/upgrade_243.php Who should upgrade: ALL - alot of fixes in this release. ########################################### ######### UPLOAD ONLY IN BINARY ########### ########################################### Although changes are listed, the entire ADMIN folder should be updated with this upgrade to ensure you are running the most current files since we have found installs running older files after upgrades that should have been updated at a previous release and were not. Please note that this release will cause ALL CURRENT client area login passwords to fail. The client must request a resend of information from /clogin.php to have their password reset and resent to them to incorporate the new security and encryption on the sessions and passwords. ====================================================== -----> changes in v2.4.3a <------ Edited file: /admin/tools/authnet_batch.php -> fixed sql syntax errror Edited file: /admin/tools/client_view_account_info.php -> Revised the admin area login and session system Edited file: /admin/client_management.php -> fixed state / province bug Edited file: /admin/client_view_edit.php -> Revised the admin area login and session system Edited file: /admin/client_view.php -> Revised the admin area login and session system -> Fixed the "Click to view Client area" link Edited file: /admin/client_cancel_account.php -> Removes cancel from list after acceptance now Edited file: /admin/server_edit.php -> Fixed display of total "active in AP" Edited file: /admin/cron_invoice.php -> Fixed issue with one time charges being added to after initial invoice Edited file: /inc/whm_functions.php -> Fixed server load display issue Edited file: /inc/whois.php -> Added measure to convert all stings to lower case Edited file: /clogin.php -> Fixed the "Click to view Client area" link Edited file: /client_area.php -> Fixed enable/disable interal helpdesk Edited file: /invoice_hosting_payable.php -> 2checkout link was wrong. ====================================================== Edited File: /admin/affiliate_details_view.php -> fixed issue with referred links not show on payouts -> fix all affiliate date issues by visiting this link: /admin/scripts/fix_affiliate_details_date.php Edited File: /admin/client_view.php -> fixed issue with updating package/addons change paid invoices Edited File: /admin/cron_invoice.php -> fixed issue with updating package/addons change paid invoices Edited File: /admin/index.php -> Revised the admin area login and session system -> Added email notification of invalid login attempts Edited File: /admin/index2.php -> Revised the admin area login and session system -> truncated the resolver area to only display 'active & unresolved' domains ( save load time ) Edited File: /admin/manage_admin.php -> Revised the admin area login and session system Edited File: /admin/process_batch.php -> Revised the batch form handler. -> Added detailed logging of post data. (switchable) Edited File: /admin/view_batch.php -> Revised the batch form handler. Edited File: /admin/config_editor.php -> Added switch to enable or disable post logging. -> Fixed domain expire check switch Edited File: /admin/tools/define_admin.php -> Revised the admin area login and session system Edited File: /admin/tools/define_admin_check.php -> Revised the admin area login and session system Edited File: /admin/themes/blue/header.php -> Revised the admin area login and session system -> fixed images path error Edited File: /inc/invoice_functions.php -> fixed issue with updating package/addons change paid invoices -> revised "send hosting reminders" flag Edited File: /inc/client_functions.php -> Revised the client area login and session system -> Fixed issue with annual recurring addons not being added into the recurring total. -> Fixed issue with cancelling SQL error when cancelling an account. Edited File: /inc/whm_functions.php -> Added detailed logging of post data. (switchable) -> Updated active server stats pull on index2.php Edited File: /inc/login_functions.php -> Revised the admin area login and session system Edited File: /tools/client_view_info.php -> Revised the client area login and session system Edited File: /tpp_pro_success.php -> Added detailed logging of post data. (switchable) Edited File: /2checkout_success.php -> Added detailed logging of post data. (switchable) Edited File: /worldpay_success.php -> Added detailed logging of post data. (switchable) Edited File: /paypal_success.php -> Added detailed logging of post data. (switchable) Edited File: /tools/credit_card_code[0].php -> Added detailed logging of post data. (switchable) Edited File: /clogin.php -> Revised the client area login and session system Edited File: /affiliate.php -> fixed referral urls to have proper package ID Edited File: /elogin.php -> Revised the client area login and session system Edited File: /client_area.php -> Revised the client area login and session system Edited File: /invoice_service_payable.php -> Revised to work with the new 2Checkout system. Edited File: /invoice_hosting_payable.php -> Revised to work with the new 2Checkout system. Edited File: /invoice_success.php -> Revised to work with the new 2Checkout system. Edited File: /invoice_service.php -> Revised to work with the new 2Checkout system. ADDED FILE: /logout.php -> Revised the client area login and session system ADDED FILE: /admin/logout.php -> Revised the admin area login and session system NOTE: Your admin login will not work after the update. You will be prompted to recreate your admin login after the database update below due to new security settions on session management & password management. DATABASE CHANGES: DELETE FROM `user` WHERE status='69'; #the above query will delete all admins due to new security ALTER TABLE `user` CHANGE `password` `password` TEXT NOT NULL; ALTER TABLE `user` DROP INDEX `sid`; ALTER TABLE `user` CHANGE `sid` `sid` TEXT NOT NULL; INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('', 'Payment Processor Returned Transaction Data', 'Gateway Response for {{domain_name}} from {{payment_gateway}}', 'Hello,\n\nBelow are the results for the hosting order for {{domain_name}} paid through {{payment_gateway}}.\n\nThis email should be used for troubleshooting any problems that may have arose during the order process or to be stored as a record of the inital response from the gateway.\n\n{{post_data}}\n\nThank you.\n\nYour AutoPilot\n\nGenerated on: {{generate_date}}', '{{domain_name}}|{{payment_gateway}}|{{post_data}}|{{generate_date}}', ''); INSERT INTO `email_templates` ( `emid` , `name` , `subject` , `message` , `attr_avail` , `default_email` ) VALUES ('', 'Invalid Admin Login Attempt', 'Invalid Admin Login on {{generate_date}}', 'Hello,\n\nOn {{generate_date}}, access to your admin area was attempted but failed.\n\nIP: {{users_ip}}\nUsername: {{username}}\nPassword Attempted: {{password_attempt}}\n\nThank you.\n\nYour AutoPilot.\n\nGenerated on: {{generate_date}}', '{{generate_date}}|{{users_ip}}|{{username}}|{{password_attempt}}', ''); ALTER TABLE `config` ADD `enable_debugging` TINYINT( 1 ) DEFAULT '1' NOT NULL ; Version 2.4.2 [Maintenance Release 3] 05/11/2004------------------------------------------------ Instructions here: http://www.whmautopilot.com/upgrade_242.php ########################################### ######### UPLOAD ONLY IN BINARY ########### ########################################### You must be at v2.4.16 for this upgrade to properly update your script. Failure to be at that version can cause errors in files and in the database. Edited File: /inc/connect.php --> added switch for empty admin_email handler --> version incrementation Edited File: /admin/plan_build.php -> fixed bug that kept private addons from showing for administrators Edited File: /admin/view_batch.php -> fixed bug that didn't account for first time charge Edited File: /admin/process_batch.php -> fixed bug that didn't account for first time charge Edited File: /admin/cron_invoice.php -> fixed bug that didn't account for first time charge Edited File: /tools/step_two_code[0].php -> fixed bug that showed private addons in the order system Edited File: /tools/step_three_code[0].php -> fixed bug that would not show addons if in certain condition Edited File: /tools/step_four_code[0].php -> fixed bug that showed private addons in the order system Edited File: /tpp_pro_success.php -> fixed bug that caused payment return errors - redirect to step_one.php Edited File: /billing_history.php -> added security features Edited File: /cc_update.php -> added exp. date to credit cards in select box Edited File: /admin/master_batch.php -> added exp. date to credit cards in select box Edited File: /tools/verify_order_code[0].php -> fixed demo mode with 2checkout - use local pc copy Edited File: /admin/view_batch.php -> added link to view credit card information Edited File: /admin/payment_process.php -> added support for new 2Checkout system Edited File: /tools/verify_order_code[0].php -> fixed demo bug for 2Checkout, added support for new 2Checkout system Edited File: /admin/invoice_create.php -> made the tax input accept more than 4 digits and modified formatting. Edited File: /admin/client_view.php -> fixed affilate bug with manual installs. Edited File: /admin/tools/client_view_info.php -> fixed affiliate bug to show correct referrer. Edited File: /inc/invoice_functions.php -> fixed issue that didn't mark invoices as paid for new orders. -> can now send emails running with "do not allow php to send nobody emails" Edited File: /inc/affiliate_functions.php -> can now send emails running with "do not allow php to send nobody emails" Edited File: /inc/client_functions.php -> can now send emails running with "do not allow php to send nobody emails" Edited File: /inc/whm_functions.php -> can now send emails running with "do not allow php to send nobody emails" ADDED File & Directory: /admin/c/index.php -> View credit card information. IMPORTANT: Please use .htaccess to lock down the /admin/c directory ** it is protected by normal admin session management but the extra layer with .htaccess will make it tighter ** DATABASE UPDATES: /SQL/maintenance_v242.sql --> log into cPanel --> click on MySQL Databases --> click on phpMyAdmin --> select your database on the left --> click on the SQL link at the top --> paste this into the query box and click GO ** or you can click browse, locate the file mentioned above and click go ** ALTER TABLE `payment_process` ADD `co_system` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `checkout_sid` ; -------- [ END V2.4.2 MAINTENANCE ] ----------------------------------------------------------------- (Version 2.4.3.2) 2/2/2004 ---------------------------------------------------------------------------------- Edited File: /admin/process_batch.php -> fixed "read error" issue -> fixed issue with invoices not marked as paid Edited File: /admin/view_batch.php -> added invoice number to batch 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: /mail_payment.php -> fixed issue: http://www.whmautopilot.com/forum/index.php?showtopic=3121&st=0&#entry18696 (Version 2.4.3.1) 2/2/2004 ---------------------------------------------------------------------------------- Edited File: /admin/cron_invoice.php -> fixed issue with multiple reports sending Edited File: /admin/config_editor.php -> added switch to send hosting reminders Edited File: /inc/invoice_functions.php -> fixed issue with invoice_create_per_client.php -> added switch to send hosting reminders Edited File: /inc/connect.php -> added switch to send hosting reminders Edited File: /invoice_new.php -> fixed issue: http://www.whmautopilot.com/forum/index.php?showtopic=3121&st=0&#entry18696 DATABASE CHANGES: ALTER TABLE `config` ADD `send_reminders` INT( 1 ) DEFAULT '1' NOT NULL ; (Version 2.4.3) 1/14/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.2) 1/8/2004 ----------------------------------------------------------------------------------- Edited File: /inc/invoice_functions.php -> Bug fixes for display Edited File: /invoice_new.php -> Bug fixes for display Edited File: /invoice_hosting.php -> Bug fixes for display Edited File: /invoice_hosting_payable.php -> Bug fixes for display and payment changes Edited File: /invoice_service.php -> Bug fixes for display and payment changes Edited File: /invoice_service_payable.php -> Bug fixes for display and payment changes Edited File: /affiliate_signup.php -> fixed undefined function error 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. (Version 2.4.1) 1/5/2004 ----------------------------------------------------------------------------------- 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 - DATABASE CHANGES: ALTER TABLE `config` ADD `enom_ip` VARCHAR( 22 ) NOT NULL AFTER `enom_pass` ; (Version 2.4.0) 12/30/2003 ----------------------------------------------------------------------------------- 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 (Version 2.3.2) 12/15/2003 ----------------------------------------------------------------------------------- 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: 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}}|', 'andy@httpeasy.com'); 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