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 wh