diff options
| author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2015-11-28 05:59:48 +0000 |
|---|---|---|
| committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2015-11-28 05:59:48 +0000 |
| commit | 6526c9b9900988a4fd72877653b4d4e0751909e1 (patch) | |
| tree | c6ba40841cc78079e709fa59239e903e0c3fd326 | |
| parent | 4eda45bfa6b44aaae6b19a5143fce9d830eb6f5a (diff) | |
| download | redmine-6526c9b9900988a4fd72877653b4d4e0751909e1.tar.gz redmine-6526c9b9900988a4fd72877653b4d4e0751909e1.zip | |
Only select actual users from the database in Redmine.pm (#21312).
Patch by Holger Just.
git-svn-id: http://svn.redmine.org/redmine/trunk@14892 e93f8b46-1217-0410-a6f0-8f06a7374b81
| -rw-r--r-- | extra/svn/Redmine.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/extra/svn/Redmine.pm b/extra/svn/Redmine.pm index 8b7fe158f..bac1cb2fc 100644 --- a/extra/svn/Redmine.pm +++ b/extra/svn/Redmine.pm @@ -244,6 +244,7 @@ sub RedmineDSN { WHERE users.login=? AND projects.identifier=? + AND users.type='User' AND users.status=1 AND ( roles.id IN (SELECT member_roles.role_id FROM members, member_roles WHERE members.user_id = users.id AND members.project_id = projects.id AND members.id = member_roles.member_id) |