ftp user list filtering by domain uses like showing all sorts of results
Not sure if this was intentional but wouldn't make sense why, but the ftp user list, when selecting a "Website" in the combo performs a SQL "LIKE" query resulting in any parent domain with similar parent number to show up.
eg.
www.domain1.tld parent_id = 5 www.domain1.tld parent_id = 15
SELECT * FROM ftp_user WHERE ((sys_userid = 3 AND sys_perm_user like '%r%') OR (sys_groupid IN (3) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') and parent_domain_id like '%3.0.0.6%' LIMIT 0, 15
shows both domains even though I selected www.domain1.tld
I changed /usr/local/ispconfig/interface/web/sites/list/ftp_user.list.php
from
$liste["item"][] = array( 'field' => "parent_domain_id", 'datatype' => "VARCHAR", 'formtype' => "SELECT", 'op' => "LIKE", 'prefix' => "%", 'suffix' => "%",
to
$liste["item"][] = array( 'field' => "parent_domain_id", 'datatype' => "VARCHAR", 'formtype' => "SELECT", 'op' => "=", 'prefix' => "", 'suffix' => "",
and it performs as I expected.