[patch] wrong databases are shown when selecting a server.
Hi,
We have a multiserver setup, server X has id 6 and server Y has id 26.
When we go to the list of databases, and select server X from the list, we also get the databases of server Y. This is because you match with a LIKE in the the database query.
This resolves that:
--- interface/web/sites/list/database.list.php.orig 2023-03-17 13:42:56.533206297 +0100
+++ interface/web/sites/list/database.list.php 2023-03-17 13:43:25.781272409 +0100
@@ -103,9 +103,9 @@
$liste["item"][] = array( 'field' => "server_id",
'datatype' => "INTEGER",
'formtype' => "SELECT",
- 'op' => "like",
- 'prefix' => "%",
- 'suffix' => "%",
+ 'op' => "=",
+ 'prefix' => "",
+ 'suffix' => "",
'datasource' => array ( 'type' => 'SQL',
'querystring' => 'SELECT a.server_id, a.server_name FROM server a, web_database b WHERE (a.server_id = b.server_id) AND ({AUTHSQL-B}) ORDER BY a.server_name',
'keyfield'=> 'server_id',