Changeset 1707 for alternc/trunk/bureau/class/m_mysql.php

Timestamp:

07/05/06 11:54:39 (7 years ago)

Author:

anarcat

Message:

ne pas donner les permissions sur les bases deja existante. reste a tester. see #698

File:

• alternc/trunk/bureau/class/m_mysql.php (modified) (1 diff)

alternc/trunk/bureau/class/m_mysql.php

@@ -152 +152 @@
       $pa=addslashes($db->f("pass"));
     }
-    // Ok, database does not exist, quota is ok and dbname is compliant. Let's proceed
-    $db->query("INSERT INTO db (uid,login,pass,db,bck_mode) VALUES ('$cuid','$lo','$pa','$dbname',0);");
-    // give everything but GRANT on db.*
-    // we assume there's already a user
-    $db->query("GRANT ALL PRIVILEGES ON `".$dbname."`.* TO '".$lo."'@'$this->client'");
-    $db->query("CREATE DATABASE `$dbname`;");
-    return true;
+    if ($db->query("CREATE DATABASE $dbname;")) {
+      // Ok, database does not exist, quota is ok and dbname is compliant. Let's proceed
+      $db->query("INSERT INTO db (uid,login,pass,db,bck_mode) VALUES ('$cuid','$lo','$pa','$dbname',0);");
+      // give everything but GRANT on db.*
+      // we assume there's already a user
+      $db->query("GRANT ALL PRIVILEGES ON `".$dbname."`.* TO '".$lo."'@'$this->client'");
+      return true;
+    } else {
+      $err->raise("mysql",3);
+      return false;
+    }
   }