$db_userids = array(); $db_users = $exdb->queryAllRecords("SELECT u.id, u.login, u.account_id, u.db_id, a.password, a.type as `pwtype`, d.dom_id FROM db_users as u INNER JOIN data_bases as d ON (d.id = u.db_id) LEFT JOIN accounts as a ON (a.id = u.account_id)"); foreach ($db_users as $db_user) { // database user $params = array('server_id' => $server_id, 'database_user' => $db_user['login'], 'database_password' => $db_user['password']); $client_id = $plesk_ispc_ids[$domain_owners[$db_user['dom_id']]]; $check = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user` = \'' . $app->db->quote($db_user['login']) . '\''); $db_user_id = 0; if ($check) { $ok = $importer->sites_database_user_update($session_id, $client_id, $check['database_user_id'], array_merge($check, $params)); if ($ok === false) { $msg .= " Error: " . $importer->getFault() . "<br />"; } $db_user_id = $check['database_user_id']; } else { $db_user_id = $importer->sites_database_user_add($session_id, $client_id, $params); } if (!isset($db_userids[$db_user['db_id']])) { $db_userids[$db_user['db_id']] = $db_user_id; } $msg .= 'Created / updated database user: '******'login'] . '<br />'; } add_command('# DATABASES'); $databases = $exdb->queryAllRecords("SELECT d.id, d.name, d.type, d.dom_id, d.db_server_id, d.default_user_id FROM `data_bases` as d"); foreach ($databases as $database) { $params = array('server_id' => $server_id, 'parent_domain_id' => $domain_ids[$database['dom_id']], 'type' => 'mysql', 'database_name' => $database['name'], 'database_user_id' => $db_userids[$database['id']], 'database_ro_user_id' => 0, 'database_charset' => 'utf8', 'remote_access' => 'n', 'active' => 'y', 'remote_ips' => ''); $client_id = $plesk_ispc_ids[$domain_owners[$database['dom_id']]]; $check = $app->db->queryOneRecord('SELECT * FROM `web_database` WHERE `database_name` = \'' . $app->db->quote($database['name']) . '\''); if ($check) { $ok = $importer->sites_database_update($session_id, $client_id, $check['database_id'], array_merge($check, $params)); if ($ok === false) {