title = "Import Domains from cPanel/WHM"; $aInt->sidebar = 'utilities'; $aInt->icon = 'import'; $aInt->helplink = "cPanel/WHM Import"; $server = (int) $whmcs->get_req_var('server'); ob_start(); $packagesArr = array( ); $result = select_query('tblproducts', 'id,configoption1', array( 'servertype' => 'cpanel' )); while( $data = mysql_fetch_array($result) ) { $pid = $data[0]; $pname = $data[1]; $packagesArr[$pname] = $pid; $result2 = select_query('tblservers', 'username', array( 'type' => 'cpanel' )); while( $data = mysql_fetch_array($result2) ) { $packagesArr[$data['username'] . '_' . $pname] = $pid; } } if( $step == '' ) { echo "\n

This WHM Import Script can save you hours of time. It will automatically import domains and usernames from your cPanel Server to save you needing to enter them manually into WHMCS.

You must make sure you have a package setup for each Package Name in use on the server by the accounts you are going to import before running the import as WHMCS will attempt to automatically assign accounts to a package based on this. Any accounts where a package is not found for them will be reported at the end for entering manually.

Begin by choosing the cPanel server you want to import from below, then click Get Account List.

\n\n

getPhpSelf(); echo "?step=2\">\n\n\n

\n\n"; } else { if( $step == '2' ) { check_token("WHMCS.admin.default"); echo "\n

The following accounts were found on the server. Tick the boxes next to the accounts you wish to import.

\n\n"; $result = select_query('tblservers', '', array( 'id' => $server )); $data = mysql_fetch_array($result); $servertype = $data['type']; $host = $data['ipaddress']; $user = WHMCS_Input_Sanitize::decode($data['username']); $pass = WHMCS_Input_Sanitize::decode(decrypt($data['password'])); $accesshash = WHMCS_Input_Sanitize::decode($data['accesshash']); $usessl = $data['secure']; $request = '/xml-api/listaccts'; $cleanaccesshash = preg_replace("'(\r|\n)'", '', $accesshash); if( $cleanaccesshash ) { $authstr = "WHM " . $user . ":" . $cleanaccesshash; } else { $authstr = "Basic " . base64_encode($user . ":" . $pass); } $ch = curl_init(); if( $usessl ) { curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_URL, "https://" . $host . ":2087" . $request); } else { curl_setopt($ch, CURLOPT_URL, "http://" . $host . ":2086" . $request); } curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $curlheaders[0] = "Authorization: " . $authstr; curl_setopt($ch, CURLOPT_HTTPHEADER, $curlheaders); curl_setopt($ch, CURLOPT_TIMEOUT, 150); $data = curl_exec($ch); if( curl_errno($ch) ) { $curlerror = curl_error($ch) . " (Code " . curl_errno($ch) . ") - Check IP/Blocked Firewall Ports"; } curl_close($ch); if( $debug_output ) { echo ""; } $xmldata = XMLtoARRAY($data); if( $curlerror ) { infoBox("Connection Error", $curlerror); echo $infobox; } else { $jquerycode .= "\$(\"#checkall\").toggle(function () {\n \$(\".checkall\").attr(\"checked\",\"checked\");\n},function () {\n \$(\".checkall\").attr(\"checked\",\"\");\n})"; echo "\n\n\n\n\n\n\n

getPhpSelf(); echo "?step=3\" name=\"importForm\">\n\n\n\n

\n\n\n\n\n"; $count = 0; foreach( $xmldata['LISTACCTS'] as $key => $account ) { if( substr($key, 0, 4) == 'ACCT' ) { $domain = trim($account['DOMAIN']); $email = $account['EMAIL']; $owner = $account['OWNER']; $plan = urldecode($account['PLAN']); $username = $account['USER']; $created = $account['UNIX_STARTDATE']; if( trim($created) ) { $created = @date("d M Y", $created); } $result = select_query('tblhosting', 'id,domainstatus,packageid,server', array( 'domain' => $domain, 'domainstatus' => 'Active' )); $data = mysql_fetch_array($result); $domaincount = $data[0]; $domainstatus = $data['domainstatus']; $packageid = $data['packageid']; $serverid = $data['server']; $bgcolor = $domaincount ? "#ffff95" : "#ffffff"; if( !$domaincount ) { $result = select_query('tblhosting', 'id,domainstatus,packageid,server', array( 'domain' => $domain )); $data = mysql_fetch_array($result); $domaincount = $data[0]; $domainstatus = $data['domainstatus']; $packageid = $data['packageid']; $serverid = $data['server']; $bgcolor = $domaincount ? "#FFFF95" : "#ffffff"; } $pid = $packagesArr[$plan]; if( !$pid ) { $bgcolor = "#CCFF66"; } if( $pid && $packageid && $pid != $packageid ) { $bgcolor = "#e8e8e8"; } if( $serverid && $serverid != $server ) { $bgcolor = "#A8C6F7"; } if( $domainstatus && ($domainstatus == 'Cancelled' || $domainstatus == 'Terminated' || $domainstatus == 'Fraud') ) { $bgcolor = "#FF9797"; } if( $hide && !$domaincount || !$hide ) { if( $useronly ) { if( $owner == $user ) { echo ""; } } else { if( $showcancelled ) { if( $bgcolor == "#FF9797" ) { echo ""; } } else { echo ""; } } } $count++; } } if( !$count ) { echo ""; } echo "

	Domain	Username	Owner	Package	Created
	" . $domain . "	" . $username . "	" . $owner . "	" . $plan . "	" . $created . "
	" . $domain . "	" . $username . "	" . $owner . "	" . $plan . "	" . $created . "
	" . $domain . " " . $domaincount . "	" . $username . "	" . $owner . "	" . $plan . "	" . $created . "
No Accounts Found - Check Server Login Details if there should be some

\n\n
\n\n\n\n\n\n\n\n

Indicates a Domain Already in WHMCS and in Sync

Indicates in WHMCS but set to a different product

Indicates in WHMCS but set to a different server

Indicates in WHMCS but set to Cancelled

Indicates a Package that doesn't exist in WHMCS so cannot be imported

\n\n

Tick this box to create domain entries for imported accounts (this assumes all clients domains are registered through you)

\n"; } } else { if( $step == '3' ) { check_token("WHMCS.admin.default"); $result = select_query('tblpaymentgateways', 'gateway', '', 'gateway', 'ASC'); $data = mysql_fetch_array($result); $defaultgateway = $data['gateway']; $result = select_query('tblservers', '', array( 'id' => $server )); $data = mysql_fetch_array($result); $servertype = $data['type']; $host = $data['ipaddress']; $user = WHMCS_Input_Sanitize::decode($data['username']); $pass = WHMCS_Input_Sanitize::decode(decrypt($data['password'])); $accesshash = WHMCS_Input_Sanitize::decode($data['accesshash']); $usessl = $data['secure']; $request = '/xml-api/listaccts'; $cleanaccesshash = preg_replace("'(\r|\n)'", '', $accesshash); if( $cleanaccesshash ) { $authstr = "WHM " . $user . ":" . $cleanaccesshash; } else { $authstr = "Basic " . base64_encode($user . ":" . $pass); } $ch = curl_init(); if( $usessl ) { curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_URL, "https://" . $host . ":2087" . $request); } else { curl_setopt($ch, CURLOPT_URL, "http://" . $host . ":2086" . $request); } curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $curlheaders[0] = "Authorization: " . $authstr; curl_setopt($ch, CURLOPT_HTTPHEADER, $curlheaders); curl_setopt($ch, CURLOPT_TIMEOUT, 150); $data = curl_exec($ch); if( curl_errno($ch) ) { $curlerror = curl_error($ch) . " (Code " . curl_errno($ch) . ") - Check IP/Blocked Firewall Ports"; } curl_close($ch); if( $debug_output ) { echo ""; } $xmldata = XMLtoARRAY($data); if( $curlerror ) { infoBox("Connection Error", $curlerror); echo $infobox; } else { $successcount = 0; $failcount = 0; foreach( $xmldata['LISTACCTS'] as $account ) { $domain = $account['DOMAIN']; $email = $account['EMAIL']; $owner = $account['OWNER']; $plan = urldecode($account['PLAN']); $user = $account['USER']; $created = $account['UNIX_STARTDATE']; if( $created ) { $created = @date('Y-m-d', $created); } if( in_array($user, $selectedaccounts) ) { $pid = $packagesArr[$plan]; if( !$pid ) { $failcount++; $faillist .= $failcount . ". " . $domain . "
"; } else { $length = 7; $seeds = 'abcdefghijklmnopqrstuvwxyz0123456789'; $str = null; $seeds_count = strlen($seeds) - 1; for( $z = 0; $z < $length; $z++ ) { $str .= $seeds[rand(0, $seeds_count)]; } $str = encrypt($str); $userid = insert_query('tblclients', array( 'firstname' => $user, 'lastname' => 'Owner', 'email' => $email, 'password' => $str, 'status' => 'Active', 'datecreated' => $created )); insert_query('tblhosting', array( 'userid' => $userid, 'regdate' => $created, 'domain' => $domain, 'server' => $server, 'paymentmethod' => $defaultgateway, 'billingcycle' => "Free Account", 'domainstatus' => 'Active', 'username' => $user, 'packageid' => $pid, 'notes' => "Imported using WHM Import Script - Payment Method, Pricing, Billing Cycle & Next Due Date may be incorrect" )); if( $createdomains ) { $domainparts = explode(".", $arr[1], 2); $tld = $domainparts[1]; $result = select_query('tbldomainpricing', '', array( 'extension' => "." . $tld ), 'registrationperiod', 'ASC'); $data = mysql_fetch_array($result); $regperiod = $data['registrationperiod']; $firstpaymentamount = $data['register']; $recurringamount = $data['renew']; insert_query('tbldomains', array( 'userid' => $userid, 'registrationdate' => $created, 'domain' => $domain, 'firstpaymentamount' => $firstpaymentamount, 'recurringamount' => $recurringamount, 'registrationperiod' => $regperiod, 'paymentmethod' => $defaultgateway, 'expirydate' => $nextdue, 'status' => 'Active', 'additionalnotes' => "Imported using WHM Import Script - Payment Method, Amount, Expiry & Next Due Date may be incorrect" )); } $successcount++; $successlist .= $successcount . ". " . $domain . "
"; } } } echo "\n

Import Results

"; echo $successcount; echo " Succeeded

"; echo $successlist; echo "

"; echo $failcount; echo " Failed (Due to Package Name Not Found in WHMCS)

"; echo $faillist; echo "

\n\n"; } } } } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->jquerycode = $jquerycode; $aInt->jscode = $jscode; $aInt->display();