| | |
|---|
| | | {
|
|---|
| | | global $app;
|
|---|
| | |
|
|---|
| | | include_once(ISPC_WEB_PATH.'/sites/tools.inc.php');
|
|---|
| | | |
|---|
| | | $app->uses('tools_sites');
|
|---|
| | | |
|---|
| | | $webserver_id = 0;
|
|---|
| | | $websrv = $this->db->queryOneRecord("SELECT * FROM web_domain WHERE domain = '".$this->db->quote($settings['main_domain'])."';");
|
|---|
| | | if(!empty($websrv)) $webserver_id = $websrv['server_id'];
|
|---|
| | |
|---|
| | | $tmp = array();
|
|---|
| | | $tmp['parent_domain_id'] = $websrv['domain_id'];
|
|---|
| | | $tmp['sys_groupid'] = $websrv['sys_groupid'];
|
|---|
| | | $dbname_prefix = replacePrefix($global_config['dbname_prefix'], $tmp);
|
|---|
| | | $dbuser_prefix = replacePrefix($global_config['dbuser_prefix'], $tmp);
|
|---|
| | | $dbname_prefix = $app->tools_sites->replacePrefix($global_config['dbname_prefix'], $tmp);
|
|---|
| | | $dbuser_prefix = $app->tools_sites->replacePrefix($global_config['dbuser_prefix'], $tmp);
|
|---|
| | | unset($tmp);
|
|---|
| | |
|
|---|
| | | //* get the default database server of the client
|
|---|
| | |
|---|
| | | //* Find a free db name for the app
|
|---|
| | | for($n = 1; $n <= 1000; $n++) {
|
|---|
| | | $mysql_db_name = $dbname_prefix.'aps'.$n;
|
|---|
| | | $tmp = $app->db->queryOneRecord("SELECT count(database_id) as number FROM web_database WHERE database_name = '".$app->db->quote($mysql_db_name)."'");
|
|---|
| | | if($tmp['number'] == 0) break;
|
|---|
| | | }
|
|---|
| | | //* Find a free db username for the app
|
|---|
| | | for($n = 1; $n <= 1000; $n++) {
|
|---|
| | | $mysql_db_user = $dbuser_prefix.'aps'.$n;
|
|---|
| | | $tmp = $app->db->queryOneRecord("SELECT count(database_id) as number FROM web_database WHERE database_name = '".$app->db->quote($mysql_db_user)."' OR database_user = '".$app->db->quote($mysql_db_name)."'");
|
|---|
| | | $tmp = $app->db->queryOneRecord("SELECT count(database_user_id) as number FROM web_database_user WHERE database_user = '".$app->db->quote($mysql_db_user)."'");
|
|---|
| | | if($tmp['number'] == 0) break;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | $mysql_db_password = $settings['main_database_password'];
|
|---|
| | |
|
|---|
| | | //* Create the mysql database user
|
|---|
| | | $insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `database_user`, `database_password`) |
|---|
| | | VALUES( ".$websrv['sys_userid'].", ".$websrv['sys_groupid'].", 'riud', '".$websrv['sys_perm_group']."', '', 0, '$mysql_db_user', PASSWORD('$mysql_db_password'))";
|
|---|
| | | $mysql_db_user_id = $app->db->datalogInsert('web_database_user', $insert_data, 'database_user_id');
|
|---|
| | | |
|---|
| | | //* Create the mysql database
|
|---|
| | | $insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `parent_domain_id`, `type`, `database_name`, `database_user`, `database_password`, `database_charset`, `remote_access`, `remote_ips`, `backup_copies`, `active`, `backup_interval`) |
|---|
| | | VALUES( ".$websrv['sys_userid'].", ".$websrv['sys_groupid'].", 'riud', '".$websrv['sys_perm_group']."', '', $mysql_db_server_id, ".$websrv['domain_id'].", 'mysql', '$mysql_db_name', '$mysql_db_user', PASSWORD('$mysql_db_password'), '', '$mysql_db_remote_access', '$mysql_db_remote_ips', ".$websrv['backup_copies'].", 'y', '".$websrv['backup_interval']."')";
|
|---|
| | | $insert_data = "(`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `parent_domain_id`, `type`, `database_name`, `database_user_id`, `database_ro_user_id`, `database_charset`, `remote_access`, `remote_ips`, `backup_copies`, `active`, `backup_interval`) |
|---|
| | | VALUES( ".$websrv['sys_userid'].", ".$websrv['sys_groupid'].", 'riud', '".$websrv['sys_perm_group']."', '', $mysql_db_server_id, ".$websrv['domain_id'].", 'mysql', '$mysql_db_name', '$mysql_db_user_id', 0, '', '$mysql_db_remote_access', '$mysql_db_remote_ips', ".$websrv['backup_copies'].", 'y', '".$websrv['backup_interval']."')";
|
|---|
| | | $app->db->datalogInsert('web_database', $insert_data, 'database_id');
|
|---|
| | |
|
|---|
| | | //* Add db details to package settings
|
|---|
| | |
|---|
| | | $this->db->datalogSave('aps', 'DELETE', 'id', $instanceid, array(), $datalog);
|
|---|
| | | */
|
|---|
| | |
|
|---|
| | | $sql = "SELECT web_database.database_id as database_id FROM aps_instances_settings, web_database WHERE aps_instances_settings.value = web_database.database_name AND aps_instances_settings.value = aps_instances_settings.name = 'main_database_name' AND aps_instances_settings.instance_id = ".$instanceid." LIMIT 0,1";
|
|---|
| | | $sql = "SELECT web_database.database_id as database_id, web_database.database_user_id as `database_user_id` FROM aps_instances_settings, web_database WHERE aps_instances_settings.value = web_database.database_name AND aps_instances_settings.value = aps_instances_settings.name = 'main_database_name' AND aps_instances_settings.instance_id = ".$instanceid." LIMIT 0,1";
|
|---|
| | | $tmp = $this->db->queryOneRecord($sql);
|
|---|
| | | if($tmp['database_id'] > 0) $this->db->datalogDelete('web_database', 'database_id', $tmp['database_id']);
|
|---|
| | |
|
|---|
| | | $database_user = $tmp['database_user_id'];
|
|---|
| | | $tmp = $this->db->queryOneRecord("SELECT COUNT(*) as `cnt` FROM `web_database` WHERE `database_user_id` = '" . intval($database_user) . "' OR `database_ro_user_id` = '" . intval($database_user) . "'");
|
|---|
| | | if($tmp['cnt'] < 1) $this->db->datalogDelete('web_database_user', 'database_user_id', $database_user);
|
|---|
| | | |
|---|
| | | $this->db->datalogUpdate('aps_instances', "instance_status = ".INSTANCE_REMOVE, 'id', $instanceid);
|
|---|
| | | }
|
|---|
| | |
|
|---|
