function onBeforeUpdate()
 {
     global $app, $conf, $interfaceConf;
     //* Site shell not be empty
     if ($this->dataRecord['parent_domain_id'] == 0) {
         $app->tform->errorMessage .= $app->tform->lng("database_site_error_empty") . '<br />';
     }
     //* Get the database name and database user prefix
     $app->uses('getconf,tools_sites');
     $global_config = $app->getconf->get_global_config('sites');
     $dbname_prefix = $app->tools_sites->replacePrefix($global_config['dbname_prefix'], $this->dataRecord);
     //* Prevent that the database name and charset is changed
     $old_record = $app->tform->getDataRecord($this->id);
     $dbname_prefix = $app->tools_sites->getPrefix($old_record['database_name_prefix'], $dbname_prefix);
     $this->dataRecord['database_name_prefix'] = $dbname_prefix;
     if ($old_record["database_name"] != $dbname_prefix . $this->dataRecord["database_name"]) {
         $app->tform->errorMessage .= $app->tform->wordbook["database_name_change_txt"] . '<br />';
     }
     if ($old_record["database_charset"] != $this->dataRecord["database_charset"]) {
         $app->tform->errorMessage .= $app->tform->wordbook["database_charset_change_txt"] . '<br />';
     }
     if (!$this->dataRecord['database_user_id']) {
         $app->tform->errorMessage .= $app->tform->wordbook["database_user_missing_txt"] . '<br />';
     }
     //* Database username and database name shall not be empty
     if ($this->dataRecord['database_name'] == '') {
         $app->tform->errorMessage .= $app->tform->wordbook["database_name_error_empty"] . '<br />';
     }
     //* Check if the server has been changed
     // We do this only for the admin or reseller users, as normal clients can not change the server ID anyway
     if ($_SESSION["s"]["user"]["typ"] == 'admin' || $app->auth->has_clients($_SESSION['s']['user']['userid'])) {
         if ($old_record["server_id"] != $this->dataRecord["server_id"]) {
             //* Add a error message and switch back to old server
             $app->tform->errorMessage .= $app->lng('The Server can not be changed.');
             $this->dataRecord["server_id"] = $rec['server_id'];
         }
     }
     unset($old_record);
     if (strlen($dbname_prefix . $this->dataRecord['database_name']) > 64) {
         $app->tform->errorMessage .= str_replace('{db}', $dbname_prefix . $this->dataRecord['database_name'], $app->tform->wordbook["database_name_error_len"]) . '<br />';
     }
     //* Check database name and user against blacklist
     $dbname_blacklist = array($conf['db_database'], 'mysql');
     if (in_array($dbname_prefix . $this->dataRecord['database_name'], $dbname_blacklist)) {
         $app->tform->errorMessage .= $app->lng('Database name not allowed.') . '<br />';
     }
     if ($app->tform->errorMessage == '') {
         /* restrict the names if there is no error */
         /* crop user and db names if they are too long -> mysql: user: 16 chars / db: 64 chars */
         $this->dataRecord['database_name'] = substr($dbname_prefix . $this->dataRecord['database_name'], 0, 64);
     }
     //* Check for duplicates
     $tmp = $app->db->queryOneRecord("SELECT count(database_id) as dbnum FROM web_database WHERE database_name = '" . $this->dataRecord['database_name'] . "' AND server_id = '" . $this->dataRecord["server_id"] . "' AND database_id != '" . $this->id . "'");
     if ($tmp['dbnum'] > 0) {
         $app->tform->errorMessage .= $app->lng('database_name_error_unique') . '<br />';
     }
     // get the web server ip (parent domain)
     $tmp = $app->db->queryOneRecord("SELECT server_id FROM web_domain WHERE domain_id = '" . $this->dataRecord['parent_domain_id'] . "'");
     if ($tmp['server_id'] && $tmp['server_id'] != $this->dataRecord['server_id']) {
         // 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'];
             }
         }
     }
     parent::onBeforeUpdate();
 }
 function onBeforeUpdate()
 {
     global $app, $conf, $interfaceConf;
     /*
      * we can not change the username and the dir, so get the "old" - data from the db
      * and set it
      */
     $data = $app->db->queryOneRecord("SELECT * FROM webdav_user WHERE webdav_user_id = " . intval($this->id));
     $this->dataRecord["username"] = $data['username'];
     $this->dataRecord["dir"] = $data['dir'];
     $passwordOld = $data['password'];
     /*
      * We shall not save the pwd in plaintext, so we store it as the hash, the apache-moule
      * needs (only if the pwd is changed)
      */
     if (isset($this->dataRecord["password"]) && $this->dataRecord["password"] != '' && $this->dataRecord["password"] != $passwordOld) {
         $hash = md5($this->dataRecord["username"] . ':' . $this->dataRecord["dir"] . ':' . $this->dataRecord["password"]);
         $this->dataRecord["password"] = $hash;
     }
     parent::onBeforeUpdate();
 }
 function onBeforeUpdate()
 {
     global $app, $conf, $interfaceConf;
     /*
      * If the names should be restricted -> do it!
      */
     //* Get the database name and database user prefix
     $app->uses('getconf');
     $global_config = $app->getconf->get_global_config('sites');
     $dbname_prefix = replacePrefix($global_config['dbname_prefix'], $this->dataRecord);
     $dbuser_prefix = replacePrefix($global_config['dbuser_prefix'], $this->dataRecord);
     //* Prevent that the database name and charset is changed
     $old_record = $app->tform->getDataRecord($this->id);
     if ($old_record["database_name"] != $dbname_prefix . $this->dataRecord["database_name"]) {
         $app->tform->errorMessage .= $app->tform->wordbook["database_name_change_txt"] . '<br />';
     }
     if ($old_record["database_charset"] != $this->dataRecord["database_charset"]) {
         $app->tform->errorMessage .= $app->tform->wordbook["database_charset_change_txt"] . '<br />';
     }
     //* Database username and database name shall not be empty
     if ($this->dataRecord['database_name'] == '') {
         $app->tform->errorMessage .= $app->tform->wordbook["database_name_error_empty"] . '<br />';
     }
     if ($this->dataRecord['database_user'] == '') {
         $app->tform->errorMessage .= $app->tform->wordbook["database_user_error_empty"] . '<br />';
     }
     //* Check if the server has been changed
     // We do this only for the admin or reseller users, as normal clients can not change the server ID anyway
     if ($_SESSION["s"]["user"]["typ"] == 'admin' || $app->auth->has_clients($_SESSION['s']['user']['userid'])) {
         if ($old_record["server_id"] != $this->dataRecord["server_id"]) {
             //* Add a error message and switch back to old server
             $app->tform->errorMessage .= $app->lng('The Server can not be changed.');
             $this->dataRecord["server_id"] = $rec['server_id'];
         }
     }
     unset($old_record);
     if (strlen($dbname_prefix . $this->dataRecord['database_name']) > 64) {
         $app->tform->errorMessage .= str_replace('{db}', $dbname_prefix . $this->dataRecord['database_name'], $app->tform->wordbook["database_name_error_len"]) . '<br />';
     }
     if (strlen($dbuser_prefix . $this->dataRecord['database_user']) > 16) {
         $app->tform->errorMessage .= str_replace('{user}', $dbuser_prefix . $this->dataRecord['database_user'], $app->tform->wordbook["database_user_error_len"]) . '<br />';
     }
     //* Check database name and user against blacklist
     $dbname_blacklist = array($conf['db_database'], 'mysql');
     if (in_array($dbname_prefix . $this->dataRecord['database_name'], $dbname_blacklist)) {
         $app->tform->errorMessage .= $app->lng('Database name not allowed.') . '<br />';
     }
     $dbuser_blacklist = array($conf['db_user'], 'mysql', 'root');
     if (in_array($dbname_prefix . $this->dataRecord['database_user'], $dbname_blacklist)) {
         $app->tform->errorMessage .= $app->lng('Database user not allowed.') . '<br />';
     }
     if ($app->tform->errorMessage == '') {
         /* restrict the names if there is no error */
         /* crop user and db names if they are too long -> mysql: user: 16 chars / db: 64 chars */
         $this->dataRecord['database_name'] = substr($dbname_prefix . $this->dataRecord['database_name'], 0, 64);
         $this->dataRecord['database_user'] = substr($dbuser_prefix . $this->dataRecord['database_user'], 0, 16);
     }
     //* Check for duplicates
     $tmp = $app->db->queryOneRecord("SELECT count(database_id) as dbnum FROM web_database WHERE database_name = '" . $this->dataRecord['database_name'] . "' AND server_id = '" . $this->dataRecord["server_id"] . "' AND database_id != '" . $this->id . "'");
     if ($tmp['dbnum'] > 0) {
         $app->tform->errorMessage .= $app->lng('database_name_error_unique') . '<br />';
     }
     parent::onBeforeUpdate();
 }
 function onBeforeUpdate()
 {
     global $app, $conf, $interfaceConf;
     /*
      * we can not change the username and the dir, so get the "old" - data from the db
      * and set it
      */
     $data = $app->db->queryOneRecord("SELECT * FROM webdav_user WHERE webdav_user_id = " . $app->functions->intval($this->id));
     $this->dataRecord["username"] = $data['username'];
     $this->dataRecord["dir"] = $data['dir'];
     $this->dataRecord['username_prefix'] = $data['username_prefix'];
     $this->dataRecord['passwordOld'] = $data['password'];
     parent::onBeforeUpdate();
 }
 function onBeforeUpdate()
 {
     global $app, $conf, $interfaceConf;
     //* Get the database user prefix
     $app->uses('getconf,tools_sites');
     $global_config = $app->getconf->get_global_config('sites');
     $dbuser_prefix = $app->tools_sites->replacePrefix($global_config['dbuser_prefix'], $this->dataRecord);
     $this->oldDataRecord = $app->db->queryOneRecord("SELECT * FROM web_database_user WHERE database_user_id = '" . $this->id . "'");
     $dbuser_prefix = $app->tools_sites->getPrefix($this->oldDataRecord['database_user_prefix'], $dbuser_prefix);
     $this->dataRecord['database_user_prefix'] = $dbuser_prefix;
     //* Database username shall not be empty
     if ($this->dataRecord['database_user'] == '') {
         $app->tform->errorMessage .= $app->tform->wordbook["database_user_error_empty"] . '<br />';
     }
     if (strlen($dbuser_prefix . $this->dataRecord['database_user']) > 16) {
         $app->tform->errorMessage .= str_replace('{user}', $dbuser_prefix . $this->dataRecord['database_user'], $app->tform->wordbook["database_user_error_len"]) . '<br />';
     }
     //* Check database user against blacklist
     $dbuser_blacklist = array($conf['db_user'], 'mysql', 'root');
     if (in_array($dbuser_prefix . $this->dataRecord['database_user'], $dbuser_blacklist)) {
         $app->tform->errorMessage .= $app->lng('Database user not allowed.') . '<br />';
     }
     if ($app->tform->errorMessage == '') {
         /* restrict the names if there is no error */
         /* crop user and db names if they are too long -> mysql: user: 16 chars / db: 64 chars */
         $this->dataRecord['database_user'] = substr($dbuser_prefix . $this->dataRecord['database_user'], 0, 16);
     }
     $this->dataRecord['server_id'] = 0;
     // we need this on all servers
     parent::onBeforeUpdate();
 }