0)); require_once WHMCS_MAIN_DIR.DS.'init.php'; require_once ADDON_DIR.DS.'loader.php'; $loader = new \MGModule\DNSManager2\loader(); main\addon::I(true); function dns_migration_decrypt_password($pass) { $result = main\addon::localAPI('decryptpassword', array('password2' => $pass)); return $result['password']; } if(!function_exists('dns_echo')) { function dns_echo($string = '', $error = false) { if(IS_CLI) { echo ($error? 'Error: ' : '') . strip_tags($string) . "\r\n"; } else { echo ($error?'Migration failed: ':'') . $string . '
'; } } } $migrate = false; if( isset($_GET['proceed']) || (isset($argv[1]) && $argv[1] == 'proceed')) { $migrate = true; } $path = dirname(dirname(__DIR__)) . DS . 'dns_manager' . DS . 'dns_manager.php'; if(!file_exists($path)) { dns_echo('I cant find old DNS Manager For WHMCS under ' . $path, true); die(); } if(!function_exists('dns_manager_isMultiservers')) { require_once $path; dns_echo('DNS file loaded ('.$path. ')'); } if(!function_exists('dns_manager_isMultiservers') || !function_exists('dns_manager_getServerAllZones') || !function_exists('dns_manager_getAllZones')) { dns_echo('Migration requires newest version of old DNS Manager For WHMCS', true); die(); } $section = 'dns_migration'; $multi = dns_manager_isMultiservers(); $zones_count = $multi ? dns_manager_getServerAllZonesCount() : dns_manager_getAllZonesCount(); $servers_count = $multi?main\mgLibs\MySQL\query::count('id', 'dns_manager_servers') : 1; if(!$migrate) { //dns_echo(); //dns_echo("There is $zones_count zones and $servers_count servers to migrate"); //dns_echo(); //dns_echo("This migration will create $servers_count servers, add $servers_count packages and import $zones_count zones in DNS Manager 2"); dns_echo(); $script = __FILE__; if(IS_CLI) { dns_echo("If you want to proceed then run this command: 'php -q $script proceed 1'"); die(); } else { dns_echo('
'); dns_echo("Or run this command in command line 'php -q $script proceed 1'"); } die(); } $avaiable_submodules = main\mgLibs\custom\dns\Core::getAvailableSubmodules(); $servers_map = array( //jesli tu nie ma to używa tej samej nazwy (sprawdzajac czy istnieje) 'dns_4psa' => 'DNS4PSA', 'parallels_plesk' => 'Plesk', 'cpanel' => 'CPanelOldApi', 'powerdns_hosted' => 'PowerDNSHosted', ); if(!$multi) { $module = dns_manager_getWHMCSconfig('mg_dns_currentmodule'); $server_config = unserialize(dns_manager_getWHMCSconfig("mg_dns_{$module}_config")); $config = unserialize(dns_manager_getWHMCSconfig('dns_processing')); $nameservers = unserialize(dns_manager_getWHMCSconfig('mg_dns_nameservers')); $default_records = main\mgLibs\MySQL\query::select(array('*'), 'mg_dns_default', array('serverid' => 0))->fetchAll(); isset($server_config['defaultIP'])?$server_config['default_ip']:''; if(isset($servers_map[$module])) { $module = $servers_map[$module]; } foreach($avaiable_submodules as $sub) { if(strtolower($sub) == strtolower($module)) { $module = $sub; } } if(empty($module)) { die(); } $module_fields = main\mgLibs\custom\CoreManager::getConfiguration($module); $server_config['default_ip'] = $server_config['defaultIP']; foreach($module_fields as $name => $arr) { if(isset($arr['type']) && $arr['type'] == 'password' && isset($server_config[$name])) { $server_config[$name] = decrypt($server_config[$name]); } if(isset($arr['type']) && $arr['type'] == 'yesno' && isset($server_config[$name])) { $server_config[$name] = $server_config[$name]==1?'on':''; } } //=========================================================================================================== //===========================================SERVER IMPORT=================================================== //=========================================================================================================== $server = new main\models\custom\server\Server(); $server->name = uniqid("Migrated $module "); $server->module = $module; $server->status = 0; $server->save(); foreach($nameservers as $index => $arr) { $server->setNameserver($index, $arr['domain'], $arr['ip']); } //TODO: decode password type fields // zapytac damiana o to $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::MODULE_CONFIGURATION, serialize($server_config)); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ENABLE_CACHE, ''); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ALLOW_RDNS, $config['reverse']==1?'on':''); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ALLOW_MULTIPLE_PTR, $config['multiple_reverse']==1?'on':''); //=========================================================================================================== //===========================================PACKAGE IMPORT================================================== //=========================================================================================================== $package = new main\models\custom\package\Package(); $package->name = uniqid("Migrated "); $package->status = 0; $package->defaultset = 0; $package->save(); $package->addServer($server->id); if(!empty($default_records)) { $set = new main\models\custom\set\Set(); $set->name = uniqid("Migrated "); $set->save(); foreach($default_records as $rec) { if($rec['record_type'] == 'LOC') continue; $r = new main\mgLibs\custom\dns\record\Record(); $r->createRDATAObject($rec['record_type']); switch($rec['record_type']) { case 'MX': $r->rdata->preference = $rec['record_priority']; $r->rdata->exchange = $rec['record_value']; break; case 'SRV': $r->rdata->priority = $rec['record_priority']; $r->rdata->weight = $rec['record_weight']; $r->rdata->port = $rec['record_port']; $r->rdata->target = $rec['record_value']; break; default: $r->rdata->setFirstProperty($rec['record_value']); break; } $set->setRecord($rec['record_address'], $rec['record_type'], $rec['record_ttl'], $r->rdata->toArray(false)); } $package->setDefaultSet($set->id); } $item_type = main\models\custom\package\item\PackageItemTypeEnum::DOMAIN; $tld_taken_db = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager2_packageitem', array('type' => $item_type))->fetchAll(); $tld_taken = array(); foreach($tld_taken_db as $arr) { $tld_taken[] = $arr['relid']; } if(isset($config['domains']) && $config['domains']['checked'] == 1) { foreach($config['domains']['with_domains'] as $tld => $on) { $tld = '.' . $tld; if(in_array($tld, $tld_taken)) { //dns_echo(); continue; } $package->addItem($item_type, $tld, 9999); } } $item_type = main\models\custom\package\item\PackageItemTypeEnum::PRODUCT; $products_taken_db = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager2_packageitem', array('type' => $item_type))->fetchAll(); $products_taken = array(); foreach($products_taken_db as $arr) { $products_taken[] = $arr['relid']; } if(isset($config['products']) && $config['products']['checked'] == 1) { foreach($config['products']['products'] as $relid => $on) { if(in_array($relid, $products_taken)) { //dns_echo(); continue; } $package->addItem($item_type, $relid, 9999); } } $item_type = main\models\custom\package\item\PackageItemTypeEnum::ADDON; $addons_taken_db = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager2_packageitem', array('type' => $item_type))->fetchAll(); $addons_taken = array(); foreach($addons_taken_db as $arr) { $addons_taken[] = $arr['relid']; } if(isset($config['addons']) && $config['addons']['checked'] == 1) { foreach($config['addons']['addons'] as $relid => $on) { if(in_array($relid, $products_taken)) { //dns_echo(); continue; } $package->addItem($item_type, $relid, 9999); } } //PACKAGE SETTINGS $disabled_records = unserialize(dns_manager_getWHMCSconfig('disable_dns'))?:array(); $available_records = main\mgLibs\custom\dns\Core::getAvailableRecordTypes(); $allowed_record_types = array(); foreach($available_records as $type) { if(in_array($type, $disabled_records)) { continue; } $allowed_record_types[$type] = 999; } $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ALLOWED_RECORD_TYPES, serialize($allowed_record_types)); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::DEFAULT_TTL, serialize($allowed_record_types)); $email_settings = unserialize(dns_manager_getWHMCSconfig('mg_dns_email_notification')); if($email_settings && $email_settings['enabled'] == 1) { if(isset($email_settings['create']) && $email_settings['create'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_CREATED, 'on'); } if(isset($email_settings['edit']) && $email_settings['edit'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_ALTERED, 'on'); } if(isset($email_settings['delete']) && $email_settings['delete'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_REMOVED, 'on'); } } else { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_ALTERED, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_CREATED, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_REMOVED, ''); } $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ENABLE_RDNS, $config['reverse']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ALLOW_MULTIPLE_PTR, $config['multiple_reverse']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_CLEANER, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_MIGRATOR, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_SYNCHRONIZATOR, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_CAN_USE_SETS, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_NEW_ITEM, 'on'); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_DOMAIN_WITH_DNS_MANAGEMENT, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_PENDING_REGISTRATION_DOMAIN, $config['domains']['pending_registrar']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_PENDING_TRANSFER_DOMAIN, $config['domains']['pending_renew']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::OWN_ZONES_PER_ITEM, 1); //=========================================================================================================== //===========================================ZONES IMPORT==================================================== //=========================================================================================================== $section = 'listzones';//uniqid('section_'); $_SESSION['_dns_manager_page_' . $section] = 1; $zones = dns_manager_getAllZones($section); while(!empty($zones)) { foreach($zones as $arr) { try { $zone = new main\models\custom\zone\Zone(); $zone->clientid = $arr['userid']; $zone->ip = ''; $zone->name = $arr['zonename']; $zone->serverid = $server->id; $zone->status = 1; $zone->relid = $arr['domainid']?:0; if(!isset($arr['ztype'])) { $zone->type = main\models\custom\zone\ZoneTypeEnum::OTHER; }elseif($arr['ztype'] == 'domain') { $zone->type = main\models\custom\zone\ZoneTypeEnum::DOMAIN; } elseif($arr['ztype'] == 'product') { $zone->type = main\models\custom\zone\ZoneTypeEnum::HOSTING; } else { $zone->type = main\models\custom\zone\ZoneTypeEnum::ADDON; } $zone->save(); } catch(\Exception $e) { } } $_SESSION['_dns_manager_page_' . $section]++; $zones = dns_manager_getAllZones($section); } unset($_SESSION['_dns_manager_page_' . $section]); } else { //=========================================================================================================== //===========================================MULTISERVERS==================================================== //=========================================================================================================== $servers = main\mgLibs\MySQL\query::select(array('*'), 'dns_manager_servers')->fetchAll(); foreach($servers as $data) { $server_config = unserialize($data['config']); $module = key($server_config); $nameservers = unserialize(main\mgLibs\MySQL\query::select(array('nameservers'), 'dns_manager_server_ns', array('serverid' => $data['id']))->fetchColumn())?:array(); $default_records = main\mgLibs\MySQL\query::select(array('*'), 'mg_dns_default', array('serverid' => $data['id']))->fetchAll(); if(isset($servers_map[$module])) { //ctrl + c -> ctrl + v bo rilis $module = $servers_map[$module]; } foreach($avaiable_submodules as $sub) { if(strtolower($sub) == strtolower($module)) { $module = $sub; } } if(empty($module)) { continue ; } $module_fields = main\mgLibs\custom\CoreManager::getConfiguration($module); $server_config['default_ip'] = $server_config['defaultIP']; foreach($module_fields as $name => $arr) { if(isset($arr['type']) && $arr['type'] == 'password' && isset($server_config[$name])) { $server_config[$name] = decrypt($server_config[$name]); } if(isset($arr['type']) && $arr['type'] == 'yesno' && isset($server_config[$name])) { $server_config[$name] = $server_config[$name]==1?'on':''; } } //=========================================================================================================== //===========================================MULTI SERVER IMPORT============================================= //=========================================================================================================== $server = new main\models\custom\server\Server(); $server->name = uniqid("Migrated {$data['name']} "); $server->module = $module; $server->status = 0; $server->save(); foreach($nameservers as $index => $arr) { $server->setNameserver($index, $arr['domain'], $arr['ip']); } $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::MODULE_CONFIGURATION, serialize(array_pop($server_config))); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ENABLE_CACHE, ''); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ALLOW_RDNS, $data['userdns']==1?'on':''); $server->setSetting(main\models\custom\server\setting\ServerSettingEnum::ALLOW_MULTIPLE_PTR, $data['multirdns']==1?'on':''); //=========================================================================================================== //===========================================MULTI PACKAGE IMPORT============================================ //=========================================================================================================== $package = new main\models\custom\package\Package(); $package->name = uniqid("Migrated "); $package->status = 0; $package->defaultset = 0; $package->save(); $package->addServer($server->id); if(!empty($default_records)) { $set = new main\models\custom\set\Set(); $set->name = uniqid("Migrated "); $set->save(); foreach($default_records as $rec) { if($rec['record_type'] == 'LOC') continue; $r = new main\mgLibs\custom\dns\record\Record(); $r->createRDATAObject($rec['record_type']); switch($rec['record_type']) { case 'MX': $r->rdata->preference = $rec['record_priority']; $r->rdata->exchange = $rec['record_value']; break; case 'SRV': $r->rdata->priority = $rec['record_priority']; $r->rdata->weight = $rec['record_weight']; $r->rdata->port = $rec['record_port']; $r->rdata->target = $rec['record_value']; break; default: $r->rdata->setFirstProperty($rec['record_value']); break; } $set->setRecord($rec['record_address'], $rec['record_type'], $rec['record_ttl'], $r->rdata->toArray(false)); } $package->setDefaultSet($set->id); } $item_type = main\models\custom\package\item\PackageItemTypeEnum::DOMAIN; $tld_taken_db = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager2_packageitem', array('type' => $item_type))->fetchAll(); $tld_taken = array(); foreach($tld_taken_db as $arr) { $tld_taken[] = $arr['relid']; } if($data['with_domain'] == 1) { $domains = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager_server_domains', array('serverid' => $data['id'], 'enabled' => 1))->fetchAll(); foreach($domains as $d) { $tld = main\mgLibs\MySQL\query::select(array('extension'), 'tbldomainpricing', array('id' => $d['domainid']))->fetchColumn(); if(in_array($tld, $tld_taken)) { //dns_echo(); continue; } $package->addItem($item_type, $tld, 9999); } } $item_type = main\models\custom\package\item\PackageItemTypeEnum::PRODUCT; $products_taken_db = main\mgLibs\MySQL\query::select(array('relid'), 'dns_manager2_packageitem', array('type' => $item_type))->fetchAll(); $products_taken = array(); foreach($products_taken_db as $arr) { $products_taken[] = $arr['relid']; } if($data['with_products'] == 1) { $products = main\mgLibs\MySQL\query::select(array('productid'), 'dns_manager_server_products', array('serverid' => $data['id'], 'enabled' => 1))->fetchAll(); foreach($products as $p) { $relid = $p['productid']; if(in_array($relid, $products_taken)) { //dns_echo(); continue; } $package->addItem($item_type, $relid, 9999); } } //PACKAGE SETTINGS $disabled_records = unserialize(dns_manager_getWHMCSconfig('disable_dns'.$data['id']))?:array(); $available_records = main\mgLibs\custom\dns\Core::getAvailableRecordTypes(); $allowed_record_types = array(); foreach($available_records as $type) { if(in_array($type, $disabled_records)) { continue; } $allowed_record_types[$type] = 999; } $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ALLOWED_RECORD_TYPES, serialize($allowed_record_types)); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::DEFAULT_TTL, serialize($allowed_record_types)); $email_settings = unserialize(dns_manager_getWHMCSconfig('mg_dns_email_notification')); if($email_settings && $email_settings['enabled'] == 1) { if(isset($email_settings['create']) && $email_settings['create'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_CREATED, 'on'); } if(isset($email_settings['edit']) && $email_settings['edit'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_ALTERED, 'on'); } if(isset($email_settings['delete']) && $email_settings['delete'] == 'on') { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_REMOVED, 'on'); } } else { $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_ALTERED, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_CREATED, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_NOTIFICATION_ZONE_REMOVED, ''); } $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ENABLE_RDNS, $data['userdns']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ALLOW_MULTIPLE_PTR, $data['multirdns']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_CLEANER, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_MIGRATOR, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ADMIN_NOTIFICATION_CRON_SYNCHRONIZATOR, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::CLIENT_CAN_USE_SETS, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_NEW_ITEM, 'on'); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_DOMAIN_WITH_DNS_MANAGEMENT, ''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_PENDING_REGISTRATION_DOMAIN, $data['with_domains_pending_registrar']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::ZONE_AUTOMATION_PENDING_TRANSFER_DOMAIN, $data['with_domains_pending_renew']==1?'on':''); $package->setSetting(main\models\custom\package\setting\PackageSettingEnum::OWN_ZONES_PER_ITEM, 1); } //=========================================================================================================== //===========================================MULTI ZONES IMPORT============================================== //=========================================================================================================== $section = 'listzones';//uniqid('section_'); $_SESSION['_dns_manager_page_' . $section] = 1; $zones = dns_manager_getServerAllZones($section); while(!empty($zones)) { foreach($zones as $arr) { try { $zone = new main\models\custom\zone\Zone(); $zone->clientid = $arr['userid']; $zone->ip = ''; $zone->name = $arr['zonename']; $zone->status = 1; $zone->relid = $arr['domainid']?:0; if(!isset($arr['ztype'])) { $zone->type = main\models\custom\zone\ZoneTypeEnum::OTHER; }elseif($arr['ztype'] == 'domain') { $zone->type = main\models\custom\zone\ZoneTypeEnum::DOMAIN; } elseif($arr['ztype'] == 'product') { $zone->type = main\models\custom\zone\ZoneTypeEnum::HOSTING; } else { $zone->type = main\models\custom\zone\ZoneTypeEnum::ADDON; } $package = $zone->getPackage(); if($package === false) continue; //log $ser = $package->getServers(); $server = array_pop($ser); $zone->serverid = $server->id; $zone->save(); } catch (\Exception $e) { } } $_SESSION['_dns_manager_page_' . $section]++; $zones = dns_manager_getServerAllZones($section); } unset($_SESSION['_dns_manager_page_' . $section]); } dns_echo('DONE');