| | |
| | | // we need remote access rights for this server, so get it's ip address |
| | | $server_config = $app->getconf->get_server_config($tmp['server_id'], 'server'); |
| | | if($server_config['ip_address']!='') { |
| | | /* |
| | | if($this->dataRecord['remote_access'] != 'y') $this->dataRecord['remote_ips'] = ''; |
| | | $this->dataRecord['remote_access'] = 'y'; |
| | | if(preg_match('/(^|,)' . preg_quote($server_config['ip_address'], '/') . '(,|$)/', $this->dataRecord['remote_ips']) == false) { |
| | | $this->dataRecord['remote_ips'] .= ($this->dataRecord['remote_ips'] != '' ? ',' : '') . $server_config['ip_address']; |
| | | } |
| | | */ |
| | | |
| | | if($this->dataRecord['remote_access'] != 'y'){ |
| | | $this->dataRecord['remote_ips'] = $server_config['ip_address']; |
| | | $this->dataRecord['remote_access'] = 'y'; |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | if ($app->tform->errorMessage == '') { |
| | | // force update of the used database user |
| | | if($this->dataRecord['database_user_id']) { |
| | | $user_old_rec = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user_id` = ' . $app->functions->intval($this->dataRecord['database_user_id'])); |
| | | if($user_old_rec) { |
| | | $user_new_rec = $user_old_rec; |
| | | $user_new_rec['server_id'] = $this->dataRecord['server_id']; |
| | | $app->db->datalogSave('web_database_user', 'UPDATE', 'database_user_id', $this->dataRecord['database_user_id'], $user_old_rec, $user_new_rec); |
| | | } |
| | | } |
| | | if($this->dataRecord['database_ro_user_id']) { |
| | | $user_old_rec = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user_id` = ' . $app->functions->intval($this->dataRecord['database_ro_user_id'])); |
| | | if($user_old_rec) { |
| | | $user_new_rec = $user_old_rec; |
| | | $user_new_rec['server_id'] = $this->dataRecord['server_id']; |
| | | $app->db->datalogSave('web_database_user', 'UPDATE', 'database_user_id', $this->dataRecord['database_ro_user_id'], $user_old_rec, $user_new_rec); |
| | | } |
| | | } |
| | | } |
| | | |
| | | parent::onBeforeUpdate(); |
| | | } |
| | |
| | | // we need remote access rights for this server, so get it's ip address |
| | | $server_config = $app->getconf->get_server_config($tmp['server_id'], 'server'); |
| | | if($server_config['ip_address']!='') { |
| | | /* |
| | | if($this->dataRecord['remote_access'] != 'y') $this->dataRecord['remote_ips'] = ''; |
| | | $this->dataRecord['remote_access'] = 'y'; |
| | | if(preg_match('/(^|,)' . preg_quote($server_config['ip_address'], '/') . '(,|$)/', $this->dataRecord['remote_ips']) == false) { |
| | | $this->dataRecord['remote_ips'] .= ($this->dataRecord['remote_ips'] != '' ? ',' : '') . $server_config['ip_address']; |
| | | } |
| | | */ |
| | | |
| | | if($this->dataRecord['remote_access'] != 'y'){ |
| | | $this->dataRecord['remote_ips'] = $server_config['ip_address']; |
| | | $this->dataRecord['remote_access'] = 'y'; |
| | |
| | | } |
| | | } |
| | | |
| | | if ($app->tform->errorMessage == '') { |
| | | // force update of the used database user |
| | | if($this->dataRecord['database_user_id']) { |
| | | $user_old_rec = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user_id` = ' . $app->functions->intval($this->dataRecord['database_user_id'])); |
| | | if($user_old_rec) { |
| | | $user_new_rec = $user_old_rec; |
| | | $user_new_rec['server_id'] = $this->dataRecord['server_id']; |
| | | $app->db->datalogSave('web_database_user', 'UPDATE', 'database_user_id', $this->dataRecord['database_user_id'], $user_old_rec, $user_new_rec); |
| | | } |
| | | } |
| | | if($this->dataRecord['database_ro_user_id']) { |
| | | $user_old_rec = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user_id` = ' . $app->functions->intval($this->dataRecord['database_ro_user_id'])); |
| | | if($user_old_rec) { |
| | | $user_new_rec = $user_old_rec; |
| | | $user_new_rec['server_id'] = $this->dataRecord['server_id']; |
| | | $app->db->datalogSave('web_database_user', 'UPDATE', 'database_user_id', $this->dataRecord['database_ro_user_id'], $user_old_rec, $user_new_rec); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | parent::onBeforeInsert(); |
| | | } |
| | | |
| | | function onInsertSave($sql) { |
| | | global $app, $conf; |
| | | |
| | | $app->uses('sites_database_plugin'); |
| | | |
| | | //$app->sites_database_plugin->processDatabaseInsert($this); |
| | | |
| | | $app->db->query($sql); |
| | | if($app->db->errorMessage != '') die($app->db->errorMessage); |
| | |
| | | global $app; |
| | | if(!empty($sql) && !$app->tform->isReadonlyTab($app->tform->getCurrentTab(), $this->id)) { |
| | | |
| | | $app->uses('sites_database_plugin'); |
| | | //$app->sites_database_plugin->processDatabaseUpdate($this); |
| | | |
| | | $app->db->query($sql); |
| | | if($app->db->errorMessage != '') die($app->db->errorMessage); |
| | | } |
| | |
| | | function onAfterInsert() { |
| | | global $app, $conf; |
| | | |
| | | if($this->dataRecord["parent_domain_id"] > 0) { |
| | | $web = $app->db->queryOneRecord("SELECT * FROM web_domain WHERE domain_id = ".$app->functions->intval($this->dataRecord["parent_domain_id"])); |
| | | |
| | | //* The Database user shall be owned by the same group then the website |
| | | $sys_groupid = $app->functions->intval($web['sys_groupid']); |
| | | $backup_interval = $app->functions->intval($web['backup_interval']); |
| | | $backup_copies = $app->functions->intval($web['backup_copies']); |
| | | |
| | | $sql = "UPDATE web_database SET sys_groupid = '$sys_groupid', backup_interval = '$backup_interval', backup_copies = '$backup_copies' WHERE database_id = ".$this->id; |
| | | $app->db->query($sql); |
| | | } |
| | | $app->uses('sites_database_plugin'); |
| | | $app->sites_database_plugin->processDatabaseInsert($this); |
| | | } |
| | | |
| | | function onAfterUpdate() { |
| | | global $app, $conf; |
| | | |
| | | if($this->dataRecord["parent_domain_id"] > 0) { |
| | | $web = $app->db->queryOneRecord("SELECT * FROM web_domain WHERE domain_id = ".$app->functions->intval($this->dataRecord["parent_domain_id"])); |
| | | |
| | | //* The Database user shall be owned by the same group then the website |
| | | $sys_groupid = $app->functions->intval($web['sys_groupid']); |
| | | $backup_interval = $app->functions->intval($web['backup_interval']); |
| | | $backup_copies = $app->functions->intval($web['backup_copies']); |
| | | |
| | | $sql = "UPDATE web_database SET sys_groupid = '$sys_groupid', backup_interval = '$backup_interval', backup_copies = '$backup_copies' WHERE database_id = ".$this->id; |
| | | $app->db->query($sql); |
| | | } |
| | | |
| | | $app->uses('sites_database_plugin'); |
| | | $app->sites_database_plugin->processDatabaseUpdate($this); |
| | | } |
| | | |
| | | } |