From a247be5fc0fc941a51e336980ae4be2ccfb86d91 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Michal=20=C4=8Ciha=C5=99?= Date: Tue, 5 Dec 2006 10:11:16 +0000 Subject: Add IF NOT EXISTS to CREATE DATABASE query (RFE #1608372), reload navigation after creating database. --- server_privileges.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'server_privileges.php') diff --git a/server_privileges.php b/server_privileges.php index b4f8dbb270..a1613dde5d 100644 --- a/server_privileges.php +++ b/server_privileges.php @@ -836,9 +836,11 @@ if (!empty($adduser_submit) || !empty($change_copy)) { /* Create database for new user */ if (isset($createdb) && $createdb > 0) { if ($createdb == 1) { - $q = 'CREATE DATABASE ' . PMA_backquote(PMA_sqlAddslashes($username)) . ';'; + $q = 'CREATE DATABASE IF NOT EXISTS ' . PMA_backquote(PMA_sqlAddslashes($username)) . ';'; $sql_query .= $q; PMA_DBI_try_query($q) or PMA_mysqlDie(PMA_DBI_getError(), $sql_query); + $GLOBALS['reload'] = TRUE; + PMA_reloadNavigation(); $q = 'GRANT ALL PRIVILEGES ON ' . PMA_backquote(PMA_sqlAddslashes($username)) . '.* TO \'' . PMA_sqlAddslashes($username) . '\'@\'' . $hostname . '\';'; $sql_query .= $q; -- cgit v1.2.3