crop db user if longer than 16 chars (mysql limit)

redray

2008-12-15 edcc94061616919f9f134d5e1e542d36e42830a6

 interface/web/sites/database_edit.php

@@ -251,8 +251,9 @@


      if ($app->tform->errorMessage == ''){

         /* restrict the names if there is no error */

         $this->dataRecord['database_name'] = $dbname_prefix . $this->dataRecord['database_name'];

         $this->dataRecord['database_user'] = $dbuser_prefix . $this->dataRecord['database_user'];

            /* 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);

      }



      parent::onBeforeUpdate();

@@ -268,8 +269,9 @@
      $dbuser_prefix = replacePrefix($global_config['dbuser_prefix'], $this->dataRecord);



      /* restrict the names */

      $this->dataRecord['database_name'] = $dbname_prefix . $this->dataRecord['database_name'];

      $this->dataRecord['database_user'] = $dbuser_prefix . $this->dataRecord['database_user'];

        /* 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);



      parent::onBeforeInsert();

   }