function selectDB_save() { if (!isset($_POST["instance-id"])) { $_POST["instance-id"] = 0; } if (!is_numeric($_POST["instance-id"])) { $_POST["instance-id"] = 0; } $fADD[] = 'INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`,'; $fADD[] = '`References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`,'; $fADD[] = ' `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES '; $fADD[] = '("' . $_POST["host"] . '", "' . $_POST["database"] . '", "' . $_POST["user"] . '", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "N", "N", "Y", "Y")'; $sqladd = @implode(" ", $fADD); $sql_delete = "DELETE FROM `db` WHERE \n\t `Host`='{$_POST["host"]}' AND `Db`='{$_POST["database"]}' AND `User`='{$_POST["user"]}'"; $sql = $sqladd; if ($_POST["enable"] == 0) { $sql = $sql_delete; } writelogs("Instance: {$_POST["instance-id"]} user={$_POST["user"]} and host={$_POST["host"]}", __FUNCTION__, __FILE__, __LINE__); $q = new mysql(); if ($_POST["instance-id"] > 0) { $q = new mysql_multi($_POST["instance-id"]); } $q->QUERY_SQL($sql, "mysql"); if (!$q->ok) { writelogs("Instance: {$_POST["instance-id"]} {$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__); echo $q->mysql_error; return; } $q->FLUSH_PRIVILEGES(); }